\n \n

🤖 Social Media Content Creator Bot

AI-powered content generation and automated posting

\n\n \n

Total Posts

Successful

Failed

This Week

\n\n \n

\n \n

🎯 Generate Content

\n \n

\n Content Type\n \n

\n \n

\n Topic (optional)\n \n

\n \n

\n Platform\n \n

\n \n \n

\n\n \n

⚡ Quick Actions

\n \n

\n \n \n \n \n \n

\n\n

🔧 Setup Required

\n Add your API keys as environment variables:\n
• OPENAI_API_KEY\n
• TWITTER_API_KEY, TWITTER_API_SECRET\n
• LINKEDIN_ACCESS_TOKEN\n

\n\n \n

📝 Generated Content

\n \n

\n \n \n

\n\n \n

📋 Recent Posts

\n \n

\n\n \n \n

\n\n \n\n",[],[224,231],[224],{"_106":240,"_98":241,"_150":242,"_152":-5,"_153":137,"_154":243,"_156":157,"_108":244,"_103":31,"_159":160,"_161":-5,"_162":27,"_163":-5,"_164":245,"_101":254},"1a24ab3e-3943-11f0-8d1a-9e149126039e","shared","9dc345b4-4b3c-4106-be9f-228b84275cdb",2,["D",1748162081261],[246],{"_106":247,"_98":248,"_150":249,"_152":242,"_153":137,"_154":243,"_156":157,"_108":250,"_103":31,"_159":172,"_161":251,"_162":27,"_163":-5,"_164":252,"_101":253},"1a248cee-3943-11f0-8d1a-9e149126039e","types.ts","1a248dca-3943-11f0-8d1a-9e149126039e",["D",1748162081261],"// Shared types for the social media bot\n\nexport interface ContentPost {\n id: string;\n content: string;\n hashtags: string[];\n platform: SocialPlatform;\n scheduledFor?: Date;\n postedAt?: Date;\n status: 'draft' | 'scheduled' | 'posted' | 'failed';\n engagement?: {\n likes: number;\n shares: number;\n comments: number;\n };\n}\n\nexport type SocialPlatform = 'twitter' | 'linkedin' | 'instagram' | 'facebook';\n\nexport interface ContentTemplate {\n type: ContentType;\n template: string;\n hashtags: string[];\n platforms: SocialPlatform[];\n}\n\nexport type ContentType = \n | 'motivational_quote'\n | 'tech_tip'\n | 'daily_fact'\n | 'industry_insight'\n | 'educational'\n | 'inspirational_story';\n\nexport interface BotConfig {\n contentTypes: ContentType[];\n platforms: SocialPlatform[];\n postingFrequency: 'hourly' | 'daily' | 'weekly';\n maxHashtags: number;\n contentLength: {\n min: number;\n max: number;\n };\n tone: 'professional' | 'casual' | 'inspirational' | 'educational';\n}\n\nexport interface GenerateContentRequest {\n type?: ContentType;\n platform?: SocialPlatform;\n topic?: string;\n customPrompt?: string;\n}\n\nexport interface PostContentRequest {\n content: string;\n platforms: SocialPlatform[];\n hashtags?: string[];\n scheduleFor?: string; // ISO date string\n}",[],[241,248],[241],{"_106":256,"_98":257,"_150":258,"_152":-5,"_153":137,"_154":259,"_156":157,"_108":260,"_103":31,"_159":234,"_161":261,"_162":27,"_163":-5,"_164":262,"_101":263},"1527c90e-3943-11f0-b067-9e149126039e","README.md","1527c9ea-3943-11f0-b067-9e149126039e",1,["D",1748162072894],"# Social Media Content Creator Bot\n\nAn intelligent social media bot that automatically generates and posts engaging content across multiple platforms.\n\n## Features\n\n- 🤖 AI-powered content generation\n- 📅 Automated scheduling with cron jobs\n- 🎯 Multiple content types (quotes, tips, facts, etc.)\n- 🔄 Multi-platform support (Twitter, LinkedIn, etc.)\n- 📊 Content tracking and analytics\n- 🎨 Dynamic hashtag generation\n- ⚙️ Configurable posting frequency\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main HTTP API\n│ ├── content-generator.ts # AI content generation\n│ ├── social-platforms.ts # Platform integrations\n│ └── scheduler.ts # Posting scheduler\n├── cron-poster.ts # Automated posting cron job\n├── shared/\n│ └── types.ts # Shared types and interfaces\n└── README.md\n```\n\n## Setup\n\n1. Set up environment variables:\n - `OPENAI_API_KEY` (for content generation)\n - `TWITTER_API_KEY`, `TWITTER_API_SECRET`, `TWITTER_ACCESS_TOKEN`, `TWITTER_ACCESS_SECRET`\n - `LINKEDIN_ACCESS_TOKEN` (optional)\n\n2. Configure content settings in `backend/content-generator.ts`\n\n3. Set up the cron job schedule in Val Town UI for automated posting\n\n## Usage\n\n- **Manual posting**: Make HTTP requests to trigger content generation and posting\n- **Automated posting**: Cron job runs on schedule to post content automatically\n- **Content management**: View and manage generated content through the API\n\n## API Endpoints\n\n- `GET /` - Dashboard and manual controls\n- `POST /generate` - Generate new content\n- `POST /post` - Post content to social media\n- `GET /content` - View recent content\n- `POST /schedule` - Schedule content for later\n\n## Content Types\n\nThe bot can generate various types of content:\n- Motivational quotes\n- Tech tips and insights\n- Daily facts and trivia\n- Industry news commentary\n- Inspirational stories\n- Educational content\n\nCustomize content types in the configuration to match your brand voice and audience.",[],[257],{"_106":265,"_98":266,"_150":267,"_152":-5,"_153":137,"_154":268,"_156":157,"_108":269,"_103":259,"_159":270,"_161":271,"_162":27,"_163":-5,"_164":272,"_101":273},"8719105e-3943-11f0-979f-9e149126039e","cron-poster.ts","83695554-3943-11f0-9650-9e149126039e",9,["D",1748162264053],"interval","// Automated content posting cron job\n// This will run on a schedule to automatically generate and post content\n\nimport { ContentGenerator } from \"./backend/content-generator.ts\";\nimport { SocialMediaManager } from \"./backend/social-platforms.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { email } from \"https://esm.town/v/std/email\";\n\nconst TABLE_NAME = 'social_bot_posts_v1';\n\n// Configuration for automated posting\nconst AUTO_POST_CONFIG = {\n platforms: ['twitter'], // Add 'linkedin' when ready\n maxPostsPerDay: 3,\n minHoursBetweenPosts: 4,\n enableEmailNotifications: true\n};\n\nexport default async function() {\n console.log('🤖 Starting automated content posting...');\n \n try {\n // Check if we should post (rate limiting)\n const shouldPost = await checkPostingLimits();\n if (!shouldPost) {\n console.log('⏸️ Skipping post due to rate limits');\n return;\n }\n\n // Initialize services\n const contentGenerator = new ContentGenerator();\n const socialManager = new SocialMediaManager();\n\n // Generate content\n console.log('📝 Generating content...');\n const generated = await contentGenerator.generateContent();\n \n if (!generated.content) {\n throw new Error('No content generated');\n }\n\n console.log('✅ Content generated:', {\n type: generated.type,\n length: generated.content.length,\n hashtags: generated.hashtags.length\n });\n\n // Post to configured platforms\n console.log('📤 Posting to platforms:', AUTO_POST_CONFIG.platforms);\n const results = await socialManager.postToMultiplePlatforms(\n generated.content,\n generated.hashtags,\n AUTO_POST_CONFIG.platforms\n );\n\n // Save results to database\n for (const result of results) {\n const postId = `auto_${Date.now()}_${Math.random().toString(36).substr(2, 9)}`;\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, content, hashtags, platform, type, status, post_id, error_message, posted_at, created_at) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n postId,\n generated.content,\n JSON.stringify(generated.hashtags),\n result.platform,\n generated.type,\n result.success ? 'posted' : 'failed',\n result.postId || null,\n result.error || null,\n result.success ? new Date().toISOString() : null,\n new Date().toISOString()\n ]\n );\n }\n\n // Log results\n const successful = results.filter(r => r.success);\n const failed = results.filter(r => !r.success);\n\n console.log('📊 Posting results:', {\n successful: successful.length,\n failed: failed.length,\n platforms: successful.map(r => r.platform)\n });\n\n // Send email notification if enabled\n if (AUTO_POST_CONFIG.enableEmailNotifications) {\n await sendNotificationEmail(generated, results);\n }\n\n // Return summary\n return {\n success: true,\n content: generated,\n results,\n summary: {\n posted: successful.length,\n failed: failed.length,\n platforms: successful.map(r => r.platform)\n }\n };\n\n } catch (error) {\n console.error('❌ Error in automated posting:', error);\n \n // Send error notification\n if (AUTO_POST_CONFIG.enableEmailNotifications) {\n await sendErrorNotification(error);\n }\n \n throw error;\n }\n}\n\nasync function checkPostingLimits(): Promise {\n try {\n // Check posts in the last 24 hours\n const recentPosts = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLE_NAME} \n WHERE created_at >= datetime('now', '-24 hours') \n AND status = 'posted'`\n );\n \n const postsToday = recentPosts.rows?.[0]?.count || 0;\n \n if (postsToday >= AUTO_POST_CONFIG.maxPostsPerDay) {\n console.log(`📊 Daily limit reached: ${postsToday}/${AUTO_POST_CONFIG.maxPostsPerDay}`);\n return false;\n }\n\n // Check minimum time between posts\n const lastPost = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} \n WHERE status = 'posted' \n ORDER BY created_at DESC \n LIMIT 1`\n );\n \n if (lastPost.rows?.length > 0) {\n const lastPostTime = new Date(lastPost.rows[0].created_at);\n const hoursSinceLastPost = (Date.now() - lastPostTime.getTime()) / (1000 * 60 * 60);\n \n if (hoursSinceLastPost < AUTO_POST_CONFIG.minHoursBetweenPosts) {\n console.log(`⏰ Too soon since last post: ${hoursSinceLastPost.toFixed(1)} hours`);\n return false;\n }\n }\n\n return true;\n } catch (error) {\n console.error('Error checking posting limits:', error);\n return false; // Err on the side of caution\n }\n}\n\nasync function sendNotificationEmail(generated: any, results: any[]) {\n try {\n const successful = results.filter(r => r.success);\n const failed = results.filter(r => !r.success);\n \n const subject = `🤖 Social Bot: ${successful.length} posts published`;\n \n const html = `\n

Social Media Bot Report

\n \n

📝 Generated Content

\n Type: ${generated.type}
\n Content: ${generated.content}
\n Hashtags: ${generated.hashtags.join(' ')}\n

\n \n

📊 Posting Results

✅ Successful: ${successful.length}
❌ Failed: ${failed.length}
🎯 Platforms: ${successful.map(r => r.platform).join(', ')}

\n \n ${failed.length > 0 ? `\n

❌ Errors

${f.platform}: ${f.error}

\n ` : ''}\n \n

Generated at ${new Date().toLocaleString()}

\n `;\n \n await email({\n subject,\n html,\n text: `Social Bot posted ${successful.length} times. Content: ${generated.content}`\n });\n } catch (error) {\n console.error('Error sending notification email:', error);\n }\n}\n\nasync function sendErrorNotification(error: Error) {\n try {\n await email({\n subject: '🚨 Social Bot Error',\n html: `\n

Social Media Bot Error

Error: ${error.message}

Time: ${new Date().toLocaleString()}

${error.stack}

\n `,\n text: `Social Bot error: ${error.message}`\n });\n } catch (emailError) {\n console.error('Error sending error notification:', emailError);\n }\n}",[],[266],"files",[147,166,176,184,194,203,212,222,229,239,246,255,264],"counts",{"_278":31,"_279":259,"_280":31,"_281":31},"pulls","branches","forks","envVars","contents",[],{"_106":185,"_98":186,"_150":187,"_152":151,"_153":137,"_154":136,"_156":157,"_108":285,"_103":189,"_159":190,"_161":191,"_162":27,"_163":-5,"_101":286},["D",1748162966061],[149,186],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.code.$",{"_96":97,"_98":99,"_100":42,"_103":-7,"_101":102,"_104":293,"_145":297,"_274":337,"_234":338,"_282":340,"_341":-5,"_342":27,"_343":-5,"_344":-5,"_345":-5,"_346":347},{"_106":107,"_98":99,"_108":294,"_110":-5,"_111":27,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":-5,"_118":27,"_119":-5,"_120":31,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_130":27,"_21":295,"_134":296},["D",1748161769385],{"_96":97,"_132":133},{"_103":136,"_98":42,"_106":137,"_138":107,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":99,"_144":97},[298,319,325,331,334],{"_106":148,"_98":149,"_150":151,"_152":-5,"_153":137,"_154":155,"_156":157,"_108":158,"_103":31,"_159":160,"_161":-5,"_162":27,"_163":-5,"_164":299,"_101":318},[300,303,306,309,312,315],{"_106":167,"_98":168,"_150":169,"_152":151,"_153":137,"_154":170,"_156":157,"_108":171,"_103":31,"_159":172,"_161":173,"_162":27,"_163":-5,"_164":301,"_101":302},[],[149,168],{"_106":177,"_98":178,"_150":179,"_152":151,"_153":137,"_154":155,"_156":157,"_108":180,"_103":31,"_159":172,"_161":181,"_162":27,"_163":-5,"_164":304,"_101":305},[],[149,178],{"_106":185,"_98":186,"_150":187,"_152":151,"_153":137,"_154":136,"_156":157,"_108":188,"_103":189,"_159":190,"_161":191,"_162":27,"_163":-5,"_164":307,"_101":308},[],[149,186],{"_106":195,"_98":196,"_150":197,"_152":151,"_153":137,"_154":198,"_156":157,"_108":199,"_103":31,"_159":172,"_161":200,"_162":27,"_163":-5,"_164":310,"_101":311},[],[149,196],{"_106":204,"_98":205,"_150":206,"_152":151,"_153":137,"_154":207,"_156":157,"_108":208,"_103":31,"_159":172,"_161":209,"_162":27,"_163":-5,"_164":313,"_101":314},[],[149,205],{"_106":213,"_98":214,"_150":215,"_152":151,"_153":137,"_154":216,"_156":157,"_108":217,"_103":31,"_159":172,"_161":218,"_162":27,"_163":-5,"_164":316,"_101":317},[],[149,214],[149],{"_106":223,"_98":224,"_150":225,"_152":-5,"_153":137,"_154":226,"_156":157,"_108":227,"_103":31,"_159":160,"_161":-5,"_162":27,"_163":-5,"_164":320,"_101":324},[321],{"_106":230,"_98":231,"_150":232,"_152":225,"_153":137,"_154":226,"_156":157,"_108":233,"_103":31,"_159":234,"_161":235,"_162":27,"_163":-5,"_164":322,"_101":323},[],[224,231],[224],{"_106":240,"_98":241,"_150":242,"_152":-5,"_153":137,"_154":243,"_156":157,"_108":244,"_103":31,"_159":160,"_161":-5,"_162":27,"_163":-5,"_164":326,"_101":330},[327],{"_106":247,"_98":248,"_150":249,"_152":242,"_153":137,"_154":243,"_156":157,"_108":250,"_103":31,"_159":172,"_161":251,"_162":27,"_163":-5,"_164":328,"_101":329},[],[241,248],[241],{"_106":256,"_98":257,"_150":258,"_152":-5,"_153":137,"_154":259,"_156":157,"_108":260,"_103":31,"_159":234,"_161":261,"_162":27,"_163":-5,"_164":332,"_101":333},[],[257],{"_106":265,"_98":266,"_150":267,"_152":-5,"_153":137,"_154":268,"_156":157,"_108":269,"_103":259,"_159":270,"_161":271,"_162":27,"_163":-5,"_164":335,"_101":336},[],[266],[298,300,303,306,309,312,315,319,321,325,327,331,334],{"_106":185,"_98":186,"_150":187,"_152":151,"_153":137,"_154":136,"_156":157,"_108":285,"_103":189,"_159":190,"_161":191,"_162":27,"_163":-5,"_101":339},[149,186],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"routes/_app","actionData","errors"]