Weekly Facebook Ads Performance Reports with AI-Powered Analysis & Gmail Delivery
Go to Workflow
Muhammad Ali
Description
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:
Fetches the previous week’s campaign metrics from the Facebook Graph API.
Formats and summarizes each campaign’s performance using OpenAI.
Merges all summaries into one comprehensive report with insights and next-week suggestions.
Converts the report into a polished PDF using any PDF generation API.
Sends the final PDF report automatically to the client via Gmail.
How to set up
Connect your Facebook, OpenAI, and Gmail accounts in n8n.
Add credentials for your preferred PDF generator (e.g., PDFCrowd, Placid, etc.).
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.