How to analyze images uploaded to Google Drive with Gemini and notify their content in Google Chat

How do you verify when a file is uploaded to a folder shared by the team?
Most people probably check after receiving a report that a file has been uploaded or when they have a free moment.
However, this can lead to the double effort of checking the file after confirming the upload report message, or you may not be able to check the file because you are too busy.
Therefore, this time we will introduce an app integration that can reduce the effort required for file checking by linking Google Drive, Gemini, and Google Chat.

Recommended for

・Teams using Google Drive
・Those who want to quickly know the details of files added to Google Drive
・Those who want to save time required for file verification
・Companies aiming to automate and improve efficiency using Gemini (generative AI)
・Companies using Google Chat as their main communication tool

Benefits and Examples of Integrating Google Drive, Gemini, and Google Chat

Benefit 1: Verification work becomes more efficient

By introducing this integration, Gemini can automatically analyze files uploaded to a specific folder in Google Drive and send the results to Google Chat. This increases the possibility of performing verification work efficiently.
For example, it is difficult to determine whether the uploaded file needs to be checked immediately without actually looking at it. In such cases, by performing this app integration, it becomes easier to understand what kind of file has been uploaded. Therefore, you will be less likely to hesitate about whether you should check the file yourself immediately, and you may be able to perform verification work efficiently.

Benefit 2: Prevent oversight

After Gemini automatically analyzes the files uploaded to the Google Drive folder, a message is sent from Google Chat. This makes it easier to notice new files and should help prevent oversight.
For example, if you have to regularly check whether new files have been uploaded, you might put it off when tasks are piling up and forget about it.
However, in addition to being notified that a file has been uploaded, you will also be automatically informed of what kind of file has been added, which may help prevent such oversight.

Benefit 3: Reduce manual notifications

If you were manually notifying about file uploads, you might be able to simplify such a flow.
For example, when you upload a file that needs to be checked by a person in charge, you might send a separate message after adding the file.
However, with this integration, in addition to being notified that a file has been uploaded, detailed information about what kind of file it is will also be notified, so you should no longer need to take the trouble to create a message.
This is expected to simplify the work and reduce the operational burden.

‍

Now, let's introduce the flow of linking apps using Yoom.
First, register with Yoom.
Yoom offers a 2-week trial. You can actually operate it and check the usability.

[What is Yoom]

This time, we will automate the process of "analyzing images uploaded to Google Drive with Gemini and notifying Google Chat of the content" using the following template.

How to Create a Google Drive, Gemini, and Google Chat Integration Flow

The integration flow for this time is broadly divided into the following processes.

・Integrate Google Drive, Gemini, and Google Chat with My Apps
・Set up to launch Google Drive
・Configure to analyze with Gemini and send messages to Google Chat
・Turn on the trigger button and verify the integration operation of B-Cart with Google Drive, Gemini, and Google Chat

Step 1: Integrate Google Drive, Gemini, and Google Chat with My Apps

After completing the registration with Yoom, please select "My Apps" from the menu on the left side.

Next, click the new connection button at the top right.

Integration of Google Drive and Yoom

1. Search

Click the Google Drive icon.

2. Sign In

Click the red frame.

3. Select Account

Select the account to integrate.

After confirming and agreeing, press Next.

4. Integration Complete

The screen will switch, and if the above display appears, the integration is complete.

Integration of Gemini and Yoom

1. Search

Enter Gemini in the search box and click the Gemini icon.

2. Enter Account Name

Enter the account name and access token.
First, enter the account name. It is recommended to use an easy-to-understand name such as the company name or the person in charge.

3. Obtain API Key
‍The access token can be obtained from the Gemini API acquisition page.

After confirming the content and agreeing, check the box and press the "Continue" button at the bottom right.

Press the "Create API Key" button at the bottom of the screen.

Then press "Create API Key with New Project".

The API key has been created. It is displayed in the red frame, so please copy it.

4. Enter

Return to the Yoom screen and enter the copied API key as the access token.
Once the required fields are entered, press Add at the bottom right.

5. Integration Complete

The screen will switch, and if the above display appears, the integration is complete.

Integration of Google Chat and Yoom

1. Search

Click the Google Chat (OAuth) icon.

2. Sign In

Click the red frame.

3. Set Required Fields

Enter the required fields.
For details, please refer to this article.

4. Integration Complete

The screen will switch, and if the above display appears, the integration is complete.

Step 2: Copy the Template

Next, please copy the template to be used this time.

1. Click "View Details" on the top banner
2. Click "Try this template" at the bottom of the transitioned screen
3. If you haven't registered with Yoom yet, please register

※ If you have already registered, the login screen will be displayed, so please log in.

When the Flowbot template is copied to "My Projects", the above display will appear.

You will transition to a page like the image, so let's proceed with detailed settings.

Step 3: Setting up Google Drive

1. Open My Projects

Open "My Projects" from the menu on the left side of the screen.

2. Open the copied template
‍Click "【Copy】Analyze with Gemini when an image is uploaded to Google Drive and notify the content to Google Chat".

3. App Trigger

Select "When a new file or folder is created" from the Google Drive icon.
Proceed to the next step.‍

4. Specify the Trigger

‍

Set the trigger interval.

You can set the trigger interval from the dropdown as shown in the image.

The trigger can be set to intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
Please note that the shortest trigger interval varies depending on the plan.

5. Specify the Folder

Specify which folder to analyze with Gemini when a file is uploaded.
Click the box to display a list of files, then select and set them.‍

6. Execute the Test

Press the test button, and if "Test Successful" is displayed in blue, press save.
※ It is recommended to create a test folder in advance and upload files.

‍

Continue to set up to retrieve file information uploaded to the folder.‍

7. Integrate with the App

‍

Select "Download File" from the Google Drive icon.
Proceed to the next step.‍

8. Execute the Test

Since the template is being utilized, the setup is complete.
Therefore, press the test button, confirm that "Test Successful" is displayed in blue, and press save.
If the test is not successful, try re-uploading the file.

Step 4: Analyze with Gemini and Send to Google Chat

1. Integrate with the App

Next, set up to upload files to Gemini.
Select "Upload File" from the Gemini icon.
Press Next.

2. Execute the Test

This is also complete because the template is being utilized.
Therefore, press the test button, confirm that "Test Successful" is displayed in blue, and press save.

3. Integrate with the App

‍

Continue to set up analysis with Gemini.
Select "Generate Content (using file)" from the Gemini icon.
Press Next.

4. Model Settings

First, enter the Gemini model type to be used.
You can check the model by clicking the top left of the Gemini page.

Since 1.5 flash is used for the image, set the same as the model.

Return to the Yoom screen.
Click the box to display a list of Gemini models.

Scroll and click to insert the same model you confirmed.

5. Set Prompt and Role

Set the prompt and file.
Both are pre-set, so if you have any preferences for the prompt, you can change it optionally.

6. Execute the Test

Once the settings are complete, press the test button at the bottom.
If "Test Successful" is displayed in blue, the setup is complete. Press save.

7. Integrate with the App

Finally, set up the message to be sent to Google Chat.
Select "Send Message" from the Google Chat icon. Press Next.

8. Enter Resource Name

First, set the resource name you want to notify the file details.
Click the box.

A list of resource names will be displayed, so click to insert any of them.

9. Confirm the Message

Set the content of the message you want to notify to Discord.

This time, as shown in the image, the data insertion is already set, so if there are no changes, it is fine as is. If you want to change it, just modify the text.‍

10. Execute the Test

Once the message setup is complete, press the test button at the bottom.
If "Test Successful" is displayed in blue, the setup is complete. Press save.

11. Turn ON the Trigger

When the Flowbot creation is complete, the above display will appear. The trigger is initially set to OFF, so turn it ON.

‍

Flowbot template used this time

Analyze with Gemini when an image is uploaded to Google Drive and notify the content to Google Chat

Other Automation Examples Using Gemini

Yoom has other examples of automation using Gemini, so here are a few introductions.

1. Summarizing Internal Meeting Content Added to NotionDB Using Gemini

If you are utilizing Notion, this template is also recommended. It should make it easier to quickly grasp the content of meetings.

2. Summarize the content added to Google Sheets using Gemini and update it in Google Sheets

This is a flow that automatically summarizes the content added to Google Sheets. Please use it when you want to inform your team about the important parts of the data.

‍

3. Analyze the content posted on Google Chat using Gemini's assistant and update the response back to Google Chat

It will be possible to view questions and answers on Google Chat without accessing Gemini. This might streamline internal research and inquiries.

Summary

You don't want to miss important images. Checking all the numerous images can be challenging. In such cases, this app integration should be helpful.
It automatically analyzes the content of images and sends the details to Google Chat, making it easier to notice uploads even when you're focused on other tasks. Additionally, if it's an important file, you can quickly go and check it.
With Yoom, app integration is possible without programming. By introducing automation, the likelihood of conducting business smoothly increases, so please make use of it.