RapidAPIとGoogle SheetsでSEOキーワード分析を自動化
中級
これはMarket Research, Multimodal AI分野の自動化ワークフローで、9個のノードを含みます。主にCode, FormTrigger, HttpRequest, GoogleSheetsなどのノードを使用。 RapidAPIとGoogle シートを使ったSEOキーワード分析の自動化
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "55979fca-6abb-43f2-af9a-59f2cacaeb51",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "259a4fed-36fb-457c-8813-f84cf10d8c36",
"parameters": {
"options": {},
"formTitle": "Keyword Analysis ",
"formFields": {
"values": [
{
"fieldLabel": "country",
"requiredField": true
},
{
"fieldLabel": "keyword",
"requiredField": true
}
]
},
"formDescription": "Keyword Analysis "
},
"typeVersion": 2.2
},
{
"id": "00963262-4328-4998-a996-b12d98f1badb",
"name": "出力の再フォーマット",
"type": "n8n-nodes-base.code",
"position": [
520,
0
],
"parameters": {
"jsCode": "return $input.first().json.data.semrushAPI.broadMatchKeywords;"
},
"typeVersion": 2
},
{
"id": "47be20f6-5340-4d42-af21-bff7faf046ec",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
0
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"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": "keywordsSerpFeatures",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keywordsSerpFeatures",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "numberOfResults",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "numberOfResults",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "searchVolume",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "searchVolume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "trends",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "trends",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keywordDifficultyIndex",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "keywordDifficultyIndex",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "intent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "intent",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 150500408,
"cachedResultUrl": "",
"cachedResultName": "keyword"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "Seo n8n"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "2ec4b6b3-d8e0-4afd-8230-05604e85a258",
"name": "キーワード分析",
"type": "n8n-nodes-base.httpRequest",
"position": [
300,
0
],
"parameters": {
"url": "https://keyword-research-tool3.p.rapidapi.com/keyword-tool.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "country",
"value": "={{ $json.country }}"
},
{
"name": "keyword",
"value": "={{ $json.keyword }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "keyword-research-tool3.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "eaa1c076-3d65-41a6-934f-b7114f86de70",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-820,
-520
],
"parameters": {
"width": 640,
"height": 980,
"content": " \n## **\"Automated Keyword Analysis and Google Sheets Logging with n8n\"**\n\n**Description:** \n\"Automate keyword research with n8n and log essential SEO data like search volume, trends, competition, and keyword difficulty directly into Google Sheets. Simplify your SEO efforts with real-time insights.\"\n\n## Node-by-Node Explanation\n\n### 1. **On form submission (Trigger)**\n- **Purpose:** This node triggers the workflow when the user submits the form with \"country\" and \"keyword\" as inputs.\n- **Explanation:** It initiates the process by accepting user input from the form and passing it to the next node for analysis.\n\n### 2. **Keyword Analysis (HTTP Request)**\n- **Purpose:** Sends a request to an external SEO API to analyze the provided keyword, fetching data like search volume, trends, and competition.\n- **Explanation:** It calls the keyword analysis API with the form input (country and keyword) and retrieves relevant keyword data.\n\n### 3. **Re-format output (Code)**\n- **Purpose:** Processes and reformats the API response into a structured format suitable for logging into Google Sheets.\n- **Explanation:** It extracts and organizes the keyword data (like competition, CPC, etc.) into a format that can be mapped to Google Sheets columns.\n\n### 4. **Google Sheets (Append)**\n- **Purpose:** Appends the reformatted keyword data into the specified Google Sheets document.\n- **Explanation:** Logs the fetched keyword insights (like search volume, trends, competition, etc.) into a Google Sheets document for ongoing analysis.\n\n---\n\n## Summary\nThis workflow automates the process of keyword research by collecting input through a form, querying an SEO API for detailed keyword insights, and logging that data into a Google Sheet for easy tracking and analysis. It simplifies the process of keeping track of important SEO metrics for your targeted keywords.\n"
},
"typeVersion": 1
},
{
"id": "fca5eb74-cc39-45b0-82c1-efc8d00c2df6",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-260
],
"parameters": {
"height": 420,
"content": "**On form submission (Trigger)**\n- **Purpose:** This node triggers the workflow when the user submits the form with \"country\" and \"keyword\" as inputs.\n- **Explanation:** It initiates the process by accepting user input from the form and passing it to the next node for analysis.\n"
},
"typeVersion": 1
},
{
"id": "e3a571a3-3fd8-478c-8b98-24ac8338a36e",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-260
],
"parameters": {
"height": 420,
"content": "**Keyword Analysis (HTTP Request)**\n- **Purpose:** Sends a request to an external SEO API to analyze the provided keyword, fetching data like search volume, trends, and competition.\n- **Explanation:** It calls the keyword analysis API with the form input (country and keyword) and retrieves relevant keyword data.\n"
},
"typeVersion": 1
},
{
"id": "83e2f234-03c1-40f7-b696-15bf9ff371ef",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-260
],
"parameters": {
"height": 420,
"content": "**Re-format output (Code)**\n- **Purpose:** Processes and reformats the API response into a structured format suitable for logging into Google Sheets.\n- **Explanation:** It extracts and organizes the keyword data (like competition, CPC, etc.) into a format that can be mapped to Google Sheets columns.\n"
},
"typeVersion": 1
},
{
"id": "beee2895-71ef-4ce4-9e2f-8e9fd847f101",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
740,
-260
],
"parameters": {
"height": 420,
"content": "**Google Sheets (Append)**\n- **Purpose:** Appends the reformatted keyword data into the specified Google Sheets document.\n- **Explanation:** Logs the fetched keyword insights (like search volume, trends, competition, etc.) into a Google Sheets document for ongoing analysis.\n\n---"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"2ec4b6b3-d8e0-4afd-8230-05604e85a258": {
"main": [
[
{
"node": "00963262-4328-4998-a996-b12d98f1badb",
"type": "main",
"index": 0
}
]
]
},
"00963262-4328-4998-a996-b12d98f1badb": {
"main": [
[
{
"node": "47be20f6-5340-4d42-af21-bff7faf046ec",
"type": "main",
"index": 0
}
]
]
},
"55979fca-6abb-43f2-af9a-59f2cacaeb51": {
"main": [
[
{
"node": "2ec4b6b3-d8e0-4afd-8230-05604e85a258",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 市場調査, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
トップクラスのリバーシブルリンクチェッカーAPIを使ってサイトのリバーシブルリンクを分析し、Google Sheetsに記録
トップクラスのバックリンクチェッカーAPIを使ってサイトのバックリンクを分析し、Google Sheetsに記録
Code
Form Trigger
Http Request
+
Code
Form Trigger
Http Request
13 ノードSk developer
市場調査
ドメイン権威指標をバッチで確認し、結果をGoogleテーブルに記録
RapidAPI を使用してドメイン権威性指標をバッチで確認し、Google スプレッドシートに記録
Code
Form Trigger
Http Request
+
Code
Form Trigger
Http Request
9 ノードSk developer
市場調査
販売税計算 API と Google Sheets を使って販売税の自動計算
売上税計算APIとGoogle Sheetsを使った自動売上税計算の実装
Code
Form Trigger
Http Request
+
Code
Form Trigger
Http Request
9 ノードSk developer
請求書処理
Sora GPT、Google Drive、Sheetsを使ってAI画像を生成して保存
Sora GPT、Google Drive、Sheets を使用して AI 画像を生成して保存
Code
Form Trigger
Google Drive
+
Code
Form Trigger
Google Drive
11 ノードSk developer
コンテンツ作成
RapidAPIとGoogle Sheetsを使ったページSEO分析の自動化と記録
APIキーの利用規約変更に基づくRapidAPIとGoogleスプレッドシートを使用したページSEO分析と記録の自動化
Set
Code
Form Trigger
+
Set
Code
Form Trigger
33 ノードEvoort Solutions
市場調査
RapidAPI と Google Sheets を使用した自動類似度検出とメールリポート
RapidAPI と Google スプレッドシートで自動類似チェックとメールリポート
If
Code
Email Send
+
If
Code
Email Send
19 ノードSk developer
コンテンツ作成
