Download & Open the CRM

Save the global-pathways-crm.html file. Open it directly in Chrome/Edge/Firefox, or upload to any web server (cPanel, Netlify, GitHub Pages, Apache, Nginx). No npm, no build step, no backend required.

Quick Start — Local Mode (No Setup)

Go to Settings → Storage Mode → Local (Browser). All data saves in your browser's localStorage. Click "Load Demo Data" to explore. This works immediately with no Google account needed.

Create a Google Sheet & Apps Script

1. Go to sheets.google.com → Create a blank spreadsheet (name it e.g. GP CRM Data).
2. In that sheet, click Extensions → Apps Script.
3. Delete all existing code, then paste the entire script below and click Save (💾).

function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var action = e.parameter.action;
  if (action === 'ping') {
    return out({ok:true, sheetName: ss.getName()});
  }
  if (action === 'load') {
    var names = ['leads','students','parents','consultants','bookings',
                 'visa','campaigns','channels','reports','users','activity'];
    var data = {};
    names.forEach(function(name) {
      var sheet = ss.getSheetByName(name);
      if (sheet && sheet.getLastRow() > 1) {
        var rows = sheet.getDataRange().getValues();
        var headers = rows[0];
        data[name] = rows.slice(1).map(function(row) {
          var obj = {};
          headers.forEach(function(h, i) {
            var v = row[i];
            if (typeof v === 'string' && (v.charAt(0)==='{' || v.charAt(0)==='[')) {
              try { v = JSON.parse(v); } catch(e2) {}
            }
            obj[h] = v;
          });
          return obj;
        });
      } else {
        data[name] = [];
      }
    });
    return out({ok:true, data:data});
  }
  return out({ok:false, error:'Unknown action'});
}

function doPost(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var payload = JSON.parse(e.postData.contents);
  if (payload.action === 'save') {
    var db = payload.db;
    Object.keys(db).forEach(function(name) {
      var arr = db[name];
      if (!arr) return;
      var sheet = ss.getSheetByName(name) || ss.insertSheet(name);
      sheet.clearContents();
      if (!arr.length) return;
      var headers = Object.keys(arr[0]);
      sheet.appendRow(headers);
      arr.forEach(function(row) {
        sheet.appendRow(headers.map(function(h) {
          var v = row[h];
          if (v === null || v === undefined) return '';
          if (typeof v === 'object') return JSON.stringify(v);
          return v;
        }));
      });
    });
    return out({ok:true});
  }
  return out({ok:false, error:'Unknown action'});
}

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

Deploy the Apps Script as a Web App

In Apps Script → click Deploy → New Deployment.
• Type: Web App
• Execute as: Me
• Who has access: Anyone
Click Deploy → Authorize → Copy the Web App URL.

Connect the CRM to Google Sheets

In the CRM go to Settings → Google Sheets Integration.
Paste the Web App URL → click Test Connection.
Once it shows ✅ Connected, click Initialize & Push Data to sync all data to the sheet.
From now on every save automatically updates Google Sheets.

Add Your Team

Go to User Management → Add staff with roles: Admin (full access), Manager (reports + leads), Consultant (own records), Data Entry (add/edit leads). Link consultant accounts to their consultant profile.

Default Login Credentials

admin / admin123 — Full Admin
Rozan / Ro456 — Admin
Aroosha / Ar678 — Admin
Team / Tm890 — Manager
consultant / consult123 — Consultant
Change passwords in User Management after first login.