Google Sheets as a data source

If you already have your prospect data in Google Sheets, you most likely understand how flexible and powerful this tool can be.

From a Google Sheet you can leverage powerful APIs to grab further data, you can Zap integrations, and you can mass email out, with tools like YAMM or GMass << check out our step by step articles.

We full embrace the power of Sheets and have enabled our image templates to pull data directly from a Sheet, right into your images, to take personalisation to a totally new level.

Once you’ve created your personalised image template, you can add the Google Sheet, which contains all your prospects, as a data source for the image:

1. Click the Add button in ‘Integrations’ of your image template
2. Select Google Sheets and then New Sheet
3. Paste in the URL of your Sheet

Your image is now connected to your Sheet, ready to use as a data source, within your personalised image.

We now need to update the Google Sheet with the image being used.

1. Click to select the Google Sheet Integration for your image
2. ClickGet Image Code' to.... copy the image link :)

Now we have the image URL copied, we can update our Sheet.

First create a new column for the Image URL, then paste the image URL in the first field.  Then replace the actual row number with a formula, so we can then copy to each row.  eg:

="https://img.hyperise.io/dynamic-images/template-159/sheet-11/row-"&row()&".png";

We can see in this example below the formula used, automatically updating for each row.

We hope this helps, but please let us know if you have any questions or need further support.

For further reading, check out our step by step articles on how to automate email campaigns using Gmail, with tools like YAMM or GMass.