SEO-Keyword-Recherche
Experte
Dies ist ein Content Creation, Multimodal AI-Bereich Automatisierungsworkflow mit 56 Nodes. Hauptsächlich werden Code, Merge, HttpRequest, GoogleSheets, ManualTrigger und andere Nodes verwendet. Vollautomatische Blog-Erstellung mit GPT-4 und Veröffentlichung in WordPress über Google Sheets
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (56)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "pVWoKnxJXiEf89Jw",
"meta": {
"instanceId": "50618e78906785f75ac298c8b090bb3bd6406a17352da71ebb8b85e6df90fa3a",
"templateCredsSetupCompleted": true
},
"name": "SEO Keyword Reseach",
"tags": [],
"nodes": [
{
"id": "84bcbf6d-65cd-45ba-904e-235d62bf2d23",
"name": "Manueller 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": {
"url": "https://api.dataforseo.com/v3/keywords_data/google_ads/search_volume/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keywords\": [\"{{ $json.Keywords }}\"]\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "98773b36-8135-4f8f-bcf3-746fbbae8561",
"name": "HTTP Google SERP",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
560
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/organic/live/advanced",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keyword\": \"{{ $json.Keywords }}\",\n \"device\": \"desktop\",\n \"depth\": 100,\n \"parse\": true\n}]\n\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "36a176ab-b2ed-4292-8fa6-1c17a66da10a",
"name": "HTTP Keyword Suggestions",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
2020
],
"parameters": {
"url": "https://api.dataforseo.com/v3/keywords_data/google_ads/keywords_for_keywords/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keywords\": [\"{{ $json.Keywords }}\"]\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "3c028d1f-c767-4039-8b49-36c146be6ee3",
"name": "HTTP Screenshot",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
260
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/screenshot",
"method": "POST",
"options": {},
"jsonBody": "=[{\"task_id\":\"{{ $json[\"tasks\"][0][\"id\"] }}\"}]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "c92d3111-f5c9-4ce0-849a-5bd154fbc589",
"name": "HTTP Local Finder",
"type": "n8n-nodes-base.httpRequest",
"position": [
-100,
1720
],
"parameters": {
"url": "https://api.dataforseo.com/v3/serp/google/local_finder/live/advanced",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keyword\": \"{{ $json[\"tasks\"][0][\"data\"][\"keyword\"] }}\"\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "08bfbe4b-85b7-4cf8-9977-e0665ebb7b32",
"name": "HTTP Backlinks",
"type": "n8n-nodes-base.httpRequest",
"position": [
140,
1460
],
"parameters": {
"url": "https://api.dataforseo.com/v3/backlinks/summary/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\"target\":\"{{ $json.top_domain }}\"}]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
}
},
"typeVersion": 4
},
{
"id": "280bea71-108c-4b57-ae13-77d08d2baba4",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1760,
520
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1966727209,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1966727209",
"cachedResultName": "Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "da596be3-6d45-446b-8e81-252647b62fff",
"name": "Snippet1 extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-100,
-20
],
"parameters": {
"jsCode": "const result = $json[\"tasks\"]?.[0]?.result?.[0] || {};\nconst output = [];\n\nlet hasSnippet = false;\n\nif (result.items) {\n for (const item of result.items) {\n if (item.type === 'featured_snippet') {\n output.push({ json: {\n Keyword: result.keyword,\n \"Snippet Title\": item.title,\n URL: item.url,\n Domain: item.domain,\n \"Snippet Text\": item.description ? item.description.substring(0, 200) : ''\n }});\n hasSnippet = true;\n break;\n }\n }\n}\n\nif (!hasSnippet) {\n output.push({ json: {\n Keyword: result.keyword,\n \"Snippet Title\": '',\n URL: '',\n Domain: '',\n \"Snippet Text\": ''\n }});\n}\n\nreturn output;\n\n"
},
"typeVersion": 2
},
{
"id": "1517df19-4d40-4809-895e-33250ed4f5a7",
"name": "SERP-Features1 erkennen",
"type": "n8n-nodes-base.code",
"position": [
-100,
560
],
"parameters": {
"jsCode": "const result = $json[\"tasks\"]?.[0]?.result?.[0];\nconst features = {\n Keyword: result?.keyword || \"\",\n Featured_Snippet: false,\n People_Also_Ask: false,\n Local_Pack: false,\n Video: false,\n Image_Pack: false,\n Top_Stories: false,\n Knowledge_Panel: false,\n Shopping_Ads: false\n};\n\nif (result?.items) {\n for (const item of result.items) {\n const type = item.type?.toLowerCase();\n if (type.includes(\"featured_snippet\")) features.Featured_Snippet = true;\n if (type.includes(\"people_also_ask\")) features.People_Also_Ask = true;\n if (type.includes(\"local\") || type.includes(\"map\")) features.Local_Pack = true;\n if (type.includes(\"video\")) features.Video = true;\n if (type.includes(\"image\")) features.Image_Pack = true;\n if (type.includes(\"top_stories\") || type.includes(\"news\")) features.Top_Stories = true;\n if (type.includes(\"knowledge\")) features.Knowledge_Panel = true;\n if (type.includes(\"shopping\")) features.Shopping_Ads = true;\n }\n}\n\nreturn [{ json: features }];"
},
"typeVersion": 2
},
{
"id": "d8ee89e5-cede-4bcf-ae5c-a907a8e96abb",
"name": "Organische Ergebnisse extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-100,
840
],
"parameters": {
"jsCode": "const result = $json[\"tasks\"][0][\"result\"][0];\nconst output = [];\n\nif (result.items) {\n for (const item of result.items) {\n if (item.type === 'organic') {\n output.push({\n json: {\n Keyword: result.keyword,\n Rank: item.rank_group,\n Position: item.rank_absolute,\n Title: item.title || '',\n URL: item.url || '',\n Domain: item.domain || '',\n Breadcrumb: item.breadcrumb || '',\n Snippet: item.description || ''\n }\n });\n }\n }\n}\n\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "a5a0b982-ab17-4df8-a2ee-10444d29c1b8",
"name": "Top-Domain extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-100,
1460
],
"parameters": {
"jsCode": "const data = $json[\"tasks\"][0][\"result\"][0];\nlet topDomain = null;\nif (data.items) {\n for (const item of data.items) {\n if (item.type === 'organic') {\n topDomain = item.domain;\n break;\n }\n }\n}\nreturn {\n json: {\n Keyword: data.keyword,\n top_domain: topDomain\n }\n};"
},
"typeVersion": 2
},
{
"id": "fd00e659-67aa-4eb3-99e6-9cc5834a8323",
"name": "Lokale Ergebnisse extrahieren",
"type": "n8n-nodes-base.code",
"position": [
140,
1720
],
"parameters": {
"jsCode": "const result = $json.tasks?.[0]?.result?.[0];\nconst output = [];\nif (result && result.items) {\n for (const biz of result.items) {\n if (biz.type === 'local_pack' || biz.type === 'map') {\n output.push({ json: {\n Keyword: result.keyword || ($json.Keyword || ''),\n \"Business Name\": biz.title || '',\n Details: biz.description || ''\n } });\n }\n }\n}\nreturn output;"
},
"typeVersion": 2
},
{
"id": "7eee3574-85d4-42a1-a1fb-5b09bdcb6e0d",
"name": "Vorschläge extrahieren",
"type": "n8n-nodes-base.code",
"position": [
140,
2020
],
"parameters": {
"jsCode": "const tasks = $json.tasks;\nconst output = [];\n\nif (tasks && tasks[0] && tasks[0].result) {\n const suggestions = tasks[0].result;\n const keyword = tasks[0].data.keywords ? tasks[0].data.keywords[0] : ($json.Keyword || '');\n\n for (const sug of suggestions) {\n output.push({\n Keyword: keyword,\n \"Suggested Keyword\": sug.keyword,\n \"Search Volume\": sug.search_volume || 0,\n CPC: sug.cpc || 0,\n Competition: sug.competition || sug.competition_level || ''\n });\n }\n}\n\nreturn output;"
},
"typeVersion": 2
},
{
"id": "d18e848b-8b59-430e-a84d-80dcd6cb7f58",
"name": "HTTP Related Keywords",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
-340
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/related_keywords/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keyword\": \"{{ $json.Keywords }}\",\n \"depth\": 1\n}]\n\n\n\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "cc00a7a4-4007-4ea9-bf5d-e167618ae6b9",
"name": "HTTP Keyword Ideas",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
-60
],
"parameters": {
"url": "https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_ideas/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\n \"location_name\": \"United States\",\n \"language_code\": \"en\",\n \"keywords\": [\"{{ $json.Keywords }}\"],\n \"limit\": 100\n}]\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "b92b2821-8925-461d-98c0-35a634c1ffe5",
"name": "HTTP Subtopics",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1440,
260
],
"parameters": {
"url": "https://api.dataforseo.com/v3/content_generation/generate_sub_topics/live",
"method": "POST",
"options": {},
"jsonBody": "=[{\"topic\":\"{{ $json.Keywords }}\",\"max_sub_topics\":10}]",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "ug4PwsfFTQ5QkOgr",
"name": "DataforSEO2"
},
"httpHeaderAuth": {
"id": "ajaXUi36aQNTqEFh",
"name": "DataForSEO"
}
},
"typeVersion": 4
},
{
"id": "79a1ec2d-16a6-437c-9cf6-e8151595bc65",
"name": "Verwandte Keywords extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-1200,
-340
],
"parameters": {
"jsCode": "const items = $json.tasks[0].result[0].items || [];\nlet allRelated = [];\n\nitems.forEach(item => {\n const mainKeyword = item.keyword_data?.keyword || null;\n const related = item.related_keywords || [];\n\n related.forEach(keyword => {\n allRelated.push({\n MainKeyword: mainKeyword,\n RelatedKeyword: keyword\n });\n });\n});\n\nreturn allRelated;\n\n\n\n\n"
},
"typeVersion": 2
},
{
"id": "8aafd19c-6a17-4379-9df9-f1aa6e8ba03a",
"name": "Unterthemen extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-1200,
260
],
"parameters": {
"jsCode": "const topic = $input.first().json.tasks[0].data.topic || '';\nconst subs = $json.tasks[0].result[0].sub_topics || [];\n\nreturn subs.map((s, idx) => ({\n Keyword: topic,\n Subtopic: s,\n Rank: idx + 1\n}));\n"
},
"typeVersion": 2
},
{
"id": "03fcd370-1d5b-4eda-bf6a-e29ea9418bae",
"name": "Keyword-Ideen extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-1200,
-60
],
"parameters": {
"jsCode": "const kw = $json.tasks[0].result[0].seed_keywords?.[0] || $json.Keyword || '';\nconst items = $json.tasks[0].result || [];\nconst out = [];\n\nitems.forEach(res => {\n (res.items || []).forEach(i => {\n out.push({\n Keyword: kw,\n IdeaKeyword: i.keyword,\n SV: i.search_volume || null,\n CPC: i.cpc || null,\n Competition: i.competition || null\n });\n });\n});\n\nreturn out;\n"
},
"typeVersion": 2
},
{
"id": "993936fb-803c-40ff-8f8c-dabfa68a7b45",
"name": "Volume Trend extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-100,
-360
],
"parameters": {
"jsCode": "const keyword = $json.tasks?.[0]?.result?.[0]?.keyword || '';\nconst monthly = $json.tasks?.[0]?.result?.[0]?.monthly_searches || [];\nconst defaultCpc = $json.tasks?.[0]?.result?.[0]?.cpc || 0;\n\nreturn monthly.map(m => ({\n Keyword: keyword,\n Year: m.year,\n Month: m.month,\n Searches: m.search_volume,\n CPC: m.cpc !== undefined ? m.cpc : defaultCpc\n}));\n"
},
"typeVersion": 2
},
{
"id": "5760dd9e-efce-4e2c-8732-1c851d99f507",
"name": "PAA/PAS extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-100,
1140
],
"parameters": {
"jsCode": "const kw = $json.keyword || $json.Keyword || ($json.tasks && $json.tasks[0].keyword) || $json.tasks?.[0]?.result?.[0]?.keyword;\nconst topItems = $json.tasks?.[0]?.result?.[0]?.items || [];\nconst out = [];\n\ntopItems.forEach(section => {\n // ✅ PAS: People Also Search op hoofdniveau\n if (section.type === 'people_also_search_element') {\n out.push({\n Type: \"PAS\",\n Keyword: kw,\n Related: section.keyword,\n Rank: section.rank_group || section.rank\n });\n }\n\n // ✅ Geneste PAA: People Also Ask elementen\n if (Array.isArray(section.items)) {\n section.items.forEach(i => {\n if (i.type === 'people_also_ask_element') {\n out.push({\n Type: \"PAA\",\n Keyword: kw,\n Question: i.title\n });\n }\n });\n }\n});\n\nreturn out;\n\n"
},
"typeVersion": 2
},
{
"id": "2fc0d43c-c493-4f80-b9a3-9681ee834af5",
"name": "Übersicht",
"type": "n8n-nodes-base.googleSheets",
"position": [
1380,
700
],
"parameters": {
"columns": {
"value": {
"CPC": "={{ $json.Average_CPC }}",
"#PAA": "={{ $json.PAA_Question }}",
"#Local": "={{ $json.Local_Business_Name }}",
"Keyword": "={{ $json.Keyword }}",
"Competition": "={{ $json.Average_Competition }}",
"Has Snippet": "={{ $json.Has_Snippet }}",
"SERP Features": "={{ $json.SERP_Features }}",
"Screenshot URL": "={{ $json.Screenshot_URL }}",
"Avg Search Volume": "={{ $json.Avg_Search_Volume }}",
"Referring Domains": "={{ $json.Referring_Domains }}",
"Top Organic Domains": "={{ $json.Top_Organic_Domain }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Avg Search Volume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Avg Search Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Has Snippet",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Has Snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SERP Features",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SERP Features",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Top Organic Domains",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Top Organic Domains",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "#PAA",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "#PAA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "#Local",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "#Local",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Referring Domains",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Referring Domains",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Screenshot URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Screenshot URL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1357600484,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1357600484",
"cachedResultName": "Overview"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "3f1ec549-8c2e-4e34-8cfa-0dc35937c5d1",
"name": "Search Volume Trend",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
-360
],
"parameters": {
"columns": {
"value": {
"CPC": "={{ $json.CPC }}",
"Year": "={{ $json.Year }}",
"Month": "={{ $json.Month }}",
"Keyword": "={{ $json.Keyword }}",
"Searches": "={{ $json.Searches }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Year",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Month",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Month",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Searches",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Searches",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"options": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 282690701,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=282690701",
"cachedResultName": "Search Volume Trend"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "6b776b8a-a12d-4e8a-aa74-3a2ad2a2f86c",
"name": "Featured Snippets",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
-20
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.URL }}",
"Domain": "={{ $json.Domain }}",
"Keyword": "={{ $json.Keyword }}",
"Snippet Text": "={{ $json['Snippet Text'] }}",
"Snippet Title": "={{ $json['Snippet Title'] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Snippet Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Snippet Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Snippet Text",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Snippet Text",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"options": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1313102974,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1313102974",
"cachedResultName": "Featured Snippets"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "c2e9953d-f96e-4e68-89a1-b01df6b5facb",
"name": "SERP Features",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
560
],
"parameters": {
"columns": {
"value": {
"Video": "={{ $json.Video }}",
"Keyword": "={{ $json.Keyword }}",
"Image_Pack": "={{ $json.Image_Pack }}",
"Local_Pack": "={{ $json.Local_Pack }}",
"Top_Stories": "={{ $json.Top_Stories }}",
"Shopping_Ads": "={{ $json.Shopping_Ads }}",
"Knowledge_Panel": "={{ $json.Knowledge_Panel }}",
"People_Also_Ask": "={{ $json.People_Also_Ask }}",
"Featured_Snippet": "={{ $json.Featured_Snippet }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Featured_Snippet",
"type": "string",
"display": true,
"required": false,
"displayName": "Featured_Snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "People_Also_Ask",
"type": "string",
"display": true,
"required": false,
"displayName": "People_Also_Ask",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Local_Pack",
"type": "string",
"display": true,
"required": false,
"displayName": "Local_Pack",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "string",
"display": true,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image_Pack",
"type": "string",
"display": true,
"required": false,
"displayName": "Image_Pack",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Top_Stories",
"type": "string",
"display": true,
"required": false,
"displayName": "Top_Stories",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Knowledge_Panel",
"type": "string",
"display": true,
"required": false,
"displayName": "Knowledge_Panel",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shopping_Ads",
"type": "string",
"display": true,
"required": false,
"displayName": "Shopping_Ads",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1323889712,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1323889712",
"cachedResultName": "SERP Features"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "46155321-d041-495f-9742-73129c9d3d80",
"name": "PAA",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
1140
],
"parameters": {
"columns": {
"value": {
"Type": "={{ $json.Type }}",
"Keyword": "={{ $json.Keyword }}",
"Question": "={{ $json.Question }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Question",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Question",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 677237490,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=677237490",
"cachedResultName": "PAA"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "f668078a-529d-4d61-9d88-f536e446a016",
"name": "Organic Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
840
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.URL }}",
"Rank": "={{ $json.Rank }}",
"Title": "={{ $json.Title }}",
"Domain": "={{ $json.Domain }}",
"Keyword": "={{ $json.Keyword }}",
"Snippet": "={{ $json.Snippet }}",
"Position": "={{ $json.Position }}",
"Breadcrumb": "={{ $json.Breadcrumb }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rank",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Rank",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Breadcrumb",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Breadcrumb",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Snippet",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1797280058,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1797280058",
"cachedResultName": "Organic Results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "74a88edf-29eb-4aad-83bf-c942dde1da56",
"name": "Local Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
1720
],
"parameters": {
"columns": {
"value": {
"Details": "={{ $json.Details }}",
"Keyword": "={{ $json.Keyword }}",
"Business Name": "={{ $json['Business Name'] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Business Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Business Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Details",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Details",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"options": [],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 550769217,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=550769217",
"cachedResultName": "Local Results"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "de5a423e-57dd-4ccf-86c1-14d07853bfd6",
"name": "Suggestions",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
2020
],
"parameters": {
"columns": {
"value": {
"CPC": "={{ $json.CPC }}",
"Keyword": "={{ $json.Keyword }}",
"Competition": "={{ $json.Competition }}",
"Search Volume": "={{ $json['Search Volume'] }}",
"Suggested Keyword": "={{ $json['Suggested Keyword'] }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suggested Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Suggested Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Search Volume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Search Volume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1378869548,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1378869548",
"cachedResultName": "Suggestions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "aa9378c9-f9b7-42fc-8f1f-8502770ef75a",
"name": "Keywords Ideas",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
-60
],
"parameters": {
"columns": {
"value": {
"SV": "={{ $json.SV }}",
"CPC": "={{ $json.CPC }}",
"Keyword": "={{ $json.Keyword }}",
"Competition": "={{ $json.Competition }}",
"IdeaKeyword": "={{ $json.IdeaKeyword }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IdeaKeyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "IdeaKeyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SV",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SV",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CPC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CPC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Competition",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 170448196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=170448196",
"cachedResultName": "Keyword Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "314d309e-b3d0-46b6-a03b-06a33edec4d7",
"name": "Subtopics",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
260
],
"parameters": {
"columns": {
"value": {
"Rank": "={{ $json.Rank }}",
"Keyword": "={{ $json.Keyword }}",
"Subtopic": "={{ $json.Subtopic }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subtopic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Subtopic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rank",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Rank",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1278595222,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1278595222",
"cachedResultName": "Subtopics"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "303b73bb-db1c-4f85-8095-74fff312eca8",
"name": "Backlinks",
"type": "n8n-nodes-base.googleSheets",
"position": [
380,
1460
],
"parameters": {
"columns": {
"value": {
"Domain": "={{ $('Extract Top Domain').item.json.top_domain }}",
"Country": "={{ $json.tasks[0].result[0].info.country }}",
"Keyword": "={{ $('Extract Top Domain').item.json.Keyword }}",
"Platform": "={{ $json.tasks[0].result[0].info.platform_type[0] }}",
"Backlinks": "={{ $json.tasks[0].result[0].backlinks }}",
"Referring Domains": "={{ $json.tasks[0].result[0].referring_main_domains }}",
"Backlinks Spam Score": "={{ $json.tasks[0].result[0].backlinks_spam_score }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Backlinks",
"type": "string",
"display": true,
"required": false,
"displayName": "Backlinks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Referring Domains",
"type": "string",
"display": true,
"required": false,
"displayName": "Referring Domains",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Backlinks Spam Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Backlinks Spam Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 260185468,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=260185468",
"cachedResultName": "Backlinks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "5d2c6aa2-82a0-4643-8c14-67e6895635e4",
"name": "Related Keywords",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
-340
],
"parameters": {
"columns": {
"value": {
"Main Keyword": "={{ $json.MainKeyword }}",
"Related Keyword": "={{ $json.RelatedKeyword }}"
},
"schema": [
{
"id": "Main Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Main Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Related Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Related Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1669673679,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit#gid=1669673679",
"cachedResultName": "Related Keywords"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1L5jRkI-Z0BqHfcxyBj5l5BS97drTkOnBPJLMD5bzfbQ/edit?usp=drivesdk",
"cachedResultName": "Keyword Research"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ugpyltO1vW4sTXNh",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "71f7cfd2-d7b5-4f03-aa8c-533ddf204e54",
"name": "Durchschnittliches Suchvolumen und CPC",
"type": "n8n-nodes-base.code",
"position": [
340,
-360
],
"parameters": {
"jsCode": "const items = $input.all();\n\nlet totalSearches = 0;\nlet totalCPC = 0;\nlet cpcCount = 0;\n\nfor (const item of items) {\n const searches = item.json.Searches || 0;\n const cpc = item.json.CPC;\n\n totalSearches += searches;\n\n if (typeof cpc === 'number') {\n totalCPC += cpc;\n cpcCount++;\n }\n}\n\nconst avgSearches = totalSearches / items.length;\nconst avgCPC = cpcCount > 0 ? totalCPC / cpcCount : null;\n\nreturn [\n {\n json: {\n Keyword: items[0].json.Keyword,\n AverageSearchVolume: Math.round(avgSearches),\n AverageCPC: avgCPC !== null ? Math.round(avgCPC * 100) / 100 : null,\n DataPoints: items.length\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "076789d9-b429-45d6-a2e7-d16572ff998e",
"name": "Ja oder Nein",
"type": "n8n-nodes-base.code",
"position": [
340,
-20
],
"parameters": {
"jsCode": "const output = [];\n\nfor (const item of $input.all()) {\n const hasSnippet = item.json[\"Snippet Title\"] && item.json[\"Snippet Title\"].trim() !== \"\";\n \n output.push({\n json: {\n Keyword: item.json.Keyword,\n HasSnippet: hasSnippet ? \"Yes\" : \"No\"\n }\n });\n}\n\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "b8ded190-d8ce-4a96-91ba-0146174b6027",
"name": "Welche Features existieren",
"type": "n8n-nodes-base.code",
"position": [
360,
560
],
"parameters": {
"jsCode": "const item = $input.first().json;\n\nconst serpFeatures = [\n 'Featured_Snippet',\n 'People_Also_Ask',\n 'Local_Pack',\n 'Video',\n 'Image_Pack',\n 'Top_Stories',\n 'Knowledge_Panel',\n 'Shopping_Ads'\n];\n\nconst found = serpFeatures.filter(key => item[key]);\n\nreturn [{\n json: {\n Keyword: item.Keyword,\n Present_SERP_Features: found.join(', ') || 'None'\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "f201fdcc-3d35-425c-894d-4f257a18b42c",
"name": "Durchschnittlicher Wettbewerb",
"type": "n8n-nodes-base.code",
"position": [
540,
2020
],
"parameters": {
"jsCode": "const items = $input.all();\nlet total = 0;\nlet count = 0;\n\nconst mapCompetition = {\n LOW: 1,\n MEDIUM: 2,\n HIGH: 3\n};\n\nlet keyword = items[0]?.json?.Keyword || \"UNKNOWN\";\n\nlet avgLabel = \"UNKNOWN\";\n\nfor (const item of items) {\n const raw = item.json.Competition?.toUpperCase();\n const value = mapCompetition[raw];\n if (value) {\n total += value;\n count++;\n }\n}\n\nif (count > 0) {\n const avg = total / count;\n if (avg < 1.5) {\n avgLabel = \"LOW\";\n } else if (avg < 2.5) {\n avgLabel = \"MEDIUM\";\n } else {\n avgLabel = \"HIGH\";\n }\n}\n\nreturn [{\n json: {\n Keyword: keyword,\n Average_Competition: avgLabel\n }\n}];\n\n\n"
},
"typeVersion": 2
},
{
"id": "77720ece-04ae-4d2f-bcd1-254dc0d75cac",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
380,
1140
],
"parameters": {
"jsCode": "const items = $input.all();\n\nif (items.length === 0) {\n return [];\n}\n\n// Neem alleen de eerste item (aangenomen dat het type PAA is)\nconst first = items.find(i => i.json.Type === 'PAA');\n\nreturn [{\n json: {\n Keyword: first?.json.Keyword || \"UNKNOWN\",\n Question: first?.json.Question || \"No question found\"\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "22d63f16-462a-45a1-be11-ad0e727ce2c5",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
540,
1720
],
"parameters": {
"jsCode": "const items = $input.all();\n\nif (items.length === 0) {\n return [];\n}\n\n// Neem alleen de eerste relevante entry\nconst first = items[0].json;\n\nreturn [{\n json: {\n Keyword: first.Keyword || \"UNKNOWN\",\n Business_Name: first[\"Business Name\"] || \"No name found\",\n Details: first.Details || \"No details\"\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
1020,
580
],
"parameters": {
"numberInputs": 8
},
"typeVersion": 3.1
},
{
"id": "f6018e44-9523-4431-b8c0-49d0f22b1170",
"name": "Daten restrukturieren",
"type": "n8n-nodes-base.code",
"position": [
1200,
700
],
"parameters": {
"jsCode": "const inputs = $input.all();\nconst combined = {};\n\nfor (const item of inputs) {\n Object.assign(combined, item.json);\n}\n\nreturn [{\n json: {\n Keyword: combined.Keyword || null,\n Avg_Search_Volume: combined.AverageSearchVolume || null,\n Average_CPC: combined.AverageCPC || null,\n DataPoints: combined.DataPoints || null,\n Has_Snippet: combined.HasSnippet || null,\n SERP_Features: combined.Present_SERP_Features || null,\n Top_Organic_Domain: combined.Domain || null,\n PAA_Question: combined.Question || null,\n Screenshot_URL: combined.tasks?.[0]?.result?.[0]?.url || null,\n Backlinks: combined.Backlinks || null,\n Referring_Domains: combined['Referring Domains'] || null,\n Spam_Score: combined['Backlinks Spam Score'] || null,\n Country: combined.Country || null,\n Platform: combined.Platform || null,\n Local_Business_Name: combined.Business_Name || null,\n Local_Details: combined.Details || null,\n Average_Competition: combined.Average_Competition || null\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "27efc4e8-ef6f-4244-b5e8-f89ab5d1df18",
"name": "Notiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
460
],
"parameters": {
"color": 4,
"width": 440,
"height": 220,
"content": "## Getting Keyword\n"
},
"typeVersion": 1
},
{
"id": "b548d12b-16c5-4bde-9c62-096287837150",
"name": "Notiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
460
],
"parameters": {
"color": 2,
"width": 820,
"height": 580,
"content": "## Creating Overview\n"
},
"typeVersion": 1
},
{
"id": "ecd8d090-1799-44c2-8c85-1385f64b0fb5",
"name": "Notiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-440
],
"parameters": {
"width": 1340,
"height": 280,
"content": "# Get Avertage Search Volume And CPC\n"
},
"typeVersion": 1
},
{
"id": "98dba987-562e-442f-aa6f-f1c9294ec612",
"name": "Notiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
-140
],
"parameters": {
"color": 3,
"width": 1340,
"height": 280,
"content": "# Extract Featured Snippet\n\n"
},
"typeVersion": 1
},
{
"id": "91ddca1e-daec-45f1-b09f-7d226da88a63",
"name": "Notiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
160
],
"parameters": {
"color": 4,
"width": 1340,
"height": 280,
"content": "# Get Page Screenshot\n"
},
"typeVersion": 1
},
{
"id": "de71b3cf-7084-4b6c-abb0-022fd7c6ddd8",
"name": "Notiz5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
460
],
"parameters": {
"color": 5,
"width": 1340,
"height": 280,
"content": "# Serp Research\n"
},
"typeVersion": 1
},
{
"id": "4515bcd9-2608-4860-bf01-f915fd7e7f7f",
"name": "Notiz6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
760
],
"parameters": {
"color": 6,
"width": 1340,
"height": 280,
"content": "# Organic Results\n"
},
"typeVersion": 1
},
{
"id": "678b247c-03af-4e58-99cf-23c59513439a",
"name": "Notiz7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1060
],
"parameters": {
"color": 5,
"width": 1340,
"height": 280,
"content": "# People Also Ask"
},
"typeVersion": 1
},
{
"id": "a57fef70-86f6-41ab-8037-0e9646f89ad1",
"name": "Notiz8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1360
],
"parameters": {
"color": 2,
"width": 1340,
"height": 280,
"content": "# Get Top Domain Backlinks\n"
},
"typeVersion": 1
},
{
"id": "64afb7ed-87c0-450b-a3df-2922a5535861",
"name": "Notiz9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1660
],
"parameters": {
"color": 3,
"width": 1340,
"height": 280,
"content": "# Local Results"
},
"typeVersion": 1
},
{
"id": "b6893598-49e9-412a-8b34-710da958f3b4",
"name": "Notiz10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-660,
1960
],
"parameters": {
"color": 4,
"width": 1340,
"height": 280,
"content": "# Suggested Keywords\n"
},
"typeVersion": 1
},
{
"id": "b9e65c87-cc25-4334-a336-bb96f95ba1cf",
"name": "Notiz11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-440
],
"parameters": {
"color": 3,
"width": 1340,
"height": 280,
"content": "# Get Related Keywords\n"
},
"typeVersion": 1
},
{
"id": "eddd6ee1-1ecd-4096-b9ff-389ad7bca959",
"name": "Notiz12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-140
],
"parameters": {
"color": 5,
"width": 1340,
"height": 280,
"content": "# Get Keyword Ideas\n"
},
"typeVersion": 1
},
{
"id": "f1678692-0659-413a-abbf-4c088d90eef2",
"name": "Notiz13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
160
],
"parameters": {
"width": 1340,
"height": 280,
"content": "# Extract Subtopics\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1c604e43-4648-4d70-b151-c66e63cdaef4",
"connections": {
"46155321-d041-495f-9742-73129c9d3d80": {
"main": [
[
{
"node": "77720ece-04ae-4d2f-bcd1-254dc0d75cac",
"type": "main",
"index": 0
}
]
]
},
"77720ece-04ae-4d2f-bcd1-254dc0d75cac": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 4
}
]
]
},
"22d63f16-462a-45a1-be11-ad0e727ce2c5": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 6
}
]
]
},
"583dbab1-d03e-4cd3-bb6a-747bcba79c2b": {
"main": [
[
{
"node": "f6018e44-9523-4431-b8c0-49d0f22b1170",
"type": "main",
"index": 0
}
]
]
},
"303b73bb-db1c-4f85-8095-74fff312eca8": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 5
}
]
]
},
"314d309e-b3d0-46b6-a03b-06a33edec4d7": {
"main": [
[]
]
},
"076789d9-b429-45d6-a2e7-d16572ff998e": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 1
}
]
]
},
"de5a423e-57dd-4ccf-86c1-14d07853bfd6": {
"main": [
[
{
"node": "f201fdcc-3d35-425c-894d-4f257a18b42c",
"type": "main",
"index": 0
}
]
]
},
"fd00e659-67aa-4eb3-99e6-9cc5834a8323": {
"main": [
[
{
"node": "74a88edf-29eb-4aad-83bf-c942dde1da56",
"type": "main",
"index": 0
}
]
]
},
"280bea71-108c-4b57-ae13-77d08d2baba4": {
"main": [
[
{
"node": "98773b36-8135-4f8f-bcf3-746fbbae8561",
"type": "main",
"index": 0
},
{
"node": "3c7d7215-2ff0-44de-b407-ac537add7b81",
"type": "main",
"index": 0
},
{
"node": "36a176ab-b2ed-4292-8fa6-1c17a66da10a",
"type": "main",
"index": 0
},
{
"node": "d18e848b-8b59-430e-a84d-80dcd6cb7f58",
"type": "main",
"index": 0
},
{
"node": "cc00a7a4-4007-4ea9-bf5d-e167618ae6b9",
"type": "main",
"index": 0
},
{
"node": "b92b2821-8925-461d-98c0-35a634c1ffe5",
"type": "main",
"index": 0
}
]
]
},
"74a88edf-29eb-4aad-83bf-c942dde1da56": {
"main": [
[
{
"node": "22d63f16-462a-45a1-be11-ad0e727ce2c5",
"type": "main",
"index": 0
}
]
]
},
"c2e9953d-f96e-4e68-89a1-b01df6b5facb": {
"main": [
[
{
"node": "b8ded190-d8ce-4a96-91ba-0146174b6027",
"type": "main",
"index": 0
}
]
]
},
"08bfbe4b-85b7-4cf8-9977-e0665ebb7b32": {
"main": [
[
{
"node": "303b73bb-db1c-4f85-8095-74fff312eca8",
"type": "main",
"index": 0
}
]
]
},
"b92b2821-8925-461d-98c0-35a634c1ffe5": {
"main": [
[
{
"node": "8aafd19c-6a17-4379-9df9-f1aa6e8ba03a",
"type": "main",
"index": 0
}
]
]
},
"84bcbf6d-65cd-45ba-904e-235d62bf2d23": {
"main": [
[
{
"node": "280bea71-108c-4b57-ae13-77d08d2baba4",
"type": "main",
"index": 0
}
]
]
},
"d8ee89e5-cede-4bcf-ae5c-a907a8e96abb": {
"main": [
[
{
"node": "f668078a-529d-4d61-9d88-f536e446a016",
"type": "main",
"index": 0
}
]
]
},
"5760dd9e-efce-4e2c-8732-1c851d99f507": {
"main": [
[
{
"node": "46155321-d041-495f-9742-73129c9d3d80",
"type": "main",
"index": 0
}
]
]
},
"3c028d1f-c767-4039-8b49-36c146be6ee3": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 2
}
]
]
},
"f668078a-529d-4d61-9d88-f536e446a016": {
"main": [
[]
]
},
"da596be3-6d45-446b-8e81-252647b62fff": {
"main": [
[
{
"node": "6b776b8a-a12d-4e8a-aa74-3a2ad2a2f86c",
"type": "main",
"index": 0
}
]
]
},
"98773b36-8135-4f8f-bcf3-746fbbae8561": {
"main": [
[
{
"node": "3c028d1f-c767-4039-8b49-36c146be6ee3",
"type": "main",
"index": 0
},
{
"node": "c92d3111-f5c9-4ce0-849a-5bd154fbc589",
"type": "main",
"index": 0
},
{
"node": "d8ee89e5-cede-4bcf-ae5c-a907a8e96abb",
"type": "main",
"index": 0
},
{
"node": "da596be3-6d45-446b-8e81-252647b62fff",
"type": "main",
"index": 0
},
{
"node": "1517df19-4d40-4809-895e-33250ed4f5a7",
"type": "main",
"index": 0
},
{
"node": "a5a0b982-ab17-4df8-a2ee-10444d29c1b8",
"type": "main",
"index": 0
},
{
"node": "5760dd9e-efce-4e2c-8732-1c851d99f507",
"type": "main",
"index": 0
}
]
]
},
"5d2c6aa2-82a0-4643-8c14-67e6895635e4": {
"main": [
[]
]
},
"f6018e44-9523-4431-b8c0-49d0f22b1170": {
"main": [
[
{
"node": "2fc0d43c-c493-4f80-b9a3-9681ee834af5",
"type": "main",
"index": 0
}
]
]
},
"8aafd19c-6a17-4379-9df9-f1aa6e8ba03a": {
"main": [
[
{
"node": "314d309e-b3d0-46b6-a03b-06a33edec4d7",
"type": "main",
"index": 0
}
]
]
},
"6b776b8a-a12d-4e8a-aa74-3a2ad2a2f86c": {
"main": [
[
{
"node": "076789d9-b429-45d6-a2e7-d16572ff998e",
"type": "main",
"index": 0
}
]
]
},
"c92d3111-f5c9-4ce0-849a-5bd154fbc589": {
"main": [
[
{
"node": "fd00e659-67aa-4eb3-99e6-9cc5834a8323",
"type": "main",
"index": 0
}
]
]
},
"3c7d7215-2ff0-44de-b407-ac537add7b81": {
"main": [
[
{
"node": "993936fb-803c-40ff-8f8c-dabfa68a7b45",
"type": "main",
"index": 0
}
]
]
},
"a5a0b982-ab17-4df8-a2ee-10444d29c1b8": {
"main": [
[
{
"node": "08bfbe4b-85b7-4cf8-9977-e0665ebb7b32",
"type": "main",
"index": 0
}
]
]
},
"cc00a7a4-4007-4ea9-bf5d-e167618ae6b9": {
"main": [
[
{
"node": "03fcd370-1d5b-4eda-bf6a-e29ea9418bae",
"type": "main",
"index": 0
}
]
]
},
"f201fdcc-3d35-425c-894d-4f257a18b42c": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 7
}
]
]
},
"7eee3574-85d4-42a1-a1fb-5b09bdcb6e0d": {
"main": [
[
{
"node": "de5a423e-57dd-4ccf-86c1-14d07853bfd6",
"type": "main",
"index": 0
}
]
]
},
"3f1ec549-8c2e-4e34-8cfa-0dc35937c5d1": {
"main": [
[
{
"node": "71f7cfd2-d7b5-4f03-aa8c-533ddf204e54",
"type": "main",
"index": 0
}
]
]
},
"b8ded190-d8ce-4a96-91ba-0146174b6027": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 3
}
]
]
},
"993936fb-803c-40ff-8f8c-dabfa68a7b45": {
"main": [
[
{
"node": "3f1ec549-8c2e-4e34-8cfa-0dc35937c5d1",
"type": "main",
"index": 0
}
]
]
},
"1517df19-4d40-4809-895e-33250ed4f5a7": {
"main": [
[
{
"node": "c2e9953d-f96e-4e68-89a1-b01df6b5facb",
"type": "main",
"index": 0
}
]
]
},
"03fcd370-1d5b-4eda-bf6a-e29ea9418bae": {
"main": [
[
{
"node": "aa9378c9-f9b7-42fc-8f1f-8502770ef75a",
"type": "main",
"index": 0
}
]
]
},
"d18e848b-8b59-430e-a84d-80dcd6cb7f58": {
"main": [
[
{
"node": "79a1ec2d-16a6-437c-9cf6-e8151595bc65",
"type": "main",
"index": 0
}
]
]
},
"79a1ec2d-16a6-437c-9cf6-e8151595bc65": {
"main": [
[
{
"node": "5d2c6aa2-82a0-4643-8c14-67e6895635e4",
"type": "main",
"index": 0
}
]
]
},
"36a176ab-b2ed-4292-8fa6-1c17a66da10a": {
"main": [
[
{
"node": "7eee3574-85d4-42a1-a1fb-5b09bdcb6e0d",
"type": "main",
"index": 0
}
]
]
},
"71f7cfd2-d7b5-4f03-aa8c-533ddf204e54": {
"main": [
[
{
"node": "583dbab1-d03e-4cd3-bb6a-747bcba79c2b",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Content-Erstellung, Multimodales KI
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
YouTube-Videos in Blogbeiträge umwandeln
Erstelle Blogartikel aus YouTube-Videos mit Mistral AI und Gemini-Bildgenerierung
Set
Code
Merge
+
Set
Code
Merge
56 NodesZakwan
Content-Erstellung
Vorlage HP - Inhaltsplanung
Automatisierte Erstellung von Instagram-Inhaltsplanung mit GPT-4, Apify und Google Sheets
Set
Code
Wait
+
Set
Code
Wait
24 Nodeskeisha kalra
Content-Erstellung
Seitenarbeitsablauf vergleichen
Automatisches Generieren von Produktvergleichsseiten mit OpenAI und Google Sheets
Code
Merge
Http Request
+
Code
Merge
Http Request
50 NodesAbrar Sami
Content-Erstellung
Inhaltsaggregation
Automatisierte Veröffentlichung von Social-Media-Posts auf LinkedIn und X/Twitter aus Website-Artikeln mit Gemini AI
If
Set
Xml
+
If
Set
Xml
34 NodesVadim
Content-Erstellung
Automatisierte Erstellung von viralen Inhalten mit OpenAI, ElevenLabs und Fal.ai für Videos, Podcasts und ASMR
Automatisiere die Erstellung viralen Contents für Videos, Podcasts und ASMR mit OpenAI, ElevenLabs und Fal.ai
Set
Code
Wait
+
Set
Code
Wait
97 NodesAdam Crafts
Content-Erstellung
Virusartige Baby-Podcast-YouTube-Kurzvideos mit OpenAI, ElevenLabs und Hedra erstellen
Erstellen Sie virale Baby-Podcast-YouTube-Kurzvideos mit OpenAI, ElevenLabs und Hedra
Code
Wait
Merge
+
Code
Wait
Merge
38 NodesElectrabot
Content-Erstellung
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes56
Kategorie2
Node-Typen6
Autor
Zakwan
@zakwanzahidExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen