Suite - Google Sheets Integration
Overview
Robot includes a native Google Sheets integration that lets you send bot conversation data directly into a spreadsheet. This is useful for tracking leads, collecting survey responses, or feeding data into other workflows.
Important: The Google Sheets integration only works with Flow Builder-based bots; standalone AI Mode bots do not trigger integrations. If you want to use AI responses and still send data to Sheets, use AI within a Flow Builder bot by adding an AI Block as a step in your flow.
When Data Is Sent to Google Sheets
Data is pushed to your connected Google Sheet when any of these events occur during a conversation:
- An email block is filled in — when the visitor provides their email address (unless a Save Data or AI block is also present in the flow)
- A "Save Data" block is hit — when the conversation reaches a Save Data block you've placed in the flow
- An AI Block is present and the timer completes — when an AI block finishes its interaction window
Troubleshooting
If data isn't appearing in your Google Sheet, work through these checks:
- Verify your bot type. The integration requires a Flow Builder-based bot. If you're running a standalone AI Mode bot, data won't be sent. Wrap your AI in a Flow Builder flow to enable integrations.
- Check your data trigger points. Make sure your flow includes at least one of the three trigger events listed above. If none are present, no data will be pushed.
- Test email notifications. If the bot collects an email and you've set up email notifications, check whether those emails are arriving. If they are, the data collection is working — the issue is between the bot and Sheets specifically.
- Verify permissions and sheet URL. Confirm that the Google Sheet is shared with the correct account and that the sheet URL in your integration settings is accurate.
- Try a fresh integration. If all else looks correct, create a new test bot with a simple flow and connect it to a new Google Sheet. If the test works, the issue is with the original bot's configuration.
Need more help?
If you've worked through this and still need a hand, contact support — we'll dig in with you.