Bear Brown
← All N8N workflows
AI & researchAgentAggregateAirtableChat TriggerExecute Workflow Trigger

Replace Mapbox public key - <your_public_key> in code

Configured with Agent, Aggregate, Airtable, Chat Trigger, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗30 nodes · MIT
Workflow preview
AI & modelsOpenAI Chat ModelOpenAI Chat ModelAI & modelsAI AgentAgentData storeWindow Buffer MemoryMemory Buffer WindowTriggerWhen chat messagereceivedChat TriggerTriggerExecute WorkflowTriggerExecute Workflow TriggerTransformResponseEdit FieldsRoutingSwitchSwitchTransformAggregateAggregateTransformAggregate1AggregateTransformMergeMergeTransformAggregate2AggregateRoutingIf1IfTransformResponse1Edit FieldsSubworkflowSearch recordsTool WorkflowSubworkflowProcess data with codeTool WorkflowCodeCreate map imageTool CodeSubworkflowGet list of basesTool WorkflowSubworkflowGet base schemaTool WorkflowData storeGet BasesAirtableData storeGet Base/Tables schemaAirtableRoutingIf filter descriptionexistsIfWeb / APIAirtable - SearchrecordsHTTP RequestWeb / APIOpenAI - Generatesearch filterHTTP RequestTransformSet schema and promptEdit FieldsWeb / APIUpload file to get linkHTTP RequestWeb / APIOpenAI - Download FileHTTP RequestWeb / APIOpenAI - Get messagesHTTP RequestWeb / APIOpenAI - Run assistantHTTP RequestWeb / APIOpenAI - Send messageHTTP RequestWeb / APIOpenAI - Create threadHTTP Request

Node categories in this workflow

  • AI & models
  • Data store
  • Trigger
  • Transform
  • Routing
  • Subworkflow
  • Code
  • Web / API

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
OpenAI Chat ModelAI & modelsOpenAI Chat ModelSee node parameters
AI AgentAI & modelsAgentSee node parameters
Window Buffer MemoryData storeMemory Buffer WindowSee node parameters
When chat message receivedTriggerChat TriggerSee node parameters
Execute Workflow TriggerTriggerExecute Workflow TriggerSee node parameters
ResponseTransformEdit FieldsSee node parameters
SwitchRoutingSwitchSee node parameters
AggregateTransformAggregateSee node parameters
Aggregate1TransformAggregateSee node parameters
MergeTransformMergeSee node parameters
Aggregate2TransformAggregateSee node parameters
If1RoutingIfSee node parameters
Response1TransformEdit FieldsSee node parameters
Search recordsSubworkflowTool WorkflowSee node parameters
Process data with codeSubworkflowTool WorkflowSee node parameters
Create map imageCodeTool CodeSee node parameters
Get list of basesSubworkflowTool WorkflowSee node parameters
Get base schemaSubworkflowTool WorkflowSee node parameters
Get BasesData storeAirtablebase
Get Base/Tables schemaData storeAirtablebase / getSchema
If filter description existsRoutingIfSee node parameters
Airtable - Search recordsWeb / APIHTTP RequestPOST
OpenAI - Generate search filterWeb / APIHTTP RequestPOST
Set schema and promptTransformEdit FieldsSee node parameters
Upload file to get linkWeb / APIHTTP RequestPOST
OpenAI - Download FileWeb / APIHTTP RequestSee node parameters
OpenAI - Get messagesWeb / APIHTTP RequestSee node parameters
OpenAI - Run assistantWeb / APIHTTP RequestPOST
OpenAI - Send messageWeb / APIHTTP RequestPOST
OpenAI - Create threadWeb / APIHTTP RequestPOST

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • airtableTokenApi
  • httpQueryAuth
  • openAiApi

Workflow notes

... or watch set up video [20 min]

... or watch set up video [20 min]

AI Agent to chat with Airtable and analyze data

AI Agent to chat with Airtable and analyze data

Made by Mark Shcherbakov from community 5minAI

Engaging with data stored in Airtable often requires manual navigation and time-consuming searches. This workflow allows users to interact conversationally with their datasets, retrieving essential information quickly while minimizing the need for complex queries.

This workflow enables an AI agent to facilitate chat interactions over Airtable data. The agent can:

  • Retrieve order records, product details, and other relevant data.
  • Execute mathematical functions to analyze data such as calculating averages and totals.
  • Optionally generate maps for geographic data visualization.
  1. Dynamic Data Retrieval: The agent uses user prompts to dynamically query the dataset.
  2. Memory Management: It retains context during conversations, allowing users to engage in a more natural dialogue.
  3. Search and Filter Capabilities: Users can perform tailored searches with specific parameters or filters to refine their results.
Set up steps

Set up steps

  1. Separate workflows:

    • Create additional workflow and move there Workflow 2.

  2. Replace credentials:

    • Replace connections and credentials in all nodes.

  3. Start chat:

    • Ask questions and don't forget to mention required base name.
Replace Mapbox public key - <your_public_key> in code

Replace Mapbox public key - <your_public_key> in code

Purpose and structure

This folder contains the Replace Mapbox public key - <your_public_key> in code workflow. Its executable nodes use agent, aggregate, airtable, chatTrigger, executeWorkflowTrigger, httpRequest, if, lmChatOpenAi, memoryBufferWindow, merge, set, switch, toolCode, toolWorkflow. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When chat message received, Execute Workflow Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Aggregate/0681_Aggregate_HTTP_Create_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Replace Mapbox public key - <your_public_key> in code
  • Replace OpenAI connection
  • Replace Airtable connection
  • Workflow 1
  • Workflow 2

More in AI & research

"Hey Siri, Ask Agent" workflow#️⃣Nostr #damus AI Powered Reporting + Gmail + Telegram(G) - Email Classification