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

Dynamic CRUD Web App with Admin & User Login – Apps Script

B13 Login & Authentication CRUD & Dashboards Apps Script Pass Pro Business
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
ADMIN & USER LOGIN DYNAMIC CRUD WEB APP USING GOOGLE APP SCRIPT | LOGIN CRUD WEBAPP | B13
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

Login type deciding what a person can see Admin sees every record in the database A user sees only the rows under their own name Add edit and delete within your own scope Changes written to the Google Sheet immediately Form fields generated from the database columns Add a column and the form picks it up on refresh Remove a column and it leaves the form too Field type set per column Dropdown values read from the sheet Account type held in one column Code already inside the shared sheet

Description

B13 takes the dynamic CRUD idea and adds the thing that makes it usable by more than one person: who you log in as decides what you can see. An admin opens the app and sees every record in the database. A user opens the same app and sees only the rows that belong to them. Same link, same screen, different data.

One column does the gating

Each account carries a type — admin or user. The app reads it at login and filters the table accordingly, so the person who should only see their own work never sees anybody else's, and the person running things does not have to switch accounts to get the full picture. Changing somebody's access means changing one cell.

Full CRUD inside your own scope

Both kinds of account can add, edit and delete. A user's additions are filed under their own name automatically, so their view stays theirs. Every change writes straight into the Google Sheet, which means the sheet and the app never drift apart while two people are working at once.

The form follows the database

The add and edit form is not hand-written HTML. It is generated from the columns you keep in the database sheet, with a type set per field. The walkthrough demonstrates this by gutting the sample columns and rebuilding the whole thing as a school record — ID, student name, class, teacher name — purely by editing the sheet. Refresh, and the table and the form both match the new shape.

Setting it up

Copy the sheet, open Apps Script from Extensions — the code is already inside — and deploy as a web app. Authorise it once and the link is ready to hand out to admins and users alike.

Requirements

  • A Google account with Drive and Sheets
  • Your own copy of the provided spreadsheet
  • An account type column holding admin or user
  • Apps Script editor access on that copy
  • Deploy as a web app with access set to anyone

What's Included

  • Complete Apps Script code already inside the sheet
  • Google Sheet with the login and database tabs
  • Login screen for admin and user accounts
  • Admin view showing every record
  • User view filtered to their own rows
  • Add edit and delete inside each scope
  • Form generated from the database columns
  • Field type setting per column
  • Deployment steps for the web app
  • Step-by-step video walkthrough of the full build
  • Free support from the developer

Item Details

Versionv1.0
PublishedAug 22, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryLogin & Authentication, CRUD & Dashboards
VideoWatch walkthrough
LicenseRegular License
Regular License B13
4.923 ratings on this siteSee reviews
White label Resale allowed Free bug fixes Lifetime updates
Get Source Code File on WhatsApp
  1. 1Message us
  2. 2Pay
  3. 3Get the file
Instant download Full source code Lifetime free updates Free bug fixes License & support detailsHide details
  • Regular license, full rights

    Full ownership, 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.

  • Setup support, 14 days

    Help with setup, install errors and questions on WhatsApp, plus the step-by-step video guide.

  • Bug fixes in 24–48 hours

    Found a bug in the code? It is fixed free. Bug fixes only, not new features.

  • Safe checkout

    SSL secure page, receipt by email, download in your account right after payment.

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

R12 | ADMIN & USER LOGIN CRUD WEB APP USING GOOGLE APP SCRIPT | LOGIN CRUD WEBAPP R12 | ADMIN & USER LOGIN CRUD WEB APP USING GOOGLE APP SCRIPT | LOGIN CRUD WEBAPP Apps Script $4.99 USD DYNAMIC CRUD WEB APP WITH PASSWORD🔒USING GOOGLE SHEETS & APPSCRIPT | R36 DYNAMIC CRUD WEB APP WITH PASSWORD🔒USING GOOGLE SHEETS & APPSCRIPT | R36 Apps Script $4.99 USD Google Sheet Web App Dashbaord Using Google Appscript with Login | B28 Google Sheet Web App Dashbaord Using Google Appscript with Login | B28 Apps Script $4.99 USD

Reviews & Feedback

What buyers and YouTube viewers say about this project.

Sort
@adilkhankhalid2376 via YouTube
Your source code link isn't working
1 like on YouTube
@abdullahquhtani4247 via YouTube
Good and wild be GREAT if you could use drop down list of any field from list of values from a sheet. That speed up data entry.
1 like on YouTube
@高吉米-p1b via YouTube
How to get this copy of google sheet for my school?
@apdaga via YouTube
It will be great if you add logout button as well.