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

Learn how to create Google Slides from Google Forms responses and share them via Gmail using Pabbly Connect. Follow this detailed tutorial for step-by-step guidance.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Slides 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 with your existing account or signing up for a free account if you’re a new user.

Once logged in, navigate to the dashboard where you can see various Pabbly applications. Click on ‘Access Now’ under Pabbly Connect to begin creating your workflow.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, click on the ‘Create Workflow’ button to start your automation. You will be prompted to name your workflow. Enter a name like ‘Create Google Slides from Google Form Responses’ and select a folder to save it in.

• Click on ‘Create’ to open the workflow window.
• Select Google Forms as your trigger application.
• Choose ‘New Response Received’ as the trigger event.

After setting the trigger, Pabbly Connect will provide a webhook URL. Copy this URL as you will need it to connect Google Forms to your workflow.

3. Connecting Google Forms to Pabbly Connect

Next, open your Google Forms and go to the ‘Responses’ section. Ensure your form is linked to a Google Sheets document. If not, click on ‘Link to Sheets’ to create that connection. using Pabbly Connect

• Open your linked Google Sheets.
• Go to ‘Extensions’ > ‘Add-ons’ > ‘Get Add-ons’.
• Search for ‘Pabbly Connect Webhook’ and install it.

After installation, go back to your Google Sheets, select ‘Pabbly Connect Webhook’ from the Add-ons menu, and choose ‘Initial Setup’. Paste the webhook URL you copied earlier and set the trigger column to the last column in your sheet.

4. Creating Google Slides from Form Responses

Return to Pabbly Connect and continue with the action step. Select Google Slides as your action application and choose ‘Create Presentation from Template’ as the action event. Connect your Google Slides account if prompted.

Select the template you want to use for the certificate. Map the participant’s name from the Google Forms response. Set the new presentation’s location in Google Drive.

After configuring these settings, click on ‘Save and Send Test Request’ in Pabbly Connect. This step will create a new certificate in your Google Drive based on the responses received.

5. Sharing Certificates via Gmail

To share the created certificates, add another action step in Pabbly Connect. Select Google Drive and choose ‘Share a File with Anyone’ as the action event. Map the file ID from the previous step to ensure the correct certificate is shared.

Next, add a Gmail action and select ‘Send Email V2’. Map the recipient’s email address from the Google Forms response and customize the email content to include the participant’s name and the link to the certificate. Finally, click ‘Save and Send Test Request’ to send the email.

With this, your workflow is complete. Now, every time a new response is received in Google Forms, Pabbly Connect will automatically create a Google Slides certificate and send it via Gmail.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to create Google Slides from Google Forms responses and share them via Gmail. This integration streamlines the process of generating and distributing certificates efficiently.