Send white-label ad performance reports with Claude, Gmail and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (every month at 08:00). Along the way it connects Gmail and Google Sheets. It also calls api.anthropic.com over HTTP.
How it runs
Trigger: On a schedule (every month at 08:00).
- Set Branding and Report Config (Edit Fields (Set)): sets 9 fields: agencyName, agencyLogoUrl, brandColorHex…
- Fetch Platform Metrics (HTTP Request): calls an HTTP API (GET)
- Normalize Metrics (Code): runs custom JavaScript code
- Generate Client Summary (HTTP Request): calls api.anthropic.com (POST)
- Build Branded Report (Code): runs custom JavaScript code
- Send Branded Report Email (Gmail): uses Gmail
- Append Report to Log (Google Sheets): append
Services it uses
HTTP calls to: api.anthropic.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick Overview This scheduled workflow pulls ad performance data from a configurable platform API, normalizes key metrics, generates a client-friendly narrative with Anthropic Claude, then emails a branded HTML report via Gmail and logs the results to Google…