Facebook ads reporting automation with Facebook Graph API and Google Sheets
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 workflow has 15 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets and Facebook Graph API.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Add credentials to the Facebook Graph API (Facebook Graph API): uses Facebook Graph API
- Get Campaign ID (Google Sheets): uses Google Sheets
- Get Campaign from AD Account (HTTP Request): calls an HTTP API
- Get Campaign statistics (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Checking if Campaign have data (If): checks a condition and branches into true / false
- Aggregate: combines items into one
- Get Only Active Campaign (If): checks a condition and branches into true / false
- Update row in sheet (Google Sheets): uses Google Sheets
…plus 3 more steps. See the full node list below.
Services it uses
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 (8)
- Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Facebook Ads Reporting Automation — Automatically Fetch & Sync Campaign Statistics This automation enables you to automatically fetch daily campaign data from Facebook Ads without manual exports. It requires connection to the Facebook Graph API and a Google…