POC - Chatbot Order by Sheet Data
This workflow implements an intelligent chat assistant named Pizzaro, primarily used for pizza ordering. Through natural language interaction, customers can easily inquire about the menu, place orders, and check order status. The system integrates AI models and various tools to obtain product information in real time and automatically process orders, effectively addressing the slow response and error-prone issues of traditional ordering processes. This enhances the efficiency and accuracy of customer service and is suitable for various scenarios such as dining and e-commerce platforms.

Workflow Name
POC - Chatbot Order by Sheet Data
Key Features and Highlights
This workflow builds a chatbot-based pizza ordering assistant named Pizzaro, capable of intelligently responding to customer inquiries about the menu, order placement, and order status through natural language interaction. By integrating OpenAI’s chat model with various tool nodes, it supports real-time product information retrieval, order processing, and calculation functions, enhancing the customer service experience while enabling automated order management.
Core Problems Addressed
It solves the issues of slow customer response times, cumbersome order processing, and error-prone workflows in traditional pizza ordering. Through an intelligent chatbot, customers can complete menu inquiries and place orders directly via conversation, with the system automatically handling orders and providing status updates, significantly improving efficiency and accuracy.
Application Scenarios
- Customer service automation for online pizza shops or food and beverage enterprises
- E-commerce platforms requiring rapid response to customer ordering requests via chat interfaces
- Any business scenario aiming to implement order management and customer interaction through chatbots
Main Process Steps
- Receive Customer Chat Message (When chat message received): Listens to customer input to initiate the conversation flow.
- AI Agent Processes User Requests (AI Agent): Identifies customer intents such as menu inquiry, order placement, or order status query based on predefined system instructions.
- Invoke Product Information API (Get Products): Retrieves real-time product details and responds when customers inquire about the menu.
- Process Order Requests (Order Product): Receives customer order information and submits orders via API.
- Query Order Status (Get Order): Returns detailed status information when customers ask about order progress.
- Calculation Support (Calculator): Performs relevant calculations as needed.
- Chat Context Management (Window Buffer Memory): Maintains dialogue context to ensure coherent multi-turn conversations.
- Call OpenAI Chat Model (Chat OpenAI): Enables natural language understanding and generation to ensure intelligent and smooth conversations.
Involved Systems or Services
- OpenAI Chat Model: Used for intelligent language understanding and dialogue generation.
- Webhook APIs (https://n8n.io/webhook/get-products, order-product, get-orders): Provide services for product information retrieval, order processing, and order status querying.
- n8n Built-in Nodes: Includes chat triggers, HTTP requests, memory management, calculation tools, and other nodes working collaboratively.
Target Users and Value
- Food and beverage operators: Quickly build intelligent customer service chatbots to improve customer satisfaction and operational efficiency.
- E-commerce and retail platforms: Achieve automated order management and reduce the burden on human customer service.
- Developers and automation enthusiasts: Serve as a demonstration template for integrating AI chatbots with APIs, facilitating secondary development and feature expansion.
This workflow centers on intelligent conversation combined with real-time data interfaces to create an efficient and smart pizza ordering solution, greatly optimizing user experience and backend management processes.