Summarize Google Form responses with ChatGPT and send notifications to Microsoft Teams
Summarize Google Form responses with ChatGPT and send notifications to Microsoft Teams
Launch this workflow to connect
ChatGPT &
Google Forms &
Microsoft Teams
!
■Overview
Do you find it time-consuming to review and share survey responses or inquiries collected through Google Forms? When a large number of responses come in, reviewing each one, summarizing the key points, and notifying relevant stakeholders can become a significant burden. With this workflow, whenever a new response is submitted to Google Forms, ChatGPT automatically summarizes the content and sends a notification to the designated Microsoft Teams channel, helping you share information faster and reduce manual effort.
■Who Is This Template For?
- People who manually review and share information collected through Google Forms
- People who want to use ChatGPT to efficiently identify key points from large volumes of text
- Teams that use Microsoft Teams as their primary communication tool and want to speed up information sharing
■Benefits of Using This Template
- Automate the entire process—from submitting a response to Google Forms to summarizing it with ChatGPT and sending a notification to Microsoft Teams—to reduce the time spent sharing information manually.
- Eliminate manual copy-and-paste and data entry, helping prevent human errors such as input mistakes and missed notifications while improving data accuracy.
■Flow Bot Process
- First, connect Google Forms and ChatGPT to Yoom.
- Next, select Google Forms as the trigger, set the “When a response is submitted to a form” action, and specify the form you want to use.
- Then, select ChatGPT as the operation, set the “Generate text” action, and instruct it to summarize the Google Forms response as the input.
- Finally, select Microsoft Teams as the operation, set the “Send a message to a channel” action, and send the summary generated by ChatGPT to the designated channel.
※ “Trigger”: An action that starts a flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization Options for This Workflow
- With ChatGPT’s “Generate text” operation, you can freely customize the instructions (prompt) to specify the type of summary you want to generate. You can also fine-tune the output format, tone, and other details.
- For the Microsoft Teams notification operation, you can choose the team and channel where notifications are sent. You can also insert Google Forms responses, ChatGPT-generated summaries, and other variables into the message body to create clearer notifications.
- You can create
■Notes
- Connect Google Forms, Microsoft Teams, and ChatGPT to Yoom.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- For details on how to retrieve response content when using Google Forms as a trigger, see How to Retrieve Response Content with the Google Forms Trigger.
- To run ChatGPT (OpenAI) actions, you need an OpenAI paid API plan. (You must be able to make payments when the API is used.)
- OpenAI charges for ChatGPT API usage based on the number of tokens used during API communication. An error may occur if you are unable to make payments when using the API.
- Microsoft 365 (formerly Office 365) offers plans for home use and general business plans (Microsoft 365 Business). Authentication may fail if you are not subscribed to a general business plan.
Check Out Similar Templates!
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
# Translated Text
After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
Based on the information from Jotform, draft a contract using ChatGPT and add it to Google Docs.
This is a business workflow that automatically drafts contracts using ChatGPT based on Jotform data and adds them to Google Docs. It reduces effort and errors, streamlining the contract creation process.
See more
About the Apps
ChatGPT
Related apps
Templates using
ChatGPT
Create a reply to the received email using ChatGPT and notify the specified Slack channel.
The minutes added to the database will be summarized using ChatGPT, and a notification will be sent to the specified Slack channel.
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
# Translated Text After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
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.
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
ChatGPT
At Yoom, it is possible to automate various tasks by integrating with the ChatGPT API without any coding. For example, you can enable direct conversations with ChatGPT from chat tools like Slack or Chatwork, and easily integrate ChatGPT with other SaaS platforms without coding. ChatGPT can be utilized for various purposes such as summarizing meeting minutes, extracting text from email content, and creating product descriptions.
see detailsTemplates
Create a reply to the received email using ChatGPT and notify the specified Slack channel.
Create a reply draft for received emails using ChatGPT and notify on Slack.
The minutes added to the database will be summarized using ChatGPT, and a notification will be sent to the specified Slack channel.
Add the minutes added to the database to ChatGPT, summarize them, and notify on Slack.
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
# Translated Text After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
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.
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 Message Is Created in a Thread
When a Form Response Is Submitted
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
Generate Text
Generate Text (with Image)
Generate Text (Advanced)
Generate Text (Web Search)
Generate Text from Image URL
Convert Text to Audio File
Retrieve Model List
Create Thread
Add Message to Thread
Convert Audio File to Text (File Upload)
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
Flowbot triggers
When a Message Is Created in a Thread
Flowbot operations
Generate TextGenerate Text (with Image)Generate Text (Advanced)Generate Text (Web Search)Generate Text from Image URLConvert Text to Audio FileRetrieve Model ListCreate ThreadAdd Message to ThreadConvert Audio File to Text (File Upload)
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 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!
