Send WhatsApp Alerts on Expiring Wi-Fi Subscription from Google Sheets Using Pabbly Connect

Learn how to send WhatsApp alerts for expiring Wi-Fi subscriptions directly from Google Sheets using Pabbly Connect in this detailed 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 Google Sheets Integration

To start sending WhatsApp alerts for expiring Wi-Fi subscriptions, first log into Pabbly Connect. This platform will act as the central hub for integrating Google Sheets with WhatsApp.

Once logged in, navigate to the Pabbly Connect dashboard and click on the ‘Create Workflow’ button. Name your workflow something relevant, like ‘Google Sheets to WhatsApp Alerts’. This sets the stage for automating the process.

2. Connecting Google Sheets to Pabbly Connect

Next, you need to connect Google Sheets to Pabbly Connect. In the workflow, select Google Sheets as the trigger application. Choose the trigger event as ‘New Spreadsheet Row’ to monitor for new entries.

• Log in to your Google account when prompted.
• Select the spreadsheet containing your Wi-Fi subscription data.
• Ensure the data range is set correctly to capture customer details.

After setting this up, click on ‘Save and Send Test Request’ to ensure Pabbly Connect can retrieve data from your Google Sheets. This step is crucial as it establishes the connection between your data source and the automation workflow.

3. Scheduling Alerts for Expiring Subscriptions

Now that Google Sheets is integrated, you need to set up a schedule in Pabbly Connect to send alerts one day prior to subscription expirations. For this, select the ‘Schedule by Pabbly’ app as your next action.

Configure the schedule to run daily at a specific time. For instance, if you want to send alerts at 5 PM IST, remember to convert it to UTC, which would be 11 AM UTC. This ensures that your alerts are sent out at the correct time.

4. Sending WhatsApp Alerts Using Pabbly Connect

The final step involves sending WhatsApp messages through Pabbly Connect using the Wati app. After setting the schedule, add Wati as your action application and choose ‘Send Template Message’ as the action event.

Fill out the necessary fields like WhatsApp number, template name, and custom parameters. For example, include the customer’s name, service name, expiration date, and a renewal link in the message template. This personalization increases the chances of customer engagement.

• Use the approved template from your Wati account for sending messages.
• Ensure to include a unique broadcast name for tracking.
• Test the message to confirm delivery.

After configuring these settings, click ‘Save and Send Test Request’ to ensure the WhatsApp message is sent correctly. This completes your automation setup!

5. Conclusion: Automate Your Wi-Fi Subscription Alerts

By following this tutorial, you can effectively automate WhatsApp alerts for expiring Wi-Fi subscriptions using Pabbly Connect. This integration not only saves time but also enhances customer communication, ensuring they are reminded to renew their subscriptions promptly.

Utilizing tools like Pabbly Connect can significantly improve your operational efficiency. Start automating your workflows today for better customer engagement!