AppSheet コミュニティテンプレート - ワークフロー
上級
これはAI分野の自動化ワークフローで、25個のノードを含みます。主にSet, Limit, Aggregate, HttpRequest, Agentなどのノードを使用、AI技術を活用したスマート自動化を実現。 AppSheet インテリジェントクエリオーケストレーター - データを問い合わせる！
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •Anthropic API Key
- •Google Gemini API Key
使用ノード (25)
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "EbTFAsvfdJZBB3J5",
"meta": {
"instanceId": "28532c0819ec8862291e01fb286b386e2fa3156b644ba3d1efc7c46bdaf57519",
"templateId": "VMiAxXa3lCAizGB5f7dVZQSFfg3FtHkdTKvLuupqBls=",
"templateCredsSetupCompleted": true
},
"name": "Appsheet Community Template-Workflow",
"tags": [],
"nodes": [
{
"id": "b4e6fed9-f776-4075-83d8-090c5180fb5a",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
320,
180
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb",
"name": "Limit",
"type": "n8n-nodes-base.limit",
"position": [
860,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4",
"name": "AppSheet",
"type": "n8n-nodes-rifad-appsheet.appSheet",
"position": [
920,
320
],
"parameters": {},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "f58c1671-396e-49d3-beed-7884d5fa5f92",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
1020,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3",
"name": "AggregateRanked",
"type": "n8n-nodes-base.set",
"position": [
1580,
-20
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "8fef5f0b-d163-468f-8dc0-f09240f06021",
"name": "Final Reranked Output",
"type": "n8n-nodes-base.set",
"position": [
1840,
-20
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d",
"name": "Cohere Rerank",
"type": "n8n-nodes-base.httpRequest",
"position": [
1340,
-20
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "47e28822-19f5-40f2-b6ab-63223049e66f",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
120,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f05514c-1499-4bc9-9d4e-2c1311a29340",
"name": "GetListOfWorksheets",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
600,
-740
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "349f36e5-634f-4141-a41c-23907144d39e",
"name": "GetHeaders",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
760,
-1060
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "e60a29e9-5c61-4d62-b666-195a2e822b14",
"name": "CallAppsheetAPI",
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"position": [
1180,
-1120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"name": "Appsheet Schema Analyser",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "This agent gets input and start exploring the data and its relationships throughout the app and creates a storyline",
"onError": "continueRegularOutput",
"position": [
420,
-1260
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.7
},
{
"id": "8f1e81d0-7ace-40d6-939e-e51e9d953da3",
"name": "Anthropic Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
340,
-1060
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "75ccf02e-721c-468a-a7a4-8b8e4c7239c4",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b3debcb8-18bc-4eb5-8df1-64a5d532b8ce",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "65e9ed23-f01a-4a9e-b262-328e7b97cc8d",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "79919a4e-e7d4-49f4-a6b8-d4861a456925",
"name": "他のワークフローから実行された場合",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-240,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "994be9b4-d4e8-4f30-a724-52d7bf9567aa",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1400,
-1700
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e0dce744-c592-45b1-a81f-5abe9f47e2bc",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6fe8fe1-459c-441e-ae65-7433da62b4a8",
"name": "チャットメッセージ受信時",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-140,
-1260
],
"webhookId": "e1fa302e-3f84-46a5-b90a-cb009f33a5b7",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "03dcef04-4a4c-48ab-b6f6-03b294fd83c2",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-920
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
"name": "入力のクリーニングと構造化",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
60,
-20
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "eaf92dab-8aa8-431e-9662-02c03a55d796",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-1240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "61b16043-6f64-44f7-91d8-b2500ce6a1b8",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7c9f2bd9-7f43-408f-95e3-0f9ab3c092ca",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-1440
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "376d90d3-0560-4d3a-a1b1-0436fac53325",
"connections": {
"b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb": {
"main": [
[
{
"node": "f58c1671-396e-49d3-beed-7884d5fa5f92",
"type": "main",
"index": 0
}
]
]
},
"3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4": {
"main": [
[
{
"node": "b2fc61ac-4c7b-4a3c-abe6-37f5a3eb34eb",
"type": "main",
"index": 0
}
]
]
},
"f58c1671-396e-49d3-beed-7884d5fa5f92": {
"main": [
[
{
"node": "b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d",
"type": "main",
"index": 0
}
]
]
},
"349f36e5-634f-4141-a41c-23907144d39e": {
"ai_tool": [
[
{
"node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"type": "ai_tool",
"index": 0
}
]
]
},
"b6ac9a2c-dead-4bdb-8b3b-f78f2673a31d": {
"main": [
[
{
"node": "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3",
"type": "main",
"index": 0
}
]
]
},
"4e3d2fe0-d1b8-40e2-96c1-66891fd770b3": {
"main": [
[
{
"node": "8fef5f0b-d163-468f-8dc0-f09240f06021",
"type": "main",
"index": 0
}
]
]
},
"e60a29e9-5c61-4d62-b666-195a2e822b14": {
"ai_tool": [
[
{
"node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"type": "ai_tool",
"index": 0
}
]
]
},
"7f05514c-1499-4bc9-9d4e-2c1311a29340": {
"ai_tool": [
[
{
"node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"type": "ai_tool",
"index": 0
}
]
]
},
"8f1e81d0-7ace-40d6-939e-e51e9d953da3": {
"ai_languageModel": [
[
{
"node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"8fef5f0b-d163-468f-8dc0-f09240f06021": {
"main": [
[]
]
},
"47e28822-19f5-40f2-b6ab-63223049e66f": {
"ai_languageModel": [
[
{
"node": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"b4e6fed9-f776-4075-83d8-090c5180fb5a": {
"ai_outputParser": [
[
{
"node": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"a6fe8fe1-459c-441e-ae65-7433da62b4a8": {
"main": [
[
{
"node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"type": "main",
"index": 0
}
]
]
},
"c2b76cf2-adad-41c6-946d-9b1b1979aedc": {
"main": [
[
{
"node": "3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4",
"type": "main",
"index": 0
}
]
]
},
"79919a4e-e7d4-49f4-a6b8-d4861a456925": {
"main": [
[
{
"node": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
Brazeで既存のメールテンプレートを更新
AIを使用してInstagram、Facebook、LinkedIn、Xでのソーシャルメディアコンテンツを自動化
Set
Gmail
Merge
+
Set
Gmail
Merge
73 ノードLukaszB
デザイン
AIメール分诊与GPT-4警报系统及Telegram通知
AIメール分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+
If
Set
Gmail
104 ノードPeter Joslyn
サポート
ブログWordPress複製販売
GPT-4、Perplexity AI、WordPressを使用したSEOブログコンテンツ作成の自動化
Set
Code
Notion
+
Set
Code
Notion
39 ノードLukaszB
人工知能
ブログ投稿自動化とSNSプロモーションエージェント
GPT-4、Perplexity、WordPressを使用したSEOブログ作成の自動化＋ソーシャルメディア
Set
Code
Gmail
+
Set
Code
Gmail
79 ノードLukaszB
デザイン
WordPress用AIブログコンテンツライター＆画像生成ツール
GPT Image 1とPerplexityに基づくWordPress用自動ブログコンテンツ作成ツール
Set
Code
Notion
+
Set
Code
Notion
41 ノードLukaszB
人工知能
