AI Scheduling and RAG Knowledge Base Agent with GPT-5 - n8n Workflow

• Businesses needing 24/7 automated client support and appointment booking.


• Users looking for advanced n8n templates integrating LangChain agents with Google services.


• Technical users wanting to deploy an AI agent powered by an n8n node like the OpenAI GPT-5 model.


• Consultants or educators who need an automated scheduling n8n workflow that handles time zone conversion.

This sophisticated n8n workflow transforms manual scheduling and information lookup into a seamless, automated process. By leveraging the power of GPT-5 via the n8n node for AI, the agent can tap into a knowledge base (stored in Google Sheets) to answer FAQs, policies, and product details. Simultaneously, it manages availability in Google Calendar, adhering strictly to the Paris time zone for user interaction while converting to CST for backend tool calls. This powerful n8n workflow eliminates errors associated with manual data handling and time zone conversions. The final step of this n8n workflow ensures a professional confirmation email is sent via Gmail, providing an end-to-end AI agent solution deployable directly within n8n.

The core of this automation is a LangChain Agent, providing sophisticated control over external tools.

1. Initiation (n8n Trigger): The n8n workflow starts via the Chat with Your Data n8n trigger (LangChain Chat Trigger), which listens for conversational input, typically via a webhook.


2. AI Orchestration: The AI Agent Support n8n node takes the client query. It uses the OpenAI GPT-5 Model (the brain) and the Memory n8n node to maintain context. Based on the detailed system instructions (a key part of this n8n template), it determines the appropriate tool to call.


3. Knowledge Retrieval: If the query asks for company policies, services, or FAQs, the agent uses the Knowledgebase Lookup n8n node, which accesses the Google Sheets database to retrieve the answer.


4. Availability Check: If scheduling is requested, the agent uses the Calendar: Check Availability n8n node (Google Calendar) to find open slots. Crucially, this n8n workflow logic enforces user-facing times in Paris time (Europe/Paris) and performs necessary conversions to CST for the Google Calendar tool.


5. Appointment Creation: Upon explicit client confirmation, the agent executes the Calendar: Create Appointment n8n node. This creates a mandatory 1-hour appointment in Google Calendar.


6. Confirmation: After a successful booking, the Send Booking Confirmation n8n node (Gmail) is called to deliver a single, detailed confirmation email containing all booking particulars in Paris time, completing the interactive automated sequence handled by this robust n8n workflow.

To set up this advanced n8n workflow, follow these steps:

1. Import the n8n Workflow: Import the provided JSON into your n8n instance.


2. Setup Credentials: You will need to configure credentials for the following services:

1. Customize Knowledge Base: Update the Google Sheets database linked in the Knowledgebase Lookup n8n node with your specific company information, policies, and service packs. A sample n8n template is referenced in the workflow notes.


2. Activate and Test: Activate the n8n workflow. Use the connected Chat with Your Data n8n trigger webhook endpoint to test the conversation flow, asking questions about the database and requesting appointments.

• Chat with Your Data (n8n Trigger): The starting point (n8n trigger) of the workflow. It receives chat input that feeds into the AI Agent.


• AI Agent Support (LangChain Agent n8n node): The core intelligence. It coordinates the use of all tools based on a complex system prompt that dictates rules for knowledge retrieval, time zone handling (Paris to CST conversion), and scheduling.


• OpenAI GPT-5 Model (LangChain LLM n8n node): Serves as the Large Language Model engine for the AI Agent. It executes the reasoning and generates responses.


• Memory (LangChain Memory n8n node): Maintains the conversational history for continuity, allowing the agent to remember context across multiple interactions in the n8n workflow.


• Knowledgebase Lookup (Google Sheets Tool n8n node): Function: Fetches factual information from the Google Sheet knowledge base, acting as the RAG mechanism. Configuration: Configured to be called at most once per request.


• Calendar: Check Availability (Google Calendar Tool n8n node): Function: Used to check for open time slots before booking. Configuration: Accepts timeMax and timeMin dynamically derived from the AI's parsed request.


• Calendar: Create Appointment (Google Calendar Tool n8n node): Function: Creates the confirmed 1-hour booking. Configuration: Inputs like start, end, summary, and description are derived via expressions from the AI agent's final decision.


• Send Booking Confirmation (Gmail Tool n8n node): Function: Sends the final confirmation email to the client with all appointment details (in Paris time). Configuration: Subject, message content, and recipient are dynamically generated by the AI agent’s logic.