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 with Gemini when an image is uploaded to Google Drive and notify Microsoft Teams of its 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 the following for the "Trigger Activation Interval": 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
※ The trigger activation interval varies depending on the plan, so be careful. A shorter setting is generally 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 issues, 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, we are quoting and setting the 'File ID'.)

‍

(10) After entering the information, click [Test], and if there are no issues, 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 issues, click [Save].

(5) Continue by clicking 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) On the next screen, enter information in items such as "Model".
As shown in the screen below, click the input bar to expand the information referenced based on the account as 'candidates', and you can quote that information.

‍

(8) You can set the desired content for "Prompt" and "systemInstruction".
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 issues, 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, click the input bar to expand the 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 add more attachments, click "+Add Attachment Information" and enter the information as needed.

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

・Turn On Trigger

By clicking the red frame 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 in a Google Drive folder and notify Microsoft Teams.

Example of Automation 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 files are saved in Google Drive, they are automatically saved to services like Box or Dropbox.

Automation Examples Using Gemini

Identify 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 from the Form in Gemini

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

Automation Example Using Microsoft Teams

Notify Microsoft Teams When a Task is Added

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

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

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

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

1. Reduce the Effort of Verification

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 scenarios where a large-scale event is held, a large number of images are uploaded, and it can be challenging for the person in charge to verify each one visually.
This automation reduces the time and effort of verification tasks, allowing the person in charge to allocate the extra time to other tasks.

2. Speed 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 corrections or re-upload 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 manager can check the content and quickly issue a correction request to the responsible team.
This can minimize misinformation or misrecognition, potentially leading to stable business operations.

3. Streamline Information Sharing

In tasks involving multiple people or departments, there may be many verification items and delays in information sharing.
By implementing this automated flow, if an uploaded image needs to be verified by multiple members, the notification feature of Microsoft Teams allows for easy information sharing.
For example, when multiple projects are underway and image verification is essential, the responsible members and stakeholders can immediately receive the information and provide feedback on the shared content promptly.

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 can be a useful means for those who prioritize safety and quality assurance.
Especially in projects or events that handle a large number of images, the effect may be maximized.

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