How to Connect Your Google Sheet
- Go to sheets.google.com → Create a new spreadsheet
- Name it "Bayanihan Golf Scores"
- Set up sheets with these tab names: Open Division, Senior Division, Ladies Division
- Each sheet matches your layout: Row 1 = Division name, Row 2 = "System 36 Net Scores", Row 3 = headers (No | Name | Day 1–6 | Total), Row 4+ = players
- Enter player scores in rows below (leave blank if not yet played)
- Click Extensions → Apps Script → delete any code → paste the script below
- Click Deploy → New Deployment → Web App
- Set "Who has access" to Anyone → Deploy → copy the URL → paste above
function doGet(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var divisions = ['Open Division','Senior Division','Ladies Division'];
var result = {};
divisions.forEach(function(name) {
var sheet = ss.getSheetByName(name);
if (!sheet) { result[name] = []; return; }
// Your sheet: Row 1 = "Open Division", Row 2 = "System 36 Net Scores"
// Row 3 = headers (No, Name, Day1...Day6, Total)
// Row 4 onwards = player data
// Columns: A=No, B=Name, C=Day1, D=Day2, E=Day3,
// F=Day4, G=Day5, H=Day6, I=Total
var lastRow = sheet.getLastRow();
if (lastRow < 4) { result[name] = []; return; }
var data = sheet.getRange(4, 1, lastRow - 3, 9).getValues();
var rows = [];
data.forEach(function(row) {
if (!row[1]) return; // skip if no name in column B
rows.push({
no: row[0],
name: row[1],
d1: row[2] !== '' ? row[2] : '',
d2: row[3] !== '' ? row[3] : '',
d3: row[4] !== '' ? row[4] : '',
d4: row[5] !== '' ? row[5] : '',
d5: row[6] !== '' ? row[6] : '',
d6: row[7] !== '' ? row[7] : '',
total: row[8] !== '' ? row[8] : ''
});
});
result[name] = rows;
});
return ContentService
.createTextOutput(JSON.stringify(result))
.setMimeType(ContentService.MimeType.JSON);
}