⚡️ 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

Template

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

Email Outcome

To: [email protected]
Body:
Hello Abc Xyz...

License

MIT