{"product_id":"n8n-voice-food-ordering-google-sheets-menu-whatsapp-api","title":"n8n Voice Food Ordering: Google Sheets Menu + WhatsApp API","description":"\u003ch3\u003eVoice food ordering from your Google Sheets menu—powered by n8n + WhatsApp\u003c\/h3\u003e\n\u003cp\u003eTurn your existing Google Sheets menu into a complete \u003cstrong\u003evoice ordering\u003c\/strong\u003e flow. This n8n workflow exposes a webhook that a voice assistant can call to \u003cstrong\u003efetch menu items\u003c\/strong\u003e, \u003cstrong\u003ecalculate totals\u003c\/strong\u003e, and \u003cstrong\u003eplace validated orders\u003c\/strong\u003e—then logs them to Google Sheets and notifies your kitchen via the \u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives voice assistant tool calls\u003c\/strong\u003e via a \u003cstrong\u003ePOST webhook\u003c\/strong\u003e, extracting the requested function name and arguments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads and caches configuration\/menu\u003c\/strong\u003e from Google Sheets (Config + Menu tabs). If cache is missing, it fetches the tabs and keeps only available menu items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eget_menu:\u003c\/strong\u003e formats available items grouped by category with prices and returns the text in the webhook response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ecalculate_order:\u003c\/strong\u003e matches requested items against the Google Sheets menu, calculates \u003cstrong\u003esubtotal\u003c\/strong\u003e, \u003cstrong\u003edelivery fee\u003c\/strong\u003e, \u003cstrong\u003etotal\u003c\/strong\u003e, and checks whether the order meets \u003cstrong\u003eminimum-order\u003c\/strong\u003e rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eplace_order:\u003c\/strong\u003e re-validates items, minimum order status, and required customer details (name, phone, address). Returns a problem message if anything is missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrder confirmation:\u003c\/strong\u003e generates an \u003cstrong\u003eorder ID\u003c\/strong\u003e, appends the order to the \u003cstrong\u003eOrders\u003c\/strong\u003e tab in Google Sheets, and sends an \u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e message with the order details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnable a voice assistant to let customers order directly from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e menu.\u003c\/li\u003e\n  \u003cli\u003eHandle order totals and minimum order rules automatically during a call.\u003c\/li\u003e\n  \u003cli\u003eNotify the kitchen instantly in WhatsApp when an order is successfully placed and stored.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e to serve the voice assistant tool-call interface\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e nodes (Config, Menu, Orders tabs; OAuth2 authentication)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp Cloud API\u003c\/strong\u003e via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic using \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, plus support nodes like \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e create\/copy a Google Sheets file with \u003cem\u003eConfig\u003c\/em\u003e, \u003cem\u003eMenu\u003c\/em\u003e, and \u003cem\u003eOrders\u003c\/em\u003e tabs, update the document\/sheet references, and configure the Google Sheets OAuth2 credentials. This is a practical n8n automation workflow built specifically for \u003cstrong\u003evoice-driven food ordering\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895370834099,"sku":"N8N-18662","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ggx_KukKoUow5D13KBgAF_IFAeCVfH.png?v=1787648886","url":"https:\/\/buyflowscripts.com\/products\/n8n-voice-food-ordering-google-sheets-menu-whatsapp-api","provider":"N8N Commerce","version":"1.0","type":"link"}