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. An n8n automation workflow template by Yash Kabra.

Categories

Tags

Capabilities

• 5 nodes
• 1 views