Automate Certificate Sending with Pabbly Connect Based on Quiz Results

Learn how to automate sending certificates based on quiz results using Pabbly Connect, Google Forms, and Gmail. Step-by-step tutorial included. 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 Automation

To start automating the sending of certificates based on quiz results, first access Pabbly Connect. Open your browser and navigate to the Pabbly Connect website. Here, you can either sign up for a new account or log in if you already have one.

Once signed in, you will reach the dashboard. Click on the ‘Create Workflow’ button to begin setting up your automation. You can name your workflow something descriptive like ‘Google Forms to Google Slides to Gmail’ to reflect the applications involved.

2. Setting Up the Trigger with Google Forms

The next step involves setting up the trigger in Pabbly Connect. Choose Google Forms as the application and select the trigger event as ‘New Response Received.’ This setup allows Pabbly Connect to capture responses from your quiz form.

• Select the Google Form you created for the quiz.
• Copy the webhook URL provided by Pabbly Connect.
• Link your Google Form to Google Sheets to store the responses.

After linking, ensure that the Google Sheets add-on for Pabbly Webhooks is installed and configured correctly to send data to Pabbly Connect each time a new response is submitted.

3. Filtering Quiz Results with Pabbly Connect

Once the trigger is set, the next step is to filter the quiz results. Use the ‘Text Formatter’ feature in Pabbly Connect to extract the score from the Google Forms response. This allows you to check if the score is above the threshold, which is six points in this case.

• Select ‘Text Formatter’ and choose the action event as ‘Split Text’.
• Map the score response from Google Forms to this action.
• Set the separator as ‘/’ to split the score from the total.

After splitting the score, set up a filter condition using the ‘Filter’ feature in Pabbly Connect to continue the automation only if the score is greater than six.

4. Generating Certificates Using Google Slides

After filtering the quiz results, you can generate certificates using Google Slides within Pabbly Connect. Choose Google Slides as the action app and select the action event as ‘Create Presentation from Template’.

Connect your Google Slides account and select the certificate template you’ve created. Map the participant’s name and score to the appropriate fields in the template to personalize the certificate for each user.

5. Sending Certificates via Gmail

The final step in this automation process is to send the generated certificate via email using Gmail. In Pabbly Connect, select Gmail as the action application and choose the action event ‘Send Email’.

Map the recipient’s email address from the Google Forms response to ensure the certificate is sent to the correct person. Customize the email subject and body, and include the PDF link of the certificate as an attachment.

Conclusion

In this tutorial, we explored how to automate sending certificates based on quiz results using Pabbly Connect, Google Forms, and Gmail. By following these steps, you can streamline your workflow and enhance user engagement effectively.