n8n Voice Food Ordering: Google Sheets Menu + WhatsApp API

Voice food ordering from your Google Sheets menu—powered by n8n + WhatsApp

Turn your existing Google Sheets menu into a complete voice ordering flow. This n8n workflow exposes a webhook that a voice assistant can call to fetch menu items, calculate totals, and place validated orders—then logs them to Google Sheets and notifies your kitchen via the WhatsApp Cloud API.

What this workflow does

• Receives voice assistant tool calls via a POST webhook, extracting the requested function name and arguments.
• Loads and caches configuration/menu from Google Sheets (Config + Menu tabs). If cache is missing, it fetches the tabs and keeps only available menu items.
• get_menu: formats available items grouped by category with prices and returns the text in the webhook response.
• calculate_order: matches requested items against the Google Sheets menu, calculates subtotal, delivery fee, total, and checks whether the order meets minimum-order rules.
• place_order: re-validates items, minimum order status, and required customer details (name, phone, address). Returns a problem message if anything is missing.
• Order confirmation: generates an order ID, appends the order to the Orders tab in Google Sheets, and sends an WhatsApp Cloud API message with the order details.

Use cases

• Enable a voice assistant to let customers order directly from your Google Sheets menu.
• Handle order totals and minimum order rules automatically during a call.
• Notify the kitchen instantly in WhatsApp when an order is successfully placed and stored.

Technical details

• Webhook to serve the voice assistant tool-call interface
• Google Sheets nodes (Config, Menu, Orders tabs; OAuth2 authentication)
• WhatsApp Cloud API via HTTP Request
• Workflow logic using if, code, plus support nodes like sticky note

Setup: create/copy a Google Sheets file with Config, Menu, and Orders tabs, update the document/sheet references, and configure the Google Sheets OAuth2 credentials. This is a practical n8n automation workflow built specifically for voice-driven food ordering.