At a glance
- Trigger
- Schedule Trigger (Schedule Trigger)
- Nodes
- 13
- Apps
- Google Analytics, Email (SMTP), Telegram and OpenAI
- AI nodes
- 3
- Credentials
- 4 types
- Category
- Content, SEO and social media
Apps and integrations
Node types used
How it works
The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.
Welcome to my Google Analytics Weekly Report Workflow!
This workflow has the following sequence
- time trigger (e.g. every Monday at 7 a.m.)
- retrieval of Google Analytics data from the last 7 days
- assignment and summary of the data
- retrieval of Google Analytics data from the last 7 days of the previous year
- allocation and summary of the data
- preparation in tabular form and brief analysis by AI.
- sending the report as an email
- preparation in short form by AI for Telegram (optional)
- sending as Telegram message.
The following accesses are required for the workflow
- Google Analytics (via Google Analytics API)
- AI API access (e.g. via OpenAI, Anthropic, Google or Ollama)
- SMTP access data (for sending the mail)
- Telegram access data (optional for sending as Telegram message)
You can contact me via LinkedIn, if you have any questions
Nodes in this workflow
The 13 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:
- Schedule Trigger (Schedule Trigger)
- Google Analytics Letzte 7 Tage (Google Analytics)
- Send Email (Send Email)
- Telegram (Telegram)
- Processing for Telegram (OpenAI)
- Calculator (Calculator Tool)
- Google Analytics: Past 7 days of the previous year (Google Analytics)
- Summarize Data (Summarize)
- Summarize Data1 (Summarize)
- Calculation same period previous year (Code)
- Assign data (Edit Fields (Set))
- Assign data1 (Edit Fields (Set))
- Processing for email (OpenAI)
Credentials you need
- Google Analytics OAuth2 – used by Google Analytics Letzte 7 Tage and Google Analytics: Past 7 days of the previous year
- OpenAI API – used by Processing for Telegram and Processing for email
- SMTP – used by Send Email
- Telegram Bot API – used by Telegram
Configure your own credentials after importing. Create each credential in n8n, then select it in the node.
How to import into n8n
- Download the JSON file with the button above.
- In n8n, open a new workflow, select the ... menu and choose Import from File. You can also paste the JSON straight into the editor canvas.
- Open each node that shows a warning and select or create its credential.
- Read the notes on the canvas, test the workflow with sample data, then activate it.
Do you need somewhere to run it? Read our guide to self-hosted n8n.