Click "Try this template".

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 :)

💡 Other Automation Examples Using Google Sheets and Gemini

You can try out more automations by utilizing Google Sheets and Gemini with Yoom. <span class="mark-yellow">Here are some more examples you can explore for your next automation</span>!

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

Automation Example Using Google Sheets

Issue Documents Based on Google Sheets Data

Automatically generate documents like Google Docs based on Google Sheets data.

Add Transcribed Audio to Google Sheets After an Online Meeting

Automatically transcribe and add audio content from Google Meets or Zoom to Google Sheets.

Lead and Contact Management Automation

Easily add lead and customer information from Google Sheets to platforms like Salesforce or HubSpot.

Automation Example Using Gemini

Read Documents Uploaded to Cloud Storage

With Gemini, you can analyze and automate responses to content uploaded to cloud storage.

Generate Text and Reply to Messages

Analyze and generate a response to inquiries received in chat tools.

Summarize and Share Email

Summarize Gmail, Outlook emails with Gemini when you receive an email and share them through chat tools.

👏 Benefits of Integrating Google Sheets with Gemini

Benefit 1: Easier Review of Key Points

Gemini automatically summarizes and appends content in Google Sheets, <span class="mark-yellow">helping team members quickly grasp key information from lengthy documents</span>.

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, <span class="mark-yellow">data from different departments can be automatically aggregated into a central hub</span>.

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, <span class="mark-yellow">no specialized knowledge is needed, and anyone can easily set it up</span>! Ready to simplify your workflows? Sign up for Yoom and try it today!

👉 Create your free Yoom account now