Send weekly Vercel analytics digest emails with Groq and SMTP

Description

Quick Overview
This workflow runs every Monday, pulls the last 7 days of Vercel Web Analytics data, uses Groq (Llama 3.3 70B) to generate an HTML summary, and emails a weekly digest via SMTP, with an automatic raw-stats fallback if the AI step fails.

How it works
Runs every Monday at 9:00 AM based on your n8n instance timezone.
Builds the reporting window and key settings (Vercel project/team IDs, site name, sender, and recipient) and generates millisecond timestamps for the last 7 days.
Calls the Vercel Web Analytics Query API to fetch total page views and unique visitors, then fetches the top 5 pages and top 5 referrer hostnames for the same time range.
Consolidates the three Vercel responses into a single JSON report with calculated pages-per-visit and defensive handling for missing or empty data.
Sends the report to Groq Llama 3.3 70B to produce a structured HTML digest with headline, metrics, top pages, traffic sources, and a single actionable insight.
If the Groq request errors, generates a plain HTML “raw numbers” version of the digest instead.
Sends the final HTML digest email via SMTP using the configured sender and recipient addresses.

Setup
Create a Vercel API token and add an n8n HTTP Header Auth credential that sets Authorization: Bearer for the Vercel API requests.
Update the configuration values in the Set Config step (Vercel Project ID, optional Team ID, site name, senderEmail, recipientEmail, and optionally the since/until date range).
Add a Groq API credential and ensure the Groq chat model is accessible for the agent step.
Add an SMTP credential and confirm the from/to addresses are allowed by your mail server settings.