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

Free Employee Payslip Portal with OTP – Google Sheets

E15 HR & Payroll Pro Apps Script Pass Business
❤️
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.
Google Sheets Payslip Generator with OTP Security | Free Apps Script Payroll System 2025 | E15
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

Secure OTP verification via Gmail Professional payslip template Multi-sheet support for departments Employee self-service portal Employees fetch their own payslip by email OTP No coding needed to set up Runs free on Google Sheets and Apps Script

Description

The lightest way to stop being the person who emails payslips one by one. Employees open a link, enter their email, verify the code that arrives, and their own payslip appears. Nothing to install, no accounts to create, no coding to set it up.

Identity by OTP, not by login

There is no user table and no password to reset. The employee's email address is the identity, and a one-time code sent to that address is the proof. That keeps salary data private — you cannot see someone else's slip without access to their inbox — while removing the whole burden of managing accounts for staff who will use this twelve times a year.

Departments in their own sheets

Multi-sheet support means each department, branch or month can live in its own sheet rather than one enormous tab, and the portal still finds the right employee. The payslip itself uses a clean professional template, ready to print or save.

Setup without code

Salary data goes in the sheet, the script is deployed as a web app, and the link goes to staff. There is nothing to edit in the code to make it work with your own columns and no server to arrange — which is the whole point of building payroll delivery on Sheets.

Which payslip project to pick

This is the simplest of the three. If you want company branding and currency settings on the slip, look at the OTP-secured payslip generator. If you need an admin dashboard, employee records, bulk emailing and monthly payroll reports, the payslip management system is the larger build.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets and Google Apps Script — no hosting or server needed
  • Gmail for sending the OTP codes
  • Employee salary data with a valid email address per employee

What's Included

  • Complete Google Apps Script source code
  • OTP email verification through Gmail
  • Employee self-service payslip portal
  • Professional payslip template
  • Multi-sheet support for departments or months
  • Google Sheets structure for salary data
  • Step-by-step video walkthrough of the full setup
  • Free support from the developer

Item Details

Versionv1.0
PublishedNov 20, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryHR & Payroll
Tagspayslip generator google sheetssalary slip generatoremployee self service payslip portalpayslip generator freeotp email verification apps scriptpayslip template google sheetssalary slip generator google sheetsgenerate payslip from spreadsheet
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

How to Make Employee Payslip Management System in Google Apps Script | D34 How to Make Employee Payslip Management System in Google Apps Script | D34 52 views this month Apps Script How to Make HR Leave Tracker Web App Dashboard with Google Sheets + Apps Script | D25 How to Make HR Leave Tracker Web App Dashboard with Google Sheets + Apps Script | D25 37 views this month Apps Script Employee Salary Management System | HR Payroll Dashboard with Google Sheets DB | D27 Employee Salary Management System | HR Payroll Dashboard with Google Sheets DB | D27 52 views this month Apps Script

Reviews & Feedback

What buyers and YouTube viewers say about this project.

Sort
@XopunBeats via YouTube
Contact us form bana ke dikaye na google sheet to app script
3 likes on YouTube
@irfanchauhan495 via YouTube
Really, So Helpful for Monthly Pay Slip 🎉
2 likes on YouTube
@XopunBeats via YouTube
Student marksheet lekin passport photo ke sath
2 likes on YouTube
@DurvishJawaleOfficial via YouTube
You always improve old projects and also bring new projects. This project is also amazing 🔥 🔥 🔥 ❤❤❤
1 like on YouTube
@IshfaqAhmadBhat-p8m via YouTube
nice video ✌
@rc.labs01 via YouTube
Nice one. Bro create an e-commerce website where there is one main admin who uploads products from different sellers. Each seller should have a business profile with their name, short description, phone number, and location, and all their products should appear under their section. Each product must also have a label/category, and when a user clicks a label, it should show all products under that label. When a customer places an order, the site should send an email to the admin with the order and seller details, and it should also send a confirmation email to the buyer with their order details. The website should be fully mobile-responsive.