・
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.
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.
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.
👉 Sign Up for Yoom Here – Quick and Easy in Just 30 Seconds!
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.
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.
■Overview
This is a flow that summarizes the content added to Google Sheets using Gemini and updates it in Google Sheets.
■Recommended for
1. Those who 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. Those who utilize Gemini for business
・Those who frequently use Gemini to summarize text
・Those who find summarizing meeting content time-consuming
■Benefits of using this template
Google Sheets is an effective tool for managing data in the cloud, making it useful for information sharing and data accumulation.
However, if you are summarizing and sharing meeting content accumulated in Google Sheets among teams, you might find it time-consuming and cumbersome.
This template allows you to update the summarized results in Google Sheets using Gemini when a row is added, thus streamlining the summarization process.
Even if there is a lot of meeting content that takes time to summarize, the content can be summarized quickly, allowing for a reduction in work time.
Additionally, by sending notifications from chat tools, you can share the summary results with the team, enabling smooth progress in work.
■Notes
・Please integrate both Google Sheets and Gemini with Yoom.
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
If you don’t have a Yoom account yet, register now from this registration form!
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.
⚠️ 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 :)
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.
For the access token, go to the Gemini API acquisition page.
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 :)
Click the "Try It" button to copy the pre-built template into your project.
■Overview
This is a flow that summarizes the content added to Google Sheets using Gemini and updates it in Google Sheets.
■Recommended for
1. Those who 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. Those who utilize Gemini for business
・Those who frequently use Gemini to summarize text
・Those who find summarizing meeting content time-consuming
■Benefits of using this template
Google Sheets is an effective tool for managing data in the cloud, making it useful for information sharing and data accumulation.
However, if you are summarizing and sharing meeting content accumulated in Google Sheets among teams, you might find it time-consuming and cumbersome.
This template allows you to update the summarized results in Google Sheets using Gemini when a row is added, thus streamlining the summarization process.
Even if there is a lot of meeting content that takes time to summarize, the content can be summarized quickly, allowing for a reduction in work time.
Additionally, by sending notifications from chat tools, you can share the summary results with the team, enabling smooth progress in work.
■Notes
・Please integrate both Google Sheets and Gemini with Yoom.
Click "Try this template".
Click "OK" and assign a name to the Flowbot for recognition.
This template will be copied to your “My Project”.
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”.
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.
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.
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 :)
■Overview
This is a flow that summarizes the content added to Google Sheets using Gemini and updates it in Google Sheets.
■Recommended for
1. Those who 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. Those who utilize Gemini for business
・Those who frequently use Gemini to summarize text
・Those who find summarizing meeting content time-consuming
■Benefits of using this template
Google Sheets is an effective tool for managing data in the cloud, making it useful for information sharing and data accumulation.
However, if you are summarizing and sharing meeting content accumulated in Google Sheets among teams, you might find it time-consuming and cumbersome.
This template allows you to update the summarized results in Google Sheets using Gemini when a row is added, thus streamlining the summarization process.
Even if there is a lot of meeting content that takes time to summarize, the content can be summarized quickly, allowing for a reduction in work time.
Additionally, by sending notifications from chat tools, you can share the summary results with the team, enabling smooth progress in work.
■Notes
・Please integrate both Google Sheets and Gemini with Yoom.
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!
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.
■Overview
This flow summarizes responses from a form using Gemini and adds them to a Google Spreadsheet.
You can automatically summarize the information collected from the form with Gemini and seamlessly integrate it into Google Spreadsheets.
■Recommended for
■Benefits of using this template
While Gemini summaries can be used to quickly check the content received in the form, manual summarization takes time.
In this flow, the content submitted to the form is automatically summarized by Gemini, and the results are added to a Google Spreadsheet. This reduces the effort of organizing data and manual input, thereby improving business efficiency.
By significantly reducing the time previously spent on manual work, you can increase the overall pace of business operations.
Additionally, by centrally managing information in Google Spreadsheets, you will enhance the team's information accessibility.
■Overview
This is a flow that summarizes Slack posts using Gemini and adds them to Google Sheets.
You can efficiently manage daily communication on Slack.
■Recommended for
■Benefits of using this template
Understanding lengthy content takes time, but by utilizing AI like Gemini, you can efficiently summarize it.
However, summarizing manually carries the risk of human error.
By using this flow, important information posted on Slack is automatically summarized by Gemini and organized and recorded in Google Sheets. This eliminates manual work and prevents errors from manual input.
Additionally, since the information is centrally managed in Google Sheets, checking and sharing information becomes smoother, leading to improved productivity for the entire team.
■Overview
This is a flow that summarizes the content of Gmail using Gemini and adds it to Google Sheets.
By summarizing with Gemini, you can streamline email management.
■Recommended for
■Benefits of using this template
Having to read and understand email information each time can be time-consuming and may affect the progress of other tasks.
This flow automatically summarizes emails received in Gmail using Gemini and organizes the summary content in Google Sheets. This allows you to quickly check important information at a glance, making data management smoother.
Additionally, automation prevents human errors during manual input, enabling accurate data management. By reducing operational mistakes, it facilitates smooth business operations.
Issue Documents Based on Google Sheets Data
Automatically generate documents like Google Docs based on Google Sheets data.
■Overview
This is a flow that issues an invoice and saves it to Google Drive when a row in a Google Spreadsheet is updated.
By using Yoom, you can easily connect apps without the need for programming.
■Recommended for
1. Those who manage data with Google Spreadsheets
・Those who manage data such as billing information using Google Spreadsheets but find it cumbersome to issue invoices manually
2. Companies that use Google Drive for file storage and sharing
・Those who use Google Drive regularly and want to utilize it for saving and sharing invoices
・Those who want to advance automation but don't know where to start
■Benefits of using this template
By implementing this automation flow, there is a benefit that an invoice is automatically generated and saved to Google Drive every time a row in a Google Spreadsheet is updated.
This reduces the effort of creating invoices and enables highly accurate billing management.
Additionally, it reduces errors associated with manual invoice creation and allows for efficient business operations.
Furthermore, by digitizing invoices, they can be accessed anytime, anywhere, enabling quick responses.
As a result, customer satisfaction and business reliability are likely to improve.
Add Transcribed Audio to Google Sheets After an Online Meeting
Automatically transcribe and add audio content from Google Meets or Zoom to Google Sheets.
◼️Overview
Automatically transcribe and summarize conversations held on Zoom and record them in a Google Spreadsheet.
This helps avoid missing parts of the conversation and allows you to manage it in Google Spreadsheet, thereby increasing work efficiency.
◼️Notes
・Please integrate Yoom with both Zoom and Google Spreadsheet.
・AI operations are available only with the Team Plan and Success Plan.
・For Free Plan and Mini Plan users, the operation of the configured Flowbot will result in an error, so please be aware.
・Paid plans such as the Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use restricted apps and AI features (operations).
■Overview
This is a flow to transcribe audio after a Google Meet meeting and add it to a Google Spreadsheet.
By using Yoom, you can easily connect apps without the need for programming.
■Recommended for
1. Those who create audio files during meetings
・Those who transcribe meeting audio files and save them as minutes
・Those who find manual data entry cumbersome and want to transcribe audio files efficiently
2. Those who utilize Google Spreadsheets for business
・Those who use it for centralized data management
・Those who use shared sheets to facilitate smooth information sharing
■Benefits of using this template
The audio files from Google Meet meetings can be used to create minutes, but transcribing that data can be burdensome for employees.
By utilizing this integration, you can transcribe the audio data from Google Meet meetings using AI and automatically add the results to Google Spreadsheets, reducing the workload on the responsible personnel.
With the meeting audio data quickly added to Google Spreadsheets, even members who did not attend the meeting can quickly grasp the content.
As a result, it is expected to improve the overall efficiency of the team.
Lead and Contact Management Automation
Easily add lead and customer information from Google Sheets to platforms like Salesforce or HubSpot.
■Overview
This is a flow that adds a record to Salesforce when a row is added in Google Sheets.
■Recommended for
1. Those who use Google Sheets for business
・Office workers who manage shared data and share information
・Sales assistants who share sheets with client companies and exchange information
2. Companies that manage deals with Salesforce
・Those who register and share the status of each project with their team
・Executives or sales managers who oversee all internal projects
■Benefits of using this template
Google Sheets allows for smooth accumulation and sharing of information, which helps facilitate business operations.
However, manually entering information from Google Sheets into Salesforce takes time away from tasks that should be prioritized.
This flow is effective for those who want to register information between different apps without spending much time.
By referencing the registration content in Google Sheets, you can also register it in Salesforce, preventing manual errors and saving effort.
■Notes
・Please integrate both Google Sheets and Salesforce with Yoom.
・Salesforce is an app available only with the Team Plan and Success Plan. If you are on the Free Plan or Mini Plan, the operations and data connections set in the flow bot will result in errors, so please be careful.
・Paid plans such as the Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use apps that are subject to restrictions.
■Overview
This is a flow that creates a contact in HubSpot when a row is added to a Google Spreadsheet.
■Recommended for
1. Those who use Google Spreadsheets for managing customer information
・Those who manage seminar or training participants using Google Spreadsheets
・Those who integrate data collected in Google Spreadsheets with other tools
2. Those who use HubSpot to advance their business operations
・Those who centrally manage customer information in HubSpot
・Those who want to streamline data entry into HubSpot
■Benefits of using this template
HubSpot is a cloud-based CRM platform that helps with centralized management of customer and transaction information.
However, creating contact information in HubSpot involves many input fields, making manual entry time-consuming and labor-intensive.
This flow is suitable for those who want to efficiently create contacts in HubSpot.
When customer information is added to a Google Spreadsheet, this flow can automate the creation of contacts in HubSpot, streamlining manual tasks.
Since data synchronization between tools is possible, even if different departments use separate tools, seamless data integration can be achieved.
■Notes
・Please integrate both Google Spreadsheets and HubSpot with Yoom.
・You can select trigger intervals of 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest trigger interval varies depending on the plan.
■Overview
This is a flow that adds a row to a Google Spreadsheet and then adds it to a SendGrid contact list.
■Recommended for
1. Those who want to improve work efficiency using Google Spreadsheets
・Those who manage lead information using Google Spreadsheets
2. Those who want to streamline email distribution using SendGrid
・Those who find it cumbersome to add information to the contact list each time
・Email marketers who want to easily manage new contact lists
■Benefits of using this template
The benefits of using this flow include the following:
Firstly, by integrating with Google Spreadsheets, information is automatically added to the SendGrid contact list, reducing workload and improving work efficiency.
By automating part of the manual work, you will be able to focus on other important tasks.
Additionally, this automated flow improves the accuracy of email marketing.
It becomes easier to maintain the contact list in an up-to-date state, enabling effective campaigns targeted at your audience, which also contributes to improved conversion rates.
■Notes
・Please integrate both Google Spreadsheets and SendGrid with Yoom.
Read Documents Uploaded to Cloud Storage
With Gemini, you can analyze and automate responses to content uploaded to cloud storage.
■Overview
The workflow "Summarize files uploaded to Google Drive with Gemini and issue documents" is an automated process to streamline document management.
This reduces the effort of organizing information and enables speedy sharing.
■Recommended for
■Benefits of using this template
■Overview
The "Read files with Gemini when uploaded to Google Drive" workflow is a system that automatically reads new files added to Google Drive with Gemini.
It reduces the hassle of daily increasing file management and achieves efficient data integration.
■Recommended for
■Benefits of using this template
■Overview
This flow analyzes images uploaded to Google Drive using Gemini and notifies the content to Slack. By using Yoom, you can easily connect apps without programming.
■Recommended for
1. Those who use Google Drive for sharing and storing images
・Those who frequently upload images to Google Drive and find manual classification and organization cumbersome
2. Those who want to utilize Gemini as an image analysis tool
・Those who want to efficiently manage image files
3. Those who use Slack as a communication tool
・Those who want to seamlessly share information with team members using Slack
■Benefits of using this template
By using this template, Gemini automatically analyzes images uploaded to Google Drive and notifies the results to Slack. There are several benefits to introducing this flow. First, you can quickly grasp the uploaded images. Since the content of the image is notified as text, you can understand the uploaded image without directly opening the image file, reducing the effort of checking. Additionally, it is effective for strengthening collaboration with members. You can communicate smoothly as you can interact directly based on the notification content in the chat.
■Notes
・Please connect Yoom with Google Drive, Gemini, and Slack.
・You can select the trigger interval from 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest trigger interval varies depending on the plan.
Generate Text and Reply to Messages
Analyze and generate a response to inquiries received in chat tools.
■Overview
This flow analyzes the content posted on Microsoft Teams using Gemini's assistant and updates the response back to Microsoft Teams.
■Recommended for
1. Those who want to improve the efficiency of internal FAQs and help desk operations
2. Those who want to promote the activation of internal communication
■Benefits of using this template
Microsoft Teams is increasingly being used not only for internal communication but also for customer support.
However, to respond quickly and accurately to customer inquiries, the knowledge and experience of the person in charge may be required, which can sometimes take time.
By utilizing this flow, the content posted on Microsoft Teams is automatically analyzed by Gemini's assistant to generate the optimal response.
The person in charge can quickly respond to customers by simply reviewing the generated response and making any necessary adjustments.
This can improve the efficiency and speed of customer support, leading to enhanced customer satisfaction.
■Notes
・Please integrate both Microsoft Teams and Gemini with Yoom.
・Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may fail.
■Overview
This is a flow where a message posted on Discord triggers Gemini to generate a response.
You can use the Discord FAQ Bot to automatically respond to user inquiries.
■Recommended for
■Benefits of using this template
By utilizing this flow, you can automate FAQ handling, reducing the burden on staff and allowing them to focus on other important tasks.
Additionally, since Gemini automatically responds to questions on Discord immediately, you can reduce user wait times and improve the speed and efficiency of responses.
This also helps prevent human errors associated with manual responses, enabling the provision of accurate information.
■Overview
The "Receive inquiries on Slack and generate responses with Gemini" workflow is designed to streamline customer support operations.
When an inquiry is received on Slack, Gemini automatically generates an appropriate response, ensuring quick and consistent replies.
By utilizing this integration, you can reduce the burden of support tasks while enhancing customer satisfaction.
■Recommended for
■Benefits of using this template
By automatically generating responses with Gemini when inquiries are received on Slack, you can streamline customer support.
Gemini generates consistent responses to inquiries, improving the quality of customer interactions.
Automation helps prevent human errors in customer support, enhancing customer satisfaction.
Summarize and Share Email
Summarize Gmail, Outlook emails with Gemini when you receive an email and share them through chat tools.
■Overview
The workflow "Receive an email in Gmail and summarize the content with Gemini for notification" is a business workflow designed to quickly grasp the content of incoming emails and respond efficiently. By leveraging the integration of Gmail and Gemini, you can ensure that important information is not missed and smoothly progress with daily tasks.
■Recommended for
■Benefits of using this template
When you receive an email in Gmail, the content is automatically summarized and notified by Gemini, eliminating the need for manual summarization and notification tasks.
By automatically summarizing and notifying, you can ensure that important information is reliably shared with team members.
Automation prevents human errors in summarization and notification, improving the accuracy of information.
■Overview
This workflow allows you to summarize and notify the content in Gemini when you receive an email in Outlook. This automation enables you to catch up on necessary information accurately while saving time.
With Yoom, you can easily connect apps without the need for programming.
■Recommended for
■Benefits of using this template
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.
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.
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!
