Weekly Facebook ads performance reports with AI-powered analysis & Gmail delivery
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.
Nodes used (9)
- Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent
What it does
Who’s it for Perfect for marketing agencies that manage multiple Facebook ad accounts and want to automate their weekly reporting. It eliminates manual data collection, analysis, and client updates by delivering a ready-to-share PDF report. How it works Every Monday, the workflow: 1. Fetches the previous week’s campaign metrics from the Facebook Graph API. 2. Formats and summarizes each campaign’s performance using OpenAI. 3. Merges all summaries into one comprehensive report with insights and next-week suggestions. 4. Converts the report into a polished PDF using any PDF generation API. 5. Sends the final PDF report automatically to the client via Gmail. How to set up 1. Connect your Facebook, OpenAI, and Gmail accounts in n8n. 2. Add credentials for your preferred PDF generator (e.g., PDFCrowd, Placid, etc.). 3. Open the “Set Node” to customize recipient email, date range, or report text. Requirements - Facebook Graph API access token - OpenAI API key - Gmail credentials - API key for your PDF generation service How to customize You can modify the trigger day, personalize the report design, or include additional analytics such as ROAS, CPC, or conversion data for deeper insights.