Send weekly Meta Ads performance PDF reports with Gemini and Gmail
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.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Gemini and Gmail. It also calls api.pdfshift.io over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00).
- Config: Credentials & IDs (Edit Fields (Set)): sets 5 fields: Meta_Ads_Account_ID, Meta_Access_Token, Report_Email…
- Calculate Dates and Wrap Data (Code): runs custom JavaScript code
- Get Ad Account Info (HTTP Request): calls an HTTP API
- Get Campaign Performance (HTTP Request): calls an HTTP API
- Get Top Ads Performance (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Organize Campaign Data (Code): runs custom JavaScript code
- Format & Fetch Ad Creatives (Code): runs custom JavaScript code
- Merge All Data & Build Charts (Code): runs custom JavaScript code
- Organize Ad Creative Data (Code): runs custom JavaScript code
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: api.pdfshift.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs weekly to pull Meta Ads campaign and ad-level insights from the Meta Graph API, summarizes performance, generates charts with QuickChart, asks Google Gemini for written analysis, converts the resulting HTML report to a PDF…