Sell products in Telegram with Flutterwave and Google Sheets

Transform your Telegram channel or group into a fully functional, automated e-commerce storefront. This n8n workflow template allows you to sell both physical and digital products directly within Telegram, utilizing Flutterwave for secure checkout and Google Sheets as a lightweight, free database for inventory and order management.

Say goodbye to complex website builders and monthly subscription fees. With this serverless setup, you can launch a store in minutes and manage everything from a simple spreadsheet. ✨ Key Features

- 🛒 Interactive Shopping Cart: Users can browse products, select quantities, and manage their cart entirely through seamless Telegram inline buttons. - 💳 Secure Payments: Direct integration with the Flutterwave API generates unique, secure checkout links for every order. - 📦 Smart Fulfillment: Automatically detects if an order is digital or physical. Digital goods (e.g., PDFs, E-books via Google Drive) are delivered instantly upon payment confirmation. Physical orders are marked as “Paid” and queued for shipping. - 📊 Free Database (Google Sheets): No SQL required! Manage your product catalog, track active user sessions, and view order history entirely within Google Sheets. - 🔍 Order Tracking System: Customers can use the /orders command or search by their unique ORD- ID to view their purchase history, resume pending payments, or track shipped items. - ⚙️ Built-in Validation: Includes robust data validation for email addresses (catching common typos like .con) and physical delivery addresses.

🛠 Prerequisites

To run this template, you will need the following accounts:

1. Telegram: A free Telegram Bot Token (obtained via BotFather). 2. Flutterwave: A Flutterwave account to receive payments (you will need your Secret Key and hash/Encryption Key). 3. Google Workspace: A Google account to host the Google Sheets database and Google Drive (if selling digital files).

📝 Setup Instructions 1. Database Setup

- Create a new Google Sheet (Template; https://docs.google.com/spreadsheets/d/1x58FYmsdo2K2dKNm81LgCSrGvHwhenkJTtjDIxc8-2w/edit?gid=187299608gid=187299608 with three tabs: Products, Orders, and Session. - Products Tab Headers: id, name, price, type (physical/digital), stock, description, fileurl (optional, for digital goods). - Orders Tab Headers: orderid, reference, userid, email, address, itemsjson, total, status, paymentlink, tracking, createdat. - Session Tab Headers: userid, chatid, state, cartjson, selectedproductid, selectedproductname, selectedproductprice, selectedproducttype, inputquantity, inputemail, inputaddress.