How to Send Google Forms Responses to Multiple Email Addresses | Pabbly Connect Tutorial

Learn how to use Pabbly Connect to automatically send Google Forms responses to multiple email addresses. Step-by-step guide for seamless integration. 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. Setting Up Pabbly Connect for Google Forms Integration

To start sending Google Forms responses to multiple email addresses, you need to set up Pabbly Connect. This platform will automate the process, ensuring that every form submission triggers an email notification. Begin by signing up for a free account on Pabbly Connect and logging into your dashboard.

Once you are on the Pabbly Connect dashboard, click on the ‘Create Workflow’ button. Name your workflow, for example, ‘Google Form to Gmail’. Select the folder where you want this workflow to be saved, and then click ‘Create’. This step is crucial as it lays the foundation for your automation.

2. Creating a Trigger in Pabbly Connect

The next step involves setting up a trigger to capture responses from Google Forms. In Pabbly Connect, you will need to choose Google Forms as your app. Select the trigger event as ‘New Response Received’. Click on ‘Connect’ to establish a connection between your Google Forms and Pabbly Connect.

• Choose Google Forms from the app list.
• Select ‘New Response Received’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, navigate to your Google Forms account. Link your Google Form to a new Google Sheet where responses will be collected. Ensure that the last question of your form is marked as required. This setup is essential for the automation to work effectively.

3. Connecting Google Sheets with Pabbly Connect

In order to send responses to multiple email addresses, you will connect the Google Sheet that stores your form responses with Pabbly Connect. Open the Google Sheet linked to your form and go to ‘Extensions’. Select ‘Add-ons’ and then ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, refresh your Google Sheet. Go back to ‘Extensions’, hover over ‘Pabbly Connect Webhooks’, and click on ‘Initial Setup’. In the dialog box, paste the webhook URL you copied earlier, select the appropriate sheet, and enter the trigger column (the last column with data). Click ‘Submit’ to finalize the setup.

4. Sending Emails Using Pabbly Connect

Now that you have set up the trigger, it’s time to configure the action that will send emails. In Pabbly Connect, choose Gmail as your action app and select ‘Send Email’ as the action event. Connect your Gmail account to Pabbly Connect, which will be used to send the emails. using Pabbly Connect

• Enter recipient email addresses separated by commas.
• Set the email subject using dynamic fields from the form responses.
• Compose the email body, including all necessary details from the form submission.

Make sure to map the fields from the Google Form responses into the email content. This includes the employee name, department, asset type, and description. Once everything is set up, click ‘Save and Send Test Request’ to check if the email is sent correctly.

5. Testing the Integration

After configuring the email settings, it’s time to test your integration. Go back to your Google Form and submit a test response. Once submitted, Pabbly Connect should capture the response and send an email to the specified addresses automatically. Check your inbox to confirm that the email was received.

This step verifies that your Pabbly Connect automation is functioning correctly. If the email is sent successfully, you can be assured that the integration works as intended. You can also make adjustments if needed, such as adding more recipients or modifying the email content.

Conclusion

By following these steps, you can effectively use Pabbly Connect to automate the process of sending Google Forms responses to multiple email addresses. This integration streamlines communication and ensures that all relevant teams receive timely notifications.