How to Get WhatsApp Message Delivery Status to Google Sheets Using Pabbly Connect

Learn how to integrate WhatsApp message delivery status with Google Sheets using Pabbly Connect in this detailed tutorial. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WhatsApp Integration

To get started with integrating WhatsApp message delivery status to Google Sheets, you first need to access Pabbly Connect. Open your browser and type Pabbly.com to reach the official site. If you are a new user, click on the ‘Sign Up for Free’ button to create an account in just a few minutes. Existing users can simply click on ‘Sign In’ to access their dashboard.

Once logged in, navigate to the ‘All Apps’ section and select Pabbly Connect. Click on ‘Access Now’ to reach the dashboard where you will create a new workflow for your integration.

2. Creating a Workflow in Pabbly Connect

Start by clicking on the plus sign to create a new workflow. Name your workflow appropriately, such as ‘Get WhatsApp Message Delivery Status to Google Sheets’. This naming helps in identifying the workflow later. After naming it, click on ‘Create’ to proceed.

• Choose the trigger application as WhatsApp Cloud API.
• Select the trigger event as ‘Message Notification’, which will activate when a message is sent, delivered, or received.
• Copy the provided webhook URL for further configuration.

By following these steps, you set up the trigger accurately. This is crucial as it allows Pabbly Connect to listen for WhatsApp message statuses effectively.

3. Configuring WhatsApp Cloud API with Pabbly Connect

Next, you need to configure your WhatsApp Cloud API account. Log into your account at developers.facebook.com. Create a new app by clicking on the ‘Create App’ button. Once your app is created, navigate to the ‘Products’ section and select WhatsApp.

In the WhatsApp configuration settings, paste the copied webhook URL from Pabbly Connect into the Callback URL field. Additionally, enter the verified token, which is usually formatted as pabbly_webhook_token. After entering these details, click on ‘Verify and Save’. This step is essential to ensure that WhatsApp can communicate with Pabbly Connect.

4. Setting Up Google Sheets for Message Status Tracking

Now that WhatsApp is configured, it’s time to set up Google Sheets to capture the message delivery status. Return to your Pabbly Connect workflow and add an action step by clicking the plus sign. Choose Google Sheets as the application and select ‘Add New Row’ as the action event.

• Connect your Google Sheets account by clicking on ‘Connect with Google Sheets’.
• Authorize Pabbly Connect to access your Google account.
• Select the spreadsheet where you want to store the WhatsApp delivery statuses.

After configuring these settings, map the relevant fields such as phone number and delivery status from the WhatsApp trigger response. This mapping ensures that whenever a message is delivered, the details are automatically added to your Google Sheet via Pabbly Connect.

5. Testing and Verifying the Integration

With the integration set up, it’s time to test it. Send a WhatsApp message to the number you configured earlier. Once the message is sent, Pabbly Connect will capture the delivery status. You can check the trigger response in the dashboard to see if the status appears as ‘Delivered’.

Next, verify that the data is correctly added to your Google Sheet. Go back to your Google Sheets and check for the new entry that includes the phone number and the delivery status. This confirms that your integration is working as intended.

In summary, you have successfully integrated WhatsApp message delivery status with Google Sheets using Pabbly Connect. This setup allows for automatic tracking of message statuses, enhancing your communication efficiency.

Conclusion

In this tutorial, we explored how to utilize Pabbly Connect to get WhatsApp message delivery statuses directly into Google Sheets. This integration simplifies tracking and enhances your messaging workflow. Start using Pabbly Connect today to automate your processes effectively!