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 →
{
"createdAt": "2025-09-23T03:59:25.271Z",
"updatedAt": "2025-09-23T04:00:09.473Z",
"id": "2MLXcTVYHM26rEv1",
"name": "d27-FB-post",
"active": false,
"isArchived": false,
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-176,
-48
],
"id": "b3f156a7-b626-4f45-99f9-b8aa6e53f199",
"name": "When clicking \u2018Execute workflow\u2019"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM",
"mode": "list",
"cachedResultName": "\u6587\u6848\u4e3b\u984c\u898f\u5283\u8868",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "\u5de5\u4f5c\u88681",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM/edit#gid=0"
},
"filtersUI": {
"values": [
{
"lookupColumn": "\u78ba\u8a8d\u4f7f\u7528\u5716\u6587",
"lookupValue": "o"
},
{
"lookupColumn": "FB \u9023\u7d50"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
48,
48
],
"id": "efdf1c20-61dd-4bce-9e95-9a6cd103d659",
"name": "Get row(s) in sheet"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
272,
48
],
"id": "64b37f0c-88b6-4f52-a7e5-3613e927b446",
"name": "Loop Over Items"
},
{
"parameters": {
"operation": "download",
"fileId": {
"__rl": true,
"value": "={{ $json['\u751f\u6210\u5716\u7247\u9023\u7d50'] }}",
"mode": "url"
},
"options": {}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
496,
-32
],
"id": "0709b7f9-a73d-450f-9f8f-1e8ae5c90d22",
"name": "Download file"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM",
"mode": "list",
"cachedResultName": "\u6587\u6848\u4e3b\u984c\u898f\u5283\u8868",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "\u5de5\u4f5c\u88681",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"ID": "={{ $('Get row(s) in sheet').item.json.ID }}",
"FB \u9023\u7d50": "=https://www.facebook.com/{{ $json.id }}"
},
"matchingColumns": [
"ID"
],
"schema": [
{
"id": "ID",
"displayName": "ID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "\u4e3b\u984c",
"displayName": "\u4e3b\u984c",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u95dc\u9375\u5b57",
"displayName": "\u95dc\u9375\u5b57",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u6587\u6848\u98a8\u683c",
"displayName": "\u6587\u6848\u98a8\u683c",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u76ee\u6a19\u53d7\u773e",
"displayName": "\u76ee\u6a19\u53d7\u773e",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u5b57\u6578\u9650\u5236",
"displayName": "\u5b57\u6578\u9650\u5236",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u8f38\u51fa\u5e73\u53f0",
"displayName": "\u8f38\u51fa\u5e73\u53f0",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u5099\u8a3b",
"displayName": "\u5099\u8a3b",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u751f\u6210\u8349\u7a3f",
"displayName": "\u751f\u6210\u8349\u7a3f",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u5716\u7247\u98a8\u683c\u5efa\u8b70",
"displayName": "\u5716\u7247\u98a8\u683c\u5efa\u8b70",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u78ba\u8a8d\u4f7f\u7528\u6587\u5b57\u5716\u7247\u5efa\u8b70",
"displayName": "\u78ba\u8a8d\u4f7f\u7528\u6587\u5b57\u5716\u7247\u5efa\u8b70",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u751f\u6210\u5716\u7247\u9023\u7d50",
"displayName": "\u751f\u6210\u5716\u7247\u9023\u7d50",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u78ba\u8a8d\u4f7f\u7528\u5716\u6587",
"displayName": "\u78ba\u8a8d\u4f7f\u7528\u5716\u6587",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "FB \u9023\u7d50",
"displayName": "FB \u9023\u7d50",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
944,
48
],
"id": "65aa9cb0-5bcc-49d3-83fb-b6f0393181e3",
"name": "Update row in sheet"
},
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"documentId": {
"__rl": true,
"value": "1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM",
"mode": "list",
"cachedResultName": "\u6587\u6848\u4e3b\u984c\u898f\u5283\u8868",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "\u5de5\u4f5c\u88681",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L2aG1su8TDETxXvqAUpgKC_n0WWpaeyRETAwJP0eOUM/edit#gid=0"
},
"event": "rowUpdate",
"options": {}
},
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
-176,
144
],
"id": "66b30713-bdfa-446d-b79f-f425fa0badfc",
"name": "Google Sheets Trigger"
},
{
"parameters": {
"httpRequestMethod": "POST",
"graphApiVersion": "v23.0",
"node": "me",
"edge": "photos",
"sendBinaryData": true,
"binaryPropertyName": "data",
"options": {
"queryParameters": {
"parameter": [
{
"name": "caption",
"value": "={{ $json['\u751f\u6210\u8349\u7a3f'] }}"
}
]
}
}
},
"type": "n8n-nodes-base.facebookGraphApi",
"typeVersion": 1,
"position": [
720,
-32
],
"id": "9cfb2add-cc74-405f-965a-2bb9679b1d54",
"name": "Facebook Graph API2"
},
{
"parameters": {
"select": "channel",
"channelId": {
"__rl": true,
"value": "C031VA2BYLF",
"mode": "list",
"cachedResultName": "githubchannel"
},
"text": "=\u4e00\u7bc7\u8cbc\u6587\u5df2\u751f\u6210\n\nhttps://www.facebook.com/{{ $('Facebook Graph API2').item.json.id }}",
"otherOptions": {}
},
"type": "n8n-nodes-base.slack",
"typeVersion": 2.3,
"position": [
1152,
48
],
"id": "d8286ba7-cd7e-49fa-9bc5-69212eaf426f",
"name": "Send a message"
}
],
"connections": {
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"Download file": {
"main": [
[
{
"node": "Facebook Graph API2",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Facebook Graph API2": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Send a message": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"meta": null,
"versionId": "c1090b13-4f60-43ca-91b0-5adeeb42374e",
"triggerCount": 0,
"shared": [
{
"createdAt": "2025-09-23T03:59:25.271Z",
"updatedAt": "2025-09-23T03:59:25.271Z",
"role": "workflow:owner",
"workflowId": "2MLXcTVYHM26rEv1",
"projectId": "6NV7foKyOeJG8Mz6"
}
],
"tags": [
{
"createdAt": "2025-09-14T06:27:04.834Z",
"updatedAt": "2025-09-14T06:27:04.834Z",
"id": "S14KyMmdLj6QsyYh",
"name": "ithome"
}
]
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
d27-FB-post. Uses googleSheets, googleDrive, googleSheetsTrigger, facebookGraphApi. Event-driven trigger; 8 nodes.
Source: https://github.com/021up/n8n-learning/blob/main/ITHome/2MLXcTVYHM26rEv1.json — 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.
Marketing teams, agencies, and businesses who regularly create tens or hundreds of Facebook ads and store their creative assets in Google Drive.
Facebook Graph Api, Error Trigger, Stop And Error +4
This n8n workflow template automates the entire process of publishing Instagram Reels from content stored in Google Sheets and Google Drive. It's designed for content creators, social media managers,
Agent, Airtable, Facebook Graph Api +8
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
Facebook Graph Api, Google Sheets, HTTP Request +2
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
Google Sheets, Facebook Graph Api, Google Sheets Trigger
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
HTTP Request, Facebook Graph Api, Google Sheets Trigger +1