How to have Gemini analyze images added to Google Drive and notify Chatwork

When a file is uploaded to a shared folder, do you find it a bit tedious to check what kind of file has been added each time? Since you have to stop your work to check, you might end up putting it off. Therefore, this time, we introduce an automation that simplifies image checks by integrating Google Drive, Gemini, and Chatwork. This could potentially reduce your workload, so if you frequently check many files, consider implementing automation. Recommended for: - Teams using shared Google Drive - Those checking a large number of files uploaded to Google Drive - Companies that have introduced or want to introduce Gemini (generative AI) into their operations - Companies using Chatwork as their main communication tool Benefits and examples of integrating Google Drive and Chatwork: Benefit 1: Streamlining file checks With this integration, Gemini automatically analyzes files added to a specific folder in Google Drive. The analysis results are sent to Chatwork, which can improve the efficiency of file checks. For example, to check files uploaded to Google Drive, you would normally need to access the files yourself. You have to stop your work to check Google Drive, which isn't very efficient. Also, there might be files that are unrelated to you, consuming your time unnecessarily. By using Gemini, it analyzes the content of uploaded files and notifies Chatwork, making it easier to perform efficient file checks without opening the files. Benefit 2: Preventing missed checks Files added to a specific folder in Google Drive are sent to a designated Chatwork room, which can help prevent missed file checks. For example, even if you are verbally requested to check files, you might put it off if you are busy. Also, if you leave a message in a Chatwork room with many messages, you might forget about it as the log flows. However, if the automatically analyzed content of the files is sent to a specific room, you won't have to worry about the log flowing, and it will be easier to understand what files have been added just by checking that room. Benefit 3: Reducing workload By implementing this automation, you might simplify the process of sending emails requesting file checks. For example, for files that need a final check or must be submitted by a deadline, you need to inform others that they have been uploaded via a message. With this integration, you can eliminate the hassle of sending such messages. As a result, the workflow is shortened, and the workload is reduced. Additionally, the possibility of forgetting or making mistakes in sending messages is also reduced. Now, let's explain how to use the no-code tool Yoom to "analyze images uploaded to Google Drive with Gemini and notify Chatwork of the content." [What is Yoom] How to analyze images added to Google Drive with Gemini and notify Chatwork: First, obtain the file data uploaded to a specific folder in Google Drive using Google Drive's API. Then, use Gemini's API to receive and automatically analyze this data. The analyzed results are further received by Chatwork's API and automatically sent to a specific room. Generally, programming knowledge is required to achieve such integration, but with the no-code tool Yoom, you can easily achieve it without programming knowledge. The integration flow is broadly divided into the following processes: - Integrate Google Drive, Gemini, and Chatwork with My Apps - Set up to activate Google Drive - Set up to analyze with Gemini and send to Chatwork - Turn on the trigger button and check the integration operation of Google Sheets and Gemini First, register with Yoom. Yoom offers a two-week trial, allowing you to actually operate and check the usability.

Step 1: Connect Google Drive, Gemini, and Chatwork to My Apps

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

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

Connecting Google Drive with Yoom

1. Search

Click on the Google Drive icon.

2. Sign In

Click the red frame.

3. Select Account

Select the account to connect.

After confirming and agreeing, press Next.

4. Connection Complete

The screen will change, and if the above display appears, the connection is complete.

Connecting Gemini with Yoom

1. Search

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

2. Enter Account Name

Enter the account name and access token.
First, enter the account name. A clear and easy-to-understand name like the company name or person in charge is recommended.

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

Check the content, agree, and check the box, then press the "Continue" button at the bottom right.

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

Continue by pressing "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 filled, press Add at the bottom right.

5. Connection Complete

The screen will change, and if the above display appears, the connection is complete.

Connecting Chatwork with Yoom

1. Search

Search for Chatwork.

2. Log in to Chatwork

The login screen will appear.
Log in with the account you want to connect.‍

3. Press Allow

Check the content and press Allow.

Return to the Yoom screen, and if the above display appears, the connection 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 completed the registration, the login screen will be displayed, so please log in. When the Flowbot template is copied to "My Projects", the above display will appear. Let's proceed with detailed settings as you transition to a page like the image. 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 "Analyze with Gemini and notify Chatwork when an image is uploaded to Google Drive". 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 activation interval. You can set the activation interval from the dropdown as shown in the image. You can choose the trigger activation interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. Please note that the shortest activation interval varies depending on the plan. 4. Specify the Folder Specify which folder to analyze with Gemini when a file is uploaded. By clicking the box, the files will be displayed in a list, so select and set them. 5. 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. 6. Integrate with the App Select "Download File" from the Google Drive icon. Proceed to the next step. 7. Execute the Test Since the template is being utilized, the settings are complete. Therefore, press the test button and confirm that "Test Successful" is displayed in blue, then press save. If the test does not succeed, it is recommended to re-upload the file. Step 4: Analyze with Gemini and send to Chatwork 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 Since the template is being utilized, the settings are complete. Therefore, press the test button and confirm that "Test Successful" is displayed in blue, then 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. Set the Model 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. By clicking the box, the Gemini models will be displayed in a list. Scroll and click to insert the same model as confirmed. 3. Set the Prompt and Role Set the prompt and file. Both are pre-set, so you can change them if desired. 4. Execute the Test Once the settings are complete, press the test button at the bottom. If "Test Successful" is displayed in blue, the settings are complete. Press save. 5. Integrate with the App Finally, set up the message to be sent to Chatwork. Select "Send Message" from the Chatwork icon. Press next. 6. Enter the Channel ID The channels will be displayed in a list, so click to insert them. First, set the channel ID where you want to notify the analyzed file information. Enter as per the note below the box. 7. Confirm the Message Set the content of the message you want to notify Chatwork. Since the data insertion is already set as shown in the image, there is no problem if there are no changes. If you want to change it, only modify the text. 8. Execute the Test Once the message settings are complete, press the test button at the bottom. If "Test Successful" is displayed in blue, the settings are complete. Press save. 9. Turn ON the Trigger When the creation of the Flowbot 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 and notify Chatwork when an image is uploaded to Google Drive

Other Automation Examples Using Google Drive, Gemini, and Chatwork

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

1. Analyze content posted on Chatwork using Gemini's assistant and update the response back to Chatwork

This allows you to utilize Gemini even without direct access. In addition to reducing the need to switch between tools, it will make it easier to share responses with Chatwork room members.

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

This is an automation that summarizes data in Google Sheets and appends the summarized content back into Google Sheets for updating. This allows for easy reference at any time as the summarized content accumulates.

3. Transcribe audio files, add audio files and text to Google Drive, and notify Chatwork

Automatic transcription using AI is also possible. Notifications will be sent to Chatwork after saving to Google Drive.

Summary

By utilizing generative AI, tasks that used to take a lot of time can be completed quickly. Improved work efficiency can lead to smoother completion of tasks and a reduction in workload.
The automation introduced here is also effective in setting up a work environment. It might make daily work easier.
Yoom allows for the implementation of automation without programming knowledge. It is designed to be user-friendly even for those who have previously given up on automation, so please take this opportunity to try it out.