Consolidate data from 5 sources for automated reporting with SQL, MongoDB & Google tools
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 14 nodes and runs on a schedule (every week). Along the way it connects Google Sheets, Postgres, MongoDB and Microsoft SQL and 1 more.
How it runs
Trigger: On a schedule (every week).
- Google Sheets: uses Google Sheets
- Postgres: select
- MongoDB: uses MongoDB
- Microsoft SQL: run a query
- Google Analytics: work with user activity
- Add Sheets Source ID (Function): runs custom JavaScript (legacy Function node)
- Add PostgreSQL Source ID (Function): runs custom JavaScript (legacy Function node)
- Add MongoDB Source ID (Function): runs custom JavaScript (legacy Function node)
- Add SQL Server Source ID (Function): runs custom JavaScript (legacy Function node)
- Add Analytics Source ID (Function): runs custom JavaScript (legacy Function node)
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in ⚙️ Process Merged Data, Add Sheets Source ID, Add PostgreSQL Source ID…: 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 |
|---|---|
| Function (legacy) ⚙️ Process Merged Data, Add Sheets Source ID, Add PostgreSQL Source ID, Add SQL Server Source ID, Add MongoDB Source ID, Add Analytics Source ID | Code node, mode 'Run Once for All Items' |
Nodes used (8)
- Google Sheets
n8n-nodes-base.googleSheets - Postgres
n8n-nodes-base.postgres - MongoDB
n8n-nodes-base.mongoDb - Function
n8n-nodes-base.function - Microsoft SQL
n8n-nodes-base.microsoftSql - Google Analytics
n8n-nodes-base.googleAnalytics - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works This workflow consolidates data from five different systems — Google Sheets, PostgreSQL, MongoDB, Microsoft SQL Server, and Google Analytics — into a single master Google Sheet. It runs on a scheduled trigger three times a week. Each dataset is…