UTM marketing attribution reports with Google Sheets, GPT-4o & 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 7 nodes and runs on a schedule (every hour). Along the way it connects Gmail, Google Sheets and Azure OpenAI Chat Model.
How it runs
Trigger: On a schedule (every hour).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Basic LLM Chain: sends a prompt to an LLM, with model: Azure OpenAI Chat Model
- Send Follow-up Email (Gmail): uses Gmail
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 (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Code
n8n-nodes-base.code
From the author
Description Turn raw marketing data into actionable insights with this n8n Source/UTM Attribution and Reporting workflow! It automatically aggregates lead submissions, calculates Cost Per Lead (CPL) per channel, and generates AI-powered weekly attribution…