Automate Sending Content Based on User’s Choice with Pabbly Connect: Google Forms to Gmail

Learn how to automate sending content based on user choices in Google Forms using Pabbly Connect and Gmail. Step-by-step guide included. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Forms Integration

To automate sending content based on user choices in Google Forms, start by accessing Pabbly Connect. This platform serves as the central hub for integrating various applications, including Google Forms and Gmail.

Begin by signing up for a free account on Pabbly Connect. Once logged in, navigate to the dashboard and click on ‘Create Workflow’. Name your workflow, for instance, ‘Google Forms to Gmail’, to keep it organized. This setup will allow you to capture form submissions directly into Pabbly Connect.

2. Connecting Google Forms to Pabbly Connect

The next step involves linking your Google Forms account to Pabbly Connect. In your workflow, locate the Trigger window and select Google Forms from the app list. Choose the event ‘New Response Received’ to initiate the connection.

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

Next, link this webhook URL to your Google Forms. Go to the Responses tab in your form, click on ‘Link to Sheets’, and create a new spreadsheet. This spreadsheet will store all the responses from your form submissions. Make sure to install the Pabbly Connect Webhooks add-on in Google Sheets to facilitate this connection.

3. Configuring the Webhook in Google Sheets

After installing the Pabbly Connect Webhooks add-on, go back to your Google Sheets. Under Extensions, find Pabbly Connect Webhooks and select ‘Initial Setup’. Here, you will need to configure the sheet and the trigger column.

• Select the sheet containing your form responses.
• Paste the copied webhook URL into the designated field.
• Specify the trigger column (the last column with data).

After completing these steps, your Google Sheets will be able to send form submission data to Pabbly Connect automatically. This connection is crucial for enabling the automation process.

4. Sending Emails with Gmail via Pabbly Connect

With the Google Forms and Sheets connected to Pabbly Connect, the next step is to set up the action to send emails via Gmail. In the action window of your workflow, select Gmail as the app and choose the action event ‘Send Email’.

Connect your Gmail account to Pabbly Connect by clicking ‘Connect’ and authorizing the necessary permissions. Once connected, map the recipient’s email address from the form submission data. This ensures that the email is sent to the correct user.

5. Finalizing the Automation Process

After configuring the Gmail action, you will need to customize the email content. Set the email subject to include the product name selected by the user in the Google Form. For the email body, create a message that includes a greeting and the brochure link corresponding to the selected product.

Finally, test the workflow by submitting a new response in your Google Form. Check your Gmail account to confirm that the email with the product brochure has been sent successfully. This confirms that Pabbly Connect is effectively automating the process.

Conclusion

In this tutorial, we explored how to automate sending content based on user choices in Google Forms using Pabbly Connect and Gmail. By following these steps, you can streamline your communication process and enhance user experience.