Extensions → Apps Script → paste → Deploy as Web App → Anyone
// Handles both GET and POSTfunctiondoGet(e) { returnhandleRequest(e); }
functiondoPost(e) { returnhandleRequest(e); }
functionhandleRequest(e) {
try {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var d = e.parameter;
var ts = d.timestamp || newDate().toLocaleString("en-PH",{timeZone:"Asia/Manila"});
if (d.status && d.status.startsWith("KO")) {
ss.getSheetByName("KO Log").appendRow([
ts,d.name||"",d.phone||"",d.location||"",
d.age||"",d.status||"","Web Bot",""
]);
} else {
var sh = ss.getSheetByName("Applicants");
sh.appendRow([
ts,d.name||"",d.phone||"",d.location||"",
d.age||"",d.experience||"",d.fieldwork||"",
d.smartphone||"",d.startDate||"",d.interviewPref||"",
d.status||"PASSED","Web Bot","","","",
"1. Bot screened","",
"=TODAY()-A"+(sh.getLastRow()+1)
]);
}
return ContentService.createTextOutput("OK")
.setMimeType(ContentService.MimeType.TEXT);
} catch(err) {
return ContentService.createTextOutput("Error: "+err)
.setMimeType(ContentService.MimeType.TEXT);
}
}
1
Go to sheets.google.com → create new file → name it Purple Hub Applicants
2
Add 3 tabs: Applicants, KO Log, Weekly Tracker
3
Paste headers below into Row 1 of each tab
4
Paste the Apps Script → Deploy as Web App → paste URL above
Applicants tab
Timestamp | Full Name | Phone | Location | Age Range | Experience | Fieldwork OK | Has Smartphone | Start Date Pref | Interview Pref | Status | Source | TAA Assigned | Interview Date | Interview Result | Pipeline Stage | Notes | Days in Pipeline
KO Log tab
Timestamp | Full Name | Phone | Location | Age Range | KO Reason | Source | Re-engage?