Integrate a Google Sheet to AI Chatbot

Last updated

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.
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!
To do this, please follow the steps in this link.
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."
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.
This is where we will send the user data gathered by your AI Chatbot.
To integrate Google Sheets into your AI Chatbot:
Select the Google Sheets icon under "Select Integration."
Click
.
Enter your the Sheet ID of your preferred Google Sheets file.
Click
.
Where is my Sheet ID?
Your Google Sheet ID is located in the URL:
docs.google.ocm/spreadsheets/d/<this-is-the-sheet-id> /edit?gid=0#gid=0
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.
Any future improvements, such as support for custom forms, may be added in future updates and releases.
Once you're done placing your integration, click
to finish the AI Chatbot setup.
Last updated