# E-commerce Support Chatbot (Airtable)

**Category:** E-commerce  
**Tools:** n8n, OpenAI, Airtable  
**Nodes:** 8  
**Built by:** Forgent Systems

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

![Workflow](preview.webp)

## How it works

1. A customer sends a chat message.
2. The AI agent decides which data it needs.
3. Inventory, orders or return policy are read from Airtable.
4. A clear answer is sent back, with memory of the conversation.

## Use cases

- Online stores
- D2C brands
- Reducing repetitive support tickets

## Data setup

**Airtable** (table: fields)

- **Marketing Campaign Management → Inventory**: _(columns as used in the nodes)_
- **Marketing Campaign Management → Order Log**: _(columns as used in the nodes)_
- **Marketing Campaign Management → Return policy**: _(columns as used in the nodes)_

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Airtable account
   - OpenAI account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **AI Agent** — `@n8n/n8n-nodes-langchain.agent`
- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
- **Get_Inventory** — `n8n-nodes-base.airtableTool`
- **Get_Orders** — `n8n-nodes-base.airtableTool`
- **Get_ReturnPolicy** — `n8n-nodes-base.airtableTool`
- **When chat message received** — `@n8n/n8n-nodes-langchain.chatTrigger`
- **Simple Memory** — `@n8n/n8n-nodes-langchain.memoryBufferWindow`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
