How to Send Updates to Students on WhatsApp Using Pabbly Connect

Learn how to send automated updates to students on WhatsApp about upcoming tests using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WhatsApp Integration

To send updates to students on WhatsApp about upcoming tests, you will first need to access Pabbly Connect. Start by opening your browser and navigating to the Pabbly website, then sign in to your account.

Once logged in, click on the ‘Products’ icon and select ‘Connect’. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow, for instance, ‘Google Sheets to WhatsApp Messages’. This setup will facilitate the integration between Google Sheets and WhatsApp through Pabbly Connect.

2. Setting Up Google Sheets as the Trigger in Pabbly Connect

In this step, you will set Google Sheets as the trigger application. Click on the trigger window and choose ‘Google Sheets’ from the list of applications. Select the trigger event as ‘New Spreadsheet Row’. using Pabbly Connect

• Choose Google Sheets as the application.
• Select ‘New Spreadsheet Row’ as the trigger event.
• Copy the provided webhook URL.

After copying the webhook URL, go to your Google Sheet where student data is stored. Click on ‘Extensions’, go to ‘Add-ons’, and select ‘Get add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. Refresh the Google Sheet after installation, then navigate back to ‘Extensions’ and click on ‘Pabbly Connect Webhooks’ to set it up.

3. Configuring the Webhook in Google Sheets

In the initial setup of the Pabbly Connect Webhooks, paste the webhook URL you copied earlier. Specify the trigger column, which is the last column where data will be entered (for example, column D).

Next, click on ‘Send Test’ to send data from Google Sheets to Pabbly Connect. Ensure you have added a new row in your Google Sheet to test this functionality. If successful, you will see a confirmation that data has been sent.

• Paste the webhook URL in the setup.
• Set the trigger column to the last data entry column.
• Click ‘Send Test’ to confirm data transfer.

After confirming the test data is sent, ensure to check ‘Send on Event’ in the Pabbly Connect Webhooks to automate future updates. This will allow any new row added in Google Sheets to trigger a WhatsApp message automatically.

4. Retrieving Student Data from Google Sheets

Now, you will retrieve student data from Google Sheets using Pabbly Connect. In the action window, select Google Sheets again and choose the action event ‘Get Rows’. Connect your Google Sheets account when prompted.

After connecting, select the specific spreadsheet and the sheet that contains student data. Define the range of data you want to fetch. For dynamic data, ensure you do not set a fixed endpoint for the last row; instead, use a notation like ‘A2:E’ to include all future entries.

Select ‘Get Rows’ as the action event. Connect to your Google Sheets account. Define the range to fetch dynamic data.

Once the data is fetched, you will see the details in an array format. This will allow you to iterate through each row of data for sending WhatsApp messages.

5. Sending WhatsApp Messages Using Pabbly Connect

Your final step involves sending WhatsApp messages using the data collected via Pabbly Connect. Choose the application ‘Wati’ as your action app and select ‘Send Template Messages’ as the action event.

Connect your Wati account by providing the API endpoint and access token. You can find these in your Wati account under the API section. Once connected, map the WhatsApp number and select the message template you created earlier.

Select Wati as the action app. Map the WhatsApp number from the retrieved data. Choose the message template for updates.

After mapping all required fields, click ‘Save and Send Test Request’. You will receive a confirmation that the message has been sent, and you can check the WhatsApp account of your student to verify the update was received successfully.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate sending updates to students on WhatsApp about upcoming tests. By integrating Google Sheets with WhatsApp, you can streamline communication and keep your students informed effortlessly.