Overview

In this tutorial, we will show you how to generate personalized videos from an existing video template via Google Sheets + Zapier.

Here’s an overview of what we will cover:

1. Set up Google Sheet
2. Set up Zap #1: generate video when contact is added
3. Set up Zap #2: update sheet when video is completed
4. Test generating videos for multiple contacts

By the end of this tutorial, you will be able to:

1. Add multiple contacts to a Google Sheet to generate personalized videos for them simultaneously
2. Receive the generated videos back into the same Google Sheet

Prerequisite

1. Please make sure you have created a personalized video template before proceeding (see Create personalized video template )
2. A Google Sheets account
3. A Zapier account

Set up Google Sheet

The next step is to set up a Google Sheet. The Google Sheet will serve two purposes:

1. Import contacts to trigger video generation
2. Store video data once videos are done generating

👀

Notes about the sample Google Sheet

The GREEN columns are your input. Feel free to add additional variables/columns as needed.

The YELLOW columns will be updated by HeyGen + Zapier.

You can get started with this sample Google Sheet here.

Watch the video tutorial here: https://www.loom.com/share/4d0fb731c3cc4049960b8e410983b4c3

Set up Zap #1: generate video when contact is added

When a contact is added to the sheet, we want to trigger an automatic request to HeyGen to generate a personalized video for the contact.

We will pass along any variable from the Google Sheet to HeyGen by using this notation in Zapier: text.variable_name.content

Examples:

• {{first_name}} ⇒ text.first_name.content
• {{company_name}} ⇒ text.company_name.content

⚠️

Make sure to double check your video template to make sure you are using the same variable name between the template and Zapier

Watch the video tutorial here: https://www.loom.com/share/3e0fc674c72e466b8ab1e712b3302a37

Set up Zap #2: update sheet when video is completed

When the personalized video is done generating, we want to automatically push the video data back to the Google Sheet to store them.

We will store the video data in the following fields:

• HeyGen Video Share Page URL
• HeyGen Video Download URL
• HeyGen GIF Download URL

🧑‍💻

Make sure to test the workflow end-to-end after you finish setting up this Zap.

Watch the video tutorial here: https://www.loom.com/share/9408c40bfe5d428db18f71dfd8312e99

Test generating videos for multiple contacts

So far, we’ve only tested adding one contact at a time. However, for many users, they will likely have a list of contacts they’d like to create personalized videos for in bulk. Therefore, let’s also test out adding multiple contacts at the same time.

There is no additional configuration needed for this step. This is mainly just a testing step to ensure things are working as expected.

Watch the video tutorial here: https://www.loom.com/share/bbf5671caf59454089cf966715451eb2