Meta ads to Google Sheets: daily & historical campaign performance report
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 10 nodes and runs on a schedule (every day at 06:00) (plus 1 other trigger). Along the way it connects Facebook Graph API and Google Sheets.
How it runs
Trigger: On a schedule (every day at 06:00) (plus 1 other trigger).
- Set config (Meta + Sheets) (Edit Fields (Set)): sets 6 fields: adAccountId, datePreset, level…
- Set backfill config (Edit Fields (Set)): sets 7 fields: adAccountId, level, timeIncrement…
- Fetch Meta Insights (yesterday) (Facebook Graph API): uses Facebook Graph API
- Fetch Meta Insights (time_range) (Facebook Graph API): uses Facebook Graph API
- Transform Meta data for Sheets (Code): runs custom JavaScript code
- Transform backfill data for Sheets (Code): runs custom JavaScript code
- Append daily rows to Google Sheet (Google Sheets): append
- Append backfill rows to Google Sheet (Google Sheets): append
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 (6)
- Edit Fields (Set)
n8n-nodes-base.set - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Overview This template automatically exports Meta (Facebook) Ads campaign performance into Google Sheets — both daily and for historical backfills. It’s ideal for performance marketers, agencies, and analytics teams who want a reliable data pipeline from Meta…