18 nodes

Sub-Auto Fetch FB Ads Data From All Ad Accounts in Business Manager

Workflow Preview

Wait

When Executed by Another Workflow

Sub Config Params

Fetch Ads List (Spend >0)

Check FB API Limit/Error

Notify Discord API Limit

Split Ads Items

Loop Per Ad

Fetch Ads Core Info

Fetch Ads Insights

Merge Ad Core & Insights

Process & Clean Metrics

Filter Ads With Spend

Check Insights Exists

Generate Insert SQL

Insert to BigQuery

Send Success Discord Notify

Notify No Spend Data

Description

Description Purpose: Deep-dive processor for one FB ad account – extracts ads list (spend>0), core info (name/adset/campaign), insights (reach/impressions/spend/CPC/messaging actions). Optimized for India low-CPC campaigns; safe for high-volume. Core Logic: Input: Account ID/token/limits → Fetch /ads?filter=spend>0 + /insights + ad details. Process: Clean metrics (messaging conv started/blocks/replies), merge data, SQL gen. Insert: BigQuery upsert (20+ cols: adid, spend INR, reach,...). Handles: API limits (wait 60min), no-data notify Discord. Output: BigQuery table + Discord alerts. Call from main for multi-account magic.

Loading demo...

What's Included

Downloadable JSON file

Sanitized credentials

Ready to import into n8n

Lifetime access

Reviews (0)

0.0

0 reviews

5 star

4 star

3 star

2 star

1 star

₹3500.00

One-time purchase

Seller

duongquangminh1321

Workflow Creator

Details

CreatedMarch 4, 2026

Nodes18

Version1.0.0