Set Up Opt Out/Unsubscribe Link For WhatsApp Template & Remove Data from Google Sheets Using Pabbly Connect

Learn how to automate the deletion of Google Sheets data based on WhatsApp responses using Pabbly Connect. Step-by-step tutorial for seamless integration. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating the deletion of Google Sheets data based on WhatsApp responses, you first need to access Pabbly Connect. This platform allows seamless integration between various applications, including WhatsApp Cloud API and Google Sheets.

Visit the Pabbly Connect homepage by entering ‘Pabbly.com/connect’ in your browser. If you’re a new user, click on the ‘Sign Up for Free’ button to create an account. Existing users can simply sign in. After signing up, you will receive 100 free tasks every month to explore the platform’s capabilities.

2. Creating a New Workflow in Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard and click on the ‘Create Workflow’ option. Here, you will need to name your workflow, for example, ‘Delete Google Sheets Row on WhatsApp Response,’ and select a folder to save it.

• Click on ‘Create’ to initiate the workflow.
• You will see two windows: Trigger and Action.
• Select WhatsApp Cloud API for the trigger and Google Sheets for the action.

This step sets the foundation for automating the deletion of Google Sheets rows based on WhatsApp responses.

3. Setting Up WhatsApp Cloud API in Pabbly Connect

In this section, we will set up the WhatsApp Cloud API as the trigger in Pabbly Connect. Choose the trigger event as ‘Message Notification.’ This event will be activated whenever a message is received from a lead on WhatsApp.

To connect WhatsApp Cloud API, you will need to copy the provided webhook URL from Pabbly Connect and paste it into the callback URL section of your WhatsApp Cloud API settings. Ensure you have configured your WhatsApp Cloud API account correctly under the Meta for Developers section.

• Paste the webhook URL in the callback URL field.
• Enter the verification token from Pabbly Connect.
• Verify and save your settings.

Once this setup is complete, your Pabbly Connect workflow can now receive messages from WhatsApp leads.

4. Filtering Responses for Negative Feedback

After setting up the WhatsApp trigger, the next step in Pabbly Connect is to filter the incoming responses. This is crucial to ensure that only negative responses (‘no’) will trigger the deletion of the corresponding Google Sheets row.

To add a filter, select the action step and choose the ‘Filter’ application. Set up conditions that define when the workflow should continue. For example, check if the message received is equal to ‘no’ and if the sender’s number exists in the response.

Condition 1: Check if the sender’s number exists. Condition 2: Check if the message text equals ‘no’.

These conditions ensure that your workflow only proceeds to delete rows when the specified criteria are met.

5. Deleting the Google Sheets Row

Finally, we will set up the action to delete the Google Sheets row based on the filtered response in Pabbly Connect. First, add a new action step and select Google Sheets as the application.

Choose the action event as ‘Delete Row’. You will need to specify the row number to delete. This can be dynamically mapped from the previous responses to ensure the correct row is targeted.

Map the row index number received from the WhatsApp response. Set the start and end row numbers based on the requirements.

Once you click on ‘Save and Send Test Request,’ your workflow will automatically delete the specified row from Google Sheets whenever a ‘no’ response is received from WhatsApp leads.

Conclusion

In this tutorial, we demonstrated how to set up an automated process using Pabbly Connect to delete Google Sheets rows based on WhatsApp responses. By following these steps, you can efficiently manage your lead data without manual intervention.

This integration not only saves time but also ensures that your Google Sheets remain updated based on real-time feedback from WhatsApp leads. Explore more automation opportunities with Pabbly Connect for your business needs.