Sync Meta Ads insights to Google Sheets with backfill and weekly ETL

Meta Ads Insights to Google Sheets (Backfill & Weekly Sync ETL)

This workflow provides a structured way to extract Meta Ads performance data and store it in Google Sheets for reporting, dashboarding, or further analysis.

It is designed as a lightweight, reliable ETL pipeline focused on stability, clarity, and ease of use, rather than building a full data warehouse solution.

What This Workflow Does

At a high level, the system:

- Pulls Meta Ads Insights data via API - Supports both historical backfill and automated incremental sync - Splits large date ranges into manageable weekly chunks - Handles pagination and retries automatically - Filters out zero-spend records before storage - Stores clean, structured data in Google Sheets - Logs skipped or empty responses for traceability

Architecture Overview Core Components - n8n - Meta Ads API - Google Sheets

Primary Data Outputs - AccountA → Campaign-level data (weekly) - AccountB → Ad-level data (daily breakdown) - AccountALog / AccountBLog → Logging for skipped or empty responses