AI Virtual Receptionist Booking System with Google Calendar & Sheets - n8n Workflow

• Businesses needing 24/7 customer service and appointment scheduling.


• Developers looking for advanced n8n templates integrating AI agents and multiple data sources.


• Operations managers aiming to reduce administrative load through automation.


• Users interested in leveraging the LangChain agent n8n node capabilities.

Scheduling appointments and managing customer inquiries can be time-consuming. This comprehensive n8n workflow solves this problem by deploying an intelligent AI receptionist powered by a LangChain Agent. This specific n8n workflow template seamlessly integrates OpenAI (GPT-4.1-mini) with Google Sheets for business context and Google Calendar for real-time booking and availability checks.

By leveraging the advanced capabilities of the n8n agent framework, this automation ensures customers receive personalized, context-aware responses, and appointments are accurately booked and recorded automatically. This allows staff to focus on core tasks, providing a high-quality, always-on customer experience managed entirely within the n8n platform.

This powerful n8n workflow starts with a chat message input and proceeds through several logical steps:

1. Trigger and Context Retrieval: The n8n trigger, When chat message received, initiates the process upon receiving a customer chat input. Immediately, the workflow uses the Get business details n8n node to pull all necessary context (services, hours, AI personality, policies) from a designated Google Sheet.


2. AI Agent Activation: The core component, the AI Receptionist (a LangChain Agent n8n node), receives the user's message and the business context. It also utilizes the Conversation Memory n8n node to remember previous interactions.


3. Decision Making & Tool Use: Based on the conversation, the AI decides whether to simply answer the question or proceed with booking. If booking is required, it uses its defined tools:

1. Response Generation: The AI generates a structured reply (e.g., confirmation or follow-up question) which is then passed back to the chat platform, completing the lifecycle of this complex n8n workflow.

To deploy this n8n workflow template, follow these steps:

1. Import the JSON: Copy the provided JSON data and paste it into your n8n instance using the 'New' menu > 'Import from JSON'.


2. Set up Credentials: Several n8n nodes require credentials:

1. Configure Spreadsheets: Ensure your Google Sheets document ('Bussiness details') is set up with tabs containing the business context (Sheet1) and a logging sheet (Sheet2/Sheet ID 1454968607) with columns matching the data fields defined in the Save Appointment Record n8n node (e.g., patient name, patient number, services, summary).


2. Activate Trigger: Activate the When chat message received n8n trigger to put the n8n workflow live and ready to receive chat inputs.

When chat message received (n8n trigger): The starting point of the n8n workflow. It monitors for incoming chat messages to begin the receptionist interaction.
Get business details (Google Sheets n8n node): Reads business context (services, hours, AI persona, policies) from a specified Google Sheet. This data is dynamically inserted into the Agent's system prompt.
AI Receptionist (LangChain Agent n8n node): The core intelligence. It coordinates the conversation, maintains memory (Conversation Memory), utilizes the gpt-4.1-mini LLM (OpenAI Chat Model), and selects the appropriate tool (Google Calendar or Google Sheets) based on the user's intent.
Conversation Memory (Memory Buffer Window n8n node): Maintains the context of the ongoing conversation, allowing the AI to reference previous turns (set to a 15-turn context window).
Check Calendar Availability (Google Calendar n8n node): Acts as a tool for the AI. It uses expressions ($fromAI) to take dates and times extracted by the AI agent and query the Google Calendar for free slots.
Book Calendar Appointment (Google Calendar n8n node): The booking tool. It creates the calendar event using event details, start/end times, and summaries dynamically provided by the AI agent via the $fromAI utility.

• Save Appointment Record (Google Sheets n8n node): Logs the successful appointment details (summary, patient info) by appending a new row to a designated logging sheet, ensuring data persistence for this n8n workflow.