Add a record to Google Sheets and send it to Outlook when a Google Form is submitted
Add a record to Google Sheets and send it to Outlook when a Google Form is submitted
Launch this workflow to connect
Google Forms &
Google Sheets &
Microsoft Outlook
!
■Overview
Manually transferring inquiries and survey responses received through Google Forms to Google Sheets and notifying relevant stakeholders via Outlook can be time-consuming.
With this workflow, whenever a response is submitted through Google Forms, a record is automatically added to Google Sheets and the relevant stakeholders are notified via Outlook, helping streamline and automate the entire process.
■Recommended for
Manually transferring inquiries and survey responses received through Google Forms to Google Sheets and notifying relevant stakeholders via Outlook can be time-consuming.
With this workflow, whenever a response is submitted through Google Forms, a record is automatically added to Google Sheets and the relevant stakeholders are notified via Outlook, helping streamline and automate the entire process.
■Recommended for
- Anyone who finds it time-consuming to transfer and share responses received through Google Forms
- Anyone looking to streamline manual data entry into Google Sheets
- Anyone who wants to build a system for sharing form responses with relevant stakeholders via Outlook
■Benefits of this template
- From recording responses in Google Sheets to notifying stakeholders via Outlook, the entire process is automated when a response is submitted through Google Forms, reducing the time spent on manual tasks.
- Prevent human errors such as data transfer mistakes and missed notifications, helping improve operational accuracy.
■Flow
- First, connect Google Forms, Google Sheets, and Outlook to Yoom.
- Next, select Google Forms as the trigger and set the “When a response is submitted to the form” action.
- Then, select Google Sheets as an operation and set the “Add a record” action to record the form responses.
- Finally, select Outlook as an operation and set the “Send an email” action to notify the relevant stakeholders.
※ “Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization options
■Customization options
- In the Google Forms trigger settings, you can specify which form to include in the automation.
- You can freely configure which responses are added to which columns in Google Sheets, as well as the recipients and content of the email sent through Outlook.
■Notes
- Connect Google Forms, Google Sheets, and Outlook to Yoom individually.
- For information on how to retrieve responses when using Google Forms as a trigger, see How to retrieve responses with the Google Forms trigger.
- You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- 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.
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.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Microsoft Outlook
Related apps
Templates using
Microsoft Outlook
This is a flow that is triggered at the end of each month to send an email in Outlook. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
This is a business workflow that automatically adds Outlook email content as notes to HubSpot. By utilizing Yoom's API integration and AI, it reduces manual tasks and streamlines information management.
When an email is received in Outlook, create a reply with ChatGPT, save it as a draft, and send a notification
Automatically generate and save ChatGPT-powered reply drafts for incoming Outlook emails, then notify Microsoft Teams. Reduce workload, standardize reply quality, and lighten the burden on team members.
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.
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
Microsoft Outlook
Yoom allows you to integrate with Outlook's API without any code, enabling the automation of email sending from Outlook. For example, you can automatically send contracts and invoices created in Outlook, or automatically reply to inquiries from input forms using Outlook.
see detailsTemplates
This is a flow that is triggered at the end of each month to send an email in Outlook. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
Activate the flow bot at the end of each month to send an email in Outlook.
This is a business workflow that automatically adds Outlook email content as notes to HubSpot. By utilizing Yoom's API integration and AI, it reduces manual tasks and streamlines information management.
Add a note to HubSpot based on the content of an Outlook email
When an email is received in Outlook, create a reply with ChatGPT, save it as a draft, and send a notification
Automatically generate and save ChatGPT-powered reply drafts for incoming Outlook emails, then notify Microsoft Teams. Reduce workload, standardize reply quality, and lighten the burden on team members.
When an email is received in Outlook, create a reply with ChatGPT, save it as a draft, and send a notification
No-Code API Actions
Executable API actions
Flowbot triggers
When a Form Response Is Submitted
When a Row Is Added
When a Row Is Updated
When a Specific Subject Email Is Received
When an Email Is Received
When an Event Is Registered in the Calendar
When a Calendar Event Is Added or Updated
When a Task Is Created
When an Email Is Received
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)
Set a Value in a Cell
Get Values
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)
Flowbot triggers
When a Row Is AddedWhen a Row Is Updated
Flowbot operations
Set a Value in a CellGet ValuesClear ValuesCreate a New SpreadsheetCopy a Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet Sheet NamesApply a Formula to a RangeEnter Values in a RangeEmbed an Image in a CellSort by Specific ColumnHide a SheetAdd a Note to the Specified CellsInsert ColumnsDelete ColumnsWrite Values to Multiple ColumnsAdd Rows
Flowbot triggers
When a Specific Subject Email Is ReceivedWhen an Email Is ReceivedWhen an Event Is Registered in the CalendarWhen a Calendar Event Is Added or UpdatedWhen a Task Is CreatedWhen an Email Is Received
Flowbot operations
Create an Event in My CalendarCreate a CalendarCreate an Event in a Specified User's CalendarGet Email Attachment InformationDownload Email AttachmentsDelete Event from a Specific User's CalendarUpdate Event in a Specific User's CalendarDelete Event from My CalendarUpdate Event in My CalendarCreate Task (with Reminder Settings)Create a Task (Reminders Not Supported)Search Events in My CalendarSearch Events in a Specific User's CalendarFind Meeting TimesGet Calendar ViewRetrieve Mail MessagesMove MessageRetrieve a Specific MessageSearch Messages in a Specific FolderUpdate MessageFind a Specified User's Free/busy ScheduleRetrieve a Specified User's Calendar ViewRetrieve a Specified Group's Calendar ViewRetrieve a List of Members in a Specified GroupMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
