June 10, 2014

Send personalised email to 1,000 people right from Google Drive

Those ingenious folk at MailChimp are forever coming up with brand new ways to enhance email marketing. With Merge, they’ve done it again; this time in collaboration with Google. You can now send emails to up to 1,000 recipients straight from a Google Document – you don’t even need a MailChimp account.

As a ticketscript user, you’ll already be collecting customer email addresses that you have exclusive access to and this is the perfect tool to help you make use of them.

What can you do with Merge?

1. Design and compose lovely documents, then email them directly to up to 1,000 email addresses.
2. View statistics about open rates and click rates, to see which ones work best.


If you don’t already have one, to use Merge, you’ll need to set up a Google account so that you can create documents in Google Drive. This is all free of course, and takes no time at all to set up.

Once you’re logged into your Google Drive account, you’ll need to create two things:


This is where you’ll keep all the names and email addresses you’ve collected and feed them into your email in order to personalise the content. So wherever your data is at the moment, copy it over to a new Google Sheet – think of it as your very own customer database.


You’ll use Documents to create the content for sending to your contacts and to configure Merge. To install Merge, after creating a document, go to the “Add-ons” menu, click “Get add-ons”, search for Merge and add it to your Google Drive. The on-screen tips should make it easy enough from here.

So that’s how to get started with Merge. MailChimp have further details and a picture-guide here on their blog.

Give it a try – make use of that hard-earned customer info by adding some sparkle to your email marketing.

– – – – –

By Dominick Soar