const SHEET_NAME = 'usuarios';

function doPost(e) {
  const data = JSON.parse(e.postData.contents);
  const action = data.action;
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName(SHEET_NAME);
  
  if (action === 'cadastrar') {
    const id = 'ST' + Date.now();
    sheet.appendRow([
      id, data.nome, data.cpf, data.telefone,
      data.cidade, data.estado, data.upline_id,
      new Date().toISOString(), data.senha, 'ativo'
    ]);
    return ContentService.createTextOutput(
      JSON.stringify({success:true, id:id})
    ).setMimeType(ContentService.MimeType.JSON);
  }
  
  if (action === 'listar') {
    const rows = sheet.getDataRange().getValues();
    const headers = rows[0];
    const users = rows.slice(1).map(r => {
      const obj = {};
      headers.forEach((h,i) => obj[h] = r[i]);
      return obj;
    });
    return ContentService.createTextOutput(
      JSON.stringify({success:true, data:users})
    ).setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  return doPost(e);
}