Sergey Skorobogatov
Templates by Sergey Skorobogatov
Generate stock market insights with technical analysis, AI, and Telegram publishing
📈 AI Stock Analytics & BCS "Profit" Social Network Publishing Workflow This workflow automatically generates stock market insights for selected tickers (e.g. GAZP, SBER, LKOH) using historical data, technical indicators, and an AI model. The results are then sent to Telegram for quick moderation and publishing. 🔑 What this workflow does Runs twice a day on a schedule with a predefined list of tickers. Fetches historical market data from a broker API. Calculates key technical indicators (RSI, EMA/SMA, MACD, Bollinger Bands, ADX). Generates an investment post (title + summary) using an LLM. Stores results in a PostgreSQL database. Sends a draft post to Telegram with inline buttons “Publish” and “Retry”. Handles Telegram actions: publishes the post to the final channel or re-runs the generation process. 📌 Key features Multi-ticker support in a single run. Automatic error handling (e.g. missing data or invalid AI JSON output). Human-in-the-loop moderation through Telegram before publishing. PostgreSQL integration for history and analytics storage. Flexible structure: easy to extend with new tickers, indicators, or publishing channels. 🛠️ Nodes used Trigger: Schedule (twice daily) + Telegram Trigger (button callbacks). Data: HTTP Request (broker API), Function (technical analysis calculations). AI: OpenAI / OpenRouter with structured JSON output. Storage: PostgreSQL (analytics history). Messaging: Telegram (drafts and publishing). 🚀 Who is this for Fintech startups looking to automate market content. Investment bloggers posting daily stock analysis. Analysts experimenting with trading strategies on real market data.
By Sergey SkorobogatovCreate a Witty Telegram Bot with AI-Powered Humor, Roasts & Stats using OpenRouter
GiggleGPTBot — Witty Telegram Bot with AI & Postgres 📝 Overview GiggleGPTBot is a witty Telegram bot built with n8n, OpenRouter, and Postgres. It delivers short jokes, motivational one-liners, and playful roasts, responds to mentions, and posts scheduled witty content. The workflow also tracks user activity and provides lightweight statistics and leaderboards. --- ✨ Features 🤖 AI-powered humor engine — replies with jokes, motivation, random witty lines, or sarcastic roasts. 💬 Command support — /joke, /inspire, /random, /roast, /help, /stats, /top. 🎯 Mention detection — replies when users tag @GiggleGPTBot. ⏰ Scheduled posts — morning jokes, daily motivation, and random wisdom at configured times. 📊 User analytics — counts messages, commands, reactions, and generates leaderboards. 🗄️ Postgres persistence — robust schema with tables for messages, responses, stats, and schedules. --- 🛠️ How It Works Triggers Telegram Trigger — receives all messages and commands from a chat. Schedule Trigger — runs hourly to check for planned posts. Processing Switch routes commands (/joke, /inspire, /random, /roast, /help, /stats, /top). Chat history fetches the latest context. Mention Analysis determines if the bot was mentioned. Generating an information response builds replies for /help, /stats, /top. AI nodes (AI response to command, AI response to mention, AI post generation) craft witty content via OpenRouter. Persistence Init Database ensures tables exist (usermessages, botresponses, botcommands, messagereactions, scheduledposts, userstats). Logging nodes update stats and store every bot/user interaction. Delivery Replies are sent back via Telegram Send nodes (Send AI response, Send info reply, Reply to Mention, Submit scheduled post). --- ⚙️ Setup Instructions Create a Telegram Bot with @BotFather and get your API token. Add credentials in n8n: Telegram API (your bot token) OpenRouter (API key from openrouter.ai) Postgres (use your DB, Supabase works well). Run the Init Database node once to create all required tables. (Optional) Seed schedule with the Adding a schedule node — it inserts: Morning joke at 06:00 Daily motivation at 09:00 Random wisdom at 17:00 (Adjust chat_id to your group/channel ID.) Activate workflow and connect Telegram Webhook or Polling. --- 📊 Database Schema user\_messages — stores user chat messages. bot\_responses — saves bot replies. bot\_commands — logs command usage. message\_reactions — tracks reactions. scheduled\_posts — holds scheduled jokes/wisdom/motivation. user\_stats — aggregates per-user message/command counts and activity. --- 🔑 Example Commands /joke → witty one-liner with light irony. /inspire → short motivational phrase. /random → unexpected witty remark. /roast → sarcastic roast (no offensive targeting). /stats → shows your personal stats. /top → displays leaderboard. /help → lists available commands. @GiggleGPTBot + message → bot replies in context. --- 🚀 Customization Ideas Add new command categories (/quote, /fact, /news). Expand analytics with reaction counts or streaks. Localize prompts into multiple languages. Adjust CRON schedules for posts. --- ✅ Requirements Telegram Bot token OpenRouter API key Postgres database --- 📦 Import this workflow, configure credentials, run the DB initializer — and your witty AI-powered Telegram companion is ready!
By Sergey Skorobogatov