Create itineraries from Google Forms responses with an AI worker, log them in Google Sheets, and send notifications
Create itineraries from Google Forms responses with an AI worker, log them in Google Sheets, and send notifications
Launch this workflow to connect
Google Forms &
Google Sheets &
Microsoft Teams
!
■Overview
Travel planning can be a time-consuming and labor-intensive task, as it requires carefully understanding each customer's needs and creating the best possible itinerary based on that information. During busy periods, such as holidays when inquiries increase, manually creating plans may not keep up with demand, leading to delays in responding to customers.
With this workflow, when a response is submitted through Google Forms, an AI worker automatically creates a draft itinerary, records it in Google Sheets, and notifies Microsoft Teams—all in one seamless process. This enables you to make prompt proposals to customers while improving both the quality and speed of your service.
With this workflow, when a response is submitted through Google Forms, an AI worker automatically creates a draft itinerary, records it in Google Sheets, and notifies Microsoft Teams—all in one seamless process. This enables you to make prompt proposals to customers while improving both the quality and speed of your service.
■Who should use this template
- Travel agency representatives who want to reduce the time and effort required to create personalized itineraries for travel inquiries received through Google Forms
- Planners who want AI to support plan creation based on customer needs so they can focus on more creative proposals
- Team leaders who want to smoothly share customer information and proposed plans across their team using Google Sheets and Microsoft Teams
■Benefits of using this template
- AI instantly creates a draft itinerary from Google Forms responses, reducing the time spent planning and improving response times for customers.
- Created itineraries are automatically stored in Google Sheets and simultaneously shared through Microsoft Teams, helping prevent missed information and data entry errors.
■How the Flow Bot works
- First, connect Google Forms, Google Sheets, and Microsoft Teams to Yoom.
- Next, set Google Forms' “When a response is submitted” as the trigger.
- Finally, create a skill for the AI worker that uses the action to add a record to Google Sheets and the action to send a message to a Microsoft Teams channel as tools, with the instruction to “Create a draft travel itinerary based on the customer's needs, add it to Google Sheets, and send a message to a Microsoft Teams channel.”
※“Trigger”: An action that starts a flow. “Operation”: An action that processes information within a flow after the trigger starts.
■Customization options
■Customization options
- In the Google Forms settings, you can set any form as the trigger based on the information you want to collect, such as the destination, budget, and length of stay.
- Within the AI worker, you can freely customize the content of the draft output—such as specific sightseeing spot recommendations and time schedules—using prompts.
- You can configure the Microsoft Teams channel ID for notifications and the Google Sheets sheet name for storing information according to your organization's workflows.
■Notes
- Connect Google Forms, Google Sheets, and Microsoft Teams to Yoom. The tools (apps) used within the AI worker also require My Apps connections.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Please 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.
- Microsoft 365 (formerly Office 365) offers plans for home use and plans for general business use (Microsoft 365 Business). Authentication may fail if you are not subscribed to a general business plan.
- For basic AI worker setup instructions, see [AI Workers] How to set up the basics.
- The number of AI workers that can run simultaneously, the number of AI workers you can create, and the AI models available to you vary by plan.
- The apps and operations available within AI workers are subject to the same usage limits as Flow Bots.
- AI workers consume tasks during test runs just as they do during production runs. For details, see [AI Workers] How task executions are counted.
- AI workers are more likely to process tasks appropriately when their skills are configured in detail. For details, see [AI Workers] How to create skills (formerly manuals).
Check Out Similar Templates!
Have an AI worker regularly analyze Shopify inventory sell-through rates and notify stakeholders of recommended actions after consultation
This flow uses AI to regularly analyze your Shopify inventory data and recommend action plans based on sell-through rates. Refine your strategies through conversations with AI and send notifications to Slack—ideal for ecommerce leaders who want to streamline inventory management while making flexible, informed decisions.
Have AI Workers analyze Jira progress weekly, update the roadmap, and notify you only when risks are detected
Automate Jira progress tracking and Google Sheets roadmap updates with AI Workers.,At a scheduled time each week, AI retrieves and analyzes Jira ticket data, then automatically updates your Google Sheet with current progress and delay risks. Administrators simply review the analysis delivered to Slack to identify potential delays early. Eliminate tedious manual updates and focus your resources on faster decision-making and resolving critical issues.
Regularly add FAQ drafts from resolved Zendesk tickets to Google Docs
Automatically create FAQ drafts from daily Zendesk tickets and centralize them in Google Docs with this Flow Bot template. Turn valuable knowledge accumulated in customer support into FAQs—without the manual effort. AI regularly reviews resolved tickets and identifies frequently asked questions, helping you efficiently maintain an FAQ update cycle that reflects the latest user needs. Reduce the time spent gathering information and creating drafts, and ensure customers always receive accurate information.
When an employee is flagged as terminated in a Google Sheets tracker, an AI worker generates separation certificate data from the payroll ledger
Use updated employee departure information in Google Sheets to have an AI agent (AI worker) automatically generate separation notices from payroll ledgers and send notifications via Gmail. Eliminate manual data entry and calculations to reduce processing time and prevent input errors.
Register contract terms in Google Forms, then use an AI worker to review them, generate a contract, and notify Slack
Automate legal reviews and contract drafting with AI based on contract terms submitted through Google Forms. Accelerate approvals, prevent errors, and streamline the path to contract execution—reducing the workload on your legal team and improving operational efficiency.
Each day, the AI worker identifies travelers who need reminders and sends pre-departure emails after approval from the person in charge.
This template automatically identifies recipients who need reminders from Google Sheets, uses an AI worker to craft personalized messages for each person, and sends emails through Outlook after approval from the assigned owner. Reduce the risk of missed recipients and misdirected emails while delivering thoughtful follow-ups that improve customer satisfaction with minimal effort.
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.
Templates using
Microsoft Teams
A flow bot that automatically starts at the end of each month and sends notifications via Teams. This flow bot can perform various automated processes through the flows added after the branch on the right side. *For example, it can be used for various purposes such as monthly invoice issuance processing, aggregation processing to spreadsheets, or regular data backup processing.
You can add content posted in a specific room on Microsoft Teams to a Google Spreadsheet. By automating the transcription process, you can prevent human errors and improve work efficiency.
This is a business workflow that automatically adds members from Microsoft Teams posts to Google Workspace groups. It saves effort and streamlines group management.
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 Teams
Yoom allows you to utilize Microsoft Teams API without any coding. By integrating Teams with Yoom, you can automate notifications to Teams and automatically register events in the Teams calendar.
see detailsTemplates
A flow bot that automatically starts at the end of each month and sends notifications via Teams. This flow bot can perform various automated processes through the flows added after the branch on the right side. *For example, it can be used for various purposes such as monthly invoice issuance processing, aggregation processing to spreadsheets, or regular data backup processing.
Activate the Flow Bot at the end of each month to notify Microsoft Teams.
You can add content posted in a specific room on Microsoft Teams to a Google Spreadsheet. By automating the transcription process, you can prevent human errors and improve work efficiency.
Add content posted in a specific room on Microsoft Teams to a Google Spreadsheet.
This is a business workflow that automatically adds members from Microsoft Teams posts to Google Workspace groups. It saves effort and streamlines group management.
Add members to a group in Google Workspace from content posted on Microsoft Teams.
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 Message Is Sent to a Channel
When a Message Is Sent to a Chat
When an Event Is Added to the Calendar
When a Message with a File Is Sent to the Channel
When a Reply Is Posted in a Specific Message Thread
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 Message Is Sent to a ChannelWhen a Message Is Sent to a ChatWhen an Event Is Added to the CalendarWhen a Message with a File Is Sent to the ChannelWhen a Reply Is Posted in a Specific Message Thread
Flowbot operations
Get TeamsGet Team MembersGet Channel ListPost a Message to a ChannelSend Message to ChatRetrieve a List of ChatsCreate ChannelPost a Message to a Channel (Mention a Channel)Get User PresenceReply to a Message Posted to a ChannelCreate a Calendar EventGet Folder InformationDownload FileAdd Member to TeamGet Replies to a Specific MessageGet Messages in a Specific ChannelGet User InformationUpdate Calendar EventGet Events[For Next Page Link] Get EventsCreate a TeamDownload Meeting Recording DataGet Meeting InformationGet Meeting Recording ListRequest ApprovalGet Approval ListCancel ApprovalRetrieve a Message in a Specific ChannelMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!