🔒 Daily activity minimums are set by your coach and cannot be changed here. Contact Coach Mike to discuss adjustments.

function doPost(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var data = JSON.parse(e.postData.contents);
  var sheet;
  if (data.type === 'daily_log') {
    sheet = ss.getSheetByName('Daily Logs');
    if (sheet.getLastRow() === 0) {
      sheet.appendRow(['Timestamp','Agent','Email','Cohort','Date','Completion%',
      'Calls','Convos','Contacts','Voicemails','Texts','TextReplies',
      'Emails','EmailReplies','Doors','DoorConvos','CMAs','Packets',
      'FollowUps','NewLeads','PipelineUpdated','ApptsSet','ApptsHeld',
      'ListingPres','Signed','ScriptPractice','Training','AcctPost']);
    }
    sheet.appendRow([data.timestamp,data.agent,data.email,data.cohort,data.date,
    data.completion_pct,data.calls,data.convos,data.contacts,data.vm,
    data.texts,data.treplies,data.emails,data.ereplies,data.doors,
    data.dcv,data.cma,data.packets,data.fu,data.newleads,data.pu,
    data.appts,data.appth,data.lpres,data.signed,data.script,data.training,data.acct]);
  } else if (data.type === 'pipeline_update') {
    sheet = ss.getSheetByName('Pipeline');
    if (sheet.getLastRow() === 0) {
      sheet.appendRow(['Timestamp','Agent','Cohort','Date','Lead Name','Address','Price','Stage']);
    }
    sheet.appendRow([data.timestamp,data.agent,data.cohort,data.date,
    data.lead_name,data.address,data.price,data.stage]);
  }
  return ContentService.createTextOutput(JSON.stringify({status:'ok'}))
    .setMimeType(ContentService.MimeType.JSON);
}
function doGet(e) {
  return ContentService.createTextOutput('ELC Dashboard API running.');
}

📋 Copy Apps Script Code 🔌 Test Connection

Status: Not connected — paste your Apps Script URL in the HTML file