Nima Salimi 
This workflow corresponds to n8n.io template #10137 — we link there as the canonical source.
This workflow follows the Form Trigger → 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": "IJ8L1LgxmncCxrN6",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "n8n - DataforSEO - All Operations",
"tags": [
{
"id": "RhAmCaLYc9EkF42I",
"name": "n8n",
"createdAt": "2025-08-24T08:04:35.027Z",
"updatedAt": "2025-08-24T08:04:35.027Z"
}
],
"nodes": [
{
"id": "a8b86cae-fc03-433b-bca7-be4137f40b9b",
"name": "On form submission",
"type": "n8n-nodes-base.formTrigger",
"position": [
-180,
-160
],
"parameters": {
"options": {
"customCss": "/* Grok UI \u2014 Dark, neon accents, soft glow */\n:root {\n /* Typography */\n --font-family: 'Inter', system-ui, -apple-system, Segoe UI, Roboto, Helvetica, Arial, 'Apple Color Emoji', 'Segoe UI Emoji';\n --font-weight-normal: 500;\n --font-weight-bold: 700;\n --font-size-body: 13px;\n --font-size-label: 13px;\n --font-size-test-notice: 12px;\n --font-size-input: 14px;\n --font-size-header: 22px;\n --font-size-paragraph: 14px;\n --font-size-link: 13px;\n --font-size-error: 12px;\n --font-size-html-h1: 28px;\n --font-size-html-h2: 22px;\n --font-size-html-h3: 18px;\n --font-size-html-h4: 16px;\n --font-size-html-h5: 13px;\n --font-size-html-h6: 12px;\n --font-size-subheader: 13px;\n\n /* Colors \u2014 Grok vibes */\n --color-background: #0b0e14; /* page bg */\n --color-test-notice-text: #f5d48a;\n --color-test-notice-bg: #1a1410;\n --color-test-notice-border: #4a3a22;\n\n --color-card-bg: #11131a; /* card bg */\n --color-card-border: #1f2430; /* card border */\n --color-card-shadow: rgba(155, 135, 245, 0.12);\n\n --color-link: #b8a6ff; /* links */\n --color-header: #eceff4; /* headings */\n --color-label: #c9ced8; /* form labels */\n --color-input-border: #2a3040; /* inputs */\n --color-input-text: #e6e9f0;\n --color-focus-border: #9b87f5; /* focus ring color */\n\n /* Accent + actions */\n --color-submit-btn-bg: linear-gradient(90deg, #6d5cff 0%, #b83aff 100%);\n --color-submit-btn-text: #0b0e14;\n --color-clear-button-bg: #2a3040;\n\n /* Status */\n --color-error: #ff5c7c;\n --color-required: #ff84d8;\n\n /* Content */\n --color-html-text: #c9ced8;\n --color-html-link: #b8a6ff;\n --color-header-subtext: #9aa3b2;\n\n /* Radii */\n --border-radius-card: 14px;\n --border-radius-input: 12px;\n --border-radius-clear-btn: 50%;\n --card-border-radius: 14px;\n\n /* Spacing */\n --padding-container-top: 28px;\n --padding-card: 24px;\n --padding-test-notice-vertical: 10px;\n --padding-test-notice-horizontal: 16px;\n --margin-bottom-card: 16px;\n --padding-form-input: 12px;\n --card-padding: 24px;\n --card-margin-bottom: 16px;\n\n /* Dimensions */\n --container-width: 520px; /* slightly wider for breathing room */\n --submit-btn-height: 46px;\n --checkbox-size: 18px;\n\n /* Effects */\n --box-shadow-card: 0 16px 48px 0 var(--color-card-shadow);\n --opacity-placeholder: 0.55;\n\n /* Extra Grok-y helpers */\n --gradient-accent: linear-gradient(90deg, #6d5cff 0%, #b83aff 100%);\n --focus-ring: 0 0 0 3px rgba(155, 135, 245, 0.35);\n}\n\n/* ===== Optional: polish the default n8n form elements ===== */\n\n/* Page / container */\nbody {\n background: var(--color-background);\n color: var(--color-html-text);\n font-family: var(--font-family);\n font-weight: var(--font-weight-normal);\n}\n\n/* Cards */\n.card,\n.n8n-form-card {\n background: var(--color-card-bg);\n border: 1px solid var(--color-card-border);\n border-radius: var(--card-border-radius);\n box-shadow: var(--box-shadow-card);\n}\n\n/* Headings */\nh1, h2, h3, h4, h5, h6 {\n color: var(--color-header);\n letter-spacing: 0.1px;\n}\n\n/* Labels */\nlabel {\n color: var(--color-label);\n font-weight: 600;\n}\n\n/* Inputs */\ninput[type=\"text\"],\ninput[type=\"email\"],\ninput[type=\"number\"],\ninput[type=\"url\"],\ninput[type=\"tel\"],\ntextarea,\nselect {\n background: #0f1218;\n color: var(--color-input-text);\n border: 1px solid var(--color-input-border);\n border-radius: var(--border-radius-input);\n padding: var(--padding-form-input);\n outline: none;\n transition: border-color 120ms ease, box-shadow 120ms ease, background 120ms ease;\n}\n\ninput::placeholder,\ntextarea::placeholder {\n opacity: var(--opacity-placeholder);\n}\n\n/* Focus glow */\ninput:focus,\ntextarea:focus,\nselect:focus {\n border-color: var(--color-focus-border);\n box-shadow: var(--focus-ring);\n}\n\n/* Checkboxes / radios */\ninput[type=\"checkbox\"],\ninput[type=\"radio\"] {\n width: var(--checkbox-size);\n height: var(--checkbox-size);\n accent-color: #9b87f5;\n border-radius: 6px;\n}\n\n/* Submit button */\nbutton[type=\"submit\"],\n.n8n-form-submit {\n background: var(--gradient-accent);\n color: var(--color-submit-btn-text);\n height: var(--submit-btn-height);\n border: 0;\n border-radius: 12px;\n font-weight: 700;\n letter-spacing: 0.2px;\n cursor: pointer;\n transition: transform 80ms ease, filter 120ms ease;\n}\nbutton[type=\"submit\"]:hover,\n.n8n-form-submit:hover {\n filter: brightness(1.06);\n}\nbutton[type=\"submit\"]:active,\n.n8n-form-submit:active {\n transform: translateY(1px);\n}\n\n/* Secondary / clear button */\n.n8n-form-clear,\nbutton[type=\"button\"] {\n background: var(--color-clear-button-bg);\n color: #d4d7de;\n border: 1px solid var(--color-input-border);\n border-radius: 12px;\n}\n\n/* Links */\na {\n color: var(--color-html-link);\n text-decoration: none;\n}\na:hover {\n text-decoration: underline;\n}\n\n/* Test notice / banner */\n.notice,\n.n8n-form-test-notice {\n color: var(--color-test-notice-text);\n background: var(--color-test-notice-bg);\n border: 1px solid var(--color-test-notice-border);\n border-radius: 10px;\n padding: var(--padding-test-notice-vertical) var(--padding-test-notice-horizontal);\n}\n\n/* Error states */\n.error,\ninput.error,\ntextarea.error,\nselect.error {\n border-color: var(--color-error) !important;\n box-shadow: 0 0 0 3px rgba(255, 92, 124, 0.25) !important;\n}\n.error-text {\n color: var(--color-error);\n font-size: var(--font-size-error);\n}\n\n/* Subtext */\n.form-subtext,\n.helper-text {\n color: var(--color-header-subtext);\n}\n\n/* Container width */\n.form-container,\n.n8n-form-container {\n max-width: var(--container-width);\n}\n",
"buttonLabel": "\ud83d\udc49 Get Related Keywords"
},
"formTitle": "SEO Related Keyword Finder\ud83d\ude80",
"formFields": {
"values": [
{
"fieldLabel": "keyword",
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "location_name",
"fieldOptions": {
"values": [
{
"option": "United States"
},
{
"option": "Algeria"
},
{
"option": "Angola"
},
{
"option": "Argentina"
},
{
"option": "Australia"
},
{
"option": "Austria"
},
{
"option": "Azerbaijan"
},
{
"option": "Bahrain"
},
{
"option": "Bangladesh"
},
{
"option": "Belgium"
},
{
"option": "Bolivia"
},
{
"option": "Bosnia and Herzegovina"
},
{
"option": "Brazil"
},
{
"option": "Bulgaria"
},
{
"option": "Burkina Faso"
},
{
"option": "Cambodia"
},
{
"option": "Cameroon"
},
{
"option": "Canada"
},
{
"option": "Chile"
},
{
"option": "Colombia"
},
{
"option": "Costa Rica"
},
{
"option": "Cote d'Ivoire"
},
{
"option": "Croatia"
},
{
"option": "Cyprus"
},
{
"option": "Czechia"
},
{
"option": "Denmark"
},
{
"option": "Ecuador"
},
{
"option": "Egypt"
},
{
"option": "El Salvador"
},
{
"option": "Estonia"
},
{
"option": "Finland"
},
{
"option": "France"
},
{
"option": "Germany"
},
{
"option": "Ghana"
},
{
"option": "Greece"
},
{
"option": "Guatemala"
},
{
"option": "Hong Kong"
},
{
"option": "Hungary"
},
{
"option": "India"
},
{
"option": "Indonesia"
},
{
"option": "Ireland"
},
{
"option": "Israel"
},
{
"option": "Italy"
},
{
"option": "Japan"
},
{
"option": "Jordan"
},
{
"option": "Kazakhstan"
},
{
"option": "Kenya"
},
{
"option": "Latvia"
},
{
"option": "Lithuania"
},
{
"option": "Malaysia"
},
{
"option": "Malta"
},
{
"option": "Mexico"
},
{
"option": "Moldova"
},
{
"option": "Monaco"
},
{
"option": "Morocco"
},
{
"option": "Myanmar (Burma)"
},
{
"option": "Netherlands"
},
{
"option": "New Zealand"
},
{
"option": "Nicaragua"
},
{
"option": "Nigeria"
},
{
"option": "North Macedonia"
},
{
"option": "Norway"
},
{
"option": "Pakistan"
},
{
"option": "Panama"
},
{
"option": "Paraguay"
},
{
"option": "Peru"
},
{
"option": "Philippines"
},
{
"option": "Poland"
},
{
"option": "Portugal"
},
{
"option": "Romania"
},
{
"option": "Saudi Arabia"
},
{
"option": "Senegal"
},
{
"option": "Serbia"
},
{
"option": "Singapore"
},
{
"option": "Slovakia"
},
{
"option": "Slovenia"
},
{
"option": "South Africa"
},
{
"option": "South Korea"
},
{
"option": "Spain"
},
{
"option": "Sri Lanka"
},
{
"option": "Sweden"
},
{
"option": "Switzerland"
},
{
"option": "Taiwan"
},
{
"option": "Thailand"
},
{
"option": "Tunisia"
},
{
"option": "Turkiye"
},
{
"option": "Ukraine"
},
{
"option": "United Arab Emirates"
},
{
"option": "United Kingdom"
},
{
"option": "Albania"
},
{
"option": "Uruguay"
},
{
"option": "Venezuela"
},
{
"option": "Vietnam"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "language_name",
"fieldOptions": {
"values": [
{
"option": "English"
},
{
"option": "Albanian"
},
{
"option": "Arabic"
},
{
"option": "Armenian"
},
{
"option": "Azeri"
},
{
"option": "Bengali"
},
{
"option": "Bosnian"
},
{
"option": "Bulgarian"
},
{
"option": "Chinese (Simplified)"
},
{
"option": "Chinese (Traditional)"
},
{
"option": "Croatian"
},
{
"option": "Czech"
},
{
"option": "Danish"
},
{
"option": "Dutch"
},
{
"option": "Estonian"
},
{
"option": "Finnish"
},
{
"option": "French"
},
{
"option": "German"
},
{
"option": "Greek"
},
{
"option": "Hebrew"
},
{
"option": "Hindi"
},
{
"option": "Hungarian"
},
{
"option": "Indonesian"
},
{
"option": "Italian"
},
{
"option": "Japanese"
},
{
"option": "Korean"
},
{
"option": "Latvian"
},
{
"option": "Lithuanian"
},
{
"option": "Macedonian"
},
{
"option": "Malay"
},
{
"option": "Norwegian"
},
{
"option": "Polish"
},
{
"option": "Portuguese"
},
{
"option": "Romanian"
},
{
"option": "Russian"
},
{
"option": "Serbian"
},
{
"option": "Slovak"
},
{
"option": "Slovenian"
},
{
"option": "Spanish"
},
{
"option": "Swedish"
},
{
"option": "Tagalog"
},
{
"option": "Thai"
},
{
"option": "Turkish"
},
{
"option": "Ukrainian"
},
{
"option": "Urdu"
},
{
"option": "Vietnamese"
}
]
},
"requiredField": true
},
{
"fieldType": "dropdown",
"fieldLabel": "Operation",
"fieldOptions": {
"values": [
{
"option": "related keywords\ud83d\udd11"
},
{
"option": "keyword suggestion\ud83d\udca1"
},
{
"option": "get autocomplete\ud83e\udde9"
},
{
"option": "get subtopics\ud83d\udcda"
},
{
"option": "people also ask\ud83d\udd0d"
}
]
}
}
]
},
"formDescription": "\u270f\ufe0f Enter your target keyword\n\ud83d\udccd Choose the location\n\ud83c\udf10 Select the language"
},
"typeVersion": 2.2
},
{
"id": "75613162-339b-4792-9c21-300a84cd07eb",
"name": "related keyword",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-560
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/related_keywords/live",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"depth\": 3,\n \"include_seed_keyword\": false,\n \"include_serp_info\": true,\n \"ignore_synonyms\": false,\n \"include_clickstream_data\": false,\n \"replace_with_core_keyword\": false,\n \"limit\": 100\n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "00881b6b-944e-448d-8786-2960602d9ad8",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
760,
-200
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "related",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f1d6e4b2-6191-41a1-ad33-e1af098a2c0d",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "related keywords\ud83d\udd11"
}
]
},
"renameOutput": true
},
{
"outputKey": "sugges",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "04f77653-ef1b-46bd-a607-9e7af4185e08",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "keyword suggestion\ud83d\udca1"
}
]
},
"renameOutput": true
},
{
"outputKey": "auto",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "32ed49a3-7107-45b3-b631-e9656f3ade19",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "get autocomplete\ud83e\udde9"
}
]
},
"renameOutput": true
},
{
"outputKey": "subtopic",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7c5cede4-f3e0-4015-bb6e-cb2abbac8bad",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "get subtopics\ud83d\udcda"
}
]
},
"renameOutput": true
},
{
"outputKey": "also ask",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e5e713e3-dedf-4590-9b72-cc2414ce60d5",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.operation }}",
"rightValue": "people also ask\ud83d\udd0d"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "435d55c0-4f2a-434c-a4d0-b73625c14e34",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
300,
-160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "687cf18b-3f44-49bf-b984-8f080ccf0801",
"name": "operation",
"type": "string",
"value": "={{ $json.Operation }}"
},
{
"id": "88dc839b-684f-4dd4-b3df-5c17e0df7042",
"name": "keyword",
"type": "string",
"value": "={{ $json.keyword }}"
},
{
"id": "da2f072b-9e53-4ba8-80f4-2dc38be52aad",
"name": "location_name",
"type": "string",
"value": "={{ $json.location_name }}"
},
{
"id": "e69eaa8f-f71d-43d7-8152-6903a8867162",
"name": "language_name",
"type": "string",
"value": "={{ $json.language_name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f57d30ea-999a-47ad-807b-8dcfe562a9e2",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
2100,
-560
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
"name": "related keyword",
"type": "string",
"value": "= {{ $json.keyword_data.keyword }}"
},
{
"id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
"name": "keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "809a4151-ab92-40e6-a8d2-4ed1a96a49aa",
"name": "keyword difficulty",
"type": "string",
"value": "={{ $json.keyword_data.keyword_properties.keyword_difficulty }}"
},
{
"id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
"name": "search intent",
"type": "string",
"value": "={{ $json.keyword_data.search_intent_info.main_intent }}"
},
{
"id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
"name": "last update",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.last_updated_time }}"
},
{
"id": "1a0d83e5-4651-4cc9-b282-1b58acd4bff2",
"name": "SERP Analysis",
"type": "string",
"value": "={{ $json.keyword_data.serp_info.serp_item_types.join(\",\") }}"
},
{
"id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
"name": "search volume",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.search_volume }}"
},
{
"id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
"name": "CPC",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.cpc }}"
},
{
"id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
"name": "compitition",
"type": "string",
"value": "={{ $json.keyword_data.keyword_info.competition_level }}"
},
{
"id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
"name": "type",
"type": "string",
"value": "related_keyword"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "419d2fee-2e8c-4e0a-abfe-2bc1f2ca3533",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
-560
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "ff5790ac-3a24-4993-81db-9ac794a0c976",
"name": "Split Out1",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
-360
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "63a738b1-cb97-4390-a767-86b4ce1197f9",
"name": "Split Out2",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
-160
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "9e3c5450-9321-4983-b6d8-8a5698e08aab",
"name": "Split Out3",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
60
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].sub_topics"
},
"typeVersion": 1
},
{
"id": "c820bb1c-5f2c-4f9e-bf05-730a608b7797",
"name": "Split Out4",
"type": "n8n-nodes-base.splitOut",
"position": [
1860,
280
],
"parameters": {
"options": {},
"fieldToSplitOut": "tasks[0].result[0].items"
},
"typeVersion": 1
},
{
"id": "a7ad86d2-5a6f-4078-b94a-9fd28e9cfe6e",
"name": "keyword suggestion",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-360
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_suggestions/live",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"depth\": 3,\n \"include_seed_keyword\": false,\n \"include_serp_info\": false,\n \"ignore_synonyms\": false,\n \"include_clickstream_data\": false,\n \"replace_with_core_keyword\": false,\n \"limit\": 100\n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "abc58e82-a4b4-4db1-b02a-2b3b30a9ed83",
"name": "keyword suggestion sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-360
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#70193D"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "833ea8c4-6d65-4cee-bd28-14b9d884c7d8",
"name": "get autocomplete",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
-160
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/autocomplete/live/advanced",
"method": "POST",
"options": {},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"client\": \"gws-wiz-serp\"\n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "e4b9cc5a-a120-4b7c-a31b-0462ad0511e6",
"name": "get subtopics",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
60
],
"parameters": {
"url": "https://api.dataforseo.com/v3/content_generation/generate_sub_topics/live",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"topic\":\"{{ $('Switch').item.json.keyword }}\"\n \n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "9a78b5a9-5ebc-4fe5-8c45-d1448219870b",
"name": "people also ask",
"type": "n8n-nodes-base.httpRequest",
"position": [
1560,
280
],
"parameters": {
"url": "https://api.dataforseo.YOUR_AWS_SECRET_KEY_HERE",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"jsonBody": "=[\n {\n \"keyword\": \"{{ $('Switch').item.json.keyword }}\",\n \"location_name\":\"{{ $('Switch').item.json.location_name }}\",\n \"language_name\":\"{{ $('Switch').item.json.language_name }}\",\n \"depth\": 20,\n \"people_also_ask_click_depth\": 1\n \n }\n]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "34e47468-0c60-427f-812e-bf093c317a71",
"name": "get autocomplete sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-160
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#26AFF4"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "b12faf3e-2f1c-41d3-9e1d-cabd95c94be3",
"name": "get subtopics sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
60
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#26F490"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "7078dcd3-3220-48a4-b0b1-f9b2df41a5c9",
"name": "people also ask sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
280
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#E1EB22"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "eabf4c58-85e2-4f73-85ed-107ff42fa330",
"name": "Edit Fields4",
"type": "n8n-nodes-base.set",
"position": [
2100,
-160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bcfd6063-5f17-481e-90a4-ffb6c90e03f4",
"name": "primary keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "82f4e7ef-214e-474f-87d8-e23bbffa02b0",
"name": "type",
"type": "string",
"value": "={{ $json.type }}"
},
{
"id": "6a3ca04d-af0a-474f-bfa6-386f302062b8",
"name": "get autocomplete",
"type": "string",
"value": "={{ $json.suggestion }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "22e11d3b-ad30-40fb-beb5-869fa32908ae",
"name": "Edit Fields6",
"type": "n8n-nodes-base.set",
"position": [
2100,
60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bcfd6063-5f17-481e-90a4-ffb6c90e03f4",
"name": "primary keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "82f4e7ef-214e-474f-87d8-e23bbffa02b0",
"name": "type",
"type": "string",
"value": "sub_topics"
},
{
"id": "6a3ca04d-af0a-474f-bfa6-386f302062b8",
"name": "sub topics",
"type": "string",
"value": "={{ $json[\"tasks[0].result[0].sub_topics\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "fdd8e7c2-97ce-4988-8f64-6601aabc7b03",
"name": "Split Out6",
"type": "n8n-nodes-base.splitOut",
"position": [
2340,
280
],
"parameters": {
"options": {},
"fieldToSplitOut": "items"
},
"typeVersion": 1
},
{
"id": "7adbf13a-efeb-4acd-897a-a107ef29955f",
"name": "Edit Fields5",
"type": "n8n-nodes-base.set",
"position": [
2580,
280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "15852b78-13ef-49f3-a695-700ba72282d9",
"name": "tittle",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "34b819c3-5a0d-4a2a-b693-f02ad480b528",
"name": "type",
"type": "string",
"value": "={{ $json.type }}"
},
{
"id": "33e0aaeb-8351-4a50-bae0-2432f2e02d26",
"name": "discription",
"type": "string",
"value": "={{ $json.expanded_element[0].description }}"
},
{
"id": "15c90345-0326-474a-a667-2132ddcd0164",
"name": "url",
"type": "string",
"value": "={{ $json.expanded_element[0].url }}"
},
{
"id": "643bfc5a-1db3-410f-b0c4-4207c2ba8435",
"name": "domain name",
"type": "string",
"value": "={{ $json.expanded_element[0].domain }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b03df472-0028-433a-a291-0b02e6d6b27a",
"name": "Edit Fields2",
"type": "n8n-nodes-base.set",
"position": [
2100,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "9b6c6833-9a17-40a4-97cd-8c28168bb9c3",
"name": "keyword",
"type": "string",
"value": "={{ $('Switch').item.json.keyword }}"
},
{
"id": "12caa5c0-3ffb-4bed-b2af-f139dbf15a9c",
"name": "search intent",
"type": "string",
"value": "={{ $json.search_intent_info.main_intent }}"
},
{
"id": "aef9fa8d-dd76-4d16-a2a6-708fb5e9ab43",
"name": "suggested keyword",
"type": "string",
"value": "= {{ $json.keyword }}"
},
{
"id": "5d33a8a9-778b-40a6-9efb-acb8204c58fe",
"name": "last update",
"type": "string",
"value": "= {{ $json.keyword_info.last_updated_time }}"
},
{
"id": "129ac304-872b-4772-bfd1-6382e6b8b71d",
"name": "search volume",
"type": "string",
"value": "={{ $json.keyword_info.search_volume }} "
},
{
"id": "1cf80f1f-dcec-4452-baa5-c5580d8aad24",
"name": "CPC",
"type": "string",
"value": "= {{ $json.keyword_info.cpc }}"
},
{
"id": "de3fe02d-8f6b-4b52-807a-ca727f089a32",
"name": "compitition",
"type": "string",
"value": "= {{ $json.keyword_info.competition }}"
},
{
"id": "1663de4d-4a53-4a0e-96bd-c437ad888e41",
"name": "type",
"type": "string",
"value": "suggested_keyword"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3852d7d0-238b-4799-879e-43414387233c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-360
],
"parameters": {
"color": 5,
"height": 460,
"content": "## Get keyword\nGet keyword, location, language and operation from user."
},
"typeVersion": 1
},
{
"id": "228fe28f-4fcb-41c5-926d-d2d64fd6b8a0",
"name": "Add operation to main sheet in Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
540,
-160
],
"parameters": {
"columns": {
"value": {
"Time": "={{ $('On form submission').item.json.submittedAt }}",
"keyword": "={{ $json.keyword }}",
"operation": "={{ $json.operation }}",
"language_name": "={{ $json.language_name }}",
"location_name": "={{ $json.location_name }}"
},
"schema": [
{
"id": "operation",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "operation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "location_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "language_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "language_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit#gid=0",
"cachedResultName": "summary"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "758a8e17-34da-482b-a678-e16b9d4a28c3",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-360
],
"parameters": {
"color": 5,
"height": 460,
"content": "## Switch\nChoose what operation to do. It gets the operation from user."
},
"typeVersion": 1
},
{
"id": "b7bc7d6a-31f3-4689-ac6a-589afae253fc",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1240,
"content": "## Create a sheet\nIt creates a sheet that its title is {keyword}{operation}.\nfr every operation it create a sheet.\n"
},
"typeVersion": 1
},
{
"id": "b728b3a8-72bf-4950-a74f-45a5567a4fda",
"name": "related keyword sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1220,
-560
],
"parameters": {
"title": "={{ $json.keyword }} [{{ $json.operation }}]",
"options": {
"tabColor": "#9426F4"
},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "28eccb35-34b2-4c7b-8d36-456a5577843d",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1460,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1240,
"content": "## DataforSEO API Request\nSend request to DataforSeo with operation, keyword, location_name and language_name.\n"
},
"typeVersion": 1
},
{
"id": "fae6c44e-7069-4278-b756-14f859847574",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1240,
"content": "## Get the Data from API call\nIt gets the data that needed from last node and ignores every other fields that we don't need.\n"
},
"typeVersion": 1
},
{
"id": "35249966-22b2-4123-9806-055bbb2f6bdd",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2280,
-760
],
"parameters": {
"color": 5,
"width": 260,
"height": 1000,
"content": "## Append data to sheet\nThis node append the data to the sheet created in 'Create a sheet' node.\n"
},
"typeVersion": 1
},
{
"id": "42475196-e399-4bc2-b258-fbd26daf545c",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2740,
120
],
"parameters": {
"color": 5,
"width": 260,
"height": 420,
"content": "## Append data to sheet\nThis node append the data to the sheet created in 'Create a sheet' node.\n"
},
"typeVersion": 1
},
{
"id": "0d121e1e-19f1-4574-87de-4b22c8d15026",
"name": "Filter people also ask",
"type": "n8n-nodes-base.filter",
"position": [
2100,
280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "50240059-95d3-4242-a151-68f70a13819f",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.type }}",
"rightValue": "people_also_ask"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6ba0d98b-6115-48e4-8550-9554c737f869",
"name": "Check If fields not empty",
"type": "n8n-nodes-base.if",
"position": [
60,
-160
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c002e63c-5c1a-4487-9698-8debcdc55348",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.keyword }}",
"rightValue": ""
},
{
"id": "9d012e48-3243-4f9d-8dc6-c66d90c6b3e3",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.location_name }}",
"rightValue": ""
},
{
"id": "63d75301-d0df-4870-8d28-447264c7317f",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.language_name }}",
"rightValue": ""
},
{
"id": "1fab5942-ef6f-437d-9127-11d14d594644",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Operation }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e07e4b2a-ada3-41ce-baf5-faa8f3467720",
"name": "Add to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
-560
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('related keyword sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "2df32bdd-390c-4e2d-8353-8a76acaf93a2",
"name": "Add to Sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
-360
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('keyword suggestion sheet').item.json.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ndz3PLihy9k96_S-uvjUGK9f9TQulIwtn1-mo53D2LQ/edit?usp=drivesdk",
"cachedResultName": "SEO Related Keyword Finder\ud83d\ude80 | n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "d65cacaa-71c7-4bc1-8e7c-fcc44606837b",
"name": "Add to Sheet2",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
-160
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "related keyword",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "related keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword difficulty",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "keyword difficulty",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "search intent",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "search intent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last update",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last update",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SERP Analysis",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "SERP Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "search volume",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "search volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "compitition",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "compitition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleApihttpBasicAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Overview 🌐
Source: https://n8n.io/workflows/10137/ — 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.
Splitout Code. Uses splitOut, httpRequest, googleSheets, stickyNote. Event-driven trigger; 36 nodes.
HTTP Request, Google Sheets, Form Trigger +1
This n8n workflow is designed for Customer Success Managers (CSM), marketers, sales teams, and data administrators who need to automate the process of uploading and processing CSV data in HubSpot. It
HTTP Request, Google Sheets, Form Trigger +1
The SEO On Page API is a powerful tool for keyword research, competitor analysis, backlink insights, and overall SEO optimization. With multiple endpoints, you can instantly gather actionable SEO data
Form Trigger, HTTP Request, Google Sheets
Demonstration video
Form Trigger, HTTP Request, Google Sheets
Description: The Spotify Music Downloader is an automation flow that allows users to easily download music from Spotify tracks. By leveraging the powerful Spotify Downloader API, the flow downloads Sp
Form Trigger, HTTP Request, Google Drive +1