Update Google Sheets based on Google Forms submissions and send via Outlook
Update Google Sheets based on Google Forms submissions and send via Outlook
Launch this workflow to connect
Google Forms
!
■Overview
Manually transferring inquiry and application details collected through Google Forms to Google Sheets, then notifying relevant stakeholders via Outlook, can be time-consuming and prone to input errors. With this workflow, a response submitted through Google Forms automatically updates the relevant record in Google Sheets and sends a notification email from Outlook. Eliminate tedious, repetitive tasks and focus on more important work.
■Who Should Use This Template
- Anyone who manually transfers Google Forms responses to Google Sheets every time
- Anyone who manually sends standard notification emails via Outlook after receiving form responses
- Anyone who wants to streamline operations by preventing manual data entry errors and missed notifications to stakeholders
■Benefits of This Template
- Automate the entire process—from receiving form responses to updating Google Sheets and sending emails—to reduce manual work.
- Prevent human errors such as data transfer mistakes and missed email notifications, improving operational accuracy.
■Flowbot Overview
- First, connect Google Forms, Google Sheets, and Outlook to Yoom.
- Next, select Google Forms as the trigger and set the action to “When a response is submitted to the form.”
- Then, set the Google Sheets “Update a record” action as an operation and update a specific record based on the form response.
- Finally, set the Outlook “Send an email” action as an operation and automatically send an email to the relevant stakeholders with the specified content.
※“Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger runs.
■Customization Options
- For the Google Forms trigger, set the flow execution interval and the target form ID as needed.
- For the Google Sheets “Update a record” action, specify the spreadsheet ID, sheet name, and table range to update. You can also define the conditions for identifying the record to update and set the new values using the form response and other data.
- For the Outlook “Send an email” action, you can freely configure the recipients, subject, body, and more. Use output data such as Google Forms responses to create dynamic emails.
■Notes
- Connect Google Forms, Google Sheets, and Outlook to Yoom.
- Microsoft 365 (formerly Office 365) offers plans for home users and businesses (Microsoft 365 Business). Authentication may fail if you are not subscribed to a business plan.
- You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- For information on how to retrieve response details when using Google Forms as a trigger, see “How to Retrieve Response Details with the Google Forms Trigger.”
Check Out Similar Templates!
Add Google Form responses to Google Sheets
When there is a response to a Google Form, the flow is to register the response in a Google Spreadsheet. Normally, when a response is submitted to a Google Form, the data is added to a specified Google Spreadsheet. However, in this flow, it is possible to add data to any specified Google Spreadsheet without complex settings in Google App Script. Additionally, it saves the effort of repeatedly entering data, allowing work to proceed smoothly, and records can be easily added to the Google Spreadsheet automatically, eliminating any gaps or omissions in information management.
Add Google Form responses to Notion and send event information via Gmail.
This is a business workflow that automatically adds Google Form responses to Notion and sends event information via Gmail. This streamlines data management and information dissemination, making event operations more efficient.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
When a response is submitted to a Google Form, an event is added to Google Calendar and an email is sent. This flow allows for seamless automation from adding the event to sending the email, using only the form responses.
See more
About the Apps
Google Forms
Related apps
Templates using
Google Forms
When there is a response to a Google Form, the flow is to register the response in a Google Spreadsheet. Normally, when a response is submitted to a Google Form, the data is added to a specified Google Spreadsheet. However, in this flow, it is possible to add data to any specified Google Spreadsheet without complex settings in Google App Script. Additionally, it saves the effort of repeatedly entering data, allowing work to proceed smoothly, and records can be easily added to the Google Spreadsheet automatically, eliminating any gaps or omissions in information management.
This is a business workflow that automatically adds Google Form responses to Notion and sends event information via Gmail. This streamlines data management and information dissemination, making event operations more efficient.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
When a response is submitted to a Google Form, an event is added to Google Calendar and an email is sent. This flow allows for seamless automation from adding the event to sending the email, using only the form responses.
About the apps you use
Google Forms
Yoom allows you to integrate with Google Forms API without any code, enabling you to automate various tasks. For example, you can notify Slack or Chatwork of information submitted via Google Forms, or automatically store information in CRMs like kintone or Salesforce.
see detailsTemplates
When there is a response to a Google Form, the flow is to register the response in a Google Spreadsheet. Normally, when a response is submitted to a Google Form, the data is added to a specified Google Spreadsheet. However, in this flow, it is possible to add data to any specified Google Spreadsheet without complex settings in Google App Script. Additionally, it saves the effort of repeatedly entering data, allowing work to proceed smoothly, and records can be easily added to the Google Spreadsheet automatically, eliminating any gaps or omissions in information management.
Add Google Form responses to Google Sheets
This is a business workflow that automatically adds Google Form responses to Notion and sends event information via Gmail. This streamlines data management and information dissemination, making event operations more efficient.
Add Google Form responses to Notion and send event information via Gmail.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
When a response is submitted to a Google Form, an event is added to Google Calendar and an email is sent. This flow allows for seamless automation from adding the event to sending the email, using only the form responses.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Form Response Is Submitted
Flowbot operations
Get Response List
Retrieve a Specific Response
Get Response List (Specify Response Period)
Get Form Questions
Update Form Title and Description
Update Question Titles and Descriptions
Create a New Form
Update Form Visibility Settings
Add a Short/paragraph Question (Title and Description)
Add a Choice Question (Radio, Checkbox, or Dropdown)
Add a Grid Question (Multiple-choice Grid / Checkbox Grid)
Add a Question Title and Description (Date/Time)
Add a Question Title and Description (Linear Scale)
Add a Question Title and Description (Image + Text)
Add a Question Title and Description (Image + Choice)
Add a Question Title and Description (Choices with Images)
Flowbot triggers
When a Form Response Is Submitted
Flowbot operations
Get Response ListRetrieve a Specific ResponseGet Response List (Specify Response Period)Get Form QuestionsUpdate Form Title and DescriptionUpdate Question Titles and DescriptionsCreate a New FormUpdate Form Visibility SettingsAdd a Short/paragraph Question (Title and Description)Add a Choice Question (Radio, Checkbox, or Dropdown)Add a Grid Question (Multiple-choice Grid / Checkbox Grid)Add a Question Title and Description (Date/Time)Add a Question Title and Description (Linear Scale)Add a Question Title and Description (Image + Text)Add a Question Title and Description (Image + Choice)Add a Question Title and Description (Choices with Images)More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
