`;\n    });\n\n    // Check for inputs\n    const inputs = document.querySelectorAll(\"input[type='text'], input:not([type])\");\n    results[\"text_inputs\"] = Array.from(inputs).map((el) => {\n      return `<input name=\"${el.name}\" placeholder=\"${el.placeholder}\" class=\"${el.className?.slice(0, 80)}\">`;\n    });\n\n    // Check for elements with placeholder-like text\n    const placeholders = document.querySelectorAll(\"[data-placeholder], [placeholder]\");\n    results[\"placeholders\"] = Array.from(placeholders).map((el) => {\n      const tag = el.tagName;\n      const ph = el.getAttribute(\"data-placeholder\") || el.getAttribute(\"placeholder\") || \"\";\n      const classes = el.className?.toString().slice(0, 80) || \"\";\n      return `<${tag} placeholder=\"${ph}\" class=\"${classes}\">`;\n    });\n\n    // Check for ProseMirror (common rich text editor)\n    const prosemirror = document.querySelectorAll(\".ProseMirror, [class*='prosemirror'], [class*='ProseMirror']\");\n    results[\"prosemirror\"] = Array.from(prosemirror).map((el) => {\n      const tag = el.tagName;\n      const classes = el.className?.toString().slice(0, 100) || \"\";\n      const role = el.getAttribute(\"role\") || \"\";\n      return `<${tag} class=\"${classes}\" role=\"${role}\">`;\n    });\n\n    // Check for elements that might be title/subtitle\n    const titleLike = document.querySelectorAll(\n      \"[class*='title'], [class*='Title'], [data-testid*='title'], [role='textbox']\"\n    );\n    results[\"title_like\"] = Array.from(titleLike).map((el) => {\n      const tag = el.tagName;\n      const classes = el.className?.toString().slice(0, 100) || \"\";\n      const role = el.getAttribute(\"role\") || \"\";\n      const testid = el.getAttribute(\"data-testid\") || \"\";\n      const text = (el as HTMLElement).innerText?.slice(0, 50) || \"\";\n      return `<${tag} class=\"${classes}\" role=\"${role}\" data-testid=\"${testid}\"> text=\"${text}\"`;\n    });\n\n    // Get the main editor container structure\n    const editorContainer = document.querySelector(\".editor, [class*='editor'], [class*='Editor'], #editor\");\n    if (editorContainer) {\n      results[\"editor_container\"] = [editorContainer.outerHTML.slice(0, 300)];\n    }\n\n    // Dump all role=textbox elements with full detail\n    const textboxes = document.querySelectorAll(\"[role='textbox']\");\n    results[\"textboxes_detail\"] = Array.from(textboxes).map((el) => {\n      return JSON.stringify({\n        tag: el.tagName,\n        id: el.id,\n        class: el.className?.toString().slice(0, 150),\n        role: el.getAttribute(\"role\"),\n        ariaLabel: el.getAttribute(\"aria-label\"),\n        contentEditable: el.getAttribute(\"contenteditable\"),\n        dataPlaceholder: el.getAttribute(\"data-placeholder\"),\n        childCount: el.children.length,\n        innerTextPreview: (el as HTMLElement).innerText?.slice(0, 80),\n      });\n    });\n\n    return results;\n  });\n\n  for (const [key, values] of Object.entries(exploration)) {\n    console.log(`--- ${key} (${values.length}) ---`);\n    for (const v of values) {\n      console.log(`  ${v}`);\n    }\n    console.log();\n  }\n\n} catch (error) {\n  console.error(\"❌ Error:\", error);\n} finally {\n  await browser.close();\n  await kernel.browsers.deleteByID(kernelBrowser.session_id);\n  console.log(\"🧹 Cleaned up\");\n}\n",[144],"89e06b6497fd31426626f15a54bba80d3f4f41de196a2e76011b49a3f7d7c212","delete-empty-drafts.ts",{"_32":155,"_13":153,"_77":156,"_79":-5,"_80":57,"_81":56,"_83":26,"_34":157,"_40":158,"_86":87,"_88":159,"_64":48,"_90":-5,"_91":-7,"_70":160,"_93":161},"c8ca6dd0-3777-11f1-8296-42b51c65c3df","2d0a4178-3776-11f1-849a-42b51c65c3df",["D",1776112303408],22,"/**\n * Delete empty/untitled drafts from optimizerslog Substack.\n */\nDeno.env.set(\"TMPDIR\", \"/tmp\");\nimport \"https://esm.town/v/wolf/StubFS/stubFs.ts\";\nimport { chromium } from \"npm:playwright-core\";\nimport Kernel from \"npm:@onkernel/sdk\";\n\nconst KERNEL_PROFILE_ID = \"nommt2ugvvjvu81g00d4vf7h\";\nconst PUB = \"optimizerslog.substack.com\";\nconst API_KEY = Deno.env.get(\"kernel_api_key\") || Deno.env.get(\"KERNEL_API_KEY\");\nif (!API_KEY) throw new Error(\"Missing kernel_api_key\");\n\nconst kernel = new Kernel({ apiKey: API_KEY });\nconst kb = await kernel.browsers.create({ profile: { id: KERNEL_PROFILE_ID } });\nconst browser = await chromium.connectOverCDP(kb.cdp_ws_url);\n\ntry {\n  const ctx = browser.contexts()[0] || (await browser.newContext());\n  const page = ctx.pages()[0] || (await ctx.newPage());\n\n  await page.goto(`https://${PUB}/publish/posts/drafts`, { waitUntil: \"domcontentloaded\", timeout: 30000 });\n  await page.waitForTimeout(2000);\n\n  // Fetch drafts (paginate since API max is 25)\n  const allDrafts: any[] = [];\n  let offset = 0;\n  while (true) {\n    const raw = await page.evaluate(async ({ pub, offset }) => {\n      const res = await fetch(\n        `https://${pub}/api/v1/post_management/drafts?offset=${offset}&limit=25&order_by=draft_updated_at&order_direction=desc`,\n        { credentials: \"include\" },\n      );\n      if (!res.ok) throw new Error(`${res.status}: ${await res.text()}`);\n      return res.json();\n    }, { pub: PUB, offset });\n\n    const batch = Array.isArray(raw) ? raw : raw.posts || raw.drafts || [];\n    allDrafts.push(...batch);\n    if (batch.length < 25) break;\n    offset += 25;\n  }\n  const drafts = allDrafts;\n\n  // Delete empty ones and [TEST] ones\n  const toDelete = drafts.filter((d: any) => {\n    const title = (d.draft_title || d.title || \"\").trim();\n    return !title || title.startsWith(\"[TEST]\");\n  });\n\n  console.log(`${drafts.length} drafts total, ${toDelete.length} to delete\\n`);\n\n  for (const d of toDelete) {\n    const result: any = await page.evaluate(async ({ pub, id }) => {\n      const res = await fetch(`https://${pub}/api/v1/drafts/${id}`, {\n        method: \"DELETE\",\n        credentials: \"include\",\n      });\n      return { status: res.status, body: await res.text().catch(() => \"\") };\n    }, { pub: PUB, id: d.id });\n\n    console.log(`  DELETE \"${d.draft_title || d.title || \"(empty)\"}\" id=${d.id} → ${result.status}`);\n  }\n} finally {\n  await browser.close();\n  await kernel.browsers.deleteByID(kb.session_id);\n}\n",[153],"1c665a0cb11f5690d680682a30496ba8bf80090b0e2d55b193fb991f167e7883","create-draft.ts",{"_32":164,"_13":162,"_77":165,"_79":-5,"_80":57,"_81":166,"_83":26,"_34":167,"_40":131,"_86":87,"_88":168,"_64":48,"_90":-5,"_91":-7,"_70":169,"_93":170},"a00e0b42-3775-11f1-8837-42b51c65c3df","496642fa-3775-11f1-8837-42b51c65c3df",20,["D",1776111376095],"/**\n * Creates a Substack draft post via Kernel browser automation.\n *\n * Uses Playwright to fill in the title, subtitle, and body\n * on the Substack post editor, then waits for auto-save.\n */\nimport \"https://esm.town/v/wolf/StubFS/stubFs.ts\";\nimport { chromium, type Page } from \"npm:playwright-core\";\nimport Kernel from \"npm:@onkernel/sdk\";\n\nconst KERNEL_PROFILE_ID = \"nommt2ugvvjvu81g00d4vf7h\";\n\ninterface DraftInput {\n  title: string;\n  subtitle?: string;\n  body: string;\n}\n\ninterface DraftResult {\n  success: boolean;\n  postUrl?: string;\n  error?: string;\n}\n\n/**\n * Fill the Substack post editor fields and wait for auto-save.\n */\nasync function fillEditor(page: Page, draft: DraftInput): Promise<string> {\n  const editorUrl = \"https://optimizerslog.substack.com/publish/post?\";\n  console.log(`📝 Navigating to new post editor...`);\n  await page.goto(editorUrl, { waitUntil: \"domcontentloaded\", timeout: 30000 });\n  // Wait for the editor to render (Substack is a React SPA)\n  await page.waitForSelector('textarea[data-testid=\"post-title\"]', { timeout: 15000 });\n  console.log(\"✅ Editor loaded\\n\");\n\n  // --- Title ---\n  console.log(`📌 Setting title: \"${draft.title}\"`);\n  const titleEl = page.locator('textarea[data-testid=\"post-title\"]');\n  await titleEl.click();\n  await titleEl.fill(draft.title);\n\n  // --- Subtitle ---\n  if (draft.subtitle) {\n    console.log(`📌 Setting subtitle: \"${draft.subtitle}\"`);\n    const subtitleEl = page.locator(\"textarea.subtitle\");\n    await subtitleEl.click();\n    await subtitleEl.fill(draft.subtitle);\n  }\n\n  // --- Body ---\n  console.log(`📌 Setting body (${draft.body.length} chars)`);\n  // The main body editor is the first tiptap ProseMirror contenteditable div\n  const bodyEl = page.locator(\"div.tiptap.ProseMirror\").first();\n  await bodyEl.scrollIntoViewIfNeeded();\n  await bodyEl.click({ force: true, timeout: 10000 });\n  // Type via keyboard so ProseMirror registers the input properly\n  await page.keyboard.type(draft.body, { delay: 5 });\n\n  // --- Wait for auto-save ---\n  // Substack auto-saves drafts; wait a few seconds for it to persist\n  console.log(\"\\n⏳ Waiting for auto-save...\");\n  await page.waitForTimeout(4000);\n\n  const postUrl = page.url();\n  console.log(`✅ Draft saved at: ${postUrl}`);\n  return postUrl;\n}\n\n/**\n * Create a Substack draft post using a Kernel browser session.\n */\nexport async function createSubstackDraft(draft: DraftInput): Promise<DraftResult> {\n  const apiKey = Deno.env.get(\"kernel_api_key\") || Deno.env.get(\"KERNEL_API_KEY\");\n  if (!apiKey) throw new Error(\"Missing env var: kernel_api_key\");\n\n  const kernel = new Kernel({ apiKey });\n\n  console.log(\"🚀 Creating Kernel browser session...\");\n  const kernelBrowser = await kernel.browsers.create({\n    profile: { id: KERNEL_PROFILE_ID },\n  });\n  console.log(`   Session: ${kernelBrowser.session_id}\\n`);\n\n  const browser = await chromium.connectOverCDP(kernelBrowser.cdp_ws_url);\n\n  try {\n    const context = browser.contexts()[0] || (await browser.newContext());\n    const page = context.pages()[0] || (await context.newPage());\n\n    // Check we're not redirected to login\n    const postUrl = await fillEditor(page, draft);\n\n    if (postUrl.includes(\"sign-in\") || postUrl.includes(\"login\")) {\n      return { success: false, error: \"Not authenticated — redirected to login\" };\n    }\n\n    return { success: true, postUrl };\n  } catch (error) {\n    const msg = error instanceof Error ? error.message : String(error);\n    console.error(\"❌ Error:\", msg);\n    return { success: false, error: msg };\n  } finally {\n    await browser.close();\n    await kernel.browsers.deleteByID(kernelBrowser.session_id);\n    console.log(\"🧹 Browser session cleaned up\");\n  }\n}\n",[162],"8a29c36e58eaf63eab994719127fdd144cff22bb2ff85e0bbdee14793a6e4424",["D",1775248563410],"legacyEnvVars","httpPrivacy","description","Google Form → AI Blog Post → Substack Draft pipeline","imageUrl","userId","cf3b6dd0-7ebd-4375-8613-79f661b36164","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","400df533-f194-4779-8ddb-e51672d37653","tursoName","bba1e21a2f9c11f182a242dde27851f2","tursoHostname","bba1e21a2f9c11f182a242dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519842404],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_212":208},"org",{"_11":12,"_206":-5,"_207":208,"_177":178,"_209":210,"_211":48},"branch","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycXlUVjNXM1F4Yjg2YXFXbWE2bVo0WTVhRXYifQ","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":58,"_13":14,"_34":304,"_46":-5,"_172":48,"_49":50,"_173":50,"_174":175,"_176":-5,"_177":178,"_179":-5,"_180":48,"_181":-5,"_182":-5,"_183":98,"_53":184,"_185":186,"_187":188,"_189":305,"_191":-5,"_192":193,"_194":193,"_195":196,"_197":196,"_198":196,"_199":193,"_200":193,"_201":306,"_203":307,"_205":308,"_47":48},"tree",[279,280,281,282,283,284,285,286],"files",[279,280,281,282,283,284,285,286],"counts",{"_268":22,"_269":98,"_270":98,"_271":272,"_273":274},"contents",[240,241,242,243,244,245,246,247],"upstreamProject",{"_32":39,"_13":14,"_174":175,"_176":-5,"_49":50,"_201":238},"upstreamBranch",{"_32":33,"_34":236,"_36":237,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1775248166909],["D",1775248378154],{"_11":52,"_212":239},"https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_32":105,"_13":102,"_77":106,"_79":-5,"_80":57,"_81":107,"_83":26,"_34":266,"_40":109,"_86":110,"_88":111,"_64":48,"_90":-5,"_70":267},{"_32":164,"_13":162,"_77":165,"_79":-5,"_80":57,"_81":166,"_83":26,"_34":264,"_40":131,"_86":87,"_88":168,"_64":48,"_90":-5,"_70":265},{"_32":155,"_13":153,"_77":156,"_79":-5,"_80":57,"_81":56,"_83":26,"_34":262,"_40":158,"_86":87,"_88":159,"_64":48,"_90":-5,"_70":263},{"_32":146,"_13":144,"_77":147,"_79":-5,"_80":57,"_81":148,"_83":26,"_34":260,"_40":98,"_86":87,"_88":150,"_64":48,"_90":-5,"_70":261},{"_32":137,"_13":135,"_77":138,"_79":-5,"_80":57,"_81":139,"_83":26,"_34":258,"_40":22,"_86":87,"_88":141,"_64":48,"_90":-5,"_70":259},{"_32":252,"_13":253,"_77":254,"_79":-5,"_80":57,"_81":98,"_83":26,"_34":255,"_40":22,"_86":87,"_88":256,"_64":48,"_90":-5,"_70":257},{"_32":127,"_13":125,"_77":128,"_79":-5,"_80":57,"_81":129,"_83":26,"_34":250,"_40":131,"_86":87,"_88":132,"_64":48,"_90":-5,"_70":251},{"_32":76,"_13":71,"_77":78,"_79":-5,"_80":57,"_81":82,"_83":26,"_34":248,"_40":85,"_86":87,"_88":89,"_64":48,"_90":-5,"_70":249},["D",1775426220545],[71],["D",1776110567480],[125],"bbac35bc-2f9c-11f1-82a2-42dde27851f2","test-google-sheet.ts","019d550f-5d26-75fe-a856-6bd58b668c72",["D",1775248563410],"/**\n * Test script: Verify we can read rows from an unlisted Google Sheet.\n *\n * Unlisted Google Sheets can be fetched as JSON without any API key\n * using the public export URL format.\n *\n * Set GOOGLE_SHEET_ID env var before running.\n */\n\nconst SHEET_ID = Deno.env.get(\"GOOGLE_SHEET_ID\");\n\nif (!SHEET_ID) {\n  console.error(\"❌ GOOGLE_SHEET_ID env var is not set.\");\n  console.log(\"Set it to the ID from your Google Sheet URL (between /d/ and /edit).\");\n  throw new Error(\"Missing GOOGLE_SHEET_ID env var\");\n}\n\n// Google Sheets can be exported as CSV publicly if the sheet is \"Anyone with the link\"\n// We'll use the gviz JSON endpoint which returns structured data\nconst url = `https://docs.google.com/spreadsheets/d/${SHEET_ID}/gviz/tq?tqx=out:json`;\n\nconsole.log(`📊 Fetching sheet: ${SHEET_ID}`);\nconsole.log(`   URL: ${url}\\n`);\n\ntry {\n  const resp = await fetch(url);\n\n  if (!resp.ok) {\n    console.error(`❌ HTTP ${resp.status}: ${resp.statusText}`);\n    console.log(\"Make sure the sheet is set to 'Anyone with the link can view'.\");\n    throw new Error(`HTTP ${resp.status}`);\n  }\n\n  const text = await resp.text();\n\n  // Google wraps the JSON in a callback: google.visualization.Query.setResponse({...})\n  // Strip that wrapper to get the raw JSON\n  const jsonStr = text.replace(/^.*google\\.visualization\\.Query\\.setResponse\$/, \"\").replace(/\$;?\\s*$/, \"\");\n  const data = JSON.parse(jsonStr);\n\n  if (data.status !== \"ok\") {\n    console.error(\"❌ Google returned an error:\", data);\n    throw new Error(\"Google API error\");\n  }\n\n  const table = data.table;\n  const cols = table.cols.map((c: any) => c.label || c.id);\n  const rows = table.rows;\n\n  console.log(`✅ Successfully connected to Google Sheet!`);\n  console.log(`   Columns (${cols.length}): ${JSON.stringify(cols)}`);\n  console.log(`   Rows: ${rows.length}\\n`);\n\n  // Show first 3 rows as a preview\n  const preview = rows.slice(0, 3);\n  for (let i = 0; i < preview.length; i++) {\n    const row = preview[i];\n    const values = row.c.map((cell: any) => cell?.v ?? null);\n    const obj: Record<string, any> = {};\n    cols.forEach((col: string, j: number) => {\n      obj[col] = values[j];\n    });\n    console.log(`   Row ${i + 1}:`, JSON.stringify(obj, null, 2));\n  }\n\n  if (rows.length > 3) {\n    console.log(`   ... and ${rows.length - 3} more rows`);\n  }\n} catch (err) {\n  console.error(\"❌ Failed to fetch sheet:\", err);\n}\n",[253],["D",1776111236230],[135],["D",1776111189480],[144],["D",1776112303408],[153],["D",1776111376095],[162],["D",1775426284897],[102],"pulls","branches","forks","envVars",{"_275":277,"_278":22},"connections",{"_275":22,"_276":22},"count","unfilledCount",4,"emptyCount",{"_32":105,"_13":102,"_77":106,"_79":-5,"_80":57,"_81":107,"_83":26,"_34":108,"_40":109,"_86":110,"_88":111,"_64":48,"_90":-5,"_91":302,"_70":303},{"_32":164,"_13":162,"_77":165,"_79":-5,"_80":57,"_81":166,"_83":26,"_34":167,"_40":131,"_86":87,"_88":168,"_64":48,"_90":-5,"_91":300,"_70":301},{"_32":155,"_13":153,"_77":156,"_79":-5,"_80":57,"_81":56,"_83":26,"_34":157,"_40":158,"_86":87,"_88":159,"_64":48,"_90":-5,"_91":298,"_70":299},{"_32":146,"_13":144,"_77":147,"_79":-5,"_80":57,"_81":148,"_83":26,"_34":149,"_40":98,"_86":87,"_88":150,"_64":48,"_90":-5,"_91":296,"_70":297},{"_32":137,"_13":135,"_77":138,"_79":-5,"_80":57,"_81":139,"_83":26,"_34":140,"_40":22,"_86":87,"_88":141,"_64":48,"_90":-5,"_91":294,"_70":295},{"_32":252,"_13":253,"_77":254,"_79":-5,"_80":57,"_81":98,"_83":26,"_34":291,"_40":22,"_86":87,"_88":256,"_64":48,"_90":-5,"_91":292,"_70":293},{"_32":127,"_13":125,"_77":128,"_79":-5,"_80":57,"_81":129,"_83":26,"_34":130,"_40":131,"_86":87,"_88":132,"_64":48,"_90":-5,"_91":289,"_70":290},{"_32":76,"_13":71,"_77":78,"_79":-5,"_80":57,"_81":82,"_83":26,"_34":84,"_40":85,"_86":87,"_88":89,"_64":48,"_90":-5,"_91":287,"_70":288},[],[71],[],[125],["D",1775248563410],[],[253],[],[135],[],[144],[],[153],[],[162],[],[102],["D",1775248563410],["D",1789519842404],{"_11":12,"_212":208},{"_11":12,"_206":-5,"_207":208,"_177":178,"_209":210,"_211":48},{"_40":56,"_13":16,"_32":57,"_38":58,"_42":33,"_43":41,"_59":50,"_60":39,"_61":54,"_55":14,"_51":12},"ctx",{"_201":-5,"_233":342,"_343":344,"_345":346,"_347":48,"_348":48,"_349":48,"_350":26,"_351":-5,"_352":-7,"_353":-7,"_354":22,"_355":48,"_356":48,"_357":-5,"_358":48,"_359":48,"_360":48,"_361":-5},"ENV",{"_313":314,"_315":316,"_317":16,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341},"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>

Compare

Mergeaginfer/mainintostevekrouse/main

README.md+1-1

test-substack.ts+67-65

create-draft.ts+107-0

delete-empty-drafts.ts+67-0

explore-editor.ts+145-0

test-create-draft.ts+13-0

test-kernel-substack.ts+115-0