Automate Sending Online Test Paper Links to Students via WhatsApp Using Pabbly Connect

Learn how to automate sending online test paper links to students on WhatsApp using Pabbly Connect, the integration platform that simplifies your workflow. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To send online test paper links to students via WhatsApp, you need to set up Pabbly Connect. Start by visiting the Pabbly Connect dashboard at Pabbly.com/connect. Here, you can create a free account in just two minutes by clicking on the ‘Sign Up Free’ button.

After logging in, click on the ‘Access Now’ button for Pabbly Connect. From the dashboard, create a new workflow by clicking the ‘Create Workflow’ button. Name your workflow, such as ‘Send Test Papers on WhatsApp,’ and click on the ‘Create’ button to proceed.

2. Configuring the Scheduler in Pabbly Connect

In this step, you will set up the scheduler trigger in Pabbly Connect. Select the ‘Scheduler’ feature as your trigger. This allows you to run your workflow on a specific date and time. Choose the option to run the workflow once, and select the date for the test.

• Select the date for the test (e.g., 12th June).
• Input the time in UTC format (e.g., 4:00 for 9:30 AM IST).

After entering the date and time, click on ‘Save’. Your workflow is now scheduled to run at the specified date and time, ready to send messages to your students.

3. Integrating Google Sheets with Pabbly Connect

Next, you will integrate Google Sheets with Pabbly Connect to retrieve student details. In the action step, search for ‘Google Sheets’ and select the ‘Get Row’ action event. This action will retrieve the rows of student data needed for sending messages.

Click on ‘Connect’ and choose to add a new connection. Authenticate your Google account and grant access to Pabbly Connect. Once connected, select your spreadsheet containing student details, such as names and WhatsApp numbers.

• Select the spreadsheet (e.g., ‘Mathematics Paper Class One’).
• Specify the data range (e.g., A2:D5).

After selecting the spreadsheet and data range, toggle the ‘Simple Response’ option off to capture the data in array format. Click on ‘Save and Send Test Request’ to confirm the setup.

4. Using the Iterator Feature in Pabbly Connect

The Iterator feature in Pabbly Connect allows you to process each student’s data individually. After capturing the data from Google Sheets, add an action step and select ‘Iterator’. This will segregate the data row by row, enabling personalized messaging.

In the Iterator setup, choose the array from the previous step. Click on ‘Save and Send Test Request’ to see the segregated data for the first student. This process ensures that each student will receive their unique message.

5. Sending Messages via WhatsApp Cloud API

Finally, set up the action for sending WhatsApp messages using the WhatsApp Cloud API through Pabbly Connect. Search for ‘WhatsApp Cloud API’ and select the ‘Send Template Message’ action event. Connect to your WhatsApp Cloud API by entering the permanent access token, phone number ID, and business account ID.

Map the recipient’s phone number from the Iterator step and fill in the body fields with the necessary information. For example, include the student’s name and the examination link in the message template. Click on ‘Save and Send Test Request’ to send a test message to the student’s WhatsApp.

Ensure the message template is approved in WhatsApp. Verify that the message is sent successfully to the recipient.

Once confirmed, your workflow is ready to run automatically on the scheduled date, sending the test paper links to your students via WhatsApp.

Conclusion

By following these steps, you can easily automate the process of sending online test paper links to students on WhatsApp using Pabbly Connect. This integration not only saves time but also ensures that all students receive their test papers promptly.