Free Ecommerce Website for Drink Shops – Google Apps Script
- Google Sheet link
- Source code file
- Resale rights
- Edit rights
- Setup guide
- AI setup help

Mohammad Rameez Imdad
Founder of Rameez Scripts. I build these systems myself and help you set them up.
- 33K+YouTube subscribers
- 348+free tutorials
- 4+ yrsbuilding since 2022
Key Features
Description
A complete ecommerce website for a soft drink shop, built on Google Sheets and Google Apps Script. Customers open your link on their phone, browse the menu by category (milk tea, fruit soda, fresh juice and more), pick a size, sugar and ice level and any paid add-ons, then check out as a guest or with an account. They pay by scanning your QR code or by bank transfer, upload the receipt, and follow the order on a tracking page. Every order is saved straight into your Google Sheet.
How an order flows
The shop gets an email the moment an order is placed. On the Order Board the new order waits in Payment Review: open the customer's screenshot, check your bank, then approve it or reject it with a reason. Approved orders move through Start, Ready and Picked Up, and the customer's tracking page follows each step. Kitchen tickets print on an 80 mm or 58 mm thermal printer, and invoices print on A4.
Highlights
- Pickup as soon as possible or at a chosen time later today; delivery with a fee can be switched on in Settings
- Opening hours that stop orders outside your trading times, plus a pause switch
- Products with sizes, optional sugar and ice, add-ons, and popular or featured flags
- Grid or table view, a one-click sold-out toggle, bulk actions and CSV import from a template
- All Orders with a 360 view of the customer, items, payment and timeline, plus bulk ready, complete and print
- Customer list built from signups, with each customer's order history and a WhatsApp button
- Dashboard with today's sales, an hourly chart, paid orders, drinks sold and average approval time
- Reports by day, drink, size, add-on and payment method, plus cancellations and refunds, with print, CSV and PDF
- Settings for shop details, logo, banner, currency, receipts, email alerts and printer size
- Users, role permissions, an activity log, backups, a nightly job and light or dark mode
Who it is for
Drink shops, bubble tea and juice bars, cafés and small takeaway counters that want to take orders online and be paid directly, without a payment gateway or a monthly platform fee. It runs as an Apps Script web app inside your own Google account, so there is no server or hosting to pay for.
Requirements 5
- Google account
- Google Sheets
- Google Drive storage
- Modern web browser
- Thermal printer (optional)
What's Included 7
- Complete Apps Script source code
- One-click demo data setup
- Sample menu and orders
- CSV import templates
- Thermal and A4 print layouts
- Video walkthrough
- 14 days support
Item Details
| Version | v1.0 |
| Published | Oct 2, 2026 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | E-commerce, Restaurant & Food |
| Video | Watch walkthrough |
| License | Regular License |
Need this customized for your business?
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
20–30% advance to start · Clear quote before work begins · Support after delivery
What we customize
- Features & functionsNew features, changes to existing scripts, custom formulas and automations
- API & integrationsWhatsApp, payment gateways, CRM and more
- Design & UI changesYour branding, layout redesign, dark mode, mobile layout
- Full custom projectsDashboards, billing, inventory, CRM, built from scratch
People choose these
Paid picks from the same category
Reviews & Feedback
What buyers and YouTube viewers say about this project.

