Automate WhatsApp Alerts for Expiring TV Subscriptions Using Pabbly Connect and Google Sheets

Learn how to automate WhatsApp alerts for expiring TV subscriptions from Google Sheets using Pabbly Connect. Follow our step-by-step tutorial. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To begin automating WhatsApp alerts for expiring TV subscriptions, first, access Pabbly Connect. This platform serves as the core integration tool that connects Google Sheets with the WhatsApp Cloud API.

Navigate to the Pabbly Connect dashboard by entering the URL in your browser. If you don’t have an account, sign up for a free account. Once logged in, click on ‘Create Workflow’ to start your automation process.

2. Creating the Workflow in Pabbly Connect

After creating your workflow, name it appropriately, such as ‘Google Sheets to WhatsApp’. This naming helps in identifying the workflow later. In the workflow, you will notice two sections: the trigger window and the action window.

• Select ‘Schedule by Pabbly’ in the trigger window to set up a daily reminder.
• Choose the frequency as ‘Every Day’ and set the time to 10 AM.
• Click ‘Save’ to finalize the trigger settings.

With the trigger set, you can now proceed to the action window, where you will retrieve data from Google Sheets using Pabbly Connect.

3. Integrating Google Sheets with Pabbly Connect

In the action section, search for Google Sheets and select ‘Get Rows’ as the action event. This step allows Pabbly Connect to pull customer subscription data from your designated Google Sheet.

Connect your Google Sheets account by following the instructions. Select the spreadsheet containing customer details and specify the range of data you want to retrieve. For example, if your data starts from cell A2 and goes to the last filled cell in column D, set the range accordingly. After setting up, click ‘Save and Send Test Request’ to ensure data retrieval works correctly.

4. Processing Data with Iterator in Pabbly Connect

Once the data is fetched, use the Iterator feature in Pabbly Connect to process each row of data individually. This feature helps to manage customer subscription details one at a time.

After adding the Iterator step, map the necessary fields such as customer name, phone number, and subscription expiry date. This mapping is crucial for sending personalized WhatsApp messages later. Once mapped, click ‘Save and Send Test Request’ to confirm that the data is processed correctly.

5. Sending WhatsApp Alerts Using WhatsApp Cloud API

Now that you have the customer data ready, it’s time to send WhatsApp alerts. In the action step, search for WhatsApp Cloud API and select ‘Send Template Message’. This action allows Pabbly Connect to send personalized messages to customers whose subscriptions are expiring.

Connect your WhatsApp Cloud API account and choose the message template you created earlier. Map the required fields such as recipient mobile number and dynamic content (like customer name and expiry date) from the previous steps. Finally, click ‘Save and Send Test Request’ to send the WhatsApp message. Check the WhatsApp account to confirm that the message was received successfully.

Conclusion

In this tutorial, we demonstrated how to automate WhatsApp alerts for expiring TV subscriptions using Pabbly Connect and Google Sheets. By following these steps, you can efficiently remind customers about their subscription renewals, ensuring better customer service and retention.