How to analyze images uploaded to Google Drive with Gemini and notify their content to Microsoft Teams

The template will be copied, so click the "OK" button.

‍

‍

Move to the "My Projects" screen of your Yoom account and check the template content.

‍

‍

There are five setup flows.

・Google Drive Trigger Setup

(1) First, set up the Google Drive app trigger.

‍

‍

From "My Projects" on the left side of your Yoom account screen, click "【Copy】Analyze images uploaded to Google Drive with Gemini and notify Microsoft Teams of the content".

‍

‍

After clicking, the template content will be displayed as shown in the screen below.

‍

‍

(2) First, click on the trigger "When a new file or folder is created".

(3) Enter the account information to be linked and click [Next].

‍

‍

(4) On the next screen, enter the "Trigger Activation Interval".
Select any of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes for the "Trigger Activation Interval".
※ The trigger activation interval varies depending on the plan, so be careful. Generally, a shorter setting is recommended.

‍

‍

(5) For the "Folder ID" item, click the input bar to expand the information obtained from the account as "candidates" as shown in the screen below.

‍

(6) After entering the information, click [Test], and if there are no problems, click [Save].
In this step, you can obtain the following information as output.
The output information can be quoted and utilized in the subsequent steps as noted in "This value can be used in other operations."

‍

‍

(7) Next, click on the second action "Download File".

‍

‍

(8) On the screen after migration, confirm that the Google Drive account information is entered and click [Next].

(9) In the "File ID" item on the next screen, click the input bar to quote the information obtained in the previous step as output as shown in the screen below.
(In this example, 'File ID' is quoted and set.)

‍

‍

(10) After entering the information, click [Test], and if there are no problems, click [Save].

・Gemini Setup

(1) Next, click on the third action "Upload File".

‍

‍

(2) Enter the account information to be linked and click [Next].

‍

‍

(3) Set the "File Attachment Method".
This time, it is set to 'Use the output of the file obtained from Google Drive'.

‍

‍

(4) Click [Test], and if there are no problems, click [Save].

(5) Continue to click on the fourth action "Generate Content (Use File)".

‍

‍

(6) On the screen after migration, confirm that the Gemini account information is entered and click [Next].

(7) Enter information in items such as "Model" on the next screen.
As shown in the screen below, clicking the input bar will expand information referenced based on the account as 'candidates', and you can quote that information.

‍

‍

(8) "Prompt" and "systemInstruction" can be set to the desired content.
Enter the roles you want to define.

(9) "File URI" can quote the output obtained in the previous step.

‍

‍

(10) After entering the information, click [Test], and if there are no problems, click [Save].

・Microsoft Teams Setup

(1) Finally, click on the fifth action "Send Message to Channel".

‍

‍

(2) Enter the account information to be linked and click [Next].

‍

‍

(3) On the next screen, enter information in items such as "Team ID" and "Channel ID".
As in the previous step, clicking the input bar will expand information referenced based on the account as 'candidates', and you can quote that information.

‍

‍

(4) Set the message for information sharing in "Message".
Enter the information according to the annotation.

(5) Enter information in 'Mention Information' and 'Attachment Information'.
As shown in the screen below, you can quote the information obtained in the previous step as output.

‍

‍

When setting file attachments, you need to upload the file to OneDrive in advance and obtain the GUID inside the eTag {}.
If you want to increase the number of attachments, click "+ Add Attachment Information" and enter the information as needed.

(6) After entering the information in the required fields, click [Test], and if there are no problems, click [Save].
This completes the setup.

・Turn on the Trigger

By clicking the red-framed part "Turn on Trigger" on the screen below, the flow bot will start automatically.

‍

‍

Here is the template used this time

Examples of Other Automations Using Google Drive, Gemini, and Microsoft Teams

In addition to the integrations introduced today, it is possible to achieve various automations by utilizing the APIs of Google Drive, Gemini, and Microsoft Teams.

If you find something interesting, please give it a try!

‍‍Automation Examples Integrating Google Drive and Microsoft Teams

You can set up notifications in Microsoft Teams when a new file is uploaded to Google Drive, or create a folder in Google Drive when a specific message is sent in Microsoft Teams.
Additionally, it is possible to regularly retrieve a list of files within a Google Drive folder and notify Microsoft Teams.

Automation Example Using Google Drive

Create a Folder When a Record is Added to the Database

When a record is added to Google Sheets or Notion, a folder is automatically created in Google Drive.

Save files stored in Google Drive to other cloud storage

Once a file is saved in Google Drive, it will automatically be saved to services like Box or Dropbox.

Automation Examples Using Gemini

Identifying Email Content and Documents with Gemini

You can use Gemini to identify messages received via email and automatically assign them to the appropriate person, or classify documents with Gemini and automatically save them to Google Drive.
Additionally, it is possible to summarize messages with Gemini and automatically add them to Google Sheets.

Summarize and Save Responses in Gemini

Automatically summarize responses from Google Forms in Gemini and add them to Notion.

Automation Example Using Microsoft Teams

Notify Microsoft Teams When a Task is Added

Automatically notify Microsoft Teams when a task is added to Trello, Asana, or similar platforms.

After a web meeting, transcribe and summarize the content, then notify Microsoft Teams

After a meeting on Zoom or Google Meet, automatically transcribe and summarize the content, then notify Microsoft Teams.

Benefits and Examples of Integrating Google Drive, Gemini, and Microsoft Teams

1. Reducing the Effort of Confirmation

When an image is uploaded to Google Drive, Gemini analyzes the image and the results are notified to Microsoft Teams, allowing the person in charge to understand the content just by checking the notification.
For example, in a scenario where a large-scale event is held, a large number of images are uploaded, and it would be difficult for the person in charge to check each one visually.
This automation reduces the time and effort of the confirmation process, allowing the person in charge to allocate the increased time to other tasks.

2. Speeding Up Response to Incorrect Uploads

While Gemini analyzes images uploaded to Google Drive, if the image is incorrect or needs correction, that information is automatically notified to Microsoft Teams.
After confirming the issue, the person in charge can quickly request correction or re-upload of the correct image, which is convenient.
For example, if an incorrect product image is uploaded to a store folder in Google Drive, Gemini detects the content and a notification is sent to Microsoft Teams.
The responsible person can check the content and quickly issue a correction request to the team in charge.
This can minimize misinformation or misrecognition, potentially leading to stable business operations.

3. Improving the Efficiency of Information Sharing

In tasks involving multiple persons or departments, there are often many confirmation items, and delays in information sharing can occur.
By introducing this automation flow, if uploaded images need to be confirmed by multiple members, the notification function of Microsoft Teams allows for easy information sharing.
For example, in cases where multiple projects are ongoing and confirmation of uploaded images is essential, information can be immediately conveyed to the responsible members and stakeholders, allowing for quick feedback on the shared content.

Conclusion

The integration of Google Drive, Gemini, and Microsoft Teams introduced here is expected to improve the efficiency of image management and speed up information sharing.
Since errors and issues can be detected and addressed early, it may be a useful means for those who prioritize safety and quality assurance.
Especially in projects or events that handle a large number of images, its effects might be maximized.

The setup is simple, so please try using Yoom to experience automation through app integration!