Send weekly SEO and AIO reports with Umami, Groq and Airtable
Ready for 3.0What this workflow does
This workflow has 21 nodes and runs on a schedule (every week at 07:00). It uses only n8n's built-in nodes. It also calls api.groq.com over HTTP.
How it runs
Trigger: On a schedule (every week at 07:00).
- Config (Edit Fields (Set)): sets 13 fields: GROQ_MODEL, GROQ_MAX_TOKENS, GROQ_TEMPERATURE…
- Umami — login (HTTP Request): calls an HTTP API (POST)
- Store token (Edit Fields (Set)): sets 1 field: _umami_token
- Get client list (HTTP Request): calls an HTTP API
- Flatten records + inject token (Code): runs custom JavaScript code
- Loop each client (Loop Over Items (Split in Batches)): loops over the items in batches
- Has client? (If): checks a condition and branches into true / false
- Umami — this week (HTTP Request): calls an HTTP API
- Umami — prior week (HTTP Request): calls an HTTP API
- Umami — top pages (HTTP Request): calls an HTTP API
…plus 10 more steps. See the full node list below.
HTTP calls to: api.groq.com
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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Send Email
n8n-nodes-base.emailSend - Wait
n8n-nodes-base.wait
From the author
Quick Overview This workflow runs every Monday and generates per-client weekly SEO and AIO reports by pulling analytics from Umami, using Groq to write the report, emailing a branded HTML version, posting a Slack summary via webhook, and storing the results…