Curated

(5/5)

AI Agent to chat with Airtable and analyze data

Replace Mapbox public key - <yourpublickey> in code

Integrations Used (9)

Workflow Structure (30 nodes)

100%

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.chat Trigger

When chat message received

Langchain.memory Buffer Window

Window Buffer Memory

Langchain.agent

AI Agent

Langchain.tool Workflow

Get list of bases

Langchain.tool Workflow

Get base schema

Langchain.tool Workflow

Search records

Langchain.tool Workflow

Process data with code

Langchain.tool Code

Create map image

Execute Workflow Trigger

Switch

If filter description exists

Http Request

OpenAI - Create thread

Set

Set schema and prompt

Http Request

OpenAI - Send message

Airtable

Get Bases

Airtable

Get Base/Tables schema

Http Request

OpenAI - Generate search filter

Http Request

OpenAI - Run assistant

Aggregate

Aggregate1

Merge

Http Request

OpenAI - Get messages

Http Request

Airtable - Search records

If1

Aggregate

Aggregate2

Http Request

OpenAI - Download File

Http Request

Upload file to get link

Set

Response

Set

Response1

Node Types:

default

trigger

transform

logic

code

action

http

Requires credentials

Prerequisites

Required Credentials (3)

Airtable Token

Used by: Get Bases, Get Base/Tables schema +1 more

Docs

Http Query Auth

Used by: Airtable - Search records

Docs

OpenAI

Used by: OpenAI Chat Model, OpenAI - Generate search filter +5 more

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~50 min

Score: 78/100

Custom Code

Conditional Logic

4 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "nodes": [
    {
      "id": "799d2e0c-29b9-494c-b11a-d79c7ed4a06d",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        920,
        480
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "zJhr5piyEwVnWtaI",
          "name": "OpenAi club"
        }
      },
      "typeVersion": 1
...