[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_207":208,"_209":210},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":25,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",44,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","mailer.ts","latestPath","fileId","c5a4be9a-5387-11f1-8344-ee650bb23af1","name","fileType","script","content","/**\n * Servicio de envío de correos vía SMTP.\n *\n * Variables de entorno requeridas:\n * - SMTP_HOST: Host del servidor SMTP (ej: smtp.gmail.com)\n * - SMTP_PORT: Puerto (ej: 587)\n * - SMTP_USER: Usuario SMTP\n * - SMTP_PASS: Contraseña o App Password\n * - SMTP_FROM: Dirección \"from\" del correo (ej: notificaciones@empresa.com)\n */\n\nimport { SMTPClient } from \"https://deno.land/x/denomailer@1.6.0/mod.ts\";\n\nfunction getSmtpConfig() {\n const host = Deno.env.get(\"SMTP_HOST\");\n const port = Deno.env.get(\"SMTP_PORT\");\n const user = Deno.env.get(\"SMTP_USER\");\n const pass = Deno.env.get(\"SMTP_PASS\");\n const from = Deno.env.get(\"SMTP_FROM\");\n\n if (!host || !port || !user || !pass || !from) {\n throw new Error(\n \"Faltan variables de entorno SMTP. Requeridas: SMTP_HOST, SMTP_PORT, SMTP_USER, SMTP_PASS, SMTP_FROM\",\n );\n }\n\n return { host, port: Number(port), user, pass, from };\n}\n\nexport async function sendScheduleEmail(\n to: string,\n name: string,\n days: string[],\n): Promise {\n const config = getSmtpConfig();\n const daysList = days.join(\", \");\n\n const subject = `📅 Tu horario de oficina para esta semana`;\n\n // Mantenemos solo la versión de texto plano\n const text =\n `Hola ${name},\\n\\nEsta semana debes ir a la oficina los días: ${daysList}.\\n\\n¡Que tengas una excelente semana!`;\n\n const client = new SMTPClient({\n connection: {\n hostname: config.host,\n port: config.port,\n tls: true,\n auth: {\n username: config.user,\n password: config.pass,\n },\n },\n });\n\n try {\n await client.send({\n from: config.from,\n to,\n subject,\n content: text, // Enviamos únicamente la propiedad content\n });\n console.log(`✅ Correo de texto enviado a ${name} (${to}): ${daysList}`);\n } catch (error) {\n // Añadí un bloque catch para que puedas ver el error exacto en consola si falla\n console.error(`❌ Error enviando a ${name} (${to}):`, error);\n } finally {\n await client.close();\n }\n}\n\nexport async function sendErrorEmail(dest: Array<{ name; to }>): Promise {\n const config = getSmtpConfig();\n\n const subject = `😅 No encontramos tu horario para esta semana`;\n const client = new SMTPClient({\n connection: {\n hostname: config.host,\n port: config.port,\n tls: true,\n auth: {\n username: config.user,\n password: config.pass,\n },\n },\n });\n\n for (const { name, to } of dest) {\n // Mantenemos solo la versión de texto plano\n const text =\n `Hola ${name},\\n\\nNo hemos podido encontrar tu horario. Puedes consultarlo aqui: https://docs.google.com/spreadsheets/d/1xQFlWjwMARiTKmtnKVZUWJ6TdlTz9W6HREonqNLOu2E/edit?gid=195547537#gid=195547537`;\n\n try {\n await client.send({\n from: config.from,\n to,\n subject,\n content: text, // Enviamos únicamente la propiedad content\n });\n console.log(`✅ Correo de texto enviado a ${name} (${to}): Error`);\n } catch (error) {\n // Añadí un bloque catch para que puedas ver el error exacto en consola si falla\n console.error(`❌ Error enviando a ${name} (${to}):`, error);\n } finally {\n await client.close();\n }\n }\n}","/**\n * Servicio de envío de correos vía SMTP.\n *\n * Variables de entorno requeridas:\n * - SMTP_HOST: Host del servidor SMTP (ej: smtp.gmail.com)\n * - SMTP_PORT: Puerto (ej: 587)\n * - SMTP_USER: Usuario SMTP\n * - SMTP_PASS: Contraseña o App Password\n * - SMTP_FROM: Dirección \"from\" del correo (ej: notificaciones@empresa.com)\n */\n\nimport { SMTPClient } from \"https://deno.land/x/denomailer@1.6.0/mod.ts\";\n\nfunction getSmtpConfig() {\n const host = Deno.env.get(\"SMTP_HOST\");\n const port = Deno.env.get(\"SMTP_PORT\");\n const user = Deno.env.get(\"SMTP_USER\");\n const pass = Deno.env.get(\"SMTP_PASS\");\n const from = Deno.env.get(\"SMTP_FROM\");\n\n if (!host || !port || !user || !pass || !from) {\n throw new Error(\n \"Faltan variables de entorno SMTP. Requeridas: SMTP_HOST, SMTP_PORT, SMTP_USER, SMTP_PASS, SMTP_FROM\",\n );\n }\n\n return { host, port: Number(port), user, pass, from };\n}\n\nexport async function sendScheduleEmail(\n to: string,\n name: string,\n days: string[],\n): Promise {\n const config = getSmtpConfig();\n const daysList = days.join(\", \");\n\n const subject = `📅 Tu horario de oficina para esta semana`;\n\n // Mantenemos solo la versión de texto plano\n const text =\n `Hola ${name},\\n\\nEsta semana debes ir a la oficina los días: ${daysList}.\\n\\n¡Que tengas una excelente semana!`;\n\n const client = new SMTPClient({\n connection: {\n hostname: config.host,\n port: config.port,\n tls: true,\n auth: {\n username: config.user,\n password: config.pass,\n },\n },\n });\n\n try {\n await client.send({\n from: config.from,\n to,\n subject,\n content: text, // Enviamos únicamente la propiedad content\n });\n console.log(`✅ Correo de texto enviado a ${name} (${to}): ${daysList}`);\n } catch (error) {\n // Añadí un bloque catch para que puedas ver el error exacto en consola si falla\n console.error(`❌ Error enviando a ${name} (${to}):`, error);\n } finally {\n await client.close();\n }\n}\n\nexport async function sendErrorEmail(dest: Array<{ name; to }>): Promise {\n const config = getSmtpConfig();\n\n const subject = `😅 No encontramos tu horario para esta semana`;\n const client = new SMTPClient({\n connection: {\n hostname: config.host,\n port: config.port,\n tls: true,\n auth: {\n username: config.user,\n password: config.pass,\n },\n },\n });\n\n for (const { name, to } of dest) {\n // Mantenemos solo la versión de texto plano\n const text =\n `Hola ${name},\\n\\nNo hemos podido encontrar tu horario. Puedes consultarlo aqui: https://docs.google.com/spreadsheets/d/1xQFlWjwMARiTKmtnKVZUWJ6TdlTz9W6HREonqNLOu2E/edit?gid=195547537#gid=195547537`;\n\n try {\n await client.send({\n from: config.from,\n to,\n subject,\n content: text, // Enviamos únicamente la propiedad content\n });\n console.log(`✅ Correo de texto enviado a ${name} (${to}): Error`);\n } catch (error) {\n console.error(`❌ Error enviando a ${name} (${to}):`, error);\n } finally {\n await client.close();\n }\n }\n}","createdAt",["D",1784731411679],"branchVersion","branchId","b08c82b8-5387-11f1-8a8f-ee650bb23af1","id","b08b9952-5387-11f1-8a8f-ee650bb23af1","office-schedule-notifier",["D",1779197767281],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Cron que lee horarios de Google Sheets y notifica por email","imageUrl","91e5fdf9-4c2d-4613-bc46-391654067cf9","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","fd743d98-e598-4a23-9e20-62f4b841c0f5","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",55,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","cocodrilette","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yZXc2Y3k1NWtDbG1ncDViV3pDbHRGc3ZlRGQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":203,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":204,"_79":205,"_81":206,"_83":25},"tree",[182,183,184,185,186],"files",[182,183,184,185,186],"counts",{"_170":61,"_171":172,"_173":61,"_174":175,"_176":177},"contents",[125,126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":163,"_32":164,"_30":165,"_133":-5,"_41":42,"_40":166,"_135":149,"_38":167,"_13":61,"_33":20,"_35":168,"_24":25,"_139":-5,"_27":169},{"_43":155,"_32":156,"_30":157,"_133":-5,"_41":42,"_40":158,"_135":149,"_38":159,"_13":160,"_33":34,"_35":161,"_24":25,"_139":-5,"_27":162},{"_43":145,"_32":146,"_30":147,"_133":-5,"_41":42,"_40":148,"_135":149,"_38":150,"_13":151,"_33":152,"_35":153,"_24":25,"_139":-5,"_27":154},{"_43":141,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_135":25,"_38":142,"_13":143,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":144},{"_43":130,"_32":131,"_30":132,"_133":-5,"_41":42,"_40":134,"_135":25,"_38":136,"_13":137,"_33":34,"_35":138,"_24":25,"_139":-5,"_27":140},"7cd97e60-51bd-4290-b0be-ab1d386d0e06","sheets.ts","bebd3472-5387-11f1-8a8f-ee650bb23af1","parentId",25,"latest",["D",1784730052472],14,"/**\n * Servicio para leer datos de Google Sheets usando una cuenta de servicio.\n *\n * Variables de entorno requeridas:\n * - GOOGLE_SERVICE_ACCOUNT: JSON completo de la cuenta de servicio\n * - GOOGLE_SHEET_ID: ID de la hoja de cálculo (de la URL)\n */\n\nconst SCOPES = [\"https://www.googleapis.com/auth/spreadsheets.readonly\"];\n\nasync function getAccessToken(): Promise {\n const serviceAccountJson = Deno.env.get(\"GOOGLE_SERVICE_ACCOUNT\");\n if (!serviceAccountJson) {\n throw new Error(\"GOOGLE_SERVICE_ACCOUNT env var is not set\");\n }\n\n const { getToken } = await import(\n \"https://deno.land/x/google_jwt_sa@v0.2.3/mod.ts\"\n );\n\n const token = await getToken(serviceAccountJson, { scope: SCOPES });\n return token.access_token;\n}\n\nasync function sheetsGet(endpoint: string): Promise {\n const sheetId = Deno.env.get(\"GOOGLE_SHEET_ID\");\n if (!sheetId) throw new Error(\"GOOGLE_SHEET_ID env var is not set\");\n\n const token = await getAccessToken();\n const url =\n `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/${endpoint}`;\n\n const res = await fetch(url, {\n headers: { Authorization: `Bearer ${token}` },\n });\n\n if (!res.ok) {\n const body = await res.text();\n throw new Error(`Google Sheets API error (${res.status}): ${body}`);\n }\n\n return res.json();\n}\n\n/**\n * Obtiene los nombres de todas las hojas del spreadsheet.\n */\nexport async function getSheetNames(): Promise {\n const data = await sheetsGet(\"?fields=sheets.properties.title\");\n return data.sheets.map((s: any) => s.properties.title);\n}\n\nfunction getTargetSheetName(): string {\n const today = new Date();\n const day = today.getDate();\n const month = today.getMonth();\n\n const sheetName = `${day + 1}/${month.toString().padStart(2, \"0\")}`;\n return sheetName;\n}\n\n/**\n * Formatea una fecha en formato \"DD/MM\".\n * Permite parametrizar el padding del día para mayor robustez en la búsqueda.\n */\nfunction formatDateToDDMM(date: Date, padDay = true): string {\n const day = date.getDate().toString();\n const month = (date.getMonth() + 1).toString().padStart(2, \"0\");\n return `${padDay ? day.padStart(2, \"0\") : day}/${month}`;\n}\n\n/**\n * Encuentra la hoja de horarios correspondiente a la semana entrante.\n * Si el lunes es festivo y no existe su hoja, busca secuencialmente los días siguientes.\n */\nexport async function findScheduleSheetName(): Promise {\n const names = await getSheetNames();\n const today = new Date();\n\n const dayOfWeek = today.getDay(); // 0 = Domingo, 1 = Lunes, ..., 6 = Sábado\n let daysToMonday = 0;\n\n // Ventana lógica de ejecución:\n // - Si es de Miércoles a Domingo, apuntamos al Lunes de la PRÓXIMA semana.\n // - Si es Lunes o Martes, asumimos que es una ejecución retrasada/manual\n // y el objetivo base es ESTE Lunes (o el día de ayer).\n if (dayOfWeek === 0) {\n daysToMonday = 1; // Domingo -> Mañana es el objetivo\n } else if (dayOfWeek >= 3) {\n daysToMonday = 8 - dayOfWeek; // Mié a Sáb -> Próximo lunes\n } else {\n daysToMonday = 1 - dayOfWeek; // Lun o Mar -> Este lunes (0 o -1 días de diferencia)\n }\n\n const baseTargetDate = new Date(today);\n baseTargetDate.setDate(today.getDate() + daysToMonday);\n console.log({ baseTargetDate });\n\n // Intentar buscar desde el Lunes base hacia adelante (máximo 4 días por festivos)\n const MAX_FALLBACK_DAYS = 4;\n\n for (let i = 0; i < MAX_FALLBACK_DAYS; i++) {\n const candidateDate = new Date(baseTargetDate);\n candidateDate.setDate(baseTargetDate.getDate() + i);\n console.log({ candidateDate });\n\n // Generamos ambas variantes por resiliencia (\"02/05\" y \"2/05\")\n const targetPadded = formatDateToDDMM(candidateDate, true);\n const targetUnpadded = formatDateToDDMM(candidateDate, false);\n\n console.log({ names, targetPadded, targetUnpadded });\n const found = names.find((n) => {\n const normalized = n.trim();\n return normalized === targetPadded || normalized === targetUnpadded;\n });\n\n if (found) {\n return found;\n }\n }\n\n throw new Error(\n `No se encontró la hoja de horarios para la semana entrante (evaluando fallbacks por festivos). Hojas disponibles: ${\n names.join(\", \")\n }`,\n );\n}\n\nconst DAY_COLUMNS = [\"B\", \"C\", \"D\", \"E\", \"F\", \"G\", \"H\"];\nconst DAY_NAMES = [\n \"Lunes\",\n \"Martes\",\n \"Miércoles\",\n \"Jueves\",\n \"Viernes\",\n \"Sábado\",\n \"Domingo\",\n];\n\nexport interface ScheduleEntry {\n name: string;\n days: string[];\n}\n\n/**\n * Lee la hoja de horarios y devuelve un mapa: nombre -> días que debe ir.\n * Busca en columnas B:H (Lunes a Domingo) y recopila todos los nombres únicos.\n */\nexport async function readSchedule(\n sheetName: string,\n): Promise {\n // Leer columnas B:H, hasta 150 filas para cubrir ~140\n const range = encodeURIComponent(`'${sheetName}'!B1:H150`);\n const data = await sheetsGet(`values/${range}?majorDimension=COLUMNS`);\n\n const columns: string[][] = data.values || [];\n\n // Mapa: nombre normalizado -> { originalName, days[] }\n const scheduleMap = new Map<\n string,\n { originalName: string; days: string[] }\n >();\n\n columns.forEach((col: string[], colIndex: number) => {\n const dayName = DAY_NAMES[colIndex] || `Columna ${colIndex}`;\n\n // Saltamos la fila 0 (encabezado)\n for (let row = 1; row < col.length; row++) {\n const cellValue = (col[row] || \"\").trim();\n if (!cellValue) continue;\n\n const key = cellValue.toLowerCase();\n if (!scheduleMap.has(key)) {\n scheduleMap.set(key, { originalName: cellValue, days: [] });\n }\n scheduleMap.get(key)!.days.push(dayName);\n }\n });\n\n return Array.from(scheduleMap.values()).map((entry) => ({\n name: entry.originalName,\n days: entry.days,\n }));\n}","label",[131],"2cd5cad2-0cd7-4fcf-be76-e1e40fe28e40",["D",1784731411679],20,[28],"0583c61f-03c4-4d2c-80a2-bfac07a7f779","cron.ts","cc5ba19a-5387-11f1-8a8f-ee650bb23af1",30,true,["D",1784730831780],2,"interval","/**\n * Cron principal: lee la hoja de Google Sheets, cruza con los contactos,\n * y envía un correo a cada persona con sus días de oficina.\n *\n * Se ejecuta los domingos a las 7pm hora Colombia (UTC-5) = lunes 00:00 UTC.\n */\n\nimport { findScheduleSheetName, readSchedule } from \"./sheets.ts\";\nimport { CONTACTS, findContact } from \"./contacts.ts\";\nimport { sendErrorEmail, sendScheduleEmail } from \"./mailer.ts\";\n\nexport default async function (_interval: Interval) {\n console.log(\"🚀 Iniciando notificación de horarios...\");\n\n try {\n // 1. Encontrar la hoja de horarios (la que no se llama \"Instrucciones\")\n const sheetName = await findScheduleSheetName();\n console.log(`📋 Hoja encontrada: \"${sheetName}\"`);\n\n // 2. Leer el horario completo\n const schedule = await readSchedule(sheetName);\n console.log(\n `📊 Se encontraron ${schedule.length} nombres únicos en la hoja`,\n );\n\n // 3. Cruzar con contactos y enviar correos\n let sent = 0;\n let skipped = 0;\n const errors: string[] = [];\n\n for (const entry of schedule) {\n const contact = findContact(entry.name);\n if (!contact) {\n skipped++;\n continue;\n }\n\n try {\n await sendScheduleEmail(contact.email, contact.name, entry.days);\n sent++;\n } catch (err) {\n const msg =\n `❌ Error enviando a ${contact.name} (${contact.email}): ${err}`;\n console.error(msg);\n errors.push(msg);\n }\n }\n\n // 4. Resumen\n console.log(`\\n📬 Resumen:`);\n console.log(` ✅ Correos enviados: ${sent}`);\n console.log(` ⏭️ Nombres sin contacto registrado: ${skipped}`);\n if (errors.length > 0) {\n console.log(` ❌ Errores: ${errors.length}`);\n }\n\n console.log(\"🏁 Proceso completado.\");\n } catch (_) {\n await sendErrorEmail(CONTACTS.map((c) => ({ name: c.name, to: c.email })));\n return;\n }\n}",[146],"9471ca8e-538c-11f1-91be-ee650bb23af1","contacts.ts","b54fc882-5387-11f1-9d0a-ee650bb23af1",19,["D",1779199867596],3,"/**\n * Tabla de contactos: mapea nombres (como aparecen en la hoja de Google Sheets)\n * a sus correos electrónicos.\n *\n * IMPORTANTE: Los nombres deben coincidir EXACTAMENTE con como aparecen en la hoja.\n * La comparación se hace en minúsculas y sin espacios extra (trim).\n */\n\nexport interface Contact {\n name: string;\n email: string;\n}\n\nexport const CONTACTS: Contact[] = [\n { name: \"Juan Fernando Cogollo\", email: \"cocodrilette@gmail.com\" },\n { name: \"Adriana Jaraba\", email: \"adriana@unergy.io\" },\n];\n\n/**\n * Busca un contacto por nombre (case-insensitive, trimmed).\n */\nexport function findContact(name: string): Contact | undefined {\n const normalized = name.trim().toLowerCase();\n return CONTACTS.find((c) => c.name.trim().toLowerCase() === normalized);\n}",[156],"d98bed2a-5387-11f1-8344-ee650bb23af1","README.md","d98bee06-5387-11f1-8344-ee650bb23af1",5,["D",1779197836063],"# 📅 Office Schedule Notifier\n\nCron que cada **domingo a las 7:00 PM (hora Colombia)** lee una hoja de Google Sheets con el horario de asistencia a la oficina y envía un correo a cada persona indicándole qué días debe ir.\n\n## Cómo funciona\n\n```mermaid\ngraph LR\n A[⏰ Cron Domingo 7pm COT] --> B[📋 Google Sheets API]\n B --> C[Busca hoja ≠ Instrucciones]\n C --> D[Lee columnas B:H - Lun a Dom]\n D --> E[Cruza nombres con contactos]\n E --> F[📧 Envía correo vía SMTP]\n```\n\n1. El cron se activa los domingos a las 7pm hora Colombia\n2. Se conecta a Google Sheets usando una cuenta de servicio\n3. Encuentra la hoja que **no** se llama \"Instrucciones\" (la del horario semanal)\n4. Lee las columnas B:H (Lunes a Domingo) y recopila qué nombres aparecen en cada día\n5. Cruza cada nombre con la tabla de contactos en `contacts.ts`\n6. Envía un correo personalizado a cada persona con sus días asignados\n\n## Estructura de la hoja de Google Sheets\n\n| | B (Lun) | C (Mar) | D (Mié) | E (Jue) | F (Vie) | G (Sáb) | H (Dom) |\n|---|---------|---------|---------|---------|---------|---------|---------|\n| Fila 1 | Lunes | Martes | Miércoles | Jueves | Viernes | Sábado | Domingo |\n| Fila 2 | Juan | María | Juan | | Ana | | |\n| Fila 3 | Ana | | Pedro | Pedro | | | |\n| ... | ... | ... | ... | ... | ... | ... | ... |\n\n## Variables de entorno requeridas\n\n| Variable | Descripción |\n|---|---|\n| `GOOGLE_SERVICE_ACCOUNT` | JSON completo de la cuenta de servicio de Google Cloud |\n| `GOOGLE_SHEET_ID` | ID del spreadsheet (de la URL entre `/d/` y `/edit`) |\n| `SMTP_HOST` | Host del servidor SMTP (ej: `smtp.gmail.com`) |\n| `SMTP_PORT` | Puerto SMTP (ej: `587`) |\n| `SMTP_USER` | Usuario SMTP |\n| `SMTP_PASS` | Contraseña o App Password |\n| `SMTP_FROM` | Dirección \"from\" del correo |\n\n## Configurar contactos\n\nEdita `contacts.ts` y agrega los contactos:\n\n```ts\nexport const CONTACTS: Contact[] = [\n { name: \"Juan Pérez\", email: \"juan.perez@empresa.com\" },\n { name: \"María García\", email: \"maria.garcia@empresa.com\" },\n { name: \"Ana López\", email: \"ana.lopez@empresa.com\" },\n];\n```\n\n> ⚠️ Los nombres deben coincidir **exactamente** con los que aparecen en la hoja de Google Sheets (la comparación ignora mayúsculas/minúsculas y espacios extra).\n\n## Archivos\n\n- `cron.ts` — Punto de entrada del cron (interval)\n- `sheets.ts` — Servicio de lectura de Google Sheets\n- `mailer.ts` — Servicio de envío de correos SMTP\n- `contacts.ts` — Tabla de contactos (nombres → emails)\n",[164],"pulls","branches",1,"forks","envVars",{"_178":180,"_181":61},"connections",{"_178":61,"_179":61},"count","unfilledCount",7,"emptyCount",{"_43":163,"_32":164,"_30":165,"_133":-5,"_41":42,"_40":166,"_135":149,"_38":200,"_13":61,"_33":20,"_35":168,"_24":25,"_139":-5,"_188":201,"_27":202},{"_43":155,"_32":156,"_30":157,"_133":-5,"_41":42,"_40":158,"_135":149,"_38":197,"_13":160,"_33":34,"_35":161,"_24":25,"_139":-5,"_188":198,"_27":199},{"_43":145,"_32":146,"_30":147,"_133":-5,"_41":42,"_40":148,"_135":149,"_38":194,"_13":151,"_33":152,"_35":153,"_24":25,"_139":-5,"_188":195,"_27":196},{"_43":141,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_135":25,"_38":191,"_13":143,"_33":34,"_35":37,"_24":25,"_139":-5,"_188":192,"_27":193},{"_43":130,"_32":131,"_30":132,"_133":-5,"_41":42,"_40":134,"_135":25,"_38":187,"_13":137,"_33":34,"_35":138,"_24":25,"_139":-5,"_188":189,"_27":190},["D",1784730052472],"children",[],[131],["D",1784731411679],[],[28],["D",1784730831780],[],[146],["D",1779199867596],[],[156],["D",1779197836063],[],[164],["D",1779197767281],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":240,"_241":242,"_243":244,"_245":25,"_246":25,"_247":25,"_248":149,"_249":-5,"_250":-7,"_251":-7,"_252":61,"_253":25,"_254":25,"_255":-5,"_256":25,"_257":25,"_258":25,"_259":-5},"ENV",{"_211":212,"_213":214,"_215":85,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v44