), best-effort: si la web no responde\n// en 4 s se sigue sin título — la respuesta del webhook no puede eternizarse.\nasync function tituloDePagina(url: string): Promise<string | null> {\n try {\n const ac = new AbortController();\n const t = setTimeout(() => ac.abort(), 4000);\n const res = await fetch(url, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (compatible; TrucosDeIA/1.0)\" },\n signal: ac.signal,\n });\n clearTimeout(t);\n if (!res.ok) return null;\n const html = (await res.text()).slice(0, 200_000);\n const og = html.match(/<meta[^>]+property=[\"']og:title[\"'][^>]+content=[\"']([^\"']+)[\"']/i)?.[1]\n ?? html.match(/<meta[^>]+content=[\"']([^\"']+)[\"'][^>]+property=[\"']og:title[\"']/i)?.[1];\n const tag = html.match(/<title[^>]*>([^<]+)<\\/title>/i)?.[1];\n const bruto = (og ?? tag ?? \"\").trim();\n if (!bruto) return null;\n return bruto\n .replace(/&#(\\d+);/g, (_, n) => String.fromCodePoint(Number(n)))\n .replace(/&#x([0-9a-f]+);/gi, (_, n) => String.fromCodePoint(parseInt(n, 16)))\n .replace(/&/g, \"&\").replace(/"/g, '\"').replace(/'/g, \"'\")\n .replace(/</g, \"<\").replace(/>/g, \">\").replace(/ñ/g, \"ñ\")\n .replace(/\\s+/g, \" \")\n .slice(0, 150);\n } catch {\n return null;\n }\n}\n\nbot.on(\"message:text\", async (ctx) => {\n const [orden, ...resto] = ctx.message.text.trim().split(/\\s+/);\n const arg = resto.join(\" \");\n try {\n switch (orden.toLowerCase()) {\n case \"estado\": {\n const resumen = await resumenPipeline();\n const FASES = [\"Idea\", \"Borrador\", \"En revisión\", \"Aprobado\", \"Programado\", \"Publicado\", \"Rechazado\"];\n const lineas = FASES.filter((e) => resumen.has(e)).map((e) => `· ${e}: ${resumen.get(e)}`);\n const pendientes = await postsPorEstado(\"En revisión\");\n if (pendientes.length) {\n lineas.push(\"\", \"En revisión:\", ...pendientes.map((p) => `· ${p.slug} — ${p.titulo}`));\n }\n await ctx.reply(\"Pipeline:\\n\" + lineas.join(\"\\n\"));\n break;\n }\n case \"ok\": {\n const post = await objetivo(arg, ctx);\n if (!post) return;\n await setEstado(post.id, \"Aprobado\");\n await ctx.reply(`✅ Aprobado: ${post.titulo} (${post.slug})`);\n break;\n }\n case \"no\": {\n const post = await objetivo(arg, ctx);\n if (!post) return;\n await setEstado(post.id, \"Rechazado\");\n await ctx.reply(`❌ Rechazado: ${post.titulo} (${post.slug})`);\n break;\n }\n case \"nota\": {\n const pendientes = await postsPorEstado(\"En revisión\");\n let post: Post | undefined;\n let textoNota = arg;\n if (pendientes.length > 1 && resto.length > 1) {\n const filtro = resto[0].toLowerCase();\n post = pendientes.find((p) => p.slug.toLowerCase().includes(filtro));\n if (post) textoNota = resto.slice(1).join(\" \");\n }\n if (!post && pendientes.length === 1) post = pendientes[0];\n if (!post || !textoNota) {\n await ctx.reply(\n pendientes.length === 0 ? \"No hay posts en revisión.\" : \"Dime a cuál: nota <slug> <texto>\",\n );\n return;\n }\n await addNota(post.id, textoNota);\n await ctx.reply(`📝 Anotado en ${post.slug}: ${textoNota}`);\n break;\n }\n case \"ideas\": {\n const ideas = await ideasPendientes();\n if (!ideas.length) {\n await ctx.reply(\"No hay ideas pendientes ahora mismo.\");\n return;\n }\n // Telegram limita cada mensaje a 4096 caracteres: se trocea la lista.\n const LIMITE_BLOQUE = 3500;\n const bloques: string[] = [];\n let actual = `💡 Ideas pendientes (${ideas.length}):`;\n ideas.forEach((n, i) => {\n const entrada = `\\n\\n${i + 1}. ${n.favorita ? \"⭐ \" : \"\"}${n.titulo}${n.fuente ? `\\n ${n.fuente}` : \"\"}${n.url ? `\\n ${n.url}` : \"\"}`;\n if (actual.length + entrada.length > LIMITE_BLOQUE) {\n bloques.push(actual);\n actual = entrada.trimStart();\n } else {\n actual += entrada;\n }\n });\n bloques.push(actual + \"\\n\\nDescarta con: descarta <número>\");\n for (const b of bloques) {\n await ctx.reply(b, { link_preview_options: { is_disabled: true } });\n }\n break;\n }\n case \"descarta\": {\n if (!arg) {\n await ctx.reply('Dime cuáles: descarta <número o texto>, y varias separadas por comas (p. ej. descarta 3, 5, spotify). La lista, con \"ideas\".');\n return;\n }\n const ideas = await ideasPendientes();\n if (!ideas.length) {\n await ctx.reply(\"No hay ideas pendientes.\");\n return;\n }\n // Varias ideas en una orden, separadas por comas. Los números se resuelven\n // sobre la misma foto de la lista, así que no se descolocan entre sí.\n const tokens = arg.split(\",\").map((t) => t.trim()).filter(Boolean);\n const hechas: string[] = [];\n const fallos: string[] = [];\n const usadas = new Set<string>();\n for (const t of tokens) {\n let idea = undefined;\n const num = Number(t);\n if (Number.isInteger(num) && num >= 1 && num <= ideas.length) {\n idea = ideas[num - 1];\n } else {\n const filtro = t.toLowerCase();\n const m = ideas.filter((n) => !usadas.has(n.id) && n.titulo.toLowerCase().includes(filtro));\n if (m.length === 1) idea = m[0];\n else {\n fallos.push(m.length === 0 ? `\"${t}\" — sin coincidencia` : `\"${t}\" — encaja con varias, sé más específico`);\n continue;\n }\n }\n if (usadas.has(idea.id)) continue;\n usadas.add(idea.id);\n await setEstado(idea.id, \"Rechazado\");\n hechas.push(idea.titulo.slice(0, 80));\n }\n const partes: string[] = [];\n if (hechas.length) partes.push(`🗑️ Descartadas (${hechas.length}):\\n` + hechas.map((t) => `· ${t}`).join(\"\\n\"));\n if (fallos.length) partes.push(`⚠️ No pude con:\\n` + fallos.map((t) => `· ${t}`).join(\"\\n\"));\n await ctx.reply(partes.join(\"\\n\\n\") || \"No he descartado nada.\");\n break;\n }\n case \"guarda\": {\n if (!arg) {\n await ctx.reply('Dime cuáles: guarda <número o texto>, y varias separadas por comas (p. ej. guarda 2, perplexity). La lista, con \"ideas\".');\n return;\n }\n const ideas = await ideasPendientes();\n if (!ideas.length) {\n await ctx.reply(\"No hay ideas pendientes.\");\n return;\n }\n const tokens = arg.split(\",\").map((t) => t.trim()).filter(Boolean);\n const hechas: string[] = [];\n const fallos: string[] = [];\n const usadas = new Set<string>();\n for (const t of tokens) {\n let idea = undefined;\n const num = Number(t);\n if (Number.isInteger(num) && num >= 1 && num <= ideas.length) {\n idea = ideas[num - 1];\n } else {\n const filtro = t.toLowerCase();\n const m = ideas.filter((n) => !usadas.has(n.id) && n.titulo.toLowerCase().includes(filtro));\n if (m.length === 1) idea = m[0];\n else {\n fallos.push(m.length === 0 ? `\"${t}\" — sin coincidencia` : `\"${t}\" — encaja con varias, sé más específico`);\n continue;\n }\n }\n if (usadas.has(idea.id)) continue;\n usadas.add(idea.id);\n await marcarFavorita(idea.id);\n hechas.push(idea.titulo.slice(0, 80));\n }\n const partes: string[] = [];\n if (hechas.length) {\n partes.push(`⭐ Guardadas como favoritas (${hechas.length}):\\n` + hechas.map((t) => `· ${t}`).join(\"\\n\"));\n }\n if (fallos.length) partes.push(`⚠️ No pude con:\\n` + fallos.map((t) => `· ${t}`).join(\"\\n\"));\n await ctx.reply(partes.join(\"\\n\\n\") || \"No he guardado nada.\");\n break;\n }\n case \"añade\":\n case \"anade\": {\n const urlMatch = arg.match(/https?:\\/\\/\\S+/);\n if (!urlMatch) {\n await ctx.reply(\"Pásame el enlace: añade <url> [comentario opcional]\");\n return;\n }\n const url = urlMatch[0].replace(/[),.;]+$/, \"\");\n const comentario = arg.replace(urlMatch[0], \"\").trim();\n const vistas = await urlsFuente();\n if (vistas.has(url)) {\n await ctx.reply(\"Esa URL ya está en el pipeline (como idea o post): no la duplico.\");\n return;\n }\n const titulo = (await tituloDePagina(url)) ?? new URL(url).hostname.replace(/^www\\./, \"\");\n await crearIdeaTop(titulo, url, comentario);\n await ctx.reply(\n `⭐ Idea top guardada:\\n${titulo}\\n${url}` + (comentario ? `\\n📝 ${comentario}` : \"\"),\n { link_preview_options: { is_disabled: true } },\n );\n break;\n }\n case \"ayuda\": {\n await ctx.reply(AYUDA_DETALLE);\n break;\n }\n case \"publica\": {\n // No publica aquí (tardaría más de lo que Telegram espera): encola como\n // \"Programado\" y el cron de cada 15 min lo saca al momento.\n const post = await objetivo(arg, ctx, \"Aprobado\");\n if (!post) return;\n await setEstado(post.id, \"Programado\");\n await ctx.reply(`⏳ En cola: ${post.titulo} (${post.slug}). Saldrá en menos de 15 minutos.`);\n break;\n }\n default:\n await ctx.reply(AYUDA);\n }\n } catch (e) {\n await ctx.reply(\"⚠️ Error: \" + (e instanceof Error ? e.message : String(e)));\n }\n});\n\n// Parte del propio token sirve de secreto para autorizar las llamadas del webhook.\nconst SECRET = TOKEN.split(\":\")[1];\nconst handleUpdate = webhookCallback(bot, \"std/http\", undefined, undefined, SECRET);\n\nlet webhookRegistrado = false;\n\nexport default async (req: Request): Promise<Response> => {\n if (!webhookRegistrado) {\n await bot.api.setWebhook(req.url, { secret_token: SECRET });\n webhookRegistrado = true;\n }\n if (req.method === \"POST\") return await handleUpdate(req);\n return new Response(\"Webhook de @Trucosdeia_bot operativo.\", { status: 200 });\n};\n",[191],"a6507ebb-475e-45fb-a4a1-19e921e5b63e","img.ts","22cc5aee-89cd-11f1-8c73-1607ee4eb77e",42,["D",1785400402143],1,"// Sirve los media de los carruseles desde blob storage.\n// La API de Meta necesita una URL pública por slide: /posts/<slug>/slide-01.png\n// (o /posts/<slug>/portada-animada.mp4 para la portada en vídeo).\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (req: Request): Promise<Response> {\n const key = decodeURIComponent(new URL(req.url).pathname.replace(/^\\//, \"\"));\n if (!key.startsWith(\"posts/\")) return new Response(\"No encontrado\", { status: 404 });\n try {\n const res = await blob.get(key);\n return new Response(res.body, {\n headers: {\n \"Content-Type\": key.endsWith(\".mp4\") ? \"video/mp4\" : \"image/png\",\n \"Cache-Control\": \"public, max-age=31536000\",\n },\n });\n } catch {\n return new Response(\"No encontrado\", { status: 404 });\n }\n}\n",[198],"f1e9c469-7af3-46cd-8558-371dde2d6531","autopublicar.ts","57506774-89cd-11f1-9aab-1607ee4eb77e",53,["D",1785607284447],"// Cron cada 15 min:\n// - publica al momento los posts en \"Programado\" (cola del comando \"publica\" del bot)\n// - en el hueco diario publica el aprobado más antiguo → cadencia de 1 post/día\nimport { postsPorEstado, setEstado } from \"./airtable.ts\";\nimport { metaConfigurado, publicarEnInstagram } from \"./publicar.ts\";\nimport { enviarTelegram } from \"./telegram.ts\";\n\n// 12:30 Madrid en horario de verano; en invierno cambiar hora a 11.\nconst SLOT_UTC = { hora: 10, minuto: 30 };\n\nexport default async function () {\n if (!(await metaConfigurado())) return { saltado: \"Meta sin configurar\" };\n const ahora = new Date();\n const enSlot = ahora.getUTCHours() === SLOT_UTC.hora &&\n ahora.getUTCMinutes() >= SLOT_UTC.minuto && ahora.getUTCMinutes() < SLOT_UTC.minuto + 15;\n const cola = await postsPorEstado(\"Programado\");\n if (enSlot && cola.length === 0) {\n const aprobados = await postsPorEstado(\"Aprobado\");\n if (aprobados.length) cola.push(aprobados[0]);\n }\n const resultados: Array<Record<string, string>> = [];\n for (const post of cola) {\n try {\n const r = await publicarEnInstagram(post.id);\n if (r.done) {\n await enviarTelegram(`🚀 Publicado en Instagram: ${post.titulo} (${post.slug})`);\n resultados.push({ slug: post.slug, mediaId: r.id ?? \"\" });\n } else {\n // Meta sigue procesando (p. ej. la portada animada). Se pasa a \"Programado\"\n // para que TODAS las pasadas siguientes lo retomen: el hueco diario solo se\n // evalúa una vez y un \"Aprobado\" a medias se quedaría colgado hasta mañana.\n if (post.estado !== \"Programado\") await setEstado(post.id, \"Programado\");\n resultados.push({ slug: post.slug, pendiente: r.detalle ?? \"\" });\n }\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n await enviarTelegram(`⚠️ Error publicando ${post.slug}: ${msg}`);\n resultados.push({ slug: post.slug, error: msg });\n }\n }\n return { publicados: resultados };\n}\n",[206],"3be5124e-d309-46ed-89d9-b270f12df7dd","airtable.ts","049a08b8-89c9-11f1-876e-1607ee4eb77e",55,["D",1785685952675],"// Cliente mínimo de la API REST de Airtable para la base \"Trucos de IA\".\nconst API = \"https://api.airtable.com/v0\";\nconst TABLA_POSTS = \"tbl3v4kWgqgJ8auxf\";\n\nexport interface Post {\n id: string;\n titulo: string;\n slug: string;\n pilar: string;\n estado: string;\n}\n\nfunction config() {\n const token = Deno.env.get(\"AIRTABLE_TOKEN\");\n const base = Deno.env.get(\"AIRTABLE_BASE_ID\");\n if (!token) throw new Error(\"Falta AIRTABLE_TOKEN (créalo en airtable.com/create/tokens)\");\n if (!base) throw new Error(\"Falta AIRTABLE_BASE_ID\");\n return { token, base };\n}\n\nasync function at(path: string, init: RequestInit = {}) {\n const { token, base } = config();\n const res = await fetch(`${API}/${base}/${path}`, {\n ...init,\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n ...(init.headers ?? {}),\n },\n });\n if (!res.ok) throw new Error(`Airtable ${res.status}: ${await res.text()}`);\n return res.json();\n}\n\nfunction toPost(r: { id: string; fields: Record<string, string> }): Post {\n return {\n id: r.id,\n titulo: r.fields[\"Título\"] ?? \"(sin título)\",\n slug: r.fields[\"Slug\"] ?? \"\",\n pilar: r.fields[\"Pilar\"] ?? \"\",\n estado: r.fields[\"Estado\"] ?? \"\",\n };\n}\n\nexport async function postsPorEstado(estado: string): Promise<Post[]> {\n // Orden por Slug ascendente: los slugs van numerados (001-, 002-…), así que\n // \"el primero de la lista\" = el más antiguo. Sin sort, Airtable no garantiza orden.\n const params = new URLSearchParams({ filterByFormula: `{Estado} = '${estado}'` });\n params.set(\"sort[0][field]\", \"Slug\");\n params.set(\"sort[0][direction]\", \"asc\");\n for (const f of [\"Título\", \"Slug\", \"Pilar\", \"Estado\"]) params.append(\"fields[]\", f);\n const data = await at(`${TABLA_POSTS}?${params}`);\n return data.records.map(toPost);\n}\n\nexport async function resumenPipeline(): Promise<Map<string, number>> {\n const counts = new Map<string, number>();\n let offset: string | undefined;\n do {\n const params = new URLSearchParams();\n params.append(\"fields[]\", \"Estado\");\n if (offset) params.set(\"offset\", offset);\n const data = await at(`${TABLA_POSTS}?${params}`);\n for (const r of data.records) {\n const e = r.fields[\"Estado\"] ?? \"Sin estado\";\n counts.set(e, (counts.get(e) ?? 0) + 1);\n }\n offset = data.offset;\n } while (offset);\n return counts;\n}\n\nexport async function setEstado(id: string, estado: string): Promise<void> {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Estado: estado } }),\n });\n}\n\nexport async function addNota(id: string, texto: string): Promise<void> {\n const rec = await at(`${TABLA_POSTS}/${id}`);\n const previa = rec.fields[\"Notas\"] ?? \"\";\n const fecha = new Date().toISOString().slice(0, 10);\n const nueva = previa ? `${previa}\\n[${fecha}] ${texto}` : `[${fecha}] ${texto}`;\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Notas: nueva } }),\n });\n}\n\nexport interface PostCompleto extends Post {\n caption: string;\n}\n\nexport async function postCompleto(id: string): Promise<PostCompleto> {\n const r = await at(`${TABLA_POSTS}/${id}`);\n return { ...toPost(r), caption: r.fields[\"Caption\"] ?? \"\" };\n}\n\n// URLs de noticias ya vistas (campo \"URL fuente\") para no proponerlas dos veces.\nexport async function urlsFuente(): Promise<Set<string>> {\n const urls = new Set<string>();\n let offset: string | undefined;\n do {\n const params = new URLSearchParams();\n params.append(\"fields[]\", \"URL fuente\");\n if (offset) params.set(\"offset\", offset);\n const data = await at(`${TABLA_POSTS}?${params}`);\n for (const r of data.records) {\n if (r.fields[\"URL fuente\"]) urls.add(r.fields[\"URL fuente\"]);\n }\n offset = data.offset;\n } while (offset);\n return urls;\n}\n\nexport interface Idea {\n titulo: string;\n fuente: string;\n url: string;\n resumen: string;\n}\n\nexport async function crearIdeas(ideas: Idea[]): Promise<void> {\n if (!ideas.length) return;\n await at(TABLA_POSTS, {\n method: \"POST\",\n body: JSON.stringify({\n records: ideas.map((i) => ({\n fields: {\n \"Título\": i.titulo,\n Estado: \"Idea\",\n Pilar: \"Actualidad\",\n Fuente: i.fuente,\n \"URL fuente\": i.url,\n Notas: i.resumen,\n },\n })),\n }),\n });\n}\n\n// Idea añadida a mano por Carlos desde el bot (\"añade <url>\"): nace como favorita ⭐.\n// El pilar es provisional, como en las ideas del cron: se decide al redactar.\nexport async function crearIdeaTop(titulo: string, url: string, nota: string): Promise<void> {\n await at(TABLA_POSTS, {\n method: \"POST\",\n body: JSON.stringify({\n records: [{\n fields: {\n \"Título\": titulo,\n Estado: \"Idea\",\n Pilar: \"Actualidad\",\n Favorita: true,\n Fuente: \"Añadida por Carlos desde Telegram\",\n \"URL fuente\": url,\n ...(nota ? { Notas: nota } : {}),\n },\n }],\n }),\n });\n}\n\nexport interface IdeaPendiente {\n id: string;\n titulo: string;\n fuente: string;\n url: string;\n favorita: boolean;\n}\n\n// Las favoritas primero: el orden es compartido por \"ideas\", \"descarta\" y \"guarda\",\n// así los números de la lista siempre significan lo mismo.\nexport async function ideasPendientes(): Promise<IdeaPendiente[]> {\n const params = new URLSearchParams({ filterByFormula: `{Estado} = 'Idea'` });\n for (const f of [\"Título\", \"Fuente\", \"URL fuente\", \"Favorita\"]) params.append(\"fields[]\", f);\n const data = await at(`${TABLA_POSTS}?${params}`);\n const ideas = data.records.map((r: { id: string; fields: Record<string, unknown> }) => ({\n id: r.id,\n titulo: (r.fields[\"Título\"] as string) ?? \"(sin título)\",\n fuente: (r.fields[\"Fuente\"] as string) ?? \"\",\n url: (r.fields[\"URL fuente\"] as string) ?? \"\",\n favorita: Boolean(r.fields[\"Favorita\"]),\n }));\n return [...ideas.filter((i: IdeaPendiente) => i.favorita), ...ideas.filter((i: IdeaPendiente) => !i.favorita)];\n}\n\nexport async function marcarFavorita(id: string): Promise<void> {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Favorita: true } }),\n });\n}\n\nconst TABLA_METRICAS = \"tblpvp2XugXh0Qnlx\";\n\n// Una fila semanal por post en la tabla Métricas (la escribe el cron metricas.ts).\nexport async function registrarMetrica(\n postId: string,\n m: { alcance: number; guardados: number; compartidos: number; meGusta: number; comentarios: number },\n): Promise<void> {\n await at(TABLA_METRICAS, {\n method: \"POST\",\n body: JSON.stringify({\n records: [{\n fields: {\n \"Fecha registro\": new Date().toISOString().slice(0, 10),\n Post: [postId],\n Alcance: m.alcance,\n Guardados: m.guardados,\n Compartidos: m.compartidos,\n \"Me gusta\": m.meGusta,\n Comentarios: m.comentarios,\n },\n }],\n }),\n });\n}\n\nexport async function marcarPublicado(id: string): Promise<void> {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({\n fields: { Estado: \"Publicado\", \"Fecha publicada\": new Date().toISOString().slice(0, 10) },\n }),\n });\n}\n",[213],"934e6f3d-903d-4b31-b035-3e208ab83ddc","README.md","d577bc7e-89c8-11f1-97fc-1607ee4eb77e",["D",1785163109277],"# Trucos de IA — automatización\n\nWebhook de Telegram (aprobación editorial) + cron de noticias del canal @trucos.de.ia.\n",[220],"pulls","branches","forks","envVars",{"_232":234,"_235":61},"connections",{"_232":61,"_233":61},"count","unfilledCount",12,"emptyCount",{"_41":219,"_31":220,"_29":221,"_142":-5,"_39":40,"_38":202,"_144":57,"_36":282,"_13":61,"_32":20,"_34":223,"_23":24,"_148":-5,"_249":283,"_26":284},{"_41":212,"_31":213,"_29":214,"_142":-5,"_39":40,"_38":215,"_144":24,"_36":279,"_13":160,"_32":146,"_34":217,"_23":24,"_148":-5,"_249":280,"_26":281},{"_41":205,"_31":206,"_29":207,"_142":-5,"_39":40,"_38":208,"_144":24,"_36":276,"_13":153,"_32":33,"_34":210,"_23":24,"_148":-5,"_249":277,"_26":278},{"_41":197,"_31":198,"_29":199,"_142":-5,"_39":40,"_38":200,"_144":57,"_36":273,"_13":202,"_32":162,"_34":203,"_23":24,"_148":-5,"_249":274,"_26":275},{"_41":190,"_31":191,"_29":55,"_142":-5,"_39":40,"_38":192,"_144":24,"_36":270,"_13":194,"_32":162,"_34":195,"_23":24,"_148":-5,"_249":271,"_26":272},{"_41":187,"_31":27,"_29":30,"_142":-5,"_39":40,"_38":14,"_144":57,"_36":267,"_13":61,"_32":33,"_34":35,"_23":24,"_148":-5,"_249":268,"_26":269},{"_41":180,"_31":181,"_29":182,"_142":-5,"_39":40,"_38":183,"_144":24,"_36":264,"_13":160,"_32":33,"_34":185,"_23":24,"_148":-5,"_249":265,"_26":266},{"_41":172,"_31":173,"_29":174,"_142":-5,"_39":40,"_38":175,"_144":24,"_36":261,"_13":177,"_32":146,"_34":178,"_23":24,"_148":-5,"_249":262,"_26":263},{"_41":165,"_31":166,"_29":167,"_142":-5,"_39":40,"_38":168,"_144":57,"_36":258,"_13":61,"_32":33,"_34":170,"_23":24,"_148":-5,"_249":259,"_26":260},{"_41":157,"_31":158,"_29":159,"_142":-5,"_39":40,"_38":160,"_144":24,"_36":255,"_13":61,"_32":162,"_34":163,"_23":24,"_148":-5,"_249":256,"_26":257},{"_41":150,"_31":151,"_29":152,"_142":-5,"_39":40,"_38":153,"_144":24,"_36":252,"_13":61,"_32":146,"_34":155,"_23":24,"_148":-5,"_249":253,"_26":254},{"_41":139,"_31":140,"_29":141,"_142":-5,"_39":40,"_38":143,"_144":57,"_36":248,"_13":61,"_32":146,"_34":147,"_23":24,"_148":-5,"_249":250,"_26":251},["D",1785235300474],"children",[],[140],["D",1785164953579],[],[151],["D",1785164962220],[],[158],["D",1785235304765],[],[166],["D",1785685955252],[],[173],["D",1785254993928],[],[181],["D",1785685986498],[],[27],["D",1785685349349],[],[191],["D",1785400402143],[],[198],["D",1785607284447],[],[206],["D",1785685952675],[],[213],["D",1785163109277],[],[220],["D",1785163109209],["D",1789484509295],{"_98":97,"_105":100},{"_98":97,"_99":100,"_101":100,"_18":53,"_102":103,"_104":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_124":323,"_324":325,"_326":327,"_328":24,"_329":24,"_330":24,"_331":57,"_332":-5,"_333":-7,"_334":-7,"_335":61,"_336":24,"_337":24,"_338":-5,"_339":24,"_340":24,"_341":24,"_342":-5},"ENV",{"_294":295,"_296":297,"_298":88,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322},"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"] </article></body></html>

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_290":291,"_292":293},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":100,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":24,"_120":121,"_122":57,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",57,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","metricas.ts","latestPath","fileId","4090ae6a-8e8a-11f1-b9da-1607ee4eb77e","name","fileType","interval","content","// Cron semanal (lunes 05:00 UTC): vuelca en la tabla Métricas de Airtable las\n// estadísticas de cada post publicado, leídas de la API de Meta, y manda un\n// resumen por Telegram. Carlos no tiene que sacar nada a mano.\n//\n// El mapping post ↔ media de Instagram vive en blob (igmedia/.json);\n// lo escribe publicar.ts al publicar. Para posts publicados antes de que\n// existiera, se auto-empareja por el inicio del caption y se guarda.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { postCompleto, postsPorEstado, registrarMetrica } from \"./airtable.ts\";\nimport { getToken } from \"./token.ts\";\nimport { enviarTelegram } from \"./telegram.ts\";\n\nconst GRAPH = \"https://graph.instagram.com/v23.0\";\n\nasync function graphGet(path: string, token: string) {\n const res = await fetch(`${GRAPH}/${path}${path.includes(\"?\") ? \"&\" : \"?\"}access_token=${token}`);\n const data = await res.json();\n if (!res.ok || data.error) throw new Error(`Meta: ${JSON.stringify(data.error ?? data)}`);\n return data;\n}\n\nexport default async function () {\n const token = await getToken();\n const igId = Deno.env.get(\"IG_USER_ID\");\n if (!token || !igId) return { saltado: \"Meta sin configurar\" };\n\n const publicados = await postsPorEstado(\"Publicado\");\n if (!publicados.length) return { saltado: \"sin posts publicados\" };\n\n // media recientes para auto-emparejar los posts sin mapping\n const media = await graphGet(`${igId}/media?fields=id,caption&limit=50`, token);\n\n const lineas: string[] = [];\n let registrados = 0;\n for (const post of publicados) {\n const KEY = `igmedia/${post.id}.json`;\n let map = (await blob.getJSON(KEY).catch(() => null)) as { mediaId: string } | null;\n if (!map) {\n const full = await postCompleto(post.id);\n const pref = (full.caption ?? \"\").slice(0, 40);\n const hit = pref && media.data?.find((m: { caption?: string }) => (m.caption ?? \"\").startsWith(pref));\n if (hit) {\n map = { mediaId: hit.id };\n await blob.setJSON(KEY, map);\n }\n }\n if (!map) {\n lineas.push(`⚠️ ${post.slug || post.titulo}: sin media de IG (¿borrado?)`);\n continue;\n }\n try {\n const ins = await graphGet(`${map.mediaId}/insights?metric=reach,saved,shares,likes,comments`, token);\n const v: Record = {};\n for (const m of ins.data) v[m.name] = m.values?.[0]?.value ?? 0;\n await registrarMetrica(post.id, {\n alcance: v.reach ?? 0,\n guardados: v.saved ?? 0,\n compartidos: v.shares ?? 0,\n meGusta: v.likes ?? 0,\n comentarios: v.comments ?? 0,\n });\n registrados++;\n const g = v.reach ? ` (${((v.saved ?? 0) / v.reach * 100).toFixed(1)}% guard.)` : \"\";\n lineas.push(`${post.slug || post.titulo}: 👁 ${v.reach ?? 0} · 💾 ${v.saved ?? 0}${g} · 📤 ${v.shares ?? 0} · ❤️ ${v.likes ?? 0} · 💬 ${v.comments ?? 0}`);\n } catch (e) {\n lineas.push(`⚠️ ${post.slug}: ${e instanceof Error ? e.message.slice(0, 80) : e}`);\n }\n }\n\n // seguidores de la cuenta y variación desde la última pasada\n let pieSeguidores = \"\";\n try {\n const me = await graphGet(`me?fields=followers_count`, token);\n const ahora = me.followers_count ?? 0;\n const prev = (await blob.getJSON(\"metricas/followers.json\").catch(() => null)) as { n: number } | null;\n await blob.setJSON(\"metricas/followers.json\", { n: ahora });\n pieSeguidores = `\\n\\n👥 Seguidores: ${ahora}${prev ? ` (${ahora - prev.n >= 0 ? \"+\" : \"\"}${ahora - prev.n} desde la última medición)` : \"\"}`;\n } catch { /* sin drama: el resumen sale igual */ }\n\n await enviarTelegram(\n `📊 Métricas semanales (${registrados} posts registrados en Airtable):\\n\\n` + lineas.join(\"\\n\") + pieSeguidores +\n \"\\n\\nObjetivos: guardados >2% del alcance · compartidos >1%.\",\n );\n return { registrados };\n}\n","createdAt",["D",1785685986498],"branchVersion","branchId","d66cfc4d-a355-43ce-a1b2-7255690ecf45","id","aff7e71b-a886-4acb-9c3c-ed0dba233db8","trucos-de-ia",["D",1785163109209],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Automatización del canal @trucos.de.ia: webhook Telegram + cron","imageUrl","7466c9e5-2d6f-472c-ae9e-1a257c0b2e02","pinnedFileId","11f6b8e4-89c9-11f1-ab7d-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019fa400-6d33-70ee-9f1b-d2bfe1a8dd3d","tursoName","aff7e71ba8864acb9c3ced0dba233db8","tursoHostname","aff7e71ba8864acb9c3ced0dba233db8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789484509295],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":100},"org",{"_98":97,"_99":100,"_101":100,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",176,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","iaparatodosig","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_41":42,"_31":43,"_36":285,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":286,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":287,"_82":288,"_84":289,"_86":24},"tree",[236,237,238,239,240,241,242,243,244,245,246,247],"files",[236,237,238,239,240,241,242,243,244,245,246,247],"counts",{"_225":61,"_226":202,"_227":61,"_228":229,"_230":231},"contents",[127,128,129,130,131,132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":219,"_31":220,"_29":221,"_142":-5,"_39":40,"_38":202,"_144":57,"_36":222,"_13":61,"_32":20,"_34":223,"_23":24,"_148":-5,"_26":224},{"_41":212,"_31":213,"_29":214,"_142":-5,"_39":40,"_38":215,"_144":24,"_36":216,"_13":160,"_32":146,"_34":217,"_23":24,"_148":-5,"_26":218},{"_41":205,"_31":206,"_29":207,"_142":-5,"_39":40,"_38":208,"_144":24,"_36":209,"_13":153,"_32":33,"_34":210,"_23":24,"_148":-5,"_26":211},{"_41":197,"_31":198,"_29":199,"_142":-5,"_39":40,"_38":200,"_144":57,"_36":201,"_13":202,"_32":162,"_34":203,"_23":24,"_148":-5,"_26":204},{"_41":190,"_31":191,"_29":55,"_142":-5,"_39":40,"_38":192,"_144":24,"_36":193,"_13":194,"_32":162,"_34":195,"_23":24,"_148":-5,"_26":196},{"_41":187,"_31":27,"_29":30,"_142":-5,"_39":40,"_38":14,"_144":57,"_36":188,"_13":61,"_32":33,"_34":35,"_23":24,"_148":-5,"_26":189},{"_41":180,"_31":181,"_29":182,"_142":-5,"_39":40,"_38":183,"_144":24,"_36":184,"_13":160,"_32":33,"_34":185,"_23":24,"_148":-5,"_26":186},{"_41":172,"_31":173,"_29":174,"_142":-5,"_39":40,"_38":175,"_144":24,"_36":176,"_13":177,"_32":146,"_34":178,"_23":24,"_148":-5,"_26":179},{"_41":165,"_31":166,"_29":167,"_142":-5,"_39":40,"_38":168,"_144":57,"_36":169,"_13":61,"_32":33,"_34":170,"_23":24,"_148":-5,"_26":171},{"_41":157,"_31":158,"_29":159,"_142":-5,"_39":40,"_38":160,"_144":24,"_36":161,"_13":61,"_32":162,"_34":163,"_23":24,"_148":-5,"_26":164},{"_41":150,"_31":151,"_29":152,"_142":-5,"_39":40,"_38":153,"_144":24,"_36":154,"_13":61,"_32":146,"_34":155,"_23":24,"_148":-5,"_26":156},{"_41":139,"_31":140,"_29":141,"_142":-5,"_39":40,"_38":143,"_144":57,"_36":145,"_13":61,"_32":146,"_34":147,"_23":24,"_148":-5,"_26":149},"a8cdb1dd-cd8d-4720-8b5c-4790f1a0ae16","token.ts","eacb6b86-8a70-11f1-bdcf-1607ee4eb77e","parentId",14,"latest",["D",1785235300474],"script","// Gestión del token de Meta. El token renovado vive en blob storage porque\n// un val no puede modificar sus propias env vars; META_ACCESS_TOKEN es la semilla.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst KEY = \"meta/access_token.json\";\n\nexport async function getToken(): Promise {\n try {\n const j = await blob.getJSON(KEY) as { token?: string } | undefined;\n if (j?.token) return j.token;\n } catch {\n // sin blob todavía: cae a la env var\n }\n return Deno.env.get(\"META_ACCESS_TOKEN\") ?? null;\n}\n\nexport async function saveToken(token: string): Promise {\n await blob.setJSON(KEY, { token, guardado: new Date().toISOString() });\n}\n","label",[140],"b0b0e2dc-1093-4d74-83e8-9cc08ecb5e71","telegram.ts","20c8c53e-89cd-11f1-ba02-1607ee4eb77e",4,["D",1785164953579],"// Envío de mensajes al chat de Carlos (fuera del contexto del webhook).\nexport async function enviarTelegram(texto: string): Promise {\n const token = Deno.env.get(\"TELEGRAM_TOKEN\");\n const chat = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!token || !chat) throw new Error(\"Faltan TELEGRAM_TOKEN / TELEGRAM_CHAT_ID\");\n const res = await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chat, text: texto, disable_web_page_preview: true }),\n });\n if (!res.ok) throw new Error(`Telegram ${res.status}: ${await res.text()}`);\n}\n",[151],"06da3936-b28c-403e-8a14-943aefe32bfe","subir.ts","25e5712a-89cd-11f1-98d2-1607ee4eb77e",6,["D",1785164962220],"http","// Recibe los PNG renderizados en local y los guarda en blob storage.\n// Uso: curl -X PUT \"?key=posts//slide-01.png\" \\\n// -H \"Authorization: Bearer $UPLOAD_SECRET\" --data-binary @slide-01.png\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (req: Request): Promise {\n const auth = req.headers.get(\"Authorization\") ?? \"\";\n const secreto = Deno.env.get(\"UPLOAD_SECRET\");\n if (!secreto || auth !== `Bearer ${secreto}`) {\n return new Response(\"No autorizado\", { status: 401 });\n }\n if (req.method !== \"PUT\" && req.method !== \"POST\") {\n return new Response(\"Usa PUT con el binario en el cuerpo\", { status: 405 });\n }\n const key = new URL(req.url).searchParams.get(\"key\");\n if (!key || !key.startsWith(\"posts/\")) {\n return new Response(\"Falta ?key=posts//\", { status: 400 });\n }\n const datos = new Uint8Array(await req.arrayBuffer());\n if (datos.length === 0) return new Response(\"Cuerpo vacío\", { status: 400 });\n await blob.set(key, datos);\n return Response.json({ ok: true, key, bytes: datos.length });\n}\n",[158],"9bfdd7ed-e95e-40c1-a4cf-fbb5d527c6c1","refrescar_token.ts","ed56c864-8a70-11f1-bfcb-1607ee4eb77e",15,["D",1785235304765],"// Cron semanal: renueva el token de Meta antes de que caduque (60 días).\n// Requisito de la API: el token debe tener al menos 24h; renovando cada semana sobra.\nimport { enviarTelegram } from \"./telegram.ts\";\nimport { getToken, saveToken } from \"./token.ts\";\n\nexport default async function () {\n const actual = await getToken();\n if (!actual) return { saltado: \"sin token\" };\n try {\n const res = await fetch(\n `https://graph.instagram.com/refresh_access_token?grant_type=ig_refresh_token&access_token=${actual}`,\n );\n const data = await res.json();\n if (!res.ok || !data.access_token) throw new Error(JSON.stringify(data));\n await saveToken(data.access_token);\n return { renovado: true, expiraEnDias: Math.round((data.expires_in ?? 0) / 86400) };\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n await enviarTelegram(\n `⚠️ No pude renovar el token de Meta: ${msg}\\nSi se repite, habrá que generar uno nuevo en developers.facebook.com antes de 60 días.`,\n );\n throw e;\n }\n}\n",[166],"9e9f5ebd-3a9f-4320-851d-4837466499bb","publicar.ts","4e5dc7ba-89cd-11f1-92c9-1607ee4eb77e",56,["D",1785685955252],5,"// Publica un carrusel aprobado en Instagram (API de Meta con Instagram Login).\n// Necesita las env vars META_ACCESS_TOKEN e IG_USER_ID.\n//\n// PUBLICACIÓN REANUDABLE: el plan gratuito de Val Town corta cada ejecución a\n// 1 minuto, y el procesado de un vídeo en Meta puede tardar varios. Por eso el\n// progreso se apunta en blob (pub/.json) y cada pasada del cron avanza\n// lo que pueda; si algo sigue procesándose, devuelve {done:false} y la\n// siguiente pasada (15 min) continúa donde quedó. Nada se crea dos veces.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { marcarPublicado, postCompleto } from \"./airtable.ts\";\nimport { getToken } from \"./token.ts\";\n\nconst GRAPH = \"https://graph.instagram.com/v23.0\";\nconst IMG_BASE = \"https://iaparatodosig--22cc5aee89cd11f18c731607ee4eb77e.web.val.run\";\nconst VIDEO_PORTADA = \"portada-animada.mp4\";\n\nexport async function metaConfigurado(): Promise {\n return Boolean((await getToken()) && Deno.env.get(\"IG_USER_ID\"));\n}\n\nasync function credenciales() {\n const token = await getToken();\n const igId = Deno.env.get(\"IG_USER_ID\");\n if (!token || !igId) throw new Error(\"Faltan META_ACCESS_TOKEN / IG_USER_ID\");\n return { token, igId };\n}\n\nasync function graphPost(path: string, params: Record, token: string) {\n const res = await fetch(`${GRAPH}/${path}`, {\n method: \"POST\",\n body: new URLSearchParams({ ...params, access_token: token }),\n });\n const data = await res.json();\n if (!res.ok || data.error) throw new Error(`Meta ${res.status}: ${JSON.stringify(data.error ?? data)}`);\n return data;\n}\n\ntype EstadoContenedor = \"FINISHED\" | \"ERROR\" | \"PENDING\";\n\n// Espera acotada: los presupuestos son cortos a propósito (límite de 1 min del\n// val); lo que no llegue a FINISHED se retoma en la siguiente pasada del cron.\nasync function esperar(id: string, token: string, tries: number): Promise {\n for (let i = 0; i < tries; i++) {\n const res = await fetch(`${GRAPH}/${id}?fields=status_code&access_token=${token}`);\n const data = await res.json();\n if (data.status_code === \"FINISHED\") return \"FINISHED\";\n if (data.status_code === \"ERROR\") return \"ERROR\";\n await new Promise((r) => setTimeout(r, 3000));\n }\n return \"PENDING\";\n}\n\ninterface EstadoPub {\n videoId?: string; // contenedor del vídeo de portada\n videoOk?: boolean; // el vídeo ya está FINISHED\n sinVideo?: boolean; // vídeo degradado a portada estática\n carruselId?: string; // contenedor del carrusel completo\n}\n\n// Devuelve {done:true, id} al publicar, o {done:false, detalle} si Meta sigue\n// procesando y hay que reintentar en la siguiente pasada del cron.\nexport async function publicarEnInstagram(\n postId: string,\n): Promise<{ done: boolean; id?: string; detalle?: string }> {\n const { token, igId } = await credenciales();\n const post = await postCompleto(postId);\n if (!post.slug) throw new Error(\"El post no tiene slug\");\n const keys = (await blob.list(`posts/${post.slug}/`)).map((b) => b.key).sort();\n const slides = keys.filter((k) => k.endsWith(\".png\"));\n const video = keys.find((k) => k.endsWith(`/${VIDEO_PORTADA}`));\n if (slides.length < 2) throw new Error(`Solo hay ${slides.length} slides en blob para ${post.slug}`);\n\n const KEY = `pub/${postId}.json`;\n const st: EstadoPub = ((await blob.getJSON(KEY).catch(() => null)) as EstadoPub) ?? {};\n\n // Fase 1 — crear el contenedor del vídeo de portada (una sola vez)\n if (video && !st.sinVideo && !st.videoId) {\n const r = await graphPost(`${igId}/media`, {\n media_type: \"VIDEO\",\n video_url: `${IMG_BASE}/${video}`,\n is_carousel_item: \"true\",\n }, token);\n st.videoId = r.id;\n await blob.setJSON(KEY, st);\n }\n\n // Fase 2 — esperar el vídeo; si Meta lo rechaza, degradar a portada estática\n if (st.videoId && !st.videoOk) {\n const s = await esperar(st.videoId, token, 8);\n if (s === \"PENDING\") return { done: false, detalle: \"la portada animada sigue procesándose en Meta\" };\n if (s === \"ERROR\") {\n const { enviarTelegram } = await import(\"./telegram.ts\");\n await enviarTelegram(`⚠️ La portada animada de ${post.slug} falló en Meta; publico con portada estática.`);\n st.videoId = undefined;\n st.sinVideo = true;\n } else {\n st.videoOk = true;\n }\n await blob.setJSON(KEY, st);\n }\n const conVideo = Boolean(st.videoOk && st.videoId);\n\n // Fase 3 — hijos de imagen + contenedor del carrusel (rápido; una sola vez)\n if (!st.carruselId) {\n const hijos: string[] = conVideo ? [st.videoId!] : [];\n for (const key of conVideo ? slides.slice(1) : slides) {\n const r = await graphPost(`${igId}/media`, {\n image_url: `${IMG_BASE}/${key}`,\n is_carousel_item: \"true\",\n }, token);\n hijos.push(r.id);\n }\n for (const h of hijos.slice(conVideo ? 1 : 0)) {\n const s = await esperar(h, token, 4);\n if (s !== \"FINISHED\") throw new Error(`Contenedor de imagen ${h} en estado ${s}`);\n }\n const carrusel = await graphPost(`${igId}/media`, {\n media_type: \"CAROUSEL\",\n children: hijos.join(\",\"),\n caption: post.caption,\n }, token);\n st.carruselId = carrusel.id;\n await blob.setJSON(KEY, st);\n }\n\n // Fase 4 — esperar el carrusel y publicar\n const s = await esperar(st.carruselId, token, 8);\n if (s === \"PENDING\") return { done: false, detalle: \"el carrusel sigue procesándose en Meta\" };\n if (s === \"ERROR\") {\n await blob.delete(KEY).catch(() => {});\n throw new Error(`Contenedor del carrusel ${st.carruselId} en ERROR`);\n }\n const pub = await graphPost(`${igId}/media_publish`, { creation_id: st.carruselId }, token);\n await blob.delete(KEY).catch(() => {});\n // mapping post ↔ media de Instagram: lo usa el cron semanal de métricas\n await blob.setJSON(`igmedia/${postId}.json`, { mediaId: pub.id }).catch(() => {});\n await marcarPublicado(postId);\n return { done: true, id: pub.id };\n}\n",[173],"0a3535bf-1647-4f10-816d-a63aa7034221","noticias.ts","53bb1ab4-89cd-11f1-b95f-1607ee4eb77e",40,["D",1785254993928],"// Cron matinal: lee los feeds RSS de los medios de confianza, filtra lo de IA\n// de las últimas horas, descarta lo ya visto y crea candidatas \"Idea\" en Airtable.\n// Coste: 0 (sin APIs de pago). Serper queda solo para búsquedas puntuales en sesión.\n// La redacción del carrusel sigue siendo humana+Claude en la sesión diaria.\nimport Parser from \"npm:rss-parser@3.13.0\";\nimport { crearIdeas, Idea, urlsFuente } from \"./airtable.ts\";\nimport { enviarTelegram } from \"./telegram.ts\";\n\n// filtrar=true → feed generalista: solo pasan ítems que mencionan IA.\n// lang=en → título y resumen se traducen al español para el digest (público hispanohablante).\nconst FEEDS = [\n { nombre: \"The Guardian — AI\", url: \"https://www.theguardian.com/technology/artificialintelligenceai/rss\", filtrar: true, lang: \"en\" },\n { nombre: \"Xataka\", url: \"https://feeds.weblogssl.com/xataka2\", filtrar: true, lang: \"es\" },\n { nombre: \"The Verge — AI\", url: \"https://www.theverge.com/rss/ai-artificial-intelligence/index.xml\", filtrar: false, lang: \"en\" },\n { nombre: \"Genbeta\", url: \"https://feeds.weblogssl.com/genbeta\", filtrar: true, lang: \"es\" },\n { nombre: \"WWWhatsNew\", url: \"https://wwwhatsnew.com/feed/\", filtrar: true, lang: \"es\" },\n { nombre: \"El País — Tecnología\", url: \"https://feeds.elpais.com/mrss-s/pages/ep/site/elpais.com/section/tecnologia/portada\", filtrar: true, lang: \"es\" },\n { nombre: \"Hipertextual\", url: \"https://hipertextual.com/feed\", filtrar: true, lang: \"es\" },\n { nombre: \"OpenAI News\", url: \"https://openai.com/news/rss.xml\", filtrar: false, lang: \"en\" },\n];\n\n// Traducción automática gratuita (MyMemory, sin registro). Si falla, se deja el original:\n// mejor un titular en inglés que un cron caído por la traducción.\nasync function traducir(texto: string): Promise {\n if (!texto) return texto;\n try {\n const params = new URLSearchParams({ q: texto.slice(0, 480), langpair: \"en|es\" });\n const email = Deno.env.get(\"MYMEMORY_EMAIL\");\n if (email) params.set(\"de\", email); // sube la cuota diaria gratuita\n const res = await fetch(`https://api.mymemory.translated.net/get?${params}`);\n const data = await res.json();\n const t = data?.responseData?.translatedText;\n if (data?.responseStatus === 200 && typeof t === \"string\" && t.trim()) return t.trim();\n } catch {\n // sin traducción: se devuelve el original\n }\n return texto;\n}\n\nconst CLAVES_IA =\n /(inteligencia artificial|\\bia\\b|\\bai\\b|chatgpt|openai|gemini|copilot|claude|anthropic|deepfake|midjourney|\\bllm\\b|machine learning|red(es)? neuronal(es)?|grok|mistral)/i;\n\n// Ruido que nunca sirve para \"IA práctica para gente normal\": bolsa, institucional,\n// vida universitaria, opinión/ensayo. Se descarta aunque hable de IA.\nconst CLAVES_RUIDO =\n /(en bolsa|acciones de|accionistas?|cotizaci[óo]n|inversores|inversi[óo]n burs[áa]til|wall street|nasdaq|\\bibex\\b|resultados trimestrales|stock market|shares of|\\bearnings\\b|\\binvestors?\\b|take profits|universidad|university|colleges?|\\bcampus\\b|summer camp|diputaci[óo]n|ayuntamiento|concejal|ministerio|consejer[íi]a|\\btribuna\\b|columna de opini[óo]n|geopol[íi]tic)/i;\n\nconst MAX_TOTAL = 6;\nconst MAX_POR_FUENTE = 2;\nconst VENTANA_HORAS = 26; // 24h + margen por husos y retrasos de feed\n\nexport default async function () {\n const parser = new Parser();\n const vistas = await urlsFuente();\n const limite = Date.now() - VENTANA_HORAS * 3600 * 1000;\n const nuevas: Idea[] = [];\n const errores: string[] = [];\n\n for (const f of FEEDS) {\n if (nuevas.length >= MAX_TOTAL) break;\n try {\n const res = await fetch(f.url, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (TrucosDeIA feed reader)\" },\n });\n if (!res.ok) throw new Error(`HTTP ${res.status}`);\n const feed = await parser.parseString(await res.text());\n let cogidas = 0;\n for (const item of feed.items ?? []) {\n if (cogidas >= MAX_POR_FUENTE || nuevas.length >= MAX_TOTAL) break;\n const url = (item.link ?? \"\").split(\"?\")[0].trim();\n const fechaStr = item.isoDate ?? item.pubDate ?? \"\";\n const fecha = Date.parse(fechaStr);\n if (!url || vistas.has(url)) continue;\n if (!Number.isFinite(fecha) || fecha < limite) continue;\n const texto = `${item.title ?? \"\"} ${item.contentSnippet ?? \"\"}`;\n if (f.filtrar && !CLAVES_IA.test(texto)) continue;\n if (CLAVES_RUIDO.test(texto)) continue;\n vistas.add(url);\n const tituloOriginal = (item.title ?? \"(sin título)\").trim();\n const snippet = (item.contentSnippet ?? \"\").replace(/\\s+/g, \" \").slice(0, 300);\n let titulo = tituloOriginal;\n let resumen = snippet;\n if (f.lang === \"en\") {\n titulo = await traducir(tituloOriginal);\n resumen = await traducir(snippet);\n if (titulo !== tituloOriginal) resumen += `\\n\\nTitular original (EN): ${tituloOriginal}`;\n }\n nuevas.push({\n titulo: titulo.slice(0, 120),\n fuente: `${f.nombre} — ${new Date(fecha).toISOString().slice(0, 10)}`,\n url,\n resumen,\n });\n cogidas++;\n }\n } catch (e) {\n errores.push(`${f.nombre}: ${e instanceof Error ? e.message : e}`);\n }\n }\n\n await crearIdeas(nuevas);\n if (nuevas.length) {\n await enviarTelegram(\n \"📰 Candidatas de hoy (guardadas como Idea en Airtable):\\n\\n\" +\n nuevas.map((n, i) => `${i + 1}. ${n.titulo}\\n ${n.fuente}\\n ${n.url}`).join(\"\\n\\n\"),\n );\n }\n // Solo molesta por errores si fallan varias fuentes (una caída puntual es normal).\n if (errores.length >= 3) {\n await enviarTelegram(\"⚠️ Varios feeds del cron de noticias fallaron hoy:\\n\" + errores.join(\"\\n\"));\n }\n return { creadas: nuevas.length, errores };\n}\n",[181],"51a1f071-00d1-480d-b5f6-b328801323ec",["D",1785685986498],[27],"f62b2c93-6c01-4624-af1b-e2c188a6c9e8","index.ts",54,["D",1785685349349],23,"// Webhook del bot @Trucosdeia_bot: convierte respuestas de Telegram en acciones\n// sobre el pipeline editorial de Airtable.\n//\n// Comandos: \"estado\" · \"ok [slug]\" · \"no [slug]\" · \"nota [slug] \"\nimport { Bot, webhookCallback } from \"https://deno.land/x/grammy@v1.35.0/mod.ts\";\nimport { addNota, crearIdeaTop, ideasPendientes, marcarFavorita, Post, postsPorEstado, resumenPipeline, setEstado, urlsFuente } from \"./airtable.ts\";\n\nconst TOKEN = Deno.env.get(\"TELEGRAM_TOKEN\");\nif (!TOKEN) throw new Error(\"TELEGRAM_TOKEN no está definido\");\nconst CHAT_ID = Deno.env.get(\"TELEGRAM_CHAT_ID\") ?? \"\";\n\nconst bot = new Bot(TOKEN);\n\n// Solo atiende al chat autorizado.\nbot.use(async (ctx, next) => {\n if (String(ctx.chat?.id ?? \"\") !== CHAT_ID) return;\n await next();\n});\n\nconst AYUDA = [\n \"Comandos que entiendo:\",\n \"· estado — resumen del pipeline\",\n \"· ok — aprueba el post en revisión (ok si hay varios)\",\n \"· no — rechaza el post en revisión (no si hay varios)\",\n \"· nota — apunta feedback en el post en revisión\",\n \"· publica — publica ya el post aprobado (publica si hay varios)\",\n \"· ideas — lista las ideas pendientes del banco\",\n \"· descarta — marca ideas como Rechazado (varias con comas)\",\n \"· guarda — marca ideas como favoritas ⭐ (varias con comas)\",\n \"· añade — guarda una noticia que hayas visto como idea top ⭐\",\n \"· ayuda — esta lista, con ejemplos de uso\",\n].join(\"\\n\");\n\nconst AYUDA_DETALLE = [\n \"📖 Comandos del bot, con ejemplos:\",\n \"\",\n \"▸ estado — resumen del pipeline y posts en revisión\",\n \" p. ej.: estado\",\n \"\",\n \"▸ ok [slug] — aprueba el post en revisión\",\n \" p. ej.: ok · ok 002\",\n \"\",\n \"▸ no [slug] — rechaza el post en revisión\",\n \" p. ej.: no 003\",\n \"\",\n \"▸ nota [slug] — guarda tu feedback en el post (sin efecto automático: se aplica en la siguiente sesión de redacción)\",\n \" p. ej.: nota el titular de la portada no me convence\",\n \"\",\n \"▸ publica [slug] — publica ya el post aprobado (sale en menos de 15 min)\",\n \" p. ej.: publica 002\",\n \"\",\n \"▸ ideas — lista numerada de las ideas pendientes\",\n \" p. ej.: ideas\",\n \"\",\n \"▸ descarta — marca ideas como Rechazado (no vuelven a proponerse); admite varias separadas por comas\",\n \" p. ej.: descarta 3 · descarta spotify · descarta 3, 5, oled\",\n \"\",\n \"▸ guarda — marca ideas como favoritas ⭐: salen las primeras en la lista y se priorizan al redactar; admite varias separadas por comas\",\n \" p. ej.: guarda 2 · guarda perplexity, 6\",\n \"\",\n \"▸ añade [comentario] — guarda esa noticia como idea favorita ⭐ en el banco; el título se saca solo de la página y el comentario (opcional) queda en las notas\",\n \" p. ej.: añade https://xataka.com/... · añade https://... para el jueves\",\n \"\",\n \"El [slug] solo hace falta cuando hay varios posts en ese estado; vale un trozo (002, notebooklm…).\",\n].join(\"\\n\");\n\nbot.command(\"start\", (ctx) => ctx.reply(\"Bot de Trucos de IA listo.\\n\\n\" + AYUDA));\nbot.command(\"ayuda\", (ctx) => ctx.reply(AYUDA_DETALLE));\n\n// Resuelve a qué post (del estado dado) se refiere la orden; si hay varios exige slug.\nasync function objetivo(\n arg: string,\n ctx: { reply: (t: string) => Promise },\n estado = \"En revisión\",\n): Promise {\n const pendientes = await postsPorEstado(estado);\n if (pendientes.length === 0) {\n await ctx.reply(`No hay ningún post en estado \"${estado}\" ahora mismo.`);\n return null;\n }\n if (!arg) {\n if (pendientes.length === 1) return pendientes[0];\n await ctx.reply(\"Hay varios en revisión, dime cuál:\\n\" + pendientes.map((p) => `· ${p.slug}`).join(\"\\n\"));\n return null;\n }\n const filtro = arg.toLowerCase();\n const m = pendientes.filter((p) =>\n p.slug.toLowerCase().includes(filtro) || p.titulo.toLowerCase().includes(filtro)\n );\n if (m.length === 1) return m[0];\n await ctx.reply(\n m.length === 0\n ? `No encuentro ningún post en revisión que encaje con \"${arg}\".`\n : \"Encaja con varios:\\n\" + m.map((p) => `· ${p.slug}`).join(\"\\n\"),\n );\n return null;\n}\n\n// Título de la página (og:title o ), best-effort: si la web no responde\n// en 4 s se sigue sin título — la respuesta del webhook no puede eternizarse.\nasync function tituloDePagina(url: string): Promise<string | null> {\n try {\n const ac = new AbortController();\n const t = setTimeout(() => ac.abort(), 4000);\n const res = await fetch(url, {\n headers: { \"User-Agent\": \"Mozilla/5.0 (compatible; TrucosDeIA/1.0)\" },\n signal: ac.signal,\n });\n clearTimeout(t);\n if (!res.ok) return null;\n const html = (await res.text()).slice(0, 200_000);\n const og = html.match(/<meta[^>]+property=[\"']og:title[\"'][^>]+content=[\"']([^\"']+)[\"']/i)?.[1]\n ?? html.match(/<meta[^>]+content=[\"']([^\"']+)[\"'][^>]+property=[\"']og:title[\"']/i)?.[1];\n const tag = html.match(/<title[^>]*>([^<]+)<\\/title>/i)?.[1];\n const bruto = (og ?? tag ?? \"\").trim();\n if (!bruto) return null;\n return bruto\n .replace(/&#(\\d+);/g, (_, n) => String.fromCodePoint(Number(n)))\n .replace(/&#x([0-9a-f]+);/gi, (_, n) => String.fromCodePoint(parseInt(n, 16)))\n .replace(/&/g, \"&\").replace(/"/g, '\"').replace(/'/g, \"'\")\n .replace(/</g, \"<\").replace(/>/g, \">\").replace(/ñ/g, \"ñ\")\n .replace(/\\s+/g, \" \")\n .slice(0, 150);\n } catch {\n return null;\n }\n}\n\nbot.on(\"message:text\", async (ctx) => {\n const [orden, ...resto] = ctx.message.text.trim().split(/\\s+/);\n const arg = resto.join(\" \");\n try {\n switch (orden.toLowerCase()) {\n case \"estado\": {\n const resumen = await resumenPipeline();\n const FASES = [\"Idea\", \"Borrador\", \"En revisión\", \"Aprobado\", \"Programado\", \"Publicado\", \"Rechazado\"];\n const lineas = FASES.filter((e) => resumen.has(e)).map((e) => `· ${e}: ${resumen.get(e)}`);\n const pendientes = await postsPorEstado(\"En revisión\");\n if (pendientes.length) {\n lineas.push(\"\", \"En revisión:\", ...pendientes.map((p) => `· ${p.slug} — ${p.titulo}`));\n }\n await ctx.reply(\"Pipeline:\\n\" + lineas.join(\"\\n\"));\n break;\n }\n case \"ok\": {\n const post = await objetivo(arg, ctx);\n if (!post) return;\n await setEstado(post.id, \"Aprobado\");\n await ctx.reply(`✅ Aprobado: ${post.titulo} (${post.slug})`);\n break;\n }\n case \"no\": {\n const post = await objetivo(arg, ctx);\n if (!post) return;\n await setEstado(post.id, \"Rechazado\");\n await ctx.reply(`❌ Rechazado: ${post.titulo} (${post.slug})`);\n break;\n }\n case \"nota\": {\n const pendientes = await postsPorEstado(\"En revisión\");\n let post: Post | undefined;\n let textoNota = arg;\n if (pendientes.length > 1 && resto.length > 1) {\n const filtro = resto[0].toLowerCase();\n post = pendientes.find((p) => p.slug.toLowerCase().includes(filtro));\n if (post) textoNota = resto.slice(1).join(\" \");\n }\n if (!post && pendientes.length === 1) post = pendientes[0];\n if (!post || !textoNota) {\n await ctx.reply(\n pendientes.length === 0 ? \"No hay posts en revisión.\" : \"Dime a cuál: nota <slug> <texto>\",\n );\n return;\n }\n await addNota(post.id, textoNota);\n await ctx.reply(`📝 Anotado en ${post.slug}: ${textoNota}`);\n break;\n }\n case \"ideas\": {\n const ideas = await ideasPendientes();\n if (!ideas.length) {\n await ctx.reply(\"No hay ideas pendientes ahora mismo.\");\n return;\n }\n // Telegram limita cada mensaje a 4096 caracteres: se trocea la lista.\n const LIMITE_BLOQUE = 3500;\n const bloques: string[] = [];\n let actual = `💡 Ideas pendientes (${ideas.length}):`;\n ideas.forEach((n, i) => {\n const entrada = `\\n\\n${i + 1}. ${n.favorita ? \"⭐ \" : \"\"}${n.titulo}${n.fuente ? `\\n ${n.fuente}` : \"\"}${n.url ? `\\n ${n.url}` : \"\"}`;\n if (actual.length + entrada.length > LIMITE_BLOQUE) {\n bloques.push(actual);\n actual = entrada.trimStart();\n } else {\n actual += entrada;\n }\n });\n bloques.push(actual + \"\\n\\nDescarta con: descarta <número>\");\n for (const b of bloques) {\n await ctx.reply(b, { link_preview_options: { is_disabled: true } });\n }\n break;\n }\n case \"descarta\": {\n if (!arg) {\n await ctx.reply('Dime cuáles: descarta <número o texto>, y varias separadas por comas (p. ej. descarta 3, 5, spotify). La lista, con \"ideas\".');\n return;\n }\n const ideas = await ideasPendientes();\n if (!ideas.length) {\n await ctx.reply(\"No hay ideas pendientes.\");\n return;\n }\n // Varias ideas en una orden, separadas por comas. Los números se resuelven\n // sobre la misma foto de la lista, así que no se descolocan entre sí.\n const tokens = arg.split(\",\").map((t) => t.trim()).filter(Boolean);\n const hechas: string[] = [];\n const fallos: string[] = [];\n const usadas = new Set<string>();\n for (const t of tokens) {\n let idea = undefined;\n const num = Number(t);\n if (Number.isInteger(num) && num >= 1 && num <= ideas.length) {\n idea = ideas[num - 1];\n } else {\n const filtro = t.toLowerCase();\n const m = ideas.filter((n) => !usadas.has(n.id) && n.titulo.toLowerCase().includes(filtro));\n if (m.length === 1) idea = m[0];\n else {\n fallos.push(m.length === 0 ? `\"${t}\" — sin coincidencia` : `\"${t}\" — encaja con varias, sé más específico`);\n continue;\n }\n }\n if (usadas.has(idea.id)) continue;\n usadas.add(idea.id);\n await setEstado(idea.id, \"Rechazado\");\n hechas.push(idea.titulo.slice(0, 80));\n }\n const partes: string[] = [];\n if (hechas.length) partes.push(`🗑️ Descartadas (${hechas.length}):\\n` + hechas.map((t) => `· ${t}`).join(\"\\n\"));\n if (fallos.length) partes.push(`⚠️ No pude con:\\n` + fallos.map((t) => `· ${t}`).join(\"\\n\"));\n await ctx.reply(partes.join(\"\\n\\n\") || \"No he descartado nada.\");\n break;\n }\n case \"guarda\": {\n if (!arg) {\n await ctx.reply('Dime cuáles: guarda <número o texto>, y varias separadas por comas (p. ej. guarda 2, perplexity). La lista, con \"ideas\".');\n return;\n }\n const ideas = await ideasPendientes();\n if (!ideas.length) {\n await ctx.reply(\"No hay ideas pendientes.\");\n return;\n }\n const tokens = arg.split(\",\").map((t) => t.trim()).filter(Boolean);\n const hechas: string[] = [];\n const fallos: string[] = [];\n const usadas = new Set<string>();\n for (const t of tokens) {\n let idea = undefined;\n const num = Number(t);\n if (Number.isInteger(num) && num >= 1 && num <= ideas.length) {\n idea = ideas[num - 1];\n } else {\n const filtro = t.toLowerCase();\n const m = ideas.filter((n) => !usadas.has(n.id) && n.titulo.toLowerCase().includes(filtro));\n if (m.length === 1) idea = m[0];\n else {\n fallos.push(m.length === 0 ? `\"${t}\" — sin coincidencia` : `\"${t}\" — encaja con varias, sé más específico`);\n continue;\n }\n }\n if (usadas.has(idea.id)) continue;\n usadas.add(idea.id);\n await marcarFavorita(idea.id);\n hechas.push(idea.titulo.slice(0, 80));\n }\n const partes: string[] = [];\n if (hechas.length) {\n partes.push(`⭐ Guardadas como favoritas (${hechas.length}):\\n` + hechas.map((t) => `· ${t}`).join(\"\\n\"));\n }\n if (fallos.length) partes.push(`⚠️ No pude con:\\n` + fallos.map((t) => `· ${t}`).join(\"\\n\"));\n await ctx.reply(partes.join(\"\\n\\n\") || \"No he guardado nada.\");\n break;\n }\n case \"añade\":\n case \"anade\": {\n const urlMatch = arg.match(/https?:\\/\\/\\S+/);\n if (!urlMatch) {\n await ctx.reply(\"Pásame el enlace: añade <url> [comentario opcional]\");\n return;\n }\n const url = urlMatch[0].replace(/[),.;]+$/, \"\");\n const comentario = arg.replace(urlMatch[0], \"\").trim();\n const vistas = await urlsFuente();\n if (vistas.has(url)) {\n await ctx.reply(\"Esa URL ya está en el pipeline (como idea o post): no la duplico.\");\n return;\n }\n const titulo = (await tituloDePagina(url)) ?? new URL(url).hostname.replace(/^www\\./, \"\");\n await crearIdeaTop(titulo, url, comentario);\n await ctx.reply(\n `⭐ Idea top guardada:\\n${titulo}\\n${url}` + (comentario ? `\\n📝 ${comentario}` : \"\"),\n { link_preview_options: { is_disabled: true } },\n );\n break;\n }\n case \"ayuda\": {\n await ctx.reply(AYUDA_DETALLE);\n break;\n }\n case \"publica\": {\n // No publica aquí (tardaría más de lo que Telegram espera): encola como\n // \"Programado\" y el cron de cada 15 min lo saca al momento.\n const post = await objetivo(arg, ctx, \"Aprobado\");\n if (!post) return;\n await setEstado(post.id, \"Programado\");\n await ctx.reply(`⏳ En cola: ${post.titulo} (${post.slug}). Saldrá en menos de 15 minutos.`);\n break;\n }\n default:\n await ctx.reply(AYUDA);\n }\n } catch (e) {\n await ctx.reply(\"⚠️ Error: \" + (e instanceof Error ? e.message : String(e)));\n }\n});\n\n// Parte del propio token sirve de secreto para autorizar las llamadas del webhook.\nconst SECRET = TOKEN.split(\":\")[1];\nconst handleUpdate = webhookCallback(bot, \"std/http\", undefined, undefined, SECRET);\n\nlet webhookRegistrado = false;\n\nexport default async (req: Request): Promise<Response> => {\n if (!webhookRegistrado) {\n await bot.api.setWebhook(req.url, { secret_token: SECRET });\n webhookRegistrado = true;\n }\n if (req.method === \"POST\") return await handleUpdate(req);\n return new Response(\"Webhook de @Trucosdeia_bot operativo.\", { status: 200 });\n};\n",[191],"a6507ebb-475e-45fb-a4a1-19e921e5b63e","img.ts","22cc5aee-89cd-11f1-8c73-1607ee4eb77e",42,["D",1785400402143],1,"// Sirve los media de los carruseles desde blob storage.\n// La API de Meta necesita una URL pública por slide: /posts/<slug>/slide-01.png\n// (o /posts/<slug>/portada-animada.mp4 para la portada en vídeo).\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (req: Request): Promise<Response> {\n const key = decodeURIComponent(new URL(req.url).pathname.replace(/^\\//, \"\"));\n if (!key.startsWith(\"posts/\")) return new Response(\"No encontrado\", { status: 404 });\n try {\n const res = await blob.get(key);\n return new Response(res.body, {\n headers: {\n \"Content-Type\": key.endsWith(\".mp4\") ? \"video/mp4\" : \"image/png\",\n \"Cache-Control\": \"public, max-age=31536000\",\n },\n });\n } catch {\n return new Response(\"No encontrado\", { status: 404 });\n }\n}\n",[198],"f1e9c469-7af3-46cd-8558-371dde2d6531","autopublicar.ts","57506774-89cd-11f1-9aab-1607ee4eb77e",53,["D",1785607284447],"// Cron cada 15 min:\n// - publica al momento los posts en \"Programado\" (cola del comando \"publica\" del bot)\n// - en el hueco diario publica el aprobado más antiguo → cadencia de 1 post/día\nimport { postsPorEstado, setEstado } from \"./airtable.ts\";\nimport { metaConfigurado, publicarEnInstagram } from \"./publicar.ts\";\nimport { enviarTelegram } from \"./telegram.ts\";\n\n// 12:30 Madrid en horario de verano; en invierno cambiar hora a 11.\nconst SLOT_UTC = { hora: 10, minuto: 30 };\n\nexport default async function () {\n if (!(await metaConfigurado())) return { saltado: \"Meta sin configurar\" };\n const ahora = new Date();\n const enSlot = ahora.getUTCHours() === SLOT_UTC.hora &&\n ahora.getUTCMinutes() >= SLOT_UTC.minuto && ahora.getUTCMinutes() < SLOT_UTC.minuto + 15;\n const cola = await postsPorEstado(\"Programado\");\n if (enSlot && cola.length === 0) {\n const aprobados = await postsPorEstado(\"Aprobado\");\n if (aprobados.length) cola.push(aprobados[0]);\n }\n const resultados: Array<Record<string, string>> = [];\n for (const post of cola) {\n try {\n const r = await publicarEnInstagram(post.id);\n if (r.done) {\n await enviarTelegram(`🚀 Publicado en Instagram: ${post.titulo} (${post.slug})`);\n resultados.push({ slug: post.slug, mediaId: r.id ?? \"\" });\n } else {\n // Meta sigue procesando (p. ej. la portada animada). Se pasa a \"Programado\"\n // para que TODAS las pasadas siguientes lo retomen: el hueco diario solo se\n // evalúa una vez y un \"Aprobado\" a medias se quedaría colgado hasta mañana.\n if (post.estado !== \"Programado\") await setEstado(post.id, \"Programado\");\n resultados.push({ slug: post.slug, pendiente: r.detalle ?? \"\" });\n }\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n await enviarTelegram(`⚠️ Error publicando ${post.slug}: ${msg}`);\n resultados.push({ slug: post.slug, error: msg });\n }\n }\n return { publicados: resultados };\n}\n",[206],"3be5124e-d309-46ed-89d9-b270f12df7dd","airtable.ts","049a08b8-89c9-11f1-876e-1607ee4eb77e",55,["D",1785685952675],"// Cliente mínimo de la API REST de Airtable para la base \"Trucos de IA\".\nconst API = \"https://api.airtable.com/v0\";\nconst TABLA_POSTS = \"tbl3v4kWgqgJ8auxf\";\n\nexport interface Post {\n id: string;\n titulo: string;\n slug: string;\n pilar: string;\n estado: string;\n}\n\nfunction config() {\n const token = Deno.env.get(\"AIRTABLE_TOKEN\");\n const base = Deno.env.get(\"AIRTABLE_BASE_ID\");\n if (!token) throw new Error(\"Falta AIRTABLE_TOKEN (créalo en airtable.com/create/tokens)\");\n if (!base) throw new Error(\"Falta AIRTABLE_BASE_ID\");\n return { token, base };\n}\n\nasync function at(path: string, init: RequestInit = {}) {\n const { token, base } = config();\n const res = await fetch(`${API}/${base}/${path}`, {\n ...init,\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n ...(init.headers ?? {}),\n },\n });\n if (!res.ok) throw new Error(`Airtable ${res.status}: ${await res.text()}`);\n return res.json();\n}\n\nfunction toPost(r: { id: string; fields: Record<string, string> }): Post {\n return {\n id: r.id,\n titulo: r.fields[\"Título\"] ?? \"(sin título)\",\n slug: r.fields[\"Slug\"] ?? \"\",\n pilar: r.fields[\"Pilar\"] ?? \"\",\n estado: r.fields[\"Estado\"] ?? \"\",\n };\n}\n\nexport async function postsPorEstado(estado: string): Promise<Post[]> {\n // Orden por Slug ascendente: los slugs van numerados (001-, 002-…), así que\n // \"el primero de la lista\" = el más antiguo. Sin sort, Airtable no garantiza orden.\n const params = new URLSearchParams({ filterByFormula: `{Estado} = '${estado}'` });\n params.set(\"sort[0][field]\", \"Slug\");\n params.set(\"sort[0][direction]\", \"asc\");\n for (const f of [\"Título\", \"Slug\", \"Pilar\", \"Estado\"]) params.append(\"fields[]\", f);\n const data = await at(`${TABLA_POSTS}?${params}`);\n return data.records.map(toPost);\n}\n\nexport async function resumenPipeline(): Promise<Map<string, number>> {\n const counts = new Map<string, number>();\n let offset: string | undefined;\n do {\n const params = new URLSearchParams();\n params.append(\"fields[]\", \"Estado\");\n if (offset) params.set(\"offset\", offset);\n const data = await at(`${TABLA_POSTS}?${params}`);\n for (const r of data.records) {\n const e = r.fields[\"Estado\"] ?? \"Sin estado\";\n counts.set(e, (counts.get(e) ?? 0) + 1);\n }\n offset = data.offset;\n } while (offset);\n return counts;\n}\n\nexport async function setEstado(id: string, estado: string): Promise<void> {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Estado: estado } }),\n });\n}\n\nexport async function addNota(id: string, texto: string): Promise<void> {\n const rec = await at(`${TABLA_POSTS}/${id}`);\n const previa = rec.fields[\"Notas\"] ?? \"\";\n const fecha = new Date().toISOString().slice(0, 10);\n const nueva = previa ? `${previa}\\n[${fecha}] ${texto}` : `[${fecha}] ${texto}`;\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Notas: nueva } }),\n });\n}\n\nexport interface PostCompleto extends Post {\n caption: string;\n}\n\nexport async function postCompleto(id: string): Promise<PostCompleto> {\n const r = await at(`${TABLA_POSTS}/${id}`);\n return { ...toPost(r), caption: r.fields[\"Caption\"] ?? \"\" };\n}\n\n// URLs de noticias ya vistas (campo \"URL fuente\") para no proponerlas dos veces.\nexport async function urlsFuente(): Promise<Set<string>> {\n const urls = new Set<string>();\n let offset: string | undefined;\n do {\n const params = new URLSearchParams();\n params.append(\"fields[]\", \"URL fuente\");\n if (offset) params.set(\"offset\", offset);\n const data = await at(`${TABLA_POSTS}?${params}`);\n for (const r of data.records) {\n if (r.fields[\"URL fuente\"]) urls.add(r.fields[\"URL fuente\"]);\n }\n offset = data.offset;\n } while (offset);\n return urls;\n}\n\nexport interface Idea {\n titulo: string;\n fuente: string;\n url: string;\n resumen: string;\n}\n\nexport async function crearIdeas(ideas: Idea[]): Promise<void> {\n if (!ideas.length) return;\n await at(TABLA_POSTS, {\n method: \"POST\",\n body: JSON.stringify({\n records: ideas.map((i) => ({\n fields: {\n \"Título\": i.titulo,\n Estado: \"Idea\",\n Pilar: \"Actualidad\",\n Fuente: i.fuente,\n \"URL fuente\": i.url,\n Notas: i.resumen,\n },\n })),\n }),\n });\n}\n\n// Idea añadida a mano por Carlos desde el bot (\"añade <url>\"): nace como favorita ⭐.\n// El pilar es provisional, como en las ideas del cron: se decide al redactar.\nexport async function crearIdeaTop(titulo: string, url: string, nota: string): Promise<void> {\n await at(TABLA_POSTS, {\n method: \"POST\",\n body: JSON.stringify({\n records: [{\n fields: {\n \"Título\": titulo,\n Estado: \"Idea\",\n Pilar: \"Actualidad\",\n Favorita: true,\n Fuente: \"Añadida por Carlos desde Telegram\",\n \"URL fuente\": url,\n ...(nota ? { Notas: nota } : {}),\n },\n }],\n }),\n });\n}\n\nexport interface IdeaPendiente {\n id: string;\n titulo: string;\n fuente: string;\n url: string;\n favorita: boolean;\n}\n\n// Las favoritas primero: el orden es compartido por \"ideas\", \"descarta\" y \"guarda\",\n// así los números de la lista siempre significan lo mismo.\nexport async function ideasPendientes(): Promise<IdeaPendiente[]> {\n const params = new URLSearchParams({ filterByFormula: `{Estado} = 'Idea'` });\n for (const f of [\"Título\", \"Fuente\", \"URL fuente\", \"Favorita\"]) params.append(\"fields[]\", f);\n const data = await at(`${TABLA_POSTS}?${params}`);\n const ideas = data.records.map((r: { id: string; fields: Record<string, unknown> }) => ({\n id: r.id,\n titulo: (r.fields[\"Título\"] as string) ?? \"(sin título)\",\n fuente: (r.fields[\"Fuente\"] as string) ?? \"\",\n url: (r.fields[\"URL fuente\"] as string) ?? \"\",\n favorita: Boolean(r.fields[\"Favorita\"]),\n }));\n return [...ideas.filter((i: IdeaPendiente) => i.favorita), ...ideas.filter((i: IdeaPendiente) => !i.favorita)];\n}\n\nexport async function marcarFavorita(id: string): Promise<void> {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Favorita: true } }),\n });\n}\n\nconst TABLA_METRICAS = \"tblpvp2XugXh0Qnlx\";\n\n// Una fila semanal por post en la tabla Métricas (la escribe el cron metricas.ts).\nexport async function registrarMetrica(\n postId: string,\n m: { alcance: number; guardados: number; compartidos: number; meGusta: number; comentarios: number },\n): Promise<void> {\n await at(TABLA_METRICAS, {\n method: \"POST\",\n body: JSON.stringify({\n records: [{\n fields: {\n \"Fecha registro\": new Date().toISOString().slice(0, 10),\n Post: [postId],\n Alcance: m.alcance,\n Guardados: m.guardados,\n Compartidos: m.compartidos,\n \"Me gusta\": m.meGusta,\n Comentarios: m.comentarios,\n },\n }],\n }),\n });\n}\n\nexport async function marcarPublicado(id: string): Promise<void> {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({\n fields: { Estado: \"Publicado\", \"Fecha publicada\": new Date().toISOString().slice(0, 10) },\n }),\n });\n}\n",[213],"934e6f3d-903d-4b31-b035-3e208ab83ddc","README.md","d577bc7e-89c8-11f1-97fc-1607ee4eb77e",["D",1785163109277],"# Trucos de IA — automatización\n\nWebhook de Telegram (aprobación editorial) + cron de noticias del canal @trucos.de.ia.\n",[220],"pulls","branches","forks","envVars",{"_232":234,"_235":61},"connections",{"_232":61,"_233":61},"count","unfilledCount",12,"emptyCount",{"_41":219,"_31":220,"_29":221,"_142":-5,"_39":40,"_38":202,"_144":57,"_36":282,"_13":61,"_32":20,"_34":223,"_23":24,"_148":-5,"_249":283,"_26":284},{"_41":212,"_31":213,"_29":214,"_142":-5,"_39":40,"_38":215,"_144":24,"_36":279,"_13":160,"_32":146,"_34":217,"_23":24,"_148":-5,"_249":280,"_26":281},{"_41":205,"_31":206,"_29":207,"_142":-5,"_39":40,"_38":208,"_144":24,"_36":276,"_13":153,"_32":33,"_34":210,"_23":24,"_148":-5,"_249":277,"_26":278},{"_41":197,"_31":198,"_29":199,"_142":-5,"_39":40,"_38":200,"_144":57,"_36":273,"_13":202,"_32":162,"_34":203,"_23":24,"_148":-5,"_249":274,"_26":275},{"_41":190,"_31":191,"_29":55,"_142":-5,"_39":40,"_38":192,"_144":24,"_36":270,"_13":194,"_32":162,"_34":195,"_23":24,"_148":-5,"_249":271,"_26":272},{"_41":187,"_31":27,"_29":30,"_142":-5,"_39":40,"_38":14,"_144":57,"_36":267,"_13":61,"_32":33,"_34":35,"_23":24,"_148":-5,"_249":268,"_26":269},{"_41":180,"_31":181,"_29":182,"_142":-5,"_39":40,"_38":183,"_144":24,"_36":264,"_13":160,"_32":33,"_34":185,"_23":24,"_148":-5,"_249":265,"_26":266},{"_41":172,"_31":173,"_29":174,"_142":-5,"_39":40,"_38":175,"_144":24,"_36":261,"_13":177,"_32":146,"_34":178,"_23":24,"_148":-5,"_249":262,"_26":263},{"_41":165,"_31":166,"_29":167,"_142":-5,"_39":40,"_38":168,"_144":57,"_36":258,"_13":61,"_32":33,"_34":170,"_23":24,"_148":-5,"_249":259,"_26":260},{"_41":157,"_31":158,"_29":159,"_142":-5,"_39":40,"_38":160,"_144":24,"_36":255,"_13":61,"_32":162,"_34":163,"_23":24,"_148":-5,"_249":256,"_26":257},{"_41":150,"_31":151,"_29":152,"_142":-5,"_39":40,"_38":153,"_144":24,"_36":252,"_13":61,"_32":146,"_34":155,"_23":24,"_148":-5,"_249":253,"_26":254},{"_41":139,"_31":140,"_29":141,"_142":-5,"_39":40,"_38":143,"_144":57,"_36":248,"_13":61,"_32":146,"_34":147,"_23":24,"_148":-5,"_249":250,"_26":251},["D",1785235300474],"children",[],[140],["D",1785164953579],[],[151],["D",1785164962220],[],[158],["D",1785235304765],[],[166],["D",1785685955252],[],[173],["D",1785254993928],[],[181],["D",1785685986498],[],[27],["D",1785685349349],[],[191],["D",1785400402143],[],[198],["D",1785607284447],[],[206],["D",1785685952675],[],[213],["D",1785163109277],[],[220],["D",1785163109209],["D",1789484509295],{"_98":97,"_105":100},{"_98":97,"_99":100,"_101":100,"_18":53,"_102":103,"_104":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_124":323,"_324":325,"_326":327,"_328":24,"_329":24,"_330":24,"_331":57,"_332":-5,"_333":-7,"_334":-7,"_335":61,"_336":24,"_337":24,"_338":-5,"_339":24,"_340":24,"_341":24,"_342":-5},"ENV",{"_294":295,"_296":297,"_298":88,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322},"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"] </article></body></html>

Diff · v57