Google Sheets: Email Merge To Send Custom Attachments With a formula
Use vlookup to send quasi-custom attachments using mail merge.
If there's a column value you can use to find the right attachment from a list, this formula will help making mail merge emails even more customized and helpful.
More on vlookup: https://docs.google.com/presentation/...
More on email merge: https://docs.google.com/presentation/...
0:00 Intro
0:36 Have Docs/file links in sheet
0:50 Share docs/files
2:10 vlookup formula
5:48 Add {{Attachment}} to the draft
#googlesheets #googleappscript #gmail