Get an email when your lock starts to unlock using Google Apps Script

Code.gs

const lockId = "PASTE_YOUR_LOCK_ID_HERE";

function checkIfEmailSentAlready() {
  const sheetId = "PASTE_YOUR_SPREADSHEET_ID_HERE";

  const sheet = SpreadsheetApp.openById(sheetId);

  const columns = sheet
    .getRange("A1:B1000")
    .getValues()
    .filter((x) => x[0]);

  const found = columns.find((x) => x[0] == lockId);

  if (!found) {
    sheet.appendRow([lockId, 1]);
    return false;
  }

  return true;
}

function checkTimeLock() {
  const apiAccessToken = "PASTE_API_ACCESS_TOKEN_HERE";

  const emailAddress = "WRITE_YOUR_EMAIL_ADDRESS_HERE";
  const emailSubject = "Your time-locked secret started to unlock! " + lockId;
  const emailBody = `Key ID: ${lockId}. Checkout the status on https://sondhi.app`;

  const emailSent = checkIfEmailSentAlready();

  // Time-lock Status API
  const result = UrlFetchApp.fetch("https://timelock.sondhi.app/key/status", {
    headers: {
      api_access_token: apiAccessToken,
      "cache-control": "no-cache",
      "content-type": "application/json",
    },
    contentType: "application/json",
    payload: `{\"uuid\":\"${lockId}\"}`,
    method: "POST",
  });

  Logger.log(result);

  const key = JSON.parse(result).key;

  if (!key.unlock_at) {
    Logger.log("Still Locked");
  } else if (!emailSent) {
    GmailApp.sendEmail(emailAddress, emailSubject, emailBody);
  }
}

function test_checkIfEmailSentAlready() {
  Logger.log(checkIfEmailSentAlready());
}