Send WhatsApp Alerts on Expiring TV Subscription from Google Sheets Using Pabbly Connect

Learn how to send WhatsApp alerts for expiring TV subscriptions directly from Google Sheets using Pabbly Connect. Follow this detailed tutorial to automate reminders. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin sending WhatsApp alerts for expiring TV subscriptions, you first need to access Pabbly Connect. Start by visiting the Pabbly website and logging in to your account. If you don’t have an account, you can easily create one in just a few minutes.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow that will facilitate the integration between Google Sheets and WhatsApp. Follow these steps:

• Click on ‘Create Workflow’ in the top right corner.
• Name your workflow (e.g., ‘Google Sheets to WhatsApp Alerts’).

With your workflow created, you are now ready to set up the integration process. This is the first step in automating your WhatsApp alerts.

2. Setting Up Google Sheets in Pabbly Connect

Next, you will connect Google Sheets to Pabbly Connect. This is crucial for fetching subscriber data, including names, phone numbers, and subscription expiry dates. In the trigger section, select Google Sheets as your application.

Then, choose the trigger event as ‘New Row’ or ‘Get Row’ based on your needs. This allows you to pull the relevant subscriber information from your Google Sheet. Here’s how to do it:

• Select your Google account and allow Pabbly Connect to access it.
• Choose the specific spreadsheet containing subscriber details.
• Define the range of data you want to fetch (e.g., A2:G14).

After setting up the Google Sheets connection, you can proceed to fetch the data needed for sending WhatsApp alerts.

3. Configuring WhatsApp Alerts Using Pabbly Connect

With your Google Sheets data now accessible through Pabbly Connect, the next step is to configure the WhatsApp alerts. For this, you will use a messaging service like Vati. In the action section of your workflow, select Vati as the application.

Choose the action event as ‘Send Template Message’. You will need to connect your Vati account and input the necessary API credentials. Follow these steps:

Provide the API endpoint and access token from your Vati account. Map the WhatsApp number and message template parameters. Customize the message with subscriber details fetched from Google Sheets.

By setting up these parameters, you ensure that each subscriber receives a personalized reminder about their expiring subscription.

4. Testing the Integration and Automation

After configuring the WhatsApp alerts, it’s time to test the integration. This is where Pabbly Connect shines, allowing you to verify that everything works as intended. Click on the ‘Send Test Request’ button to check if the alerts are being sent correctly.

During testing, ensure that the alerts are being sent to the correct WhatsApp numbers and that the messages include the right details. If everything looks good, you can finalize your workflow. Here’s a quick checklist:

Verify that the correct subscriber data is being pulled from Google Sheets. Ensure the WhatsApp message template is formatted correctly. Confirm that the alerts are sent at the scheduled time.

Once you confirm that the integration works seamlessly, you can set it to run automatically at your preferred schedule.

5. Final Setup for Ongoing Alerts

Now that your integration is tested and functional, you need to configure Pabbly Connect to run this automation regularly. Set a schedule to check the Google Sheets data daily, ensuring that subscribers receive their alerts one day before their subscription expires.

To do this, use the ‘Schedule’ trigger in Pabbly Connect. Specify the time you want the integration to run and select the frequency (e.g., daily). This automation will now run in the background, sending WhatsApp alerts without any manual intervention. Remember to:

Monitor the broadcast history in Vati to track message deliveries. Adjust any parameters in Pabbly Connect as needed based on subscriber feedback.

Your system is now fully automated, ensuring that all subscribers receive timely reminders about their TV subscription expirations.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to send WhatsApp alerts for expiring TV subscriptions directly from Google Sheets. By following the steps outlined, you can automate reminders efficiently and ensure subscribers are notified in a timely manner. This integration not only saves time but also enhances customer engagement.