Track marketing revenue attribution with Google Sheets, Anthropic Claude, and Gmail
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 AI workflow has 16 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets, Basic LLM Chain, Anthropic Chat Model and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Transform Lead Data (Code): runs custom JavaScript code
- Search Lead Source in Sheets (Google Sheets): uses Google Sheets
- Specify Report Recipient (Edit Fields (Set)): sets 1 field: reportRecipient
- Append Lead to Sheets (Google Sheets): append
- Calculate Channel Revenue (Code): runs custom JavaScript code
- Read Revenue from Sheets (Google Sheets): uses Google Sheets
- Confirm Lead Logged (Respond to Webhook): sends the response back to the webhook caller
- Append Revenue to Sheets (Google Sheets): append
- Summarize Revenue by Channel (Code): runs custom JavaScript code
- Confirm Revenue Logged (Respond to Webhook): sends the response back to the webhook caller
…plus 2 more steps. See the full node list below.
Services it uses
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 (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow captures leads via webhooks, logs UTM-based channel attribution to Google Sheets, attributes won-deal revenue back to the original channel, and sends a monthly executive summary written by Anthropic Claude via Gmail. How it works…