{"product_id":"whatsapp-restaurant-booking-automation-with-n8n-gemini-sheets","title":"WhatsApp Restaurant Booking Automation with n8n, Gemini \u0026 Sheets","description":"\u003ch3\u003eAutomate Restaurant Reservations on WhatsApp—Text or Voice—Using n8n, Gemini, Google Sheets, and Google Calendar\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns WhatsApp messages into real restaurant bookings. Customers can book by \u003cstrong\u003etext or voice\u003c\/strong\u003e, and the workflow uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to manage the conversation, then saves reservations in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, updates events in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, and sends \u003cstrong\u003eWhatsApp confirmations\u003c\/strong\u003e to both the customer and the restaurant owner.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives WhatsApp messages\u003c\/strong\u003e when a new message arrives (via WhatsApp Trigger\/OAuth and WhatsApp Cloud API).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects message type\u003c\/strong\u003e: routes requests for \u003cem\u003etext\u003c\/em\u003e directly, or downloads \u003cem\u003evoice notes\u003c\/em\u003e and transcribes them using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns a Gemini-powered reservation agent\u003c\/strong\u003e that keeps per-customer conversation context using the customer’s phone number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnswers dish\/price questions\u003c\/strong\u003e by reading your \u003cstrong\u003eGoogle Sheets “Menu”\u003c\/strong\u003e tab and replying in \u003cstrong\u003eSpanish\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates, updates, or cancels bookings\u003c\/strong\u003e by writing reservation records to the \u003cstrong\u003eGoogle Sheets “Reservas”\u003c\/strong\u003e tab and synchronizing matching events in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies the restaurant owner via WhatsApp\u003c\/strong\u003e for every new booking, change, or cancellation, then sends the appropriate response back to the customer.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCollect reservations 24\/7 through WhatsApp without manually checking calendars.\u003c\/li\u003e\n  \u003cli\u003eHandle customer voice messages for booking requests and special instructions.\u003c\/li\u003e\n  \u003cli\u003ePublish menu details from Google Sheets and respond in Spanish instantly.\u003c\/li\u003e\n  \u003cli\u003eKeep restaurant staff informed on every booking modification via WhatsApp.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/OAuth:\u003c\/strong\u003e WhatsApp (Trigger\/OAuth + WhatsApp Cloud API), Google Gemini (PaLM API), Google Sheets OAuth2, Google Calendar OAuth2.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore nodes used:\u003c\/strong\u003e Set, Switch, WhatsApp (trigger\/tool), HTTP Request, Sticky Note (for workflow clarity), plus Gemini and Google Sheets\/Calendar actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheets:\u003c\/strong\u003e A Google Spreadsheet with tabs named \u003cstrong\u003e“Menu”\u003c\/strong\u003e and \u003cstrong\u003e“Reservas”\u003c\/strong\u003e, with the expected column headers (including accents).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974326968499,"sku":"N8N-19281","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YGZvUzoK7ssvHPSRpWJCa_buNbgAYc.png?v=1788772559","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-restaurant-booking-automation-with-n8n-gemini-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}