Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Chatflow to Set Up Your Chatbot

To begin integrating your WhatsApp orders with Google Sheets, you first need to access Pabbly Chatflow. Open your web browser and navigate to www.pabbly.com/chatflow. Once there, you will need to sign in to your account. If you are a new user, click on “Sign Up for Free” to receive 100 free credits monthly.

After logging in, you will see the Pabbly apps dashboard. Here, locate Pabbly Chatflow and click on it to access the app dashboard. You can view your credits and the WhatsApp number associated with your account. If you need to add a WhatsApp number, click on “Add WhatsApp Number” and choose your preferred connection method.

2. Creating Your WhatsApp Chatbot Flow in Pabbly Chatflow

Next, you will create a flow for your WhatsApp chatbot using Pabbly Chatflow. Click on the “Flows” option in the left sidebar, which will take you to the flow builder. Here, you can create a new flow by clicking on “Add Flow” and naming it “Restaurant Orders”.

  • Select the trigger event as “Keyword Regex Match”.
  • Enter your keyword for triggering the chatbot.
  • Set the Regex pattern for smart keyword matching.

Once the trigger is set, you can start designing the chatbot’s responses. Use the drag-and-drop interface to add message types such as text or buttons. This is where you can customize the responses that your customers will receive when they interact with your chatbot.

3. Gathering Order Details Through Chatbot Interactions

After setting up the initial greeting, you need to gather order details from users. This is done by asking specific questions through the chatbot created in Pabbly Chatflow. Use the “Ask Question” feature to prompt users for their order preferences such as bread type, veggie selection, rice, and beverages.

  • Ask for bread type and set the custom field for this response.
  • Repeat this for each item: veggies, rice, dal, and beverages.
  • Ensure each question is linked to a custom field for data collection.

Once the user has provided all the necessary information, you can use the API request feature to send these details directly to your Google Sheets. This integration ensures that every order is logged accurately and efficiently.

4. Configuring Google Sheets Integration Using Pabbly Chatflow

To finalize the order processing, you will need to connect Pabbly Chatflow with Google Sheets. Start by creating a new workflow in Pabbly Connect, which is the integration platform that links your chatbot responses to Google Sheets. Choose “Webhook by Pabbly” as your trigger.

Copy the Webhook URL provided and paste it into the API request section of your chatbot flow in Pabbly Chatflow. Ensure you set the method to POST and add the necessary fields for the order details, such as bread, veggies, rice, dal, and beverages.

After completing the setup, test the connection to ensure that when an order is placed, all details are sent to your Google Sheets automatically. Make sure to save your workflow in Pabbly Connect to maintain the integration.

5. Finalizing Your Chatbot and Testing

With the integration configured, it’s time to finalize your chatbot in Pabbly Chatflow. Review all the steps and ensure that each question is correctly set up to gather the necessary information from your customers. Test the flow by sending a message through WhatsApp and checking if the details appear in Google Sheets.

Make sure to monitor the responses and adjust any settings as needed. This will help you refine the user experience and ensure that orders are processed smoothly. Remember, you can create multiple chatbots for different purposes using Pabbly Chatflow.

Once everything is functioning as expected, you can confidently use your automated WhatsApp order system for your restaurant, enhancing customer satisfaction and operational efficiency.

Conclusion

In this tutorial, we explored how to automate WhatsApp orders to Google Sheets using Pabbly Chatflow. By following these steps, you can enhance your restaurant’s order processing system efficiently.