Enterprise Portal - Google Sheets Powered

Message here...

Backend Connection

Connect your custom Google Sheet endpoint

Google Sheets Integration Guide

Set up your database in 3 minutes

1 Create Your Google Sheet

Create a new sheet, name the sheet tab Users, and add headers in Row 1:

2 Add Google Apps Script

Go to Extensions > Apps Script, paste the code below into Code.gs, and click Save:

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    var email = (data.email || "").trim().toLowerCase();
    var password = data.password || "";

    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Users");
    var values = sheet.getDataRange().getValues();

    for (var i = 1; i < values.length; i++) {
      var userEmail = String(values[i][0]).trim().toLowerCase();
      var userPassword = String(values[i][1]);
      var userName = values[i][2];
      var userRole = values[i][3];

      if (userEmail === email && userPassword === password) {
        return createResponse({
          success: true,
          user: { name: userName, email: userEmail, role: userRole }
        });
      }
    }

    return createResponse({ success: false, message: "Invalid credentials." });
  } catch (err) {
    return createResponse({ success: false, message: err.toString() });
  }
}

function createResponse(obj) {
  return ContentService.createTextOutput(JSON.stringify(obj))
    .setMimeType(ContentService.MimeType.JSON);
}

3 Deploy Web App

1. Click Deploy > New deployment.
2. Select type ⚙️ Web App.
3. Set Execute as: Me and Who has access: Anyone.
4. Copy the Web App URL and paste it into .

Reset Password

Enter your email to receive recovery instructions.

Sanjeev Industrial Corporation

Alex Morgan

System Access Log

Employee Login