How To Use Google Sheets Mail Merge
You can set up a mail merge using google drive and an add on called autocrat.
How to use google sheets mail merge. Here s a walkthrough guide on how to send a mail merge with google sheets in gmass. A dialog box will appear and tell you that the script requires authorization. Run your script to send emails. You ll need to head over here and make a copy of the gmail google sheets mail merge spreadsheet template. Instead of wasting time creating a google apps script to build a mail merge template you can use gmass to send emails in seconds.
Autocrat makes it easy to merge data from google sheets into google docs or into a pdf. Step 1 formatting your spreadsheet. Create an apps script to read data from your sheet perform a mail merge and send out emails. A mail merge is an extremely useful tool for personalizing forms or emails for many individuals at once. Alternatively you can download the right inbox extension that will allow you to do a mail merge within gmail.
In the copied spreadsheet click on custom menu item mail merge send emails. Yellowwebmonkey has the solution for you.