There are times when you want to quickly share a new file added to Google Drive with members via Microsoft Teams. However, have you ever experienced being too busy with work to send a message promptly, or even forgetting to do so? If you have had such experiences, we recommend taking this opportunity to integrate Google Drive and Microsoft Teams!
That said, when it comes to integration, you might feel that "the setup seems difficult" or "an engineer's help might be needed." However, by utilizing the no-code tool Yoom, anyone can easily integrate Google Drive and Microsoft Teams and enable automatic data synchronization!
By achieving integration, you may be able to reduce the burden of manual tasks and prevent file sharing errors.
In this article, we will explain in detail what can be done with the integration of Google Drive and Microsoft Teams, as well as the specific setup procedures. If you want to automate file sharing with your team members, please read to the end!
For those who want to try it as soon as possible
By using Yoom, you can easily integrate Google Drive and Microsoft Teams with no code. Yoom provides templates for integrating Google Drive and Microsoft Teams in advance, so you can achieve integration immediately just by registering, even without API knowledge.
Notify Microsoft Teams when a new file is uploaded to Google Drive™.
■Overview The flow "Notify Microsoft Teams when a new file is uploaded to Google Drive™" is a business workflow that facilitates file sharing and team communication. Whenever a new file is added to Google Drive™, a notification is automatically sent to Microsoft Teams, allowing all team members to keep track of the latest file status in real-time. This reduces information sharing omissions and the effort of confirmation tasks, enabling efficient collaboration.
■Recommended for - Team leaders who use Google Drive™ and Microsoft Teams on a daily basis - IT personnel who want to automate file management and team communication - Business owners who want to enhance real-time information sharing and improve work efficiency - Business persons who feel that manual notification tasks are taking up time and preventing them from focusing on other tasks
■Cautions - Please integrate Yoom with both Google Drive and Microsoft Teams. - You can select a trigger interval from 5, 10, 15, 30, or 60 minutes. - Please note that the shortest trigger interval varies depending on the plan. - Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business), and authentication may fail if you are not subscribed to the general business plan. - Branching is a feature (operation) available with the Mini Plan or higher. With the Free Plan, operations set in the flowbot will result in an error, so please be careful. - A two-week free trial is available for paid plans like the Mini Plan. During the free trial, you can use restricted apps and features (operations).
What You Can Do by Integrating Google Drive and Microsoft Teams
By integrating the APIs of Google Drive and Microsoft Teams, you can automatically sync Google Drive data with Microsoft Teams!
For example, you can automatically perform data synchronization like the following without human intervention.
Notify Microsoft Teams When a New File is Uploaded to Google Drive
This flow is recommended for accounting personnel or project managers who frequently review documents! Since Microsoft Teams will notify you of file uploads, you can smoothly confirm and share files.
Notify Microsoft Teams when a new file is uploaded to Google Drive™.
■Overview The flow "Notify Microsoft Teams when a new file is uploaded to Google Drive™" is a business workflow that facilitates file sharing and team communication. Whenever a new file is added to Google Drive™, a notification is automatically sent to Microsoft Teams, allowing all team members to keep track of the latest file status in real-time. This reduces information sharing omissions and the effort of confirmation tasks, enabling efficient collaboration.
■Recommended for - Team leaders who use Google Drive™ and Microsoft Teams on a daily basis - IT personnel who want to automate file management and team communication - Business owners who want to enhance real-time information sharing and improve work efficiency - Business persons who feel that manual notification tasks are taking up time and preventing them from focusing on other tasks
■Cautions - Please integrate Yoom with both Google Drive and Microsoft Teams. - You can select a trigger interval from 5, 10, 15, 30, or 60 minutes. - Please note that the shortest trigger interval varies depending on the plan. - Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business), and authentication may fail if you are not subscribed to the general business plan. - Branching is a feature (operation) available with the Mini Plan or higher. With the Free Plan, operations set in the flowbot will result in an error, so please be careful. - A two-week free trial is available for paid plans like the Mini Plan. During the free trial, you can use restricted apps and features (operations).
Regularly Retrieve a List of Files in a Google Drive Folder and Post to Microsoft Teams
This flow is recommended for administrative staff who find file organization and management cumbersome. One of its attractions is the ability to regularly compile and review a list of files.
Regularly retrieve a list of files in a Google Drive folder and post it to Microsoft Teams.
■Overview The workflow "Periodically retrieve a list of files in a Google Drive folder and post it to Microsoft Teams" is an automation tool to streamline team file management and sharing. By regularly retrieving the latest file information stored in Google Drive and automatically posting it to a designated Microsoft Teams channel, all team members can grasp the latest file status in real-time. This reduces the hassle of information sharing and enhances the transparency of work.
■Recommended for ・Team leaders who use Google Drive daily and find file management cumbersome ・Those using Microsoft Teams for communication but find manually updating the latest file sharing information burdensome ・Project managers who want to constantly keep track of the file status of the entire team ・IT personnel who want to automate business workflows using Yoom for efficiency
■Notes ・Please link Google Drive, Microsoft Teams, and Yoom respectively. ・There are home plans and general business plans (Microsoft365 Business) for Microsoft365 (formerly Office365), and there may be authentication failures if you are not subscribed to the general business plan.
Let's Create a Google Drive and Microsoft Teams Integration Flow!
Let's dive in and create a flow that integrates Google Drive with Microsoft Teams!
This time, we'll use Yoom to proceed with the integration of Google Drive and Microsoft Teams without any coding. If you don't have a Yoom account yet, please issue one from the Yoom Registration Form.
[What is Yoom]
This time, we'll create a flow bot that "notifies Microsoft Teams when a new file is uploaded to Google Drive"!
The creation process is broadly divided into the following steps:
Integrate Google Drive and Microsoft Teams with My Apps
Copy the template
Set the trigger and action
Set the trigger to ON and prepare for flow operation
Notify Microsoft Teams when a new file is uploaded to Google Drive™.
■Overview The flow "Notify Microsoft Teams when a new file is uploaded to Google Drive™" is a business workflow that facilitates file sharing and team communication. Whenever a new file is added to Google Drive™, a notification is automatically sent to Microsoft Teams, allowing all team members to keep track of the latest file status in real-time. This reduces information sharing omissions and the effort of confirmation tasks, enabling efficient collaboration.
■Recommended for - Team leaders who use Google Drive™ and Microsoft Teams on a daily basis - IT personnel who want to automate file management and team communication - Business owners who want to enhance real-time information sharing and improve work efficiency - Business persons who feel that manual notification tasks are taking up time and preventing them from focusing on other tasks
■Cautions - Please integrate Yoom with both Google Drive and Microsoft Teams. - You can select a trigger interval from 5, 10, 15, 30, or 60 minutes. - Please note that the shortest trigger interval varies depending on the plan. - Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business), and authentication may fail if you are not subscribed to the general business plan. - Branching is a feature (operation) available with the Mini Plan or higher. With the Free Plan, operations set in the flowbot will result in an error, so please be careful. - A two-week free trial is available for paid plans like the Mini Plan. During the free trial, you can use restricted apps and features (operations).
First, register "Google Drive" and "Microsoft Teams" as My Apps.
Click "Add" on the right from "My Apps" on the left.
Register Google Drive as My App
After clicking "Add", search for "Google Drive" from the list of apps.
When the following screen appears, click "Sign with Google" to proceed.
Select the account you want to use.
Check the following screen and click "Continue".
Check the following screen and click "Continue" to proceed.
This completes the registration of My Apps.
Register Microsoft Teams as My App
After clicking "Add", search for "Microsoft Teams" from the list of apps.
When the following screen appears, log in to your Microsoft365 account. If you do not have an account, please create one.
*Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail, so please check.
This completes the registration of My Apps!
Step 2: Copy Template
From here, we will actually create a flow bot!
Click "Try it" from the banner below to copy the template.
Notify Microsoft Teams when a new file is uploaded to Google Drive™.
■Overview The flow "Notify Microsoft Teams when a new file is uploaded to Google Drive™" is a business workflow that facilitates file sharing and team communication. Whenever a new file is added to Google Drive™, a notification is automatically sent to Microsoft Teams, allowing all team members to keep track of the latest file status in real-time. This reduces information sharing omissions and the effort of confirmation tasks, enabling efficient collaboration.
■Recommended for - Team leaders who use Google Drive™ and Microsoft Teams on a daily basis - IT personnel who want to automate file management and team communication - Business owners who want to enhance real-time information sharing and improve work efficiency - Business persons who feel that manual notification tasks are taking up time and preventing them from focusing on other tasks
■Cautions - Please integrate Yoom with both Google Drive and Microsoft Teams. - You can select a trigger interval from 5, 10, 15, 30, or 60 minutes. - Please note that the shortest trigger interval varies depending on the plan. - Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business), and authentication may fail if you are not subscribed to the general business plan. - Branching is a feature (operation) available with the Mini Plan or higher. With the Free Plan, operations set in the flowbot will result in an error, so please be careful. - A two-week free trial is available for paid plans like the Mini Plan. During the free trial, you can use restricted apps and features (operations).
Please click "When a new file or folder is created".
When the following screen appears, check the account information to be linked and proceed to the next step.
Next is the API connection settings.
Set the interval according to your business needs.
You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. Also, please note that the shortest interval varies depending on the plan.
After setting the trigger interval, please conduct a test.
If the test is successful, the following screen will appear.
By quoting the retrieved value in subsequent settings, it is possible to send to Microsoft Teams!
Click "Save" and proceed to the next step.
Step 4: Set the Branch
Next, click "Command Operation".
Next, set the branch
The branch is a feature (operation) available with the Mini Plan or higher. If you are on the Free Plan, the operation of the Flow Bot you have set will result in an error, so please be careful! Additionally, paid plans like the Mini Plan offer a 2-week free trial. During the free trial, you can use apps and features (operations) that are subject to restrictions.
Set "Operation" to "When a new file or folder is created". Select "File ID" for "Retrieved value".
You can select from the dropdown, so choose from there.
By selecting "is not empty" in the branch condition, it will branch between those with a non-empty File ID and others.
Click "Save" and proceed to the next step.
Click "Save".
Step 5: Set to Send a Message to the Channel
Next, click "Send message to channel".
When the following screen appears, check the linked account information and proceed to the next step.
Next is the API connection settings.
"Team ID" is the team ID of Microsoft Teams. Select from the candidates.
"Channel ID" should be selected from the candidates. Notifications will be sent to the channel specified here.
For "Message", please enter according to the following setting example.
Select "File Name" from retrieved values. By including "File Name", it becomes easier to verify the file through search.
Please set "Mention Information" and "Attachment Information" as needed. If there is a project manager or someone you want to mention, you can set "Mention Information".
Finally, let's conduct a test. If the test is successful, click "Save" and proceed to the next step.
Step 6: Confirm Flow Bot Automation
When the following screen appears, click "Trigger ON".
This completes all the settings!
If You Want to Link Microsoft Teams Data to Google Drive
This time, we introduced how to link data from Google Drive to Microsoft Teams, but if you want to link data from Microsoft Teams to Google Drive, please also use the following template.
Create a Folder in Google Drive When a Specific Message is Sent in Microsoft Teams
This flow is recommended for office or sales staff who find file management cumbersome. When a specified message is sent, a folder is created in Google Drive, allowing for automatic creation of customer documents or inquiry files!
Create a folder in Google Drive when a specific message is sent in Microsoft Teams
This flow creates a folder in Google Drive when a specific message is sent on Microsoft Teams.
■Notes ・Please link Microsoft Teams and Google Drive with Yoom respectively. ・Microsoft365 (formerly Office365) has plans for households and general businesses (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail. ・The 'Branching' operation is a feature (operation) available in the Mini Plan or higher plans. In the case of the Free Plan, the flowbot operations set will result in an error, so please be careful. ・Paid plans such as the Mini Plan can offer a 2-week free trial. During the free trial, you can use apps and features (operations) that are subject to restrictions. ・You can choose the trigger activation interval at 5, 10, 15, 30, or 60 minutes. ・Please be aware that the shortest activation interval varies depending on the plan.
■Overview This flow issues an invoice with the content of the Google Form when it is submitted and saves it to Google Drive. With Yoom, you can easily integrate apps without programming.
■Recommended for: 1. Those who want to improve operational efficiency using Google Forms. - If you need to issue invoices regularly and it takes time. - If you want to reduce data entry effort and errors through automation.
2. Those managing documents with Google Drive. - If you want to manage various invoices and documents on Google Drive but want to avoid the manual upload process. - If you want to make it easier to share documents with team members using Google Drive.
■Notes - Please integrate Yoom with both Google Forms and Google Drive. - You can select the trigger intervals as 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. - The shortest trigger interval varies by plan, so please be careful. - Refer to the following on how to obtain response content when using Google Forms as a trigger. https://intercom.help/yoom/ja/articles/6807133
■Overview This is a flow where a folder is created in OneDrive based on the message content when a message is posted on Microsoft Teams. Using Yoom, you can easily connect apps without programming.
■Recommended for: 1. Those who use Microsoft Teams to communicate with members ・People who want to efficiently manage daily message content and have quick access to necessary information ・Those who want to organize interactions with members and prevent shared information from being overlooked
2. Those who utilize OneDrive for file management ・People who want to reduce the hassle of manually organizing files and improve work efficiency through automation ・Those who want to automatically create folders based on message content to ensure important information is stored without omission
■Notes ・Please link both Microsoft Teams and OneDrive with Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the minimum activation interval varies depending on the plan. ・Microsoft365 (formerly Office365) has home and general business plans (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may fail.
■Overview In environments where Microsoft Teams and Slack are used together, do you feel burdened by missed information checks or manual re-entry between tools? Missing important messages or sharing by copying and pasting each time causes communication delays and inefficiency. By using this workflow, posting a message to a specific Microsoft Teams channel can trigger an automatic notification to a designated Slack channel, facilitating smooth cross-tool information sharing.
■Who we recommend this template for ・Those who use both Microsoft Teams and Slack and want to eliminate omissions and effort in information sharing ・Those who feel challenges with smooth collaboration because different chat tools are used across departments or teams ・Those who want to automate manual information transfer and prevent communication loss
■Notes ・Please connect Yoom with both Microsoft Teams and Slack. ・Microsoft 365 (formerly Office 365) offers consumer plans and general business plans (Microsoft 365 Business). If you are not subscribed to a business plan, authentication may fail. ・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes. ・The minimum trigger interval varies by plan, so please be aware.
■Overview The flow 'When a message with specific conditions is posted on Microsoft Teams, create a meeting on Zoom and notify' is a business workflow that streamlines communication and meeting coordination. For example, when a message containing specific keywords is posted within Teams, a Zoom meeting is automatically created, and the meeting link is notified, enabling quick meeting setup. This eliminates the hassle of manually setting up meetings and sharing links, allowing the team to collaborate more efficiently.
■Recommended for - Team leaders and administrators who regularly use Microsoft Teams and Zoom - Business users who want to quickly set up meetings in response to specific triggers in chat - Those who feel that manual meeting setup and link sharing take up time and want to improve work efficiency - Executives and project managers who want to smoothen team communication and promote quick decision-making
■Notes - Please integrate both Microsoft Teams and Zoom with Yoom. - Triggers can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. - The shortest activation interval varies depending on the plan, so please be aware. - Microsoft365 (formerly Office365) has plans for home use and general corporate use (Microsoft365 Business), and if you are not subscribed to the general corporate plan, authentication may fail. - Branching is a feature (operation) available with the Mini Plan or higher. In the case of the Free Plan, the operation of the flow bot set will result in an error, so please be aware. - Paid plans such as the Mini Plan offer a 2-week free trial. During the free trial, you can use restricted apps and features (operations).
We introduced how to integrate Google Drive with Microsoft Teams! If you can set up notifications for new files added to Google Drive to be sent to Microsoft Teams, as shown in the flow we introduced, it might enable quick handoffs to the appropriate members. This would be very pleasing if it improves work efficiency!
Also, this app integration can be easily achieved by utilizing Yoom, which requires no programming! Since you can smoothly implement automation without specialized knowledge like that of an engineer, it might be seen as a benefit for beginners in app integration.
If you want to implement such automation, register with Yoom now! After creating a free account, you can immediately check the actual usability. You can quickly register an account in between work, so please take this opportunity to try it out!
With Yoom, you can easily build the kind of collaboration described here without programming knowledge.
.avif)
