This workflow acts as an intelligent personal assistant to automatically manage appointment scheduling via a website chatbot. It uses OpenAI’s conversational AI with Microsoft Outlook Calendar to check availability, propose time slots, and confirm bookings—all while ensuring no double-bookings. Customers can also leave enquiries, which are forwarded by email if they’re not ready to schedule a meeting.
Key Features:
- 🔄 Event-driven automation — reacts to Airtable row updates, new fields, and schema changes.
- 📂 PDF text extraction — automatically retrieves and parses PDF file contents.
- 🤖 AI-powered data extraction — uses OpenAI LLMs with dynamic prompts defined in Airtable field descriptions.
- 🧩 Dynamic schema mapping — maps extracted values into the correct Airtable fields based on field type and description.
- ⚡ Optimized performance — only updates necessary rows/fields, preventing redundant processing.
- 🔗 Reusable setup — can be adapted for different Airtable bases/tables with minimal changes.
- 🎛️ Webhook integration — keeps Airtable and n8n workflows in sync in real-time.
