Are you tired of manually summarizing content in Google Sheets?
Many businesses store full meeting minutes and their summaries in Google Sheets, but when you’re juggling multiple tasks, wouldn't it be great if summarization could be automated?
With Google Sheets and Gemini, you can easily automate this. Imagine an automatic summarization process, where Gemini generates summaries from data added to Google Sheets, and the summary is automatically added back to the sheet.
In this article, we’ll share what you can achieve with the Google Sheets Gemini integration and how to set it up.
Meet Yoom: No-Code Automation
Yoom is a next-generation no-code automation that lets you connect and automate tasks between your favorite apps. Connecting different apps can be challenging for non-engineers, but Yoom makes automation accessible to everyone.
🌐 Connect with apps like Gemini, Google Sheets, and more.
📖 Use automation templates - no technical setup required
📈 Boost productivity and reduce human errors
You don't need to go through a complex setup and IT jargon, you can build your automation workflows with just a few clicks :) It's designed for those who want to streamline their daily work and save hours of time and stress from repetitive work.
In this guide, you'll learn the step-by-step process of how to use Yoom to connect Gemini and Google Sheets to create a Flowbot that automatically summarizes Google Sheets data with Gemini and updates the sheet with the generated summary.
✨ Recommended for
Those looking to improve work efficiency by automating tasks with Google Sheets.
Those who want to automatically register Gemini-generated summaries in Google Sheets.
Anyone interested in utilizing Gemini AI in their workflow.
✔️ For Those Who Want to Try It Now
Yoom offers ready-made templates for easy setup in creating an automated summarization flow by integrating Google Sheets and Gemini. Click the "Try it" button to get started now!
We'll also walk you through the step-by-step process of creating this automation flow in the following section of this article.
Use Gemini to summarize the content added in Google Sheets and update it in Google Sheets.
■Overview This is a flow that summarizes the content added in Google Sheets using Gemini and updates it in Google Sheets.
■Recommended for those who 1. Use Google Sheets for business ・Those who accumulate meeting content in Google Sheets ・Those who share Google Sheets among teams to proceed with work 2. Utilize Gemini for business ・Those who often use Gemini to summarize text ・Those who spend a lot of time summarizing meeting content
■Notes ・Please link each of Google Sheets and Gemini with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
🚀 Let’s Create a Flow to Automatically Summarize Data in Google Sheets with Gemini
Let's walk through how to set up a flow that automatically generates summaries with Gemini for data added to Google Sheets, and updates the sheet with generated summaries.
⏱️ Setup time: 10 minutes
🔧 What You’ll Need
A free Yoom account
Access to Google Sheets & Gemini
If you don’t have a Yoom account yet, register now from thisregistration form!
Step 1: Connect Google Sheets and Gemini to Yoom
Let’s start with connecting these apps first!
After logging into Yoom, go to "My Apps" from the left side menu, and click the "+ Add" button.
Connect Google Sheets
⚠️ Before linking, make sure to create a Google Sheets file you will use to store the generated summaries. If you create a file after linking, the integration may not work properly.
Search for Google Sheets from the app list and select it.
Click on "Sign in with Google".
Select the account you want to connect to.
Click "Continue".
Click "Continue". Now, your Google Sheets is connected with Yoom :)
Connect Gemini
Same as before, click the "+ Add" button.
Enter the account name. Use a name that's easy to recognize, such as your company name or the person responsible for the account.
Click on the "Create API key" button. Then, select to create an API key for your existing project or new project. Your new API key will appear. Copy it.
Return to Yoom, paste it into the Access Token field, and click “Add”.
Now, Gemini is connected :)
Step 2: Copy the Template
Click the "Try It" button to copy the pre-built template into your project.
Use Gemini to summarize the content added in Google Sheets and update it in Google Sheets.
■Overview This is a flow that summarizes the content added in Google Sheets using Gemini and updates it in Google Sheets.
■Recommended for those who 1. Use Google Sheets for business ・Those who accumulate meeting content in Google Sheets ・Those who share Google Sheets among teams to proceed with work 2. Utilize Gemini for business ・Those who often use Gemini to summarize text ・Those who spend a lot of time summarizing meeting content
■Notes ・Please link each of Google Sheets and Gemini with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
Click "OK" and assign a name to the Flowbot for recognition.
This template will be copied to your “My Project”.
Step 3: Google Sheets Trigger
Let's start by setting up the trigger action. Click on the Google Sheets trigger action.
Change the title (optional) for the trigger. Confirm the pre-configured settings and click “Next”.
Set your trigger interval (how often you want Yoom to check Google Sheets for new updates). It can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. We recommend setting the trigger to the shortest activation interval available for your plan.
⚠️ Note: The trigger interval varies depending on your Yoom plan. Be sure to check your current plan’s limit.
Enter all the required fields. For the "Column with Unique Values", select a column where there are no duplicate values. In this case, column A is used as the unique identifier.
Once everything is set, click “Test”. If the test succeeds, the retrieved value will get updated.
Then click “Save”.
Step 4: Generate Content with Gemini
Next, click "Generate Content".
Change the title (optional) for the action. Confirm the pre-configured settings and click “Next”.
Select the Gemini model you want to use.
Give Gemini an instruction based on the example input provided below. Select the "retrieved values" from the Google Sheets in the previous step. By setting it as shown below, you can automatically share the Google Sheets data to Gemini.
To set the text you want to summarize, select “Minutes” from the trigger retrieved value.
📚 Reference: For more details on retrieved values and how to set it up, see the guide here.
Once the setting is complete, click "Test". The retrieved value will get updated.
Click “Save” when you're done.
Step 5: Update in Google Sheets
Let’s set up the final action for Google Sheets. Click on the Google Sheets action item.
The title can be changed (optional). Check the pre-configured settings, and click “Next”.
Specify the required fields (where you want to add a record).
Update the row that matches condition ① based on the content of ②.
For this example, condition ① is that the “No.” in your Google Sheets should match the “No.” in the retrieved value (unique value). Content ② refers to the “Generated Content” from Gemini, which will be inserted into the “Summary” field of the corresponding row in the table.
So when the “No.” in Google Sheets matches the “No.” from the retrieved value, “GeneratedContent” will automatically populate in the “Summary” field of that specific row.
Once everything is set, click “Test”. If the data gets added to Google Sheets, save it.
Step 6: Activate the Flowbot
Toggle the "TriggerOn" button to activate your flow! Check if the Flowbot you set up is working properly.
That's it! Your Flowbot is ready :)
Use Gemini to summarize the content added in Google Sheets and update it in Google Sheets.
■Overview This is a flow that summarizes the content added in Google Sheets using Gemini and updates it in Google Sheets.
■Recommended for those who 1. Use Google Sheets for business ・Those who accumulate meeting content in Google Sheets ・Those who share Google Sheets among teams to proceed with work 2. Utilize Gemini for business ・Those who often use Gemini to summarize text ・Those who spend a lot of time summarizing meeting content
■Notes ・Please link each of Google Sheets and Gemini with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
💡 Other Automation Examples Using Google Sheets and Gemini
You can try out more automations by utilizing Google Sheets and Gemini with Yoom. Here are some more examples you can explore for your next automation!
Automation Examples Using Google Sheets & Gemini
You can summarize content from emails, forms, and chat tools using Gemini and automatically add it to Google Sheets.It is also possible to summarize content sent via email, forms, and chat tools with Gemini and add it to Google Sheets.
After completing the form, summarize with Gemini and add it to Google Sheets.
■Overview This is a flow to summarize with Gemini and add to Google Spreadsheet after responding to the form. You can automatically summarize the information collected in the form with Gemini and smoothly link it to Google Spreadsheet.
■Recommended for ・Those who are collecting data using online forms Business personnel who are gathering a lot of information through forms such as customer surveys and internal applications ・Those who are spending time summarizing and organizing data Team leaders or managers who want to reduce the manual burden by automatically summarizing information using Gemini ・Those who are managing data using Google Spreadsheet People who want to reduce manual input into Google Spreadsheet and manage data efficiently through automatic linkage ・Executives or IT personnel aiming to automate business workflows Executives or IT personnel who want to improve overall business efficiency through data processing automation
■Notes ・Please link Yoom with both Gemini and Google Spreadsheet.
■Overview This is a workflow to summarize Slack post content with Gemini and add it to Google Spreadsheet. It allows you to efficiently manage daily communication on Slack.
■Recommended for ・Team leaders who use Slack regularly Those who want to efficiently organize and share communication content within the team ・Those who want to use Gemini's summary function for information management Those who want to easily summarize a large number of messages and not miss important points ・Business persons who want to centrally manage data with Google Spreadsheet Those who want to link data between multiple platforms and utilize organized information ・IT personnel of companies aiming for operational efficiency Those who want to reduce manual work and streamline business processes through automation
■Notes ・Please link Yoom with Gemini, Slack, and Google Spreadsheet respectively.
■Overview This flow summarizes Gmail content using Gemini and adds it to a Google Spreadsheet. By summarizing with Gemini, email management can be streamlined.
■Recommended For ・Those who want to efficiently manage a large number of emails People who receive a lot of Gmail daily and find it challenging to organize the content ・Business people who want to centrally manage email content Those who want to compile information to share with the team in a Google Spreadsheet ・Those who want to reduce manual data entry People who want to avoid the hassle of manually transcribing email content into a spreadsheet to improve work efficiency
■Notes ・Please integrate each of Gemini, Gmail, and Google Spreadsheet with Yoom.
■Overview This is a flow to issue a document and save it to Google Drive when a row in Google Sheets is updated. With Yoom, you can easily connect apps without programming.
■Recommended for 1. Those who manage data with Google Sheets ・If you manage data such as customer information using Google Sheets but find it cumbersome to issue documents manually
2. Companies that use Google Drive for file storage and sharing ・If you use Google Drive regularly and want to utilize it for saving and sharing invoices ・If you want to automate but don't know where to start
■Notes ・Please connect both Google Sheets and Google Drive with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan. ・Branching is a feature (operation) available in plans above the mini plan. In the case of the free plan, the operation of the flow bot set will result in an error, so please be careful. ・Paid plans such as the mini plan offer a 2-week free trial. During the free trial, you can use apps and features (operations) that are subject to restrictions.
■ Overview Creating minutes after online meetings is an important task, yet it often requires a lot of time for transcribing recordings and copying the content. With this workflow, when a Google Meet meeting ends, the recording is automatically transcribed and the results are recorded in Google Sheets. It reduces the effort of minute-taking and helps you focus on core work.
■ Who we recommend this template for ・ Those who have many meetings in Google Meet and feel the workload of minute-taking is a challenge ・ Managers who want to streamline the recording and sharing of meeting content to improve team productivity ・ Members who want to prevent omissions from manual transcription and keep accurate minutes
■ Notes ・ Please connect Google Meet, Google Drive, and Google Sheets to Yoom. ・ You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes. ・ The minimum trigger interval varies by plan. ・ Executing operations across a "Wait" step is only available on the Team Plan and Success Plan. On the Free and Mini plans, operations and Data Connect configured in the flowbot will result in errors. ・ Paid plans such as the Team Plan and Success Plan include a 2-week free trial. During the free trial you can use apps and features (operations) that are otherwise restricted. ・ The maximum downloadable file size is up to 300 MB. Depending on the app specifications, it may be less than 300 MB. ・ For details on the file size limits for the trigger and each operation, please see the link below. https://intercom.help/yoom/en/articles/9413924 ・ AI operations for OCR or speech transcription are only available on the Team Plan and Success Plan. On the Free and Mini plans, the operations set in the flowbot will result in errors. ・ Paid plans such as the Team Plan and Success Plan include a 2-week free trial. During the free trial you can use apps and AI features (operations) that are otherwise restricted.
■Overview The "Summarize files uploaded to Google Drive with Gemini and issue documents" workflow is an automated process to streamline document management. This reduces the effort of organizing information and enables speedy sharing.
■Recommended for ・Business users managing many files on Google Drive ・Administrative staff spending time on document summarization ・Team leaders aiming to improve information sharing efficiency ・Those considering automating business processes using Yoom ・Those interested in AI-powered document management
■Notes ・Please integrate Google Drive, Gemini, and Yoom. ・Branching is a feature (operation) available in plans above the mini plan. In the case of the free plan, the operations set in the flow bot will result in an error, so please be careful. ・Paid plans such as the mini plan can be tried for free for two weeks. During the free trial, you can use apps and features (operations) that are subject to restrictions. ・The maximum downloadable file size is 300MB. Depending on the app's specifications, it may be less than 300MB, so please be careful. ・For details on the file size that can be handled by triggers and each operation, please refer to the following. https://intercom.help/yoom/en/articles/9413924 ・Triggers can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan. ・When creating a flow bot with more than 5 operations, it can be set in plans above the mini plan. In the case of the free plan, the flow bot will not activate, so please be careful.
■Overview The "Read with Gemini when a file is uploaded to Google Drive" workflow automatically reads new files added to Google Drive with Gemini. It reduces the daily increasing burden of file management and achieves efficient data integration.
■Recommended for ・Those who use Google Drive and Gemini regularly and want to automate file management ・Office staff who have many manual file registration tasks and feel challenged in improving work efficiency ・IT personnel of companies aiming for unified data management by linking multiple SaaS applications ・Business owners considering saving time and effort through automation of business workflows
■Notes ・Please link Google Drive, Gemini, Slack, and Yoom. ・Branching is a feature (operation) available in plans above the mini plan. In the case of the free plan, the operation of the flow bot set will result in an error, so please be careful. ・Paid plans such as the mini plan can be tried for free for two weeks. During the free trial, you can use restricted apps and features (operations). ・The maximum downloadable file size is 300MB. Depending on the app's specifications, it may be less than 300MB, so please be careful. ・Details of the file size that can be handled by triggers and each operation are here ・Triggers can be set to activate at intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan.
■Overview Are you finding it cumbersome to constantly check images uploaded to Google Drive and share their contents with your team? By utilizing this workflow, you can automate the entire process where Gemini automatically analyzes the content of new images added to Google Drive and instantly notifies Chatwork of the results, eliminating the need for manual image checking and reporting.
■Recommended for ・Those responsible for regularly checking and sharing the contents of images uploaded to Google Drive ・Those who want to automate the identification of objects in images and the generation of descriptions using AI ・Anyone looking to streamline daily routine tasks and allocate more time to creative work
■Notes ・Please integrate Google Drive, Gemini, and Slack with Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan. ・The maximum downloadable file size is 300MB. Depending on the app's specifications, it may be less than 300MB, so please be aware. ・For details on the file size that can be handled by triggers and each operation, please refer to the following. https://intercom.help/yoom/en/articles/9413924
■Overview Are you overwhelmed with handling inquiries and sharing information in Microsoft Teams, and finding it time-consuming to review posts and craft appropriate responses? Handling everything manually not only takes time but can also lead to inconsistent response quality. By leveraging this workflow, Gemini automatically analyzes messages posted to Microsoft Teams and posts the generated response to the channel, helping resolve these communication challenges.
■Who we recommend this template for ・Those who want to streamline inquiry handling in Microsoft Teams and shorten the time to reply ・Team leaders who want Gemini to summarize discussions and information in specific internal channels and use them as knowledge ・Those who want to incorporate generative AI into their operations to eliminate manual effort in gathering information and creating responses
■Notes ・Please connect Yoom with both Microsoft Teams and Gemini. ・Microsoft 365 (formerly Office 365) has consumer plans and commercial plans (Microsoft 365 Business). If you are not subscribed to a commercial plan, authentication may fail. ・You can select a trigger interval of 5, 10, 15, 30, or 60 minutes. ・The minimum trigger interval varies by plan, so please be aware.
■Overview This is a flow that generates a text with Gemini and replies when a message is posted on Discord. You can automatically respond to user questions using the Discord FAQ Bot.
■Recommended for the following individuals Those who utilize Discord as a communication tool ・Administrators who feel the burden of responding to frequently asked questions
Those who utilize Gemini in their business ・Those who want to introduce AI automated responses and automate FAQ handling
Those considering introducing a chatbot ・Company representatives aiming to improve the efficiency of support operations and increase user satisfaction
■Notes ・Please integrate Discord and Gemini with Yoom.
■Overview The workflow "Receive inquiries on Slack and reply by generating text with Gemini" aims to improve the efficiency of customer support operations. Gemini automatically generates appropriate reply text for inquiries received on Slack, ensuring quick and consistent responses. By utilizing this integration, you can reduce the burden of support operations while enhancing customer satisfaction.
■Recommended for ・Individuals using Slack as a customer support tool ・Those who have implemented Gemini and want to incorporate automated reply functionality into their operations ・Business owners who want to improve the quality and speed of inquiry responses using AI ・Administrators who want to streamline support operations and reduce the burden on their team
■Notes ・Integrate Slack and Gemini with Yoom respectively. ・You can select trigger 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.
■Overview The 'When an email is received in Gmail, summarize the content with Gemini and notify' workflow is a business workflow designed for quickly understanding received email content and efficiently responding. By leveraging the integration of Gmail and Gemini, you can ensure you don't miss important information and smoothly progress with daily work.
■Recommended for: - Business professionals who receive a large volume of emails daily and spend time understanding the content. - Those who primarily use Gmail as their email service and want to streamline their email management. - Those who want to automate email content summarization and notification using Gemini's AI features. - Executives or team leaders looking to improve productivity through workflow automation. - Administrators who want to quickly share important email information and facilitate communication within the team.
■Cautions - Please integrate Gmail and Gemini with Yoom. - Triggers can be set at 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.
■Overview This workflow allows you to summarize the content with Gemini and notify when an email is received in Outlook. This automation helps you save time while accurately catching up on necessary information. With Yoom, you can easily connect apps without programming.
■Recommended for ・Business people who receive a large number of emails daily and want to manage the content efficiently ・Those who want to incorporate email summarization using Gemini ・Those who want to automate notifications of important emails by integrating with Outlook ・Those interested in automating business workflows and want to utilize Yoom ・Leaders who want to smoothly share information within the team
■Notes ・Please connect each of Outlook, Gemini, and Slack with Yoom. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan.
👏 Benefits of Integrating Google Sheets with Gemini
Benefit 1: Easier Review of Key Points
Gemini automatically summarizes and appends content in Google Sheets, helping team members quickly grasp key information from lengthy documents.
For example, after recording sales meeting minutes in Google Sheets, Gemini summarizes the main topics and decisions, saving time on review. Since the summarized information stays in the Google Sheets, it’s easy to access when reviewing past content. This streamlines project progress as the key points can be grasped easier.
Benefit 2: Smoother Information Sharing Among Teams
By integrating Google Sheets with Gemini, data from different departments can be automatically aggregated into a central hub.
For instance, combining client data from sales and survey results from marketing into one Google Sheets makes it accessible to all stakeholders. This can enable smoother information sharing, helping to track progress and make informed decisions.
📖 Summary
By integrating GoogleSheets and Gemini with Yoom, you can automate various tasks like summarizing meeting content, organizing data, and streamlining your workflow. In this article, we focused on how to automatically summarize content added to Google Sheets using Gemini and update the sheet with the generated summary. These automations can reduce manual work, save time, and ensure consistency.
Best of all, no specialized knowledge is needed, and anyone can easily set it up! Ready to simplify your workflows? Sign up for Yoom and try it today!
With five years of experience as an SEO writer, I continue to write with the motto of being "easy to read" and "easy to understand." I want to convey the convenience of Yoom, which allows app integration without programming knowledge, to as many people as possible!
.avif)
.avif)
