7d ā¢ General discussion
šAutomated Weekly Lead Attribution Report with AI
This automation builds a production-grade Weekly Lead Attribution Reporting System using n8n, Google Sheets, Azure OpenAI, and Gmail.
It runs on a schedule and automatically pulls lead data from Google Sheets.
The workflow cleans and normalizes inconsistent source and spend fields.
Leads are aggregated by channel with total counts calculated.
Ad spend is processed to compute accurate Cost Per Lead (CPL) per source.
A structured JSON summary is prepared for reporting.
GPT-4o-mini converts the data into a professional, responsive HTML report.
The report includes key metrics, CPL breakdown, insights, and priority actions.
The final output is mobile-friendly and email-ready.
The report is automatically sent via Gmail with zero manual effort.
1
0 comments
šAutomated Weekly Lead Attribution Report with AI
powered by
skool.com/the-sparrow-nest-1884
Rahul Joshiās AI Automation Club: n8n, AI agents, and workflow orchestration. Topā2 n8n creator. Deploy automations that save hours and cut costs.
Suggested communities
Powered by