How to Notify on WhatsApp for New Entries in Google Sheets Using Pabbly Chatflow

Learn how to use Pabbly Connect to automate WhatsApp notifications for new entries in Google Sheets with this detailed step-by-step 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 Automation

To begin automating WhatsApp notifications for new entries in Google Sheets, you first need to access Pabbly Connect. This platform allows you to create workflows that integrate various applications seamlessly.

Start by navigating to the Pabbly Connect website. If you are a new user, sign up for a free account to receive 100 free tasks each month. Existing users can log in to their Pabbly Connect account to begin creating workflows.

2. Creating Your Workflow in Pabbly Connect

Once logged in, click on the ‘Create Workflow’ button in the top right corner of the dashboard. This initiates the process of setting up your automation. using Pabbly Connect

• Enter the workflow name: ‘Notify on WhatsApp for New Entries in Google Sheets’.
• Select a folder to save this workflow.

After naming your workflow and selecting a folder, click the ‘Create’ button. This action will bring you to the main workflow interface, where you will set up triggers and actions.

3. Setting Up the Trigger with Google Sheets

The next step involves setting up the trigger that will activate the workflow. For this integration, select Google Sheets as your trigger application. using Pabbly Connect

• Choose the trigger event: ‘New or Updated Spreadsheet Row’.
• Copy the provided webhook URL.
• Open your Google Sheets and go to Extensions > Add-ons > Get Add-ons.

Search for the Pabbly Connect Webhooks add-on and install it. After installation, navigate back to the Extensions menu, select Pabbly Connect Webhooks, and choose ‘Initial Setup’. Paste the copied webhook URL and set the trigger column to the last data column in your sheet.

4. Configuring Action with Pabbly Chatflow

After setting up the trigger, the next step is to configure the action that will take place when a new entry is detected. For this, select Pabbly Chatflow as your action application.

In your Pabbly Chatflow account, ensure you have your WhatsApp number and API details configured. This includes the Meta access token and WhatsApp Business Account ID. Create a message template that will be sent to participants upon registration.

Select the action event: ‘Send Template Message’. Map the recipient mobile number from the previous step. Choose your created message template.

Finally, test the connection by sending a test message to ensure everything is working correctly. If successful, you will see the message in your WhatsApp inbox confirming the registration.

5. Testing and Verifying Your Integration

To test your integration, add a new participant’s details in your Google Sheet. This action should trigger the workflow you created in Pabbly Connect.

After entering the details, check your WhatsApp to verify that the confirmation message was sent successfully. You can also monitor the status of the message in your Pabbly Chatflow inbox, where you will see if the message was delivered and read.

If you encounter any issues, revisit the steps to ensure all configurations are correct. This process streamlines communication with your participants and enhances their experience.

Conclusion

This tutorial has demonstrated how to notify participants on WhatsApp for new entries in Google Sheets using Pabbly Connect. By automating this process, you ensure timely communication and a better experience for your event attendees.