Zakwan This workflow corresponds to n8n.io template #8027 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request 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": "pVWoKnxJXiEf89Jw",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "SEO Keyword Reseach",
"tags": [],
"nodes": [
{
"id": "84bcbf6d-65cd-45ba-904e-235d62bf2d23",
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2000,
520
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3c7d7215-2ff0-44de-b407-ac537add7b81",
"name": "HTTP SearchVolume",
"type": "n8n-nodes-base.httpRequest",
"position": [
-420,
-360
],
"parameters": {},
"typeVersion": 4
},
{
"id": "98773b36-8135-4f8f-bcf3-746fbbae8561",
"name": "HTTP Google SERP",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
560
],
"parameters": {},
"typeVersion": 4
},
{
"id": "36a176ab-b2ed-4292-8fa6-1c17a66da10a",
"name": "HTTP Keyword Suggestions",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
2020
],
"parameters": {},
"typeVersion": 4
},
{
"id": "3c028d1f-c767-4039-8b49-36c146be6ee3",
"name": "HTTP Screenshot",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
260
],
"parameters": {},
"typeVersion": 4
},
{
"id": "c92d3111-f5c9-4ce0-849a-5bd154fbc589",
"name": "HTTP Local Finder",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
1720
],
"parameters": {},
"typeVersion": 4
},
{
"id": "08bfbe4b-85b7-4cf8-9977-e0665ebb7b32",
"name": "HTTP Backlinks",
"type": "n8n-nodes-base.httpRequest",
"position": [
140,
1460
],
"parameters": {},
"typeVersion": 4
},
{
"id": "280bea71-108c-4b57-ae13-77d08d2baba4",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1760,
520
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "da596be3-6d45-446b-8e81-252647b62fff",
"name": "Extract Snippet1",
"type": "n8n-nodes-base.code",
"position": [
-100,
-20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1517df19-4d40-4809-895e-33250ed4f5a7",
"name": "Detect SERP Features1",
"type": "n8n-nodes-base.code",
"position": [
-100,
560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d8ee89e5-cede-4bcf-ae5c-a907a8e96abb",
"name": "Extract Organic",
"type": "n8n-nodes-base.code",
"position": [
-100,
840
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a5a0b982-ab17-4df8-a2ee-10444d29c1b8",
"name": "Extract Top Domain",
"type": "n8n-nodes-base.code",
"position": [
-100,
1460
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fd00e659-67aa-4eb3-99e6-9cc5834a8323",
"name": "Extract Local",
"type": "n8n-nodes-base.code",
"position": [
140,
1720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7eee3574-85d4-42a1-a1fb-5b09bdcb6e0d",
"name": "Extract Suggestions",
"type": "n8n-nodes-base.code",
"position": [
140,
2020
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d18e848b-8b59-430e-a84d-80dcd6cb7f58",
"name": "HTTP Related Keywords",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
-340
],
"parameters": {},
"typeVersion": 4
},
{
"id": "cc00a7a4-4007-4ea9-bf5d-e167618ae6b9",
"name": "HTTP Keyword Ideas",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
-60
],
"parameters": {},
"typeVersion": 4
},
{
"id": "b92b2821-8925-461d-98c0-35a634c1ffe5",
"name": "HTTP Subtopics",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
260
],
"parameters": {},
"typeVersion": 4
},
{
"id": "79a1ec2d-16a6-437c-9cf6-e8151595bc65",
"name": "Extract Related Keywords",
"type": "n8n-nodes-base.code",
"position": [
-1200,
-340
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8aafd19c-6a17-4379-9df9-f1aa6e8ba03a",
"name": "Extract Subtopics",
"type": "n8n-nodes-base.code",
"position": [
-1200,
260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "03fcd370-1d5b-4eda-bf6a-e29ea9418bae",
"name": "Extract Keyword Ideas",
"type": "n8n-nodes-base.code",
"position": [
-1200,
-60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "993936fb-803c-40ff-8f8c-dabfa68a7b45",
"name": "Extract Volume Trend",
"type": "n8n-nodes-base.code",
"position": [
-100,
-360
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5760dd9e-efce-4e2c-8732-1c851d99f507",
"name": "Extract PAA/PAS",
"type": "n8n-nodes-base.code",
"position": [
-100,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "2fc0d43c-c493-4f80-b9a3-9681ee834af5",
"name": "Overview",
"type": "n8n-nodes-base.googleSheets",
"position": [
1380,
700
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "3f1ec549-8c2e-4e34-8cfa-0dc35937c5d1",
"name": "Search Volume Trend",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
-360
],
"parameters": {},
"typeVersion": 4
},
{
"id": "6b776b8a-a12d-4e8a-aa74-3a2ad2a2f86c",
"name": "Featured Snippets",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
-20
],
"parameters": {},
"typeVersion": 4
},
{
"id": "c2e9953d-f96e-4e68-89a1-b01df6b5facb",
"name": "SERP Features",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
560
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "46155321-d041-495f-9742-73129c9d3d80",
"name": "PAA",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
1140
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "f668078a-529d-4d61-9d88-f536e446a016",
"name": "Organic Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
840
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "74a88edf-29eb-4aad-83bf-c942dde1da56",
"name": "Local Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
1720
],
"parameters": {},
"typeVersion": 4
},
{
"id": "de5a423e-57dd-4ccf-86c1-14d07853bfd6",
"name": "Suggestions",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
2020
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "aa9378c9-f9b7-42fc-8f1f-8502770ef75a",
"name": "Keywords Ideas",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
-60
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "314d309e-b3d0-46b6-a03b-06a33edec4d7",
"name": "Subtopics",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
260
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "303b73bb-db1c-4f85-8095-74fff312eca8",
"name": "Backlinks",
"type": "n8n-nodes-base.googleSheets",
"position": [
380,
1460
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5d2c6aa2-82a0-4643-8c14-67e6895635e4",
"name": "Related Keywords",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
-340
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "71f7cfd2-d7b5-4f03-aa8c-533ddf204e54",
"name": "average search volume and CPC",
"type": "n8n-nodes-base.code",
"position": [
340,
-360
],
"parameters": {},
"typeVersion": 2
},
{
"id": "076789d9-b429-45d6-a2e7-d16572ff998e",
"name": "Yes or No",
"type": "n8n-nodes-base.code",
"position": [
340,
-20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "b8ded190-d8ce-4a96-91ba-0146174b6027",
"name": "Wich features exist",
"type": "n8n-nodes-base.code",
"position": [
360,
560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f201fdcc-3d35-425c-894d-4f257a18b42c",
"name": "Average competition",
"type": "n8n-nodes-base.code",
"position": [
540,
2020
],
"parameters": {},
"typeVersion": 2
},
{
"id": "77720ece-04ae-4d2f-bcd1-254dc0d75cac",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
380,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "22d63f16-462a-45a1-be11-ad0e727ce2c5",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
540,
1720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
1020,
580
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "f6018e44-9523-4431-b8c0-49d0f22b1170",
"name": "Restructure data",
"type": "n8n-nodes-base.code",
"position": [
1200,
700
],
"parameters": {},
"typeVersion": 2
},
{
"id": "27efc4e8-ef6f-4244-b5e8-f89ab5d1df18",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b548d12b-16c5-4bde-9c62-096287837150",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ecd8d090-1799-44c2-8c85-1385f64b0fb5",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-440
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "98dba987-562e-442f-aa6f-f1c9294ec612",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "91ddca1e-daec-45f1-b09f-7d226da88a63",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "de71b3cf-7084-4b6c-abb0-022fd7c6ddd8",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4515bcd9-2608-4860-bf01-f915fd7e7f7f",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "678b247c-03af-4e58-99cf-23c59513439a",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1060
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a57fef70-86f6-41ab-8037-0e9646f89ad1",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1360
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "64afb7ed-87c0-450b-a3df-2922a5535861",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b6893598-49e9-412a-8b34-710da958f3b4",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1960
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b9e65c87-cc25-4334-a336-bb96f95ba1cf",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-440
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "eddd6ee1-1ecd-4096-b9ff-389ad7bca959",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f1678692-0659-413a-abbf-4c088d90eef2",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "1c604e43-4648-4d70-b151-c66e63cdaef4",
"connections": {
"PAA": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 4
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 6
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Restructure data",
"type": "main",
"index": 0
}
]
]
},
"Backlinks": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 5
}
]
]
},
"Subtopics": {
"main": [
[]
]
},
"Yes or No": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Suggestions": {
"main": [
[
{
"node": "Average competition",
"type": "main",
"index": 0
}
]
]
},
"Extract Local": {
"main": [
[
{
"node": "Local Results",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "HTTP Google SERP",
"type": "main",
"index": 0
},
{
"node": "HTTP SearchVolume",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Suggestions",
"type": "main",
"index": 0
},
{
"node": "HTTP Related Keywords",
"type": "main",
"index": 0
},
{
"node": "HTTP Keyword Ideas",
"type": "main",
"index": 0
},
{
"node": "HTTP Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Local Results": {
"main": [
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"SERP Features": {
"main": [
[
{
"node": "Wich features exist",
"type": "main",
"index": 0
}
]
]
},
"HTTP Backlinks": {
"main": [
[
{
"node": "Backlinks",
"type": "main",
"index": 0
}
]
]
},
"HTTP Subtopics": {
"main": [
[
{
"node": "Extract Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Extract Organic": {
"main": [
[
{
"node": "Organic Results",
"type": "main",
"index": 0
}
]
]
},
"Extract PAA/PAS": {
"main": [
[
{
"node": "PAA",
"type": "main",
"index": 0
}
]
]
},
"HTTP Screenshot": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Organic Results": {
"main": [
[]
]
},
"Extract Snippet1": {
"main": [
[
{
"node": "Featured Snippets",
"type": "main",
"index": 0
}
]
]
},
"HTTP Google SERP": {
"main": [
[
{
"node": "HTTP Screenshot",
"type": "main",
"index": 0
},
{
"node": "HTTP Local Finder",
"type": "main",
"index": 0
},
{
"node": "Extract Organic",
"type": "main",
"index": 0
},
{
"node": "Extract Snippet1",
"type": "main",
"index": 0
},
{
"node": "Detect SERP Features1",
"type": "main",
"index": 0
},
{
"node": "Extract Top Domain",
"type": "main",
"index": 0
},
{
"node": "Extract PAA/PAS",
"type": "main",
"index": 0
}
]
]
},
"Related Keywords": {
"main": [
[]
]
},
"Restructure data": {
"main": [
[
{
"node": "Overview",
"type": "main",
"index": 0
}
]
]
},
"Extract Subtopics": {
"main": [
[
{
"node": "Subtopics",
"type": "main",
"index": 0
}
]
]
},
"Featured Snippets": {
"main": [
[
{
"node": "Yes or No",
"type": "main",
"index": 0
}
]
]
},
"HTTP Local Finder": {
"main": [
[
{
"node": "Extract Local",
"type": "main",
"index": 0
}
]
]
},
"HTTP SearchVolume": {
"main": [
[
{
"node": "Extract Volume Trend",
"type": "main",
"index": 0
}
]
]
},
"Extract Top Domain": {
"main": [
[
{
"node": "HTTP Backlinks",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Ideas": {
"main": [
[
{
"node": "Extract Keyword Ideas",
"type": "main",
"index": 0
}
]
]
},
"Average competition": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 7
}
]
]
},
"Extract Suggestions": {
"main": [
[
{
"node": "Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Search Volume Trend": {
"main": [
[
{
"node": "average search volume and CPC",
"type": "main",
"index": 0
}
]
]
},
"Wich features exist": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 3
}
]
]
},
"Extract Volume Trend": {
"main": [
[
{
"node": "Search Volume Trend",
"type": "main",
"index": 0
}
]
]
},
"Detect SERP Features1": {
"main": [
[
{
"node": "SERP Features",
"type": "main",
"index": 0
}
]
]
},
"Extract Keyword Ideas": {
"main": [
[
{
"node": "Keywords Ideas",
"type": "main",
"index": 0
}
]
]
},
"HTTP Related Keywords": {
"main": [
[
{
"node": "Extract Related Keywords",
"type": "main",
"index": 0
}
]
]
},
"Extract Related Keywords": {
"main": [
[
{
"node": "Related Keywords",
"type": "main",
"index": 0
}
]
]
},
"HTTP Keyword Suggestions": {
"main": [
[
{
"node": "Extract Suggestions",
"type": "main",
"index": 0
}
]
]
},
"average search volume and CPC": {
"main": [
[
{
"node": "Merge",
"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
Creating high-quality, SEO-friendly blog posts consistently can be time-consuming. This template helps content creators, bloggers, SEO specialists, and agencies fully automate their blogging workflow. By combining AI content generation (GPT), Google Sheets for keyword…
Source: https://n8n.io/workflows/8027/ — 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 workflow is for content teams, marketers, and solo site owners who draft posts in Google Sheets and want a reliable way to publish to WordPress automatically — including featured images and tags.
HTTP Request, Google Sheets
wordpress_fb. Uses googleSheets, httpRequest. Event-driven trigger; 28 nodes.
Google Sheets, HTTP Request
Automatically discover trending developer and security topics, generate SEO-optimized blog posts, and publish them to WordPress as drafts — complete with AI-generated featured images. Discover trends
WordPress, HTTP Request, Perplexity +1
This workflow is perfect for content managers, SEO specialists, and website owners who want to easily analyze their WordPress content structure. It automatically fetches posts, categories, and tags fr
Form Trigger, HTTP Request, Form +1
What Is TWZ n8n MailPoet Integration?
Form Trigger, HTTP Request, Google Sheets +1