> For the complete documentation index, see [llms.txt](https://manual.captivatechat.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://manual.captivatechat.ai/start-creating/create-an-ai-chatbot/copy-of-select-integration/integrate-a-google-sheet-to-ai-chatbot.md).

# Integrate a Google Sheet to AI Chatbot

<figure><img src="https://978488295-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fcu5LzWzKzBENebCXtKBf%2Fuploads%2FCxXwvx3syHRzSgjVqM8C%2Fimage.png?alt=media&amp;token=fa43d930-8207-4a5a-8b1f-b0e66eb19a3a" alt="Under the &#x22;Select Integration&#x22; page, selecting &#x22;Google Sheets&#x22; and clicking &#x22;Configure&#x22; will take users to a &#x22;Customize Integration&#x22; page where they have to insert their Google Sheet&#x27;s Sheet ID. After that, they should click &#x22;Next&#x22; to finish the integration process."><figcaption><p>Under the "Select Integration" page, selecting "Google Sheets" and clicking "Configure" will take users to a "Customize Integration" page where they have to insert their Google Sheet's Sheet ID. After that, they should click "Next" to finish the integration process.</p></figcaption></figure>

You can also select **Google Sheets** as your AI Chatbot integration. With this selected, users who want to transition to a Live Agent will have their name and email address auto-populate the sheet named "Customers" within your Google Sheet file.&#x20;

{% hint style="danger" %}
**Your Google Sheet needs to be editable by everyone**

Before you start the integration process that connects your Google Sheet to your AI Chatbot, make sure that your selected Google Sheet has its permissions set to be editable by everyone!&#x20;

To do this, please follow the steps in [this link](https://www.youtube.com/watch?v=Dv8s4QxZlDk).&#x20;

You can also simply click the blue *"Share"* button on the upper right of your Google Sheet. Under *"General Access,"* click *"Anyone with the link"* and select *"Can edit."*&#x20;
{% endhint %}

{% hint style="danger" %}
**You need to create a "Customers" sheet first!**

Before you integrate your Google Sheet into your AI Chatbot, your selected Google Sheet needs to have its *"Sheet 1"* renamed as `Customers`.&#x20;

This is where we will send the user data gathered by your AI Chatbot.
{% endhint %}

To integrate Google Sheets into your AI Chatbot:

1. Select the Google Sheets icon under "Select Integration."
2. Click ![The "Configure" button in the "Select Integration" page will let users configure the information of the platform they selected. The "Select Integration" page within the AI Chatbot creation process can assign the AI Chatbot to get user data from their conversations and store them in a selected integration platform: HubSpot, Email, or Google Sheets.](https://978488295-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fcu5LzWzKzBENebCXtKBf%2Fuploads%2FafEyTD74xKWUFCcGjgf4%2Fimage.png?alt=media\&token=ed2d7248-d0c5-46d4-8a39-260285f0ff38).
3. Enter your **the Sheet ID** of your preferred Google Sheets file.&#x20;
4. Click !["Next" in the context of Select Integration > Google Sheet > Configure > Customize Integration will integrate the selected Google Sheet into the AI Chatbot. ](https://978488295-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fcu5LzWzKzBENebCXtKBf%2Fuploads%2FP6dPoZc0BQWKz4lPqwmN%2Fimage.png?alt=media\&token=ade773dd-3de1-4621-8a3a-3a9051d8b231).

{% hint style="info" %}
**Where is my Sheet ID?**

Your Google Sheet ID is located in the URL:&#x20;

*docs.google.ocm/spreadsheets/d/*`<this-is-the-sheet-id>` */edit?gid=0#gid=0*
{% endhint %}

{% hint style="warning" %}
**Only the user's names and emails will be sent to your Google Sheets file**

Please note that, at this time, the Captivate Chat Google Sheet Integration **only captures the user’s name and email**.&#x20;

Any future improvements, such as support for custom forms, may be added in future updates and releases.
{% endhint %}

***

Once you're done placing your integration, click ![If you made it to the "Select Integration" page of the AI Chatbot creation process, leave it be and click "Update AI Chatbot" to finish the AI Chatbot creation process.](https://978488295-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fcu5LzWzKzBENebCXtKBf%2Fuploads%2FfCsb1egbsNJlsd9upWJo%2Fimage.png?alt=media\&token=4a2f7f85-ad12-4b31-a67b-4cd70907ad4b)  to finish the AI Chatbot setup.