Weekly Google Analytics report with GPT-4o analysis & email delivery
UnknownWhat this workflow does
This AI workflow has 13 nodes and runs on a schedule (every week). Along the way it connects Gmail, Google Analytics, OpenAI and Htmlcsstopdf (community).
How it runs
Trigger: On a schedule (every week).
- Generate Date Range (Code): runs custom JavaScript code
- GA This Week (Google Analytics): uses Google Analytics
- GA Last Week (Google Analytics): uses Google Analytics
- Extract GA This Week (Code): runs custom JavaScript code
- Extract GA Last Week (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Calculate Differences (Code): runs custom JavaScript code
- Message a model (OpenAI): uses OpenAI
- Generate chart (Code): runs custom JavaScript code
- Report template (HTML): parses or builds HTML
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-htmlcsstopdf is verified or supports 3.0 (used in HTML to PDF).
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Google Analytics
n8n-nodes-base.googleAnalytics - Merge
n8n-nodes-base.merge - Htmlcsstopdf
n8n-nodes-htmlcsstopdf.htmlcsstopdf - HTML
n8n-nodes-base.html - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Overview The workflow automatically gathers weekly user and page view metrics. It then uses AI to analyze, compare, and compile a summary report. Finally, it sends the report to the manager's email. How it works Get Data from GA Automatically retrieve data…