When a row is added to Google Sheets, analyze it with Gemini and send a message to Google Chat

■Overview

Reviewing customer feedback, survey results, and other data accumulated in Google Sheets and sharing it with your team each time can be time-consuming. With this workflow, whenever a new row is added to Google Sheets, Gemini automatically analyzes the content and sends a summary to Google Chat. By connecting Gemini with Google Chat, you can automate information sharing and help your team respond faster.

■Who This Template Is For

• Anyone who manually summarizes Google Sheets data and shares it in Google Chat
• Anyone looking to automate routine text analysis and summarization with Gemini
• Team leaders looking to connect Gemini with Google Chat to streamline information sharing and improve efficiency

■Benefits of Using This Template

• Automate the process from adding data to a spreadsheet through analysis and sharing, reduce time spent on manual work, and focus on more important tasks.
• Gemini analyzes and summarizes content based on consistent rules, helping prevent inconsistencies and missed updates while standardizing the quality of your operations.

■Workflow

1. First, connect Google Sheets, Gemini, and Google Chat with Yoom.
2. Next, select Google Sheets as the trigger and set the “When a row is added” action.
3. Then, select Gemini as the operation and set the “Generate content” action to analyze and summarize the information from the spreadsheet.
4. Finally, select Google Chat as the operation and set the “Send a message” action to send the content generated by Gemini to the specified space.

※ “Trigger”: An action that starts the workflow. “Operation”: An action that processes data within the workflow after the trigger starts.

■Customization Options

• In the Google Sheets trigger settings, specify the spreadsheet, sheet, and table range to read as needed.
• For the Gemini action, freely customize the prompt based on the type of text you want to generate. You can also insert information retrieved from Google Sheets as variables.
• In the Google Chat notification settings, specify the space where you want to send the message. The message body can include not only fixed text but also information retrieved in previous operations as variables.

■Notes

• Connect Google Sheets, Gemini, and Google Chat with Yoom.
• You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
• Note that the shortest available trigger interval varies by plan.
• Google Chat can only be connected when using Google Workspace. See below for details.
  Learn more