1. Sending Chatbot Data to Google Sheets
This article explains how to save chatbot responses directly into Google Sheets.
Why Send Data to Sheets
Useful for:
- Lead tracking
- Admission forms
- Appointment booking logs
How Integration Works
Chatbot answers are:
- Mapped to sheet columns
- Saved row-by-row automatically
Setup Steps
- Connect Google account
- Select spreadsheet
- Map chatbot fields to columns
- Save integration
2. Auto Lead Sheet Creation Using triochat.io
This article explains how triochat.io can automatically create and update lead sheets.
Auto Sheet Creation
You can configure:
- New sheet for each campaign
- Central master lead sheet
Data That Can Be Stored
- Name
- Phone number
- Responses
- Source channel
Benefits
- No manual data entry
- Easy sharing with sales team
3. Uploading Campaign Lists from Google Sheets
This article explains how to run campaigns using contact lists stored in Google Sheets.
Why Use Sheets for Campaigns
- Easy collaboration
- Live updating lists
- Large datasets
How to Use Sheet for Campaign
- Select Google Sheets as source
- Choose spreadsheet and tab
- Map phone number column
- Preview and send campaign
Sync Frequency
Data can be:
- Pulled once
- Or synced dynamically
4. Troubleshooting Google Sheets Sync Errors
This article explains common sync problems and how to resolve them.
Common Issues
- Permission revoked
- Sheet renamed
- Column mismatch
- API limits
Quick Fixes
- Reconnect Google account
- Re-map columns
- Check sheet sharing settings
When to Contact Support
If:
- Sync fails repeatedly
- Data not updating