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