Google Sheets

Sheets from Google is a free online spreadsheet tool. It can be used to store structured data and create colorful charts and graphs from your data. These sheets can be accessed and edited from any device, anywhere. You can use our integration with Google Sheets to capture your data from the bot inside these Sheets.

Connect Collect.chat with Google Sheets

Go to your Collect.chat dashboard and select your bot. Then click on Edit > Integrations. Next to Google Sheets, click on the Connect button.

Choose any one of your Google accounts. The sheet in which the responses will be saved will belong to this account.

You will get this pop-up asking for permission. Click on Allow.

There will be one more confirmation page from Google. Click on Allow once more.

You will be redirected

View Sheet

You can click on the sheet icon to open the sheet that you just created.

You will be able to see that the columns in the sheet have already been populated with the questions in the chatbot.

Test the Integration

• Go to your Dashboard > Edit > Design.

• Click on the Eye-shaped icon to have a test conversation with your chatbot.

• Have a complete interaction with your chatbot.

Check the Google Sheet you just created. You should see that the data has been saved in the Sheet.

Tip

If you would like to see the partial responses on your Sheet, please go to Settings > Notifications and turn on Send incomplete responses.

Note

To stop the Google Sheets integration, click on the disconnect button.