Extract Meta Ads detailed targeting across all endpoints using Google Sheets
Ready for 3.0What this workflow does
This workflow has 25 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Facebook Graph API.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Read Input (Google Sheets) (Google Sheets): uses Google Sheets
- Valid rows (ad_account_id + endpoint) (Filter): keeps only the items that match a condition
- Switch: routes items into 4 branches
- API Search (Facebook Graph API): uses Facebook Graph API
- Merge: merges the data from its input branches
- API Suggestions (Facebook Graph API): uses Facebook Graph API
- Merge: merges the data from its input branches
- API Browse (Facebook Graph API): uses Facebook Graph API
- Merge: merges the data from its input branches
- API Validation (Facebook Graph API): uses Facebook Graph API
…plus 13 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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Switch
n8n-nodes-base.switch - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger
From the author
Meta Ads Detailed Targeting Extractor (Universal, Switch by Endpoint) This workflow is a universal automation for all four Meta Detailed Targeting API endpoints: Search, Suggestions, Browse, and Validation. You use a single Google Sheets tab with an endpoint…