{"product_id":"n8n-vip-concierge-google-sheets-table-reservations-w-gemini","title":"n8n VIP Concierge: Google Sheets Table Reservations w\/ Gemini","description":"\u003ch3\u003eTurn your Google Sheets into a VIP table-booking concierge—powered by n8n + Gemini\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003en8n VIP Concierge: Google Sheets Table Reservations w\/ Gemini\u003c\/strong\u003e is a chat-based workflow that answers venue questions and confirms VIP table reservations using \u003cstrong\u003elive data from Google Sheets\u003c\/strong\u003e. It selects an available table, shows a booking summary, waits for explicit guest confirmation, then appends exactly \u003cstrong\u003eone CONFIRMED reservation\u003c\/strong\u003e to your \u003cstrong\u003eReservations\u003c\/strong\u003e sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives a guest message through \u003cstrong\u003en8n Chat\u003c\/strong\u003e and loads your configured \u003cstrong\u003eGoogle Sheets spreadsheet ID\u003c\/strong\u003e and \u003cstrong\u003evenueTimezone (IANA format)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenRouter (Gemini model)\u003c\/strong\u003e with short-term conversation memory to interpret requests and follow a \u003cstrong\u003econfirmation-first\u003c\/strong\u003e booking flow.\u003c\/li\u003e\n  \u003cli\u003eReads from Google Sheets to answer questions using live information, including \u003cstrong\u003evenue policies and hours\u003c\/strong\u003e, \u003cstrong\u003etable list and capacities\u003c\/strong\u003e, \u003cstrong\u003ebottle inventory\u003c\/strong\u003e, \u003cstrong\u003eupcoming events\u003c\/strong\u003e, and \u003cstrong\u003eexisting reservations\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor reservation requests, selects a table that fits the party size and presents the \u003cstrong\u003etime block\u003c\/strong\u003e, \u003cstrong\u003earrival cutoff\u003c\/strong\u003e, \u003cstrong\u003ezone\u003c\/strong\u003e, \u003cstrong\u003eminimum spend\u003c\/strong\u003e, and available \u003cstrong\u003ebottle options\u003c\/strong\u003e from the sheet.\u003c\/li\u003e\n  \u003cli\u003eCollects guest contact details and notes, then shows a final booking summary and waits for \u003cstrong\u003eexplicit confirmation\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAfter confirmation, rechecks \u003cstrong\u003etable availability\u003c\/strong\u003e, \u003cstrong\u003eexisting bookings\u003c\/strong\u003e, and \u003cstrong\u003ebottle inventory\u003c\/strong\u003e, then appends exactly \u003cstrong\u003eone\u003c\/strong\u003e confirmed entry to the \u003cstrong\u003eReservations\u003c\/strong\u003e sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVIP guest outreach: handle questions about hours, policies, bottle options, and minimum spend instantly.\u003c\/li\u003e\n  \u003cli\u003eHigh-demand nights: reduce booking friction by confirming reservations only after guest approval.\u003c\/li\u003e\n  \u003cli\u003eOperators using Google Sheets: keep tables, inventory, and bookings synchronized without building a full app.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8nn8n-nodes-langchainchat trigger\u003c\/strong\u003e for chat input\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8nn8n-nodes-langchainlm chat open router\u003c\/strong\u003e (Gemini via OpenRouter) with short-term memory\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003egoogle sheets tool\u003c\/strong\u003e for reading live tables\/events\/inventory\/reservations and appending the confirmed booking\u003c\/li\u003e\n  \u003cli\u003eAdditional workflow nodes including \u003cstrong\u003eset\u003c\/strong\u003e and \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Copy the provided Google Sheets template, paste your \u003cstrong\u003espreadsheet ID\u003c\/strong\u003e and \u003cstrong\u003evenueTimezone\u003c\/strong\u003e, then create a \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e credential with edit access.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785611632819,"sku":"N8N-17927","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/69ao-tikJWJ0yJf3ioFjs_dJYBgkES.png?v=1786179826","url":"https:\/\/buyflowscripts.com\/products\/n8n-vip-concierge-google-sheets-table-reservations-w-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}