How to Schedule Emails for Sending Later with Gmail Mail Merge

Published in: Mail Merge for Gmail

The Mail Merge add-on allows you to schedule email messages so that they can be sent later at your preferred date and time automatically.

When you create a new Mail merge template, it includes a column called “Scheduled Date”. You can put the date and time in this column and the email for recipients in that row will go out +/- 30 minutes of your scheduled time.

Following are some commonly asked question around scheduling in Mail merge for Gmail.

Q: What is the correct format for specifying the scheduled date and time in the mail merge sheet?

The format depends on your Spreadsheet locale and thus may be different for different users. To know the exact date time format for your sheet, go to an empty cell in the sheet and type the formula =NOW() and press Enter. It will show you the format for your sheet.

Q: My emails are not getting sent as per schedule?

The email scheduler is not accurate by the minute due to a limitation in the Google API. Email messages can be sent anywhere between +/- 30 minutes of the scheduled time.

For instance, if you set the scheduled date as 2/20/2015 04:30, the email can go out anytime between 4 to 5 AM.

Q: I’ve scheduled a bunch of emails. How do I unschedule them?

There are two ways to unschedule emails. You can either clear the date in the corresponding Scheduled Date column of the spreadsheet or you can simply delete the row from the spreadsheet.

Q: My scheduled emails are not getting sent at all?

It is likely that you email quota for the day is over. Else, the scheduler has stopped for some technical reason. You can go to the Add-ons - Mail Merge with Attachments - Configure menu and run Mail Merge again to resume the scheduler.

Q: Can I send recurring email with Mail Merge?

Please see this workaround for sending recurring emails with Mail merge.

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Mail Merge for Gmail

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube