Weekly Meta Ads Performance Report PDF (Gemini + Gmail) via n8n

Automatically generate your weekly Meta Ads performance PDF—with Gemini analysis and Gmail delivery (n8n)

This n8n workflow pulls your Meta Ads campaign and ad-level insights every week, summarizes performance with charts, asks Google Gemini for written insights, converts the report to a PDF, and emails it via Gmail—so you always know what’s working without manual reporting.

What this workflow does

• Runs weekly: Scheduled to trigger every Monday at 8:00 AM using a schedule trigger.
• Builds the reporting window: Automatically sets the date range (last 7/14/30 days, depending on your schedule setting) and loads your Meta Ads account ID, access token, company name, and recipient email.
• Fetches Meta Graph API insights: Calls the Meta Graph API to retrieve campaign-level daily insights for the selected period.
• Aggregates performance metrics: Computes and prepares totals for reporting, including spend, impressions, clicks, CTR, CPC, CPM, results, revenue/ROAS.
• Enriches with top ads by spend: Pulls the highest-spend ads and fetches creative details (thumbnail, body, title) to strengthen the ad-level section.
• Creates charts: Generates chart image URLs using QuickChart and builds a branded HTML report.
• Generates narrative insights: Sends a structured performance summary to Google Gemini for analysis and next-step recommendations.
• Delivers as a PDF: Converts the HTML report to PDF using PDFShift and emails it through Gmail.

Use cases

• SaaS operators who need a weekly Meta Ads performance report for stakeholders
• Automation engineers setting up a repeatable Meta ads analytics pipeline in n8n
• Marketing teams monitoring KPIs like CTR, CPC, CPM, ROAS, and identifying top-spend creatives

Technical details

• n8n nodes / integrations: set, code, gmail, merge, sticky note, http request
• APIs/services: Meta Graph API, Google Gemini (PaLM), QuickChart, PDFShift
• Setup requirements: Use a Meta access token with ads_read permissions and provide your Meta Ads Account ID (without the act_ prefix), plus Gemini API credentials.