Mohammed Rifad This workflow corresponds to n8n.io template #2932 — we link there as the canonical source.
This workflow follows the Agent → Chainllm recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "EbTFAsvfdJZBB3J5",
"meta": {
"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": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b3debcb8-18bc-4eb5-8df1-64a5d532b8ce",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "65e9ed23-f01a-4a9e-b262-328e7b97cc8d",
"name": "Sticky Note2",
"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": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1400,
-1700
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e0dce744-c592-45b1-a81f-5abe9f47e2bc",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6fe8fe1-459c-441e-ae65-7433da62b4a8",
"name": "When chat message received",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-140,
-1260
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "03dcef04-4a4c-48ab-b6f6-03b294fd83c2",
"name": "Sticky Note5",
"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": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-1240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "61b16043-6f64-44f7-91d8-b2500ce6a1b8",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7c9f2bd9-7f43-408f-95e3-0f9ab3c092ca",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-1440
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "376d90d3-0560-4d3a-a1b1-0436fac53325",
"connections": {
"Limit": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"AppSheet": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Cohere Rerank",
"type": "main",
"index": 0
}
]
]
},
"GetHeaders": {
"ai_tool": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_tool",
"index": 0
}
]
]
},
"Cohere Rerank": {
"main": [
[
{
"node": "AggregateRanked",
"type": "main",
"index": 0
}
]
]
},
"AggregateRanked": {
"main": [
[
{
"node": "Final Reranked Output",
"type": "main",
"index": 0
}
]
]
},
"CallAppsheetAPI": {
"ai_tool": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_tool",
"index": 0
}
]
]
},
"GetListOfWorksheets": {
"ai_tool": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_tool",
"index": 0
}
]
]
},
"Anthropic Chat Model": {
"ai_languageModel": [
[
{
"node": "Appsheet Schema Analyser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Final Reranked Output": {
"main": [
[]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Cleanup and structure the input",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Cleanup and structure the input",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Appsheet Schema Analyser",
"type": "main",
"index": 0
}
]
]
},
"Cleanup and structure the input": {
"main": [
[
{
"node": "AppSheet",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Cleanup and structure the input",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
A friendly, practical tool that makes working with AppSheet data simpler and more efficient. This workflow is your go-to helper for building precise queries without getting lost in a sea of different tables.
Source: https://n8n.io/workflows/2932/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Content - Newsletter Agent. Uses formTrigger, chainLlm, outputParserStructured, httpRequest. Event-driven trigger; 91 nodes.
Form Trigger, Chain Llm, Output Parser Structured +8
How it Works
Memory Buffer Window, Agent, Output Parser Structured +9
The best content automation template in the market is now even better—with “deep research” on time-sensitive topics\! Unlike most n8n content automation templates that are mainly for “demo purposes,”
OpenAI, HTTP Request, XML +11
Typeform IA - YT. Uses typeformTrigger, agent, lmChatOpenAi, toolWorkflow. Event-driven trigger; 75 nodes.
Typeform Trigger, Agent, OpenAI Chat +7
Agent Nodes. Uses lmChatOpenAi, slack, stopAndError, errorTrigger. Event-driven trigger; 72 nodes.
OpenAI Chat, Slack, Stop And Error +12