function showModal() { var html = HtmlService.createHtmlOutputFromFile('Index') .setWidth(400) .setHeight(300); SpreadsheetApp.getUi().showModalDialog(html, 'Select a Sheet'); }
function getSheetNames() { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); var sheetNames = sheets.map(sheet => sheet.getName()); return sheetNames; }
function findSheetData(sheetName) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName); if (!sheet) return { success: false, data: [] };
var data = sheet.getDataRange().getValues(); return { success: true, data: data }; }