{"product_id":"line-oa-appointment-booking-automation-with-n8n-openai","title":"LINE OA Appointment Booking Automation with n8n + OpenAI","description":"\u003ch3\u003eBook appointments on LINE automatically—using n8n + OpenAI + Google Calendar\u003c\/h3\u003e\n\u003cp\u003eThis LINE Official Account appointment booking automation lets customers schedule, reschedule, or cancel appointments by messaging your LINE OA. It uses OpenAI to understand booking requests, checks availability in Google Calendar, logs results to Google Sheets, and sends automated LINE confirmations and reminders.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives LINE messages via webhook\u003c\/strong\u003e and verifies the request signature before responding with a \u003cstrong\u003e200\u003c\/strong\u003e for valid events.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUnderstands customer intent with OpenAI\u003c\/strong\u003e: splits the webhook payload into individual text messages, then extracts whether the customer wants to \u003cem\u003ebook\u003c\/em\u003e, \u003cem\u003ecancel\u003c\/em\u003e, or \u003cem\u003ereschedule\u003c\/em\u003e, plus the booking details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates service + time against opening hours\u003c\/strong\u003e. If required info is missing, the workflow asks follow-up questions in LINE.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks availability in Google Calendar\u003c\/strong\u003e for the requested day. If the time is taken, it replies with up to \u003cstrong\u003ethree alternative time options\u003c\/strong\u003e using LINE quick-reply buttons.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates\/updates appointments\u003c\/strong\u003e in Google Calendar when a slot is available, and logs booking status + metadata to a Google Sheets \u003cstrong\u003e“Bookings”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends confirmations and handles cancellations\u003c\/strong\u003e: confirms the appointment in LINE (and triggers an owner alert for new bookings). For cancellation requests, it deletes the calendar event and updates the booking as cancelled.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly reminders\u003c\/strong\u003e: checks Google Sheets for bookings starting within the next \u003cstrong\u003e24 hours\u003c\/strong\u003e, sends LINE reminders, and marks bookings as reminded.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA clinic or salon where clients message LINE to book\/reschedule appointments without calling.\u003c\/li\u003e\n  \u003cli\u003eA service business that needs real-time scheduling with opening-hours validation.\u003c\/li\u003e\n  \u003cli\u003eOperations teams that want reminders automatically pushed through LINE before appointments.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow logic\/nodes:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLINE:\u003c\/strong\u003e webhook events + signature verification (Channel access tokens required)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI:\u003c\/strong\u003e extracts intent and booking details from LINE text\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar:\u003c\/strong\u003e availability checks + create\/update\/delete events\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e logs bookings to the “Bookings” tab and tracks reminder status\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e In the LINE Developers Console, enable webhooks and generate a Channel access token.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46289185013939,"sku":"N8N-21620","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Oqb6hevQr75We4Z6j3mq__zrricu7X.png?v=1793006509","url":"https:\/\/buyflowscripts.com\/products\/line-oa-appointment-booking-automation-with-n8n-openai","provider":"N8N Commerce","version":"1.0","type":"link"}