Vapi Order Status & Callback Queue for n8n Data Tables

Give your Vapi voice agent instant order support with an n8n Data Tables order-status lookup and callback queue

This n8n workflow adds two Vapi assistant tools—getOrderStatus and requestCallback—backed by native n8n Data Tables. It can verify an order using orderId + checkout email, return fulfillment details, and record a visible callback queue for your support team.

What this workflow does

• Seeds demo data for quick testing: the Manual setup branch creates blucca_vapi_demo_orders and blucca_vapi_demo_callbacks, then inserts ORD-1001 (alex@example.com) and ORD-1002 (jamie@example.com). You can inspect both tables directly in n8n.
• Receives Vapi tool calls via a Header Auth webhook: the workflow processes each tool call individually and preserves the incoming toolCallId throughout lookup, validation, and response building.
• Checks fulfillment status securely (getOrderStatus): it matches the supplied orderId and checkout email. If found, it returns fulfillment status, carrier, tracking number, and estimated delivery; if not, it returns order_not_found so the assistant can request the caller to confirm details.
• Records callback requests (requestCallback): using the same orderId + email pairing, it stores phone, reason, and a pending status in the callback table for your team to follow up.
• Supports queue management: callback identity combines the Vapi call ID and tool-call ID, enabling sequential retries to reuse the same row and preserve operator-managed status. If details change for the same key, it returns an explicit tool error.
• Returns one HTTP 200 envelope per batch, even when multiple tool calls are submitted.

Use cases

• Voice agents answering “Where is my order?” with real fulfillment status and tracking.
• Capturing callback requests when customers need human assistance (wrong item, delivery issues, account questions).
• Agencies delivering Vapi voice workflows with a built-in, visible support queue in n8n.

Technical details

• Nodes used: if, code, webhook, data table, sticky note, manual trigger.
• Data Tables: blucca_vapi_demo_orders and blucca_vapi_demo_callbacks.
• Workflow integration: Vapi tool calls received through a Header Auth webhook; toolCallId is preserved end-to-end.