Watch Step By Step Video Tutorial Below






1. Setting Up Pabbly Connect for WhatsApp Feedback

To begin integrating WhatsApp feedback into Google Sheets, you need to set up Pabbly Connect. First, visit the Pabbly Connect dashboard and create a new workflow. This platform will act as the bridge between your WhatsApp chatbot and Google Sheets, ensuring that all feedback is collected seamlessly.

Once you’re in Pabbly Connect, click on ‘Create Workflow’. You will be prompted to name your workflow. For this integration, you can name it “WhatsApp Feedback to Google Sheets”. After naming, select the trigger application as “Webhook by Pabbly”. This will generate a unique webhook URL that will be used to receive data from your WhatsApp chatbot.


2. Creating the WhatsApp Chatbot Using Pabbly Chatflow

Next, you need to create a WhatsApp chatbot using Pabbly Chatflow. Access Pabbly Chatflow by navigating to the Pabbly website and signing in. If you are a new user, sign up for free to get started. Once logged in, click on “Add Flow” to create a new chatbot flow.

  • Name your flow as “Collect Customer Feedback”.
  • Select the trigger event as “Keyword Reax Match Only”.
  • Enter the keyword that will trigger the bot, e.g., “Hey”.

After setting up the trigger, you can design the conversation flow. Drag and drop elements to create messages and buttons. Make sure to include options like “Give Feedback” and “Remind Me Later” to engage users effectively.


3. Collecting Feedback and Sending It to Google Sheets

Once the chatbot is set up, you’ll need to configure it to collect feedback and send it to Google Sheets using Pabbly Connect. After the user interacts with the chatbot, their responses need to be sent to the webhook you created earlier. To do this, drag and drop the “API Request” action and select “POST” as the request type.

In the API request settings, paste the webhook URL from Pabbly Connect. You will then need to map the user responses (like name, email, rating, and feedback) to the respective fields in Google Sheets. This mapping ensures that all feedback is organized correctly in your spreadsheet.


4. Testing and Finalizing the Integration

After setting up the API request, it’s crucial to test the integration to ensure everything works correctly. Send a test message through your WhatsApp chatbot and check if the data appears in your Google Sheets. In Pabbly Connect, click on “Test” to see if the data is received as expected.

If the test is successful, make sure to save your workflow in Pabbly Connect. This step is essential to ensure that your integration is live and functioning. You can also set up a delay for follow-up messages, enhancing user engagement.


Conclusion

In this tutorial, we explored how to use Pabbly Connect to integrate customer feedback from WhatsApp directly into Google Sheets. By following the steps outlined, you can automate your feedback collection process efficiently. This integration not only saves time but also streamlines data management for your business.