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

Free QR Code Attendance System – Google Sheets Apps Script

E31 Attendance Systems 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 QR Code Attendance System in Google Sheets with Apps Script | E31
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

QR code based attendance marking QR scanner built into the web app Admin teacher and student portals Automatic absence detection Late arrival penalties Leave request system Email notifications Real-time dashboard Google Sheets backend React dashboard front end Mobile optimised

Description

Attendance taken by scanning instead of calling names. Each student carries a QR code, the scanner is built into the web app, and the register fills itself — with the absences, the late marks and the leave requests handled by the system rather than by a teacher's memory.

Scan to mark

The QR scanner lives inside the app, so any phone or tablet camera reads a student's code and marks them present. A class that takes ten minutes to call through takes the length of a queue at the door, and there is no transcription step afterwards where errors get introduced.

What it works out for itself

Anyone not scanned by the cut-off is marked absent automatically — absence is the default the system infers, not a second job for the teacher. Late arrivals are caught by the time of the scan and carry their own penalty rule, so a pattern of late arrivals shows up as data rather than as a complaint.

Three portals

Admin, teacher and student each get their own view: the admin over the whole institution, teachers over their classes, students over their own record and their leave requests. Leave is applied for in the app and decided there, and email notifications keep parents or staff informed without anyone sending messages by hand.

Underneath

A React dashboard with live attendance figures, Google Sheets as the database so the register stays exportable, and a mobile-optimised layout because the scanning happens on a phone at a classroom door.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets and Google Apps Script — no hosting or server needed
  • A phone or tablet with a camera for scanning
  • Printed QR codes for students or staff
  • Gmail for the email notifications

What's Included

  • Complete Google Apps Script source code
  • QR scanner built into the web app
  • Admin, teacher and student portals
  • Automatic absence detection and late-arrival penalties
  • Leave request and approval flow
  • Email notifications
  • Real-time React dashboard
  • Google Sheets structure for students, classes and attendance
  • Step-by-step video walkthrough of the full build
  • Free support from the developer

Item Details

Versionv1.0
PublishedJan 18, 2026
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryAttendance Systems
Tagsqr code attendance system google sheetsqr code attendance systemqr code attendance system source codeqr code attendance system for studentsattendance using qr codeqr code attendance system freeqr code attendance system projectstudent attendance system google sheets
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

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

What We Customize

Features & Functions
Add new features, modify existing scripts, custom formulas & automations
API & Integrations
Connect with WhatsApp, 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 quote before work begins • Support included after delivery

Free
Source Code File

People choose these

What buyers of this file added to the same order

I Built a Salon Management System with ERP + CRM Dashboard & Web App - Google Sheets + Apps Script I Built a Salon Management System with ERP + CRM Dashboard & Web App - Google Sheets + Apps Script Bought with this one Apps Script I Built a GST Billing Software with Claude Code That Actually Works (PHP MySQL + Source Code) I Built a GST Billing Software with Claude Code That Actually Works (PHP MySQL + Source Code) Bought with this one PHP Build a Gym Management System with Claude Code & Google Sheets Build a Gym Management System with Claude Code & Google Sheets Bought with this one Apps Script

Reviews & Feedback

What buyers and viewers say about How to Create QR Code Attendance System in Google Sheets with Apps Script | E31.

No star ratings yet Tap a star to be the first to rate it.
22 comments from
YouTube viewers
Sort
@foodmastiIndia via YouTube
a decent and elaborative system for Attendance .
1 like on YouTube
@DurvishJawaleOfficial via YouTube
Cool app❤❤ Useful❤❤❤
1 like on YouTube
@Mr_Roblox_Story via YouTube
Brother the system is great. But i have a question how can i add custom grade?
@RMRITCONNECT via YouTube
Camera Error Unable to access camera. Please grant camera permissions. how to solve it?
@NORTH-s8o via YouTube
I love you Rameez,,,❤❤ your work is the best...if i success i wil donate for you. Thx...
@O_hcomp via YouTube
my camera not function, king. pls help me
@BNCHSSSLG26-27 via YouTube
how can i open it on my phone?
@hnourkonsult5329 via YouTube
Nice project as usual
@mfaizan5075 via YouTube
Boht zabardast system he
@ZaheerAbro-p2c via YouTube
Very nice project & Dear Ramiz
@pinkygamit9139 via YouTube
Fine...Wonderful Web App Helping us...👌
@vipulchaudhari4437 via YouTube
Thsnks Bro...Attendance System For Schools and Teachers ....❤❤🎉
@khanasadullah5125 via YouTube
Hazir hun guru ji
@hnourkonsult5329 via YouTube
Very nice project always 🎉
@Skyxxa via YouTube
nc project 😮
@keshabmaity9436 via YouTube
Please make a complete advance level Inventory Management System
@rasc-c5e via YouTube
Nice System 🎉
@MdMohiuddin-r1b via YouTube
This is one of your best videos. ❤
@csptechinspiration via YouTube
Very good application for teachers
@eduhindi via YouTube
🎉 Awesome Think Nice Approach, helping
@irfanchauhan495 via YouTube
Wonderful Work 🎉
@M.K.Kalaiyarasan via YouTube
Nice system bro it’s very helpful 👍👍👍👍