Automate unified marketing reports with Google Analytics, Google Ads, Meta Ads & HubSpot
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 workflow has 29 nodes and runs on a schedule (every week at 09:00) (plus 1 other trigger). Along the way it connects Gmail, Google Sheets, Google Analytics and Google Ads and 1 more.
How it runs
Trigger: On a schedule (every week at 09:00) (plus 1 other trigger).
- check month and week (Code): runs custom JavaScript code
- Set Websites and Campaings (Edit Fields (Set)): sets 3 fields: websites, isWeekly, isMonthly
- Fetch (HubSpot): get many
- Expand Websites (Split Out): splits a list into separate items
- Filter Hubspot Leads (Code): runs custom JavaScript code
- Attach Run Flags (Edit Fields (Set)): sets 5 fields: isWeekly, isMonthly, name…
- Summarize Hubspot Leads (Code): runs custom JavaScript code
- Loop Websites (Loop Over Items (Split in Batches)): loops over the items in batches
- Prepare Report Data (Code): runs custom JavaScript code
- Append or update row in sheet (Google Sheets): append or update
…plus 17 more steps. See the full node list below.
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 (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Switch
n8n-nodes-base.switch - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Google Analytics
n8n-nodes-base.googleAnalytics - Google Ads
n8n-nodes-base.googleAds - HTTP Request
n8n-nodes-base.httpRequest - HubSpot
n8n-nodes-base.hubspot
From the author
How it works This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CRM leads, then calculates KPIs and insights…