Use Google Mail Merge with MailChimp templates

Google Mail Merge with MailChimp templates.md

Go to MailChimp

1. Replicate template in MailChimp

   MailChimp templates

2. Edit template for the campaign

   You should make it complete, not as a template. All texts, pics should be final.

   You can use tags from the Mail Merge Sheet like {{First Name}} or {{Email Address}} and it will be populated for each recipient.

   Promo Simple

   Basic template, just drag & drop content, edit texts, etc.

   Promo Hero

   This is more tricky one. You have a special header that has a backround image, an overlay and you can also enter text. The MailChimp editor does not handle this, you should do it by code.

   1. Click the header.

   2. Scary colorful text appears on the right.

   3. Egész cucc:

      • background-image: change the URL in the ()
      • background-position: position the background in the box. First is the horizontal (that can be top, center, bottom), second the vertical (left, center, right)

      Do not edit red text outside the lines!

   4. Overlay: sets the overlay color and opacity. Grab a color picker, like this and choose a color. Copy the RGB value (something like rgb(123,123,123)), but only the three numbers (123,123,123)! Paste it in, but leave the 4th number (0.5)! It will look like this:

      background-color: rgba(123,123,123,0.5);
      

      The last (4th) number is the opacity. 0 is transparent, 1 is opaque. Set something in between.

   5. Tartalom: here you set the spacing the text in the header box should have. First is vertical, second horizontal. Play with the numbers and you will see.

   6. Text fields: the following three are predefined text fields. You can copy/paste them to make more. Settings are:

      • color: text color (rgb, hex color, or plain color name)
      • text-align: (left, right, center, justify)
      • font-family: ('Playfair Display', serif) or delete property

   7. Texts: the black texts are the actual lines that appear on the header. Edit or delete them as you like.

   IMPORTANT:
   NEVER EDIT GREEN OR BLUE TEXT. RED TEXT CAN BE EDITED BETWEEN THE LINES (/*--------*/).

   Otherwise this template can be edited the same way as the Simple.

3. Save and Exit template

4. Export template

On your computer

4. Open file and copy all content

Go to Google Sheets

8. Go to Mail Merge Google Sheet

   1. Choose extensions -> Mail Merge -> Configure...
   2. Edit as you wish:
      • sender name
      • campaign name
   3. Click Continue

9. Choose Wrtie your own template...

10. Edit subject

11. Paste code

12. Send test

13. Run