How to Automatically Add Messages Posted in a Specific Microsoft Teams Channel to Notion

[About Yoom]

How to Create an Integration Flow between Microsoft Teams and Notion

This time, we will introduce how to set up a flow to "Add content posted in a specific room in Microsoft Teams to a Notion database".
The process consists of only 3 steps, so you can set it up in 10-15 minutes.

1. Setting up a flow bot that triggers when a new message is posted in a room
2. Setting up an operation to extract data from text
3. Setting up an action to add a record

If you are not using Yoom, please register for free here.
If you are already using Yoom, make sure to log in.

How to Connect Microsoft Teams and Notion with Yoom

Register your My Apps to connect Microsoft Teams and Notion with Yoom.
Registering My Apps in advance will make the subsequent automation settings easier.
First, let's start with registering My Apps for Microsoft Teams.

Click "My Apps" → "New Connection" on the left side of the Yoom screen.
Search for Microsoft Teams from "Search by App Name" or find it from the app list.

※ There are personal and business plans (Microsoft 365 Business) for "Microsoft 365 (formerly Office 365)". If you do not have a business plan, authentication from Yoom may not work properly, so please be careful.

Once you transition to the following screen, please sign in to Microsoft Teams.

Next, register My Apps for Notion, and select Notion in the same way as before.
You will transition to the following screen, so click the blue button "Select a Page".

Once you transition to the following screen, check the page you want to allow access to, and click "Allow Access".

If Microsoft Teams and Notion are displayed in your My Apps section, the My Apps registration is complete.

How to Add Content Posted in a Specific Room in Microsoft Teams to a Notion Database

To set up automation, click "Try it" on the banner below.

Read the following screen display and click "OK".

Proceed to the following screen and check "Title" → "Description".
If you want to make changes, click on the relevant section to modify it.
Start with the Microsoft Teams settings, and click "When a new message is posted in the room".

Once you proceed to the following screen, check the settings.

• "Title" → Can be changed as needed
• "Account information linked with Microsoft Teams" → Confirm the account to be used
• "Trigger action" → When a message is sent to the channel
  

Move to the Microsoft Teams screen and set a message as an example at your discretion.
This time, let's extract a message with the following content as an example.

Return to the Yoom screen and click "Next".
Proceed to the following screen and configure the settings.

• "Trigger interval" → Can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
  ※ The shortest trigger interval you can set varies depending on your plan, so be sure to check that. It is generally recommended to use the shortest trigger interval available for your plan.
• "Team ID", "Channel ID" → Select from the options
• "Test" → "Test successful" → Click "Save".
  

Next, set up the extraction of Microsoft Teams message content by clicking "Extract data from text".
Use Yoom's operation and check the setup method here.
※ AI operations are only available in the Team Plan and Success Plan. In the case of the Free Plan or Mini Plan, the operation of the flow bot you set will result in an error, so please be careful.
Once you proceed to the following screen, check the settings.

• "Title" → Can be changed as needed
• "Conversion type" → Data extraction (2 tasks)
  

Read the following precautions before proceeding to the next settings.

Scroll down and check the settings for "Target text".
"Target text" → {{Message content}}
※ Since the text to be extracted is the message content, select the message content of the Microsoft Teams output. {{Message content}} ← This is the output.
It is already entered, so leave it as it is.

Proceed to the following screen and read the description under "Items to extract" and set it as desired.
As an example, the following items are entered.
"Test" → "Test successful" → Click "Save".

The Microsoft Teams output will be displayed as follows.

Next, set up Notion by clicking "Add record".
Once you proceed to the following screen, check the settings.

• "Title" → Can be changed as needed
• "Account information linked with Notion" → Confirm the account to be used
• "Execute action" → Add record
  

Move to the Notion screen and create item names to generate the extracted message.
※ Please use the table view.

This time, the item names are entered as follows.

Return to the Yoom screen, scroll down, and select "Database ID" from the options or enter it as described.

Proceed to the following screen and set the "Value of the record to be added".
Click the red frame of "Extract data from text" and enter the output that matches the item.
"Test" → "Test successful" → Click "Save".

Finally, click "Turn on trigger" to complete the automation setup.

Other Automation Examples with Microsoft Teams and Notion

In addition to the flow introduced this time, you can achieve various business automations by using the APIs of Microsoft Teams and Notion. All of them can be used with simple settings, so if you find something that interests you, please give it a try!

Automation Example Using Microsoft Teams

When there is a post on Microsoft Teams, ChatGPT responds

This is recommended when you need to respond quickly to a large number of inquiries on Microsoft Teams.
It will help reduce the burden on the person in charge.
‍

When there is a response to the survey form, add the response content to Microsoft Excel and notify Microsoft Teams

This is an excellent flow that automatically compiles the form content into Microsoft Excel and completes the notification process.
If you frequently conduct surveys, please give it a try.

Notify Slack when a message is sent to a Microsoft Teams channel

Recommended for those who use both Microsoft Teams and Slack as chat tools.
You can know that a message has been posted on Slack without opening Microsoft Teams.

Examples of Automation Using Notion

Retrieve Notion Information in Bulk Every Month and Record it in Google Docs

Once set up, data is automatically transferred to Google Docs every month, making it useful as a backup for Notion.

Add Gmail Received Content to Notion

This time, we explained how to add Microsoft Teams posts to Notion, but you can also change it to Gmail.
Try using it conveniently with the tools you usually use!

Create a folder in Microsoft SharePoint based on Notion information

In addition to adding data to Notion, it is also possible to synchronize Notion data with other tools.
It becomes even more convenient to use different flows depending on which tool you use as the main one.

Benefits of Integrating Microsoft Teams with Notion

Benefit 1: Streamline Message Management

By integrating Microsoft Teams with Notion, you can streamline message management.
For example, you can automatically add content posted in a specific room in Microsoft Teams to a Notion database.
Manually copying messages from Microsoft Teams to Notion can be cumbersome, right?
By automating this process, you can prevent forgetting or missing copies and use your time effectively.

Benefit 2: Prevent Mistakes in Chat Communication

Another advantage of integrating Microsoft Teams with Notion is the ability to prevent mistakes in chat communication.
Many people use Microsoft Teams for communication, especially in remote work scenarios.
When working remotely, the sheer volume of interactions can cause important messages to get buried, leading to potential oversights.
By linking the apps, you can automatically transfer the content of Microsoft Teams messages to Notion, making it less likely to miss important information.
This allows you to efficiently check message content even while working remotely.

Conclusion

In this article, we introduced the process of "adding content posted in a specific room in Microsoft Teams to a Notion database."
Integrating Microsoft Teams with Notion streamlines message management, enhancing accuracy and speeding up operations!
By utilizing template settings, you can also extract necessary information.
The usage is flexible, so feel free to set up templates in a way that suits you best!