SVD OnlineSVD Online
EN|NL
← All workflows
Reporting and monitoringUses AI

Weekly data report

Every Monday morning, five data sources are pulled together and Claude writes a short summary of my week in my inbox.

Weekly data report: canvas view of the real n8n workflow, 14 nodes. Daily companion workflow · 4 nodes Daily Schedule Fetch Clarity Metrics Wrap With Date Store Clarity Metrics Weekly report workflow · 10 nodes Weekly Schedule Get Funnel Daily Get Leads Attribution Get Contact Messages Get Clarity Daily Get GA4 Report Build Report Prompt Parse Claude Response Send Report Email Call Claude API
The real workflow, redrawn from n8n so it stays sharp on any screen. Every node is here.

The problem it solves

Checking five dashboards every week is a task that is easy to skip and hard to do consistently. When the numbers live in different tools, nobody gets the full picture, and patterns get missed.

Built before the numbers moved

I built the reporting before I had the activity to fill it. The automation is running and the report is ready for when the numbers start to move. That is what building for scale before you need it looks like in practice: it does not feel like much, and it is much easier than scrambling to build it once things get busy.

This is a Frame-size build: the weekly report and the small daily workflow that feeds it, two connected workflows that share the database.

How it runs

  1. 1

    Daily

    A companion workflow stores Clarity metrics

    Every day, a small second workflow pulls the session metrics from Clarity and saves them, so the weekly report has the whole week to read.

  2. 2

    Schedule

    Every Monday morning

    The workflow starts on its own. Nobody has to remember to look at the numbers.

  3. 3

    Collect

    Five sources are pulled

    The lead and conversion funnel, leads attribution, contact form messages from the past week, Clarity session metrics and the GA4 traffic report.

  4. 4

    Prepare

    The data is shaped into a prompt

    Everything is combined into one clear set of numbers for Claude to read.

  5. 5

    Summarise

    Claude writes the report

    A written summary of the week, in plain language, not a wall of dashboards.

  6. 6

    Send

    It lands in my inbox

    Ready to read before the week gets going.

What it connects

  • n8n

    Runs on a weekly schedule and gathers the data.

  • Supabase

    Provides the lead funnel, attribution and contact form messages.

  • Clarity

    Provides session metrics, stored daily by a small companion workflow.

  • GA4

    Provides the traffic report.

  • Claude API

    Reads everything and writes the summary.

Works well with

Client deliveryPost-delivery follow-upAfter a project is delivered, every client gets a short sequence of follow-up emails, sent on schedule without me having to remember.View workflow →
Proposals and paymentsPayment and invoicingTwo connected workflows run the full payment cycle: a payment link and invoice go out when a project is ready, and a paid payment turns into a receipt, a booked invoice and a follow-up.View workflow →