Solomon This workflow corresponds to n8n.io template #2714 — we link there as the canonical source.
This workflow follows the Facebookgraphapi → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "82313e22-7fea-4d64-95d6-577d1ac46775",
"name": "data column only",
"type": "n8n-nodes-base.splitOut",
"position": [
1320,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4ad67c87-ff93-460c-b2b4-5053f1393ed9",
"name": "split actions",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "79c0f6f5-6f44-4b1c-b8aa-ab4a5e963baf",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
860,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "23bedaf7-e02f-4947-9446-addf864302fd",
"name": "Everyday at 3am",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
860,
60
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b221a2b7-ac20-4c0d-a655-27849fa2649a",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "43f806e2-92d5-4a02-8491-2ddeca3601c7",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b6e86b79-ddde-4095-a602-08f5ceadcfa8",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2600,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "55a38170-38ef-4c03-9284-d31c2d057e70",
"name": "Ad insights from any date period",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
1080,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "28e25544-838f-43a8-9fb9-8d9c7ba57bf1",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "88fdc9b5-c918-4756-9d66-f4694b87cffd",
"name": "Ad insights from yesterday",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
1080,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3287f957-9464-4cbc-93b9-5b6f07655b9c",
"name": "split action values",
"type": "n8n-nodes-base.splitOut",
"position": [
2100,
500
],
"parameters": {},
"typeVersion": 1
},
{
"id": "422671e1-e054-45ed-b5f6-246085320f6c",
"name": "filter by action type",
"type": "n8n-nodes-base.filter",
"position": [
2600,
240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "18202591-8208-4f4d-b861-640c4ccb1d8f",
"name": "Only monetary actions",
"type": "n8n-nodes-base.filter",
"position": [
2340,
500
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "ac91d6d2-6d61-4687-8a8a-551cadc36516",
"name": "filter by monetary action type",
"type": "n8n-nodes-base.filter",
"position": [
2600,
500
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "54b9a7bd-0642-4c0f-9159-09ebf1baa8ce",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2600,
660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45ad5870-8381-46e3-a713-2ae31313c597",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3140,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6d8ad63c-a53e-4831-9ab4-dda7aaa71d5b",
"name": "Add General Metrics",
"type": "n8n-nodes-base.googleSheets",
"position": [
1600,
20
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "3b530b1d-11d8-43b3-a60c-92bfb0a77297",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d22e5ce5-533d-4745-959c-38df65b17148",
"name": "Add Non-Monetary actions",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
240
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "c7c25228-7a03-4ec8-b827-7a64da151be8",
"name": "Add Monetary actions",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
500
],
"parameters": {},
"typeVersion": 4.4
}
],
"connections": {
"split actions": {
"main": [
[
{
"node": "split action values",
"type": "main",
"index": 0
},
{
"node": "filter by action type",
"type": "main",
"index": 0
}
]
]
},
"Everyday at 3am": {
"main": [
[
{
"node": "Ad insights from yesterday",
"type": "main",
"index": 0
}
]
]
},
"data column only": {
"main": [
[
{
"node": "split actions",
"type": "main",
"index": 0
},
{
"node": "Add General Metrics",
"type": "main",
"index": 0
}
]
]
},
"split action values": {
"main": [
[
{
"node": "Only monetary actions",
"type": "main",
"index": 0
}
]
]
},
"Only monetary actions": {
"main": [
[
{
"node": "filter by monetary action type",
"type": "main",
"index": 0
}
]
]
},
"filter by action type": {
"main": [
[
{
"node": "Add Non-Monetary actions",
"type": "main",
"index": 0
}
]
]
},
"Add Non-Monetary actions": {
"main": [
[]
]
},
"Ad insights from yesterday": {
"main": [
[
{
"node": "data column only",
"type": "main",
"index": 0
}
]
]
},
"filter by monetary action type": {
"main": [
[
{
"node": "Add Monetary actions",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Ad insights from yesterday",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Pull data using the Facebook Graph API and get your Meta Ads insights into your Google Sheets for analysis.
Source: https://n8n.io/workflows/2714/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This n8n workflow automates the process of uploading video and image advertisements to Meta Ads Manager via the Meta Graph API (Facebook Ads) directly from Google Sheets and Google Drive. The workflow
Marketing teams, agencies, and businesses who regularly create tens or hundreds of Facebook ads and store their creative assets in Google Drive.
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 column; a Switch nod
d27-FB-post. Uses googleSheets, googleDrive, googleSheetsTrigger, facebookGraphApi. Event-driven trigger; 8 nodes.
This template is designed for Marketing Managers, Performance Marketers, and Ad Ops professionals who want to automate Facebook ad creation using structured data in Google Sheets. It’s ideal for teams