Sync Meta Ads insights to Google Sheets with backfill and weekly ETL
Manual Trigger (Historical Backfill)
Append to Log Sheet (Account B)
googleSheets
Split API Response (Account A)
Append to Sheet (Account A)
googleSheets
Fetch Meta Insights (Account A)
graph.facebook.com
Loop Over Periods (Account A)
noOp
Valid Response? (Account A)
Log Skipped Period (Account A)
Append to Log Sheet (Account A)
googleSheets
Loop Over Periods (Account B)
noOp
Fetch Meta Insights (Account B)
graph.facebook.com
Valid Response? (Account B)
Split API Response (Account B)
Append to Sheet (Account B)
googleSheets
If Spend not 0 (Account A)
If Spend not 0 (Account B)
Set Incremental Range (Last 7 Days)
Schedule Trigger (Incremental)
Generate Weekly Periods
Set Date Range (Historical Backfill)
Log Skipped Period (Account B)
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.