This google app script will use the most recent draft in Gmail as a template.
- Handles duplicate entries (by email)
- Works on HTML and plain text emails
- Open google spreadsheet doc containing the data.
- Go to
Tools -> Script editor - Paste contents of
bulkmail.gsthere - Save it
- After saving script, you will notice a new menu Bulk Mail (At the top) in Spreadsheet.
- From Spreadsheet, Go to
Bulk Mail -> Send mail
#sheet1
| Name | SendOrNot | |
|---|---|---|
| abc@gmail.com | Dhanush | SENT_ALREADY |
| xyz@gmail.com | Bharadwaj |
here you can add as many fields as you want.
#sheet2
| subject | link1 | link2 |
|---|---|---|
| xyz | https://... | (https://...) |
here just one field is enough to send 'bulkMails' as you want.
To: Email (here, put the title of email column)
Subject: SOmething common to everyone.
Body:
Hi {{name}} some content will be entered
........................................
...........
{{link1}}
..........
{{link2}}
regards
abc,
cdef
<Body>
For every field you added in spreadsheet you have to add the same title name in “ {{ }} “
To: abc@def.com
Subject : Common subject
Body:
Hello Abc Xyz
PQR
<Body>