RapidAPI 및 Google Sheets를 사용한 자동화된 페이지 SEO 분석 및 기록
고급
이것은Market Research, Multimodal AI분야의자동화 워크플로우로, 33개의 노드를 포함합니다.주로 Set, Code, FormTrigger, HttpRequest, GoogleSheets 등의 노드를 사용하며. RapidAPI 및 Google Sheets를 사용한 자동화된 페이지 SEO 분석 및 기록
사전 요구사항
- •대상 API의 인증 정보가 필요할 수 있음
- •Google Sheets API 인증 정보
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "10211c28-4673-429a-ba74-e41f4897dc93",
"name": "폼 제출 시",
"type": "n8n-nodes-base.formTrigger",
"position": [
-540,
0
],
"webhookId": "db57033b-15eb-42ea-b443-9fd003069d77",
"parameters": {
"options": {},
"formTitle": "OnPage SEO ( WebSite )",
"formFields": {
"values": [
{
"fieldLabel": "website",
"requiredField": true
}
]
},
"formDescription": "OnPage SEO ( WebSite )"
},
"typeVersion": 2.2
},
{
"id": "d540b3a7-fa74-4cbf-a5f1-f2fe90dac4b5",
"name": "글로벌 스토리지",
"type": "n8n-nodes-base.set",
"position": [
-220,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "10714a4e-2be6-4167-aef5-afe30eebdc2b",
"name": "website",
"type": "string",
"value": "={{ $json.website }}"
},
{
"id": "6d160d8b-ab11-4f0a-a484-2e3f8f7f3033",
"name": "country",
"type": "string",
"value": "={{ $json.country }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5a516ec6-5571-49e5-9f29-71b0ca5571b9",
"name": "웹사이트 트래픽 체커",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
-280
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/webtraffic.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "6fd04a51-99f5-41b8-9e87-4b79458cb64f",
"name": "웹사이트 메트릭 DA PA",
"type": "n8n-nodes-base.httpRequest",
"position": [
180,
20
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/dapa.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "=seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "fd821ffa-4514-4d5d-b00b-121cd80f4de9",
"name": "탑 백링크",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
320
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/backlink.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ba321850-215d-4bfc-974d-ca8b05010037",
"name": "경쟁사 분석",
"type": "n8n-nodes-base.httpRequest",
"position": [
40,
660
],
"parameters": {
"url": "https://seo-on-page.p.rapidapi.com/competitor.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "website",
"value": "={{ $json.website }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "seo-on-page.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "0608f487-09a2-4ace-8180-554a64db14d4",
"name": "재포맷",
"type": "n8n-nodes-base.code",
"position": [
460,
-280
],
"parameters": {
"jsCode": "\nreturn $input.first().json.data.semrushAPI.trafficSummary[0];"
},
"typeVersion": 2
},
{
"id": "7e562232-bd9e-46e7-b084-6b63fbc45fcc",
"name": "재포맷 2",
"type": "n8n-nodes-base.code",
"position": [
440,
0
],
"parameters": {
"jsCode": "return $input.first().json.data;"
},
"typeVersion": 2
},
{
"id": "8716e2fc-4e2a-4edf-9ebf-63ed9b985e87",
"name": "DA PA",
"type": "n8n-nodes-base.googleSheets",
"position": [
740,
-20
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "da",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "da",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pa",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pa",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "spam_score",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "spam_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "dr",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "dr",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "org_traffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "org_traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2000619993,
"cachedResultUrl": "",
"cachedResultName": "DA PA"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "55ddbf28-b730-484b-b53a-1e84924df5b2",
"name": "웹사이트 트래픽",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
-280
],
"parameters": {
"columns": {
"value": {
"users": "={{ $json.users }}",
"visits": "={{ $json.visits }}",
"website": "={{ $json.target }}",
"bounceRate": "={{ $json.bounceRate }}",
"timeOnSite": "={{ $json.timeOnSite }}",
"displayDate": "={{ $json.displayDate }}",
"pagesPerVisit": "={{ $json.pagesPerVisit }}",
"searchOrganic": "={{ $json.searchOrganic }}"
},
"schema": [
{
"id": "website",
"type": "string",
"display": true,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "searchOrganic",
"type": "string",
"display": true,
"required": false,
"displayName": "searchOrganic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pagesPerVisit",
"type": "string",
"display": true,
"required": false,
"displayName": "pagesPerVisit",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "visits",
"type": "string",
"display": true,
"required": false,
"displayName": "visits",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "users",
"type": "string",
"display": true,
"required": false,
"displayName": "users",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timeOnSite",
"type": "string",
"display": true,
"required": false,
"displayName": "timeOnSite",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "bounceRate",
"type": "string",
"display": true,
"required": false,
"displayName": "bounceRate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "displayDate",
"type": "string",
"display": true,
"required": false,
"displayName": "displayDate",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "WebSite Traffic"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "5a800f61-2f0c-4a3e-9cee-79c66b1982cc",
"name": "재포맷 3",
"type": "n8n-nodes-base.code",
"position": [
540,
360
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinksOverview;"
},
"typeVersion": 2
},
{
"id": "98c5b73e-34cf-4a8b-b850-c80b134c3aef",
"name": "재포맷 4",
"type": "n8n-nodes-base.code",
"position": [
540,
620
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinks;"
},
"typeVersion": 2
},
{
"id": "d46bdc66-a2ee-4614-b7ba-3862f106231e",
"name": "백링크 개요",
"type": "n8n-nodes-base.googleSheets",
"position": [
980,
300
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "ascore",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ascore",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domainsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domainsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "followsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "framesNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "framesNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ipclasscNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ipclasscNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "imagesNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "imagesNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ipsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ipsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nofollowsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "nofollowsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sponsoredNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sponsoredNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "textsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "textsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "total",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "urlsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "urlsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ugcNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ugcNum",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1629296631,
"cachedResultUrl": "",
"cachedResultName": "Backlinks Overview"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "154437d1-0cae-4c9d-9512-4d8b00e84cf4",
"name": "백링크",
"type": "n8n-nodes-base.googleSheets",
"position": [
1020,
620
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1558472055,
"cachedResultUrl": "",
"cachedResultName": "Backlinks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "f56d9efb-55c9-4751-8acc-fe82974e52d7",
"name": "재포맷 5",
"type": "n8n-nodes-base.code",
"position": [
320,
820
],
"parameters": {
"jsCode": "const apiData = $input.first().json.data.semrushAPI;\n\nlet allRows = [];\n\n// Loop through each property\nfor (const key in apiData) {\n if (Array.isArray(apiData[key])) {\n // Add the name of the dataset as a field\n apiData[key].forEach(item => {\n allRows.push({ json: { dataset: key, ...item } });\n });\n }\n}\n\nreturn allRows;\n"
},
"typeVersion": 2
},
{
"id": "0bb2eed8-177c-4dae-b195-a3084efaa6da",
"name": "경쟁사 분석",
"type": "n8n-nodes-base.googleSheets",
"position": [
680,
860
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "dataset",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "dataset",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "database",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "database",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organicKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organicKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organicTraffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organicTraffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "backlinksNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "backlinksNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domainsNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domainsNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "adwordsKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "adwordsKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "commonKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "commonKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "competitorRelevance",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "competitorRelevance",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organicCost",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organicCost",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trafficPercent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trafficPercent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "traffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "numberOfKeywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "numberOfKeywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "competition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "competition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cpc",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "cpc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "numberOfResults",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "numberOfResults",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "positionDifference",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "positionDifference",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "previousPosition",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "previousPosition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "searchVolume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "searchVolume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trafficCostPercent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trafficCostPercent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trends",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trends",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keywordDifficulty",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keywordDifficulty",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1156851816,
"cachedResultUrl": "",
"cachedResultName": "Competitor Analysis"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1VfFCJ_xNkhTdr0vHfHlxKlfaKXNXUrrT3FzIwHvfFJg",
"cachedResultUrl": "",
"cachedResultName": "OnPage Seo ( Website )"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "af175b68-810b-4bc5-afb2-104158caf45f",
"name": "스티키 노트",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1840,
-180
],
"parameters": {
"width": 940,
"height": 840,
"content": "# OnPage SEO (Website) \n\nCaptures a website from a form, calls RapidAPI endpoints for traffic, DA/PA, backlinks, and competitors, reformats the results with Code nodes, and appends structured rows into dedicated tabs of a Google Sheet.\n\n---\n\n## Node-by-node Overview\n\n1. **On form submission** — Shows a web form (field: `website`) and triggers the workflow on submit. \n2. **Global Storage** — Copies `website` (and optional `country`) into the execution JSON for reuse. \n3. **Website Traffic Cheker** — POSTs `website` to `webtraffic.php` (RapidAPI) to fetch traffic summary. \n4. **Re-Format** — Extracts `data.semrushAPI.trafficSummary[0]` from the traffic API response. \n5. **Website Traffic** — Appends traffic metrics (visits, users, bounce, etc.) to the **\"WebSite Traffic\"** sheet. \n6. **Website Metrics DA PA** — POSTs `website` to `dapa.php` (RapidAPI) to get DA, PA, spam score, DR, org traffic. \n7. **Re-Format 2** — Pulls the `data` object from the DA/PA API response for clean mapping. \n8. **DA PA** — Appends DA/PA and related fields into the **\"DA PA\"** sheet. \n9. **Top Baclinks** — POSTs `website` to `backlink.php` (RapidAPI) to retrieve backlink data. \n10. **Re-Format 3** — Extracts `data.semrushAPI.backlinksOverview` (aggregate backlink metrics). \n11. **Backlinks Overview** — Appends overview metrics into the **\"Backlinks Overview\"** sheet. \n12. **Re-Format 4** — Extracts detailed `data.semrushAPI.backlinks` (individual backlinks list). \n13. **Backlinks** — Appends each backlink row into the **\"Backlinks\"** sheet. \n14. **Competitors Analysis** — POSTs `website` to `competitor.php` (RapidAPI) to fetch competitors/data sets. \n15. **Re-Format 5** — Flattens all array datasets under `data.semrushAPI` into rows with a `dataset` label. \n16. **Competitor Analysis** — Appends the flattened competitor and keyword rows into the **\"Competitor Analysis\"** sheet. \n"
},
"typeVersion": 1
},
{
"id": "255845ab-aad0-4151-ae7b-96b255b6aeca",
"name": "스티키 노트1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-600,
-140
],
"parameters": {
"height": 340,
"content": "**On form submission** — Shows a web form (field: `website`) and triggers the workflow on submit."
},
"typeVersion": 1
},
{
"id": "dac1487c-1660-47f4-9849-0b65f5d66bd1",
"name": "스티키 노트2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
-140
],
"parameters": {
"height": 340,
"content": " **Global Storage** — Copies `website` (and optional `country`) into the execution JSON for reuse. \n"
},
"typeVersion": 1
},
{
"id": "453e9e3f-5612-4c0e-ac9f-83c717bcbd14",
"name": "스티키 노트3",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
-380
],
"parameters": {
"height": 220,
"content": "**Website Traffic Cheker** — POSTs `website` to `webtraffic.php` (RapidAPI) to fetch traffic summary. \n"
},
"typeVersion": 1
},
{
"id": "78261b9e-c35d-4a23-a1c9-e9a4acb011b6",
"name": "스티키 노트4",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-380
],
"parameters": {
"height": 220,
"content": "**Re-Format** — Extracts `data.semrushAPI.trafficSummary[0]` from the traffic API response. "
},
"typeVersion": 1
},
{
"id": "a3f76afc-705e-4747-8ab0-8b3193c46f23",
"name": "스티키 노트5",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
-360
],
"parameters": {
"height": 220,
"content": "**Website Traffic** — Appends traffic metrics (visits, users, bounce, etc.) to the **\"WebSite Traffic\"** sheet."
},
"typeVersion": 1
},
{
"id": "671f2955-762c-4ae9-836b-600dfa08d2f4",
"name": "스티키 노트6",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
-80
],
"parameters": {
"height": 220,
"content": " **Website Metrics DA PA** — POSTs `website` to `dapa.php` (RapidAPI) to get DA, PA, spam score, DR, org traffic."
},
"typeVersion": 1
},
{
"id": "d46ac965-90ae-43dd-a4e8-78d1d8b815fe",
"name": "스티키 노트7",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
-80
],
"parameters": {
"height": 220,
"content": "**Re-Format 2** — Pulls the `data` object from the DA/PA API response for clean mapping"
},
"typeVersion": 1
},
{
"id": "dfdc4b4e-e6ae-43d3-8068-c5dda8a7e7f3",
"name": "스티키 노트8",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-100
],
"parameters": {
"height": 220,
"content": "**DA PA** — Appends DA/PA and related fields into the **\"DA PA\"** sheet. "
},
"typeVersion": 1
},
{
"id": "da105eb1-58c0-4816-8d8d-070e6ddf9791",
"name": "스티키 노트9",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
240
],
"parameters": {
"height": 200,
"content": "**Top Baclinks** — POSTs `website` to `backlink.php` (RapidAPI) to retrieve backlink data. \n"
},
"typeVersion": 1
},
{
"id": "c172b486-0220-42d4-9383-1f6203dcc320",
"name": "스티키 노트10",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
260
],
"parameters": {
"height": 220,
"content": " **Re-Format 3** — Extracts `data.semrushAPI.backlinksOverview` (aggregate backlink metrics). \n"
},
"typeVersion": 1
},
{
"id": "7235fabb-56ec-490f-88a3-b22864c972fe",
"name": "스티키 노트11",
"type": "n8n-nodes-base.stickyNote",
"position": [
900,
220
],
"parameters": {
"height": 220,
"content": "**Backlinks Overview** — Appends overview metrics into the **\"Backlinks Overview\"** sheet. "
},
"typeVersion": 1
},
{
"id": "4d1219dd-a333-49b9-8362-9ab7f6685b47",
"name": "스티키 노트12",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
520
],
"parameters": {
"height": 220,
"content": " **Re-Format 4** — Extracts detailed `data.semrushAPI.backlinks` (individual backlinks list). "
},
"typeVersion": 1
},
{
"id": "1131c491-00b8-4861-bdfc-34c7b7aa8072",
"name": "스티키 노트13",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
540
],
"parameters": {
"height": 240,
"content": " **Backlinks** — Appends each backlink row into the **\"Backlinks\"** sheet. \n"
},
"typeVersion": 1
},
{
"id": "e0039df4-faeb-4478-835f-05275538768a",
"name": "스티키 노트14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
560
],
"parameters": {
"height": 220,
"content": "**Competitors Analysis** — POSTs `website` to `competitor.php` (RapidAPI) to fetch competitors/data sets. "
},
"typeVersion": 1
},
{
"id": "eb9a700c-5d6c-439e-ad97-5dc1105dc613",
"name": "스티키 노트15",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
720
],
"parameters": {
"height": 220,
"content": " **Re-Format 5** — Flattens all array datasets under `data.semrushAPI` into rows with a `dataset` label. \n"
},
"typeVersion": 1
},
{
"id": "109ad2cb-00c4-48f4-a4ee-b3776100c7bf",
"name": "스티키 노트16",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
780
],
"parameters": {
"height": 200,
"content": " **Competitor Analysis** — Appends the flattened competitor and keyword rows into the **\"Competitor Analysis\"** sheet."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"0608f487-09a2-4ace-8180-554a64db14d4": {
"main": [
[
{
"node": "55ddbf28-b730-484b-b53a-1e84924df5b2",
"type": "main",
"index": 0
}
]
]
},
"7e562232-bd9e-46e7-b084-6b63fbc45fcc": {
"main": [
[
{
"node": "8716e2fc-4e2a-4edf-9ebf-63ed9b985e87",
"type": "main",
"index": 0
}
]
]
},
"5a800f61-2f0c-4a3e-9cee-79c66b1982cc": {
"main": [
[
{
"node": "d46bdc66-a2ee-4614-b7ba-3862f106231e",
"type": "main",
"index": 0
}
]
]
},
"98c5b73e-34cf-4a8b-b850-c80b134c3aef": {
"main": [
[
{
"node": "154437d1-0cae-4c9d-9512-4d8b00e84cf4",
"type": "main",
"index": 0
}
]
]
},
"f56d9efb-55c9-4751-8acc-fe82974e52d7": {
"main": [
[
{
"node": "0bb2eed8-177c-4dae-b195-a3084efaa6da",
"type": "main",
"index": 0
}
]
]
},
"fd821ffa-4514-4d5d-b00b-121cd80f4de9": {
"main": [
[
{
"node": "5a800f61-2f0c-4a3e-9cee-79c66b1982cc",
"type": "main",
"index": 0
},
{
"node": "98c5b73e-34cf-4a8b-b850-c80b134c3aef",
"type": "main",
"index": 0
}
]
]
},
"d540b3a7-fa74-4cbf-a5f1-f2fe90dac4b5": {
"main": [
[
{
"node": "5a516ec6-5571-49e5-9f29-71b0ca5571b9",
"type": "main",
"index": 0
},
{
"node": "0bb2eed8-177c-4dae-b195-a3084efaa6da",
"type": "main",
"index": 0
},
{
"node": "6fd04a51-99f5-41b8-9e87-4b79458cb64f",
"type": "main",
"index": 0
},
{
"node": "fd821ffa-4514-4d5d-b00b-121cd80f4de9",
"type": "main",
"index": 0
}
]
]
},
"10211c28-4673-429a-ba74-e41f4897dc93": {
"main": [
[
{
"node": "d540b3a7-fa74-4cbf-a5f1-f2fe90dac4b5",
"type": "main",
"index": 0
}
]
]
},
"0bb2eed8-177c-4dae-b195-a3084efaa6da": {
"main": [
[
{
"node": "f56d9efb-55c9-4751-8acc-fe82974e52d7",
"type": "main",
"index": 0
}
]
]
},
"6fd04a51-99f5-41b8-9e87-4b79458cb64f": {
"main": [
[
{
"node": "7e562232-bd9e-46e7-b084-6b63fbc45fcc",
"type": "main",
"index": 0
}
]
]
},
"5a516ec6-5571-49e5-9f29-71b0ca5571b9": {
"main": [
[
{
"node": "0608f487-09a2-4ace-8180-554a64db14d4",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - 시장 조사, 멀티모달 AI
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
Semrush 백링크 데이터를 Google Sheets로 자동 내보내기(RapidAPI 통해)
RapidAPI를 통한 Semrush 백링크 데이터 Google Sheets 자동 내보내기
Code
Form Trigger
Http Request
+
Code
Form Trigger
Http Request
13 노드Evoort Solutions
시장 조사
YouTube 채널 메타데이터를 Google Docs에 RapidAPI로 추출
RapidAPI를 사용하여 YouTube 채널 메타데이터를 Google Docs에 추출
Code
Google Docs
Form Trigger
+
Code
Google Docs
Form Trigger
9 노드Evoort Solutions
시장 조사
Job Search Global API 및 Google Sheets를 사용한 구직 활동 자동화
Job Search Global API 및 Google Sheets를 사용한 채용 공고 검색 자동화
If
Set
Code
+
If
Set
Code
15 노드Evoort Solutions
콘텐츠 제작
Dumpling AI를 사용하여 웹 블로그 내용을 추출하고 Google Sheets에 저장
Dumpling AI를 사용하여 웹사이트 블로그 내용을 추출하고 Google Sheets에 저장
Set
Code
Form Trigger
+
Set
Code
Form Trigger
11 노드Yang
시장 조사
Google Sheets와 이메일 알림을 사용하여 제목 명확성을 최적화
Google Sheets와 이메일 알림을 사용하여 제목 명확성을 최적화하기
If
Code
Email Send
+
If
Code
Email Send
14 노드Evoort Solutions
콘텐츠 제작
AI 기반 제품 연구 및 SEO 콘텐츠 자동화
AI 기반 제품 연구 및 SEO 콘텐츠 자동화
Set
Code
Function
+
Set
Code
Function
17 노드Evoort Solutions
인공지능
