Auto-generate sales insights from Sheets using Gemini and notify teams instantly
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, Google Gemini Chat Model, Gmail and Trello and 2 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Save to Sheet (Google Sheets): append
- Get All Rows (Google Sheets): uses Google Sheets
- Concat Sales Data (Code): runs custom JavaScript code
- Generate Insights (Summarization Chain): summarizes text with AI, with model: Google Gemini Chat Model
- Send a message (Gmail): uses Gmail
- Remove HTML Tags (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Classify Insight (Text Classifier): classifies text into categories with AI, with model: Google Gemini Chat Model
- Notify Group (Telegram): uses Telegram
- Create a backlog (Trello): uses Trello
- Create a meeting (Google Calendar): uses Google Calendar
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Summarization Chain
@n8n/n8n-nodes-langchain.chainSummarization - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Trello
n8n-nodes-base.trello - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Telegram
n8n-nodes-base.telegram - Google Calendar
n8n-nodes-base.googleCalendar
From the author
Daily Sales Metrics Auto-Insight with Gemini, Google Sheets, Calendar, Telegram, Trello and Gmail Who’s it for This workflow is ideal for sales managers, operations teams, and business owners who need daily automated sales summaries and team notifications. It…