🚀 Manual N2B Scheduler Test

📋 Instructions:

Make sure you have a post in Notion with Status = \"Scheduled\"
Set the Scheduled Date to a time in the past or very soon
Click the button below to run the scheduler manually

\n \n \n \n

Click the button above to test the scheduler

🧪 N2B Scheduler Test

🔄 Running tests...

\n \n \n \n \n `;\n\n const url = new URL(req.url);\n \n if (url.pathname === '/api/test') {\n return new Response(JSON.stringify(await runTestSuite()), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n return new Response(html, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nasync function runTestSuite() {\n const tests = [];\n \n // Test 1: Environment Variables\n try {\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n const missing = [];\n if (!notionToken) missing.push('NOTION_TOKEN');\n if (!notionDatabaseId) missing.push('NOTION_DATABASE_ID');\n if (!blueskyHandle) missing.push('BLUESKY_HANDLE');\n if (!blueskyAppPassword) missing.push('BLUESKY_APP_PASSWORD');\n\n if (missing.length > 0) {\n tests.push({\n name: 'Environment Variables',\n success: false,\n message: `Missing environment variables: ${missing.join(', ')}`,\n });\n } else {\n // Clean up the handle (remove @ if present)\n const cleanHandle = blueskyHandle.startsWith('@') ? blueskyHandle.slice(1) : blueskyHandle;\n \n tests.push({\n name: 'Environment Variables',\n success: true,\n message: 'All required environment variables are set',\n details: `Handle: ${cleanHandle}\\nDatabase ID: ${notionDatabaseId.substring(0, 8)}...`\n });\n }\n } catch (error) {\n tests.push({\n name: 'Environment Variables',\n success: false,\n message: `Error checking environment variables: ${error.message}`,\n });\n }\n\n // Test 2: Notion Connection\n try {\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (notionToken && notionDatabaseId) {\n const notion = new NotionClient(notionToken, notionDatabaseId);\n const posts = await notion.getScheduledPosts();\n \n tests.push({\n name: 'Notion Connection',\n success: true,\n message: `Successfully connected to Notion database`,\n details: `Found ${posts.length} scheduled posts ready to publish`\n });\n }\n } catch (error) {\n tests.push({\n name: 'Notion Connection',\n success: false,\n message: `Failed to connect to Notion: ${error.message}`,\n details: 'Check your NOTION_TOKEN and NOTION_DATABASE_ID. Make sure the integration has access to the database.'\n });\n }\n\n // Test 3: Bluesky Authentication\n try {\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n \n if (blueskyHandle && blueskyAppPassword) {\n // Clean up the handle (remove @ if present)\n const cleanHandle = blueskyHandle.startsWith('@') ? blueskyHandle.slice(1) : blueskyHandle;\n \n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n await bluesky.authenticate();\n \n tests.push({\n name: 'Bluesky Authentication',\n success: true,\n message: `Successfully authenticated with Bluesky as ${cleanHandle}`,\n });\n }\n } catch (error) {\n tests.push({\n name: 'Bluesky Authentication',\n success: false,\n message: `Failed to authenticate with Bluesky: ${error.message}`,\n details: 'Check your BLUESKY_HANDLE and BLUESKY_APP_PASSWORD. Make sure the app password is correct.'\n });\n }\n\n // Test 4: Database Schema Check\n try {\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n \n if (notionToken && notionDatabaseId) {\n const response = await fetch(`https://api.notion.com/v1/databases/${notionDatabaseId}`, {\n headers: {\n 'Authorization': `Bearer ${notionToken}`,\n 'Notion-Version': '2022-06-28',\n },\n });\n \n if (response.ok) {\n const database = await response.json();\n const properties = database.properties;\n \n const requiredFields = ['Title', 'Text', 'Scheduled Date', 'Status', 'URL'];\n const missingFields = requiredFields.filter(field => !properties[field]);\n \n if (missingFields.length > 0) {\n tests.push({\n name: 'Database Schema',\n success: false,\n message: `Missing required fields: ${missingFields.join(', ')}`,\n details: `Available fields: ${Object.keys(properties).join(', ')}`\n });\n } else {\n tests.push({\n name: 'Database Schema',\n success: true,\n message: 'All required database fields are present',\n details: `Fields: ${Object.keys(properties).join(', ')}`\n });\n }\n } else {\n throw new Error(`HTTP ${response.status}`);\n }\n }\n } catch (error) {\n tests.push({\n name: 'Database Schema',\n success: false,\n message: `Failed to check database schema: ${error.message}`,\n });\n }\n\n return { tests };\n}",[],[243],"files",[152,171,182,191,201,211,221,230,241],"counts",{"_254":31,"_255":124,"_256":31,"_257":258},"pulls","branches","forks","envVars",4,"contents",[261,264,267,270,273,276],{"_107":153,"_100":154,"_155":156,"_157":-5,"_158":141,"_159":160,"_161":162,"_109":262,"_104":31,"_164":165,"_166":-5,"_167":27,"_168":-5,"_103":263},["D",1748142768743],[154],{"_107":202,"_100":203,"_155":204,"_157":-5,"_158":141,"_159":140,"_161":162,"_109":265,"_104":206,"_164":207,"_166":208,"_167":27,"_168":-5,"_103":266},["D",1748290729561],[203],{"_107":212,"_100":213,"_155":214,"_157":-5,"_158":141,"_159":215,"_161":162,"_109":268,"_104":124,"_164":217,"_166":218,"_167":27,"_168":-5,"_103":269},["D",1748143306749],[213],{"_107":222,"_100":223,"_155":224,"_157":-5,"_158":141,"_159":225,"_161":162,"_109":271,"_104":160,"_164":217,"_166":227,"_167":27,"_168":-5,"_103":272},["D",1748143917789],[223],{"_107":231,"_100":232,"_155":233,"_157":-5,"_158":141,"_159":234,"_161":162,"_109":274,"_104":236,"_164":237,"_166":238,"_167":27,"_168":-5,"_103":275},["D",1748155110493],[232],{"_107":242,"_100":243,"_155":244,"_157":-5,"_158":141,"_159":245,"_161":162,"_109":277,"_104":124,"_164":217,"_166":247,"_167":27,"_168":-5,"_103":278},["D",1748143272641],[243],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history",{"_98":99,"_100":101,"_102":42,"_105":285,"_289":290,"_499":31,"_500":27},{"_107":108,"_100":101,"_109":286,"_111":-5,"_112":27,"_113":114,"_115":116,"_117":118,"_12":119,"_120":-5,"_121":27,"_122":-5,"_123":124,"_14":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_21":287,"_138":288,"_149":27},["D",1748141278512],{"_98":99,"_136":137},{"_104":140,"_100":42,"_107":141,"_142":108,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":101,"_148":99},"history",[291,296,304,309,317,325,333,341,346,353,358,363,368,376,384,392,399,407,415,420,427,435,443,448,455,462,468,475,482,492],{"_155":204,"_104":140,"_109":292,"_158":141,"_250":293},["D",1748290729561],[294],{"_107":202,"_158":141,"_155":204,"_100":203,"_166":208,"_164":207,"_104":206,"_157":-5,"_109":292,"_159":140,"_168":-5,"_161":162,"_167":27,"_103":295},[203],{"_155":204,"_104":297,"_109":298,"_158":141,"_250":299},29,["D",1748290696647],[300],{"_107":301,"_158":141,"_155":204,"_100":203,"_166":302,"_164":207,"_104":258,"_157":-5,"_109":298,"_159":297,"_168":-5,"_161":27,"_167":27,"_103":303},"8ee3cdd4-3a6e-11f0-bf6b-9e149126039e","# N2B Scheduler - Notion to Bluesky Auto Poster\n\nAn automated scheduler that reads posts from a Notion database and publishes them to Bluesky at scheduled times.\n\nSee it in action, https://bsky.app/profile/nucky.bsky.social\n\n## Features\n\n- 📅 Schedule Bluesky posts from Notion database\n- 🤖 Automatic posting via cron job (every 15 minutes)\n- 📊 Status tracking (Draft → Scheduled → Posted)\n- 🔗 Stores posted URLs back to Notion\n- 📸 **Media support** - Upload images with your posts (up to 4 images per post)\n\n## Setup\n\n### 1. Notion Database Setup\n\nYour database needs these fields:\n- **Title** (Title field) - Post title/identifier\n- **Text** (Rich Text field) - The post content\n- **Scheduled Date** (Date field with time) - When to post\n- **Status** (Select field) - Options: Draft, Scheduled, Posted\n- **URL** (URL field) - Stores the Bluesky post URL after posting\n- **Media** (Files & media field) - Upload images (JPG, PNG, GIF, WebP) ⚠️ **ADD THIS FIELD**\n\n### 2. Environment Variables\n\nSet these in your Val Town environment:\n- `NOTION_TOKEN` - Your Notion integration token\n- `NOTION_DATABASE_ID` - Your database ID\n- `BLUESKY_HANDLE` - Your Bluesky handle (e.g., user.bsky.social)\n- `BLUESKY_APP_PASSWORD` - Your Bluesky app password\n\n### 3. Notion Integration Permissions\n\nMake sure your Notion integration has access to:\n- Read content\n- Update content\n- Read database structure\n\n## Files\n\n- `/scheduler.ts` - Main cron job that checks and posts\n- `/lib/notion.ts` - Notion API integration\n- `/lib/bluesky.ts` - Bluesky posting functionality\n- `/lib/types.ts` - TypeScript interfaces\n\n## How It Works\n\n1. Cron job runs every 15 minutes\n2. Queries Notion for posts with status \"Scheduled\" and due date/time\n3. Posts to Bluesky\n4. Updates Notion record with \"Posted\" status and Bluesky URL\n\n## Usage\n\n1. Create a new row in your Notion database\n2. Set the Text field with your post content\n3. **Optional**: Upload images to the Media field (supports JPG, PNG, GIF, WebP)\n4. Set the Scheduled Date field with when you want it posted\n5. Set Status to \"Scheduled\"\n6. The cron job will automatically post it at the scheduled time",[203],{"_155":233,"_104":234,"_109":305,"_158":141,"_250":306},["D",1748155110493],[307],{"_107":231,"_158":141,"_155":233,"_100":232,"_166":238,"_164":237,"_104":236,"_157":-5,"_109":305,"_159":234,"_168":-5,"_161":162,"_167":27,"_103":308},[232],{"_155":233,"_104":310,"_109":311,"_158":141,"_250":312},27,["D",1748146023303],[313],{"_107":314,"_158":141,"_155":233,"_100":232,"_166":315,"_164":237,"_104":206,"_157":-5,"_109":311,"_159":310,"_168":-5,"_161":27,"_167":27,"_103":316},"b6dab80e-391d-11f0-872a-9e149126039e","import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * N2B Scheduler - Notion to Bluesky Auto Poster\n * \n * This cron job runs every 15 minutes to check for scheduled posts\n * in Notion and publishes them to Bluesky when their time comes.\n */15 * * * *\nexport default async function() {\n console.log('🚀 N2B Scheduler starting...', new Date().toISOString());\n\n try {\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables. Please set: NOTION_TOKEN, NOTION_DATABASE_ID, BLUESKY_HANDLE, BLUESKY_APP_PASSWORD');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n // Clean up handle - remove @ symbol, spaces, and invisible Unicode characters\n const cleanHandle = blueskyHandle\n .replace(/[^\\w.-]/g, '') // Keep only word chars, dots, and hyphens\n .replace(/^@+/, ''); // Remove any @ symbols at the start\n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n console.log('✅ No posts scheduled for now');\n return;\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky (with media if available)\n const blueskyUrl = await bluesky.createPost(post.text, post.media);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n // Continue with other posts even if one fails\n }\n }\n\n console.log('🎉 N2B Scheduler completed successfully');\n\n } catch (error) {\n console.error('💥 N2B Scheduler failed:', error);\n throw error; // Re-throw to ensure cron job shows as failed\n }\n}",[232],{"_155":204,"_104":318,"_109":319,"_158":141,"_250":320},26,["D",1748143937604],[321],{"_107":322,"_158":141,"_155":204,"_100":203,"_166":323,"_164":207,"_104":177,"_157":-5,"_109":319,"_159":318,"_168":-5,"_161":27,"_167":27,"_103":324},"dbae14d2-3918-11f0-8113-9e149126039e","# N2B Scheduler - Notion to Bluesky Auto Poster\n\nAn automated scheduler that reads posts from a Notion database and publishes them to Bluesky at scheduled times.\n\n## Features\n\n- 📅 Schedule Bluesky posts from Notion database\n- 🤖 Automatic posting via cron job (every 15 minutes)\n- 📊 Status tracking (Draft → Scheduled → Posted)\n- 🔗 Stores posted URLs back to Notion\n- 📸 **Media support** - Upload images with your posts (up to 4 images per post)\n\n## Setup\n\n### 1. Notion Database Setup\n\nYour database needs these fields:\n- **Title** (Title field) - Post title/identifier\n- **Text** (Rich Text field) - The post content\n- **Scheduled Date** (Date field with time) - When to post\n- **Status** (Select field) - Options: Draft, Scheduled, Posted\n- **URL** (URL field) - Stores the Bluesky post URL after posting\n- **Media** (Files & media field) - Upload images (JPG, PNG, GIF, WebP) ⚠️ **ADD THIS FIELD**\n\n### 2. Environment Variables\n\nSet these in your Val Town environment:\n- `NOTION_TOKEN` - Your Notion integration token\n- `NOTION_DATABASE_ID` - Your database ID\n- `BLUESKY_HANDLE` - Your Bluesky handle (e.g., user.bsky.social)\n- `BLUESKY_APP_PASSWORD` - Your Bluesky app password\n\n### 3. Notion Integration Permissions\n\nMake sure your Notion integration has access to:\n- Read content\n- Update content\n- Read database structure\n\n## Files\n\n- `/scheduler.ts` - Main cron job that checks and posts\n- `/lib/notion.ts` - Notion API integration\n- `/lib/bluesky.ts` - Bluesky posting functionality\n- `/lib/types.ts` - TypeScript interfaces\n\n## How It Works\n\n1. Cron job runs every 15 minutes\n2. Queries Notion for posts with status \"Scheduled\" and due date/time\n3. Posts to Bluesky\n4. Updates Notion record with \"Posted\" status and Bluesky URL\n\n## Usage\n\n1. Create a new row in your Notion database\n2. Set the Text field with your post content\n3. **Optional**: Upload images to the Media field (supports JPG, PNG, GIF, WebP)\n4. Set the Scheduled Date field with when you want it posted\n5. Set Status to \"Scheduled\"\n6. The cron job will automatically post it at the scheduled time",[203],{"_155":204,"_104":326,"_109":327,"_158":141,"_250":328},25,["D",1748143933029],[329],{"_107":330,"_158":141,"_155":204,"_100":203,"_166":331,"_164":207,"_104":160,"_157":-5,"_109":327,"_159":326,"_168":-5,"_161":27,"_167":27,"_103":332},"d8f3f02c-3918-11f0-8d36-9e149126039e","# N2B Scheduler - Notion to Bluesky Auto Poster\n\nAn automated scheduler that reads posts from a Notion database and publishes them to Bluesky at scheduled times.\n\n## Features\n\n- 📅 Schedule Bluesky posts from Notion database\n- 🤖 Automatic posting via cron job (every 15 minutes)\n- 📊 Status tracking (Draft → Scheduled → Posted)\n- 🔗 Stores posted URLs back to Notion\n- 📸 **Media support** - Upload images with your posts (up to 4 images per post)\n\n## Setup\n\n### 1. Notion Database Setup\n\nYour database needs these fields:\n- **Title** (Title field) - Post title/identifier\n- **Text** (Rich Text field) - The post content\n- **Scheduled Date** (Date field with time) - When to post\n- **Status** (Select field) - Options: Draft, Scheduled, Posted\n- **URL** (URL field) - Stores the Bluesky post URL after posting\n- **Media** (Files & media field) - Upload images (JPG, PNG, GIF, WebP) ⚠️ **ADD THIS FIELD**\n\n### 2. Environment Variables\n\nSet these in your Val Town environment:\n- `NOTION_TOKEN` - Your Notion integration token\n- `NOTION_DATABASE_ID` - Your database ID\n- `BLUESKY_HANDLE` - Your Bluesky handle (e.g., user.bsky.social)\n- `BLUESKY_APP_PASSWORD` - Your Bluesky app password\n\n### 3. Notion Integration Permissions\n\nMake sure your Notion integration has access to:\n- Read content\n- Update content\n- Read database structure\n\n## Files\n\n- `/scheduler.ts` - Main cron job that checks and posts\n- `/lib/notion.ts` - Notion API integration\n- `/lib/bluesky.ts` - Bluesky posting functionality\n- `/lib/types.ts` - TypeScript interfaces\n\n## How It Works\n\n1. Cron job runs every 15 minutes\n2. Queries Notion for posts with status \"Scheduled\" and due date/time\n3. Posts to Bluesky\n4. Updates Notion record with \"Posted\" status and Bluesky URL\n\n## Usage\n\n1. Create a new row in your Notion database\n2. Set the Text field with your post content\n3. Set the Scheduled Date field with when you want it posted\n4. Set Status to \"Scheduled\"\n5. The cron job will automatically post it at the scheduled time",[203],{"_155":204,"_104":334,"_109":335,"_158":141,"_250":336},24,["D",1748143925650],[337],{"_107":338,"_158":141,"_155":204,"_100":203,"_166":339,"_164":207,"_104":124,"_157":-5,"_109":335,"_159":334,"_168":-5,"_161":27,"_167":27,"_103":340},"d48e04e6-3918-11f0-8b6f-9e149126039e","# N2B Scheduler - Notion to Bluesky Auto Poster\n\nAn automated scheduler that reads posts from a Notion database and publishes them to Bluesky at scheduled times.\n\n## Features\n\n- 📅 Schedule Bluesky posts from Notion database\n- 🤖 Automatic posting via cron job (every 15 minutes)\n- 📊 Status tracking (Draft → Scheduled → Posted)\n- 🔗 Stores posted URLs back to Notion\n\n## Setup\n\n### 1. Notion Database Setup\n\nYour database needs these fields:\n- **Title** (Title field) - Post title/identifier\n- **Text** (Rich Text field) - The post content\n- **Scheduled Date** (Date field with time) - When to post\n- **Status** (Select field) - Options: Draft, Scheduled, Posted\n- **URL** (URL field) - Stores the Bluesky post URL after posting\n- **Media** (Files & media field) - Upload images (JPG, PNG, GIF, WebP) ⚠️ **ADD THIS FIELD**\n\n### 2. Environment Variables\n\nSet these in your Val Town environment:\n- `NOTION_TOKEN` - Your Notion integration token\n- `NOTION_DATABASE_ID` - Your database ID\n- `BLUESKY_HANDLE` - Your Bluesky handle (e.g., user.bsky.social)\n- `BLUESKY_APP_PASSWORD` - Your Bluesky app password\n\n### 3. Notion Integration Permissions\n\nMake sure your Notion integration has access to:\n- Read content\n- Update content\n- Read database structure\n\n## Files\n\n- `/scheduler.ts` - Main cron job that checks and posts\n- `/lib/notion.ts` - Notion API integration\n- `/lib/bluesky.ts` - Bluesky posting functionality\n- `/lib/types.ts` - TypeScript interfaces\n\n## How It Works\n\n1. Cron job runs every 15 minutes\n2. Queries Notion for posts with status \"Scheduled\" and due date/time\n3. Posts to Bluesky\n4. Updates Notion record with \"Posted\" status and Bluesky URL\n\n## Usage\n\n1. Create a new row in your Notion database\n2. Set the Text field with your post content\n3. Set the Scheduled Date field with when you want it posted\n4. Set Status to \"Scheduled\"\n5. The cron job will automatically post it at the scheduled time",[203],{"_155":224,"_104":225,"_109":342,"_158":141,"_250":343},["D",1748143917789],[344],{"_107":222,"_158":141,"_155":224,"_100":223,"_166":227,"_164":217,"_104":160,"_157":-5,"_109":342,"_159":225,"_168":-5,"_161":162,"_167":27,"_103":345},[223],{"_155":233,"_104":347,"_109":348,"_158":141,"_250":349},22,["D",1748143913753],[350],{"_107":351,"_158":141,"_155":233,"_100":232,"_166":238,"_164":237,"_104":258,"_157":-5,"_109":348,"_159":347,"_168":-5,"_161":27,"_167":27,"_103":352},"cd76e3bc-3918-11f0-8425-9e149126039e",[232],{"_155":174,"_104":175,"_109":354,"_158":141,"_250":355},["D",1748143908846],[356],{"_107":172,"_158":141,"_155":174,"_100":173,"_166":179,"_164":178,"_104":177,"_157":156,"_109":354,"_159":175,"_168":-5,"_161":162,"_167":27,"_103":357},[154,173],{"_155":185,"_104":186,"_109":359,"_158":141,"_250":360},["D",1748143891528],[361],{"_107":183,"_158":141,"_155":185,"_100":184,"_166":188,"_164":178,"_104":124,"_157":156,"_109":359,"_159":186,"_168":-5,"_161":162,"_167":27,"_103":362},[154,184],{"_155":194,"_104":195,"_109":364,"_158":141,"_250":365},["D",1748143884742],[366],{"_107":192,"_158":141,"_155":194,"_100":193,"_166":197,"_164":178,"_104":177,"_157":156,"_109":364,"_159":195,"_168":-5,"_161":162,"_167":27,"_103":367},[154,193],{"_155":194,"_104":369,"_109":370,"_158":141,"_250":371},18,["D",1748143880397],[372],{"_107":373,"_158":141,"_155":194,"_100":193,"_166":374,"_164":178,"_104":160,"_157":156,"_109":370,"_159":369,"_168":-5,"_161":27,"_167":27,"_103":375},"b994fdde-3918-11f0-80fa-9e149126039e","// Shared types for the N2B Scheduler\n\nexport interface NotionPost {\n id: string;\n title: string;\n text: string;\n scheduledDate: string;\n status: 'Draft' | 'Scheduled' | 'Posted';\n url?: string;\n media?: string[]; // Array of image URLs\n}\n\nexport interface BlueskyPost {\n text: string;\n createdAt: string;\n embed?: {\n $type: 'app.bsky.embed.images';\n images: Array<{\n alt: string;\n image: {\n $type: 'blob';\n ref: {\n $link: string;\n };\n mimeType: string;\n size: number;\n };\n }>;\n };\n}\n\nexport interface BlueskyResponse {\n uri: string;\n cid: string;\n}\n\nexport interface NotionDatabaseResponse {\n results: Array<{\n id: string;\n properties: {\n Title: {\n title: Array<{\n plain_text: string;\n }>;\n };\n Text: {\n rich_text: Array<{\n plain_text: string;\n }>;\n };\n 'Scheduled Date': {\n date: {\n start: string;\n } | null;\n };\n Status: {\n select: {\n name: string;\n } | null;\n };\n URL: {\n url: string | null;\n };\n };\n }>;\n}",[154,193],{"_155":194,"_104":377,"_109":378,"_158":141,"_250":379},17,["D",1748143875074],[380],{"_107":381,"_158":141,"_155":194,"_100":193,"_166":382,"_164":178,"_104":124,"_157":156,"_109":378,"_159":377,"_168":-5,"_161":27,"_167":27,"_103":383},"b668e0e4-3918-11f0-935e-9e149126039e","// Shared types for the N2B Scheduler\n\nexport interface NotionPost {\n id: string;\n title: string;\n text: string;\n scheduledDate: string;\n status: 'Draft' | 'Scheduled' | 'Posted';\n url?: string;\n media?: string[]; // Array of image URLs\n}\n\nexport interface BlueskyPost {\n text: string;\n createdAt: string;\n}\n\nexport interface BlueskyResponse {\n uri: string;\n cid: string;\n}\n\nexport interface NotionDatabaseResponse {\n results: Array<{\n id: string;\n properties: {\n Title: {\n title: Array<{\n plain_text: string;\n }>;\n };\n Text: {\n rich_text: Array<{\n plain_text: string;\n }>;\n };\n 'Scheduled Date': {\n date: {\n start: string;\n } | null;\n };\n Status: {\n select: {\n name: string;\n } | null;\n };\n URL: {\n url: string | null;\n };\n };\n }>;\n}",[154,193],{"_155":224,"_104":385,"_109":386,"_158":141,"_250":387},16,["D",1748143403628],[388],{"_107":389,"_158":141,"_155":224,"_100":223,"_166":390,"_164":217,"_104":124,"_157":-5,"_109":386,"_159":385,"_168":-5,"_161":27,"_167":27,"_103":391},"9d682114-3917-11f0-bf69-9e149126039e","import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * Manual test to run the scheduler logic once\n * This simulates what the cron job does\n */\nexport default async function(req: Request) {\n const html = `\n \n \n \n Manual N2B Test\n \n \n \n

🚀 Manual N2B Scheduler Test

📋 Instructions:

Make sure you have a post in Notion with Status = \"Scheduled\"
Set the Scheduled Date to a time in the past or very soon
Click the button below to run the scheduler manually

\n \n \n \n

Click the button above to test the scheduler

\n \n \n \n \n `;\n\n const url = new URL(req.url);\n \n if (url.pathname === '/api/run') {\n return new Response(JSON.stringify(await runSchedulerTest()), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n \n return new Response(html, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nasync function runSchedulerTest() {\n try {\n console.log('🚀 Manual N2B Scheduler test starting...', new Date().toISOString());\n\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n const cleanHandle = blueskyHandle\n .replace(/[^\\w.-]/g, '')\n .replace(/^@+/, '');\n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n return {\n success: true,\n message: 'No posts scheduled for now',\n details: 'Make sure you have a post with Status=\"Scheduled\" and Scheduled Date in the past or very soon'\n };\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n \n const results = [];\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky\n const blueskyUrl = await bluesky.createPost(post.text);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n results.push({\n title: post.title,\n success: true,\n blueskyUrl: blueskyUrl\n });\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n results.push({\n title: post.title,\n success: false,\n error: error.message\n });\n }\n }\n\n const successCount = results.filter(r => r.success).length;\n const failCount = results.filter(r => !r.success).length;\n\n return {\n success: failCount === 0,\n message: `Processed ${results.length} post(s): ${successCount} successful, ${failCount} failed`,\n details: JSON.stringify(results, null, 2)\n };\n\n } catch (error) {\n console.error('💥 Manual scheduler test failed:', error);\n return {\n success: false,\n message: error.message,\n details: error.stack\n };\n }\n}",[223],{"_155":224,"_104":393,"_109":394,"_158":141,"_250":395},15,["D",1748143400145],[396],{"_107":397,"_158":141,"_155":224,"_100":223,"_166":390,"_164":178,"_104":31,"_157":-5,"_109":394,"_159":393,"_168":-5,"_161":27,"_167":27,"_103":398},"9b54678e-3917-11f0-ac85-9e149126039e",[223],{"_155":233,"_104":400,"_109":401,"_158":141,"_250":402},14,["D",1748143324642],[403],{"_107":404,"_158":141,"_155":233,"_100":232,"_166":405,"_164":237,"_104":177,"_157":-5,"_109":401,"_159":400,"_168":-5,"_161":27,"_167":27,"_103":406},"6e538594-3917-11f0-9f10-9e149126039e","import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * N2B Scheduler - Notion to Bluesky Auto Poster\n * \n * This cron job runs every 15 minutes to check for scheduled posts\n * in Notion and publishes them to Bluesky when their time comes.\n */\nexport default async function() {\n console.log('🚀 N2B Scheduler starting...', new Date().toISOString());\n\n try {\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables. Please set: NOTION_TOKEN, NOTION_DATABASE_ID, BLUESKY_HANDLE, BLUESKY_APP_PASSWORD');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n // Clean up handle - remove @ symbol, spaces, and invisible Unicode characters\n const cleanHandle = blueskyHandle\n .replace(/[^\\w.-]/g, '') // Keep only word chars, dots, and hyphens\n .replace(/^@+/, ''); // Remove any @ symbols at the start\n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n console.log('✅ No posts scheduled for now');\n return;\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky\n const blueskyUrl = await bluesky.createPost(post.text);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n // Continue with other posts even if one fails\n }\n }\n\n console.log('🎉 N2B Scheduler completed successfully');\n\n } catch (error) {\n console.error('💥 N2B Scheduler failed:', error);\n throw error; // Re-throw to ensure cron job shows as failed\n }\n}",[232],{"_155":174,"_104":408,"_109":409,"_158":141,"_250":410},13,["D",1748143318630],[411],{"_107":412,"_158":141,"_155":174,"_100":173,"_166":413,"_164":178,"_104":160,"_157":156,"_109":409,"_159":408,"_168":-5,"_161":27,"_167":27,"_103":414},"6abe8212-3917-11f0-a639-9e149126039e","import type { BlueskyPost, BlueskyResponse } from './types.ts';\n\nexport class BlueskyClient {\n private handle: string;\n private appPassword: string;\n private accessJwt?: string;\n\n constructor(handle: string, appPassword: string) {\n // Clean up handle - remove @ symbol, spaces, and invisible Unicode characters\n this.handle = handle\n .replace(/[^\\w.-]/g, '') // Keep only word chars, dots, and hyphens\n .replace(/^@+/, ''); // Remove any @ symbols at the start\n this.appPassword = appPassword;\n }\n\n async authenticate(): Promise {\n const response = await fetch('https://bsky.social/xrpc/com.atproto.server.createSession', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n identifier: this.handle,\n password: this.appPassword,\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Bluesky auth failed: ${response.status} ${error}`);\n }\n\n const data = await response.json();\n this.accessJwt = data.accessJwt;\n }\n\n async createPost(text: string): Promise {\n if (!this.accessJwt) {\n await this.authenticate();\n }\n\n const post: BlueskyPost = {\n text: text,\n createdAt: new Date().toISOString(),\n };\n\n const record = {\n repo: this.handle,\n collection: 'app.bsky.feed.post',\n record: {\n $type: 'app.bsky.feed.post',\n ...post,\n },\n };\n\n const response = await fetch('https://bsky.social/xrpc/com.atproto.repo.createRecord', {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${this.accessJwt}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(record),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Bluesky post failed: ${response.status} ${error}`);\n }\n\n const result: BlueskyResponse = await response.json();\n \n // Convert AT Protocol URI to web URL\n const postId = result.uri.split('/').pop();\n const userHandle = this.handle;\n return `https://bsky.app/profile/${userHandle}/post/${postId}`;\n }\n}",[154,173],{"_155":214,"_104":215,"_109":416,"_158":141,"_250":417},["D",1748143306749],[418],{"_107":212,"_158":141,"_155":214,"_100":213,"_166":218,"_164":217,"_104":124,"_157":-5,"_109":416,"_159":215,"_168":-5,"_161":162,"_167":27,"_103":419},[213],{"_155":214,"_104":421,"_109":422,"_158":141,"_250":423},11,["D",1748143302332],[424],{"_107":425,"_158":141,"_155":214,"_100":213,"_166":218,"_164":178,"_104":31,"_157":-5,"_109":422,"_159":421,"_168":-5,"_161":27,"_167":27,"_103":426},"61072058-3917-11f0-ab8f-9e149126039e",[213],{"_155":233,"_104":428,"_109":429,"_158":141,"_250":430},10,["D",1748143282742],[431],{"_107":432,"_158":141,"_155":233,"_100":232,"_166":433,"_164":237,"_104":160,"_157":-5,"_109":429,"_159":428,"_168":-5,"_161":27,"_167":27,"_103":434},"555aac34-3917-11f0-b3ab-9e149126039e","import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * N2B Scheduler - Notion to Bluesky Auto Poster\n * \n * This cron job runs every 15 minutes to check for scheduled posts\n * in Notion and publishes them to Bluesky when their time comes.\n */\nexport default async function() {\n console.log('🚀 N2B Scheduler starting...', new Date().toISOString());\n\n try {\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables. Please set: NOTION_TOKEN, NOTION_DATABASE_ID, BLUESKY_HANDLE, BLUESKY_APP_PASSWORD');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n // Clean up handle - remove @ if present\n const cleanHandle = blueskyHandle.startsWith('@') ? blueskyHandle.slice(1) : blueskyHandle;\n const bluesky = new BlueskyClient(cleanHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n console.log('✅ No posts scheduled for now');\n return;\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky\n const blueskyUrl = await bluesky.createPost(post.text);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n // Continue with other posts even if one fails\n }\n }\n\n console.log('🎉 N2B Scheduler completed successfully');\n\n } catch (error) {\n console.error('💥 N2B Scheduler failed:', error);\n throw error; // Re-throw to ensure cron job shows as failed\n }\n}",[232],{"_155":174,"_104":436,"_109":437,"_158":141,"_250":438},9,["D",1748143278031],[439],{"_107":440,"_158":141,"_155":174,"_100":173,"_166":441,"_164":178,"_104":124,"_157":156,"_109":437,"_159":436,"_168":-5,"_161":27,"_167":27,"_103":442},"528b3654-3917-11f0-853e-9e149126039e","import type { BlueskyPost, BlueskyResponse } from './types.ts';\n\nexport class BlueskyClient {\n private handle: string;\n private appPassword: string;\n private accessJwt?: string;\n\n constructor(handle: string, appPassword: string) {\n // Clean up handle - remove @ if present\n this.handle = handle.startsWith('@') ? handle.slice(1) : handle;\n this.appPassword = appPassword;\n }\n\n async authenticate(): Promise {\n const response = await fetch('https://bsky.social/xrpc/com.atproto.server.createSession', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n identifier: this.handle,\n password: this.appPassword,\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Bluesky auth failed: ${response.status} ${error}`);\n }\n\n const data = await response.json();\n this.accessJwt = data.accessJwt;\n }\n\n async createPost(text: string): Promise {\n if (!this.accessJwt) {\n await this.authenticate();\n }\n\n const post: BlueskyPost = {\n text: text,\n createdAt: new Date().toISOString(),\n };\n\n const record = {\n repo: this.handle,\n collection: 'app.bsky.feed.post',\n record: {\n $type: 'app.bsky.feed.post',\n ...post,\n },\n };\n\n const response = await fetch('https://bsky.social/xrpc/com.atproto.repo.createRecord', {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${this.accessJwt}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(record),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Bluesky post failed: ${response.status} ${error}`);\n }\n\n const result: BlueskyResponse = await response.json();\n \n // Convert AT Protocol URI to web URL\n const postId = result.uri.split('/').pop();\n const userHandle = this.handle;\n return `https://bsky.app/profile/${userHandle}/post/${postId}`;\n }\n}",[154,173],{"_155":244,"_104":245,"_109":444,"_158":141,"_250":445},["D",1748143272641],[446],{"_107":242,"_158":141,"_155":244,"_100":243,"_166":247,"_164":217,"_104":124,"_157":-5,"_109":444,"_159":245,"_168":-5,"_161":162,"_167":27,"_103":447},[243],{"_155":244,"_104":449,"_109":450,"_158":141,"_250":451},7,["D",1748143269832],[452],{"_107":453,"_158":141,"_155":244,"_100":243,"_166":247,"_164":178,"_104":31,"_157":-5,"_109":450,"_159":449,"_168":-5,"_161":27,"_167":27,"_103":454},"4da7e2cc-3917-11f0-a2ae-9e149126039e",[243],{"_155":233,"_104":236,"_109":456,"_158":141,"_250":457},["D",1748142806645],[458],{"_107":459,"_158":141,"_155":233,"_100":232,"_166":460,"_164":237,"_104":124,"_157":-5,"_109":456,"_159":236,"_168":-5,"_161":27,"_167":27,"_103":461},"39941aa4-3916-11f0-b4a7-9e149126039e","import { NotionClient } from './lib/notion.ts';\nimport { BlueskyClient } from './lib/bluesky.ts';\n\n/**\n * N2B Scheduler - Notion to Bluesky Auto Poster\n * \n * This cron job runs every 15 minutes to check for scheduled posts\n * in Notion and publishes them to Bluesky when their time comes.\n */\nexport default async function() {\n console.log('🚀 N2B Scheduler starting...', new Date().toISOString());\n\n try {\n // Get environment variables\n const notionToken = Deno.env.get('NOTION_TOKEN');\n const notionDatabaseId = Deno.env.get('NOTION_DATABASE_ID');\n const blueskyHandle = Deno.env.get('BLUESKY_HANDLE');\n const blueskyAppPassword = Deno.env.get('BLUESKY_APP_PASSWORD');\n\n if (!notionToken || !notionDatabaseId || !blueskyHandle || !blueskyAppPassword) {\n throw new Error('Missing required environment variables. Please set: NOTION_TOKEN, NOTION_DATABASE_ID, BLUESKY_HANDLE, BLUESKY_APP_PASSWORD');\n }\n\n // Initialize clients\n const notion = new NotionClient(notionToken, notionDatabaseId);\n const bluesky = new BlueskyClient(blueskyHandle, blueskyAppPassword);\n\n // Get posts that are scheduled and due\n console.log('📋 Checking for scheduled posts...');\n const scheduledPosts = await notion.getScheduledPosts();\n \n if (scheduledPosts.length === 0) {\n console.log('✅ No posts scheduled for now');\n return;\n }\n\n console.log(`📝 Found ${scheduledPosts.length} post(s) ready to publish`);\n\n // Process each post\n for (const post of scheduledPosts) {\n try {\n console.log(`📤 Publishing: \"${post.title}\" (${post.text.substring(0, 50)}...)`);\n \n // Post to Bluesky\n const blueskyUrl = await bluesky.createPost(post.text);\n console.log(`✅ Posted to Bluesky: ${blueskyUrl}`);\n \n // Update Notion with success\n await notion.updatePostStatus(post.id, 'Posted', blueskyUrl);\n console.log(`📝 Updated Notion status to Posted`);\n \n } catch (error) {\n console.error(`❌ Failed to publish post \"${post.title}\":`, error);\n // Continue with other posts even if one fails\n }\n }\n\n console.log('🎉 N2B Scheduler completed successfully');\n\n } catch (error) {\n console.error('💥 N2B Scheduler failed:', error);\n throw error; // Re-throw to ensure cron job shows as failed\n }\n}",[232],{"_155":233,"_104":206,"_109":463,"_158":141,"_250":464},["D",1748142803552],[465],{"_107":466,"_158":141,"_155":233,"_100":232,"_166":460,"_164":178,"_104":31,"_157":-5,"_109":463,"_159":206,"_168":-5,"_161":27,"_167":27,"_103":467},"37bb4450-3916-11f0-a786-9e149126039e",[232],{"_155":174,"_104":258,"_109":469,"_158":141,"_250":470},["D",1748142790979],[471],{"_107":472,"_158":141,"_155":174,"_100":173,"_166":473,"_164":178,"_104":31,"_157":156,"_109":469,"_159":258,"_168":-5,"_161":27,"_167":27,"_103":474},"303ccf6e-3916-11f0-b36e-9e149126039e","import type { BlueskyPost, BlueskyResponse } from './types.ts';\n\nexport class BlueskyClient {\n private handle: string;\n private appPassword: string;\n private accessJwt?: string;\n\n constructor(handle: string, appPassword: string) {\n this.handle = handle;\n this.appPassword = appPassword;\n }\n\n async authenticate(): Promise {\n const response = await fetch('https://bsky.social/xrpc/com.atproto.server.createSession', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n identifier: this.handle,\n password: this.appPassword,\n }),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Bluesky auth failed: ${response.status} ${error}`);\n }\n\n const data = await response.json();\n this.accessJwt = data.accessJwt;\n }\n\n async createPost(text: string): Promise {\n if (!this.accessJwt) {\n await this.authenticate();\n }\n\n const post: BlueskyPost = {\n text: text,\n createdAt: new Date().toISOString(),\n };\n\n const record = {\n repo: this.handle,\n collection: 'app.bsky.feed.post',\n record: {\n $type: 'app.bsky.feed.post',\n ...post,\n },\n };\n\n const response = await fetch('https://bsky.social/xrpc/com.atproto.repo.createRecord', {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${this.accessJwt}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(record),\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Bluesky post failed: ${response.status} ${error}`);\n }\n\n const result: BlueskyResponse = await response.json();\n \n // Convert AT Protocol URI to web URL\n const postId = result.uri.split('/').pop();\n const userHandle = this.handle;\n return `https://bsky.app/profile/${userHandle}/post/${postId}`;\n }\n}",[154,173],{"_155":185,"_104":177,"_109":476,"_158":141,"_250":477},["D",1748142780151],[478],{"_107":479,"_158":141,"_155":185,"_100":184,"_166":480,"_164":178,"_104":31,"_157":156,"_109":476,"_159":177,"_168":-5,"_161":27,"_167":27,"_103":481},"29cbff1a-3916-11f0-89aa-9e149126039e","import type { NotionPost, NotionDatabaseResponse } from './types.ts';\n\nconst NOTION_API_BASE = 'https://api.notion.com/v1';\n\nexport class NotionClient {\n private token: string;\n private databaseId: string;\n\n constructor(token: string, databaseId: string) {\n this.token = token;\n this.databaseId = databaseId;\n }\n\n private async makeRequest(endpoint: string, options: RequestInit = {}) {\n const response = await fetch(`${NOTION_API_BASE}${endpoint}`, {\n ...options,\n headers: {\n 'Authorization': `Bearer ${this.token}`,\n 'Notion-Version': '2022-06-28',\n 'Content-Type': 'application/json',\n ...options.headers,\n },\n });\n\n if (!response.ok) {\n const error = await response.text();\n throw new Error(`Notion API error: ${response.status} ${error}`);\n }\n\n return response.json();\n }\n\n async getScheduledPosts(): Promise {\n const now = new Date().toISOString();\n \n const query = {\n filter: {\n and: [\n {\n property: 'Status',\n select: {\n equals: 'Scheduled'\n }\n },\n {\n property: 'Scheduled Date',\n date: {\n on_or_before: now\n }\n }\n ]\n }\n };\n\n const response: NotionDatabaseResponse = await this.makeRequest(\n `/databases/${this.databaseId}/query`,\n {\n method: 'POST',\n body: JSON.stringify(query),\n }\n );\n\n return response.results.map(this.parseNotionPage);\n }\n\n async updatePostStatus(pageId: string, status: 'Posted', url?: string): Promise {\n const updateData: any = {\n properties: {\n Status: {\n select: {\n name: status\n }\n }\n }\n };\n\n if (url) {\n updateData.properties.URL = {\n url: url\n };\n }\n\n await this.makeRequest(`/pages/${pageId}`, {\n method: 'PATCH',\n body: JSON.stringify(updateData),\n });\n }\n\n private parseNotionPage(page: NotionDatabaseResponse['results'][0]): NotionPost {\n const props = page.properties;\n \n return {\n id: page.id,\n title: props.Title?.title?.[0]?.plain_text || '',\n text: props.Text?.rich_text?.map(rt => rt.plain_text).join('') || '',\n scheduledDate: props['Scheduled Date']?.date?.start || '',\n status: (props.Status?.select?.name as any) || 'Draft',\n url: props.URL?.url || undefined,\n };\n }\n}",[154,184],{"_155":194,"_104":160,"_109":483,"_158":141,"_250":484},["D",1748142768743],[485,489],{"_107":486,"_158":141,"_155":194,"_100":193,"_166":487,"_164":178,"_104":31,"_157":156,"_109":483,"_159":160,"_168":-5,"_161":27,"_167":27,"_103":488},"22fc1468-3916-11f0-9782-9e149126039e","// Shared types for the N2B Scheduler\n\nexport interface NotionPost {\n id: string;\n title: string;\n text: string;\n scheduledDate: string;\n status: 'Draft' | 'Scheduled' | 'Posted';\n url?: string;\n}\n\nexport interface BlueskyPost {\n text: string;\n createdAt: string;\n}\n\nexport interface BlueskyResponse {\n uri: string;\n cid: string;\n}\n\nexport interface NotionDatabaseResponse {\n results: Array<{\n id: string;\n properties: {\n Title: {\n title: Array<{\n plain_text: string;\n }>;\n };\n Text: {\n rich_text: Array<{\n plain_text: string;\n }>;\n };\n 'Scheduled Date': {\n date: {\n start: string;\n } | null;\n };\n Status: {\n select: {\n name: string;\n } | null;\n };\n URL: {\n url: string | null;\n };\n };\n }>;\n}",[154,193],{"_107":153,"_158":141,"_155":156,"_100":154,"_166":-5,"_164":165,"_104":31,"_157":-5,"_109":490,"_159":160,"_168":-5,"_161":162,"_167":27,"_103":491},["D",1748142768743],[154],{"_155":204,"_104":124,"_109":493,"_158":141,"_250":494},["D",1748142762729],[495],{"_107":496,"_158":141,"_155":204,"_100":203,"_166":497,"_164":207,"_104":31,"_157":-5,"_109":493,"_159":124,"_168":-5,"_161":27,"_167":27,"_103":498},"1f66805e-3916-11f0-aa03-9e149126039e","# N2B Scheduler - Notion to Bluesky Auto Poster\n\nAn automated scheduler that reads posts from a Notion database and publishes them to Bluesky at scheduled times.\n\n## Features\n\n- 📅 Schedule Bluesky posts from Notion database\n- 🤖 Automatic posting via cron job (every 15 minutes)\n- 📊 Status tracking (Draft → Scheduled → Posted)\n- 🔗 Stores posted URLs back to Notion\n\n## Setup\n\n### 1. Notion Database Setup\n\nYour database needs these fields:\n- **Title** (Title field) - Post title/identifier\n- **Text** (Rich Text field) - The post content\n- **Scheduled Date** (Date field with time) - When to post ⚠️ **ADD THIS FIELD**\n- **Status** (Select field) - Options: Draft, Scheduled, Posted\n- **URL** (URL field) - Stores the Bluesky post URL after posting\n\n### 2. Environment Variables\n\nSet these in your Val Town environment:\n- `NOTION_TOKEN` - Your Notion integration token\n- `NOTION_DATABASE_ID` - Your database ID\n- `BLUESKY_HANDLE` - Your Bluesky handle (e.g., user.bsky.social)\n- `BLUESKY_APP_PASSWORD` - Your Bluesky app password\n\n### 3. Notion Integration Permissions\n\nMake sure your Notion integration has access to:\n- Read content\n- Update content\n- Read database structure\n\n## Files\n\n- `/scheduler.ts` - Main cron job that checks and posts\n- `/lib/notion.ts` - Notion API integration\n- `/lib/bluesky.ts` - Bluesky posting functionality\n- `/lib/types.ts` - TypeScript interfaces\n\n## How It Works\n\n1. Cron job runs every 15 minutes\n2. Queries Notion for posts with status \"Scheduled\" and due date/time\n3. Posts to Bluesky\n4. Updates Notion record with \"Posted\" status and Bluesky URL\n\n## Usage\n\n1. Create a new row in your Notion database\n2. Set the Text field with your post content\n3. Set the Scheduled Date field with when you want it posted\n4. Set Status to \"Scheduled\"\n5. The cron job will automatically post it at the scheduled time",[203],"page","hasNext","routes/_app","actionData","errors"]

History