How to Send Outlook Email on Google Forms Submission Using Pabbly Connect

Learn how to automate sending Outlook emails on Google Forms submission using Pabbly Connect. Step-by-step guide to streamline your workflow. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Forms and Outlook

To send Outlook emails on Google Forms submission, we will utilize Pabbly Connect. First, access the Pabbly Connect homepage by visiting Pabbly.com/connect. Here, you can either sign up for a new account or sign in if you are an existing user.

Once logged in, you will see the dashboard of Pabbly Connect. To create a new workflow, click on the ‘Create Workflow’ button at the top right corner. Name your workflow something descriptive, like ‘Send Outlook Email on Google Form Submission’ and select your preferred folder. This sets the foundation for your automation.

2. Configuring Google Forms as the Trigger in Pabbly Connect

In this step, we will configure Google Forms as the trigger application in Pabbly Connect. Select Google Forms from the list of applications and choose the trigger event as ‘New Response Received’. This ensures that every time a new form submission occurs, it will trigger the next action.

• Select Google Forms as the trigger application.
• Choose ‘New Response Received’ as the trigger event.
• Copy the generated webhook URL.

Now, head over to your Google Forms and set up your form fields (like name, email, and phone number). Ensure that the last field is required to capture complete responses. Then, link your Google Forms to a Google Sheets document where all responses will be stored. This is crucial for the next steps in Pabbly Connect.

3. Linking Google Sheets with Pabbly Connect

After setting up Google Forms, the next step is to connect Google Sheets with Pabbly Connect. In Google Sheets, navigate to ‘Extensions’, then ‘Add-ons’, and search for the ‘Pabbly Connect Webhooks’ add-on. Install this add-on to facilitate the connection.

Once installed, go back to ‘Extensions’ and select ‘Pabbly Connect Webhooks’. Click on ‘Initial Setup’ and paste the webhook URL you copied earlier. Set the trigger column to the last column of your data (e.g., Column D). This setup allows Pabbly Connect to capture the entire row of data when a new response is added.

• Paste the webhook URL in the initial setup.
• Set the trigger column to the appropriate column.
• Turn on the ‘Send on Event’ option.

After completing these steps, your Google Sheets will successfully send data to Pabbly Connect whenever a new Google Forms response is submitted. This integration is essential for automating the email sending process.

4. Sending Outlook Email via Pabbly Connect

Now that we have our trigger set up, let’s configure the action to send an email via Outlook using Pabbly Connect. Select Microsoft Office 365 as the action application and choose the action event as ‘Send Mail’. This allows you to send an email automatically whenever a new response is received.

To connect your Microsoft Office 365 account, click on ‘Connect’ and grant the necessary permissions. Once connected, you will need to fill in the email subject, content type, and body of the email. For the body, you can customize the message and use mapped fields from the Google Forms response to personalize the email.

Enter the email subject (e.g., ‘Successful Form Submission’). Map the recipient’s name and email address from the Google Forms data. Click on ‘Save and Send Test Request’ to finalize the setup.

After completing these steps, you will have successfully configured Pabbly Connect to send an Outlook email automatically for every Google Forms submission. This greatly enhances your workflow efficiency.

5. Testing and Verifying the Automation

To ensure everything is working correctly, perform a test submission on your Google Form. Enter test data and submit the form. Check your Google Sheets to verify that the response has been recorded. This confirms that the connection between Google Forms and Pabbly Connect is functioning properly.

Next, check your Outlook email to see if you received the email corresponding to the test submission. The email should contain the personalized message you set up earlier. This step is crucial to verify that the automated process is functioning as intended.

Once confirmed, you can confidently use this automation in your daily tasks. If you need to replicate this workflow, you can find the Clone Link in the description box below the video.

Conclusion

In this tutorial, we detailed how to use Pabbly Connect to send Outlook emails automatically upon Google Forms submissions. By integrating Google Forms with Microsoft Office 365 via Pabbly Connect, you can streamline your communication process effectively. This automation saves time and enhances your workflow efficiency.