Free · no code · ~5 min

Automate your weekly client reports

Monday reporting is a tax on every agency: exporting numbers, writing the same “here’s what happened” narrative per client, every single week.

Keep each client’s metrics in a Google Sheet. Every Monday the workflow reads the week’s numbers, writes a plain-English narrative — what moved, why, and what’s next — and emails it to the client.

The working template

Weekly Client Report

Every Monday, turn the week’s metrics into a clear client-facing narrative report — what happened, why, what’s next — and email it automatically.

What you’ll need

  • A free n8n account (cloud or self-hosted)
  • A Google account (for Sheets)
  • A Gmail account (or swap in Outlook/SMTP)
  • An OpenAI API key (any OpenAI-compatible key works)

Common questions

Where do the metrics come from?

Any source you can get into a sheet — GA4, Meta Ads, Shopify, a dashboard export. You paste or pipe the week’s row in.

Can I run it per client?

Yes — duplicate the workflow per client and point each at its own sheet and recipient.

Want it built for you instead?

We’ll set this up in your tools, customized, running within 7 days.