Platform
Chatbot Builder Bulk Messaging Team Inbox Mini CRM API & Webhooks AI Integration WhatsApp Flows
Industries
E-commerce & D2C Real Estate Education Healthcare Finance & BFSI Logistics Hospitality Retail
Integrations
Learn
Learning Hub Help & Docs Connect Guides Automation Codex Blog Message Templates
Pricing Get Started →
Home › Help & Docs › Bot Builder › Create dynamic buttons and lists from Google Sheet data
Bot Builder

Create dynamic buttons and lists from Google Sheet data

Instead of hardcoding button options in your bot, you can pull them live from a Google Sheet and display them as an interactive list. This is useful for product catalogues, service menus, complaint categories, or any list that changes over time — update the sheet and the bot's options update automatically.

Use case

A service centre bot asks 'Enter your billing number' then shows a dynamic list of all open complaints linked to that number, pulled live from a Google Sheet. The user picks one to see its status.

Step 1: Capture the lookup value

1
Add a keyword trigger and an Ask a Question block.
2
Ask the user for the value to look up (phone number, membership ID, etc.).
3
Save the response to a Bot Field.

Step 2: Fetch matching rows from Google Sheets

1
Add a node → Automation App → Google Sheets → Lookup Rows.
2
Connect your Google account, select the spreadsheet and sheet.
3
Set the lookup column and map it to the Bot Field from Step 1.
4
Set condition to Equal to.
5
Run and save. Store: number of rows found and full row data (JSON) in Bot Fields.

Step 3: Add a router for zero results

1
Add a Router.
2
If rows = 0: send 'No records found.' and optionally loop back.
3
If rows > 0: proceed to Step 4.

Step 4: Create the dynamic list

1
Add a node → Send Message → Interactive Message → Dynamic List.
2
Map Title to a relevant field (e.g., complaint type or product name).
3
Map Description to a detail field (e.g., date, amount).
4
Map Value to a unique identifier (e.g., complaint number or row ID).
5
Save the user's selection to a Bot Field.
6
Use the selected value in subsequent messages or API calls.
7
Save and enable the workflow.

Was this helpful? If you are stuck, message us and a real person will help — the only platform that answers you live on WhatsApp.

Ask us on WhatsApp
Related guides

Search Google Sheets data and respond

The single-result lookup flow — one input, one matching reply.

Read guide →

Google Sheet blocks in a bot

Full reference for all Google Sheet blocks: lookup, add row, update, and more.

Read guide →

The Ask a Question block

How question types, buttons, and interactive lists work.

Read guide →
1