RapidAPI を通じて Google Sheets への Semrush による自動バックラinking データ出力
中級
これはMarket Research, Multimodal AI分野の自動化ワークフローで、13個のノードを含みます。主にCode, FormTrigger, HttpRequest, GoogleSheetsなどのノードを使用。 Semrush から自動のにリバースリンクデータをGoogle Sheetsへ出力（RapidAPIを使用）
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "9137421c-a5a6-47e0-816c-4c9707c77d75",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "5c31527e-396a-4263-bfa2-0b8d893060e4",
"parameters": {
"options": {},
"formTitle": "Semrush Backlink Checker",
"formFields": {
"values": [
{
"fieldLabel": "website",
"requiredField": true
}
]
},
"formDescription": "Semrush Backlink Checker"
},
"typeVersion": 2.2
},
{
"id": "885fee0f-647f-4eb3-80b3-7e37d15c9bd7",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
0
],
"parameters": {
"url": "https://semrush-backlink-checker.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": "semrush-backlink-checker.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "05e9b4d1-a348-48d2-8f9d-3b8243b183f3",
"name": "データ整形 1",
"type": "n8n-nodes-base.code",
"position": [
480,
0
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinksOverview;"
},
"typeVersion": 2
},
{
"id": "56aa5555-0460-453b-9518-36a82cf1eb97",
"name": "データ整形 2",
"type": "n8n-nodes-base.code",
"position": [
400,
300
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.backlinks;"
},
"typeVersion": 2
},
{
"id": "53bb9a7e-069b-4398-8cad-444a5d41f8f2",
"name": "バックリンク概要",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
0
],
"parameters": {
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 4590546,
"cachedResultUrl": "",
"cachedResultName": "backlink overflow"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "c4eb2b7d-d586-4300-b427-44c3c7027178",
"name": "バックリンク一覧",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
300
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "targetUrl",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "targetUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceUrl",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sourceUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sourceTitle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sourceTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pageAscore",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pageAscore",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lastSeen",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "lastSeen",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "internalNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "internalNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "firstSeen",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "firstSeen",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "externalNum",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "externalNum",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "anchor",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "anchor",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nofollow",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "nofollow",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "backlinks"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "8a3c938c-b6bf-4bbb-bfa3-22b9d30ef2d2",
"name": "付箋メモ",
"type": "n8n-nodes-base.stickyNote",
"position": [
-820,
-140
],
"parameters": {
"width": 680,
"height": 780,
"content": "# 🚀 Semrush Backlink Checker Automation with n8n and Google Sheets\n\n## 📘 Description\n\nThis automated n8n workflow enables users to input a website URL via a form, fetch backlink data using the Semrush Backlink Checker API (via RapidAPI), and export both an overview and detailed backlink information to Google Sheets. Ideal for SEO professionals looking to streamline backlink audits and reporting.\n\n---\n\n## 🧩 Node-by-Node Explanation\n\n- **On form submission** – Starts the workflow when a user submits a website URL through a custom form.\n- **HTTP Request** – Sends the submitted URL to Semrush Backlink Checker API using POST with headers and body data.\n- **Reformat 1** – Extracts the `backlinksOverview` object from the API response JSON.\n- **Reformat 2** – Extracts the `backlinks` list (detailed data) from the API response JSON.\n- **Backlink overview** – Appends backlink overview metrics to the “backlink overflow” sheet in a specified Google Sheets document.\n- **Backlinks** – Appends individual backlink entries (e.g. source URL, anchor, score) to the “backlinks” sheet in the same Google Sheet.\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "543c484a-e96e-4ee6-ae3c-dcb9343c17e5",
"name": "付箋メモ1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-140
],
"parameters": {
"height": 300,
"content": "**On form submission** – Starts the workflow when a user submits a website URL through a custom form."
},
"typeVersion": 1
},
{
"id": "b9ccc855-61e1-43c2-a948-b67a12dd518a",
"name": "付箋メモ2",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-140
],
"parameters": {
"height": 300,
"content": "**HTTP Request** – Sends the submitted URL to Semrush Backlink Checker API using POST with headers and body data."
},
"typeVersion": 1
},
{
"id": "a2efe122-287c-45a0-8706-b83f8e9b66b0",
"name": "付箋メモ3",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-140
],
"parameters": {
"height": 300,
"content": " **Reformat 1** – Extracts the `backlinksOverview` object from the API response JSON."
},
"typeVersion": 1
},
{
"id": "a959e928-e4b8-41b7-a5d4-a41502962113",
"name": "付箋メモ4",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
200
],
"parameters": {
"height": 280,
"content": " **Reformat 2** – Extracts the `backlinks` list (detailed data) from the API response JSON."
},
"typeVersion": 1
},
{
"id": "5eb05e85-9c3b-41b1-9cf9-3afbcd411c5d",
"name": "付箋メモ5",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-140
],
"parameters": {
"height": 300,
"content": "**Backlink overview** – Appends backlink overview metrics to the “backlink overflow” sheet in a specified Google Sheets document."
},
"typeVersion": 1
},
{
"id": "72bcc8b0-6dc1-4802-a558-1ccb5695de9c",
"name": "付箋メモ6",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
220
],
"parameters": {
"height": 260,
"content": " **Backlinks** – Appends individual backlink entries (e.g. source URL, anchor, score) to the “backlinks” sheet in the same Google Sheet."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"05e9b4d1-a348-48d2-8f9d-3b8243b183f3": {
"main": [
[
{
"node": "53bb9a7e-069b-4398-8cad-444a5d41f8f2",
"type": "main",
"index": 0
}
]
]
},
"56aa5555-0460-453b-9518-36a82cf1eb97": {
"main": [
[
{
"node": "c4eb2b7d-d586-4300-b427-44c3c7027178",
"type": "main",
"index": 0
}
]
]
},
"885fee0f-647f-4eb3-80b3-7e37d15c9bd7": {
"main": [
[
{
"node": "05e9b4d1-a348-48d2-8f9d-3b8243b183f3",
"type": "main",
"index": 0
},
{
"node": "56aa5555-0460-453b-9518-36a82cf1eb97",
"type": "main",
"index": 0
}
]
]
},
"9137421c-a5a6-47e0-816c-4c9707c77d75": {
"main": [
[
{
"node": "885fee0f-647f-4eb3-80b3-7e37d15c9bd7",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 市場調査, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
RapidAPIとGoogle Sheetsを使ったページSEO分析の自動化と記録
APIキーの利用規約変更に基づくRapidAPIとGoogleスプレッドシートを使用したページSEO分析と記録の自動化
Set
Code
Form Trigger
+
Set
Code
Form Trigger
33 ノードEvoort Solutions
市場調査
RapidAPIを使ってYouTubeチャンネル メタデータをGoogle Docsに抽出
RapidAPIを使ってYouTubeチャネルメタデータをGoogle Docsに抽出
Code
Google Docs
Form Trigger
+
Code
Google Docs
Form Trigger
9 ノードEvoort Solutions
市場調査
Google Sheetsとメール通知を使用してタイトルの明確さを最適化する
Google Sheetsとメール通知によるタイトルの明確さの最適化
If
Code
Email Send
+
If
Code
Email Send
14 ノードEvoort Solutions
コンテンツ作成
ランディングページアナライザーAIを使ってウェブページを分析し、Google Docsレポートを生成
ラニリングページアナライザAIを使ってウェブページを分析し、Google Docsのレポートを生成
Code
Google Docs
Form Trigger
+
Code
Google Docs
Form Trigger
9 ノードEvoort Solutions
AI要約
トップクラスのリバーシブルリンクチェッカーAPIを使ってサイトのリバーシブルリンクを分析し、Google Sheetsに記録
トップクラスのバックリンクチェッカーAPIを使ってサイトのバックリンクを分析し、Google Sheetsに記録
Code
Form Trigger
Http Request
+
Code
Form Trigger
Http Request
13 ノードSk developer
市場調査
Job Search Global API と Google Sheets を使って求人検索を自動化
Job Search Global API、Google Sheets を使って 自動化求人検索を行う
If
Set
Code
+
If
Set
Code
15 ノードEvoort Solutions
コンテンツ作成
