Google Sheets Data Search via Bot Flow

This feature allows you to fetch data from Google Sheets and respond to users dynamically in a bot flow. Steps:

1. Go to Chatbot and click on Create Bot Flow

2. Enter a Bot Flow name

3. Add a Trigger (e.g., Keyword) and select channel

4. Add an Ask Question block to collect input (e.g., Complaint Number)

5. (Optional) Save response in a Custom/Super Field

6. Add a Branch and select Automation App → Google Sheets

7. Choose Lookup Spreadsheet Rows action

8. Connect your Google account (Authentication)

9. Select Spreadsheet and Sheet

10. Enter Column (e.g., D for Complaint Number)

11. Set condition (e.g., Equal to Number) and map value as Last Text Input

12. Test and verify data using Run History

13. Save response data into Bot Fields (e.g., Status, Row Count)

14. Add a Router:

• If no record → send “No record found” and re-ask input

• If record found → display fetched data

1. Save and Enable Bot Flow

This setup helps automate data lookup and gives instant responses to users using Google Sheets.