• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

  • Please note that the team will not be available on 17th June 2024, due to a public holiday.

    During this period, support assistance may experience some delays.

sharing data from spreadsheet to wati chatbot

AQIB ALI

Member
I

Scenario:
  1. When a user interacts with our WhatsApp chatbot and provides their order ID, we want the chatbot to retrieve the relevant order status information from a Google Spreadsheet.
  2. The chatbot should then send this order status information back to the user via WhatsApp.

Key Points:
We are using a 'wait' chatbot approach, where the chatbot awaits user input before proceeding.
The data for order tracking is stored in a Google Spreadsheet. We believe that integrating Pabbly with our Google Spreadsheet can streamline this process and provide a seamless experience for our customers.
Could you please provide us with guidelines on how we can achieve this integration using Pabbly?
Specifically, we need assistance in configuring Pabbly to retrieve data from the Google Spreadsheet based on the user's input (order ID) and send the response back to the user via WhatsApp.
 

ArshilAhmad

Moderator
Staff member
Hi @AQIB ALI,

Please watch the video shared below to understand how you can set up your workflow to create a WhatsApp Chatbot. Only the first and last steps of the video are relevant to your use case.

You can use 'Lookup Spreadsheet Rows' action step to fetch the order status information.
1708278403601.png
 
Top