{"product_id":"openai-chat-receptionist-for-n8n-google-calendar-sheets-booking","title":"OpenAI Chat Receptionist for n8n: Google Calendar \u0026 Sheets Booking","description":"\u003ch3\u003eLet OpenAI answer your customers—then book them automatically in Google Calendar \u0026amp; Sheets\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eOpenAI Chat Receptionist for n8n: Google Calendar \u0026amp; Sheets Booking\u003c\/strong\u003e is a public chat receptionist workflow that uses an OpenAI GPT-4o-mini agent with a RAG-style knowledge base to answer customer questions and handle bookings. It checks availability in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, confirms appointments, logs them to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and escalates complaints or disputes via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your business info on demand:\u003c\/strong\u003e When run manually, it ingests your “services, prices, and policy” text, splits it into chunks, generates \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e, and stores them in an \u003cstrong\u003ein-memory vector index\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChats with customers in a public reception interface:\u003c\/strong\u003e Incoming customer messages from a \u003cstrong\u003epublic chat trigger\u003c\/strong\u003e are sent to a \u003cstrong\u003eGPT-4o-mini\u003c\/strong\u003e agent with \u003cstrong\u003e12-message conversation memory\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnswers using retrieved facts (no guessing):\u003c\/strong\u003e The workflow retrieves relevant information (services, pricing, hours, area, payment, warranty, and booking policy) using embedding-based search so the agent can respond accurately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBooks appointments automatically:\u003c\/strong\u003e If a customer wants to book, it checks the \u003cstrong\u003enext 7 days\u003c\/strong\u003e in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e and proposes appointment options based on free slots.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirms and records bookings:\u003c\/strong\u003e After the customer agrees, it appends the booking details (job, slot, contact info, and address) to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates upset customers to a human:\u003c\/strong\u003e For complaints, disputes, safety\/legal issues, or generally upset customers, it emails an escalation summary to the owner via \u003cstrong\u003eGmail\u003c\/strong\u003e and informs the customer that a human will follow up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal service businesses that need an always-on chat receptionist with booking support\u003c\/li\u003e\n  \u003cli\u003eConsulting\/appointment providers collecting address and contact details and logging bookings to Sheets\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a customer-facing n8n chatbot with OpenAI-powered FAQ\/RAG responses\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI:\u003c\/strong\u003e GPT-4o-mini chat model + embedding nodes (embedding model used consistently for indexing and retrieval)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e Manual Trigger, n8n8n-nodes-langchainagent (LangChain agent), Google Calendar availability checks, Google Sheets appending, Gmail escalation, Set, Sticky Note\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cem\u003eBest practice:\u003c\/em\u003e Replace the sample “services, prices and policies” text with your real business information to power accurate RAG responses.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938184978611,"sku":"N8N-19041","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CpVGuSsTcYAAFXkc0VWcH_pNqpu9NR.png?v=1788340025","url":"https:\/\/buyflowscripts.com\/products\/openai-chat-receptionist-for-n8n-google-calendar-sheets-booking","provider":"N8N Commerce","version":"1.0","type":"link"}