特定の日付のリクエストを作成する
中級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、14個のノードを含みます。主にSet, Code, SplitOut, HttpRequest, GoogleSheetsなどのノードを使用。 OpenAIを使用して職務要約を分析し、関連テンプレートを検索してGoogleスプレッドシートに記録
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (14)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "FhM3j90R33Z2xljk",
"meta": {
"instanceId": "f92b2f5dd06caa798e438c28ffbfaefb7248b0e550ddfec39077609f45e21ab8",
"templateCredsSetupCompleted": true
},
"name": "n8n Templates for Upwork",
"tags": [
{
"id": "gXb9aQuVQ6Y8qPJa",
"name": "upwork",
"createdAt": "2025-08-29T00:49:12.848Z",
"updatedAt": "2025-08-29T00:49:12.848Z"
},
{
"id": "iUYtwXp6ROMyrq1Y",
"name": "proposals",
"createdAt": "2025-09-04T14:12:54.746Z",
"updatedAt": "2025-09-04T14:12:54.746Z"
},
{
"id": "wdBKVgVHVo4La799",
"name": "n8n",
"createdAt": "2025-08-29T00:49:01.460Z",
"updatedAt": "2025-08-29T00:49:01.460Z"
}
],
"nodes": [
{
"id": "9eb3a5a6-2981-4052-9433-83bc401c098e",
"name": "チャットメッセージ受信時",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-240,
400
],
"webhookId": "6508f62f-a4e4-4357-a590-571eb820480c",
"parameters": {
"options": {}
},
"typeVersion": 1.3
},
{
"id": "04ae28c4-4f0b-4a58-8612-a58e7de56a49",
"name": "AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-16,
400
],
"parameters": {
"options": {
"systemMessage": "You are a helpful assistant. \nExtract exactly 5 distinct search keywords or short phrases from the following job description. \nReturn them strictly as a JSON object with the keys \"keyword1\", \"keyword2\", \"keyword3\", \"keyword4\", \"keyword5\". \nDo not include explanations or extra text. \nThe values must be concise search-ready terms taken directly from the job description context."
}
},
"typeVersion": 2.2
},
{
"id": "0038b249-d5ad-46c5-bbab-119aec8be21f",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
56,
624
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "7lyc6bsOwpwV9y1x",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "ace430e0-a890-470c-8926-824d94740e26",
"name": "キーワード解析",
"type": "n8n-nodes-base.code",
"position": [
336,
400
],
"parameters": {
"jsCode": "const items = $input.all();\nconst updatedItems = items.map((item) => {\n const output = JSON.parse(item?.json?.output);\n return output;\n});\nreturn updatedItems;\n"
},
"typeVersion": 2
},
{
"id": "f847a129-ff2c-4b35-b3f2-bcae45d07707",
"name": "テンプレート検索",
"type": "n8n-nodes-base.httpRequest",
"position": [
1008,
448
],
"parameters": {
"url": "https://api.n8n.io/templates/search",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "=search",
"value": "={{ $json.keyword }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Name",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "f79d297e-6f37-4469-9fa7-c27f4337c4b0",
"name": "分割",
"type": "n8n-nodes-base.splitOut",
"position": [
1008,
256
],
"parameters": {
"options": {},
"fieldToSplitOut": "workflows"
},
"typeVersion": 1
},
{
"id": "d9e899bc-3422-42ee-af34-5af6045e5405",
"name": "アイテムループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
784,
400
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "31e957ef-2af1-4482-aad4-7cb86e7445c6",
"name": "配列変換",
"type": "n8n-nodes-base.code",
"position": [
560,
400
],
"parameters": {
"jsCode": "const input = $json;\nreturn [\n { json: { keyword: input.keyword1 } },\n { json: { keyword: input.keyword2 } },\n { json: { keyword: input.keyword3 } },\n { json: { keyword: input.keyword4 } },\n { json: { keyword: input.keyword5 } },\n];"
},
"typeVersion": 2
},
{
"id": "3aa34d3e-fe01-4804-a4d4-a629b37d7cdf",
"name": "sheet2に行を追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
1232,
256
],
"parameters": {
"columns": {
"value": {
"id": "={{ $json.id }}",
"Name": "={{ $json.name }}",
"User": "={{ $json.user }}",
"Description": "={{ $json.description }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "User",
"type": "string",
"display": true,
"required": false,
"displayName": "User",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY/edit?usp=drivesdk",
"cachedResultName": "n8n Projects"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "jOa9HPz3eugURQ5I",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "0458e77f-53ea-485f-bde7-90d80c405cf1",
"name": "シートから行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
1456,
256
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.id }}",
"lookupColumn": "id"
},
{
"lookupValue": "={{ $json.Name }}",
"lookupColumn": "Name"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY/edit?usp=drivesdk",
"cachedResultName": "n8n Projects"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "jOa9HPz3eugURQ5I",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "1f7e9ea7-88b9-4203-9af8-8c1584f54c4d",
"name": "フィールド編集",
"type": "n8n-nodes-base.set",
"position": [
1680,
256
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "8c1e234b-030f-4c75-8de2-a10ffcbd3ac3",
"name": "URL",
"type": "string",
"value": "=https://n8n.io/workflows/{{$json.id}}-{{$json.Name.toLowerCase().replace(/[^a-z0-9]+/g, \"-\").replace(/(^-|-$)/g, \"\")}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "99e6afe4-825e-4e8f-b640-fba60ba35ad6",
"name": "シートの行を更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1904,
256
],
"parameters": {
"columns": {
"value": {
"id": "={{ $json.URL }}",
"row_number": "={{ $('Get row(s) in sheet').item.json.row_number }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "User",
"type": "string",
"display": true,
"required": false,
"displayName": "User",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LC7YaRub1nZxdkcrWEt1PtVkZKyy0kcQTXuAv8zlsxY/edit?usp=drivesdk",
"cachedResultName": "n8n Projects"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "jOa9HPz3eugURQ5I",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "ba73d877-d103-4f6c-a09e-63640a817df7",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-144
],
"parameters": {
"width": 672,
"height": 384,
"content": "Title: Setup Instructions\nContent:\n - Add OpenAI credentials to the LLM node.\n - Add Google Sheets OAuth credentials to Sheets nodes.\n - Set GOOGLE_SHEETS_DOC_ID, GOOGLE_SHEET_NAME, and N8N_TEMPLATES_API_URL in ⚙️ Config.\n - Create columns: Template ID, Name, User, Description, URL in your Google Sheet."
},
"typeVersion": 1
},
{
"id": "48133b53-44f8-4cea-822a-e595ec5ca3a8",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
656
],
"parameters": {
"color": 5,
"width": 784,
"height": 384,
"content": "Title: Input Trigger\nContent:\n- This node starts the workflow when a chat message is received.\n- The message should contain a job brief or description.\n\nTitle: Keyword Extraction\nContent:\n- The agent extracts 5 distinct keywords from the job description using OpenAI.\n- Output is parsed and converted into an array for further processing.\n\nTitle: Template Search\nContent:\n- For each keyword, the workflow searches the n8n template library API.\n- Results are split and processed individually.\n\nTitle: Google Sheets Logging\nContent:\n- Appends template search results to Google Sheets.\n- Builds a public URL for each template and updates the corresponding row.\n\nTitle: General Notes\nContent:\n- No hardcoded API keys in HTTP nodes.\n- You can swap Google Sheets for Airtable/Notion if needed.\n- Ensure all required columns exist in your destination sheet."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2ed4f281-7f84-4b36-92cd-2dc00fe2f4af",
"connections": {
"04ae28c4-4f0b-4a58-8612-a58e7de56a49": {
"main": [
[
{
"node": "ace430e0-a890-470c-8926-824d94740e26",
"type": "main",
"index": 0
}
]
]
},
"f79d297e-6f37-4469-9fa7-c27f4337c4b0": {
"main": [
[
{
"node": "3aa34d3e-fe01-4804-a4d4-a629b37d7cdf",
"type": "main",
"index": 0
}
]
]
},
"1f7e9ea7-88b9-4203-9af8-8c1584f54c4d": {
"main": [
[
{
"node": "99e6afe4-825e-4e8f-b640-fba60ba35ad6",
"type": "main",
"index": 0
}
]
]
},
"ace430e0-a890-470c-8926-824d94740e26": {
"main": [
[
{
"node": "31e957ef-2af1-4482-aad4-7cb86e7445c6",
"type": "main",
"index": 0
}
]
]
},
"d9e899bc-3422-42ee-af34-5af6045e5405": {
"main": [
[
{
"node": "f79d297e-6f37-4469-9fa7-c27f4337c4b0",
"type": "main",
"index": 0
}
],
[
{
"node": "f847a129-ff2c-4b35-b3f2-bcae45d07707",
"type": "main",
"index": 0
}
]
]
},
"f847a129-ff2c-4b35-b3f2-bcae45d07707": {
"main": [
[
{
"node": "d9e899bc-3422-42ee-af34-5af6045e5405",
"type": "main",
"index": 0
}
]
]
},
"0038b249-d5ad-46c5-bbab-119aec8be21f": {
"ai_languageModel": [
[
{
"node": "04ae28c4-4f0b-4a58-8612-a58e7de56a49",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"31e957ef-2af1-4482-aad4-7cb86e7445c6": {
"main": [
[
{
"node": "d9e899bc-3422-42ee-af34-5af6045e5405",
"type": "main",
"index": 0
}
]
]
},
"0458e77f-53ea-485f-bde7-90d80c405cf1": {
"main": [
[
{
"node": "1f7e9ea7-88b9-4203-9af8-8c1584f54c4d",
"type": "main",
"index": 0
}
]
]
},
"3aa34d3e-fe01-4804-a4d4-a629b37d7cdf": {
"main": [
[
{
"node": "0458e77f-53ea-485f-bde7-90d80c405cf1",
"type": "main",
"index": 0
}
]
]
},
"9eb3a5a6-2981-4052-9433-83bc401c098e": {
"main": [
[
{
"node": "04ae28c4-4f0b-4a58-8612-a58e7de56a49",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - コンテンツ作成, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
💥 NanoBanana、Seedream 4、ChatGPT Image、Veo 3 を使って動画広告を自動化 - VIDEO
AI（NanoBanana、Seedream、GPT-4o、Veo 3）を使って動画広告キャンペーンを自動化し公開
Set
Code
Wait
+
Set
Code
Wait
63 ノードDr. Firas
コンテンツ作成
OpenAI、RunwayML、ElevenLabsを使って無顔の短い動画を自動化
OpenAI、RunwayML、ElevenLabs を使ってアニメ顔の短い動画を自動化：スクリプトからソーシャルメディアへ
Set
Code
Wait
+
Set
Code
Wait
56 ノードLeeWei
コンテンツ作成
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
GPT-5 nanoとGoogle Sheetsを使ってウェブサイトをスクレイピングして質問に回答
GPT-5 nanoとGoogle Sheetsでウェブサイトをスクレイピングし、質問に答える
If
Set
Xml
+
If
Set
Xml
44 ノードOriol Seguí
市場調査
コンテンツジェネレーター v3
AI驱动ブログ自動化：使用GPT-4生成并公開SEO記事至WordPressとTwitter
If
Set
Code
+
If
Set
Code
144 ノードJay Emp0
コンテンツ作成
ブログパブリッシャー – 完全AI駆動のコンテンツ調査、作成、最適化、公開の自動化
Gemini、Ideogram AI、WordPress でブログ作成と公開を自動化
If
Set
Code
+
If
Set
Code
35 ノードIncrementors
コンテンツ作成
