NocoDB and Telegram integration

Overview This workflow automates the process of converting RSS feed articles into ready-to-publish social media posts using OpenAI, NocoDB, and Telegram. It's ideal for content teams, marketing managers, or news portals seeking to automate content curation while maintaining control through a human approval system. Features RSS Feed Monitoring Polls a specified RSS feed every 20 minutes. Detects new articles automatically. AI-Powered Content Processing Summarizes the full article using OpenAI's Assistant API. Creates an image prompt based on the article summary. Generates a platform-specific post for Facebook and LinkedIn using AI. Image Generation Leverages OpenAI's image model to generate a relevant image from the prompt. Retrieves and stores the featured image from the original article (via custom code node). Post Management with NocoDB Stores all content in NocoDB including: Article URL AI-generated summary Image prompt Post content per platform Generated image URL Post status (Pending, Approved, Declined) Human Approval via Telegram Sends post preview to a Telegram group or channel with inline buttons: ✅ Approve ❌ Decline On approval: Posts to Facebook, LinkedIn, and optionally Twitter. On rejection: Marks the NocoDB record as "Declined". Conditional Twitter (X) Posting Asks user whether to post with or without a link. Posts accordingly based on user’s Telegram response. No-Code Backend NocoDB acts as a lightweight CMS to manage, edit, and review AI-generated content before publishing. Setup Instructions Clone the workflow in your n8n instance. Configure the following credentials under Credentials > New: OpenAI API Key Facebook Graph API LinkedIn Access Token Twitter (X) OAuth credentials Telegram Bot Token and Chat ID NocoDB API Token and Base URL Set the RSS feed URL in the trigger node to your preferred news source. Adjust the NocoDB API node with your table and field names (see below). Deploy the workflow on an interval trigger (20-minute polling recommended). NocoDB Database Structure Column Name Description url Original article URL summary AI-generated summary image_prompt Prompt used for generating image image_url Final image URL (from OpenAI) post_content Formatted social media post platform Social platform (Facebook, LinkedIn, etc.) status Current status (Pending, Approved, Declined) date_created Date article was fetched Requirements An active n8n instance (cloud or self-hosted). API credentials for: OpenAI Telegram Bot Facebook Graph API LinkedIn Developer App Twitter/X Developer App NocoDB (self-hosted or cloud) A Telegram chat (group or user) where the bot is added. Customization Guidance Add more platforms: Extend the logic to other platforms like Instagram, Threads, or Mastodon. Customize AI tone: Adjust the prompt to OpenAI for a specific writing style (e.g., formal, casual, humorous). Adjust scheduling: Modify interval time or RSS feed frequency as needed. Add post delay: Schedule posts using a delay node to spread them over time. Use Cases Auto-publish summarized news articles to multiple social platforms. Reduce effort for social teams by automating draft creation and media. Maintain editorial control using the Telegram approval step. Repurpose blog or article content into engaging posts with minimal effort. Integrations Used OpenAI (Assistants & DALL·E Image Generation) Telegram Bot (Inline approval workflow) Facebook Graph API (Post publishing) LinkedIn API (Company or personal posts) Twitter/X API (Optional conditional post publishing) RSS Feed Reader (Article fetching) NocoDB (Content repository and status manager)

Complete Telegram Trivia Bot with AI Question Generation Build a fully-featured Telegram trivia bot that automatically generates fresh questions daily using OpenAI and tracks user progress with NocoDB. Perfect for communities, education, or entertainment! Get Started with n8n now! ✨ Key Features 🤖 AI Question Generation: Automatically creates 40+ new trivia questions daily across 8 categories 📊 Smart User Management: Tracks scores, prevents question repeats, maintains leaderboards 🎮 Game Mechanics: Star-based difficulty scoring, answer history, progress tracking 🏆 Competitive Elements: Real-time leaderboards with emoji rankings and user positioning 🛡️ Robust Architecture: Error handling, state management, and data validation 🚀 Perfect For Community Engagement**: Keep Telegram groups active with daily trivia challenges Educational Content**: Create learning experiences with categorized questions Business Applications**: Employee training, customer engagement, lead generation Personal Projects**: Learn n8n automation while building something fun 📱 Supported Commands /start - Welcome new users with setup instructions /question - Get personalized trivia questions (never repeats correctly answered ones) /score - View current points and statistics /leaderboard - See top 10 players with rankings /stats - Detailed accuracy and performance metrics /help - Complete command reference 🔧 How It Works User Journey: User sends /question command to bot System checks their answer history to avoid repeats Displays fresh question with multiple choice options Processes answer, updates score based on difficulty stars Saves complete answer history for future filtering AI Content Pipeline: Daily scheduler triggers question generation OpenAI creates 5 questions per category (8 categories total) Questions automatically saved to NocoDB with difficulty ratings Content includes explanations and proper formatting 🛠️ Set Up Steps Prerequisites: n8n instance (cloud or self-hosted) NocoDB database (free tier works) OpenAI API key (Not required if you want to add questions yourself) Telegram bot token Database Setup: Create 3 NocoDB tables with the exact field specifications provided in the sticky notes. The workflow includes complete schema documentation. Configuration Time: ~15 minutes for database setup + API keys Detailed Setup Instructions: All setup steps, database schemas, and configuration details are documented in the workflow's sticky notes for easy implementation. 📈 Advanced Features Question History Tracking**: Users never see correctly answered questions again Difficulty-Based Scoring**: 1-5 star rating system with corresponding points Category Management**: 8 different trivia categories for variety State Management**: Proper game flow with idle/waiting states Error Handling**: Graceful fallbacks for all edge cases Scalable Architecture**: Supports unlimited concurrent users 🎯 Business Applications Lead Generation**: Capture user data through engaging trivia Employee Training**: Create custom questions for onboarding Customer Engagement**: Keep users active in your Telegram community Educational Tools**: Subject-specific learning with progress tracking Event Activation**: Conferences, workshops, or team building 💡 Customization Options Modify question categories for your niche Adjust scoring systems and difficulty levels Add custom commands and features Integrate with other platforms or APIs Create specialized question sets 🔗 Get Started Ready to build your own AI-powered trivia bot? Start with n8n and follow the comprehensive setup guide included in this workflow template. Next Steps: Import this workflow template Follow the database setup instructions in sticky notes Configure your API credentials Test with sample questions Launch your trivia bot! Turn your friend group into trivia champions with AI-generated questions that spark friendly competition!

An example workflow for a multilanguage Telegram bot. It allows adding many new languages to the bot without editing the workflow. Important note! Due to some breaking API changes in NocoDB some of its node options are not working at the moment (MAY 2022). These two nodes were replaced by HTTP request nodes. Functionality is still the same.