{
"id": "snk82d35avKeTZ6m",
"meta": {
"instanceId": "9fb634bb746cbe3fe9f7fa86fdd635510d2f0c24c4ba919fbba1ca6aec3c4e57",
"templateCredsSetupCompleted": true
},
"name": "SEO Keyword Research Agent v1",
"tags": [],
"nodes": [
{
"id": "7fcd53bc-8c23-4ab9-b95e-5a1b75242d4e",
"name": "Get live google organic SERP regular",
"type": "n8n-nodes-dataforseo.dataForSeoSerpApi",
"position": [
256,
-80
],
"parameters": {
"keyword": "={{ $json.Keyword }}",
"language_name": "={{ $json.Language }}",
"location_name": "={{ $json.Location }}",
"max_crawl_pages": 2
},
"credentials": {
"dataForSeoApi": {
"id": "GnZc9ved6UcBtWuO",
"name": "DataForSEO account"
}
},
"typeVersion": 1
},
{
"id": "fee858f3-9f8e-4299-aa51-1e2f102f5588",
"name": "Get keyword suggestions",
"type": "n8n-nodes-dataforseo.dataForSeo",
"position": [
256,
304
],
"parameters": {
"keyword": "={{ $json.Keyword }}",
"resource": "labs",
"operation": "get-keyword-suggestions",
"language_name_required": "={{ $json.Language }}",
"location_name_required": "={{ $json.Location }}"
},
"credentials": {
"dataForSeoApi": {
"id": "GnZc9ved6UcBtWuO",
"name": "DataForSEO account"
}
},
"typeVersion": 1
},
{
"id": "546c81c8-c641-40bf-9294-38f150f7f651",
"name": "Get keyword ideas",
"type": "n8n-nodes-dataforseo.dataForSeo",
"position": [
256,
112
],
"parameters": {
"resource": "labs",
"operation": "get-keyword-ideas",
"keywords_ideas": {
"values": [
{
"value": "={{ $json.Keyword }}"
}
]
},
"language_name_required": "={{ $json.Language }}",
"location_name_required": "={{ $json.Location }}"
},
"credentials": {
"dataForSeoApi": {
"id": "GnZc9ved6UcBtWuO",
"name": "DataForSEO account"
}
},
"typeVersion": 1
},
{
"id": "4ba649bb-6ef9-4ddc-ab79-c9a394867564",
"name": "Set: SERP",
"type": "n8n-nodes-base.set",
"position": [
704,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "2da8267a-9eb4-4e69-8e85-c140c1a0e1f3",
"name": "Rank",
"type": "string",
"value": "={{ $json.rank_absolute }}"
},
{
"id": "67fe4135-fb2f-49df-bf91-d103b814ad9a",
"name": "URL",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "e57b4fff-0341-4936-86b5-049dfc77d931",
"name": "Title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "16f38c49-0274-4176-9856-61b9d9aa532f",
"name": "Description ",
"type": "string",
"value": "={{ $json.description }}"
},
{
"id": "3f641701-83aa-4d89-84f2-d5d0f502ac72",
"name": "Keyword",
"type": "string",
"value": "={{ $('Set Add').item.json.Keyword }}"
},
{
"id": "772a0ab5-47b3-44f6-ab14-08cc438772df",
"name": "Location",
"type": "string",
"value": "={{ $('Set Add').item.json.Location }}"
},
{
"id": "78b200ff-ab23-47ac-acbf-189e9e6c8b52",
"name": "Language",
"type": "string",
"value": "={{ $('Set Add').item.json.Language }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "96988f7a-2a51-4159-8f02-ed3af3c1d57d",
"name": "Set: Keyword Ideas",
"type": "n8n-nodes-base.set",
"position": [
704,
112
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "dccf956d-1c69-4055-8481-d0b3fae92b3c",
"name": "Suggestion",
"type": "string",
"value": "={{ $json.keyword }}"
},
{
"id": "dfd83a52-f8bf-4326-bf00-3e6bb4f3b792",
"name": "Monthly Serarch Volume",
"type": "string",
"value": "={{ $json.keyword_info.search_volume }}"
},
{
"id": "5644cb2c-8d8b-4b38-9894-1c247fdd539e",
"name": "Competition",
"type": "string",
"value": "={{ $json.keyword_info.competition_level }}"
},
{
"id": "118cc1a3-ac96-4cdd-8150-51beab6e3fcc",
"name": "Search Intent ",
"type": "string",
"value": "={{ $json.search_intent_info.main_intent }}"
},
{
"id": "0b87f301-451c-47ae-adbe-bd78250e6c55",
"name": "High Page Bid",
"type": "string",
"value": "={{ $json.keyword_info.high_top_of_page_bid }}"
},
{
"id": "8a8f1dd4-74ea-4529-a934-1d9c4aec0fe0",
"name": "Low Page Bid",
"type": "string",
"value": "={{ $json.keyword_info.low_top_of_page_bid }}"
},
{
"id": "bbe84bfc-ebc9-4b6b-8a36-89f540c77397",
"name": "Keyword",
"type": "string",
"value": "={{ $('Set Add').item.json.Keyword }}"
},
{
"id": "bca50dd2-45a4-4c9c-9275-dbc477009f90",
"name": "Location",
"type": "string",
"value": "={{ $('Set Add').item.json.Location }}"
},
{
"id": "45f95b94-9608-4804-b1e2-7206e802157a",
"name": "Language",
"type": "string",
"value": "={{ $('Set Add').item.json.Language }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e7c9cc2b-9adc-4327-a063-a35a57a87e90",
"name": "Set: Keyword Suggestions",
"type": "n8n-nodes-base.set",
"position": [
704,
304
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a1efd762-ef33-4d90-807e-64656f14edd1",
"name": "Suggestion ",
"type": "string",
"value": "={{ $json.keyword }}"
},
{
"id": "074c8ab4-001d-42bf-af62-ea5bbe7a604d",
"name": "Monthly Serarch Volume",
"type": "string",
"value": "={{ $json.keyword_info.search_volume }}"
},
{
"id": "07b9c0fd-5a22-49da-ac30-bc0b39263933",
"name": "Competition",
"type": "string",
"value": "={{ $json.keyword_info.competition_level }}"
},
{
"id": "f5064c46-b8bd-4a2c-8b19-771979f564e3",
"name": "Search Intent",
"type": "string",
"value": "={{ $json.search_intent_info.main_intent }}"
},
{
"id": "bbd0022f-84da-4530-bdfb-94602edcb5f7",
"name": "High Page Bid",
"type": "string",
"value": "={{ $json.keyword_info.high_top_of_page_bid }}"
},
{
"id": "d75f7a5e-1c09-45af-960b-8b61e6d236e8",
"name": "Low Page Bid",
"type": "string",
"value": "={{ $json.keyword_info.low_top_of_page_bid }}"
},
{
"id": "8c7118ad-3764-4635-967b-45795ebc0b0c",
"name": "Keyword",
"type": "string",
"value": "={{ $('Set Add').item.json.Keyword }}"
},
{
"id": "74452223-243f-4db4-8152-2adfb08f7fc7",
"name": "Location",
"type": "string",
"value": "={{ $('Set Add').item.json.Location }}"
},
{
"id": "634a0f55-7244-44ee-9160-d3336b9e28ff",
"name": "Language",
"type": "string",
"value": "={{ $('Set Add').item.json.Language }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "512a0050-b0c1-44c4-b6f9-5c4b223f29b0",
"name": "Add Row: SERP",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
-80
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Language",
"type": "string",
"display": true,
"required": false,
"displayName": "Language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rank",
"type": "string",
"display": true,
"required": false,
"displayName": "Rank",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description ",
"type": "string",
"display": true,
"required": false,
"displayName": "Description ",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 468374814,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=468374814",
"cachedResultName": "KW SERP"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "dbad8f86-314e-40f0-8baa-2a7624fa720d",
"name": "Add Row: Keyword Ideas",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
112
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Language",
"type": "string",
"display": true,
"required": false,
"displayName": "Language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suggestion",
"type": "string",
"display": true,
"required": false,
"displayName": "Suggestion",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Monthly Serarch Volume",
"type": "string",
"display": true,
"required": false,
"displayName": "Monthly Serarch Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Search Intent ",
"type": "string",
"display": true,
"required": false,
"displayName": "Search Intent ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "High Page Bid",
"type": "string",
"display": true,
"required": false,
"displayName": "High Page Bid",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Low Page Bid",
"type": "string",
"display": true,
"required": false,
"displayName": "Low Page Bid",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 895821319,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=895821319",
"cachedResultName": "KW Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "4f173dde-92af-42f7-b0dc-fab6915bf0b9",
"name": "Add Row: Keyword Suggestions",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
304
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Language",
"type": "string",
"display": true,
"required": false,
"displayName": "Language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suggestion ",
"type": "string",
"display": true,
"required": false,
"displayName": "Suggestion ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Monthly Serarch Volume",
"type": "string",
"display": true,
"required": false,
"displayName": "Monthly Serarch Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Search Intent",
"type": "string",
"display": true,
"required": false,
"displayName": "Search Intent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "High Page Bid",
"type": "string",
"display": true,
"required": false,
"displayName": "High Page Bid",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Low Page Bid",
"type": "string",
"display": true,
"required": false,
"displayName": "Low Page Bid",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 479239852,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=479239852",
"cachedResultName": "KW Suggestions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "4a4fa877-2034-494c-ba62-c729eda28c2d",
"name": "Get: Keyword Ideas",
"type": "n8n-nodes-base.code",
"position": [
480,
112
],
"parameters": {
"jsCode": "return $input.first().json.tasks[0].result[0].items"
},
"typeVersion": 2
},
{
"id": "09ea2050-9320-46c9-b493-e8e493aaf1dc",
"name": "Get: Keyword Suggestions",
"type": "n8n-nodes-base.code",
"position": [
480,
304
],
"parameters": {
"jsCode": "return $input.first().json.tasks[0].result[0].items"
},
"typeVersion": 2
},
{
"id": "f1b9ce5d-1d25-441e-8ae0-a86a0cfe4f11",
"name": "Get: SERP",
"type": "n8n-nodes-base.code",
"position": [
480,
-80
],
"parameters": {
"jsCode": "return $input.first().json.tasks[0].result[0].items"
},
"typeVersion": 2
},
{
"id": "2ccc4473-e1d8-4b09-a8bd-847c0e280f64",
"name": "Keyword Research Completed",
"type": "n8n-nodes-base.googleSheets",
"position": [
1600,
112
],
"parameters": {
"columns": {
"value": {
"Status": "Completed",
"Keyword": "={{ $json.Keyword[0] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Language",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keyword"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=0",
"cachedResultName": "Input Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "de886153-609b-477f-b328-d66b3b080949",
"name": "On Keyword Add",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-416,
16
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=0",
"cachedResultName": "Input Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "LeqiK6fwf0NDQTGj",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "3dba4697-9af4-4311-9bd8-03cbec786bf4",
"name": "On Keyword Reset",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-416,
736
],
"parameters": {
"event": "rowUpdate",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=0",
"cachedResultName": "Input Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "LeqiK6fwf0NDQTGj",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "22e38f22-4920-44ce-b743-d953f20538d7",
"name": "Reset Get row(s) SERP",
"type": "n8n-nodes-base.googleSheets",
"position": [
256,
544
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.Keyword }}",
"lookupColumn": "Keyword"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 468374814,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=468374814",
"cachedResultName": "KW SERP"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "ed2f53f8-6b36-4629-bb22-68031b41df20",
"name": "Reset Get row(s) Suggestion",
"type": "n8n-nodes-base.googleSheets",
"position": [
256,
736
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.Keyword }}",
"lookupColumn": "Keyword"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 479239852,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=479239852",
"cachedResultName": "KW Suggestions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "c5c5745a-2c5a-423e-816b-defbca2d3b3c",
"name": "Reset Get row(s) Ideas",
"type": "n8n-nodes-base.googleSheets",
"position": [
256,
928
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.Keyword }}",
"lookupColumn": "Keyword"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 895821319,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=895821319",
"cachedResultName": "KW Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "b0f4a535-0a95-4765-bc14-4143b290985d",
"name": "Delete row SERP",
"type": "n8n-nodes-base.googleSheets",
"position": [
704,
736
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 468374814,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=468374814",
"cachedResultName": "KW SERP"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
},
"startIndex": "={{ $json.startRow }}",
"numberToDelete": "={{ $json.count }}"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "d0be2283-7ab7-4999-b9e9-68460e3c0057",
"name": "Delete row Suggestion",
"type": "n8n-nodes-base.googleSheets",
"position": [
704,
544
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 479239852,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=479239852",
"cachedResultName": "KW Suggestions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
},
"startIndex": "={{ $json.startRow }}",
"numberToDelete": "={{ $json.count }}"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "55758345-f3a6-415c-9d72-58e151ee0234",
"name": "Delete row Idea",
"type": "n8n-nodes-base.googleSheets",
"position": [
704,
928
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 895821319,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=895821319",
"cachedResultName": "KW Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
},
"startIndex": "={{ $json.startRow }}",
"numberToDelete": "={{ $json.count }}"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "b1aea471-9471-4660-8573-40631196b8fd",
"name": "Filter Reset",
"type": "n8n-nodes-base.filter",
"position": [
-192,
736
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c0c1d436-878e-4f21-bc9f-dcd9ad42cd85",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "=Reset"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b492993c-3ed3-4dd6-9115-ee875aa83c95",
"name": "Filter Add",
"type": "n8n-nodes-base.filter",
"position": [
-192,
112
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "29dd5faf-1dd2-48fb-984f-0df286e28488",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "Pending"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "264a6123-e750-44c6-a292-373f714546b6",
"name": "Keyword Research Completed1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1600,
736
],
"parameters": {
"columns": {
"value": {
"Status": "Completed",
"Keyword": "={{ $json.Keyword[0] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Language",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keyword"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=0",
"cachedResultName": "Input Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "TB2tCNqF1GBm2ag8",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "0eaa0eb1-f884-494e-83d0-31bb30bbe331",
"name": "Format Add Row",
"type": "n8n-nodes-base.code",
"position": [
1152,
112
],
"parameters": {
"jsCode": "const data = {\n Keyword: $('Set Add').first().json.Keyword,\n Location: $('Set Add').first().json.Location,\n Language: $('Set Add').first().json.Language\n}\n\nreturn data"
},
"typeVersion": 2
},
{
"id": "6e636704-9753-467e-ba2a-5410dd00635b",
"name": "Format Reset Row",
"type": "n8n-nodes-base.code",
"position": [
1152,
736
],
"parameters": {
"jsCode": "const data = {\n Keyword: $('Set Reset').first().json.Keyword,\n Location: $('Set Reset').first().json.Location,\n Language: $('Set Reset').first().json.Language\n}\n\nreturn data"
},
"typeVersion": 2
},
{
"id": "822fafee-64ea-4724-8445-76fb87d72320",
"name": "Aggregate Add",
"type": "n8n-nodes-base.aggregate",
"position": [
1376,
112
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "Keyword"
}
]
}
},
"typeVersion": 1
},
{
"id": "ace21167-526a-4fc2-869d-fe747a6ebc7d",
"name": "Aggregate Reset",
"type": "n8n-nodes-base.aggregate",
"position": [
1376,
736
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "Keyword"
}
]
}
},
"typeVersion": 1
},
{
"id": "921dacd5-ecef-455d-bae2-0392caa0487e",
"name": "On Keyword Pending",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-416,
208
],
"parameters": {
"event": "rowUpdate",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit#gid=0",
"cachedResultName": "Input Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/edit?usp=drivesdk",
"cachedResultName": "SEO Keyword Research v1 - Ai With Sohail"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "LeqiK6fwf0NDQTGj",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "7c4069e7-7892-42cf-a4ee-954a17b1f9a0",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
928,
736
],
"webhookId": "97c02ffd-0da8-4b2f-ae7f-b6de78cd94bd",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "55f3201d-aab1-49a4-a7df-fedc3890feaf",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"position": [
928,
544
],
"webhookId": "97c02ffd-0da8-4b2f-ae7f-b6de78cd94bd",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "4bc73822-02d3-4470-aa23-a3da516b2afc",
"name": "Wait2",
"type": "n8n-nodes-base.wait",
"position": [
928,
928
],
"webhookId": "97c02ffd-0da8-4b2f-ae7f-b6de78cd94bd",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "776177ae-5d08-416b-b387-c58f1afa1e01",
"name": "Batch Rows For Delete",
"type": "n8n-nodes-base.code",
"position": [
480,
736
],
"parameters": {
"jsCode": "function groupKeywordBlocks(rows) {\n const groups = [];\n let currentKeyword = null;\n let startRow = null;\n let count = 0;\n\n for (let i = 0; i < rows.length; i++) {\n const row = rows[i].json;\n const keyword = row.Keyword;\n const rowNumber = row.row_number;\n\n // Start new block\n if (currentKeyword === null) {\n currentKeyword = keyword;\n startRow = rowNumber;\n count = 1;\n continue;\n }\n\n // If keyword continues → expand block\n if (keyword === currentKeyword) {\n count++;\n } else {\n // Keyword changed → close previous block\n groups.push({\n keyword: currentKeyword,\n startRow,\n count,\n });\n\n // Start new block\n currentKeyword = keyword;\n startRow = rowNumber;\n count = 1;\n }\n }\n\n // Push the last group if exists\n if (currentKeyword !== null) {\n groups.push({\n keyword: currentKeyword,\n startRow,\n count,\n });\n }\n\n return groups;\n}\nconst rows = $input.all()\nconst groups = groupKeywordBlocks(rows)\nreturn groups\n"
},
"typeVersion": 2
},
{
"id": "2d2715af-8544-49e8-bf68-5944ff5a28bf",
"name": "Set Add",
"type": "n8n-nodes-base.set",
"position": [
32,
112
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "73cec9de-02cd-40c7-9fa6-9b2ff97db893",
"name": "Keyword",
"type": "string",
"value": "={{ $json.Keyword }}"
},
{
"id": "afa71e45-8fec-4b72-b969-8c378ef78036",
"name": "Location",
"type": "string",
"value": "={{ $json.Location }}"
},
{
"id": "13b7e767-3140-46ab-8d31-504ed14c3216",
"name": "Language",
"type": "string",
"value": "={{ $json.Language }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ccab583b-45a7-4d76-be55-f430b85a88f7",
"name": "Set Reset",
"type": "n8n-nodes-base.set",
"position": [
32,
736
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "73cec9de-02cd-40c7-9fa6-9b2ff97db893",
"name": "Keyword",
"type": "string",
"value": "={{ $json.Keyword }}"
},
{
"id": "afa71e45-8fec-4b72-b969-8c378ef78036",
"name": "Location",
"type": "string",
"value": "={{ $json.Location }}"
},
{
"id": "13b7e767-3140-46ab-8d31-504ed14c3216",
"name": "Language",
"type": "string",
"value": "={{ $json.Language }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "16da72d8-a7d7-4ca3-b685-695fd51d3bc0",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-496,
-112
],
"parameters": {
"width": 2368,
"height": 608,
"content": "## Do The Keyword Research"
},
"typeVersion": 1
},
{
"id": "d00a552b-e3bf-4514-82e2-6c6ce90244fa",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-496,
496
],
"parameters": {
"width": 2368,
"height": 608,
"content": "## Reset The Keyword Research"
},
"typeVersion": 1
},
{
"id": "fd9df228-4c77-44b3-8ef6-ca8189e93a94",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1152,
-112
],
"parameters": {
"width": 656,
"height": 1216,
"content": "# 🛠️ Setup Guide \n\n**Author: [Sohail Jafri](https://link.thesohailjafri.me/web_ai) | [Youtube](https://link.thesohailjafri.me/yt_ai) | [Instagram](https://link.thesohailjafri.me/ig_ai) | [Join Skool](https://link.thesohailjafri.me/join-skool)**\n\n### ✅ Step 1: Copy the Google Sheet Template \n#### Your workflow uses multiple tabs for SERP, Keyword Ideas, Suggestions, and Input Keywords.\n\n#### 📄 **Google Sheet Template (Make a Copy):** \n#### https://docs.google.com/spreadsheets/d/1_EHmCUiiwKO3wIUIPRd8E_4APDhT42YWUiw4qRIu0Sc/copy\n\n### ✅ Step 2: Connect Your DataForSEO API \n#### All research nodes use your **DataForSEO account** credential:\n\nNodes requiring DataForSEO:\n- **Get live google organic SERP regular** \n- **Get keyword ideas** \n- **Get keyword suggestions**\n\n### ✅ Step 3: Internal Processing Nodes \n#### These nodes need no credentials but must stay unchanged\n#### They structure DataForSEO output and prepare Google Sheets rows.\n\n### 💡 Step 4: Test the Workflow \n1. Open your copied Google Sheet. \n2. Add a row in **Input Keywords**: \n - Keyword \n - Location \n - Language \n - Status = `Pending` \n3. Workflow runs automatically within 1–2 minutes. \n4. Check sheets: \n - SERP → **KW SERP** \n - Ideas → **KW Ideas** \n - Suggestions → **KW Suggestions** \n5. `Status` updates to **Completed** automatically. \n6. To reset data, change Status → `Reset`.\n"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "4afe8480-c4df-4872-ba98-b020d58ed091",
"connections": {
"Wait": {
"main": [
[
{
"node": "Format Reset Row",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Format Reset Row",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Format Reset Row",
"type": "main",
"index": 0
}
]
]
},
"Set Add": {
"main": [
[
{
"node": "Get keyword ideas",
"type": "main",
"index": 0
},
{
"node": "Get live google organic SERP regular",
"type": "main",
"index": 0
},
{
"node": "Get keyword suggestions",
"type": "main",
"index": 0
}
]
]
},
"Get: SERP": {
"main": [
[
{
"node": "Set: SERP",
"type": "main",
"index": 0
}
]
]
},
"Set Reset": {
"main": [
[
{
"node": "Reset Get row(s) SERP",
"type": "main",
"index": 0
},
{
"node": "Reset Get row(s) Suggestion",
"type": "main",
"index": 0
},
{
"node": "Reset Get row(s) Ideas",
"type": "main",
"index": 0
}
]
]
},
"Set: SERP": {
"main": [
[
{
"node": "Add Row: SERP",
"type": "main",
"index": 0
}
]
]
},
"Filter Add": {
"main": [
[
{
"node": "Set Add",
"type": "main",
"index": 0
}
]
]
},
"Filter Reset": {
"main": [
[
{
"node": "Set Reset",
"type": "main",
"index": 0
}
]
]
},
"Add Row: SERP": {
"main": [
[
{
"node": "Format Add Row",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Add": {
"main": [
[
{
"node": "Keyword Research Completed",
"type": "main",
"index": 0
}
]
]
},
"Format Add Row": {
"main": [
[
{
"node": "Aggregate Add",
"type": "main",
"index": 0
}
]
]
},
"On Keyword Add": {
"main": [
[
{
"node": "Filter Add",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Reset": {
"main": [
[
{
"node": "Keyword Research Completed1",
"type": "main",
"index": 0
}
]
]
},
"Delete row Idea": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Delete row SERP": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Format Reset Row": {
"main": [
[
{
"node": "Aggregate Reset",
"type": "main",
"index": 0
}
]
]
},
"On Keyword Reset": {
"main": [
[
{
"node": "Filter Reset",
"type": "main",
"index": 0
}
]
]
},
"Get keyword ideas": {
"main": [
[
{
"node": "Get: Keyword Ideas",
"type": "main",
"index": 0
}
]
]
},
"Get: Keyword Ideas": {
"main": [
[
{
"node": "Set: Keyword Ideas",
"type": "main",
"index": 0
}
]
]
},
"On Keyword Pending": {
"main": [
[
{
"node": "Filter Add",
"type": "main",
"index": 0
}
]
]
},
"Set: Keyword Ideas": {
"main": [
[
{
"node": "Add Row: Keyword Ideas",
"type": "main",
"index": 0
}
]
]
},
"Batch Rows For Delete": {
"main": [
[
{
"node": "Delete row Suggestion",
"type": "main",
"index": 0
},
{
"node": "Delete row SERP",
"type": "main",
"index": 0
},
{
"node": "Delete row Idea",
"type": "main",
"index": 0
}
]
]
},
"Delete row Suggestion": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Reset Get row(s) SERP": {
"main": [
[
{
"node": "Batch Rows For Delete",
"type": "main",
"index": 0
}
]
]
},
"Add Row: Keyword Ideas": {
"main": [
[
{
"node": "Format Add Row",
"type": "main",
"index": 0
}
]
]
},
"Reset Get row(s) Ideas": {
"main": [
[
{
"node": "Batch Rows For Delete",
"type": "main",
"index": 0
}
]
]
},
"Get keyword suggestions": {
"main": [
[
{
"node": "Get: Keyword Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Get: Keyword Suggestions": {
"main": [
[
{
"node": "Set: Keyword Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Set: Keyword Suggestions": {
"main": [
[
{
"node": "Add Row: Keyword Suggestions",
"type": "main",
"index": 0
}
]
]
},
"Reset Get row(s) Suggestion": {
"main": [
[
{
"node": "Batch Rows For Delete",
"type": "main",
"index": 0
}
]
]
},
"Add Row: Keyword Suggestions": {
"main": [
[
{
"node": "Format Add Row",
"type": "main",
"index": 0
}
]
]
},
"Get live google organic SERP regular": {
"main": [
[
{
"node": "Get: SERP",
"type": "main",
"index": 0
}
]
]
}
}
}