Spreadsheet autoreply
Reply from Google Sheet rows — update copy without redeploying rules.
Open Autoreply → Spreadsheet.
What this page is for
Spreadsheet links connect Google Sheets to your WhatsApp or Telegram devices. Each row defines a keyword, logic, and response text. Teammates can edit the sheet in Google Sheets; changes apply on the next incoming message — no need to save dashboard rules.
For replies to run, set On incoming message to Spreadsheet on each linked device under Channel → WhatsApp → Devices or Channel → Telegram → Devices.
Sample data shown.
End-to-end workflow
- Prepare a Google Sheet with
keyword,logic, andresponsecolumns (see Sheet format). - Share the sheet — Anyone with the link — Viewer.
- Add spreadsheet on this page — name, devices, URL, optional note.
- Set device mode — On incoming message → Spreadsheet on each linked device.
- Test — send a message that matches a row; Kirisan replies with that row’s
responsecell.
Spreadsheet list
| Column / control | What it does |
|---|---|
| Tutorial | In-dashboard guide — sheet format, logic values, sharing, device mode. |
| Add spreadsheet | Link a new Google Sheet to one or more devices. |
| Name | Label for your reference. |
| Spreadsheet URL | Link to the Google Sheet (opens in a new tab). |
| Internal note | Private team note — not sent to users. |
| Channels | Click N linked to see WhatsApp lines or Telegram bots. |
| Actions | Edit spreadsheet or Remove spreadsheet. |
Entries are saved to your account. The browser also keeps a local backup copy.
Add or edit a spreadsheet link
Click Add spreadsheet or edit a row.
Sample data shown.
| Field | What to enter |
|---|---|
| Name | Short label (for example FAQ replies, Price list March). |
| Devices | Filter WhatsApp or Telegram, search, and pick one or more lines or bots. Use All / All filtered for bulk selection. |
| Spreadsheet URL | Full Google Sheets URL (https://docs.google.com/spreadsheets/d/…). |
| Internal note | Optional reminder for your team. |
Click Create (or Save when editing).
The helper text under the URL reminds you that the sheet needs keyword, logic, and response columns. The response column also supports server-side [[…]] variables — see Variables.
Tutorial (in-dashboard guide)
Click Tutorial for step-by-step setup inside the dashboard.
Sample data shown.
The tutorial covers:
- Prepare the sheet — header row (
keyword,logic,response) with example values — see also Sheet format. - Pick a logic value —
exact,startswith,endswith,includes. - Share the sheet — public viewer access for CSV export.
- Create a spreadsheet link — this page.
- Switch the device to Spreadsheet mode — device settings.
- How a reply is chosen — order of sheets and rows.
- Dynamic values —
[[date-…]],[[time-…]], etc.
Sheet format
The first row must be the header with these three column names. Names are case-insensitive; column order does not matter. Extra columns (for example notes for your team) are ignored.
Sample data shown — row 1 is the header; replies start from row 2.
| Column | Purpose | Example value |
|---|---|---|
keyword | Trigger text matched against the incoming message. | hi, price, order #123 |
logic | How to compare — see Logic values. | exact, includes, startswith, endswith |
response | Reply text sent when the row matches. | Hi! How can I help you today? |
Example rows
| keyword | logic | response | Matches when the user sends… |
|---|---|---|---|
hi | exact | Hi! How can I help you today? | Exactly hi (trimmed, any casing — Hi works too). |
price | includes | Our price list: https://example.com/price | Any message containing price, such as what is the price?. |
order | startswith | Thanks for your order! We’ll process it shortly. | A message that starts with order, such as order 4821. |
thanks | endswith | You’re welcome! Have a great day. | A message that ends with thanks, such as ok thanks. |
promo | includes | Today is [[date-dd-mm-yyyy]] — ask us about our sale! | Any message containing promo; [[date-dd-mm-yyyy]] is replaced at send time. |
Rows with empty keyword or response are skipped.
Logic values
| Value | Matches when | Example keyword | Example incoming message |
|---|---|---|---|
exact | The full message equals the keyword (trimmed, case-insensitive). | hi | hi or Hi |
startswith | The message begins with the keyword. | order | order 4821 blue shirt |
endswith | The message ends with the keyword. | thanks | received, thanks |
includes | The message contains the keyword anywhere (default if blank or unknown). | price | send me the price list |
Put specific rules (exact) above broad ones (includes) within the sheet.
Enable Spreadsheet mode on a device
Spreadsheet links only run when the device is in Spreadsheet mode:
- Open Channel → WhatsApp → Devices or Channel → Telegram → Devices.
- Edit the device.
- Under On incoming message, choose Spreadsheet (not Autoreply, Flow, or Webhook).
- Save.
| Mode | Behavior |
|---|---|
| Spreadsheet | Match rows from linked sheets on this page. |
| Autoreply | Dashboard keyword templates — see Autoreply. |
| Flow | Visual conversation tree — see Flow. |
| Webhook | Forward to your server only. |
Only one mode is active per device at a time.
How a reply is chosen
- All spreadsheets linked to that device are checked in the order you created them on this page.
- Within each sheet, rows are scanned top to bottom.
- The first row whose
keywordmatches (using itslogic) wins. - Kirisan sends that row’s
responsecell. - If nothing matches across all linked sheets, no autoreply is sent.
Matching is case-insensitive. Every incoming message fetches the latest sheet data — edits in Google Sheets apply immediately.
Dynamic values in responses
The response cell supports server-side variables in double brackets, for example:
[[date-dd-mm-yyyy]][[time-hh:mm]]
See Variables for the full list.
Spreadsheet vs dashboard autoreply
| Dashboard Autoreply | Spreadsheet mode |
|---|---|
| Edit rules in the dashboard | Edit rows in Google Sheets |
| Message, template, or submission replies | Plain text from the response column |
| Device mode: Autoreply | Device mode: Spreadsheet |
You can link multiple sheets to one device, or one sheet to many devices. Spreadsheet mode does not read dashboard autoreply templates — pick one mode per device.
Spreadsheet links on this page are for WhatsApp and Telegram devices only.
Tips
- Share the sheet as Anyone with the link — Viewer before going live.
- Keep keywords unique within a sheet to avoid unpredictable matches.
- Use a separate sheet or tab for unrelated keyword sets.
- For WABA Cloud API numbers, use Autoreply templates or Flow — spreadsheet lookup is for WhatsApp and Telegram bots linked here.
Related
- Autoreply — dashboard keyword rules (separate device mode)
- Flow — canvas automations when sheets are not enough
- WhatsApp Devices — On incoming message setting
- Telegram Devices — bot inbound mode