Google Sheets
This guide covers how to integrate Google with Gan.AI using Make to create personalized videos
Last updated
This guide covers how to integrate Google with Gan.AI using Make to create personalized videos
Last updated
In this tutorial, we have used Google Sheets as an example. The users can connect Make directly to their CRM or marketing software of their choice.
Log into 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 which 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 the rows which 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 (as shown)
Under '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 variable and map them to the corresponding values in your Sheet (as shown)
Click on 'Run once' to check if the scenario is working
Once it's successful, click on 'Save'
Log into 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 (as shown)
Now click on 'Ok' to save these values.
In the Gan.AI platform, click on 'Save & close' to save the project's settings