How to Create Google Slides from Google Forms Responses & Share on Gmail Using Pabbly Connect

Learn how to automate the creation of Google Slides from Google Forms responses and share them via Gmail using Pabbly Connect. Step-by-step tutorial included. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Forms Integration

To create Google Slides from Google Forms responses, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website and signing in or signing up for a free account. This platform allows you to automate workflows without any coding knowledge.

Once logged in, navigate to the dashboard. Here, you will find various Pabbly applications, but for this tutorial, we will focus on Pabbly Connect. Click on ‘Access Now’ to get started with your workflow creation.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a new workflow in Pabbly Connect for automating the process. Click on the button labeled ‘Create Workflow’. You will be prompted to name your workflow and select a folder for it.

• Name your workflow: Create Google Slides from Google Form Responses
• Select the folder: Automations

After naming your workflow, click on ‘Create’. This will open the workflow window where you can set up your trigger and action. In this case, the trigger will be Google Forms, and the action will involve creating a Google Slides presentation.

3. Setting Up Google Forms Trigger in Pabbly Connect

Now that you have your workflow set up, it’s time to define the trigger. Search for Google Forms and select it as your trigger application. Choose the event as ‘New Response Received’. This will allow Pabbly Connect to capture new submissions from your Google Forms.

Upon selecting the trigger, Pabbly Connect will provide you with a webhook URL. Copy this URL and navigate to your Google Forms. Go to the ‘Responses’ tab and link it to Google Sheets, if not already done. Then, open the linked Google Sheets to set up the integration.

4. Connecting Google Sheets to Pabbly Connect

In your Google Sheets, you need to install the Pabbly Connect add-on to establish the connection. Go to Extensions > Add-ons > Get Add-ons, and search for Pabbly Connect Webhooks. Install it if you haven’t already.

• Open the Pabbly Connect Webhooks add-on.
• Paste the webhook URL you copied earlier.
• Set the trigger column to the last column of your data.

After completing these steps, click on ‘Submit’. This action will successfully connect your Google Forms to Pabbly Connect, enabling the transfer of data into your workflow.

5. Creating Google Slides and Emailing Certificates

Next, you will set up the action to create Google Slides. Search for Google Slides within Pabbly Connect and select the action event ‘Create Presentation from Template’. Choose your pre-designed template for the certificate.

Map the necessary fields such as the participant’s name from the Google Forms response to the template. This allows the presentation to dynamically include the participant’s name. After creating the presentation, add another action to share the file via Google Drive and send an email using Gmail. Map the file link to the email content to ensure the participant receives their certificate.

Conclusion

This tutorial demonstrates how to use Pabbly Connect to automate the creation of Google Slides from Google Forms responses and share them via Gmail. With these steps, you can efficiently manage participant certificates without manual effort.