Google Gemini Chat Model and MongoDB integration

🤖 Interactive Academic Chatbot (Telegram + MongoDB) Overview 📋 This project is a template for building a complete academic virtual assistant using n8n. It connects to Telegram, answers frequently asked questions by querying MongoDB, keeps the community informed about key dates (via web scraping), and collects user feedback for continuous improvement. How It Works Architecture and Workflow ⚙️ n8n: Orchestration of 3 workflows (chatbot, scraping worker, announcer). Telegram: Frontend for user interaction and sending announcements. MongoDB: Centralized database for FAQs, academic calendar, and feedback logs. Web Scraping: HTTP Request and HTML Extract nodes to read the university's web calendar. Cron: For automatic periodic executions (daily and weekly). Core Processes 🧠 Real-time reception of user queries via Telegram. Querying MongoDB collections for FAQ answers and calendar dates. Daily scraping of the university website to keep the calendar updated. Instant logging of user feedback (👍/👎) in MongoDB. Proactive sending of weekly announcements to the Telegram channel. Key Benefits ✅ Complete automation of student communication 24/7. An always-accurate academic calendar database without manual intervention. A built-in continuous improvement system through user feedback. Proactive communication of important events to the entire community. Use Cases 💼 Automation of student support in universities, colleges, and institutions. A virtual assistant for any organization needing to manage FAQs and a dynamic calendar. An automated announcements channel to keep a community informed. Requirements 👨‍💻 n8n instance (self-hosted or cloud). Credentials for a Telegram Bot (obtained from @BotFather). Credentials for a MongoDB database (Connection URI). URL of the academic calendar to be scraped. Authors 👥 Doménica Amores Nicole Guevara Adrián Villamar Mentor: Jaren Pazmiño Applicants to the CIAP Polytechnic Artificial Intelligence Club

Stop fighting alerts and start orchestrating intelligence. This workflow is a complete ecosystem designed to combat network threats in real-time. It transforms raw DNS logs into structured knowledge, leveraging Artificial Intelligence to make decisions that previously required hours of manual work by a SOC analyst. Real-World Problems it Solves: Manual Threat Analysis: Automates the process of verifying suspicious domains and IP addresses across multiple CTI sources simultaneously. Security Credential Management: Eliminates the risk of API key leaks through native integration with HashiCorp Vault. Alert Fatigue: Thanks to built-in filtering logic, the system only notifies you when the AI Threat Score exceeds 5 (Malicious/Critical). Data Fragmentation: Consolidates data from multiple CTI providers into a single, cohesive technical report. Core System Components: The workflow manages and communicates with the following elements of your infrastructure: Traffic Capture: Monitors passive DNS traffic to identify new Indicators of Compromise (IoCs). Secret Engine: HashiCorp Vault provides database credentials and API tokens dynamically during workflow execution. Intelligence Layer: Features three independent scanning branches: VirusTotal, Abuse_URLhaus, and Abuse_ThreatFox. AI Brain: Google Gemini AI acts as a "Senior Security Analyst," correlating data and generating verdicts in both English and Polish. Automated Response: An email notification system triggered exclusively for confirmed high-risk threats. Release v1.0.0 Highlights This release (available on https://github.com/lukaszFD/cyber-sentinel/releases) marks the first fully stable production-ready version of the system. Key features of this release: Full Ansible Orchestration: The entire stack—including Nginx, Vault, databases, and n8n—is deployed automatically using Ansible playbooks. Infrastructure as Code (IaC): Secure deployment based on Ansible Vault, requiring only the population of credentials and the presence of a .vault_pass file. Production-Ready: The system has been rigorously tested for stability in both Debian (Proxmox) and Raspberry Pi 5 environments. Documentation : https://lukaszfd.github.io/cyber-sentinel/

AI Powered Blog Automation for Shopify >Watch the Youtube Tutorial Video Transform Your Shopify Store with Automated, AI Generated Blog Content Stop struggling with content creation. This n8n workflow automatically generates high quality, SEO optimized blog posts for your Shopify store every single day while you focus on growing your business. See It In Action: Real Results from Pink Matcha Visit Pink Matcha Blog - A real Shopify store powered by this exact workflow. Real Traffic, Real Results 50+ SEO optimized articles** published automatically Consistent daily content** without hiring writers Multiple categories** with targeted content Professional formatting** that converts visitors to customers What You're Getting ✅ Automated Content Generation AI creates unique articles** from curated industry sources SEO optimized** with proper headings, keywords, and meta descriptions 800 to 1200 words per article** with actionable insights Plagiarism free** content that ranks in Google ✅ Multi Category Organization Fitness, Nutrition, Wellness, Personal Growth, or YOUR niche Each category gets targeted, relevant content Build authority across your entire product range Cross sell opportunities through strategic content ✅ Direct Shopify Integration One click publishing** to your Shopify blog Professional HTML formatting Automatic categorization SEO metadata included Draft or publish modes ✅ Multi Blog Support Manage multiple blogs** within the same Shopify store Create separate blogs for different product lines or audiences Each blog can have its own RSS feeds and categories Run workflows independently or simultaneously ✅ Smart Product Integration Automatically embed product links** within articles AI intelligently references relevant products from your catalog Include product cards, images, and CTAs Drive traffic directly to product pages Turn readers into buyers with strategic product placement ✅ AI Generated Featured Images Automatically creates branded images** for every blog post AI generates custom visuals that match your brand style Include your logo or signature products in every image Customizable style instructions for perfect brand consistency No need for stock photos or graphic designers Every article gets a unique, professional featured image ✅ Smart Content Intelligence MongoDB vector search** prevents duplicate topics Sources content from trusted RSS feeds in your niche Learns your brand voice Maintains consistency across all articles 🔥 Game Changing Features Multiple Blogs, One Workflow Run multiple blogs within the same Shopify store: Create separate blogs for different product lines (e.g., Men's vs Women's, Premium vs Budget) Target different audiences with customized content strategies Each blog has its own RSS feeds, categories, and publishing schedule Manage everything from a single n8n instance Perfect for multi brand stores or diverse product catalogs Example Use Cases: Fashion Store**: Separate blogs for Men, Women, Kids, and Accessories Wellness Store**: Different blogs for Fitness, Nutrition, Mental Health, and Supplements Tech Store**: Blogs for Gadgets, Software Reviews, How To Guides, and Industry News Intelligent Product Integration AI automatically embeds your products within blog content: Analyzes article topics and matches relevant products from your catalog Inserts product cards with images, descriptions, and "Buy Now" buttons Creates contextual product mentions throughout the article Links to product pages to drive direct sales Customizable product placement rules Turn Every Article Into a Sales Machine: Blog post about "Best Workout Routines" → Automatically includes your yoga mats, resistance bands, and protein powder Article on "Winter Skincare Tips" → Embeds your moisturizers, serums, and face masks Guide to "Home Office Setup" → Features your desk organizers, chairs, and lighting products AI Generated Featured Images with Brand Consistency Every article gets a unique, professionally designed featured image: AI generates custom images matching your brand aesthetic Automatically includes your logo or signature product in each image Configure your brand style once, AI applies it to all future images Customizable image generation instructions for perfect consistency Wide, natural looking scenes (no generic stock photo vibes) No need for Canva, designers, or stock photo subscriptions How It Works: Configure your Branding Logo (product image or logo URL) Set your Branding Style ("Image should contain a girl holding this drink") Define Image Style guidelines ("Wide, natural scene with no square framing") AI automatically generates unique images for each article topic Images are uploaded to Shopify and set as featured images Example: Article: "5 Morning Rituals for Better Energy" Generated Image: Wide, natural scene of a person holding Pink Matcha drink during sunrise, perfectly matching your brand aesthetic No more spending hours on: Finding stock photos Editing images in Canva Ensuring brand consistency Resizing for different platforms Worrying about image licensing Why Store Owners Love This Workflow 💰 Save Thousands on Content Creation Traditional Approach: Freelance writers: $100 to 300 per article 30 articles/month = $3,000 to 9,000/month Plus time for editing, SEO, uploading, formatting With This Workflow: $30 to 60/month** in API costs Unlimited articles Zero manual work Save $2,940 to 8,940 per month** ⏰ Reclaim Your Time Before: 4 to 6 hours writing each article 2 hours researching topics 1 hour formatting and uploading 7+ hours per article** After: Click one button AI generates, formats, and publishes 0 hours of your time** 📈 Grow Your Organic Traffic Fresh content signals to Google you're active More pages = more chances to rank Long tail keywords across every article Internal linking boosts your entire site 🎯 Perfect for E commerce Educational content** that supports your products How to guides** featuring your items Category pages** that drive purchase decisions Build trust** before customers buy Live Examples from Pink Matcha Fitness Content Nutrition Content Self Care Content Personal Growth Content Every single one of these articles was generated automatically by this workflow. Perfect For Every Shopify Store 🏋️ Health & Wellness Brands Generate workout tips, nutrition guides, supplement education, and wellness advice that positions your products as solutions. 👗 Fashion & Apparel Create style guides, trend reports, outfit inspiration, and care instructions that showcase your clothing line. 🏠 Home & Lifestyle Produce decorating tips, organization hacks, product care guides, and seasonal content that drives home goods sales. 💄 Beauty & Skincare Develop routine guides, ingredient education, application tutorials, and trend analysis that supports cosmetics sales. 🎮 Hobbies & Collectibles Write product reviews, how to guides, industry news, and collector tips that engage enthusiasts. 📱 Tech & Gadgets Generate setup guides, comparison articles, tech news, and troubleshooting content for electronics stores. What's Included in Your Purchase 4 Complete n8n Workflows Shopify Blog Automation - The core automation engine Gemini Image Generator Tool - AI powered featured image creation with brand consistency Web Search Tool - Real time web research using OpenAI GPT 4O Search Link Validator Tool - Ensures all URLs work before publishing Complete Documentation Step by step setup guide** (Technical Setup.md) Video walkthrough** (coming soon) Google Sheets templates** for RSS feeds and categories Example configurations** for multiple niches Lifetime Access & Updates All future workflow improvements New features as they're released Updated documentation Priority email support How It Works (Simple 3 Step Process) Step 1: Configure Your RSS Feeds Add trusted content sources from your industry into a Google Sheet. The workflow monitors these for fresh content daily. Step 2: AI Generates Unique Articles Google Gemini reads source articles, understands your niche, and creates completely original blog posts optimized for SEO and your brand voice. Step 3: Auto Publish to Shopify Articles are automatically formatted, categorized, and published to your Shopify blog—no manual work required. That's it. Your blog grows on autopilot. Technical Specs (For the Curious) AI Content Engine**: Google Gemini for blog content generation AI Image Engine**: Google Gemini 3 Pro Image Preview (16:9 branded images) Web Search**: OpenAI GPT-4O SEARCH PREVIEW for real time research Vector Search**: MongoDB Atlas (prevents duplicate topics) Embeddings**: OpenAI text-embedding-3-small for semantic matching Platform**: n8n workflow automation Integration**: Native Shopify Admin API & OAuth2 Social**: Auto post to Twitter (optional) Scalability**: 1 to 10+ articles per day with custom featured images Full technical documentation included with purchase. Frequently Asked Questions Q: Do I need coding skills? A: No! Import the workflows, configure your credentials, and you're ready. Full setup guide included (~60 to 90 minutes). Q: What are the monthly costs? A: ~$30 to 60/month (Google Gemini API + OpenAI + MongoDB free tier + n8n self to hosted). Way cheaper than hiring writers. Q: How many articles can it generate? A: Unlimited. Run it daily for 30 to 90 articles/month, or adjust frequency to your needs. Q: Will the content be unique? A: 100% original. AI creates new content inspired by sources, never copies. Vector search prevents duplicate topics. Q: Can I use this for my niche? A: Yes! Works for ANY niche. Just configure your RSS feeds and categories. Tech, fashion, home, beauty, gaming—anything. Q: Does it work with WordPress or other platforms? A: This version is built for Shopify. The workflow can be adapted for WordPress, Ghost, Medium, or custom sites. Q: How long are the articles? A: Configurable. Default is 800 to 1200 words. Adjust AI prompts for shorter (500w) or longer (2000w+) content. Q: Can I review articles before publishing? A: Yes! Set to "draft" mode, review in Shopify, edit if needed, then publish manually. Q: What languages does it support? A: Google Gemini supports 100+ languages. Configure the AI prompts to generate content in your target language. Q: What's your refund policy? A: No refunds. Please review this page and the live examples before purchasing. Still Not Sure? See The Results Visit pinkmatcha.co to see this workflow in action. Every article. Every category. All automated. Read the articles. Check the formatting. See the SEO optimization. Experience the quality. Then imagine this running on YOUR Shopify store. Questions? We're Here to Help 📧 Email: [email protected] 💬 Community: Join our Skool 📚 Documentation: Comprehensive guides included 🎥 Videos: Setup tutorials (coming soon) About emp0 We build production ready n8n automation workflows used by hundreds of businesses worldwide. Our workflows save companies thousands of hours and tens of thousands of dollars every month. 🛍️ Premium Workflows: store.emp0.com 🆓 Free Workflows: emp0.com/automation-workflows 🐦 Twitter: @emp0_com 🎯 Live Example: Pink Matcha Blog Don't Let Your Competitors Outrank You While you're manually writing one blog post per week, your competitors could be publishing daily with AI automation. Every day you wait is another day without: Fresh SEO content ranking in Google Educational articles converting visitors Authority building thought leadership Traffic flowing to your products The solution is one click away. Powered by n8n • Google Gemini • OpenAI • MongoDB • Shopify

How it works This workflow creates a multi-talented AI assistant named Simran that interacts with users via Telegram. It can handle text and voice messages, understand the user's intent, and perform various tasks. Step 1: Receive & Transcribe Input The workflow triggers on any new Telegram message. If it's a voice message, it uses AssemblyAI to transcribe it into text; otherwise, it processes the incoming text directly. Step 2: Understand User Intent Using a Large Language Model (LLM), the workflow analyzes the user's message to determine their goal, categorizing it as a general chat, a request to generate an image, a command to set a reminder, or a request to remember a specific piece of information. Step 3: Fetch Context & Route The assistant retrieves past conversation summaries from a MongoDB database to maintain context. Based on the user's intent, the workflow routes the task to the appropriate path. Step 4: Execute the Task Chat: Generates a response using an AI agent whose personality can be toggled between a standard assistant and a "Girlfriend Mode." It also analyzes the user's mood to tailor the response. Generate Image: Creates a detailed prompt and uses an image generation API to create and send a picture. Set Reminder: Parses the natural language request, creates an event in Google Calendar and a task in Google Tasks, and sends a confirmation. Remember Info: Saves specific user-provided information to a dedicated memory collection in MongoDB. Step 5: Respond and Save Memory The final output (text, voice message, or image) is sent back to the user on Telegram. The workflow then summarizes the interaction and saves it to the database to ensure continuity in future conversations. Set up steps Estimated Set up time: 20 - 30 minutes. Configure Credentials: You will need to add credentials for several services in your n8n instance: Telegram (Bot API Token) AssemblyAI (API Key) MongoDB Google (for Calendar, Tasks, Sheets, and Natural Language API) A Large Language Model (the workflow uses Google Gemini but can be adapted) An image generation service (the workflow uses the Together.xyz API) Set up External Services: Ensure your MongoDB instance has two collections: user_memory and memory_auto. Create a Google Sheet to manage the "Girlfriend Mode" status for different users. Ensure edge-tts is installed on the machine running your n8n instance for the text-to-speech functionality. Customize Nodes: Review the nodes with hardcoded IDs, such as Google Tasks and Google Sheets, and update them with your specific Task List ID and Sheet ID. The sticky notes inside the workflow provide more detailed instructions for specific nodes and segments.