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. 2. n8n Node Configuration - Import this template into your n8n workspace. - Update the Google Sheets credentials and replace the Document ID in all sheet nodes with your specific spreadsheet ID. - Add your Telegram Bot Token via n8n’s credential manager to activate the Telegram Trigger and messaging nodes. - Locate the nodes containing the YOURFLUTTERWAVESECRETKEY placeholder (e.g., Flutterwave Init Transaction) and insert your actual Flutterwave Secret Key. 3. Webhook Activation - Double-click the Flutterwave Webhook node. - Copy the “Production URL” provided by n8n. - Log into your Flutterwave Dashboard, navigate to Settings > Webhooks, and paste the URL. This ensures your bot receives real-time payment confirmations. 💡 Use Cases - Digital Creators: Sell e-books, courses, templates, or software directly to your Telegram audience with instant file delivery. - Local Businesses: Automate orders for physical goods, food delivery, or merchandise without needing a dedicated website. - Dropshipping: Seamlessly collect orders and addresses before forwarding them to suppliers. 🔗 Apps Integrated - Telegram - Flutterwave - Google Sheets - Google Drive (Optional) You can also test the workflow live on Telegram: @flutterwavesellbot or http://t.me/flutterwavesellbot(Bold)) 👋 Need help or want to customize this workflow? 📺 Contact: Fiverr 📩 Consultation: Book Apoointment