Analyse et enregistrement automatisés du SEO de page avec RapidAPI et Google Sheets
Avancé
Ceci est unMarket Research, Multimodal AIworkflow d'automatisation du domainecontenant 33 nœuds.Utilise principalement des nœuds comme Set, Code, FormTrigger, HttpRequest, GoogleSheets. Analyse et journalisation automatisées du référencement de pages avec RapidAPI et Google Sheets
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (33)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "10211c28-4673-429a-ba74-e41f4897dc93",
"name": "À la soumission du formulaire",
"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": "Stockage global",
"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": "Vérificateur de trafic du site web",
"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": "Métriques du site web 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": "Top Backlinks",
"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": "Analyse des concurrents",
"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": "Reformatage",
"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": "Reformatage 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": "Trafic du site web",
"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": "Reformatage 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": "Reformatage 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": "Aperçu des backlinks",
"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": "Backlinks",
"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": "Reformatage 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": "Analyse concurrentielle",
"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": "Note autocollante",
"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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "Note autocollante 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": "ba321850-215d-4bfc-974d-ca8b05010037",
"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
}
]
]
},
"ba321850-215d-4bfc-974d-ca8b05010037": {
"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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Étude de marché, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Exportation automatisée des données de liens retour de Semrush vers Google Sheets (via RapidAPI
Exportation automatisée des données de liens retour depuis Semrush vers Google Sheets (via RapidAPI)
Code
Form Trigger
Http Request
+
Code
Form Trigger
Http Request
13 NœudsEvoort Solutions
Étude de marché
Extraction de métadonnées de chaîne YouTube vers Google Docs avec RapidAPI
Extraire les métadonnées de chaînes YouTube vers Google Docs avec RapidAPI
Code
Google Docs
Form Trigger
+
Code
Google Docs
Form Trigger
9 NœudsEvoort Solutions
Étude de marché
Automatisation de la recherche d'emploi avec Job Search Global API et Google Sheets
Automatisation de la recherche d'offres d'emploi avec Job Search Global API et Google Sheets
If
Set
Code
+
If
Set
Code
15 NœudsEvoort Solutions
Création de contenu
Utiliser Dumpling AI pour scraper le contenu des blogs de sites web et l'enregistrer dans Google Sheets
Gratter le contenu des blogs de sites web et le sauvegarder dans Google Sheets avec Dumpling AI
Set
Code
Form Trigger
+
Set
Code
Form Trigger
11 NœudsYang
Étude de marché
Optimiser la clarté des titres avec Google Sheets et des notifications par e-mail
Optimiser la clarté des titres avec Google Sheets et notifications par e-mail
If
Code
Email Send
+
If
Code
Email Send
14 NœudsEvoort Solutions
Création de contenu
Recherche de Produit et Automatisation de Contenu SEO Pilotées par l'IA
Recherche de Produit et Automatisation de Contenu SEO Pilotées par l'IA
Set
Code
Function
+
Set
Code
Function
17 NœudsEvoort Solutions
Intelligence Artificielle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds33
Catégorie2
Types de nœuds6
Description de la difficulté
Auteur
Evoort Solutions
@evoortsolutionsLiens externes
Voir sur n8n.io →
Partager ce workflow