`;\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",[172],"c8ca6dd0-3777-11f1-8296-42b51c65c3df","delete-empty-drafts.ts","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",[179],"a00e0b42-3775-11f1-8837-42b51c65c3df","create-draft.ts","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",[186],"85e033ee-313a-11f1-8639-42dde27851f2","README.md","019d550f-5d25-77ba-8a8d-b2a16bc59b96",9,["D",1775426284897],2,"# Form to Substack\n\nAutomatically detects new Google Form submissions (via a linked Google Sheet), generates a blog post with AI, and pushes it to Substack as a draft.\n\n## Architecture\n\n```mermaid\nflowchart LR\n    A[Google Form] -->|responses saved to| B[Google Sheet\\n unlisted]\n    B -->|poll for new rows| C[Val Town\\nInterval Cron]\n    C -->|generate blog post| D[OpenAI\\nvia Val Town std]\n    C -->|track processed rows| E[SQLite]\n    D -->|create draft| F[Substack\\nvia raw API]\n```\n\n## How It Works\n\n1. **Poll Google Sheet** — An interval val runs on a schedule (e.g. every 15 min). It fetches all rows from the unlisted Google Sheet via the public CSV/JSON export URL (no API key needed for unlisted sheets).\n2. **Deduplicate** — Each row's timestamp (or row number) is tracked in SQLite so we never process the same submission twice.\n3. **Generate Blog Post** — New submissions are sent to OpenAI (via Val Town's `std/openai`) to generate a full blog post (title + HTML body).\n4. **Push to Substack** — The generated post is created as a **draft** on Substack via its internal API (`POST /api/v1/drafts`), authenticated with your `substack.sid` cookie.\n5. **Log & Review** — You review and publish drafts in Substack's UI.\n\n## Setup Instructions\n\n### 1. Set environment variables\n\nIn the val's settings (left sidebar → **Environment Variables**), add these three:\n\n#### `GOOGLE_SHEET_ID`\n\nThe ID from your Google Sheet URL. For example, if the URL is:\n\n```\nhttps://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsTuVwXyZ/edit\n```\n\nthen the ID is `1aBcDeFgHiJkLmNoPqRsTuVwXyZ`.\n\n> ⚠️ The sheet must be set to **\"Anyone with the link can view\"** (unlisted) for the pipeline to read it without Google API credentials.\n\n#### `SUBSTACK_SID`\n\nYour `substack.sid` cookie, which authenticates API requests as you.\n\n1. Log into [substack.com](https://substack.com) in Chrome\n2. Open DevTools: **F12** (or right-click → Inspect)\n3. Go to the **Application** tab → **Cookies** → `https://substack.com`\n4. Find the cookie named **`substack.sid`** and copy its **Value**\n\n> ⚠️ Treat this like a password — it gives full access to your Substack account. It stays valid for months as long as you don't log out.\n\n#### `SUBSTACK_PUB_URL`\n\nYour Substack publication hostname, e.g. `yourname.substack.com` (no `https://`, just the hostname).\n\n### 2. Test Google Sheet connection\n\nRun `test-google-sheet.ts`. You should see your column names and a preview of the first few rows. If it fails, double-check:\n- The sheet ID is correct\n- The sheet sharing is set to \"Anyone with the link\"\n\n### 3. Test Substack connection\n\nRun `test-substack.ts`. This will:\n1. Verify your cookie authenticates successfully (prints your name/email)\n2. Create a test **draft** post on your Substack\n\nIf it succeeds, check your [Substack dashboard drafts](https://substack.com/publish/drafts) — you should see a test draft. You can safely delete it.\n\n### 4. Done — ready to build the pipeline\n\nOnce both test scripts pass, the connections are working and we can build the main cron pipeline.\n\n## Files\n\n- `README.md` — This file\n- `test-google-sheet.ts` — Script to test Google Sheet connectivity\n- `test-substack.ts` — Script to test Substack API connectivity\n- `main.ts` — (TODO) The main interval cron that ties it all together\n\n## Status\n\n- [x] Project plan\n- [ ] Test Google Sheet connection\n- [ ] Test Substack connection\n- [ ] AI blog post generation\n- [ ] Main pipeline cron\n- [ ] Dashboard (optional)",[193],"pulls","branches","forks","envVars",{"_207":209,"_210":161},"connections",{"_207":161,"_208":161},"count","unfilledCount",4,"emptyCount",{"_18":192,"_20":193,"_132":194,"_134":-5,"_135":69,"_136":195,"_138":139,"_22":241,"_66":197,"_142":101,"_144":198,"_146":26,"_147":-5,"_220":242,"_90":243},{"_18":185,"_20":186,"_132":187,"_134":-5,"_135":69,"_136":188,"_138":139,"_22":238,"_66":154,"_142":143,"_144":190,"_146":26,"_147":-5,"_220":239,"_90":240},{"_18":178,"_20":179,"_132":180,"_134":-5,"_135":69,"_136":67,"_138":139,"_22":235,"_66":182,"_142":143,"_144":183,"_146":26,"_147":-5,"_220":236,"_90":237},{"_18":171,"_20":172,"_132":173,"_134":-5,"_135":69,"_136":174,"_138":139,"_22":232,"_66":40,"_142":143,"_144":176,"_146":26,"_147":-5,"_220":233,"_90":234},{"_18":164,"_20":165,"_132":166,"_134":-5,"_135":69,"_136":167,"_138":139,"_22":229,"_66":161,"_142":143,"_144":169,"_146":26,"_147":-5,"_220":230,"_90":231},{"_18":157,"_20":158,"_132":159,"_134":-5,"_135":69,"_136":40,"_138":139,"_22":226,"_66":161,"_142":143,"_144":162,"_146":26,"_147":-5,"_220":227,"_90":228},{"_18":149,"_20":150,"_132":151,"_134":-5,"_135":69,"_136":152,"_138":139,"_22":223,"_66":154,"_142":143,"_144":155,"_146":26,"_147":-5,"_220":224,"_90":225},{"_18":130,"_20":131,"_132":133,"_134":-5,"_135":69,"_136":137,"_138":139,"_22":219,"_66":141,"_142":143,"_144":145,"_146":26,"_147":-5,"_220":221,"_90":222},["D",1775426220545],"children",[],[131],["D",1776110567480],[],[150],["D",1775248563410],[],[158],["D",1776111236230],[],[165],["D",1776111189480],[],[172],["D",1776112303408],[],[179],["D",1776111376095],[],[186],["D",1775426284897],[],[193],["D",1775248563410],["D",1789519842404],{"_16":17,"_88":84},{"_16":17,"_82":-5,"_83":84,"_33":34,"_85":86,"_87":26},{"_66":67,"_20":68,"_18":69,"_70":19,"_71":72,"_73":74,"_75":28,"_76":77,"_78":79,"_80":21,"_81":17},"ctx",{"_59":-5,"_111":282,"_283":284,"_285":286,"_287":26,"_288":26,"_289":26,"_290":139,"_291":-5,"_292":-7,"_293":-7,"_294":161,"_295":26,"_296":26,"_297":-5,"_298":26,"_299":26,"_300":26,"_301":-5},"ENV",{"_253":254,"_255":256,"_257":68,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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>

Search