Posts

Showing posts from October, 2020

How to Search Emails in Gmail by Specific Time

Image
Gmail supports a plethora of search operators to help you instantly find that elusive email message buried in your mailbox. You have  size search  - like larger_than:5mb  - to find the big messages in your account. File search - like has:attachment filename:doc - will locate email messages that contain specific file attachments. This graphic illustrates all the known Gmail search operators that work both on Gmail website and mobile. Search by Date in Gmail Date search in Gmail helps you locate emails sent or received during a specific period. Here are some examples: newer_than:7d from:me - Emails sent in the last 7 days after:2020/10/15 before:2020/10/20 from:uber - Emails from Uber received between October 15 and October 20. newer_than:60d older_than:30d - All emails received in the previous 30-day range. The date in the Gmail search query is specified in the YYYY/MM/DD format. Search Emails by Specific Time in Gmail Gmail supports an undocumented t...

How to Change the Reply-to Address in Mail Merge

Image
When you send an email campaign through Gmail, you’ve an option to specify a different reply-to email address for your emails. When the email recipient hits the “Reply” or “Reply All” button, the To field in their email reply will be automatically populated with the email address that you’ve specified as the Reply-to email at the time of sending. You can even specify more than one email addresses in the reply-to field, separated by commas, and they will all show up in the To field of the reply field. For instance, you could send emails from your own email address but the replies would be received in your email inbox as well as the support team. To get started, open your Google sheet, go to the add-ons menu and choose Mail merge with attachments . Next click on the Configure menu to open the Mail Merge sidebar. Here go the Reply-to address file and type an email address. If you wish to receive replies on multiple email addresses, type them all here separated by commas. Now when...

Download Gmail Messages as EML Files in Google Drive

This Google Script will help you download your email messages from Gmail to your Google Drive in the EML format. What is the EML Format The .eml file format is popular for transferring emails from one email program to another since it complies with the RFC 822 standard and thus can be natively opened inside Apple Mail and Microsoft Outlook. You can even open EML files inside Google Chrome by dragging the file from your desktop onto a new browser table. EML files contains the email content (email body, header and encoded images and attachments) as plain text in MIME format . Download Gmail message as EML Files Inside Gmail, open any email thread, go to the 3-dot menu and choose “Download Message” from the menu. It will turn your current email message into an eml file and save it your desktop. However, if you wish to automate the process and download multiple emails as eml files in your Google Drive, Apps Script can help. const downloadEmails = ( ) => { const se...

Google Drive Monitor - Get Email Alerts When Files are Deleted in your Drive

Image
When you delete a file in Google Drive, it moves to the trash folder and stays there indefinitely until you manually empty the bin. That is how it has always been but, sometime this month, Google made one important change to how the trash bin works. Under the new policy, files that have been in Google Drive’s trash bin for more than 30-days are automatically deleted. This automatic cleanup does help reclaim space but if you happen to accidentally delete some important files or folders from your Google Drive, there’s no way to restore them from the trash after the 30-day window. Monitor Google Drive Files If you are like me who is terrified at the prospect of forever losing important files that were deleted by mistake, Google Drive Watch can help. Google Drive Watch is an open-source Google Script that automatically monitors your Google Drive and sends daily email notifications with a detailed list of files that were deleted the previous day. Here’s a sample email notification s...

How to Send Emails from a Different Address (Alias) with Gmail

Image
Say you have two email accounts - personal@gmail.com and work@company.com - the former is your personal email address while the latter is your work (corporate) email address. You are logged into your personal Gmail account but would like the mail merge to go out from your work account. Consider another scenario where the personal secretary needs to sends out emails on behalf of her boss. So she runs the merge while staying logged into her own Google account but the recipients will see her boss’s email as the sender. Both these scenarios can be easily handled in Mail Merge and Document Studio by setting up aliases in Gmail. You can even send emails from your Outlook, Yahoo or Zoho email addresses through aliases in Gmail. Students and teach can send emails from their @school.edu email address while logged into their personal email accounts. How to Setup Email Aliases in Gmail Open gmail.com on your desktop computer, go to Settings, click the Accounts tab and, under the “Sen...

How to Request Additional Quota for your YouTube API Project

Image
A UK based organization recently organized an online conference with 300+ participants and each of the attendees were asked to upload a video to a common YouTube channel post the event. The organizers created a YouTube uploader to make it easy for attendees to submit videos but soon ran into the quota issue with YouTube. Let me explain. The YouTube API website says that 1600 quota units are required to upload a single video to the YouTube website through the videos.insert method of the YouTube API. Thus, for instance, if you are expecting users to upload 100 videos to your YouTube channel in a single day, your Google Cloud project should have a quota of at least 1600 * 100 = 160,000 units. The quota limits reset every 24 hours. New Google Cloud projects have lower quota and you’ll have to request YouTube to increase your quota if you are expecting higher number of videos. Increase your YouTube API Quota Here’s step by step guide that will help you get your YouTube video uplo...

How to Password Protect Google Documents and PDF files in Google Drive

Image
Introducing PDF toolbox , a new Google Drive addon that lets you password protect PDF files and Google Documents. The app can also help you unlock PDF files that are already protected with a password in your Google Drive. Watch the video tutorial to get started. Password Protect PDF Files To get started, install the PDF toolbox add-on and grant the necessary authorization. The app requires access to the file that you would like to encrypt (or decrypt) and you also have an an option to send the encrypted file as an email attachment to another user. Next, select any PDF file or Google document in your Google Drive and expand the “Encrypt PDF” section. Enter the output file name (it will also be saved in your Google Drive), provide a password and specify whether the encrypted file should allow printing and comments. Click the Encrypt button to create a new PDF file that would require a password to open. The app can secure PDF files as well as Google documents, spreadsheet an...

Reclaim Disk Space - How to Find the Biggest Files in your Google Drive

Image
Your Google account storage is shared between Gmail, Google Drive, and Google Photos. What do you do when your Google account is running out of storage space? You either buy more storage from Google or the inexpensive option is that you spend some time spring-cleaning your account and delete the emails and files that could be hogging up the storage space. Recover Spaces in Google Drive First things first. Go to google.com/settings/storage and click on the “View Details” link to know the total available disk space and see exactly how much storage space is used by the email and drive service. Gmail offers the size search operator so you can easily find emails that have large attachments and delete them to reclaim space. For instance, a query like size:5MB older_than:1y will show all emails older than a year and that take up more than 5 MB of space in your Google account. See more Gmail search operators Unlike Gmail, there’s no easy way to find large files by size in Google Drive...

How to Make your Documents Read-only in Google Drive

Image
The files in your Google Drive are private by default and only the owner has initial permissions to view, edit or delete their files. If you choose to share a file with other people, you can decide whether others have read-only access to your files or if they are allowed to edit and comment on your files. You can always remove external collaborators from your documents to prevent them from editing your files but how do you prevent yourself (the owner) from accidentally editing your own files in Google Drive? How to Prevent Document Edits in Google Drive Google Drive now has a new Locking API to help developers easily add content restrictions on documents, spreadsheets, presentations, PDF and any other file in Google Drive. When you lock a file, no one (including the owner) can make edits to the file, the file title cannot be changed and also lose the option of commenting inside files. Google Drive doesn’t have a simple button (yet) for locking files so here’s a little Google...