Telegram Mini App for reordering goods

I developed a Mini App that automates processes for businesses - it allows reordering products directly in a chat with the bot. The system automatically pulls products from Google Sheets based on the user's order history and sends order confirmations to the server.

Main goal: to simplify the reordering process for customers and automate communication between the client and the business.

Functionality:
- User authorization – after logging into the mini-app, the administrator receives a notification about a new user;
- Integration with Google Sheets – the bot retrieves a list of products that the user has ordered before;
- Order form – the user selects a product, quantity (from 10 to 3000 kg in increments of 5 kg);
- Order confirmation – before sending the data, the user sees a popup with the details;
- Sending a JSON request to the server – the order is received in the business system via REST API.

Technologies used

Frontend:
- React + Vite (fast development and optimization for Telegram Mini Apps);
- Styled Components (custom styles);
- Telegram Web Apps API (authorization, integration with the bot).

Backend:
- Node.js + Express (server logic);
- Google Sheets API (data retrieval from the sheet);
- Axios (sending API requests);
- JWT (authorization via Bearer Token).

Deployment and server:
- Nginx (reverse proxy);
- PM2 (process manager for Node.js);
- Ubuntu VPS (server setup).

Result
- Fully implemented technical specifications according to the UI design;
- Improved UX (intuitive quantity input, convenient confirmation);
- Provided instructions for setting up API keys for further deployment;
- Stable operation on the server (deployment via PM2, optimized performance).

Conclusion
This project allowed the business to automate the reordering process, reduce manual work, and enhance user convenience. Thanks to this Mini App, clients can quickly place orders, and integration with Google Sheets simplifies product management.

Ready to implement similar solutions for your business!