E-commerce

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.

The E-commerce Support Chatbot (Airtable) workflow on the n8n canvas, with its 8 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
E-commerce
Nodes
8
Apps
OpenAI, Airtable
Price
Free
Download JSON
On this page

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

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.

TableColumns
Marketing Campaign Management → InventoryAirtableColumns are in the README.
Marketing Campaign Management → Order LogAirtableColumns are in the README.
Marketing Campaign Management → Return policyAirtableColumns are in the README.

Setup

  1. 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.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. 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

NodeType
AI Agentagent
OpenAI Chat ModellmChatOpenAi
Get_InventoryairtableTool
Get_OrdersairtableTool
Get_ReturnPolicyairtableTool
When chat message receivedchatTrigger
Simple MemorymemoryBufferWindow

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.

Keep exploring
  • n8n canvas of the AI Shopify Product Builder with Review workflow

    E-commerce37 nodes

    AI Shopify Product Builder with Review

    Creates complete Shopify products from a photo or a brief. AI writes the copy, generates images and saves everything for review, and approved products are published automatically.

  • n8n canvas of the Product Image to 3D Video Generator workflow

    E-commerce21 nodes

    Product Image to 3D Video Generator

    Turns one product photo into a polished 3D showcase video. The background is removed automatically, an AI video model renders the clip, and every asset is organized in Google Drive and logged in a sheet.

  • n8n canvas of the Shopify Low-Stock Email Alert workflow

    E-commerce4 nodes

    Shopify Low-Stock Email Alert

    Checks Shopify inventory on a schedule and emails the team when any product falls below your threshold.