SimpleBot — 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 rather than the integration itself.
Need more help?
If you've worked through this and still need a hand, contact support — we'll dig in with you.