Skip to content

⚡️ Google Script for Mail Merge using Spreadsheet and Gmail

License

Notifications You must be signed in to change notification settings

patrickacollier/gmail-mail-merge

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 

Repository files navigation

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

About

⚡️ Google Script for Mail Merge using Spreadsheet and Gmail

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 100.0%