UTM Revenue Attribution Workflow: n8n + Google Sheets + Gmail

UTM revenue attribution that turns clicks into real money (and sends an executive summary)

This n8n workflow captures your leads from webhooks, standardizes UTM-based channel attribution in Google Sheets, matches won deals back to the original channel, and then emails a monthly 4–6 sentence executive summary generated by Anthropic Claude via Gmail.

What this workflow does

• Lead capture via webhook: Receives a POST request on a lead-capture webhook containing lead details and UTM parameters.
• UTM normalization & logging: Normalizes lead fields, maps UTM source/medium values to a standardized marketing channel, and appends the lead to the Leads tab in Google Sheets.
• Deal-won attribution via webhook: Receives a POST request on a deal-won webhook containing the customer email and deal value.
• Revenue-to-channel matching: Looks up the matching lead by email in the Leads tab, attributes the won-deal revenue to the original channel (or marks it as Unknown / untracked), and appends the result to the Revenue tab.
• Monthly executive reporting: Runs on the 1st of every month at 08:00, aggregates last month’s revenue and deal count by channel from the Revenue tab, generates a 4–6 sentence executive summary with Anthropic Claude, and emails the summary and figures using Gmail.

Use cases

• SaaS operators who need UTM attribution that includes won revenue, not just lead volume.
• Automation engineers standardizing UTM source/medium into consistent marketing channels.
• Teams preparing monthly pipeline/channel performance reports without manual spreadsheets.

Technical details

• n8n nodes used: webhook, set, code, google sheets, gmail, and supporting nodes like sticky note.
• Google Sheets tabs required: Leads and Revenue.
• Credentials: Google Sheets access to the target spreadsheet, Anthropic API credential for the Claude model, and Gmail credential with a configured recipient email.