Recipe No. 49 · Reporting
Weekly client report email
Pull weekly metrics from Google Sheets/Analytics, have AI write a plain-English summary, and draft the client email.
- Plan needed
- n8n: free to self-host (you pay hosting) or n8n Cloud (paid). Check your plan.
- Est. SMS cost
- No SMS needed
- TriggerSchedule Trigger
- Step 2Google Analytics node or Google Sheets 'Get…
- Step 3OpenAI node
- Step 4Gmail 'Create Draft' to the client with the…
- Step 5Review and send manually
Ingredients
- Google Analytics 4 or a metrics Google Sheet
- n8n
- OpenAI credentials
- Gmail
Editor-reviewedLast checked 2026-10-16v1.0.0 · Free
Steps reviewed against current tool UIs by the editor; not yet run end-to-end in a live account. Time saved is an estimate; results vary. Costs from Axis Consulting and Twilio pricing; check current pricing.
Method
- Schedule Trigger: Mondays 7:00.
- Google Analytics node (Get Report: sessions, conversions, last 7 days) or Google Sheets 'Get Rows'.
- OpenAI node: 'Summarize these metrics for a non-technical client in 5 bullet points. Compare to prior week. Do not invent numbers.' Pass the raw data.
- Gmail 'Create Draft' to the client with the summary and raw numbers table.
- Review and send manually; check figures against the source each time.