Video notes & templates (free): Lead Form
Try n8n for free: AI Workflow Automation Platform & Tools - n8n
Learn to build AI automations on top of Airtable using n8n without any coding. This tutorial covers daily email reports, an AI research agent, a conversational AI agent, and MCP server integration with ChatGPT and voice assistants.
Book a Free Consultation: Book a Call - SmoothWork
[email protected]
This comprehensive tutorial demonstrates how to create powerful AI automations and agents using your Airtable data through n8n’s no-code workflow platform. You’ll learn to build four progressively advanced examples that showcase the potential of combining Airtable with AI capabilities.
The tutorial begins with setting up the connection between n8n and Airtable using a Personal Access Token with the proper scopes. The first automation creates a daily email report that automatically sends a formatted table of new contacts added to your database, using scheduled triggers and HTML formatting.
The second example builds an AI company research agent that automatically triggers when new companies are added to your Airtable base. This agent uses OpenAI to search the web for information about the company, then structures the results using JSON schema and updates the Airtable record with the website and a summary of activities.
The third automation creates an interactive AI agent you can chat with to query your Airtable data. This agent uses multiple Airtable tools to search different tables and can answer complex questions by reasoning through the steps needed and combining data from multiple sources.
The final section demonstrates how to expose these AI capabilities as an MCP server, allowing you to connect your Airtable automations to external tools like ChatGPT or voice AI platforms like Vapi. This enables you to query your private Airtable data directly through conversational interfaces.
Throughout the tutorial, you’ll learn key concepts like filtering records with Airtable formulas, structuring AI outputs with JSON schema, connecting multiple tools to AI agents, and creating production-ready endpoints for external integrations. All of this is accomplished without writing a single line of code, making advanced AI automation accessible to everyone.
==== Timestamps ====
0:00 Introduction: Airtable AI Automations with n8n
0:38 How to Set Up Airtable Connection in n8n
1:44 Airtable Agent 1 - Send Daily Email Report from Airtable data with n8n
4:08 AI Agent 2 - Company Research Agent with Airtable Trigger
9:08 AI Agent 3 - AI Agent to Chat with Airtable Data
11:22 How to Build An Airtable MCP Server
13:18 Conclusion
