Skip to content
FlowHubFluxonLab
A
AI Automationfree

AI Agent to chat with Airtable and analyze data

by Mark Shcherbakovadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentAirtableAirtableCall n8n Workflow ToolCall n8n Workflow ToolCode ToolCode ToolHTTP RequestHTTP RequestOpenAI Chat ModelOpenAI Chat ModelSSimple Memory
Share Post Share
OpenAI Chat ModelOpenAI Chat Mod…AgAI AgentMBWindow Buffer MemoryWindow Buffer M…ChWhen chat message receivedWhen chat messa…EWExecute Workflow TriggerExecute Workflo…SeResponseSwSwitchAgAggregateAgAggregate1MeMergeAgAggregate2IfIf1SeResponse1TWSearch recordsTWProcess data with codeProcess data wi…TCCreate map imageTWGet list of basesGet list of bas…TWGet base schemaGet BasesGet Base/Tables schemaGet Base/Tables…IfIf filter description existsIf filter descr…HRAirtable - Search recordsAirtable - Sear…HROpenAI - Generate search filterOpenAI - Genera…SeSet schema and promptSet schema and …HRUpload file to get linkUpload file to …HROpenAI - Download FileOpenAI - Downlo…HROpenAI - Get messagesOpenAI - Get me…HROpenAI - Run assistantOpenAI - Run as…HROpenAI - Send messageOpenAI - Send m…HROpenAI - Create threadOpenAI - Create…12345678
1/5
FLOWS
STEPS · 8
Starts from a chat message

Video Guide I prepared a detailed guide that shows the entire process of building an AI agent that integrates with Airtable data in n8n. This template covers everything from data preparation to advanced configurations. Youtube Link Who is this for? This workflow is designed for developers, data analysts, and business owners who want to create an AI-powered conversational agent integrated with Airtable datasets. It is particularly useful for users looking to enhance data interaction through chat interfaces. What problem does this workflow solve? 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. What this workflow does 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.

Tags

n8nreference-onlyagentairtablelm-chat-open-aimemory-buffer-windowtool-codetool-workflow
Connects
AAI AgentairtableAirtablecalln8nworkflowtoolCall n8n Workflow ToolcodetoolCode ToolWHTTP RequestopenaichatmodelOpenAI Chat Model
CategoryAI Automation
Triggermanual
Complexityadvanced
Nodes30
AddedJan 6, 2025

Related workflows

See all AI Automation
AopenaichatmodelserpapigooglesearchS
free

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.

by n8n Team
Acodetoollangchaincodeopenaichatmodel
free

Custom LangChain agent written in JavaScript

This workflow has multiple functionalities. It starts with a manual trigger, "When clicking 'Execute Workflow'", that activates two separate paths. The first path takes a preset string "Tell me a joke" and processes it through a custom Language Learning Model (LLM) chain node. This node interacts with an OpenAI node for query processing. The second path takes another preset string "What year was Einstein born?" and passes it to an "Agent" node. This agent further interacts with a Chat OpenAI node and a custom Wikipedia node to produce the required information. The workflow uses both built-in and custom nodes, and integrates with OpenAI for both paths. It's built for experimenting with language models, specifically in the context of conversational agents and information retrieval. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team
AopenaichatmodelserpapigooglesearchS
free

AI chatbot that can search the web

This workflow is designed for dynamic and intelligent conversational capabilities. It incorporates OpenAI's GPT-4o model for natural language understanding and generation. Additional tools include SerpAPI and Wikipedia for enriched, data-driven responses. The workflow is triggered manually, and utilizes a 'Window Buffer Memory' to maintain the context of the last 20 interactions for better conversational continuity. All these components are orchestrated through n8n nodes, ensuring seamless interconnectivity. To use this template, you need to be on n8n version 1.50.0 or later.

by n8n Team