💬 Automate HVAC service scheduling with AI agent, Google Calendar and Gmail

⚡ 976 views · 💬 Support Chatbots

Description

Instant, automated scheduling. This AI Scheduling Agent manages real-time appointments, availability checks, and rescheduling across Google Calendar and Sheets, eliminating human hold times.

🎯 Problem Statement

Traditional call center or online booking systems often lack the flexibility to handle complex, multi-step customer requests like rescheduling, checking dynamic availability across multiple time slots, or handling context-aware conversational booking. This leads to friction, missed bookings, and high administrative overhead for service companies like HVAC providers.

✨ Solution

This workflow deploys a sophisticated AI Scheduling Agent that acts as a virtual receptionist. It uses the Language Model’s (LLM) “tool-use” capability to intelligently execute complex, sequential business logic (e.g., check availability before booking, find existing events before rescheduling) and manages the entire lifecycle of a service appointment, from initial inquiry to final confirmation.

⚙️ How It Works (Multi-Step Execution)

  1. Trigger: A customer request (e.g., from an external voice or text platform) hits the Webhook Trigger with intent details (e.g., tool_request: ‘reschedule_appointment’).

  2. Agent Logic: The Receptionist Agent uses a strict system prompt and its internal tools to formulate an execution plan. It maintains conversational state via the simple-memory node.

  3. Tool Execution (Example: Reschedule): The Agent executes a predefined sequence of private tools:

    • find_old_event: Locates the existing booking ID using the customer’s email.

    • check_calendar: Verifies the proposed new time is available (2-hour window).

    • reschedule_appointment: Updates the calendar event.

    • log_lead: Updates the central Google Sheet.

  4. Synchronous Response: The Agent sends a confirmation or follow-up question via the respond_to_webhook node.

  5. Asynchronous Confirmation: The log_lead action triggers a secondary workflow that composes a professional email via a second LLM (Anthropic) and sends it to the customer via Gmail, followed by an internal alert via Google Chat.

🛠️ Setup Steps

  1. Credentials:

    • AI/LLM: Configure credentials for the Language Model used (OpenAI or Gemini) for the core Agent.

    • Google Services: Set up OAuth2 credentials for Google Calendar (for booking/checking), Google Sheets (for logging), and Gmail (for customer confirmation).

  2. Google Calendar: Specify the technician’s calendar ID (bhuvaneshx13@gmail.com in the template) in all Calendar nodes.

  3. Google Sheets: Create a new Google Sheet to serve as the Lead Log and update the Document ID and Sheet Name in the log_lead and log_lead_trigger nodes.

  4. Tool Configuration: Review and customize the Agent’s system prompt in the Receptionist node to align time zone rules (currently Asia/Kolkata - IST) and business hours (9:00 AM to 6:00 PM) with your operations.

✅ Benefits

  1. Increased Efficiency: Fully automates complex scheduling and rescheduling, freeing up human staff.

  2. Contextual Service: AI handles multi-turn conversations and adheres to strict business rules (e.g., 2-hour slots, maximum tool usage).

  3. Data Integrity: Ensures all bookings are immediately logged to Google Sheets, maintaining a centralized record (CRM).

  4. Professional Flow: Provides immediate confirmation to the customer via email and instant notification to the internal team via chat.

🚀 Other Use Cases

The underlying multi-step, tool-execution pattern is highly versatile and can be adapted for any service industry requiring complex, rules-based scheduling:

🔗 Nodes Used

Webhook, Gmail, Google Chat, Google Sheets Trigger, AI Agent, OpenAI Chat Model

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup