LLM Customer Service Automation: Order Tracking, Delivery Support, and Scheduling

This workflow automates customer service for order and delivery support via a chat interface, using OpenAI for AI responses, Airtable for order management, Supabase for a knowledge base, and Google Calendar for scheduling. Key nodes include Chat Trigger for input, Condition for validation, Agent for AI processing, Airtable for ticket creation, and Google Calendar for meetings. To set up, install n8n from n8n.io for self-hosting or sign up at cloud.n8n.io for cloud hosting. Create an OpenAI API key at platform.openai.com for Agent and Knowledge AI nodes. Obtain an Airtable personal access token from airtable.com. Set up a Supabase project at supabase.com for vector storage, and get API credentials. Configure Google Calendar OAuth2 credentials at console.cloud.google.com. Import the workflow JSON into n8n. Add OpenAI API key to OpenAI and Knowledge AI nodes, Airtable token to Airtable nodes (Order Lookup, Ticket Creator), Supabase credentials to Vector Store, and Google Calendar credentials to Meeting Scheduler. Copy the Chat Trigger’s webhook URL and configure it in your chat platform (e.g., Telegram via BotFather with /setwebhook). Ensure Condition node validates chat input, and Airtable nodes use correct base and table IDs. Test by sending a customer query (e.g., “Track order 12345”) via the chat platform. Verify the Agent node responds with order details or creates a ticket in Airtable. Check Google Calendar for scheduled meetings if requested. Confirm the Success Handler node outputs a success message with timestamp. Handle errors like invalid Airtable tokens (HTTP 401), missing chat input (Error Handler triggers), or incorrect tracking numbers (no order found). Regenerate credentials if needed. Deploy by activating the workflow in n8n, ensuring the webhook is live. Monitor logs for API rate limits or Supabase query failures. Validate output for accurate order details, ticket creation in Airtable, or meeting confirmation in Google Calendar, with professional formatting and branding.