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

Free Sliding Login and Signup Form – Google Apps Script

B39 Login & Authentication Forms & Data Entry Premium Plan Weekly Plan VIP Premium Plan
❤️
Need a Custom Business Solution?
Connect with us on WhatsApp to discuss your requirements. Our team will design and develop a tailored software solution aligned with your business workflow, operational needs, and growth objectives.
How to create a Login and Register Form using Google spreadsheet data & Appscript | B39
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

Animated sliding between sign in and sign up Responsive on mobile and desktop Duplicate username rejected at signup Duplicate email rejected at signup Password must mix capital letter small letter and digits Weak passwords refused Account created confirmation email to the user A redirect URL assigned per user by the admin Destination URL hidden from the user Browser tab title configurable in the script Embeddable in Blogger WordPress or any site by iframe Sheet ID set in one place Google Sheets as the database

Description

The second version of the login and signup form, and the one worth taking: it checks what people type, emails them when the account is made, and sends each user to their own destination.

A redirect per user, kept hidden

This is the feature that separates it. The admin assigns each account its own URL, so two people signing in through the same form land in two different places — a student portal for one, a staff dashboard for another. The destination is not revealed in the form, so a user cannot read off the address and bypass the login by going straight there next time.

Signup that refuses bad data

A username already in the sheet is rejected. An email already in the sheet is rejected too — separately, with its own message, so the person knows which one is the problem rather than guessing. And the password must mix an uppercase letter, a lowercase letter and digits; anything weaker is refused. Those three checks are what stop a user table filling with duplicates and one-character passwords within a week of going live.

The welcome email

A successful signup emails the user to confirm their account was created. It is a small thing that makes a form feel like a system, and it gives the user a record they can search for later.

Fitting it to your site

The browser tab title is set in the script — make it your institution's name — and the deployed URL embeds by iframe into Blogger, WordPress or any page you can edit, so the login sits inside your own site rather than on a Google address.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets and Google Apps Script — no hosting or server needed
  • Gmail for the account confirmation emails
  • A destination URL per user to assign in the sheet
  • Your Sheet ID set in the script

What's Included

  • Complete Google Apps Script source code
  • Animated, responsive sign in and sign up form
  • Duplicate username and duplicate email validation
  • Password strength rule enforcement
  • Account confirmation email on signup
  • Per-user redirect URL, hidden from the user
  • Configurable page title and iframe embedding
  • Google Sheets structure for the user accounts
  • Deployment walkthrough for publishing as a 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, Forms & Data Entry
Tagslogin and signup formlogin and register form google sheetslogin form google sheetshow to create login and register form using google spreadsheetlogin and signup form designpassword strength validationduplicate username checksignup confirmation email
VideoWatch walkthrough
LicenseRegular License
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

Subscribe & Unlock Source Code

Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.

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 to our channel

Browse More Free Files
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
Free
Source Code File

People choose these

Paid picks from the same category

PHP MySQL CRUD Project with AI Form Builder — Login System, Admin Panel & Full Source Code PHP MySQL CRUD Project with AI Form Builder — Login System, Admin Panel & Full Source Code 48 views this month PHP How to Create Multi-Level Login Form Using Google Sheets & Apps Script | B23 How to Create Multi-Level Login Form Using Google Sheets & Apps Script | B23 44 views this month Apps Script Grocery Store POS System with Barcode Scanner | Google Sheet POS + Apps Script + AI Grocery Store POS System with Barcode Scanner | Google Sheet POS + Apps Script + AI 380 views this month Apps Script

Reviews & Feedback

What buyers and YouTube viewers say about this project.

Sort
@MokimAhmedBlp via YouTube
Shukriya Bhai Aap ki Koshish se n malom kitne logon ko faida ho raha hae.
1 like on YouTube
@Prabh_hundal_01 via YouTube
Please .... how to add custom domain with apps script
1 like on YouTube
@dlhk.sumedangkab via YouTube
Woow. So cool
1 like on YouTube
@Pwilao_Narzary_Official via YouTube
Source code not available please reply
@Ahsan-Khan-e9j via YouTube
Link does not work
@myfinance_CG_official via YouTube
Sir me ek civil contractor hu sir mujhe ek app script chahiye tha jis me mujhe kuch point hai 1 employee registration 2 employee attendance 3 employee salary calculation 4 client payment history 5 invoice customise 6 data entry bas ye kuch function hai ish ke liye video post kariye
@wangzig9800 via YouTube
Excellent, can it be connected to a newsletter marketing, a normal HTML website, so when users subscribe it starts sending them newsletters from an excel sheet automatically? if can please make a tutorial thank you!