Skip to content
FlowHubFluxonLab
A
AI Automationfree

Send weekly Vercel analytics digest emails with Groq and SMTP

by Yash Kabraadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentCCodeGroq Chat ModelGroq Chat ModelHTTP RequestHTTP RequestSend EmailSend Email
Share Post Share
ScEvery Monday 9 AMEvery Monday 9 …SeSet ConfigHRFetch Vercel SummaryFetch Vercel Su…HRFetch Vercel Top PagesFetch Vercel To…HRFetch Vercel ReferrersFetch Vercel Re…CoBuild ReportAgDigest AgentGroq ModelCoRaw Stats FallbackRaw Stats Fallb…ESSend Digest EmailSend Digest Ema…12345678910
1/5
STEPS · 10
Runs on a schedule

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.

Tags

n8nreference-onlyagentemail-sendlm-chat-groq
Connects
AAI AgentCCodegroqchatmodelGroq Chat ModelWHTTP RequestsendemailSend Email
CategoryAI Automation
Triggermanual
Complexitycomplex
Nodes10
AddedJul 9, 2026

Related workflows

See all AI Automation
ACgmailsheets
free

Screen LinkedIn jobs and send tailored applications with Apify and OpenAI

Quick overview This workflow collects your job preferences via an n8n form, uses Apify to scrape LinkedIn job listings, and has OpenAI screen and rank them. After you approve a shortlist by Gmail, it generates tailored resume and cover-letter PDFs with DocRaptor, emails them to you, and logs matches to Sheets How it works Receives your job preferences and resume text through an n8n form submission. Sends the preferences to Apify to scrape recent LinkedIn jobs, then removes duplicates and obvious mismatches (seniority, years of experience, and location). Uses OpenAI to score each job’s relevance and eligibility and returns a JSON verdict with a fit score and short reason. Keeps the top matches above the configured threshold and emails you a shortlist in Gmail with approve/decline buttons. If you approve, uses OpenAI to draft a job-specific resume and cover letter from only the provided profile text and generates HTML interview prep questions. Converts the resume and cover letter HTML into PDFs via DocRaptor, emails the tailored application package to you in Gmail, and appends the match details to a Google Sheets tracker. Setup Add credentials for OpenAI, Gmail OAuth2, Google Sheets

by Dr. Firas
ACW
free

Run a multimodal WhatsApp AI assistant with OpenAI for text, voice and images

Quick overview This workflow turns WhatsApp into a multimodal assistant that answers text, voice notes, images, and PDF documents using OpenAI, and can generate images with DALL·E on demand, replying back in WhatsApp with either text, audio, or an image. How it works Triggers when a new WhatsApp message is received. Detects whether the incoming message is text, a voice note, an image, a PDF document, or an unsupported type. For text messages, generates an image with OpenAI DALL·E when the message starts with the configured /image command, and sends the generated image back to the sender. For voice notes, fetches the WhatsApp media URL, downloads the audio, transcribes it with OpenAI, and forwards the transcript to the assistant. For images, fetches the WhatsApp media URL, downloads the image, describes it with OpenAI vision using the configured analysis prompt, and forwards the description (plus any caption) to the assistant. For PDF documents, downloads the file from WhatsApp, extracts the PDF text, and forwards the extracted content (plus any caption) to the assistant, while non-PDF files receive an error message. Uses an OpenAI chat model with per-contact short-term memory to ge

by Dr. Firas
ACDgmail
free

AI: Summarize podcast episode and enhance using Wikipedia

The workflow automates the process of creating a summarized and enriched podcast digest, which is then sent via email. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team