Create Sales Orders with Web POS Interface, AI Reports, Telegram Alerts & Sheets

Go to Workflow
0 views
Built by Budi SJ Budi SJ
Created on July 30, 2025

Description

Smart POS System with Live Updates to Telegram & Sheets

This Smart POS (Point of Sale) System template provides a lightweight yet powerful sales management solution. It features a modern web based interface for placing orders, with real time integration to Google Sheets and instant Telegram notifications, enhanced by AI-generated reports.
Ideal for small businesses, mobile vendors, or anyone who needs a quick and smart POS system.

✨ Key Features
πŸ–₯️ Modern web interface with product catalog and search
πŸ›’ Cart system with quantity, price, and discount handling
πŸ†” Unique Sales ID generation for every transaction
πŸ“Š Google Sheets integration to store product and sales data
πŸ€– AI-generated sales summary via OpenRouter
πŸš€ Instant Telegram notifications for new orders

πŸ”§ Requirements
A Google Sheet to store products and sales data
πŸ‘‰ Use this Google Sheets template to get started
Telegram Bot Token and User ID
(Create a bot via @BotFather)
OpenRouter API Key
(Sign up at openrouter.ai and use the LLM model)

βš™οΈ Setup Instructions
Set Up Your Google Sheets
Use the template and fill in product details in the products tab

Configure Telegram Bot
Create a bot via BotFather
Obtain your Bot Token and Chat ID (message the bot once to get ID)

Set Up AI Agent
In the AI agent node, replace the placeholder with your actual OpenRouter API Key

πŸš€ Deploy the Workflow
Activate the workflow in n8n
Open the webhook URL to access the POS interface
Enter product orders and customer details
Submit the order
Receive an instant Telegram notification with AI-generated sales summary
Data is automatically saved to Google Sheets for tracking and analysis

Nodes Used (5)

AI Agent
@n8n/n8n-nodes-langchain.agent
Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter
Telegram
n8n-nodes-base.telegram