Acompanhamento de campanhas

function doGet(e) {
  const sheet = SpreadsheetApp
    .openById('14VgLDJdTVzvSCqkOEzwnflqDNJLdP1yAjqZbIztVCBo')
    .getSheetByName('leads_utm_medium_pesquisa');
  const data = sheet.getDataRange().getValues();
  const headers = data[0];
  const rows = data.slice(1).map(row => {
    const obj = {};
    headers.forEach((h, i) => obj[h] = String(row[i] ?? ''));
    return obj;
  }).filter(r => r['ID do Lead']);
  return ContentService
    .createTextOutput(JSON.stringify({ status: 'ok', data: rows }))
    .setMimeType(ContentService.MimeType.JSON);
}