# Google Sheets
#### How to import data from your Google Sheets through Make to create video copies in Gan.AI?
1. Log in to 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 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
6. 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:
* 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?
1. Log in to 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
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.
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.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://help.gan.ai/integrations-and-automation/available-integrations/google-sheets.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.