How does it detect fake attendance?

It compares the live location with the IP address on the same entry. When those two do not agree, the submission is flagged and an alert is raised.

Does it calculate total work hours?

Yes. Hours are calculated from the recorded login and logout times.

Do employees need accounts?

Yes. Each employee authenticates with a username and password before recording attendance.

Is the data available immediately?

Yes. Attendance records update in real time in your Google Sheet.

How does this compare with the other attendance systems?

This one focuses on verified login and logout with mismatch alerts and work hours. Others in the catalog add selfie capture, leave approval, holidays or full payroll.

Does the template include a video tutorial?

Yes — every Apps Script and PHP template ships with a step-by-step YouTube video tutorial showing exactly how to deploy and customize it.

Do template purchases include updates?

Yes. When a template you bought is updated, the new version appears in your portal under My Files at no extra cost.

Is VIP membership a recurring subscription?

Pricing and renewal terms are listed live at https://rameezscripts.com/plans.php — VIP unlocks every current and future template.

Is it cheaper to buy a ready-made script or build a custom system?

A ready-made script is far cheaper and faster — you deploy a tested system in minutes from $15 instead of waiting weeks for a custom build. Rameez Scripts sells ready-made Apps Script and PHP source code (POS, CRM, billing, inventory, school and loan management) and also builds custom systems when your needs are unique. Many clients start with a ready-made script, then pay for customization on top.

Do I get the full source code, and can I resell or modify it?

Yes — every purchase includes complete, editable source code with setup docs, so you fully own and can customize it. Files you download during a membership stay yours for lifetime, even after the plan ends, with resale and modification rights on eligible plans. Rameez Scripts never ships encrypted or locked code. See plans at https://rameezscripts.com/plans.php.

What technology stack does Rameez Scripts use?

Backend: Google Apps Script (V8), PHP 8+ with PDO, MySQL. Frontend: React 18 (CDN + Babel standalone), Chart.js 4.4.0, DataTables v1.13.7, jQuery 3.7.1, Font Awesome 6.5.1, SweetAlert2. AI: Google Gemini, Anthropic Claude, OpenAI APIs.

Does Rameez Scripts use templates or write custom code?

Custom code. Mohammad Rameez Imdad personally writes every line — no offshore team, no rebranded templates. Templates exist as standalone products at https://rameezscripts.com/appscript_projects.php, but custom projects are written from scratch to spec.

Is the source code provided after delivery?

Yes — full source code is delivered for every project. PHP/MySQL projects ship with the database schema. Apps Script projects ship with the Sheet template plus the full Code.gs.

How does the Google Drive access work?

Once verified, you get access to copy the file from the Rameez Scripts Google Drive directly to your own Google Drive. You receive the original file with all Apps Script functionality intact — no downloads to your computer needed.

What if I already subscribed but verification fails?

Verify with the same Google account you used to subscribe to the YouTube channel. If issues persist, contact Rameez Scripts on WhatsApp for immediate help.

Can I get this file customized for my business?

Yes — professional customization is available: extra features, design changes, new columns, custom reports, or complete modifications. Message requirements on WhatsApp for a quote.

How much does a custom project cost?

Pricing depends on complexity and scope. Simple modifications start at a very affordable rate; send requirements on WhatsApp for a clear quote with timeline — no hidden charges.

How long does a custom project take?

Small customizations take 1-2 days; bigger projects take 3-7 days. A clear timeline is shared before starting so delivery expectations are exact.

Can you build a completely new project from scratch?

Yes — custom dashboards, web apps, Google Apps Script solutions, inventory systems, CRM tools, billing software, and more. Share the idea on WhatsApp and it gets built.

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

Geo-Location Attendance with Work Hours – Google Apps Script

Name: Geo-Location Attendance with Work Hours – Google Apps Script
Brand: Rameez Scripts
Price: 0.64 USD
Availability: InStock
Author: Rameez Scripts

B36 Attendance Systems Premium Plan Weekly Plan VIP Premium Plan

How to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

You get

Google Sheet link
Source code file
Resale rights
Edit rights
Setup guide
AI setup help

Key Features

Employee authentication with username and password Login and logout times recorded Live location captured on each entry IP address recorded alongside the location Fake attendance detected from location and IP mismatches Alerts raised on suspicious submissions Total work hours calculated automatically Real-time attendance records Google Sheets as the live database

Description

An employee attendance web app that does not just record attendance — it checks it. Login and logout times are captured with the live location and the IP address, and when those two disagree with each other the system flags the submission as suspect rather than filing it quietly.

What it does

Employees authenticate with a username and password, then record their login and logout. Each entry stores the live location and the IP address it came from. The detection step is what separates this from a timesheet: a mismatch between where the device claims to be and where the network says it is raises an alert, which is exactly the pattern a faked punch produces. Total work hours are calculated from the login and logout times, and the records update in real time in Google Sheets.

Highlights

Username and password authentication
Login and logout time recording
Live location and IP address on every entry
Fake attendance detection with alerts on mismatches
Automatic total work hours calculation
Real-time attendance records in Google Sheets

Who it is for

Employers with remote, field or multi-site staff, where attendance is self-reported and needs to be verifiable. Other attendance builds in this catalog add selfie capture, leave approval or full payroll on top of the same idea.

Requirements

A Google account (Gmail or Google Workspace)
Google Sheets and Google Apps Script access — no server or hosting needed
A modern browser (Chrome, Edge, Firefox or Safari)
Location permission granted in the employee's browser

What's Included

Complete Google Apps Script backend source code
Attendance web app front-end
Google Sheets database structure for employees and attendance records
Step-by-step video walkthrough of the full build
Free support from the developer

Item Details

Version	v1.0
Published	Aug 22, 2025
Platform	Google Apps Script
Database	Google Sheets
Category	Attendance Systems
Tags	geo location based attendance systemlocation based attendance systememployee attendance google sheetsattendance system google apps scriptattendance system for employeesfake attendance detectionemployee login logout trackingwork hours calculator google sheets
Video	Watch walkthrough
License	Regular License

$0.64

Limited-time offer ends in

0days : 00hrs : 00min : 00sec

Subtotal $0.64 USD

Total $0.64 USD

Other payment methods

Wise / Bank Transfer · via WhatsApp +92 343 534 7417 ~~$1.28~~$0.64

Redotpay

How to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

Secure checkout

Amount due

$0.64$1.28

Total due

Redotpay Account

1002896884

How to pay

Copy the Redotpay account
Pay $0.64 via Redotpay
Enter the transaction reference below
Submit the details below to complete your order

Order details$0.64

Order summary

ItemHow to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

ReferenceB36

Payment MethodRedotpay

Total$0.64

You paysend the proof

proof

We approve2 hours

delivery

Your emailfiles + video guide

Your payment proofReference + screenshot — takes a minute

Full name

Your Email

Your receipt and download link will be sent to this address.

Contact / WhatsApp Number

Country code is set from your location. Change it if needed and enter the number without the code.

Redotpay Transaction ID / Reference

Payment screenshot

Upload a screenshot of the paymentDrop it here or click to browse · JPG or PNG, up to 2 MB

Confirmed typically within 2 hours (24/7)

Encrypted connection

Confirmation in 2 hours

Emailed receipt

Binance Pay

How to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

Secure checkout

Amount due

$0.64

Total due · no additional fees

Binance Pay ID

766412546

Account holder: Muahmmad Ramiz Imdad

How to pay

Open the Binance app and choose Pay
Enter the Pay ID
Send $0.64 in any supported asset
Copy the Order ID from your Binance receipt
Enter it below with a screenshot and submit

Order details$0.64

Order summary

ItemHow to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

ReferenceB36

Payment MethodBinance Pay

Total$0.64

You paysend the proof

proof

We approve2 hours

delivery

Your emailfiles + video guide

Your payment proofReference + screenshot — takes a minute

Full name

Your Email

Your receipt and download link will be sent to this address.

Contact / WhatsApp Number

Country code is set from your location. Change it if needed and enter the number without the code.

Binance Order ID / Transaction ID

Payment screenshot

Upload a screenshot of the paymentDrop it here or click to browse · JPG or PNG, up to 2 MB

Confirmed typically within 2 hours (24/7)

Encrypted connection

Confirmation in 2 hours

Emailed receipt

Cryptocurrency

How to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

Secure checkout

Amount due

$0.64

Send the equivalent amount in the selected asset

Select an asset

BTC

Ethereum

Ethereum (ERC20)

Redotpay

USDT BEP(20)

USDT TRC(20)

Wallet address

15jjKnm6NgxN1Wgbfh7xdBWgbCFztHeNhE

Send only the selected asset on the selected network. Transfers made on a different network cannot be recovered.

How to pay

Select an asset above
Copy the wallet address and send the equivalent of $0.64
Enter the transaction hash below
Submit the details below to complete your order

Order details$0.64

Order summary

ItemHow to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

ReferenceB36

Payment MethodCryptocurrency

Total$0.64

You paysend the proof

proof

We approve2 hours

delivery

Your emailfiles + video guide

Your payment proofReference + screenshot — takes a minute

Full name

Your Email

Your receipt and download link will be sent to this address.

Contact / WhatsApp Number

Country code is set from your location. Change it if needed and enter the number without the code.

Transaction Hash / TX ID

Payment screenshot

Upload a screenshot of the paymentDrop it here or click to browse · JPG or PNG, up to 2 MB

Confirmed typically within 2 hours (24/7)

Encrypted connection

Confirmation in 2 hours

Emailed receipt

PayPal

How to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

Secure checkout

Amount due

$0.64

Total due

Pay $0.64 with PayPal

Opens PayPal in a new tab. Return here with your Transaction ID to complete the submission.

How to pay

Select Pay $0.64 with PayPal; PayPal opens in a new tab
Copy the Transaction ID from your PayPal receipt
Enter it below with a screenshot of the payment, then submit
Your payment is verified and access is enabled; the download link is also emailed to you

Order details$0.64

Order summary

ItemHow to Create an Employee Attendance System Webapp Google Sheets, Apps Script & Location Track | B36

ReferenceB36

Payment MethodPayPal

Total$0.64

You paysend the proof

proof

We approve2 hours

delivery

Your emailfiles + video guide

Your payment proofReference + screenshot — takes a minute

Full name

Your Email

Your receipt and download link will be sent to this address.

Contact / WhatsApp Number

Country code is set from your location. Change it if needed and enter the number without the code.

PayPal Transaction ID

Payment screenshot

Upload a screenshot of the paymentDrop it here or click to browse · JPG or PNG, up to 2 MB

Confirmed typically within 2 hours (24/7)

Encrypted connection

Confirmation in 2 hours

Emailed receipt

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