■Overview
This is a flow that adds content posted in a specific room on Microsoft Teams to a Google Spreadsheet.
■Recommended for
1. Those who communicate daily using Microsoft Teams
・Administrative staff who share information on Microsoft Teams
2. Those who manage work using Google Spreadsheets
・Management department staff who manage information on Google Spreadsheets
■Benefits of using this template
If you are manually transferring data to Google Spreadsheets, there is a possibility of human errors such as transcription mistakes or omissions.
Moreover, manual transcription takes time away from tasks that should be prioritized, making it inefficient.
This template allows you to automatically append content posted on Microsoft Teams to a Google Spreadsheet.
By automating the transcription process, you can prevent human errors and improve work efficiency.
■Notes
・Please integrate both Microsoft Teams and Google Spreadsheets with Yoom.
・Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may fail.
・AI operations are only available with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operation of the flow bot you set will result in an error, so please be careful.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).


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 registered in the calendar
When a message with a file is sent to the channel
When a reply is posted in a specific message thread
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete Columns
When a message is sent to a channel
When a message is sent to a chat
When an event is registered in the calendar
When a message with a file is sent to the channel
When a reply is posted in a specific message thread
Get List of Teams
Retrieve Team Members List
Get List of Channels
Send Message to Channel
Send Message to Chat
List chats
Create Channel
Add Members to Private Channel
Send Message to Channel (Mention in Channel)
Create Event in Calendar (Deprecated)
Get User Presence
Reply to Channel Message
Create Calendar Event
Retrieve Folder Information
Download File
Add Member to Team
Retrieve List of Replies to a Specific Message
Retrieve List of Messages in a Specific Channel
Retrieve user information