How to Send Email on Google Forms Submission using Google Generative AI with Pabbly Connect

Learn how to automate sending emails on Google Forms submissions using Google Generative AI and Pabbly Connect with our step-by-step tutorial. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To send emails on Google Forms submission using Google Generative AI, you first need to access Pabbly Connect. This platform allows you to automate tasks across different applications seamlessly. Start by visiting the Pabbly Connect website and signing in or signing up if you are a new user.

Once you are logged in, you will see the Pabbly Connect dashboard. Here, you can create a new workflow which will be the foundation for your integration. Click on the ‘Create Workflow’ button to begin setting up your automation.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a workflow to automate the email sending process. Name your workflow something like ‘Send Email on Google Form Submission using Google Generative AI’. This will help you identify the workflow later on. After naming your workflow, select a folder for organization purposes. using Pabbly Connect

• Click on the ‘Create’ button to finalize your workflow.
• You will then see options for setting up your trigger and action steps.

Next, you will set up the trigger application as Google Forms. Choose the trigger event as ‘New Response Received’. This allows Pabbly Connect to listen for new submissions from your Google Form.

3. Connecting Google Forms to Pabbly Connect

To connect Google Forms to Pabbly Connect, you will receive a webhook URL. This URL is essential for linking your Google Form to Pabbly Connect. Copy this URL, as you will need it shortly. In your Google Form, navigate to the responses section and link it to Google Sheets.

Next, create a new spreadsheet where the responses will be stored. Ensure that the fields in the spreadsheet match the questions in your Google Form. After setting up the spreadsheet, go back to your Google Form and click on the ‘Extensions’ tab. From there, select ‘Add-ons’ and search for Pabbly Connect Webhooks to install it.

4. Setting Up the Webhook in Google Sheets

Once the Pabbly Connect Webhooks add-on is installed, you need to perform the initial setup. Click on the ‘Extensions’ tab again, find Pabbly Connect Webhooks, and choose ‘Initial Setup’. Here, paste the webhook URL you copied earlier and specify the trigger column, which typically is the last column where data will be added. using Pabbly Connect

• Enter the trigger column as G or the relevant final column for your data.
• Click ‘Submit’ to save the configuration.

After submitting, you can send a test to ensure the setup is working correctly. Once you receive a successful response in Pabbly Connect, your Google Sheets and Google Forms are now linked through Pabbly Connect.

5. Generating Email Content Using Google Generative AI

Now that your Google Forms and Sheets are connected, it’s time to set up the action step using Google Generative AI. In Pabbly Connect, select Google Generative AI as your action application and choose ‘Generate Content’ as the action event. You will need to connect your Google Generative AI account by entering your API key, which you can obtain from the Google AI Studio. using Pabbly Connect

After connecting, you will enter a prompt for generating the email body. This prompt should include dynamic fields from the Google Form responses. For example, you might say, ‘I am giving you some details of a user from a feedback Google Form submission. Write a compelling thank you email based on the feedback description from ABC Company.’

Finally, you will map the relevant fields such as full name, feedback type, and feedback description from the Google Sheets to personalize the email content. Once the content is generated, you can proceed to set up the next action step to send the email via Gmail.

Conclusion: Sending Email via Gmail

In the final step, you will select Gmail as your action application in Pabbly Connect and choose ‘Send Email’ as the action event. Connect your Gmail account and map the recipient’s email address from the Google Sheets. Customize the email subject and sender name, and map the email body generated by Google Generative AI.

After completing all the fields, click on ‘Save and Send Test Request’. You should receive a confirmation that the email was sent successfully. This entire process demonstrates how Pabbly Connect can seamlessly integrate Google Forms with Google Generative AI and Gmail to automate email communications based on user feedback submissions.

By following these steps, you can efficiently set up automated email responses for any Google Form submissions using Pabbly Connect, enhancing your customer communication and workflow automation.