Handle voice food orders with Google Sheets and WhatsApp Cloud API
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger
What it does
Quick overview This workflow exposes a webhook for a voice assistant to fetch a Google Sheets menu, calculate an order total from sheet prices, and place validated orders, then logs them to Google Sheets and notifies the kitchen via WhatsApp Cloud API. How it works 1. Receives a POST webhook request from a voice platform tool call and extracts the requested function name and arguments. 2. Tries to use a cached business config and menu, and if missing fetches the Config and Menu tabs from Google Sheets and keeps only available items. 3. If the tool call is getmenu, formats the available menu items with prices grouped by category and returns the text in the webhook response. 4. If the tool call is calculateorder, matches requested items to the Google Sheets menu, calculates subtotal, delivery fee, total, and minimum-order status, and returns the result in the webhook response. 5. If the tool call is placeorder, re-validates items, minimum order, and required customer details (name, phone, address) and either returns a problem message or continues. 6. For valid orders, generates an order ID, appends the order to the Google Sheets Orders tab, sends a WhatsApp Cloud API message with the order details, and returns an order-confirmation message in the webhook response. Setup 1. Create or copy a Google Sheets file with Config, Menu, and Orders tabs and update the document and sheet references in the Google Sheets nodes to match. 2. Add a Google Sheets OAuth2 credential with access to the spreadsheet. 3. Set your business settings in the Config tab (including currency, delivery fee, minimum order, kitchen WhatsApp number, and WhatsApp phone number ID) and keep Menu rows accurate with an available field. 4. Add a WhatsApp Cloud API access token as an HTTP Header Auth credential and ensure your WhatsApp Cloud API sender (phone number ID) can message the target numbers. 5. Copy the Webhook URL from n8n and configure your voice platform to call it as a tool for getmenu, calculateorder, and placeorder (adjust the request parsing in the code if your platform uses a different payload shape).