How to Generate PDF on Google Forms Submission & Send Email Automatically with Pabbly Connect

Learn how to automate PDF generation from Google Forms submissions and send emails using Pabbly Connect in this detailed tutorial. 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 automating the process of generating PDFs from Google Forms submissions, you first need to access Pabbly Connect. This platform allows you to integrate various applications seamlessly.

Visit the Pabbly Connect website, and if you’re a new user, click on ‘Sign Up Free’ to create an account. Existing users can simply sign in. Once logged in, you’ll be directed to the dashboard where you can create workflows to automate your tasks.

2. Creating a Workflow in Pabbly Connect

In this section, you’ll create a workflow in Pabbly Connect to handle Google Forms submissions. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard.

• Name your workflow: ‘Generate PDF on Google Form Submission and Send Email Automatically’.
• Select a folder to organize your workflows, such as ‘Automations’.
• Click on ‘Create’ to save your workflow and proceed.

This workflow will define how Pabbly Connect will react when a new response is received from your Google Form. Now, you need to set up the trigger for this workflow.

3. Setting Up Google Forms Trigger in Pabbly Connect

To capture new responses from Google Forms, you will set Google Forms as the trigger application in Pabbly Connect. Choose ‘Google Forms’ from the trigger application options.

Select the trigger event as ‘New Response Received’. This will ensure that every time a new response is submitted, Pabbly Connect captures it. You will then receive a webhook URL.

• Copy the webhook URL provided by Pabbly Connect.
• Open your Google Form and navigate to the responses section.
• Link the Google Form to Google Sheets to collect responses automatically.

Once the Google Form is linked, you can proceed to test the connection by submitting a dummy response to ensure everything is working correctly.

4. Generating PDF Using Google Docs and Pabbly Connect

After setting up the trigger, the next step is to generate a PDF ticket using a template in Google Docs. In this action step, select ‘Google Docs’ as the action application.

Choose the action event as ‘Create Document from Template’. This allows you to use a pre-defined template to create a new document for each registrant. Connect your Google Docs account to Pabbly Connect and select the template you have created for the event ticket.

Map the fields from the Google Form responses to the corresponding fields in your Google Docs template. Specify the location in Google Drive where the new document should be saved. Click ‘Save and Send Test Request’ to create a new document.

Once the document is created, you can check your Google Drive to ensure that the event ticket has been generated successfully.

5. Sending Email with Pabbly Connect

The final step in this automation process is to send the generated PDF ticket to the registrant’s email. In this action step, select ‘Gmail’ as the action application.

Choose the action event as ‘Send Email’. Connect your Gmail account to Pabbly Connect and fill in the required fields, such as the recipient’s email address, subject, and body of the email.

Map the registrant’s email from the Google Form response. Attach the PDF file link generated in the previous step. Click ‘Save and Send Test Request’ to send the email.

After sending the email, check the recipient’s inbox to verify that the email with the PDF attachment has been received successfully.

Conclusion

In this tutorial, we explored how to generate a PDF from Google Forms submissions and send it via email using Pabbly Connect. This automation streamlines the process, saves time, and ensures accuracy in event ticketing.

By integrating Google Forms, Google Docs, and Gmail through Pabbly Connect, you can enhance your event management efficiency significantly. Implement these steps to automate your workflows effectively.