Send personal emails from Google Sheets with Gmail (mail merge)

Short answer: Use a free Google Apps Script that sends each row of your sheet its own email from your Gmail, with names and details filled in, and marks who has been sent one. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make a Recipients tab; Make a Settings tab; Paste the script; Send a test; Send to everyone.

How to set it up

1. Make a Recipients tab. Add a tab called Recipients with headings in row 1. You need one column called Email and one called Status; add any others you want to use, such as First name or Company.
2. Make a Settings tab. Add a tab called Settings. Type the subject in B1 and the message in B2. Put a column name in curly brackets, like {First name}, wherever you want that row's value.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Mail merge menu appears.
4. Send a test. Choose Mail merge, then Send a test to me. You get the email for row 2, so you can check it before anyone else does.
5. Send to everyone. Choose Send to everyone not yet sent. Each row with an empty Status gets its email, and its Status becomes Sent and the date. Rows with anything in Status are skipped, so running it again only sends to new rows.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• Gmail limits how many emails a script can send each day: about 100 on a free Gmail account and 1,500 on Google Workspace. The script stops at the limit and tells you; run it again the next day for the rest.
• Emails are plain text and come from your own address, so replies go to your inbox.
• Only email people who have asked to hear from you.

Questions

What does this script do?

It is a free Google Apps Script that sends each row of your sheet its own email from your Gmail, with names and details filled in, and marks who has been sent one.

How do I set it up?

In 5 steps: 1. Make a Recipients tab; 2. Make a Settings tab; 3. Paste the script; 4. Send a test; 5. Send to everyone. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.