Store Bot Data in Google Sheets (Real-Time)

This guide explains how to collect user data through a bot and automatically store it in Google Sheets.

Step 1: Create Bot Flow #

1. Go to Chatbot → Create Botflow
2. Add a trigger (keyword)
3. Select channel and set conditions
4. Save configuration

Step 2: Collect User Data #

Add question blocks to capture user inputs:

• Welcome Message + Action Button (e.g., Place Order)
• Name → Save response
• Product Selection (buttons/list) → Save response
• Quantity → Save response

Step 3: Connect Google Sheets #

1. Add Automation → Google Sheets → Add Row
2. Select or create authentication
3. Choose the spreadsheet and sheet

Step 4: Map Data #

• Map collected fields to sheet columns:
  • Name
  • Product Name
  • Quantity
• Click Run & Save

Step 5: Test Flow #

• Trigger the bot
• Enter user details
• Verify data is added automatically in Google Sheets
• Save and Enable workflow