AppSheet Community-Vorlage – Workflow
Experte
Dies ist ein AI-Bereich Automatisierungsworkflow mit 25 Nodes. Hauptsächlich werden Set, Limit, Aggregate, HttpRequest, Agent und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. AppSheet Intelligent Query Orchestrator – Abfragen Sie alle Daten!
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
- •Anthropic API Key
- •Google Gemini API Key
Verwendete Nodes (25)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in 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": "Begrenzen",
"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": "Aggregieren",
"type": "n8n-nodes-base.aggregate",
"position": [
1020,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4e3d2fe0-d1b8-40e2-96c1-66891fd770b3",
"name": "AggregierenRanked",
"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-Modell",
"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-Modell",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
340,
-1060
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "75ccf02e-721c-468a-a7a4-8b8e4c7239c4",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b3debcb8-18bc-4eb5-8df1-64a5d532b8ce",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "65e9ed23-f01a-4a9e-b262-328e7b97cc8d",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "79919a4e-e7d4-49f4-a6b8-d4861a456925",
"name": "When Executed by Another Workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-240,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "994be9b4-d4e8-4f30-a724-52d7bf9567aa",
"name": "Haftnotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1400,
-1700
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e0dce744-c592-45b1-a81f-5abe9f47e2bc",
"name": "Haftnotiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6fe8fe1-459c-441e-ae65-7433da62b4a8",
"name": "Bei Chat-Nachricht empfangen",
"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": "Haftnotiz5",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-920
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c2b76cf2-adad-41c6-946d-9b1b1979aedc",
"name": "Cleanup and structure the input",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
60,
-20
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "eaf92dab-8aa8-431e-9662-02c03a55d796",
"name": "Haftnotiz6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-1240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "61b16043-6f64-44f7-91d8-b2500ce6a1b8",
"name": "Haftnotiz7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7c9f2bd9-7f43-408f-95e3-0f9ab3c092ca",
"name": "Haftnotiz8",
"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": {
"Limit": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"3ab3185c-d9b3-4767-8bc6-5d9d8b1966e4": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"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": "AggregateRanked",
"type": "main",
"index": 0
}
]
]
},
"AggregateRanked": {
"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
}
]
]
},
"Anthropic Chat Model": {
"ai_languageModel": [
[
{
"node": "ef68c1bc-1fc1-4027-9dfe-0ebcad79d5be",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"8fef5f0b-d163-468f-8dc0-f09240f06021": {
"main": [
[]
]
},
"Google Gemini Chat Model": {
"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
}
]
]
},
"When chat message received": {
"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
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Künstliche Intelligenz
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
Aktualisierung bestehender E-Mail-Vorlagen in Braze
Automatisierung von Social-Media-Inhalten für Instagram, Facebook, LinkedIn und X mit KI
Set
Gmail
Merge
+
Set
Gmail
Merge
73 NodesLukaszB
Design
AI Email Triage & Alert System with GPT-4 and Telegram Notifications
If
Set
Gmail
+
If
Set
Gmail
104 NodesPeter Joslyn
Support
Blog WordPress-Kopie Verkauf
Automatisierung der Erstellung von SEO-Blog-Inhalten mit GPT-4, Perplexity AI und WordPress
Set
Code
Notion
+
Set
Code
Notion
39 NodesLukaszB
Künstliche Intelligenz
Automatisierter Blog-Schreib- und Social-Media-Promotions-Agent
Automatisierung der Erstellung von SEO-Blogs + Social Media mit GPT-4, Perplexity und WordPress
Set
Code
Gmail
+
Set
Code
Gmail
79 NodesLukaszB
Design
AI-Blog-Inhalts- und Bild-Generator für WordPress
Automatisierter WordPress-Blog-Inhalts-Generator basierend auf GPT Image 1 und Perplexity
Set
Code
Notion
+
Set
Code
Notion
41 NodesLukaszB
Künstliche Intelligenz
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes25
Kategorie1
Node-Typen15
Autor
Mohammed Rifad
@rifadm817Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen