How to Schedule Emails for Sending Later with Gmail Mail Merge

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.

Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

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.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory


Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.