Google Sheets

This guide covers how to integrate Google with Gan.AI using Make to create personalized videos

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.

How to import data from your Google Sheets through Make to create video copies in Gan.AI?

  1. Log into your Gan.AI account, select the required personalised project

  2. Go to Project settings -> Integrations -> Make and turn on the integration

  3. Log in to your Make account and click on 'Create a new scenario'

  4. Name your scenario based on the automation you are looking to create

  5. 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

  1. 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'

How to export video copies from Gan.AI to your Google Sheets through Make?

  1. Log into your Gan.AI account, select the required personalised project

  2. Go to Project settings -> Integrations -> Make and turn on the integration

  3. Log in to your Make account and click on 'Create a new scenario'

  4. Name your scenario based on the automation you are looking to create

  5. In the Apps section, search for 'Webhooks' and select 'Custom webhooks'

  6. Name your webhook and click on 'Save'

  7. Click on 'Copy address to clipboard' and paste it in the Gan.AI platform in the webhook URL input

  8. Once it shows "Successfully determined" on the Make platform, click on 'Ok'

  9. Click on 'Add another module' and search for Google Sheets

  10. Choose the action you want to happen in your Google Sheets

  11. Now copy the Spreadsheet ID, and paste it in the Input box

  12. Now select the sheet and map the values that you want to send to the columns in the spreadsheet (as shown)

  1. Now click on 'Ok' to save these values.

  2. In the Gan.AI platform, click on 'Save & close' to save the project's settings

Last updated