News & Announcements

One-click publishing is active — Publish writes straight to the sheet, and the password is verified by Google rather than in the browser. Kept here in case the deployment ever needs rebuilding.

1. Open the News sheet › Extensions › Apps Script.
2. Delete whatever is in the editor and paste the code below.
3. Deploy › New deployment › type Web app.
4. Set Execute as to Me, and Who has access to Anyone.
5. Deploy, approve the permission prompt, and copy the /exec URL.
6. Send me that URL and I'll wire it in.

function doPost(e) {
  var NEWS_SHEET = '1K0JrkBr1EDIqlZfhla7C9Dnauxl2br6QFa9QvV4NLsg';
  var PW_SHEET   = '136R9Sl1JSmARjzXjEXd3T1CCoAlnlBqqMKUEnmvjPpA';

  var out = function (o) {
    return ContentService.createTextOutput(JSON.stringify(o))
      .setMimeType(ContentService.MimeType.JSON);
  };

  try {
    var d = JSON.parse(e.postData.contents);
    var pw = String(
      SpreadsheetApp.openById(PW_SHEET).getSheets()[0].getRange('A1').getValue()
    ).trim();

    if (String(d.pw || '').trim() !== pw) return out({ ok: false, error: 'bad password' });

    var sh = SpreadsheetApp.openById(NEWS_SHEET).getSheets()[0];
    sh.insertRowAfter(1);
    sh.getRange(2, 1, 1, 6).setValues([[
      d.date || '', d.title || '', d.body || '',
      d.image || '', d.author || '', d.pinned || 'NO'
    ]]);
    sh.getRange(2, 1, 1, 6).setNumberFormat('@');
    return out({ ok: true });
  } catch (err) {
    return out({ ok: false, error: String(err) });
  }
}