Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free Ecommerce Website for Drink Shops – Google Apps Script

F33 E-commerce Restaurant & Food Apps Script Pass Pro Business Free
Need a Custom System? We Build It From Scratch
ERP, Finance, School Management, CRM & more — fully customized, production-ready, delivered fast.
ERP FMS SMS CRM Inventory HMS POS
Build Ecommerce Website Free using Google Sheets Apps Script
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help
Built and supported by

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

Mobile-friendly storefront Category filters and search Drink sizes and add-ons Sugar and ice options Guest checkout Customer signup and login Pickup time selection QR and bank payments Payment receipt upload Customer order tracking Payment review and approval Order board workflow Order 360 view Thermal and A4 printing Bulk product CSV import One-click sold-out toggle WhatsApp customer messaging Sales dashboard and charts Daily and product reports CSV and PDF export Opening hours control Email order notifications Roles and permissions Backup and nightly job Light and dark mode

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

Versionv1.0
PublishedOct 2, 2026
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryE-commerce, Restaurant & Food
VideoWatch walkthrough
LicenseRegular License
Get this source code free F33
  • Full source code
  • Google Sheet
  • Setup guide

Unlock in 1 step

Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click — no payment. Google only confirms you are subscribed.
Verify Now
Free download

Verify your subscription

Subscribed to the channel? Verify in one click and download the source code.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish
Not subscribed yet? Subscribe on YouTube

Google only checks your subscription No payment, no card

4.928 ratings on this siteSee reviews
White label Resale allowed Free bug fixes Lifetime updates
Free download Full source code Setup guide Edit + resale rights License & unlock detailsHide details
  • Regular license, full rights

    White label: your own brand, no Rameez Scripts credit needed. Modify it, use it on unlimited projects and resell it. Only condition: no video content about the product.

  • How the unlock works

    No payment and no card. Google is used only to confirm your YouTube subscription.

  • Setup guide

    The step-by-step Apps Script setup guide opens right after the download.

Get a custom version for your business

Your features, branding and reports, built on this system. Free quote before any work starts.

Chat on WhatsApp
Custom development

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.

400+Projects delivered
91+Countries served

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.

Sort
@pavanib.k.n622 via YouTube
Hi, could you tell me where you are hosting this webapp
@FazlulKarum-y2z via YouTube
महोदय, मैं आपके लगभग सभी वीडियो देखता हूँ। जब मैंने पहली बार यह वीडियो देखा था, तब यह फ़ाइल मुफ़्त थी। अब मैं इसे खरीद नहीं सकता क्योंकि मैं छात्र हूँ और मेरे पास पैसे नहीं हैं। कृपया महोदय, क्या आप मुझे यह फ़ाइल दे सकते हैं? 🙏❤
@TheAI-PoweredAnalyst via YouTube
Please you did not show us the step by step tutorial
@knamtv via YouTube
College fees collection script banaye
@RicardoAlcázar-z2q via YouTube
Hi, thank you so much for your excellent contributions. I’m new to the channel and truly admire your work. I’d also like to propose a project for a comprehensive parking management solution—featuring controls for entries, exits, occupancy, payments, average stay duration, and so on, along with the relevant metrics for business reporting and analysis. It would be incredibly helpful to me. Best regards and all the best.
@AbdallahibnsunneeMaikwano17 via YouTube
Very speechless and superb projects, anything from rameez script is different and marvellous, We wish you all the best and your teams too. Thank you and God bless you sir
@gaminggoodforhealth576 via YouTube
The Ai Video Editing is good, What model you use.
@JeanTube7777 via YouTube
Que belleza de sistema. Me encanta 10 de 10.
@irfanchauhan495 via YouTube
Video Editing is superb..... Theme and Design are also Awesome... Nice Web App...
@DineyPoi via YouTube
10/10 awesome loved
@PadhakuKida via YouTube
Great knowlege
@niftylegacy via YouTube
Very good development. Thanks.
@QasimKhan-jh6lb via YouTube
It would be great if I won this.
@vidigyamishra6523 via YouTube
Good one...but best if we get the code
@abubakaraminuisa via YouTube
First to comments. And I have doing it but I have never been win😢 hopefully today I will be selected
@Kowayriya_Ma via YouTube
Number one❤❤