How to summarize and update content added in Google Sheets using Gemini

[What is Yoom]

How to Summarize Content Added to Google Sheets Using Gemini and Update Google Sheets

Integrating apps typically requires programming knowledge, but with the no-code tool Yoom, it can be easily achieved without programming knowledge.
The integration flow this time is broadly divided into the following processes.

• Integrate Google Sheets and Gemini with My Apps
• Set up to launch Google Sheets
• Set up to summarize with Gemini and add the summary result to Google Sheets
• Turn on the trigger button and check the integration operation of Google Sheets and Gemini

First, let's register with Yoom.
Yoom offers a 2-week trial. You can actually operate it and check the usability.

Step 1: Integrate Google Sheets and Gemini with My Apps

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

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

Integration of Google Sheets and Yoom

1. Search

Click the Google Sheets 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.

5. Prepare Google Sheets

Prepare the Google Sheets to be integrated with Gemini.

At this time, be sure to create " Items to add summary results " and " Items with no duplicate data ".

This time, the item with no duplicate data is "Date".

The item to add summary results will be the data added after summarizing with Gemini. Therefore, it can be left blank at this point.

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. A clear and easy-to-understand naming such as 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 contents, agree, 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 a 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.

Step 2: Copy the Template

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

1. Click on "View Details" on the top banner
2. Click on "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: Launch Settings for Google Sheets

1. Open My Projects

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

2. Open the copied template
‍Click on "【Copy】Summarize the content added in Google Sheets using Gemini and update it in Google Sheets".‍

3. Select App Trigger

Click on "When a row is added" under the Google Sheets icon.
Since the title and other settings are complete, press Next.‍

4. Set Trigger Launch Interval

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

5. Enter ID

Set according to the suggestions at the bottom of the box. Click the box.

Since the data from Google Sheets will be displayed in a list, click and insert the one you want to link with Gemini.
Set the sheet ID in the same way.‍

6. Enter Table Range, etc.

Specify the table range, etc.

This time, the table range of the prepared Google Sheets is A to D.

The non-overlapping column with others is set to the date in column D.

Therefore, the settings will be as shown in the image.

7. Run Test

Once the settings are complete, press the test button.
If "Test Successful" is displayed, it is complete. Click Save.

Step 4: Set to Summarize with Gemini and Add Summary Results to Google Sheets

1. Integrate with App

Click on "Generate Content" under the Gemini icon.
Since the title and other settings are complete, press Next.

2. 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.

In the case of the image, 1.5 flash is used, so 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 one as the model you confirmed.

3. Set Prompt and Role

Set the prompt and role. Please set each as desired.

4. Run Test

Once the settings are complete, press the test button.
If "Test Successful" is displayed, it is complete. Click Save.

Next, proceed with the settings to add the summary results to Google Sheets.
1. Operate the Database

Click on "Update Record" under the Google Sheets icon.
Scroll down.‍

2. Set Required Items

Enter the required items. Click the box for the spreadsheet ID.

Click inside the box, and a list of created sheets will be displayed as shown in the image. Select the Google Sheets that you linked with Streak earlier.
Set the tab name in the same way.

Regarding the table range, it depends on the prepared Google Sheets, so enter it according to the contents of Google Sheets.

This time, since A to D is used, it is set as shown in the image.
Once entered, press Next.

3. Conditions for the Record to be Updated

Set the conditions for the record you want to update.

From the dropdown in the left box, select the task number set as non-overlapping data with others. Next, click the right box.

Select the Google Sheets icon.

From the data in Google Sheets, retrieve the unique value set as non-overlapping with other data.
This time, since the unique value was set to the date, the date was inserted.
By doing this setting, the unique value set in Google Sheets will be linked with the data summarized by Gemini, <span class="mark-yellow">allowing you to add Gemini's summary data to Google Sheets.</span>

4. Values of the Record After Update

Next, add the summarized data to the summary column in Google Sheets.
First, click the box.

Select the Gemini icon

Click on "Generated Content".‍

5. Run Test

Once the data insertion is complete, press the test button.
If "Test Successful" is displayed, the setup is complete. Press Save.‍

6. Turn ON the Trigger

Once the creation of the Flowbot is complete, the above display will appear. The trigger is initially set to OFF, so turn it ON.
This completes the app integration.

Other Automation Examples with Google Sheets and Gemini

In addition to the flow introduced this time, various business automations can be realized by using the APIs of Google Sheets and Gemini. All can be used with simple settings, so if you find something you're interested in, please give it a try!

Automation Example Using Google Sheets

Issue an invoice and send it via Gmail when a row in Google Sheets is updated

By reducing the effort of creating invoices and sending emails, you can achieve faster customer response. This is recommended for those who handle a large number of invoices on a daily basis.

Update Google Calendar events based on Google Sheets information at a specified date and time

Automatically update Google Calendar on a specified schedule based on data from Google Sheets.
This regular automatic synchronization between Google Sheets and Calendar helps prevent discrepancies in information.

Update Google Spreadsheet when a HubSpot form is submitted

This is a workflow to streamline marketing and customer data management.
Automatic updates allow for smooth data organization and analysis, which can enhance operational efficiency.

Example of Automation Using Gemini

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

By automating basic question responses, staff can efficiently handle more complex inquiries, leading to increased productivity for the entire team.
Since automation can be achieved using only Google tools, convenience may be significantly enhanced.

When a page is created in Notion, summarize it with Gemini and record it in Notion

In this example, we explained using Google Sheets, but you can set up a similar flow in Notion as well.
Try integrating it with the tools you usually use.

Analyze Slack Post Messages with Gemini and Send Warnings for Inappropriate Remarks

This flow utilizes Gemini's advanced analysis capabilities to automatically send warning messages when problematic remarks are detected on Slack.
It supports maintaining healthy communication within the team.

Benefits and Examples of Integrating Google Sheets with Gemini

Benefit 1: Simplification of Summarization

When you add a row to Google Sheets, its content is automatically summarized by Gemini. The summary results are then added to Google Sheets and updated automatically. This makes it easier to organize data. For example, if you have been summarizing large amounts of data manually, this should save you a significant amount of time. Even if you have been using Gemini for summarization, you can eliminate the need to access Gemini and input prompts each time, making your work more efficient.

Benefit 2: Avoidance of Human Error

Avoiding human error is another advantage of automatic summarization. For instance, if you frequently summarize manually, there is a risk of misreading content or making typing errors. However, by implementing this automation, it becomes easier to avoid such human errors and helps in accurately summarizing data.

Benefit 3: Enhanced Information Sharing

Since the data added to Google Sheets is quickly summarized and updated, team members can easily check the data overview. For example, even if you add raw data, there might be times when you can't immediately get to summarizing it, forcing members to check the vast amount of unsummarized data. By automating through app integration, information sharing can become smoother.

Conclusion

Summarizing content is essential for quickly and accurately sharing and understanding data. However, the more data there is, the longer it can take. This is where app integration using Gemini is recommended. Automate the tasks that have been time-consuming and improve work efficiency! With Yoom, you can integrate apps without the need for programming. Please take advantage of this opportunity.