How to Share Google Forms Responses with Attachments via Gmail Using Pabbly Connect

Learn how to automate sharing Google Forms responses with attachments via Gmail using Pabbly Connect. Follow our step-by-step tutorial for seamless integration. 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. Accessing Pabbly Connect for Google Forms Integration

To share Google Forms responses with attachments via Gmail, we will utilize Pabbly Connect. Start by visiting the Pabbly Connect homepage by browsing to the URL provided. If you are a new user, click on the ‘Sign Up Free’ button to create an account and get 100 free tasks for your automation needs.

If you are an existing user, simply click on the ‘Sign In’ button. Once logged in, you will be directed to the Pabbly Connect dashboard where you can create new workflows to automate your processes.

2. Creating a Workflow in Pabbly Connect

After accessing the dashboard, click on the ‘Create Workflow’ button located at the top right corner. This will open a dialog box where you can name your workflow. For this integration, name it ‘Share Google Forms Responses with Attachments via Gmail’ and select your desired folder. using Pabbly Connect

• Click on the ‘Create’ button to initiate your workflow.
• Set the trigger application to Google Forms and select ‘New Response Received’ as the trigger event.
• Copy the provided webhook URL for connecting your Google Forms.

With the webhook URL copied, you can proceed to set up your Google Forms to send responses directly to Pabbly Connect.

3. Setting Up Google Forms to Work with Pabbly Connect

In your Google Forms, ensure you have created a form that collects responses, including file uploads. Click on the ‘Responses’ tab and then select the option to link your form to Google Sheets by clicking on ‘Link to Sheets’ and creating a new spreadsheet. using Pabbly Connect

• Go to ‘Extensions’ in Google Sheets, click on ‘Add-ons’, and search for ‘Pabbly Connect Webhooks’.
• Install the add-on if you haven’t done so already.
• After installation, return to ‘Extensions’ and select ‘Pabbly Connect Webhooks’ followed by ‘Initial Setup’.

Paste the copied webhook URL into the designated field and enter the trigger column as the last data column (e.g., column E). This setup allows Pabbly Connect to receive data whenever a new response is submitted.

4. Configuring Gmail to Send Responses with Attachments

Next, return to your Pabbly Connect workflow and set up the action step. Select Gmail as your action application and choose ‘Send Email’ as the action event. Connect your Gmail account by clicking on ‘Connect’ and following the prompts to allow Pabbly Connect access. using Pabbly Connect

Enter the recipient’s email address for receiving the notifications. Set the email subject as ‘New Participation’ and write the email content notifying about the new submission. Attach the file link received from Google Drive to the email.

After completing these fields, click on ‘Save and Send Test Request’ to verify that the email is sent correctly with the attached file.

5. Testing the Integration Setup

To ensure everything is functioning properly, submit a test response through your Google Form. Enter details such as name, email, phone number, and upload a file. After submission, check your Google Sheets to confirm that the response appears correctly.

Next, check your Gmail to confirm that you received an email notification with the participant’s details and the file attached. This confirms that your automation is working seamlessly through Pabbly Connect.

Repeat the test process with different entries to ensure consistent functionality. You can also modify the email content or recipient details as needed.

Conclusion

In this tutorial, we demonstrated how to share Google Forms responses with attachments via Gmail using Pabbly Connect. By following these steps, you can automate the process of sending email notifications with file attachments, enhancing your workflow efficiency.