{"product_id":"utm-revenue-attribution-workflow-n8n-google-sheets-gmail","title":"UTM Revenue Attribution Workflow: n8n + Google Sheets + Gmail","description":"\u003ch3\u003eUTM revenue attribution that turns clicks into real money (and sends an executive summary)\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eLead capture via webhook:\u003c\/b\u003e Receives a \u003ccode\u003ePOST\u003c\/code\u003e request on a lead-capture webhook containing lead details and UTM parameters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUTM normalization \u0026amp; logging:\u003c\/b\u003e Normalizes lead fields, maps UTM source\/medium values to a standardized marketing channel, and appends the lead to the \u003cb\u003eLeads\u003c\/b\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDeal-won attribution via webhook:\u003c\/b\u003e Receives a \u003ccode\u003ePOST\u003c\/code\u003e request on a deal-won webhook containing the customer email and deal value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRevenue-to-channel matching:\u003c\/b\u003e Looks up the matching lead by email in the \u003cb\u003eLeads\u003c\/b\u003e tab, attributes the won-deal revenue to the original channel (or marks it as \u003cb\u003eUnknown \/ untracked\u003c\/b\u003e), and appends the result to the \u003cb\u003eRevenue\u003c\/b\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMonthly executive reporting:\u003c\/b\u003e Runs on the \u003cb\u003e1st of every month at 08:00\u003c\/b\u003e, aggregates last month’s revenue and deal count by channel from the \u003cb\u003eRevenue\u003c\/b\u003e tab, generates a \u003cb\u003e4–6 sentence\u003c\/b\u003e executive summary with \u003cb\u003eAnthropic Claude\u003c\/b\u003e, and emails the summary and figures using \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need UTM attribution that includes \u003cb\u003ewon revenue\u003c\/b\u003e, not just lead volume.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing UTM source\/medium into consistent marketing channels.\u003c\/li\u003e\n  \u003cli\u003eTeams preparing monthly pipeline\/channel performance reports without manual spreadsheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes used:\u003c\/b\u003e \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, and supporting nodes like \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets tabs required:\u003c\/b\u003e \u003cb\u003eLeads\u003c\/b\u003e and \u003cb\u003eRevenue\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCredentials:\u003c\/b\u003e Google Sheets access to the target spreadsheet, Anthropic API credential for the Claude model, and Gmail credential with a configured recipient email.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764323541171,"sku":"N8N-17854","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RClj6tIlNO07ZMb8F9FFW_5yWgYeU6.png?v=1786007329","url":"https:\/\/buyflowscripts.com\/products\/utm-revenue-attribution-workflow-n8n-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}