Setup Guides

Google Sheets (Recommended)

Connect your Clipping Data app to Google Sheets so that when you tap Finish, a row is added to your sheet.

1. Open a new Google Sheet (or an existing one).
2. Click Extensions → Apps Script.
3. Delete anything in the editor and paste this script:

function doPost(e){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getSheetByName("Clipping Data");
  if(!sh){ 
    sh = ss.insertSheet("Clipping Data");
    sh.appendRow(["Date","Hole","Litres","HOC","GreenSize (m2)","ml/m2"]);
  }
  var d = JSON.parse(e.postData.contents);
  // Accept single object or {rows:[...]}
  var rows = Array.isArray(d.rows) ? d.rows : [d];
  var out = rows.map(function(r){ return [
    r.date || new Date().toISOString().slice(0,10),
    (r.hole||'').toString().toUpperCase(),
    Number(r.litres||0),
    r.hoc||r.heightOfCut||"",
    r.greenSize||"",
    r.mlPerM2||""
  ];});
  sh.getRange(sh.getLastRow()+1,1,out.length,6).setValues(out);
  return ContentService.createTextOutput("OK");
}

4. Click Deploy → New deployment.
5. In the dialog, click Select type and choose Web app.
6. Click Authorize if prompted, and approve the permissions (the script only writes to your sheet).
7. Set Execute as: Me · Who has access:
   • Anyone with the link (easiest; works for all clubs), or
   • Only in your organisation (best if your club uses Google Workspace).
8. Click Deploy, then copy the Web App URL (it must end with /exec).
9. Paste the URL into your app’s Settings → Spreadsheet Sync box, then Save.
10. Enter litres in the app and tap Finish — a new row should appear in the Clipping Data tab.

Excel

Note: Excel is not natively supported by this app.

Excel users: Export from Google Sheets as CSV (File → Download), or use a connector (Zapier/Make/Power Automate).

Security

All data is sent over HTTPS to your Google Sheet. Only staff with your club’s login key can submit data from the app.