⚡️ Mail Merge using Spreadsheet and Gmail

This script will use the most recent draft in Gmail as a template.

Features

• Handles duplicate entries (by email address)
• Works with HTML and plain text emails

Usage

1. Open Spreadsheet
2. Go to Tools > Script editor...
3. Paste contents of mailmerge.gs there
4. Save it
5. After saving script, you will notice a new menu Mail Merege in Spreadsheet
6. From Spreadsheet, Go to Mail Merge > Send mail

Example Spreadsheet

First name	Last name	Email
Abc	Xyz	abc@def.com
Def	Pqr	def@pqr.com

Template

To: Email (here, put the title of email column)
Body:
Hello {{First name}} {{Last name}}...

Email Outcome

To: abc@def.com
Body:
Hello Abc Xyz...

License

MIT