function doGet(e) {
try {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var result = { sheets: {} };
var names = ['YTD Dashboard','Controls','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'];
names.forEach(function(name) {
var sheet = ss.getSheetByName(name);
if (sheet) result.sheets[name] = sheet.getDataRange().getValues();
});
return ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON);
} catch (err) {
return ContentService.createTextOutput(JSON.stringify({error: err.toString()})).setMimeType(ContentService.MimeType.JSON);
}
}
Step 4: Click Save (Ctrl+S)console.anthropic.com → API KeysAdd a Claude API key in settings for AI-powered deep analysis.
| Week | Hullk v4.2 | Win% | QZeus v1.2a | Win% | Elevator v2 | Win% | Hullk 5min | Win% | Week Total |
|---|