E-commerce Support Chatbot (Airtable)
A 24/7 store assistant that answers product availability, order status and return-policy questions using live data from Airtable.

On this page
How it works
- A customer sends a chat message.
- The AI agent decides which data it needs.
- Inventory, orders or return policy are read from Airtable.
- A clear answer is sent back, with memory of the conversation.
Use cases
- Online stores
- D2C brands
- Reducing repetitive support tickets
What you need
This workflow connects to these apps.
- n8n
- OpenAI
- Airtable
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- Airtable account
- OpenAI account
Data setup
Create these tables with these exact column names before the first run.
| Table | Columns |
|---|---|
| Marketing Campaign Management → InventoryAirtable | Columns are in the README. |
| Marketing Campaign Management → Order LogAirtable | Columns are in the README. |
| Marketing Campaign Management → Return policyAirtable | Columns are in the README. |
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| AI Agent | agent |
| OpenAI Chat Model | lmChatOpenAi |
| Get_Inventory | airtableTool |
| Get_Orders | airtableTool |
| Get_ReturnPolicy | airtableTool |
| When chat message received | chatTrigger |
| Simple Memory | memoryBufferWindow |
Frequently asked questions
A 24/7 store assistant that answers product availability, order status and return-policy questions using live data from Airtable. It's a 8-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for Airtable and OpenAI. It uses only nodes that ship with n8n, so there's nothing else to install.
It works with 3 tables in Airtable. Create them with the column names listed under Data setup on this page before the first run.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



