Appearance
Google Spreadsheet Integration
Let your AI sales assistant 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 assistant | Connect + file picker flow |
| Latin-only column names | First row of the sheet | Each header becomes a field the assistant must collect |
| Order collection enabled | Automatic on connect | Assistant writes a new row per order |
Connect in 6 steps:
- Open the Integrations tab in your MyChatBot dashboard.
- Select the assistant you want to connect.
- Find Spreadsheet Orders and click Connect.
- Either reuse an existing connection another assistant 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 assistant → 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 assistant will ask the user to fill in before it can save the row.
MyChatBot automatically adds three columns when the sheet doesn't already have them (new columns go at the far right):
| Column | Purpose |
|---|---|
| Client ID | Identifies the user/customer |
| Order ID | Unique identifier for each entry |
| Chat link | Link to the conversation the order came from |
Two more columns are filled only if you add the header yourself:
| Column | Purpose |
|---|---|
| Page ID | Channel identifier (e.g. your Instagram account for Instagram, account name for OLX) — shows which channel the order came from |
| Invoice number | A sequential invoice number per account, assigned once you add the column |
What the assistant can do
After you connect a spreadsheet, your assistant gains the ability to collect structured data and save it as a new row.
| Capability | What the assistant 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 assistant must collect, the assistant 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 assistant 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 assistant has to ask for.
- Add instructions in your assistant's settings to guide it on when to use the spreadsheet (for example, only after the user confirms they want to order).