Order Status & Inventory Automation

### Project Title

Order Status and Inventory Automation

### Project Description

I developed an automated order status management workflow that connects restaurant orders with inventory operations using n8n, Telegram, JavaScript, and Google Sheets.

The system receives order status updates from the kitchen through Telegram, processes the incoming message, extracts the order number and status, and retrieves the corresponding order from Google Sheets.

A conditional workflow using Switch and IF logic determines the appropriate action based on the order status. Completed orders can trigger inventory operations to deduct the ingredients used to prepare the order, while cancelled orders follow a separate workflow without affecting the inventory.

### Key Features

* Telegram-based order status updates

* Automatic order identification

* Conditional workflow routing

* Order completion handling

* Inventory deduction automation

* Google Sheets integration

* JavaScript data processing

* Switch and IF business logic

* Automated restaurant workflow

### Technologies

n8n, JavaScript, Telegram Bot API, Google Sheets, Workflow Automation, Conditional Logic, Inventory Management