Google Sheets
Connect Google Sheets to Gan.AI through Make to import prospect data, generate personalized videos, and send video results back into Sheets automatically.
How to import data from your Google Sheets through Make to create video copies in Gan.AI?
Log in to your Gan.AI account, select the required personalised project
Go to Project settings -> Integrations -> Make and turn on the integration
Log in to your Make account and click on 'Create a new scenario'
Name your scenario based on the automation you are looking to create
Setting up the trigger
Search for Google Sheets
Choose the event that would trigger the scenario
Connect your Gmail account to Make
Under Search method, select 'Search from all'
For 'Google Sheets', copy the spreadsheet ID from the like (as shown) and paste it in the Make platform
Select the sheet that you want to import the data from under the 'Sheet name' dropdown
Select the range of rows that contains the prospects' data that you want to import
Click on 'Ok' to save your data
Setting up the action
Click on 'Add another module'
Select 'HTTP' in the dropdown
Under action, select 'Make a request'
Under 'URL', paste the following link: https://api.gan.ai/create_video/bulk?project_id=
Copy your 'Project ID' and paste it in the URL input
Under the 'Method' dropdown, select the method as 'POST'
Click on 'Add a header' and under 'Name', write 'Authorization'
Under 'Value', write 'Bearer' and after a space, copy the Access token and paste it in the input box
Set the Body type as Raw
Set the Content type as JSON
In the 'Request Content' input box, enter this:
[ { "Variable 1" : "" "Variable 2" : "" "Variable 3" : "" } ]
Here, instead of 'Variable 1', add the names of all the project variables and map them to the corresponding values in your Sheet
Click on 'Run once' to check if the scenario is working
Once it's successful, click on 'Save'
How to export video copies from Gan.AI to your Google Sheets through Make?
Log in to your Gan.AI account, select the required personalised project
Go to Project settings -> Integrations -> Make and turn on the integration
Log in to your Make account and click on 'Create a new scenario'
Name your scenario based on the automation you are looking to create
In the Apps section, search for 'Webhooks' and select 'Custom webhooks'
Name your webhook and click on 'Save'
Click on 'Copy address to clipboard' and paste it in the Gan.AI platform in the webhook URL input
Once it shows "Successfully determined" on the Make platform, click on 'Ok'
Click on 'Add another module' and search for Google Sheets
Choose the action you want to happen in your Google Sheets
Now copy the Spreadsheet ID, and paste it in the Input box
Now select the sheet and map the values that you want to send to the columns in the spreadsheet
Now click on 'Ok' to save these values.
In the Gan.AI platform, click on 'Save & close' to save the project's settings.
Integrating Google Sheets with Gan.AI creates a smooth automation loop—your sheet sends data for video creation, and Gan.AI sends the personalized video links right back. It’s fast, scalable, and perfect for managing high-volume personalization without manual work.
Last updated