Important Notice: Join our official WhatsApp Channel for verified announcements, exclusive offers, giveaways, and expert resources on building web applications with AI

Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets

F6 E-commerce Premium Plan VIP Premium Plan
❤️
Whatsapp Community
Join 🔥 Rameez Scripts WhatsApp Community — Get Free Templates, Tutorials & Giveaways Before Anyone Else!
Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets

Key Features

Bulk order matrix for entering quantities by colour and size in one grid Tier pricing that drops the rate automatically as quantity crosses a slab Live price recalculation as the buyer types Pin code shipping calculator with zones free-above thresholds and flat rates Guest checkout with required contact and address plus optional GST details Payment by cash on delivery bank transfer or UPI with QR code and screenshot upload Storefront with news ticker search category filters banners and FAQ section Product cards with size chart images multiple photos and an optional YouTube demo WhatsApp enquiry button straight from the product Quotations with searchable products custom terms internal notes and a timeline One-click convert quotation to order Orders from both storefront checkout and quotations in one list Chevron pipeline filters and a full order timeline Record payments against an outstanding order balance Issue and email invoices with print and balance payment Returns with pick lines refund toggle and mark refunded replaced received or rejected Print jobs module with artwork file proof mockup vendor and approval status Ask AI chatbot answering buyer questions from your own knowledge base Bring your own Gemini API key with model selection Customer portal with orders favourites addresses and profile Admin management of products categories banners and FAQs Settings for branding currency tax percentage and minimum order value Dispatch with AWB tracking and automatic shipping emails SWR background loading and a mobile-friendly layout

Description

A bulk-order ecommerce portal built for wholesalers, running entirely on Google Sheets and Apps Script. A buyer lands on the storefront, opens a product and fills in a colour-and-size quantity matrix — and as the quantity climbs, tier pricing drops the rate automatically. The cart slides in, a pin code calculates shipping, and the order can be printed, sent over WhatsApp, or checked out on the spot as a guest.

What it does

This is built around how wholesale actually works, not retail. Orders are entered as a grid rather than one item at a time. Prices move in slabs — 1 to 19 pieces at one rate, 20 and above at another — and the total recalculates live. Shipping is worked out by zone and pin code, with a free-above threshold and a flat charge below it. Buyers who want a formal quote get one: the admin builds a quotation with searchable products, custom terms and internal notes, and converts it to an order in one click when it is accepted.

Highlights

  • Storefront with news ticker, search, category filters, unlimited banners and an editable FAQ block
  • Product cards carrying a size chart, multiple photos and an optional YouTube demo video
  • Orders from storefront checkout and from quotations land in one list, with chevron pipeline filters and a full timeline
  • Payments recorded against an outstanding balance, invoices issued and emailed, balances payable from the invoice
  • Returns with line picking, a refund toggle and mark refunded / replaced / received / rejected
  • A print-jobs module for custom artwork orders — artwork file, proof mockup, vendor, customer approval, printing status
  • Customer portal with orders, favourites, saved addresses and profile
  • Dispatch with AWB tracking and automatic shipping emails

The AI assistant

An Ask AI chatbot answers buyer questions — payment terms, bulk discounts — from a knowledge base you maintain, using your own Gemini API key and chosen model. Conversations can be saved back to the sheet so you can see what buyers keep asking.

Who it is for

Wholesalers, distributors, garment and textile suppliers — any business taking large repeat orders from trade buyers who need quantity grids, slab pricing and quotations rather than a single Add to Cart button.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets as the database — no server or MySQL needed
  • Google Apps Script web app deployment access
  • Google Drive space for order attachments and payment screenshots
  • Optional: a Gemini API key if you want the Ask AI chatbot
  • Modern browser (Chrome, Edge, Firefox or Safari)

What's Included

  • Full Apps Script source code (Code.gs + index.html)
  • Public storefront with bulk order matrix and tier pricing
  • Guest and registered checkout with multiple payment methods
  • Admin panel: products, categories, banners, FAQs
  • Quotations, orders, invoices, payments and returns
  • Print jobs module for custom artwork orders
  • Shipping zone and pin code configuration
  • Customer portal
  • Ask AI chatbot wiring for your own Gemini key
  • Full video walkthrough
  • Free support and paid customization on request

Item Details

Versionv1.0
PublishedMay 10, 2026
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryE-commerce
Tagsb2b ecommerce portalb2b ecommerce google sheetswholesale ecommerce portalonline store google sheetsb2b order management systemecommerce website google apps scriptdealer portal softwaregoogle apps script web app
VideoWatch walkthrough
LicenseRegular License

Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets

E-commerce

What You Get

Code.gs FilesComplete Apps Script source code files
HTML FilesAll HTML template files included
Google SheetYour own copy with all data and scripts
Setup GuideStep-by-step video tutorials included
6 Months SupportBug fixes, tweaks, and guidance — all free
Free UpdatesAll future updates included at no extra cost
Regular License F6
Subtotal $2.88 USD
Card fee (10%) $0.29 USD
Total $3.17 USD
70% OFF applied — was $9.60 now $2.88
Other payment methods
Wise / Bank Transfer · via WhatsApp +92 343 534 7417 $9.60$2.88
RE
Redotpay
Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Secure checkout
Amount due
$2.88$9.60
Amount to pay
Redotpay Account
1002896884
What happens after you pay
  1. Send us the proofEnter your transaction ID and upload the payment screenshot in the form on this page.
  2. We check it by handUsually cleared in 10–30 minutes during working hours — no bots, a person looks at it.
  3. Your file arrives by emailWe open your account and email the login together with the download link, so use an address you can actually open.
Encrypted & secure
Manual review 10–30 min
Receipt by email
How to pay
  1. Copy the Redotpay account
  2. Pay $2.88 via Redotpay
  3. Enter transaction ID below
  4. Submit below — admin verifies & grants access
Manual verification: Typically takes 10 to 30 minutes to verify and grant access during working hours.
We'll find or create your account by this email.
Your country is picked from your location — change it if it's wrong, then type your number without the country code.
Submitted for admin review · typically takes 10 to 30 minutes to verify
Payment invoice
File / CourseBuild a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Invoice CodeF6
Payment MethodRedotpay
Total$2.88
BP
Binance Pay
Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Secure checkout
Amount due
$2.88
Amount to pay · zero fee · instant
Scan to Pay with Binance
Scan to Pay
Binance Pay ID
766412546
Account holder: Muahmmad Ramiz Imdad
What happens after you pay
  1. Send us the proofEnter your transaction ID and upload the payment screenshot in the form on this page.
  2. We check it by handUsually cleared in 10–30 minutes during working hours — no bots, a person looks at it.
  3. Your file arrives by emailWe open your account and email the login together with the download link, so use an address you can actually open.
Encrypted & secure
Manual review 10–30 min
Receipt by email
How to pay
  1. Open Binance app → Pay
  2. Scan QR or enter Pay ID
  3. Send $2.88 (any supported crypto)
  4. Copy Order ID from Binance receipt
  5. Paste below & submit for verification
Manual verification: Typically takes 10 to 30 minutes to verify and grant access during working hours.
We'll find or create your account by this email.
Your country is picked from your location — change it if it's wrong, then type your number without the country code.
Submitted for admin review · typically takes 10 to 30 minutes to verify
Payment invoice
File / CourseBuild a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Invoice CodeF6
Payment MethodBinance Pay
Total$2.88
CR
Cryptocurrency
Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Secure checkout
Amount due
$2.88
Send exact amount in crypto equivalent
Pick one
Send to this address
15jjKnm6NgxN1Wgbfh7xdBWgbCFztHeNhE
Important: Send only the selected coin on its correct network. Sending on wrong network may result in permanent loss.
What happens after you pay
  1. Send us the proofEnter your transaction ID and upload the payment screenshot in the form on this page.
  2. We check it by handUsually cleared in 10–30 minutes during working hours — no bots, a person looks at it.
  3. Your file arrives by emailWe open your account and email the login together with the download link, so use an address you can actually open.
Encrypted & secure
Manual review 10–30 min
Receipt by email
How to pay
  1. Choose your preferred crypto above
  2. Copy wallet address & send $2.88 equivalent
  3. Enter transaction hash below
  4. Submit below — admin verifies & grants access
Manual verification: Typically takes 10 to 30 minutes to verify and grant access during working hours.
We'll find or create your account by this email.
Your country is picked from your location — change it if it's wrong, then type your number without the country code.
Submitted for admin review · typically takes 10 to 30 minutes to verify
Payment invoice
File / CourseBuild a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Invoice CodeF6
Payment MethodCryptocurrency
Total$2.88
PA
PayPal
Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Secure checkout
Amount due
$2.88
Amount to pay
Pay $2.88 with PayPal
Opens PayPal in a new tab. Come back here afterwards with your Transaction ID.
What happens after you pay
  1. Send us the proofEnter your transaction ID and upload the payment screenshot in the form on this page.
  2. We check it by handUsually cleared in 10–30 minutes during working hours — no bots, a person looks at it.
  3. Your file arrives by emailWe open your account and email the login together with the download link, so use an address you can actually open.
Encrypted & secure
Manual review 10–30 min
Receipt by email
How to pay
  1. Tap Pay $2.88 with PayPal — it opens PayPal in a new tab
  2. Copy the Transaction ID from your PayPal receipt
  3. Enter it below with a screenshot of the payment, then submit
  4. We verify it and unlock your file — the download link is emailed to you too
Manual verification: Typically takes 10 to 30 minutes to verify and grant access during working hours.
We'll find or create your account by this email.
Your country is picked from your location — change it if it's wrong, then type your number without the country code.
Submitted for admin review · typically takes 10 to 30 minutes to verify
Payment invoice
File / CourseBuild a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Invoice CodeF6
Payment MethodPayPal
Total$2.88
400+ PROJECTS DELIVERED · 5,000+ HAPPY CLIENTS WORLDWIDE

Need This Customized For Your Business?

We don't just deliver and disappear — every project comes with 6 months of free support. Bug fixes, small tweaks, and guidance included. Choose us without any worry.

5,000+
Happy Clients
24-72h
Fast Delivery
6 Months
Free Support
100%
Money Back
30 min
Avg. Reply

What We Customize

Features & Functions
Add new features, modify existing scripts, custom formulas & automations
API & Integrations
Connect with WhatsApp, Telegram, Payment Gateways, CRM & more
Design & UI Changes
Custom branding, layout redesign, dark mode, mobile optimization
Full Custom Projects
Dashboards, billing systems, inventory, CRM — built from scratch
Get Free Quote on WhatsApp

20-30% advance to start • Clear pricing before we start • 6 months free support after delivery

$3.17
USD · incl. card fee

People choose these

What buyers of this file added to the same order

Most bought together Petrol Station Management System in Google Sheets (Shifts, Tanks & Accounts) Petrol Station Management System in Google Sheets (Shifts, Tanks & Accounts) 2 buyers took both Apps Script $1.92 USD How to Build a Full HR & Payroll ERP with Google Apps Script and React | Salary Slip + Attendance How to Build a Full HR & Payroll ERP with Google Apps Script and React | Salary Slip + Attendance 2 buyers took both Apps Script $1.92 USD Build a Gym Management System with Claude Code & Google Sheets Build a Gym Management System with Claude Code & Google Sheets 2 buyers took both Apps Script $1.44 USD

Reviews & Feedback

What buyers and viewers say about Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets.

No star ratings yet · 20 YouTube comments
Sort
@CristhianCUribe via YouTube
After analyzing this portal and seeing the outstanding work you’ve been doing, I can only say that it’s truly impressive. Cograts!!
1 like on YouTube
@sajidbahar_graphics via YouTube
Start a playlist where all the different web applications are explained in the playlist Like Inventory management system School management system And more
1 like on YouTube
@foodmastiIndia via YouTube
very systematically app and some thing to consider : first the order delete option should be avaided because in the wholesale business , a complete transaction will be missed in doing the balanced sheet or accounts maintain. it may marked with some tag like " order unaccounted " or instead of delete it must be list on another sheet with such records for future to see the accounts clearly . if once order deleted a important link of that order relates to stock , credit and transaction .. the whole link breaks and after many months the admin will not have any trace of whre the stocks gone or where are the orders gone like this . Rest its a great helpful system for wholesale. well done
1 like on YouTube
@DurvishJawaleOfficial via YouTube
This helped me a lot For my company I need web app like this only Keep it up brother.
1 like on YouTube
@Pixeltoart via YouTube
Awesome work
@kkmotswaborwa via YouTube
thank you sir. this is helpful
@gusadiyanto via YouTube
Wow...awesome web app B2B e-commerce ❤🎉👍
@JeanTube7777 via YouTube
Un sistema de ventas muy completo y útil.
@joselitoantipuesto8085 via YouTube
Wow it's great
@richarrh via YouTube
Great web app! This B2B portal template is incredibly useful for small business es. Thks for sharing!
@bishalkalita8059 via YouTube
This is amazing script... This is very helpful for me! Thank you sir for building this type of web script
@jordanfelipe31 via YouTube
This code is quite comprehensive and can be adapted for other areas.
@rasc-c5e via YouTube
Very nice website and people system and management system wonderful 👍🎊🎉🙏
@CesarAndreotti via YouTube
Amazing!! Good job Rameez
@Kyyxxz via YouTube
All the information and added products, and also the flow is easy to understand. It's user-friendly. You're the best.
@sajidbahar_graphics via YouTube
How we can build this type of applications from start to finish
@M.K.Kalaiyarasan via YouTube
Bro it's very useful and small detailing also ultimate 🥳🥳🥳🥳
@irfanchauhan495 via YouTube
Always something new... This web application is based on SWR technology.... So it's fast and accurate to fetch data quickly... Superb🎉 .....Thank You Brother
@genuspro1 via YouTube
Go ahead dear
@khanasadullah5125 via YouTube
Labbaik 😊😊😊