receive twilio events and search airtable tool and getschema base airtable tool
Configured with Agent, Airtable, Airtable Tool, OpenAI Chat Model, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Trigger
- Data store
- Transform
- Messaging
- AI & models
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| Twilio Trigger | Trigger | Twilio Trigger | See node parameters |
| Search Available Courses | Data store | Airtable Tool | search |
| Get Course Database Schema | Data store | Airtable Tool | base / getSchema |
| Get User Message | Transform | Edit Fields | See node parameters |
| Send SMS reply | Messaging | Twilio | See node parameters |
| Append to Call Log | Data store | Airtable | create |
| Course Assistant Agent | AI & models | Agent | See node parameters |
| Get List of Professors | Data store | Airtable Tool | search |
| Get List of Departments | Data store | Airtable Tool | search |
| Model | AI & models | OpenAI Chat Model | See node parameters |
| Memory | Data store | Memory Buffer Window | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
airtableTokenApiopenAiApitwilioApi
Workflow notes
Try It Out!
Try It Out!
This n8n template offers a simple yet capable chatbot assistant who can answer course enquiries over SMS.
Given the right access to data, AI Agents are capable of planning and performing relatively complex research tasks to get their answers. In this example, the agent must first understand the database schema, retrieve lists of values before generating it's own query to search over the database.
Checkout the example database here - https://airtable.com/appO5xvP1aUBYKyJ7/shr8jSFDaghubDOrw
How it works
- A Twilio trigger gives us the ability to receive SMS input into our workflow via webhook.
- The message is then directed to our AI agent who is instructed to assist the user and use the course database as reference. The database is an Airtable base.
- The agent autonomously figures out which tool it needs to use and generates it's own "filter_by_formula" query to search over the available courses.
- On successful search results, the Agent can then use this information to answer the user's query.
- The Agent's output is logged in a second sheet of the Airtable base. We can use this later for analysis and lead gen.
- Finally, the response is sent back to the user through SMS using Twilio.
How to use
- Ensure your Twilio number is set to forward messages to this workflow's webhook URL.
- Configure and update the course database as required. If you're not interested in courses, you can swap this out for inventory, deliveries or any other data relevant to your business.
- Ask questions like:
- "Can you help me find suitable courses to fill my Wednesday mornings?"
- "Which courses are being instructed by profession Lee?"
- "I'm interested in creative arts. What courses are available which could be relevant to me?"
Requirements
- Twilio for SMS receiving and sending
- OpenAI for LLM and Agent
- Airtable for Course Database
Customising this workflow
- Add additional tools and expand the range of queries the agent is able to answer or assist with.
- Not using Airtable? This technique also works with SQL databases like PostgreSQL.
Need Help?
Join the Discord or ask in the Forum!
Happy Hacking!
receive twilio events and search airtable tool and getschema base airtable tool
receive twilio events and search airtable tool and getschema base airtable tool
Purpose and structure
This folder contains the receive twilio events and search airtable tool and getschema base airtable tool workflow. Its executable nodes use agent, airtable, airtableTool, lmChatOpenAi, memoryBufferWindow, set, twilio, twilioTrigger. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
Twilio Trigger
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Twilio/0841_Twilio_Stickynote_Send_Triggered.json MIT; preserve source notices.