# Restaurant Ordering Chat Agent

**Category:** AI Agents  
**Tools:** OpenAI, n8n, Google Sheets  
**Nodes:** 12  
**Built by:** Forgent Systems

A chat agent that shows the menu, takes orders, calculates totals, checks order status and cancels orders, with Google Sheets as the order book.

![Workflow](preview.webp)

## How it works

1. A customer starts a chat.
2. The agent reads the menu and answers questions.
3. It creates an order, calculates the price and saves it.
4. It can also check status or cancel an order.

## Use cases

- Pizzerias and cloud kitchens
- Cafés and takeaways
- Food trucks

## Data setup

**Google Sheets** (tab: columns)

- **Pizza Ordering System → Orders**: `Order ID`, `Customer Name`, `Phone`, `Address`, `Pizza Type`, `Size`, `Toppings`, `Quantity`, `Total Price`, `Order Status`, `Status`, `Timestamp`, `Updated Timestamp`
- **Pizza Ordering System → Menu**: `Pizza Name`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets account
   - OpenAI account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **When chat message received** — `@n8n/n8n-nodes-langchain.chatTrigger`
- **Pizza Chatbot Agent** — `@n8n/n8n-nodes-langchain.agent`
- **Conversation Memory** — `@n8n/n8n-nodes-langchain.memoryBufferWindow`
- **Create Order** — `n8n-nodes-base.googleSheetsTool`
- **Get Single Pizza Menu** — `n8n-nodes-base.googleSheetsTool`
- **Get All Pizza Menu** — `n8n-nodes-base.googleSheetsTool`
- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
- **Cancel Order** — `n8n-nodes-base.googleSheetsTool`
- **Get Orders & Status** — `n8n-nodes-base.googleSheetsTool`
- **Calculator** — `@n8n/n8n-nodes-langchain.toolCalculator`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Respond to Chat** — `@n8n/n8n-nodes-langchain.chat`
