Google Sheets as an data source
If you already have your prospect data in Google Sheets, you most likely understand how flexible and powerful this tool can be.
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:
Click the Add button in ‘Integrations’ of your image template
- Select Google Sheets and then New Sheet
- 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.
Click to select the Google Sheet data source for your image click 'Copy Link' to.... copy the image link :)
Now we have the image URL Sheet formula copied, we can simply paste direct into the Sheet.
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.
Did this answer your question?