Quantcast

Mailmerge on Google Sheets

Awesome tool for doing emails out to multiple people on Google Sheets :)

http://www.labnol.org/internet/personalized-mail-merge-in-gmail/20981/

1. Go to the Add-ons menu in the sheet, select Mail Merge with Attachments and then select the Create Merge Template

2. Include one or more variable fields in the email  message using the {{field name}} notation

(http://www.labnol.org/internet/personalized-mail-merge-in-gmail/20981/)

To use Google Analytics to track open rates see this:

https://docs.google.com/spreadsheets/d/1x8lF48liTROp0UKRdoaksGEPpltPIE04eUpv9sDr6s0/copy

Track clicks

http://www.labnol.org/internet/google-analytics-track-email-clicks/2476/

Tagged with:
Posted in Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>