📊 UTM marketing attribution reports with Google Sheets, GPT-4o & Gmail
⚡ 186 views · 📊 Market Research & Insights
Description
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 reports—delivered straight to your inbox in a professional HTML format.
What This Template Does
📅 Runs hourly to process new lead submissions 📊 Aggregates leads by source (Instagram, LinkedIn, Google Ads, etc.) 💰 Calculates key metrics like Cost Per Lead (CPL) 🧠 Uses AI to generate executive-ready HTML reports 📈 Highlights top-performing sources and growth opportunities 📧 Sends polished reports via Gmail automatically
Prerequisites
- Google Sheets with lead submission data
- Google Forms (or similar) as the data input source
- n8n instance (self-hosted or cloud)
- Azure OpenAI (GPT-4o-mini) API key for AI-powered reporting
- Gmail API credentials for automated report delivery
Step-by-Step Setup
- Trigger workflow hourly with n8n Scheduler.
- Fetch new lead submissions from Google Sheets.
- Aggregate and group data by Source/UTM parameters.
- Calculate CPL using spend + lead count per channel.
- Standardize column names for consistent reporting.
- Send raw + aggregated data to Azure OpenAI for report generation.
- Format into a professional HTML report (with insights & recommendations).
- Send report via Gmail node to stakeholders.
Customization Ideas
- Replace Gmail with Slack/Teams notifications for real-time sharing.
- Add visual charts (Google Data Studio / Looker) for more analytics.
- Use additional UTM fields (campaign, adgroup, creative) for deeper granularity.
- Extend reporting to include ROI and ROAS calculations.
Key Benefits
✅ Hands-free attribution tracking and analysis ✅ Accurate CPL metrics per channel ✅ AI-generated reports with actionable insights ✅ Saves time vs. manual data crunching ✅ Weekly reports ensure marketing strategy stays optimized
Perfect For
- Marketing teams managing multi-channel campaigns
- Agencies providing client attribution reports
- Business owners optimizing ad spend efficiency
- Growth teams tracking lead quality by source
🔗 Nodes Used
Google Sheets, Gmail, Schedule Trigger, Basic LLM Chain, Azure OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File