Call Center Login Tracker

Add Employee

Bulk Import Employees (CSV)

One employee per line: userId,name,password,standardTime,role — e.g. agent001,Jane Smith,Pass123,09:00,user. A header row is skipped automatically. Standard time defaults to 09:00 and role to user if blank. Existing User IDs are updated (name/password/time/role overwritten); new ones are added. Every imported employee is also pushed to the Master Data tab in Google Sheets.

All Employees (0/100)

User ID	User Name	Standard Time	Access	Times Late	Times Early (Left Early)	Last Login	Actions

Record an Early Departure

There is no logout button in this tracker, so early departures are logged manually here — kept in a separate record from login times.

All Early Departure Records

User ID	User Name	Date	Time Left	Reason	Actions

Overview — All Employees

Fixed to today and the current calendar month, across every employee — unaffected by the Range/Employee filters below.

Devices — All Time, All Employees

One row per browser/computer that has ever logged in (identified by a per-browser ID, not hardware — see Settings for the caveats on that). A device used by more than one User ID is flagged Shared — that's the buddy-punching signal: the same computer being used to log in multiple different employees.

Device	First Seen	Total Logins	Users Seen On It

User ID	User Name	Date	Login Time	Access	Status	Device

Early Departures in Range

User ID	User Name	Date	Time Left	Reason

Late Login Grace Period

Grace period (minutes)

A login within the grace period after the standard time is still counted as on time.

Google Sheets Export

A browser page cannot write to Google Sheets directly, and it cannot use the spreadsheet's normal edit link either. You must deploy the Apps Script below as a Web App from inside your target spreadsheet (this one, if that's the sheet you're using), then paste the resulting URL here (it ends in /exec, not /edit). The script writes to three tabs: Login, Early Departure, and Master Data. The Master Data tab is matched by its internal sheet ID (gid=9681607) so it lands in the correct existing tab with headers User ID / User Name / Password / Standard Login Time / Access regardless of what that tab is named — if no tab with that ID exists in the spreadsheet the script is deployed on, it creates a new one called "Master Data" instead. Every employee add/edit, login, and early departure entry is pushed automatically the instant it happens — no button press needed. The Reports tab reads directly from this spreadsheet (not this browser's local storage), so it reflects everyone's logins across every device. The backfill buttons in Reports and here only push this browser's local records up — use them to catch up old data, not for normal viewing.

If new employees are showing up in the Login tab instead of Master Data, the live deployment is still running an older version of this script. Editing the code here does nothing to the live URL by itself — you must go to Deploy → Manage deployments → Edit (pencil) → New version → Deploy for the fix to take effect.

Device tracking added two columns — Device ID and Device Label — to the Login tab. The script only writes headers when it CREATES a sheet, so if your Login tab already exists, add "Device ID" in G1 and "Device Label" in H1 yourself; the script won't retroactively add them. Then redeploy as above (New version → Deploy) so the live URL actually runs this updated code.

Passwords are stored and synced as plain text, per your setup — anyone with edit or view access to this spreadsheet can see every employee's password. Restrict sharing on this sheet accordingly.

Apps Script Web App URL

Every employee added or edited on the Employees tab is pushed automatically to the Master Data tab in this spreadsheet (matched by User ID, so editing someone overwrites their row instead of duplicating it). Use the button below only to push everyone already stored in this browser — e.g. right after saving the URL for the first time, or if an employee was added before the URL was configured.

1. Open your spreadsheet → Extensions → Apps Script.
2. Delete any existing code and paste the script below.
3. Click Deploy → New deployment → gear icon → type "Web app".
4. Execute as: Me. Who has access: Anyone. Click Deploy, then authorize when prompted.
5. Copy the URL ending in /exec and paste it into the field above, then Save.
6. If you edit the script later, you must go to Deploy → Manage deployments → Edit (pencil) → New version → Deploy — saving the script alone does not update the live URL.
7. To sanity-check reads work, paste that same /exec URL into a new browser tab — you should see raw JSON with your Login and Early Departure rows, not an error page.

// The Master Data tab is matched by internal sheet ID, not name, so it lands
// in whichever existing tab has this ID even if you've renamed it. Find the
// right number by opening the tab in your browser and reading the "gid="
// value at the end of the URL.
var MASTER_DATA_SHEET_GID = 9681607;

function doPost(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var data = JSON.parse(e.postData.contents);

  // TEMPORARY DEBUG — writes exactly what arrived and which branch it took to
  // a "Debug" tab. Delete this block (and the dbg.appendRow line below) once
  // the routing issue is confirmed fixed.
  var dbg = ss.getSheetByName('Debug') || ss.insertSheet('Debug');
  if (dbg.getLastRow() === 0) dbg.appendRow(['Timestamp','Branch Taken','Raw Row JSON']);

  var headers = {
    'Login': ['User ID','User Name','Date','Login Time','Access','Status','Device ID','Device Label'],
    'Early Departure': ['User ID','User Name','Date','Time Left','Reason']
  };

  function getOrCreateSheet(name) {
    var sheet = ss.getSheetByName(name);
    if (!sheet) {
      sheet = ss.insertSheet(name);
      sheet.appendRow(headers[name]);
    }
    return sheet;
  }

  function getMasterDataSheet() {
    var sheets = ss.getSheets();
    for (var i = 0; i < sheets.length; i++) {
      if (sheets[i].getSheetId() === MASTER_DATA_SHEET_GID) return sheets[i];
    }
    // Fallback: this spreadsheet doesn't have a tab with that ID — create one.
    var s = ss.insertSheet('Master Data');
    s.appendRow(['User ID','User Name','Password','Standard Login Time','Access']);
    return s;
  }

  // Employees are matched by User ID and overwritten in place, so editing an
  // employee updates their existing row instead of appending a duplicate.
  function upsertUserRow(sheet, r) {
    var lastRow = sheet.getLastRow();
    if (lastRow >= 2) {
      var ids = sheet.getRange(2, 1, lastRow - 1, 1).getValues();
      for (var row = 0; row < ids.length; row++) {
        if (String(ids[row][0]) === String(r.userId)) {
          sheet.getRange(row + 2, 1, 1, 5).setValues([[r.userId, r.userName, r.password, r.standardLoginTime, r.access]]);
          return;
        }
      }
    }
    sheet.appendRow([r.userId, r.userName, r.password, r.standardLoginTime, r.access]);
  }

  data.rows.forEach(function(r) {
    var branch;
    if (r.type === 'Early Departure') {
      branch = 'Early Departure';
      var s = getOrCreateSheet('Early Departure');
      s.appendRow([r.userId, r.userName, r.date, r.time, r.status]);
    } else if (r.type === 'User') {
      branch = 'Master Data';
      upsertUserRow(getMasterDataSheet(), r);
    } else {
      branch = 'Login (fallback — r.type was: ' + JSON.stringify(r.type) + ')';
      var s2 = getOrCreateSheet('Login');
      s2.appendRow([r.userId, r.userName, r.date, r.time, r.access, r.status, r.deviceId || '', r.deviceLabel || '']);
    }
    dbg.appendRow([new Date(), branch, JSON.stringify(r)]);
  });

  return ContentService.createTextOutput(JSON.stringify({ok:true}))
    .setMimeType(ContentService.MimeType.JSON);
}

// Reports in the page call this (GET) to read data straight from the spreadsheet.
function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  function readSheet(name) {
    var sheet = ss.getSheetByName(name);
    if (!sheet || sheet.getLastRow() < 2) return [];
    var values = sheet.getDataRange().getValues();
    values.shift(); // drop header row
    return values;
  }

  // Sheets sometimes silently converts appended date/time strings into real
  // Date objects. Reformat them back to plain strings so the page's string
  // comparisons (e.g. date range filtering) keep working either way.
  function fmtDate(v) {
    return (Object.prototype.toString.call(v) === '[object Date]')
      ? Utilities.formatDate(v, Session.getScriptTimeZone(), 'yyyy-MM-dd') : v;
  }
  function fmtTime(v) {
    return (Object.prototype.toString.call(v) === '[object Date]')
      ? Utilities.formatDate(v, Session.getScriptTimeZone(), 'HH:mm:ss') : v;
  }

  var logins = readSheet('Login').map(function(r) {
    return {
      userId: r[0], userName: r[1], date: fmtDate(r[2]), time: fmtTime(r[3]), access: r[4], status: r[5],
      deviceId: r[6] || '', deviceLabel: r[7] || ''
    };
  });
  var early = readSheet('Early Departure').map(function(r) {
    return { userId: r[0], userName: r[1], date: fmtDate(r[2]), time: fmtTime(r[3]), reason: r[4] };
  });

  return ContentService.createTextOutput(JSON.stringify({ logins: logins, early: early }))
    .setMimeType(ContentService.MimeType.JSON);
}

// Do NOT click Run on doPost above — the editor calls it with no event and
// it will throw "Cannot read properties of undefined (reading 'postData')".
// Run this instead to verify the script writes to all three tabs correctly.
function testDoPost() {
  var fakeEvent = {
    postData: {
      contents: JSON.stringify({
        rows: [
          { type: 'User', userId: 'test1', userName: 'Test User', password: 'testpass', standardLoginTime: '09:00', access: 'User Access' },
          { type: 'Login', userId: 'test1', userName: 'Test User', date: '2026-01-01', time: '09:15:00', access: 'User Access', status: 'Late 15 min' },
          { type: 'Early Departure', userId: 'test1', userName: 'Test User', date: '2026-01-01', time: '16:30', status: 'test reason' }
        ]
      })
    }
  };
  doPost(fakeEvent);
}

// Run this to check what doGet would return (view results in the execution log).
function testDoGet() {
  Logger.log(doGet().getContent());
}

Data

Employees, standard login times, and passwords are stored in this browser's local storage only — they do not sync across devices and are cleared if browser data is cleared. The Reports tab is the exception: it reads live from the Google Sheet, so it reflects logins and early departures recorded on any device, as long as this browser and the device recording the event both point at the same Sheets URL. Passwords here are stored as plain text for admin visibility/reset — do not reuse sensitive personal passwords.