Google Sheets with merge mails to send dynamic emails from gmail for free with attachments (as links)

1. Add all your attachments to your google drive folder
2. Make your drive folder public by right clicking on the folder and change the share option to

Right click on folder and select share option

Get this addon installed in google sheets that will be used to mail merge

Get the add-on by clicking on the get addons menu bar option in google sheets

Add your merge fields like Name, Email addresses and links that we created as follows

Required fields populated here

— — — — — — — — — — -PRO tip — — — — — — — — —

Use the following extension to create mapping from file name to file URL, and then use it to map in your sheet

Mail Merge with attachment

Follow this tutorial to create mappings from your file name to url

How to Mail Merge with Gmail and Google Sheets — YouTube

Select List files in Google Drive folder to get mapping from File name to file Url

Then configure your mail merge addon that gives 2000 mails per day

Select the apt Email field

Configure mail body and add attachment columns as merge fields in the body and send your mails with dynamic attachments as urls