When configured, every time a member checks a square, their name, score, lines, and completed tasks automatically update in your Google Sheet.
Quick Google Sheets Setup:
- Create a Google Sheet with headers in Row 1:
Member Name | Completed Count | Lines | Blackout | Completed Tasks | Last Updated
- Click Extensions > Apps Script, paste the code below, and click Deploy > New deployment > Web app (set access to Anyone).
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
var name = (data.memberName || "Unnamed Member").trim();
var rows = sheet.getDataRange().getValues();
var rowIndex = -1;
for (var i = 1; i < rows.length; i++) {
if (String(rows[i][0]).toLowerCase() === name.toLowerCase()) {
rowIndex = i + 1;
break;
}
}
var rowData = [
name,
data.completedCount + " / 30",
data.linesCount + " / 11",
data.isBlackout ? "YES" : "No",
(data.completedTasks || []).join(", "),
new Date()
];
if (rowIndex > 0) {
sheet.getRange(rowIndex, 1, 1, rowData.length).setValues([rowData]);
} else {
sheet.appendRow(rowData);
}
return ContentService.createTextOutput(JSON.stringify({ status: "ok" }))
.setMimeType(ContentService.MimeType.JSON);
}