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

Step 1: Connect Google Sheets and Gemini with My Apps

First, connect the apps you will use with Yoom.
After logging into Yoom, click "+ Add" from "My Apps" in the left menu.

When the "New App Connection" window appears, search for Google Sheets and Gemini, and register them with My Apps.

＜For Google Sheets＞

・Click "Sign in with Google".

・Select the account to connect.

・Confirm the account to log in and click "Next".

・Click "Continue" to complete the registration with My Apps.

＜For Gemini＞

・Enter the account name and access token, and click "Add" to complete the registration with My Apps.

※ To obtain the access token, please issue the necessary API key from here.

Once each connection is made, they will appear in the My Apps list.

Step 2: Set Up App Trigger

The initial setting is "When a row is added".
First, let's check the account information that has been linked with My Apps.

If you are linked with multiple Google accounts, sometimes an unintended account may be displayed. In that case, select the correct one from the options.

The title can be edited. If necessary, make corrections, and proceed to the next step without changing the trigger action.

‍

Next, specify the Google Sheets to check the information and the trigger activation interval.

※ The trigger activation interval can be selected from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. The shortest activation interval varies depending on the plan. Generally, a shorter setting is recommended.

Select and enter each required item.

For "Column with Unique Values", choose one that is set so that there are no duplicate values within the same column.
In this case, since the Google Sheets is set as follows, "No." is used as the unique value.

After entering each item, click "Test" to obtain the output.
You can retrieve the contents of the above sheet.

Once confirmed, click "Save" to complete the trigger setup.

Step 3: Set Up Summarization in Gemini

The next setting is "Generate Content".
On the first page, as with Google Sheets, confirm the account information and make any necessary title corrections before proceeding.

Next, select the Gemini model and set the instructions for summarizing the text.

Use the output to create a prompt.
If there are specific requirements for the summary format, provide instructions here. Once you have entered up to "systemInstruction", click "Test".

Once the output is obtained, the summarization setup is complete.

Step 4: Set Up Information Update in Google Sheets

The final setting is "Update Record".
On the first page, as before, correct the account information and title.

Scroll down to find the section where you specify the sheet to update the record.

If you want to update information within the same sheet as the initial setup, specify the same one, or if you want to summarize separately, specify a different sheet.

Once entered, click "Next" to confirm the connection.
Next, set the conditions for updating the record.

Update the row that matches condition ① according to the content of ②.
In the above image, it instructs to insert "Generated Content" into the "Summary" field of the row where the "No." in Google Sheets matches the "No." in the output (unique value).

Once set, click "Test" to check if the summary generated by Gemini is reflected in Google Sheets.

If it is successfully reflected, all settings are complete.
Finally, turn on the trigger to activate the flow.

With this, when information is updated on Google Sheets, the reserved text will be automatically reflected.

Other Automation Examples Using Google Sheets and Gemini

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Sheets and Gemini.

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

‍‍Automation Examples Integrating Google Sheets and Gemini

‍It is also possible to summarize content sent via email, forms, and chat tools with Gemini and add it to Google Sheets.

Automation Example Using Google Sheets

Issuing Documents Based on Google Sheets Information

Automatically create documents such as Google Docs based on the content registered in Google Sheets.

Add transcribed audio to Google Sheets after a web meeting

After a web meeting on Google Meet or Zoom ends, the audio is transcribed and automatically added to Google Sheets.

Add lead information to the customer management app when a row is added in Google Sheets

When lead information is added to Google Sheets, it will be automatically added to platforms like Salesforce or HubSpot.

Automation Example Using Gemini

Read Documents Uploaded to Cloud Storage with Gemini

When a file is uploaded to Google Drive or similar, it is automatically read by Gemini.

Generate a response with Gemini when an inquiry is received via chat tool

When an inquiry is received via Slack, Discord, or other platforms, automatically generate a response with Gemini.

Receive an email and summarize the content with Gemini to notify the chat tool

When you receive an email in Gmail or Outlook, Gemini automatically summarizes the content and notifies the chat tool.

Benefits of Integrating Google Sheets with Gemini

Benefit 1: Easier Review of Key Points

Gemini automatically summarizes and appends the content added to Google Sheets. This allows team members to quickly understand lengthy documents such as meeting notes or reports, making it easier for them to grasp the information.

For example, after recording the minutes of a sales meeting in Google Sheets, Gemini summarizes and reflects the main topics and decisions, so other members don't need to spend much time reviewing the content. This facilitates smooth project progression and transition to the next tasks, potentially improving the overall work efficiency of the team.
Additionally, since the summarized information remains in the spreadsheet continuously, it is convenient to quickly access necessary information when reviewing past meeting content, as only the key points are compiled.

Benefit 2: Smoother Information Sharing Among Teams

By integrating Google Sheets with Gemini, data from different departments can be automatically aggregated, allowing for centralized management of business data.

For instance, by consolidating client data managed by the sales team and survey results collected by the marketing team into a single spreadsheet, you can create an up-to-date information source accessible to all stakeholders.
This smoothens data sharing among teams, enabling managers and leaders to easily check the progress and status of each team. As a result, it may facilitate more appropriate decision-making.

Conclusion

By leveraging the integration of Google Sheets and Gemini with Yoom, you can automatically summarize and manage key information, aiming for increased work efficiency.
Particularly, the ease of setup without requiring programming knowledge is an attractive feature.

Moreover, utilizing the integration flow of Google Sheets and Gemini makes it easier to organize lengthy records and meeting content, contributing to improved productivity for the entire team.
Be sure to try automation with Yoom!