Send Examination Results on WhatsApp from Google Sheets Using Pabbly Connect

Learn how to send examination results on WhatsApp from Google Sheets using Pabbly Connect. Step-by-step tutorial to automate your process! This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start sending examination results on WhatsApp from Google Sheets, first, you need to access Pabbly Connect. Open your browser and go to Pabbly Connect. If you don’t have an account, create one for free in just a couple of minutes.

Once you sign in, you will see the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button and name your workflow, for instance, ‘Results on WhatsApp’. This will set up the foundation for your automation process.

2. Setting Up the Trigger in Pabbly Connect

The next step involves configuring the trigger in Pabbly Connect. In the trigger application, search for ‘Google Sheets’ and select it. For the trigger event, choose ‘New or Updated Spreadsheet Row’. This event will monitor any new entries or updates in your Google Sheets.

• Select the Google Sheets account where your examination results are stored.
• Copy the Webhook URL provided by Pabbly Connect.
• Go to your Google Sheets, click on Extensions, then Add-ons, and select Get Add-ons.

Search for ‘Pabbly Connect Webhooks’ and install this add-on. After installation, refresh your Google Sheets. Go back to Extensions, find Pabbly Connect Webhooks, and click on Initial Setup. Paste the copied Webhook URL and set the trigger column to the last column of your data. Click ‘Send Test’ to verify the setup.

3. Sending Examination Results via WhatsApp Cloud API

Now that the trigger is set, it’s time to configure the action step using Pabbly Connect. For the action application, search for ‘WhatsApp Cloud API’ and select it. Choose the action event as ‘Send Template Message’.

• Connect your WhatsApp Cloud API account by entering the necessary credentials like token and phone number ID.
• Select the template message you created for sending results.
• Map the necessary fields such as student name, class, percentage, and result status from the Google Sheets data.

After mapping all required fields, click on ‘Save and Send Test Request’. This will send the WhatsApp message to the student’s number with their examination results. Check the WhatsApp account to confirm receipt of the message.

4. Automating the Process for Future Entries

To ensure that future entries in your Google Sheets are automatically sent via WhatsApp, you can enable the ‘Send on Event’ feature in Pabbly Connect. This allows the automation to trigger every time a new entry is added to the sheet.

Simply return to Google Sheets, go to Extensions, find Pabbly Connect Webhooks, and select ‘Send on Event’. This will ensure that whenever you add a new student’s results, the corresponding WhatsApp message is sent automatically.

5. Testing and Verifying Your Automation Setup

After setting everything up, it’s crucial to test the automation process. Add a new student’s examination results in Google Sheets and verify if the WhatsApp message is sent successfully via Pabbly Connect.

For instance, if you enter a new student named Nitin Kumar with his details, the automation should send a WhatsApp message to his number instantly. This confirms that your integration between Google Sheets and WhatsApp Cloud API through Pabbly Connect is functioning correctly.

Conclusion

In this guide, we explored how to send examination results on WhatsApp from Google Sheets using Pabbly Connect. By automating this process, you can save time and ensure that students receive their results promptly. Implementing this integration can revolutionize how educational institutions communicate with their students.