Toolkit›Suite›Robot›Suite - Google Sheets Integration

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:

  1. 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)
  2. A "Save Data" block is hit — when the conversation reaches a Save Data block you've placed in the flow
  3. 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.