Generate & distribute market reports with Google Docs, Sheets, and Gmail
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Cron, Function (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 7 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Docs, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (legacy Cron node).
- 1. HTTP Request (Get Market Data) (HTTP Request): calls an HTTP API
- 2. Function (Process Data) (Function): runs custom JavaScript (legacy Function node)
- 3. Google Docs (Create Report) (Google Docs): uses Google Docs
- 4. Google Sheets (Get Client List) (Google Sheets): uses Google Sheets
- 5. Split In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- 6. Gmail (Send Report) (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron in 0. Cron (Monthly Schedule): replace with Schedule Trigger.
- Function (legacy) in 2. Function (Process Data): replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron 0. Cron (Monthly Schedule) | Schedule Trigger |
| Function (legacy) 2. Function (Process Data) | Code node, mode 'Run Once for All Items' |
Nodes used (7)
- Cron
n8n-nodes-base.cron - HTTP Request
n8n-nodes-base.httpRequest - Function
n8n-nodes-base.function - Google Docs
n8n-nodes-base.googleDocs - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail
From the author
How It Works ⚙️ This workflow is a powerful automation engine for your marketing efforts. On a set schedule, it automatically generates a professional market report and distributes it to your client list, positioning you as a market expert with zero manual…