Back/Operations/n8n/Airtable
AdvancedOperationsn8nAirtable

How to Build a Low-Code AI Concierge with Airtable, n8n, and Twilio

Build a custom AI agent that interacts with users via SMS to perform tasks like matchmaking or scheduling. This advanced workflow uses a low-code stack to connect a database (Airtable), an automation engine (n8n), and a messaging API (Twilio).

From How I AI

How I AI: Building a Real-World Business with Andrew Mason & Nabil Hyatt

with Claire Vo

How to Build a Low-Code AI Concierge with Airtable, n8n, and Twilio

Tools Used

n8n

Workflow automation platform

Airtable

Cloud-based database and spreadsheet tool

Step-by-Step Guide

1

Design the AI-Ready Tech Stack

Set up the three core components. Use Airtable as the database for all business data (users, reservations, etc.), n8n as the workflow automation backend (the agent's brain), and Twilio as the user interface (the SMS phone number).

2

Structure Your Airtable Base for AI

When designing your Airtable base, use flexible free-text fields for user preferences like 'gaming preferences' or 'availability'. This structure is much easier for a large language model to understand and parse compared to rigid, structured data.

Pro Tip: Thinking about how an AI will read your data from the very beginning makes building the agentic workflow much simpler.
3

Build the Agentic Workflow in n8n

Create a new workflow in n8n that triggers when Twilio receives a message. The workflow should first use the sender's phone number to look up the user in your Airtable members table. Then, it passes the user's message to a central AI agent node within n8n.

4

Define Agent 'Tools' for Airtable

Give your AI agent in n8n a set of 'tools,' which are simply functions that allow it to interact with your Airtable base. These tools can include actions like create_record, get_records, or update_record.

5

Write a Plain-English System Prompt

Configure the AI agent with a system prompt written in plain English. This prompt should explain the agent's purpose, what it should do, and how to use the available tools. The agent will then interpret user requests and figure out which tool to use on its own.

Pro Tip: As Andrew Mason noted, 'You're just literally writing down what you think it should go do, and then it'll figure out how to find the function and use it.'
6

Connect Twilio to Receive User Requests

In Twilio, configure your phone number to send an HTTP request to the n8n workflow's webhook URL whenever it receives an SMS. This final step connects your user interface to the agent's brain, making the concierge live.

Prompt:
Hey, can you set up a game for me anytime this weekend? Maybe a deck building game.

Become a 10x PM.
For just $5 / month.

We've made ChatPRD affordable so everyone from engineers to founders to Chief Product Officers can benefit from an AI PM.