Sam Yassine This workflow corresponds to n8n.io template #4277 — we link there as the canonical source.
This workflow follows the Google Drive → 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 →
{
"id": "vJUoHTm2PsqJRRY0",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "My Sub-Workflow 3",
"tags": [],
"nodes": [
{
"id": "b36cdb0a-9804-4559-9d81-3b03a6f098de",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
180,
720
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c8ce845c-959b-445e-b974-51743a413c43",
"name": "Set Main Fields",
"type": "n8n-nodes-base.set",
"position": [
1020,
720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "aa4a4bf0-6017-4b89-8069-556aec11cbcc",
"name": "Set Related KW Fields",
"type": "n8n-nodes-base.set",
"position": [
2700,
-100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4a01d529-af72-4839-8cbc-6101a6f65963",
"name": "Split Out Related KWs",
"type": "n8n-nodes-base.splitOut",
"position": [
2500,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "95436779-dd32-4cfd-9f87-526ef0f818c9",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "81e1ecec-a5e7-43c7-b8e4-cd2063f53055",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aae6d7dc-8673-40cc-8a08-c72703d78afd",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c3099493-34c5-47b8-bbad-c8a15010d534",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4c3a17df-3fd6-46f0-9b62-cf7cd009ace0",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
4340,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8d7a1074-df18-4127-9338-4667c38bea52",
"name": "Google Sheets KW Research Template",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
720
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "700a1485-7061-4a13-a9b5-58a19585658d",
"name": "Google Drive Create KW Folder",
"type": "n8n-nodes-base.googleDrive",
"position": [
660,
720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9a7a078a-dfa3-49b5-9326-1b4eac9aa393",
"name": "Google Drive Copy KW Template",
"type": "n8n-nodes-base.googleDrive",
"position": [
860,
720
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f2232b9d-49d9-4b07-b780-03dbf2817339",
"name": "HTTP Keyword Suggestions",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
260
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8e21b4d7-b815-4c1b-b3ea-f35c9b2a4b37",
"name": "HTTP Related Keywords",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
-100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "6439a767-ab07-4c28-a3ae-21ba493f8657",
"name": "Add Related KWs to Related KWs Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "2f40158b-b769-4a7b-bc7c-f48984fbcc5a",
"name": "Add Related KWs to Master all KW Variations Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "268bf914-05b2-4d56-b32f-5f1940b2c0ae",
"name": "Add KWs to Keyword Suggestions Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
260
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "c9565457-b25a-4d68-bb2e-20214f766339",
"name": "Add KWs to Master All KW Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
260
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "716fda24-7b62-4021-8ad9-37a61bb4f276",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "99ada347-09c8-4cc0-abd7-fba96dc012fa",
"name": "Add KWs to Master All KW Sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "b9ba52a9-1ae9-4ec3-980f-12ff1b44f56d",
"name": "HTTP Keyword Ideas",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
620
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f77329cf-9135-4e3b-bf4d-9fc8949ba2d5",
"name": "Split Out KW Suggestions",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "dc8584f6-eada-4d8c-a602-bb85f038c88c",
"name": "Set KW Suggestion Fields",
"type": "n8n-nodes-base.set",
"position": [
2720,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a4dfe603-fc06-4d99-8216-1ee23813303f",
"name": "Split Out KW Ideas",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
620
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5fe90a28-c938-4d37-ae14-9517d6c06a44",
"name": "Set KW Ideas Fields",
"type": "n8n-nodes-base.set",
"position": [
2720,
620
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "035ac1ab-943b-4221-8912-627d9134e429",
"name": "Add KWs to Keyword Ideas Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "aa17b8f1-e2d3-4a0e-b4c1-15da54671a44",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "56257dbe-cd4e-4fe7-867e-3951c113d171",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "69c76030-00df-4d3d-b06f-38fbd8afce01",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d557c699-e12e-4d97-b1ac-96c056570985",
"name": "Split Out Autocomplete",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f79435c-cfd2-4d97-8b90-1f0889714ec9",
"name": "Set Autocomplete Fields",
"type": "n8n-nodes-base.set",
"position": [
2720,
960
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7c8720b5-b690-4484-bb7f-8c9e92e2ba35",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8609079e-cc2f-4c63-b75f-85d647012396",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "266f7a8f-425e-4c34-983c-bd6ffbf32988",
"name": "HTTP Autocomplete",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
960
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "26337f73-7aab-46f8-89a6-30d71039f3c8",
"name": "Add Autocomplete to Autocomplete Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
960
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "9fb77120-fc89-4bc0-a828-f672355cd6ed",
"name": "Split Out Subtopics",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
1300
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5854a87d-bc8c-47b4-9880-70b5df0f8f11",
"name": "Set Subtopics Fields",
"type": "n8n-nodes-base.set",
"position": [
2720,
1300
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1a16c4e5-7d18-4b4a-a8dc-cb682ace2269",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
3900,
1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "14c28d83-6802-4458-929a-ac1b6bf0c376",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
1180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4347928c-c2d1-487c-8499-a56f3fce7149",
"name": "HTTP Subtopics",
"type": "n8n-nodes-base.httpRequest",
"position": [
2280,
1300
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a2c66ce2-598b-4f52-b703-bf2a5289f0ba",
"name": "Add Subtopics to Subtopics Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2940,
1300
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "90802d0d-fd83-4fc6-8f92-542f6a51474e",
"name": "Add Subtopics to Master KWs Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
960
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "7edff654-4cee-4726-8cfe-60652a4ba1f6",
"name": "Filter SERPs",
"type": "n8n-nodes-base.filter",
"position": [
2720,
1620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0506b631-dc32-4e79-8149-8250abe23433",
"name": "Filter PAA",
"type": "n8n-nodes-base.filter",
"position": [
2720,
1820
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "115ab146-8992-405c-b413-89fee7813ac7",
"name": "Set SERP Fields",
"type": "n8n-nodes-base.set",
"position": [
2920,
1620
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d2e3dec2-e201-46d1-b77a-d0c06cb93c0b",
"name": "Split Out PAA",
"type": "n8n-nodes-base.splitOut",
"position": [
2920,
1820
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5ee2a485-4b62-4c04-9316-726ffa5b6d4e",
"name": "Set PAA Fields",
"type": "n8n-nodes-base.set",
"position": [
3140,
1820
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "69f9fa86-f0ed-4272-a503-c52818d3e87c",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
1520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ab453289-7ce5-4cdd-bfd7-c3475385084c",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
3860,
1720
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ac9eb623-61d4-419a-9179-a7efb3498799",
"name": "HTTP SERPs",
"type": "n8n-nodes-base.httpRequest",
"position": [
2300,
1820
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7bb43620-1b92-4469-8c40-5fda93621aa1",
"name": "Split Out SERPs and PAA",
"type": "n8n-nodes-base.splitOut",
"position": [
2520,
1820
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c3ca3b7c-7c07-4e03-8d5a-b0df7f92853f",
"name": "Add Subtopics to Master KW sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3940,
1300
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "47b89892-7e8f-420b-bd57-a1fc16db6d51",
"name": "Add SERPs to SERP Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3140,
1620
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "d6bbe89b-b862-4f29-ae8f-6947439470db",
"name": "Add PAA to PAA Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3360,
1820
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "865c02d3-c571-4cf7-b82d-0d6e8d54812b",
"name": "Add PAA to Master KW Variations Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
3900,
1820
],
"parameters": {},
"typeVersion": 4.5
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "41fb75f4-c5ce-4479-97f8-0206bbd382b8",
"connections": {
"Filter PAA": {
"main": [
[
{
"node": "Split Out PAA",
"type": "main",
"index": 0
}
]
]
},
"HTTP SERPs": {
"main": [
[
{
"node": "Split Out SERPs and PAA",
"type": "main",
"index": 0
}
]
]
},
"Filter SERPs": {
"main": [
[
{
"node": "Set SERP Fields",
"type": "main",
"index": 0
}
]
]
},
"Split Out PAA": {
"main": [
[
{
"node": "Set PAA Fields",
"type": "main",
"index": 0
}
]
]
},
"HTTP Subtopics": {
"main": [
[
{
"node": "Split Out Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Set PAA Fields": {
"main": [
[
{
"node": "Add PAA to PAA Sheet",
"type": "main",
"index": 0
}
]
]
},
"Set Main Fields": {
"main": [
[
{
"node": "HTTP Related Keywords",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Suggestions",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Ideas",
"type": "main",
"index": 0
},
{
"node": "HTTP Autocomplete",
"type": "main",
"index": 0
},
{
"node": "HTTP Subtopics",
"type": "main",
"index": 0
},
{
"node": "HTTP SERPs",
"type": "main",
"index": 0
}
]
]
},
"Set SERP Fields": {
"main": [
[
{
"node": "Add SERPs to SERP Sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Autocomplete": {
"main": [
[
{
"node": "Split Out Autocomplete",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Ideas": {
"main": [
[
{
"node": "Split Out KW Ideas",
"type": "main",
"index": 0
}
]
]
},
"Split Out KW Ideas": {
"main": [
[
{
"node": "Set KW Ideas Fields",
"type": "main",
"index": 0
}
]
]
},
"Set KW Ideas Fields": {
"main": [
[
{
"node": "Add KWs to Keyword Ideas Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out Subtopics": {
"main": [
[
{
"node": "Set Subtopics Fields",
"type": "main",
"index": 0
}
]
]
},
"Add PAA to PAA Sheet": {
"main": [
[
{
"node": "Add PAA to Master KW Variations Sheet",
"type": "main",
"index": 0
}
]
]
},
"Set Subtopics Fields": {
"main": [
[
{
"node": "Add Subtopics to Subtopics Sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Related Keywords": {
"main": [
[
{
"node": "Split Out Related KWs",
"type": "main",
"index": 0
}
]
]
},
"Set Related KW Fields": {
"main": [
[
{
"node": "Add Related KWs to Related KWs Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out Related KWs": {
"main": [
[
{
"node": "Set Related KW Fields",
"type": "main",
"index": 0
}
]
]
},
"Split Out Autocomplete": {
"main": [
[
{
"node": "Set Autocomplete Fields",
"type": "main",
"index": 0
}
]
]
},
"Set Autocomplete Fields": {
"main": [
[
{
"node": "Add Autocomplete to Autocomplete Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out SERPs and PAA": {
"main": [
[
{
"node": "Filter SERPs",
"type": "main",
"index": 0
},
{
"node": "Filter PAA",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Suggestions": {
"main": [
[
{
"node": "Split Out KW Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Set KW Suggestion Fields": {
"main": [
[
{
"node": "Add KWs to Keyword Suggestions Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out KW Suggestions": {
"main": [
[
{
"node": "Set KW Suggestion Fields",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Copy KW Template": {
"main": [
[
{
"node": "Set Main Fields",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Create KW Folder": {
"main": [
[
{
"node": "Google Drive Copy KW Template",
"type": "main",
"index": 0
}
]
]
},
"Add KWs to Keyword Ideas Sheet": {
"main": [
[
{
"node": "Add KWs to Master All KW Sheet1",
"type": "main",
"index": 0
}
]
]
},
"Add Subtopics to Subtopics Sheet": {
"main": [
[
{
"node": "Add Subtopics to Master KW sheet",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Google Sheets KW Research Template",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets KW Research Template": {
"main": [
[
{
"node": "Google Drive Create KW Folder",
"type": "main",
"index": 0
}
]
]
},
"Add KWs to Keyword Suggestions Sheet": {
"main": [
[
{
"node": "Add KWs to Master All KW Sheet",
"type": "main",
"index": 0
}
]
]
},
"Add Related KWs to Related KWs Sheet": {
"main": [
[
{
"node": "Add Related KWs to Master all KW Variations Sheet",
"type": "main",
"index": 0
}
]
]
},
"Add Autocomplete to Autocomplete Sheet": {
"main": [
[
{
"node": "Add Subtopics to Master KWs Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet for the research, queries multiple DataForSEO API endpoints for different…
Source: https://n8n.io/workflows/4277/ — 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.
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)
HTTP Request, Google Drive, Google Sheets
📄 Documentation: Notion Guide
Google Sheets, Google Drive, HTTP Request +2
Overview
Google Sheets, Google Drive, HTTP Request
This workflow automates the full pipeline for extending short Viral UGC-style videos using AI, merging them, and finally publishing the output to cloud storage or social media platforms (TikTok, Insta
HTTP Request, Google Sheets, Google Drive +1