Integrating WhatsApp Messages to Google Sheets Using Pabbly Connect

Learn how to automate the process of sending WhatsApp messages to Google Sheets using Pabbly Connect in this detailed tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To begin integrating WhatsApp messages into Google Sheets, you need to access Pabbly Connect. Start by signing into your Pabbly account and navigating to the dashboard where you can create a new workflow.

Click on the ‘Create Workflow’ button and name your workflow, for instance, ‘Get WhatsApp Messages in Google Sheets’. Once created, you will see the trigger and action modules where you can set up the integration.

2. Configuring Trigger and Action in Pabbly Connect

In this step, you will set the trigger event for your workflow. Choose ‘Customer Message Received’ from the Interact by WhatsApp as the trigger event. This means that every time a message is received, it will initiate the workflow. using Pabbly Connect

• Select the trigger application: Interact by WhatsApp.
• Choose the event: Customer Message Received.
• Set up the action application: Google Sheets.
• Select the action event: Add New Row.

After setting up the trigger, you will connect to Google Sheets where the data will be recorded. Ensure that your Google Sheets is ready to receive the data from the workflow.

3. Configuring Webhook in Interact by WhatsApp

Next, you need to configure the webhook that connects Pabbly Connect to Interact by WhatsApp. Copy the webhook URL provided by Pabbly Connect and navigate to your Interact settings.

• Go to Developer Settings in Interact.
• Paste the copied webhook URL into the designated field.
• Select the trigger for message receipt.
• Submit the settings to finalize the webhook configuration.

Once the webhook is configured, test the connection to ensure that messages are being captured correctly by Pabbly Connect.

4. Formatting Data Before Sending to Google Sheets

After receiving the message in Pabbly Connect, you will need to format the data appropriately before sending it to Google Sheets. This includes changing the time zone and splitting the date and time into separate columns.

Use the Date Time Formatter feature in Pabbly Connect to adjust the time zone from UTC to your local time zone, such as Asia/Kolkata. Then, implement the Text Formatter to separate the date and time into distinct fields.

5. Finalizing the Integration to Google Sheets

The final step involves mapping the formatted data to the appropriate columns in Google Sheets. Ensure that you select the spreadsheet and sheet where the data will be recorded. using Pabbly Connect

Choose the correct spreadsheet name: Customer Feedback. Map the fields: Country Code, Phone Number, Message, Date, and Time. Save and test the integration.

Once the integration is confirmed, every feedback message received via WhatsApp will automatically populate your Google Sheets, streamlining your data collection process.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to integrate WhatsApp messages into Google Sheets effectively. By automating this process, you can efficiently collect feedback without manual intervention, enhancing your operational efficiency.