PICKED FROM N8N.IO · REPORTING & OPERATIONS
This workflow pulls page engagement, search results and country views from Google Analytics for this week and the prior week. Code nodes tidy the numbers, combine them and build an HTML report with colour-coded tables. Gmail then emails the report, on a schedule or when you run it.
Template by Alex Kim · 18.8k views on n8n.io · listed there as “Automate google analytics reporting”
- DIFFICULTY
- Intermediate
- NODES
- 19
- USES AI
- No
- PUBLISHED
- November 2024
001 / WHAT HAPPENS
- 01
A schedule or manual trigger starts the run.
- 02
Six Google Analytics requests fetch engagement, search and country data for this week and last week.
- 03
Code nodes parse each result into a clean text string.
- 04
The data is aggregated and formatted into an HTML report with three coloured sections.
- 05
Gmail sends the finished report by email to your chosen address.
WHO IT SUITS
Suits an owner or marketer who wants a weekly website snapshot in their inbox without opening Google Analytics.
CONNECTS
- Google Analytics
- Gmail
002 / BEFORE YOU USE IT HERE
- !The nodes use the older Google Analytics node, which may only work with Universal Analytics. Check that it supports your GA4 property, or rebuild the requests.
- !Set the workflow timezone to Australia/Sydney (or your city) so the weekly comparison starts on the right day.
- !Property IDs and report fields are hard-coded. Replace them with your own, and expect to test the parsing code against your data.
LOCAL SWAP
Swap Gmail for the Microsoft Outlook node to send the report from a Microsoft 365 mailbox.
Need n8n and the AI hosted in Australia? →003 / MORE FOR REPORTING & OPERATIONS
- 15 NODESAI
REPORTING & OPERATIONS
Chat with Google Drive documents using Gemini and Pinecone
Google DriveGoogle GeminiPineconeAdvancedby Mihai Farcas352k views - 8 NODESAI
REPORTING & OPERATIONS
Ask an AI assistant questions about your Notion knowledge base
NotionOpenAIIntermediateby Max Tkacz51.1k views - 19 NODESAI
REPORTING & OPERATIONS
Book follow-up meetings from Google Meet transcripts with AI
Google CalendarGoogle DriveOpenAIGoogle MeetAdvancedby Jimleuk34.5k views
004 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.
We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.
Book a free call→