Agency Monthly Client Report
Every client's monthly GA4 and Search Console report, written, checked, branded and emailed, after you approve it.
An n8n template for agencies and freelancers who send clients a monthly website report. Nothing goes to a client until you click Approve.
$79 one-time download · 14-day refund, email [email protected]
A look inside
What it does
- n8n 2.x
- Self-hosted
- GA4
- Search Console
- Gemini
- Resend or Gmail
GA4 and Search Console
Pulls last month and the month before from Google Analytics 4 and Search Console for each client on your list.
Plain English
Google Gemini writes a short summary: headline, what went well, what to watch, next steps.
Every number checked
If the AI writes a number that is not in the data, it is asked again. If it still gets it wrong, the report uses a summary built only from the data, and the approval email tells you.
Branded, 3 pages
The client's logo and color, KPI cards, charts, top pages and top searches. Made inside n8n, no paid PDF service, no Docker. Gotenberg is supported if you want it.
You approve first
The PDF is emailed to you with Approve and Reject buttons. Approve sends it to the client through Resend or Gmail.
Every report logged
Client, month, tokens, cost and status in an n8n Data Table, plus Google Sheets or Airtable if you like.
Details that save you trouble
- One client list for all clients. A client with a bad setting is skipped and reported, and the others still go out.
- A client and month that was already sent is not sent again by accident, so re-running the same month is safe.
- Sample data mode, so you can see the whole flow and the PDF before you connect Google.
- A test switch that sends every client email to you instead, marked [TEST].
- Every setting is checked before the run. A typo stops the run with a list of what to fix.
- An error workflow emails you what failed and what to do next, for example which Google property your account cannot see.
- No API keys inside the workflow files. They stay in n8n credentials.
- In our live test, one AI summary cost under one cent with the default Gemini model. Your provider bills you directly.
What has been tested, and what has not
Tested on self-hosted n8n 2.44.6:
- An automated suite of 19 scenarios with 63 checks, all passing. It runs the real workflows inside n8n with the outside services replaced by mocks, and covers approve, reject, an edited approval key, expiry, re-running a month, the number check catching an invented number, the data-only fallback, Google access errors, bad settings, a bad client row, logos and the Gotenberg engine.
- A live run with real Gemini and real Resend, using sample data for a made-up client. The number check passed, the approval email arrived in a Gmail inbox with the PDF attached, the Approve link resumed the run, and the test client email arrived and was logged as sent.
- The PDF output: a valid 3 page A4 file from the built-in engine.
Not tested yet
- Real Google Analytics 4 and Search Console accounts. The requests follow Google's documented formats and were tested against responses in that documented shape, but a real account could still behave differently.
- The Gmail sending option and Google Sheets as client list or log (these nodes ship switched off).
- Approving from a phone or another computer. This needs your n8n on a public HTTPS address (WEBHOOK_URL). Our tests ran on a local instance.
- Company email security tools that open links automatically. These could use up the approval link.
- Real Gotenberg (tested with a stand-in only).
- n8n Cloud, other n8n versions and queue mode with several workers.
The full test summary is in the download.
What you need
Requirements
- n8n with Data Tables, self-hosted. Built and tested on 2.44.6. n8n Cloud has not been tested.
- A Gemini API key from Google AI Studio.
- Resend with a verified domain, or a Gmail account.
- For real data: a Google account with access to your clients' GA4 and Search Console properties, and a Google OAuth credential in n8n. Sample data mode needs none of this.
- For approval links that work from your phone or inbox: n8n reachable at a public HTTPS address.
- Your own accounts with these providers. Their usage fees are billed to you by them.
Included files
- agency-report-scheduler.json
- agency-report-per-client.json
- agency-report-error-handler.json
- README.md setup guide with every setting explained
- TESTING.md: a 5 minute check and the test summary
- LICENSE.txt
- Screenshots
Good to know
- Setup takes about 20 minutes, most of it the Google OAuth credential.
- The number check covers numbers written with digits. You still read each report before approving it.
- English by default. You can set another language in Config.
License, refunds and support
This is a downloadable, self-serve software template, not a service. You import it into your own n8n and run it on your own accounts. VNCNT Labs does not host it and has no access to your data.
License: single account. Use it in your own n8n instances and in instances you run for your clients. Do not resell or redistribute the template files. Full terms are in LICENSE.txt.
Refunds: 14 days from purchase, whichever store you bought from. Email [email protected] with your order number. See the Refund Policy.
Agency Monthly Client Report
$79 · Same file on every store · Questions: [email protected]
Agency Monthly Client Report is an independent product of VNCNT Labs, sold by FAMVII LLC, doing business as VNCNT Labs. n8n is a trademark of n8n GmbH. Google Analytics, Search Console, Gemini, Resend, Gmail, Airtable and Gotenberg are trademarks of their owners. VNCNT Labs is not affiliated with or endorsed by any of them.