Generate weekly sales insights with Google Sheets, Gemini AI and Gmail
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 9 nodes and runs on a schedule (every week at 21:00). Along the way it connects Gmail, Google Sheets and Google Gemini. It also calls quickchart.io over HTTP.
How it runs
Trigger: On a schedule (every week at 21:00).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Removing Empty Rows (Code): runs custom JavaScript code
- Filter Latest Week (Code): runs custom JavaScript code
- Sales Analytics Engine (Code): runs custom JavaScript code
- Message a model (Google Gemini): uses Google Gemini
- HTTP Request: calls quickchart.io
- Format Email (Edit Fields (Set)): sets or maps fields
- Send Email (Gmail): uses Gmail
Services it uses
HTTP calls to: quickchart.io
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 (7)
- Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
How it works This workflow automatically generates a weekly sales performance report from Google Sheets data. It runs on a schedule, cleans and filters the dataset, and calculates week-over-week performance metrics. An AI model generates a concise business…