AlekSystem Workflow Detail

Qualify Calendly leads in Airtable with OpenAI GPT-based categorization Workflow Solution

Qualify Calendly leads in Airtable with OpenAI GPT-based categorization

Calendly Lead Qualification & AI-Powered Categorization What it's for: This automation streamlines your sales qualification process by automatically capturin...

Rank 75 Verified workflow

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Relevant for managed services and support workflows.

Calendly Lead Qualification & AI-Powered Categorization What it's for: This automation streamlines your sales qualification process by automatically capturing Calendly bookings, filtering qualified leads, and using AI to intelligently categorize the reasons prospects book discovery calls. Perfect for agencies, consultancies, or any business using Calendly for sales meetings who want to automatically organize and track lead intent in Airtable. Key Features: Automatically captures Calendly booking and cancellation events Filters leads based on qualification criteria (e.g., minimum revenue requirements) Uses OpenAI GPT to intelligently categorize booking reasons Syncs all data to Airtable for CRM management Handles both new bookings and cancellations How it works: Input: Calendly webhook triggers when someone books or cancels a meeting AlekSystem Processing Flow: Qualification Check - Validates if the lead meets your criteria (e.g., "$30k+ monthly sales") Event Type Routing - Determines if it's a new booking or cancellation New Booking Path: Creates record in Airtable with contact details, meeting time, and booking reason Fetches available categories from Airtable AI analyzes the "reason for booking" and assigns appropriate category Updates Airtable record with AI-selected category Cancellation Path: Searches for existing record in Airtable Deletes the cancelled meeting record AI Processing: OpenAI GPT-5 analyzes the prospect's stated reason for booking and matches it to predefined categories (e.g., "Uncertainty / Strategy Gap", "Scaling Issues", etc.) Output: Organized, categorized lead data in Airtable ready for sales follow-up How to use: 1. Set up Airtable Base Create an Airtable base with two tables: Table 1: "Calendly Information" with fields: Name (text) First Name (text) Last Name (text) Email (text) Phone (text) Event Name (text) Brand (text) Meeting Date (date/time) Why they booked (text) Categories (linked to Categories table) Table 2: "Categories" with fields: Name (text) - Your category names (e.g., "Uncertainty / Strategy Gap", "Performance Issues", etc.) id (auto-generated record ID) Populate the Categories table with your desired lead categories 2. Create Airtable API Credentials in AlekSystem Go to Airtable → Account → Developer Hub Create a new personal access token with scopes: data.records:read and data.records:write In AlekSystem, create new Airtable credentials and paste your token Test the connection 3. Configure Calendly Webhook Log into your Calendly account Go to Integrations → API & Webhooks Click "Create Webhook" Copy the webhook URL from the "Calendly Webhook" node in AlekSystem (click the node and copy the "Webhook URL" shown) Paste it into Calendly's webhook URL field Subscribe to these events: invitee.created invitee.canceled Save the webhook 4. Set up OpenAI Credentials Create an OpenAI account at https://platform.openai.com/ Go to API Keys section and create a new API key In AlekSystem, create new OpenAI credentials and paste your API key Ensure you have credits in your OpenAI account 5. Configure Workflow Nodes Update Airtable Node Connections: Open each Airtable node ("Get Categories", "Create a Calendly Meeting", "Update Category", "Search records", "Delete a record") Select your Airtable credentials Update the Base ID and Table ID to match your Airtable base Save each node Customize Qualification Logic: Open the "Qualified?" IF node Adjust the qualification criteria to match your Calendly question structure Current example checks: questions_and_answers[2].answer equals "Yes" Modify the array index [2] to match your qualification question's position Customize AI Category Prompt: Open the "Category Assigner" (OpenAI) node Update the system prompt to reflect your business type and categories Modify the example in the messages array to match your typical booking reasons Update Field Mappings: Open "Create a Calendly Meeting" node Adjust field mappings to match your Calendly form questions: Phone: questions_and_answers[0].answer Brand: questions_and_answers[1].answer Qualification: questions_and_answers[2].answer Why they booked: questions_and_answers[3].answer Modify array indices [0], [1], etc. to match your form structure 6. Test the Workflow Activate the workflow in AlekSystem Book a test meeting in your Calendly Answer all questions including your qualification criteria Check that: Record appears in Airtable AI assigns the correct category All fields are populated correctly Test a cancellation to ensure records are deleted properly Requirements: Calendly account** (any paid plan that supports webhooks) Airtable account** (Free tier works) OpenAI API account** with credits (GPT-5 access recommended) AlekSystem instance** (Cloud or self-hosted) Customizing this workflow: Adjust Qualification Criteria: Modify the "Qualified?" IF node to match your specific lead qualification requirements Add multiple conditions (revenue, location, industry, etc.) Add More Categories: Simply add new rows to your Airtable Categories table The AI will automatically consider them when categorizing Improve AI Accuracy: Add more examples in the "Category Assigner" node's prompt Include edge cases specific to your business Use few-shot learning by adding 2-3 example classifications Enhance Data Capture: Add more fields to the Airtable base (UTM parameters, referral source, etc.) Map additional Calendly questions to Airtable fields Add tracking fields like "Date Created", "Last Updated" Notifications: Add Slack/Email nodes after "Update Category" to notify your sales team Include the assigned category in the notification Filter notifications to only high-priority categories Multi-Language Support: Update the AI prompt to handle multiple languages Add language detection logic before categorization Advanced Routing: Add additional IF nodes to route different event types to different workflows Create separate processes for VIP leads, different product lines, etc.

Best fit

Categories

AI/MLCommunicationSales

Services

AirtableOpenAI

Use cases

sales automationsupport automationemail workflow automation