[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_345":346,"_347":348},"routes/_app.x.$handle.$name",{"_103":102,"_31":44,"_112":90,"_26":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":125,"_126":127,"_128":24,"_129":130,"_131":59,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":24},"version",109,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/auth.tsx","latestPath","fileId","6b89867a-7cae-11f1-b5b0-1607ee4eb77e","name","auth.tsx","fileType","script","content","/** @jsxImportSource npm:hono@4/jsx */\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The template's own live preview (owned by the \"templates\" org) is publicly\n// viewable. Your remix is owned by your org, so it requires login.\nconst IS_TEMPLATE_PREVIEW = parseVal().username === \"templates\";\n\n// Auth guard for the dashboard routes. Register the public webhook routes\n// (POST / and /process) BEFORE this so external systems can submit leads\n// without logging in.\nexport async function requireOrgMember(c: any, next: any) {\n if (IS_TEMPLATE_PREVIEW && c.req.method === \"GET\") return next();\n const session = await getOAuthUserData(c.req.raw);\n if (!session) return c.html();\n if (!session.isOrgMember) {\n return c.html(, 403);\n }\n await next();\n}\n\nfunction Shell({ title, children }: { title: string; children: any }) {\n return (\n \n \n \n \n {title}\n \n \n \n

\n {children}\n

\n \n \n );\n}\n\nfunction LoginPage() {\n return (\n \n

🔒

GitHub Leads Dashboard

\n \n $\"\"$ \n Sign in with Val Town\n \n

\n \n );\n}\n\nfunction UnauthorizedPage({ username }: { username: string }) {\n return (\n \n

⛔

Access Denied

\n You must be a member of this val's organization to view the dashboard.\n

\n Logged in as {username}\n

\n \n );\n}\n","createdAt",["D",1783722399530],"branchVersion","branchId","2beae49c-ed74-11f0-997b-42dde27851f2","id","2be6e306-ed74-11f0-997b-42dde27851f2","github-leads",["D",1767974365657],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Find customers to sell to from GitHub activity","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aeec28de-dccc-49ab-3dcc-66b67afd7700/square512?exp=1789549199&sig=d54b8f4321c3c4c5ef0f5ef6df79b4950fde1dc8fe81ea79059f2ca922e3cdef","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","019ba37b-ea2b-73cf-99fb-0144463ae288","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",3,"orgId","019aa807-52c2-709c-928b-2029bae9a558","tursoName","2be6e306ed7411f0997b42dde27851f2","tursoHostname","2be6e306ed7411f0997b42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789455078571],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_18":-5,"_108":109,"_110":59},"branch",{"_13":89,"_31":90,"_42":41,"_91":43,"_92":93,"_94":95,"_96":49,"_97":98,"_99":65,"_100":44,"_101":102},"isOwned",146,"main","projectId","forkedBranchId","6b736e3c-daf9-11f0-9e58-42dde27851f2","forkedBranchVersion",138,"forkedProjectPrivacy","forkedProjectId","6b7157fa-daf9-11f0-9e58-42dde27851f2","forkedProjectOrgId","projectName","userHandle","templates","handle","displayName","Templates","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789549199&sig=85ec03bbe2ae9af315fa5e89fceebe840b59020b3ec43df39e2ab37ef0d215ad","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":340,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":341,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":342,"_84":343,"_86":344,"_88":24},"tree",[258,263,265,266,267,268,269,270,271,272,273],"files",[258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273],"counts",{"_246":237,"_247":248,"_249":250,"_251":252,"_253":254},"contents",[146,147,148,149,150,151,152,153,154,155,156],"upstreamProject",{"_42":98,"_31":142,"_51":143,"_53":144,"_48":49,"_82":145},"upstreamBranch",{"_42":93,"_37":136,"_137":138,"_31":90,"_91":98,"_13":139,"_92":-5,"_94":-5,"_140":141,"_46":-5,"_88":24,"_48":49,"_101":102,"_64":65,"_100":142},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1765942523251],"updatedAt",["D",1783725702215],144,"lockfileKey","1783725702296-esm.town_v_templates_leads@144-main","leads","Lead qualifying from any data source","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/dbb4ad1d-cd97-4466-848f-80ed9f1be300/square512?exp=1789549199&sig=c63faefc37cc1b5f1a79f34099773f1ef92e0c5a34201f1d41f103d42370abbf",{"_103":102,"_111":107},{"_42":240,"_31":241,"_29":242,"_160":-5,"_40":41,"_39":243,"_162":59,"_37":244,"_13":237,"_33":238,"_35":-5,"_23":24,"_166":-5,"_26":245},{"_42":232,"_31":233,"_29":234,"_160":-5,"_40":41,"_39":235,"_162":59,"_37":236,"_13":237,"_33":238,"_35":-5,"_23":24,"_166":-5,"_26":239},{"_42":224,"_31":225,"_29":226,"_160":-5,"_40":41,"_39":227,"_162":24,"_37":228,"_13":229,"_33":20,"_35":230,"_23":24,"_166":-5,"_26":231},{"_42":217,"_31":218,"_29":219,"_160":-5,"_40":41,"_39":170,"_162":24,"_37":220,"_13":221,"_33":20,"_35":222,"_23":24,"_166":-5,"_26":223},{"_42":209,"_31":210,"_29":211,"_160":-5,"_40":41,"_39":212,"_162":24,"_37":213,"_13":214,"_33":34,"_35":215,"_23":24,"_166":-5,"_26":216},{"_42":201,"_31":202,"_29":203,"_160":-5,"_40":41,"_39":204,"_162":24,"_37":205,"_13":206,"_33":34,"_35":207,"_23":24,"_166":-5,"_26":208},{"_42":193,"_31":194,"_29":195,"_160":-5,"_40":41,"_39":196,"_162":24,"_37":197,"_13":198,"_33":34,"_35":199,"_23":24,"_166":-5,"_26":200},{"_42":185,"_31":186,"_29":187,"_160":-5,"_40":41,"_39":188,"_162":24,"_37":189,"_13":190,"_33":182,"_35":191,"_23":24,"_166":-5,"_26":192},{"_42":176,"_31":177,"_29":178,"_160":-5,"_40":41,"_39":179,"_162":24,"_37":180,"_13":181,"_33":182,"_35":183,"_23":24,"_166":-5,"_26":184},{"_42":168,"_31":169,"_29":57,"_160":-5,"_40":41,"_39":170,"_162":24,"_37":171,"_13":164,"_33":172,"_35":173,"_23":24,"_166":174,"_26":175},{"_42":157,"_31":158,"_29":159,"_160":-5,"_40":41,"_39":161,"_162":24,"_37":163,"_13":164,"_33":34,"_35":165,"_23":24,"_166":-5,"_26":167},"560cf52a-edb1-11f0-afb8-42dde27851f2","welcome-ui.tsx","019ba37b-ea2b-73cf-99fb-062784208fe8","parentId",85,"latest",["D",1768000635708],5,"/** @jsxImportSource npm:hono@4/jsx */\nimport { processLead } from \"./agent.ts\";\nimport { GITHUB_ORG } from \"./github.cron.ts\";\n\nconst ACTIVITY_TYPES = [\n { value: \"WatchEvent\", label: \"⭐ Star\" },\n { value: \"ForkEvent\", label: \"🍴 Fork\" },\n { value: \"IssuesEvent\", label: \"📝 Issue\" },\n { value: \"PullRequestEvent\", label: \"🔀 PR\" },\n];\n\nfunction createMockEvent(username: string, activityType: string, org: string) {\n const now = new Date().toISOString();\n const repoName = `${org}/example-repo`;\n\n const baseEvent = {\n id: `mock-${Date.now()}`,\n type: activityType,\n actor: {\n id: 0,\n login: username,\n display_login: username,\n gravatar_id: \"\",\n url: `https://api.github.com/users/${username}`,\n avatar_url: `https://github.com/${username}.png`,\n },\n repo: {\n id: 0,\n name: repoName,\n url: `https://api.github.com/repos/${repoName}`,\n },\n public: true,\n created_at: now,\n org: {\n id: 0,\n login: org,\n gravatar_id: \"\",\n url: `https://api.github.com/orgs/${org}`,\n avatar_url: `https://github.com/${org}.png`,\n },\n };\n\n switch (activityType) {\n case \"WatchEvent\":\n return { ...baseEvent, payload: { action: \"started\" } };\n case \"ForkEvent\":\n return {\n ...baseEvent,\n payload: {\n forkee: { full_name: `${username}/${repoName.split(\"/\")[1]}` },\n },\n };\n case \"IssuesEvent\":\n return {\n ...baseEvent,\n payload: {\n action: \"opened\",\n issue: { number: 1, title: \"Example issue\" },\n },\n };\n case \"PullRequestEvent\":\n return {\n ...baseEvent,\n payload: {\n action: \"opened\",\n pull_request: { number: 1, title: \"Example PR\" },\n },\n };\n default:\n return baseEvent;\n }\n}\n\nexport async function handleTestRequest(req: Request): Promise {\n try {\n const { username, activityType } = await req.json();\n\n if (!username || !activityType) {\n return Response.json({ error: \"Missing username or activityType\" }, {\n status: 400,\n });\n }\n\n const mockEvent = createMockEvent(username, activityType, GITHUB_ORG);\n const result = await processLead([mockEvent]);\n\n return Response.json({\n success: true,\n message: \"Lead processed! Refresh to see results.\",\n result,\n });\n } catch (error) {\n console.error(\"Test request error:\", error);\n return Response.json({ error: error.message }, { status: 500 });\n }\n}\n\ninterface WelcomePanelProps {\n testEndpoint: string;\n}\n\nexport function WelcomePanel({ testEndpoint }: WelcomePanelProps) {\n const scriptData = JSON.stringify({ testEndpoint });\n\n return (\n

\n \n Simulate Activity:\n \n @\n \n \n {ACTIVITY_TYPES.map((type) => (\n \n ))}\n \n \n Run\n \n \n

\n\n \n

\n );\n}","label",[158],"883ecee5-67fe-4435-a77a-53b7305f14f0","main.ts",104,["D",1783720570201],"http","import { Hono } from \"npm:hono@4\";\nimport { processLead, reanalyzeLead } from \"./agent.ts\";\nimport { app as dashboard } from \"./dashboard.tsx\";\nimport { handleTestRequest } from \"./welcome-ui.tsx\";\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n // Early API key check to avoid confusing when using the tester ui\n if (!Deno.env.get(\"OPENAI_API_KEY\")) {\n return c.json(\n { error: \"Add OPENAI_API_KEY in Environment Variables\" },\n 503,\n );\n }\n\n const body = await c.req.json();\n const url = new URL(c.req.url);\n const query = Object.fromEntries(url.searchParams);\n const inputData = Object.keys(query).length\n ? { ...body, _query: query }\n : body;\n\n // Fire-and-forget request for quick response and processing in another request\n // https://docs.val.town/vals/http/early-return/\n fetch(`${url.origin}/process`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(inputData),\n });\n\n return c.json({ ok: true });\n});\n\napp.post(\"/process\", async (c) => {\n const inputData = await c.req.json();\n await processLead(inputData);\n return c.json({ ok: true });\n});\n\n// Test endpoint for the welcome UI\napp.post(\"/test\", async (c) => {\n if (!Deno.env.get(\"OPENAI_API_KEY\")) {\n return c.json(\n { error: \"Add OPENAI_API_KEY in Environment Variables\" },\n 503,\n );\n }\n return handleTestRequest(c.req.raw);\n});\n\n// Reanalyze a lead\napp.post(\"/lead/:id/reanalyze\", async (c) => {\n if (!Deno.env.get(\"OPENAI_API_KEY\")) {\n return c.json(\n { error: \"Add OPENAI_API_KEY in Environment Variables\" },\n 503,\n );\n }\n \n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid lead ID\" }, { status: 400 });\n }\n \n try {\n const result = await reanalyzeLead(id);\n return c.json({ ok: true, ...result });\n } catch (error) {\n return c.json({ error: error.message }, { status: 500 });\n }\n});\n\napp.route(\"/\", dashboard);\n\nexport default app.fetch;\n","githubleads",[169],"4e7382cc-23ce-11f1-87b3-42dde27851f2","github.cron.ts","81346198-ed75-11f0-a2b0-42dde27851f2",99,["D",1773950441144],40,"interval","import { processLead } from \"./agent.ts\";\nimport { appendFollowup, findLeadByInputPath } from \"./db.ts\";\nimport { Octokit } from \"npm:octokit@5.0.5\";\n\nexport const GITHUB_ORG = \"val-town\";\n\nexport default async function (interval: Interval) {\n const lastChecked = interval.lastRunAt ?? new Date(0);\n\n const octokit = new Octokit({ auth: Deno.env.get(\"GITHUB_TOKEN\") });\n const recentEvents = await octokit.paginate(\n octokit.rest.activity.listPublicOrgEvents,\n { org: GITHUB_ORG, per_page: 100 },\n );\n\n const newEvents = recentEvents\n .filter((e: any) => new Date(e.created_at) > lastChecked)\n .filter((e: any) => e.actor?.login && !e.actor?.login.includes(\"[bot]\"));\n console.log(`Processing ${newEvents.length} new events`);\n\n const actorEvents = Map.groupBy(newEvents, (e) => e.actor.login);\n console.log(`Found ${actorEvents.size} users`);\n\n await Promise.all(\n Array.from(actorEvents, async ([login, events]) => {\n const existingLead = await findLeadByInputPath(\"actor.login\", login);\n if (existingLead) {\n await appendFollowup(existingLead.id, events);\n } else {\n await processLead(events);\n }\n }),\n );\n}",[177],"9bba1bbc-c80f-4aa2-ac1b-565cbf25bbb6","digest.ts","17e6dc20-ed75-11f0-abee-42dde27851f2",100,["D",1783610746961],8,"import { email } from \"https://esm.town/v/std/email\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getAllLeads } from \"./db.ts\";\n\n// ============================================================================\n// CONFIGURE: Set the DIGEST_RECIPIENTS env var to a comma-separated list of\n// email addresses to receive the daily digest\n// ============================================================================\nconst RECIPIENTS = (Deno.env.get(\"DIGEST_RECIPIENTS\") ?? \"\")\n .split(\",\")\n .map((s) => s.trim())\n .filter(Boolean);\n\nfunction getSource(inputData) {\n const input = typeof inputData === \"string\"\n ? JSON.parse(inputData)\n : inputData;\n const first = Array.isArray(input) ? input[0] : input;\n if (first?.actor?.login) return \"github\";\n if (first?._query?.source) return first._query.source;\n return null;\n}\n\nfunction getRepos(inputData): string[] {\n const input = typeof inputData === \"string\"\n ? JSON.parse(inputData)\n : inputData;\n const events = Array.isArray(input) ? input : [input];\n const repos = new Set();\n for (const event of events) {\n if (event?.repo?.name) {\n repos.add(event.repo.name);\n }\n }\n return Array.from(repos);\n}\n\nfunction formatHTML(matches, dashboardUrl) {\n const typeStyles: Record = {\n customer: { bg: \"#d1fae5\", color: \"#047857\" },\n hire: { bg: \"#ede9fe\", color: \"#6d28d9\" },\n };\n\n const rows = matches.map((l) => {\n const scoreDisplay = l.score\n ? `${l.score}`\n : \"\";\n\n const leadTypesDisplay = l.leadTypes && l.leadTypes.length > 0\n ? l.leadTypes.map((type: string) => {\n const style = typeStyles[type] || { bg: \"#f3f4f6\", color: \"#374151\" };\n return `${type}`;\n }).join(\"\")\n : \"\";\n\n const sourceTag = l.source\n ? `${l.source}`\n : \"\";\n\n const reposDisplay = l.repos && l.repos.length > 0\n ? `

${\n l.repos.map((repo: string) =>\n `📦 ${\n repo.split(\"/\")[1]\n }`\n ).join(\"\")\n }

`\n : \"\";\n\n return `\n \n \n

\n ${scoreDisplay}${l.name} ${leadTypesDisplay}${sourceTag}\n

\n ${l.reasoning}\n

\n ${reposDisplay}\n \n \n `;\n }).join(\"\");\n\n return `\n \n \n \n \n

🎯 ${matches.length} Qualified Lead${\n matches.length !== 1 ? \"s\" : \"\"\n }

\n \n \n ${rows}\n \n

\n View dashboard\n

\n \n \n `;\n}\n\nexport default async function (interval?: { lastRunAt?: Date }) {\n console.log(\"interval received:\", JSON.stringify(interval));\n\n if (RECIPIENTS.length === 0) {\n console.log(\n \"No recipients configured — set the DIGEST_RECIPIENTS env var to a comma-separated list of email addresses to receive the digest\",\n );\n return { sent: false, reason: \"no_recipients\" };\n }\n\n const dashboardUrl = await httpEndpoint(\"main.ts\", import.meta.url);\n const since = interval?.lastRunAt?.getTime() ??\n Date.now() - 24 * 60 * 60 * 1000;\n\n console.log(\"looking back to:\", new Date(since).toISOString());\n\n const leads = await getAllLeads();\n console.log(\"total leads in db:\", leads.length);\n\n const matches = leads\n .filter((l) => l.timestamp > since)\n .filter((l) => JSON.parse(l.output_data).match)\n .map((l) => ({\n id: l.id,\n source: getSource(l.input_data),\n repos: getRepos(l.input_data),\n ...JSON.parse(l.output_data),\n }))\n .sort((a, b) => (b.score ?? 0) - (a.score ?? 0));\n\n console.log(\"matches found:\", matches.length);\n\n if (matches.length === 0) {\n console.log(\"No matches since\", new Date(since).toISOString());\n return { sent: false };\n }\n\n const subject = `🎯 ${matches.length} Qualified Lead${\n matches.length !== 1 ? \"s\" : \"\"\n }`;\n await email({\n to: RECIPIENTS,\n subject,\n html: formatHTML(matches, dashboardUrl),\n });\n\n console.log(\n `Sent digest: ${matches.length} leads to ${RECIPIENTS.join(\", \")}`,\n );\n return { sent: true, count: matches.length };\n}\n",[186],"67d01cae-23cd-11f1-a7d8-42dde27851f2","db.ts","019ba37b-ea2b-73cf-99fa-ffb3027e4471",97,["D",1773950054188],9,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = \"github_leads_v4\";\n\nawait createTable();\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\nexport async function storeLead(\n inputData: Record | Record[],\n outputData: Record,\n) {\n // Always store as array\n const inputArray = Array.isArray(inputData) ? inputData : [inputData];\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (timestamp, input_data, output_data)\n VALUES (?, ?, ?)`,\n [Date.now(), JSON.stringify(inputArray), JSON.stringify(outputData)],\n );\n}\n\nexport async function updateLeadOutput(\n id: number,\n outputData: Record,\n) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ?`,\n [JSON.stringify(outputData), id],\n );\n}\n\nexport async function getAllLeads(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`,\n );\n return result.rows as unknown as Lead[];\n}\n\nexport async function getLeadById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id],\n );\n return result.rows[0] as unknown as Lead;\n}\n\nexport async function findLeadByInputPath(\n path: string,\n value: string,\n): Promise {\n const leads = await getAllLeads();\n return leads.find((lead) => {\n const input = JSON.parse(lead.input_data);\n // Check first event in array for the path\n const firstEvent = Array.isArray(input) ? input[0] : input;\n return path.split(\".\").reduce((obj, key) => obj?.[key], firstEvent) ===\n value;\n }) || null;\n}\n\nexport async function appendFollowup(\n id: number,\n data: Record | Record[],\n) {\n const lead = await getLeadById(id);\n const input = JSON.parse(lead!.input_data);\n const events = Array.isArray(input) ? input : [input];\n const newEvents = Array.isArray(data) ? data : [data];\n\n // Deduplicate by event ID to prevent unbounded growth\n const existingIds = new Set(events.map((e: any) => e.id).filter(Boolean));\n const uniqueNew = newEvents.filter((e: any) => !e.id || !existingIds.has(e.id));\n\n events.push(...uniqueNew);\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET input_data = ? WHERE id = ?`,\n [JSON.stringify(events), id],\n );\n}\n\nasync function createTable() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n input_data TEXT NOT NULL,\n output_data TEXT NOT NULL\n )`,\n );\n}",[194],"285cdfe6-f0b8-11f0-b725-42dde27851f2","dashboard.tsx","019ba37b-ea2b-73cf-99fa-fb45726c3a35",89,["D",1768333419019],10,"/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono } from \"npm:hono@4\";\nimport { getAllLeads, getLeadById, Lead } from \"./db.ts\";\nimport { WelcomePanel } from \"./welcome-ui.tsx\"; // DELETE THIS LINE to remove onboarding UI\nimport { marked } from \"npm:marked@11\";\n\nexport const app = new Hono();\n\nfunction getRepos(input: unknown): string[] {\n const events = Array.isArray(input) ? input : [input];\n const repos = new Set();\n for (const event of events) {\n if (event?.repo?.name) {\n repos.add(event.repo.name);\n }\n }\n return Array.from(repos);\n}\n\nfunction getSource(input: unknown): string | null {\n const first = Array.isArray(input) ? input[0] : input;\n if (first?.actor?.login) return \"github\";\n if (first?._query?.source) return first._query.source;\n return null;\n}\n\nfunction getUsername(input: unknown): string | null {\n const first = Array.isArray(input) ? input[0] : input;\n return first?.actor?.login || null;\n}\n\nfunction ReposList({ repos }: { repos: string[] }) {\n if (repos.length === 0) return null;\n return (\n

\n Repositories ({repos.length})\n

\n {repos.map((repo) => (\n \n \n {repo}\n \n ))}\n

\n );\n}\n\nfunction Layout({ children, title }: { children: any; title: string }) {\n return (\n \n \n \n \n {title}\n \n \n \n {children}\n \n );\n}\n\nfunction SourceBadge({ source }: { source: string | null }) {\n if (!source) return null;\n\n if (source === \"github\") {\n return (\n \n \n GitHub\n \n );\n }\n\n return (\n \n {source}\n \n );\n}\n\nfunction ScoreBadge({ score }: { score?: number }) {\n if (score === undefined || score === null) return null;\n\n const color = score >= 70\n ? \"bg-blue-100 text-blue-700\"\n : score >= 50\n ? \"bg-amber-100 text-amber-700\"\n : \"bg-gray-100 text-gray-500\";\n\n return (\n \n {score}\n \n );\n}\n\nfunction LeadTypeBadges({ leadTypes }: { leadTypes?: string[] }) {\n if (!leadTypes || leadTypes.length === 0) return null;\n\n const typeStyles: Record = {\n customer: \"bg-emerald-100 text-emerald-700\",\n hire: \"bg-purple-100 text-purple-700\",\n };\n\n return (\n <>\n {leadTypes.map((type) => (\n \n {type}\n \n ))}\n \n );\n}\n\nfunction LeadRow({ lead, isMatch }: { lead: Lead; isMatch: boolean }) {\n const output = JSON.parse(lead.output_data);\n const input = JSON.parse(lead.input_data);\n const eventCount = Array.isArray(input) ? input.length : 1;\n const source = getSource(input);\n const date = new Date(lead.timestamp).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n\n return (\n \n \n \n \n {output.name || \"Unknown\"}\n \n \n \n {eventCount > 1 && (\n \n {eventCount}\n \n )}\n {date}\n \n );\n}\n\nconst Arrow = () => (\n \n \n \n);\n\nfunction DataValue(\n { value, path, keyName }: { value: unknown; path: string; keyName?: string },\n) {\n if (value === null || value === undefined) {\n return (\n \n {keyName && {keyName}:}\n null\n \n );\n }\n\n if (typeof value !== \"object\") {\n return (\n \n {keyName && {keyName}:}\n {String(value)}\n \n );\n }\n\n if (Array.isArray(value)) {\n if (value.length === 0) {\n return (\n \n {keyName && {keyName}:}\n []\n \n );\n }\n const id = `arr-${path}`;\n return (\n

\n \n \n {keyName && {keyName}}\n [{value.length}]\n

\n {value.map((item, idx) => (\n

\n \n

\n ))}\n

\n \n );\n }\n\n const entries = Object.entries(value);\n if (entries.length === 0) {\n return (\n \n {keyName && {keyName}:}\n {\"{}\"}\n \n );\n }\n const id = `obj-${path}`;\n return (\n

\n \n \n {keyName && {keyName}}\n {`{${entries.length}}`}\n

\n {entries.map(([k, v]) => (\n

\n \n

\n ))}\n

\n \n );\n}\n\nfunction DataTable({ title, data }: { title: string; data: unknown }) {\n if (data === null || data === undefined) return null;\n\n if (Array.isArray(data)) {\n return (\n

\n {title} ({data.length})\n

\n {data.map((item, idx) => (\n

Event {idx + 1}

\n {Object.entries(item).map(([k, v]) => (\n

\n \n

\n ))}\n

\n );\n }\n\n const entries = Object.entries(data as Record);\n if (entries.length === 0) return null;\n\n return (\n

\n {title}\n

\n {entries.map(([key, value]) => (\n

\n \n

\n ))}\n

\n );\n}\n\napp.get(\"/\", async (c) => {\n const leads = await getAllLeads();\n const baseUrl = new URL(c.req.url).origin;\n const testEndpoint = `${baseUrl}/test`;\n\n const matches = leads.filter((l) => JSON.parse(l.output_data).match === true);\n const nonMatches = leads.filter((l) =>\n JSON.parse(l.output_data).match !== true\n );\n\n return c.html(\n \n

\n \n\n

GitHub Leads

\n \n view source\n \n

\n {leads.length} leads · {matches.length} matches\n

\n\n {leads.length === 0\n ? (\n

\n No leads yet. Configure your GitHub org and wait for activity, or\n use \"Try It Out\" above.\n

\n )\n : (\n

\n {matches.map((lead) => )}\n\n {nonMatches.length > 0 && (\n

\n \n {nonMatches.length} not matched\n v\n \n

\n {nonMatches.map((lead) => (\n \n ))}\n

\n )}\n

\n ,\n );\n});\n\napp.get(\"/lead/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n const lead = await getLeadById(id);\n\n if (!lead) {\n return c.html(\n \n

Lead Not Found

\n \n ← Back\n \n

\n ,\n 404,\n );\n }\n\n const input = JSON.parse(lead.input_data);\n const output = JSON.parse(lead.output_data);\n const repos = getRepos(input);\n const source = getSource(input);\n const username = getUsername(input);\n\n return c.html(\n \n

\n \n ← Back\n \n\n

\n {output.name || \"Unknown\"}\n

\n \n \n \n

\n {username && (\n \n @{username}\n \n )}\n

\n {new Date(lead.timestamp).toLocaleString()}\n {output.cost != null && ` · ${output.cost.toFixed(4)}`}\n

\n\n {/* Result Summary */}\n \n

\n \n \n {output.match ? \"Match\" : \"No Match\"}\n \n

\n \n

\n\n {/* Reanalyze Button */}\n

\n location.reload())`}\n class=\"px-4 py-2 bg-gray-100 hover:bg-gray-200 text-gray-700 border border-gray-200 disabled:opacity-50 font-medium rounded-lg text-sm\"\n >\n Reanalyze\n \n

\n\n {/* GitHub Repositories */}\n \n\n {/* AI Output first */}\n \n\n {/* Input Data second */}\n \n \n ,\n );\n});\n\nexport default app.fetch;",[202],"42274630-3bee-4d3c-9273-a89189056425","agent.ts","019ba37b-ea2b-73cf-99fa-f65a711e51a7",102,["D",1783709493354],11,"import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport \"npm:@modelcontextprotocol/sdk/types.js\"; // peer dep of @openai/agents that Deno needs installed explicitly\nimport { Agent, run, RunResult, webSearchTool } from \"npm:@openai/agents@0.7\";\nimport { getLeadById, storeLead, updateLeadOutput } from \"./db.ts\";\n\nconst PROMPT = await readFile(\"/PROMPT.txt\");\nconst agent = new Agent({\n name: \"Researcher\",\n model: \"gpt-5\",\n tools: [webSearchTool()],\n instructions: PROMPT,\n});\n\nfunction calculateCost(result: RunResult): number {\n // GPT-5 pricing (verified rates as of January 2026)\n const COST_PER_INPUT_TOKEN = 0.00000125; // $1.25 per 1M tokens\n const COST_PER_CACHED_INPUT_TOKEN = 0.000000125; // $0.125 per 1M tokens (90% discount)\n const COST_PER_OUTPUT_TOKEN = 0.00001; // $10 per 1M tokens\n\n const usage = result.state._context.usage;\n const inputTokens = usage.inputTokens || 0;\n const cachedInputTokens = usage.inputTokensDetails[0].cached_tokens || 0;\n const outputTokens = usage.outputTokens || 0;\n\n console.log(\"result.state\", result.state);\n console.log(\"result.state._context.usage\", usage);\n\n // Calculate cost: subtract cached tokens from regular input if both are provided\n const regularInputTokens = inputTokens - cachedInputTokens;\n const cost = (regularInputTokens * COST_PER_INPUT_TOKEN) +\n (cachedInputTokens * COST_PER_CACHED_INPUT_TOKEN) +\n (outputTokens * COST_PER_OUTPUT_TOKEN);\n\n console.log(\"Cost breakdown:\", {\n regularInputTokens,\n cachedInputTokens,\n outputTokens,\n cost,\n });\n\n return cost;\n}\n\nasync function analyzeLead(inputData: any) {\n const result = await run(agent, JSON.stringify(inputData));\n const outputData = JSON.parse(result.finalOutput);\n outputData.cost = calculateCost(result);\n return outputData;\n}\n\nexport async function processLead(inputData: any) {\n const outputData = await analyzeLead(inputData);\n await storeLead(inputData, outputData);\n console.log(outputData);\n return { outputData };\n}\n\nexport async function reanalyzeLead(id: number) {\n const lead = await getLeadById(id);\n if (!lead) throw new Error(`Lead ${id} not found`);\n\n const outputData = await analyzeLead(lead.input_data);\n await updateLeadOutput(id, outputData);\n return { outputData };\n}",[210],"48005561-0f91-4d15-840c-b3c401e0f1f1","README.md","019ba37b-ea2b-73cf-99fa-f3d9c3769619",["D",1783720570201],7,"# GitHub Leads\n\nFind potential customers from GitHub activity. Monitor your org's repos for\nstars, forks, issues, and PRs — then use AI to qualify leads automatically.\n\n## What this does\n\n1. A cron job monitors public activity on your GitHub org\n2. When someone stars, forks, or opens an issue/PR, they're captured\n3. An AI agent researches the person and scores them as a lead\n4. Qualified leads appear in your dashboard with periodic digest emails\n\n## Getting started\n\n1. Click [**Remix**](/?intent=remix)\n2. Add environment variables:\n - `OPENAI_API_KEY` — for AI lead qualification\n - `GITHUB_TOKEN` — for accessing GitHub API\n ([create one here](https://github.com/settings/tokens))\n - `DIGEST_RECIPIENTS` — comma-separated emails for the daily digest\n3. Configure your settings:\n - Edit `GITHUB_ORG` in [`github.cron.ts`](./github.cron.ts)\n - Customize [`PROMPT.txt`](./PROMPT.txt) with your ICP criteria\n4. Open [`main.ts`](./main.ts) to view your dashboard\n\n**Note:** GitHub's Events API only returns the 300 most recent events per org.\n\n## How it works\n\n**GitHub Monitoring** ([`github.cron.ts`](./github.cron.ts))\n\n- Runs hourly to check for new activity on your org\n- Captures stars, forks, issues, PRs, and other public events\n- Groups events by user to avoid duplicate leads\n\n**AI Agent** ([`agent.ts`](./agent.ts))\n\n- Researches each GitHub user's profile, repos, and linked sites\n- Uses web search to learn about their company and role\n- Scores them against your ICP defined in [`PROMPT.txt`](./PROMPT.txt)\n- Returns `{name, match, score, leadTypes, reasoning}`\n\n**Storage** ([`db.ts`](./db.ts))\n\n- Every lead is stored in SQLite with columns:\n - `id` — auto-incremented\n - `timestamp` — when first seen\n - `input_data` — the GitHub event(s) that triggered it\n - `output_data` — AI result\n\n**Dashboard** ([`main.ts`](./main.ts))\n\n- Qualified leads (match=true) appear at the top\n- Shows score and lead type tags (customer/hire)\n- Click a lead to see full details and GitHub activity\n\n**Email Digest** ([`digest.ts`](./digest.ts))\n\n- Sends daily emails (1pm UTC) with new qualified leads\n- Recipients are configured via the `DIGEST_RECIPIENTS` env var\n (comma-separated email addresses)\n\n## Customization\n\n- Edit [`PROMPT.txt`](./PROMPT.txt) to define your ideal customer profile\n- Adjust the GitHub sweep frequency in [`github.cron.ts`](./github.cron.ts)\n interval settings (default: hourly)\n- Adjust the email digest schedule in [`digest.ts`](./digest.ts) interval\n settings (default: daily at 1pm UTC)\n\n## Testing\n\nUse the test bar in the dashboard to evaluate any GitHub username instantly.\n",[218],"403624f6-f0b8-11f0-bed2-42dde27851f2","PROMPT.txt","019ba37b-ea2b-73cf-99fa-ed0b20eca3a8",90,["D",1768333459019],4,"You are an assistant to the CEO of Val Town.\n\nVal Town is like Zapier for people who know how to code, a tool for writing code and getting it running in the cloud,\nparticularly useful for lightweight automations in technical teams.\n\nI'm sending you data about GitHub activity and it's your job to exhuastively research the person by visiting the links \non their GitHub profile, any company listed on their profile, searching the web for their name creatively,\nfinding their personal and company sites, blogs they've written, etc to determine if they are in Val Town's \nideal customer profile.\n\nVal Town's ideal customer profile:\n\n1. Founder\n2. B2B SaaS Startup\n3. Seed-stage (approximately)\n4. They know how to code\n\nReturn your final response in JSON only with the following schema:\n\n{\n \"name\": string,\n \"company\": string,\n \"match\": boolean,\n \"score\": number,\n \"reasoning\": string\n}\n\nThe score field is from 0 to 100.\n\nThe company is where they currently work.\n\nFor the \"reasoning\" field, write in Markdown. Include newlines where appropriate.\n\nIf the person works at Val Town, there is no match and the score is 0.",[225],"9c1cdea9-4ba2-4b3a-8b3e-6f50d66ad73c","shared","da5f8181-1e13-4ebe-9f1b-2c28666398f9",105,["D",1783722336474],0,"directory",[233],"ab2bb3e7-4a60-438d-8cac-2baf00804fe0","backend","3ea2838f-5343-48f4-b985-0a829d249ddb",106,["D",1783722357816],[241],"pulls","branches",1,"forks",13,"envVars",{"_255":63,"_257":237},"connections",{"_255":237,"_256":237},"count","unfilledCount","emptyCount",{"_42":240,"_31":241,"_29":242,"_160":-5,"_40":41,"_39":243,"_162":59,"_37":337,"_13":237,"_33":238,"_35":-5,"_23":24,"_166":-5,"_275":338,"_26":339},{"_42":330,"_31":210,"_29":331,"_160":242,"_40":41,"_39":332,"_162":24,"_37":333,"_13":237,"_33":34,"_35":334,"_23":24,"_166":-5,"_275":335,"_26":336},{"_42":326,"_31":32,"_29":30,"_160":242,"_40":41,"_39":14,"_162":59,"_37":327,"_13":237,"_33":34,"_35":36,"_23":24,"_166":-5,"_275":328,"_26":329},{"_42":320,"_31":194,"_29":321,"_160":242,"_40":41,"_39":243,"_162":24,"_37":322,"_13":237,"_33":34,"_35":323,"_23":24,"_166":-5,"_275":324,"_26":325},{"_42":312,"_31":313,"_29":314,"_160":242,"_40":41,"_39":315,"_162":59,"_37":316,"_13":237,"_33":34,"_35":317,"_23":24,"_166":-5,"_275":318,"_26":319},{"_42":232,"_31":233,"_29":234,"_160":-5,"_40":41,"_39":235,"_162":59,"_37":309,"_13":237,"_33":238,"_35":-5,"_23":24,"_166":-5,"_275":310,"_26":311},{"_42":302,"_31":303,"_29":304,"_160":234,"_40":41,"_39":235,"_162":24,"_37":305,"_13":237,"_33":34,"_35":306,"_23":24,"_166":-5,"_275":307,"_26":308},{"_42":224,"_31":225,"_29":226,"_160":-5,"_40":41,"_39":227,"_162":24,"_37":299,"_13":229,"_33":20,"_35":230,"_23":24,"_166":-5,"_275":300,"_26":301},{"_42":217,"_31":218,"_29":219,"_160":-5,"_40":41,"_39":170,"_162":24,"_37":296,"_13":221,"_33":20,"_35":222,"_23":24,"_166":-5,"_275":297,"_26":298},{"_42":209,"_31":210,"_29":211,"_160":-5,"_40":41,"_39":212,"_162":24,"_37":293,"_13":214,"_33":34,"_35":215,"_23":24,"_166":-5,"_275":294,"_26":295},{"_42":201,"_31":202,"_29":203,"_160":-5,"_40":41,"_39":204,"_162":24,"_37":290,"_13":206,"_33":34,"_35":207,"_23":24,"_166":-5,"_275":291,"_26":292},{"_42":193,"_31":194,"_29":195,"_160":-5,"_40":41,"_39":196,"_162":24,"_37":287,"_13":198,"_33":34,"_35":199,"_23":24,"_166":-5,"_275":288,"_26":289},{"_42":185,"_31":186,"_29":187,"_160":-5,"_40":41,"_39":188,"_162":24,"_37":284,"_13":190,"_33":182,"_35":191,"_23":24,"_166":-5,"_275":285,"_26":286},{"_42":176,"_31":177,"_29":178,"_160":-5,"_40":41,"_39":179,"_162":24,"_37":281,"_13":181,"_33":182,"_35":183,"_23":24,"_166":-5,"_275":282,"_26":283},{"_42":168,"_31":169,"_29":57,"_160":-5,"_40":41,"_39":170,"_162":24,"_37":278,"_13":164,"_33":172,"_35":173,"_23":24,"_166":174,"_275":279,"_26":280},{"_42":157,"_31":158,"_29":159,"_160":-5,"_40":41,"_39":161,"_162":24,"_37":274,"_13":164,"_33":34,"_35":165,"_23":24,"_166":-5,"_275":276,"_26":277},["D",1768000635708],"children",[],[158],["D",1783720570201],[],[169],["D",1773950441144],[],[177],["D",1783610746961],[],[186],["D",1773950054188],[],[194],["D",1768333419019],[],[202],["D",1783709493354],[],[210],["D",1783720570201],[],[218],["D",1768333459019],[],[225],"f8020cfb-bc74-440f-94fb-c82cebb89bca","types.ts","45f2a14e-7cae-11f1-9c75-1607ee4eb77e",["D",1783722336474],"// Types shared between the Hono backend and the React frontend.\n\nexport interface LeadOutput {\n name?: string;\n company?: string;\n score?: number;\n reasoning?: string;\n error?: string;\n [key: string]: unknown;\n}\n\nexport type LeadStatus = \"processing\" | \"done\" | \"failed\";\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input: Record;\n output: LeadOutput | null;\n status: LeadStatus;\n score: number | null;\n}\n\n// A lead still \"processing\" after this long almost certainly crashed.\nexport const PROCESSING_TIMEOUT_MS = 3 * 60 * 1000;\n\n// A lead is qualified at or above this score: green in the UI, and the bar\n// any notification (email digest, Slack, etc.) should trigger on.\nexport const QUALIFIED_SCORE = 80;\n\n// Sentinel the backend writes into output_data when it claims a lead for\n// scoring, so concurrent /process calls can't double-score it. Both \"\" (just\n// created) and this sentinel mean \"still processing\".\nexport const CLAIMED_OUTPUT = \"claimed\";\n\ninterface LeadRow {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\n// Turn a raw DB row (input_data/output_data as JSON strings) into the shape the\n// frontend consumes: parsed fields plus a single computed status. Keeping this\n// one function as the source of truth means the server and client never disagree\n// about whether a lead is processing, done, or failed.\nexport function toClientLead(row: LeadRow, now: number): Lead {\n let input: Record = {};\n try {\n input = JSON.parse(row.input_data);\n } catch { /* leave as {} */ }\n\n const base = { id: row.id, timestamp: row.timestamp, input };\n\n // Empty or claimed output = the agent hasn't written a result yet.\n if (row.output_data === \"\" || row.output_data === CLAIMED_OUTPUT) {\n const timedOut = now - row.timestamp > PROCESSING_TIMEOUT_MS;\n return { ...base, output: null, status: timedOut ? \"failed\" : \"processing\", score: null };\n }\n\n let output: LeadOutput;\n try {\n output = JSON.parse(row.output_data);\n } catch {\n return { ...base, output: { error: \"Malformed output\" }, status: \"failed\", score: null };\n }\n\n if (output.error) return { ...base, output, status: \"failed\", score: null };\n\n return {\n ...base,\n output,\n status: \"done\",\n score: typeof output.score === \"number\" ? output.score : 0,\n };\n}\n",[],[233,303],["D",1783722336474],[264],[233],"db78c653-e245-4201-8a6d-437ba72c44ff","notify.ts","5a4b0398-7cae-11f1-b950-1607ee4eb77e",107,["D",1783722370612],"import { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport { LeadOutput, QUALIFIED_SCORE } from \"../shared/types.ts\";\n\n// Set the SLACK_WEBHOOK_URL env var to get a Slack message the moment a lead\n// scores as qualified. Without it, this is a no-op.\n// https://docs.val.town/guides/slack/send-messages-to-slack/\nexport async function notifySlack(output: LeadOutput) {\n const webhookUrl = Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (!webhookUrl) return;\n if (typeof output.score !== \"number\" || output.score < QUALIFIED_SCORE) return;\n\n // Best-effort: a Slack hiccup should never fail (or retry) the lead scoring.\n try {\n const dashboardUrl = await httpEndpoint(\"main.ts\", import.meta.url);\n const who = [output.name, output.company].filter(Boolean).join(\" · \");\n await new IncomingWebhook(webhookUrl).send({\n text: [\n `🎯 Qualified lead (${output.score}): *${who || \"Unknown\"}*`,\n output.reasoning,\n `<${dashboardUrl}|Open dashboard>`,\n ].filter(Boolean).join(\"\\n\"),\n });\n } catch (err) {\n console.error(\"Slack notification failed:\", err);\n }\n}\n",[],[241,313],"1dee54b7-e733-476b-84a8-77d761420f58","52aba23c-7cae-11f1-a02d-1607ee4eb77e",["D",1783722357816],"import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport { CLAIMED_OUTPUT } from \"../shared/types.ts\";\n\nconst TABLE_NAME = \"leads\";\n\nawait createTable();\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\nexport async function createProcessingLead(\n inputData: Record,\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (timestamp, input_data, output_data)\n VALUES (?, ?, ?)`,\n [Date.now(), JSON.stringify(inputData), \"\"],\n );\n return Number(result.lastInsertRowid);\n}\n\n// Atomically claim a just-created lead for scoring. Returns false if the\n// lead doesn't exist or was already claimed/finished, so concurrent /process\n// calls can't double-score (and double-spend on) the same lead.\nexport async function claimLead(id: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ? AND output_data = ''`,\n [CLAIMED_OUTPUT, id],\n );\n return result.rowsAffected > 0;\n}\n\nexport async function updateLeadOutput(\n id: number,\n outputData: Record,\n) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ?`,\n [JSON.stringify(outputData), id],\n );\n}\n\nexport async function getAllLeads(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`,\n );\n return rowsToLeads(result);\n}\n\nexport async function getLeadById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id],\n );\n const leads = rowsToLeads(result);\n return leads[0] || null;\n}\n\n// Find an existing lead by the github_username stored in its input, so the\n// GitHub cron appends new activity to the same person instead of creating a\n// duplicate lead.\nexport async function findLeadByGithubUsername(\n login: string,\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME}\n WHERE json_extract(input_data, '$.github_username') = ?`,\n [login],\n );\n const leads = rowsToLeads(result);\n return leads[0] || null;\n}\n\n// Append new GitHub events to an existing lead's input, deduplicated by\n// event id so repeat sweeps don't grow the lead unboundedly.\nexport async function appendFollowup(\n id: number,\n newEvents: Array<{ id?: string }>,\n) {\n const lead = await getLeadById(id);\n if (!lead) return;\n const input = JSON.parse(lead.input_data);\n const events: Array<{ id?: string }> = Array.isArray(input.events) ? input.events : [];\n const existingIds = new Set(events.map((e) => e.id).filter(Boolean));\n events.push(...newEvents.filter((e) => !e.id || !existingIds.has(e.id)));\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET input_data = ? WHERE id = ?`,\n [JSON.stringify({ ...input, events }), id],\n );\n}\n\nfunction rowsToLeads(result: { columns: string[]; rows: unknown[] }): Lead[] {\n return result.rows.map((row: any) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj as Lead;\n });\n}\n\nasync function createTable() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n input_data TEXT NOT NULL,\n output_data TEXT NOT NULL\n )`,\n );\n}\n\nexport function isProcessing(lead: Lead): boolean {\n return lead.output_data === \"\" || lead.output_data === CLAIMED_OUTPUT;\n}\n\nexport function isFailed(lead: Lead): boolean {\n if (isProcessing(lead)) return false;\n try {\n return Boolean(JSON.parse(lead.output_data).error);\n } catch {\n return true;\n }\n}\n",[],[241,194],"fcf76045-e5c1-4a27-9591-87c38b079a37",["D",1783722399530],[],[241,32],"fa36e00f-4ab6-4ab8-b268-c92e533006a5","5ffdc05a-7cae-11f1-ab77-1607ee4eb77e",108,["D",1783722380138],"import { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { clay } from \"https://esm.town/v/valdottown/clay-proxy/sdk.ts\";\nimport OpenAI from \"npm:openai\";\nimport { updateLeadOutput } from \"./db.ts\";\nimport { notifySlack } from \"./notify.ts\";\n\n// Uses Val Town's built-in OpenAI proxy, so no API key setup is needed.\n// If you hit its rate limits, set the OPENAI_API_KEY env var to use your\n// own OpenAI account instead.\nconst apiKey = Deno.env.get(\"OPENAI_API_KEY\");\nconst openai = apiKey ? new OpenAI({ apiKey }) : new ValTownOpenAI({});\n\nconst PROMPT = await readFile(\"/PROMPT.md\");\n\n// Clay enrichment (person, LinkedIn, company, funding) is available to\n// Val Town Pro accounts; free accounts skip it and rely on web search alone.\nasync function enrichLead(inputData: Record) {\n if (!inputData.email && !inputData.github_username) return {};\n try {\n const enrichment = await clay({\n email: inputData.email as string | undefined,\n github_username: inputData.github_username as string | undefined,\n source: \"github-leads-template\",\n });\n return { enrichment };\n } catch (err) {\n if (err.status === 401 || err.status === 403) {\n return {\n enrichmentNote:\n \"Clay enrichment unavailable — requires Val Town Pro (https://www.val.town/pricing)\",\n };\n }\n console.error(\"Clay enrichment failed:\", err);\n return { enrichmentNote: `Clay enrichment failed: ${err.message}` };\n }\n}\n\nexport async function processLead(\n leadId: number,\n inputData: Record,\n) {\n try {\n const { enrichment, enrichmentNote } = await enrichLead(inputData);\n const response = await openai.responses.create({\n model: \"gpt-5\",\n tools: [{ type: \"web_search\" }],\n instructions: PROMPT,\n input: JSON.stringify(enrichment ? { ...inputData, enrichment } : inputData),\n });\n if (response.status !== \"completed\") {\n throw new Error(`Model response ${response.status}: ${JSON.stringify(response.incomplete_details)}`);\n }\n // The prompt asks for bare JSON, but models sometimes wrap it in ```json fences\n const json = response.output_text.replace(/^\\s*```(?:json)?\\s*|\\s*```\\s*$/g, \"\");\n const outputData = { ...JSON.parse(json), ...(enrichmentNote && { enrichmentNote }) };\n await updateLeadOutput(leadId, outputData);\n await notifySlack(outputData);\n return { outputData };\n } catch (err) {\n // Record the failure so the dashboard shows it immediately instead of\n // spinning until the timeout. Log first so the root cause survives even if\n // this DB write itself throws.\n console.error(`Lead ${leadId} failed:`, err);\n const error = err instanceof Error ? err.message : String(err);\n await updateLeadOutput(leadId, { error });\n throw err;\n }\n}\n",[],[241,210],["D",1783722357816],[259,260,261,262],[241],["D",1767974365657],["D",1789455078571],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_18":-5,"_108":109,"_110":59},{"_13":89,"_31":90,"_42":41,"_91":43,"_92":93,"_94":95,"_96":49,"_97":98,"_99":65,"_100":44,"_101":102},"ctx",{"_82":-5,"_133":378,"_379":380,"_381":382,"_383":24,"_384":24,"_385":24,"_386":59,"_387":-5,"_388":-7,"_389":-7,"_390":237,"_391":24,"_392":24,"_393":-5,"_394":24,"_395":24,"_396":24,"_397":-5},"ENV",{"_349":350,"_351":352,"_353":90,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377},"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 · v109