Appearance
Google Spreadsheet Integration
Let your MyChatBot agent collect structured data from users — orders, contact details, and other form fields — and write it straight into a Google Spreadsheet you can view, edit, and export.
At a glance
| You need | Where | Result |
|---|---|---|
| A Google Spreadsheet with a header row | Google Drive | Column headers become the data fields |
| The Spreadsheet Orders integration | Integrations tab → your agent | Connect + file picker flow |
| Latin-only column names | First row of the sheet | Each header becomes a field the agent must collect |
| Order collection enabled | Automatic on connect | Agent writes a new row per order |
Connect in 6 steps:
- Open the Integrations tab in your MyChatBot dashboard.
- Select the agent you want to connect.
- Find Spreadsheet Orders and click Connect.
- Either reuse an existing connection another agent already uses, or create a new one via Connect → Open file picker.
- Choose the Google Spreadsheet to use for data collection.
- Click Connect to finish.
In the app
Go to Integrations → pick your agent → Spreadsheet Orders → Connect → Open file picker. App URL: https://app.mychatbot.app/integration
Latin column names only
Column headers must use Latin characters (English alphabet). Cyrillic, Arabic, or other scripts will break the integration. Rename headers before connecting.
Spreadsheet requirements
To work with the MyChatBot integration, your spreadsheet must:
- Have column headers in the first row defining the data fields you want to collect.
- Use Latin characters only for column names (no Cyrillic, Arabic, or other scripts).
- Expect each column header to become a field the agent will ask the user to fill in before it can save the row.
MyChatBot automatically adds three columns:
| Column | Purpose |
|---|---|
| Client ID | Identifies the user/customer |
| Order ID | Unique identifier for each entry |
| Page ID | Channel identifier (e.g. your Instagram account for Instagram, account name for OLX) — shows which channel the order came from |
What the agent can do
After you connect a spreadsheet, your agent gains the ability to collect structured data and save it as a new row.
| Capability | What the agent does | When it happens |
|---|---|---|
| Collect order data | Guides the user through every field defined by your column headers | When a user wants to place an order or submit details |
| Write a new row | Saves the collected values, assigns an Order ID, and records the channel | Once all required fields are provided |
Because every column header is treated as a field the agent must collect, the agent won't save an incomplete row — it keeps asking until each field has a value.
Example use case
When a user asks to place an order, the agent will:
- Request all required information matching your spreadsheet columns.
- Create a new row with the provided data.
- Generate a unique Order ID.
- Confirm the successful order creation to the user.
You can see every collected row in your connected sheet, or inside MyChatBot on the Orders page.
In the app
Review collected rows via the View orders button on the integration, or open the Orders page directly at https://app.mychatbot.app/orders.
Configuration tips
- Create clear column headers that reflect the exact information you need.
- Keep the number of fields reasonable so you don't overwhelm users — every header is something the agent has to ask for.
- Add instructions in your agent's settings to guide it on when to use the spreadsheet (for example, only after the user confirms they want to order).