Fetch Data from Google Sheets & Create Dynamic Buttons/List

This guide explains how to fetch user data from Google Sheets and display it as dynamic buttons or lists in a bot flow.

Step 1: Create Bot Flow

1. Go to Chatbot → Create Botflow

2. Add trigger (keyword)

3. Select channel and save

Step 2: Capture Phone Number

• Ask user if their WhatsApp number is the billing number

  • If Yes → Save WhatsApp number

  • If No → Ask for billing number and save input

Step 3: Fetch Data from Google Sheets

1. Add Automation → Google Sheets → Lookup Rows

2. Select authentication and spreadsheet

3. Enter column (e.g., Phone Number column)

4. Set condition (equals)

5. Map phone number variable

6. Run once and then Save

Step 4: Store Retrieved Data

• Save:

  • Number of rows found

  • Full response data

• Use Bot Fields for storage

Step 5: Apply Conditions

• If no data found (rows = 0)

  • Send message: No complaint found

  • Redirect user (Go To block)

• If data found (rows > 0)

  • Proceed to next step

Step 6: Create Dynamic List

1. Add Interactive Message

2. Select Dynamic List

3. Map:

   • Title → Name

   • Description → Complaint Number

   • Value → Unique field (e.g., Complaint Number)

4. Save user selection

Step 7: Show Complaint Status

• Send message with mapped complaint status

• Save and Enable workflow