When task information matching specific conditions is added to Google Sheets, analyze it with ChatGPT and notify Microsoft Teams
When task information matching specific conditions is added to Google Sheets, analyze it with ChatGPT and notify Microsoft Teams
Launch this workflow to connect
Microsoft Teams &
ChatGPT &
Google Sheets
!
■Overview
When managing tasks in Google Sheets, reviewing the contents and manually notifying the relevant people every time new information is added is time-consuming and can easily lead to missed follow-ups. With this workflow, whenever a row that meets specific conditions is added to Google Sheets, ChatGPT analyzes the contents and automatically sends a notification to Microsoft Teams. This automates the task-sharing process, enabling fast and accurate information delivery.
■Recommended for
- Anyone manually managing tasks in Google Sheets and sending notifications through Microsoft Teams
- Anyone looking to automate task summaries and assignee allocation with ChatGPT
- Project leaders who want to streamline information sharing across multiple tools and improve team productivity
■Benefits of using this template
- Automate the entire process—from adding information to a spreadsheet to analyzing the contents and sending notifications—so you can reduce the time spent on manual reviews and communication.
- Eliminate manual data entry and notification tasks to help prevent human errors, such as sending messages to the wrong people or overlooking tasks.
■Workflow
- First, connect Google Sheets, ChatGPT, and Microsoft Teams with Yoom.
- Next, select Google Sheets as the trigger and set the “When a row is added” action, then specify the spreadsheet and sheet to monitor.
- Next, configure branching in the operation so that the workflow proceeds only when the added row meets specific conditions.
- Next, select ChatGPT in the operation and configure it to generate the notification message based on the information in the added row.
- Finally, select Microsoft Teams in the operation and configure it to send the text generated by ChatGPT to the specified channel.
※ “Trigger”: An action that starts the workflow. “Operation”: An action that runs a process within the workflow after the trigger starts.
■Customization options
- In the Google Sheets trigger settings, set the interval at which the workflow bot checks for newly added rows.
- You can set any conditions for sending notifications with the branching feature. For example, you can configure notifications to be sent only when a specific keyword is entered in a particular spreadsheet column.
- You can freely customize the notification message sent to Microsoft Teams, as well as the users and channels to mention, allowing you to configure notifications based on each task.
■Notes
- Connect Google Sheets, ChatGPT, and Microsoft Teams with Yoom.
- Microsoft 365 (formerly Office 365) offers home and business plans (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 important information about using Google Sheets as an app trigger, see “Important Notes on the Google Sheets Trigger for App Triggers.”
- Branching is an operation available on the Personal plan and above. On the Free plan, operations configured in the workflow bot that use branching will result in an error.
- Paid plans, such as the Personal plan, include a two-week free trial. During the free trial, you can use apps and features (operations) that are otherwise subject to restrictions.
- To run ChatGPT (OpenAI) actions, you need a paid OpenAI API plan. (You must be able to make payments when the API is used.)
- For details, see OpenAI’s “API Pricing” page.
- OpenAI charges for ChatGPT API usage based on the number of tokens used during API communication. An error will occur if you are unable to make payments when using the API.
Check Out Similar Templates!
Activate the Flow Bot at the end of each month to notify 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.
Analyze the content of Zendesk tickets using AI and send alerts to Microsoft Teams.
This is a business workflow that analyzes Zendesk tickets using AI with Yoom and sends alert notifications to Microsoft Teams. By quickly sharing important information and responding as a team, it supports the improvement of customer satisfaction.
See more
About the Apps
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.
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 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.
About the apps you use
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.
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 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.
No-Code API Actions
Executable API actions
Flowbot triggers
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
When a Message Is Created in a Thread
When a Row Is Added
When a Row Is Updated
Flowbot operations
Get Teams
Get Team Members
Get Channel List
Post a Message to a Channel
Send Message to Chat
Retrieve a List of Chats
Create Channel
Post a Message to a Channel (Mention a Channel)
Get User Presence
Reply to a Message Posted to a Channel
Create a Calendar Event
Get Folder Information
Download File
Add Member to Team
Get Replies to a Specific Message
Get Messages in a Specific Channel
Get User Information
Update Calendar Event
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 Channel
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 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 RowsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
