Skip to main content

Generate stock market insights with technical analysis, AI, and Telegram publishing

Workflow preview

Workflow preview
100%
Generate stock market insights with technical analysis, AI, and Telegram publishing preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

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 dat...

Best for

  • Crypto Trading automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenrouter, n8n-nodes-base.scheduletrigger, n8n-nodes-base.executeworkflow, n8n-nodes-base.telegramtrigger, n8n-nodes-base.telegram, @n8n/n8n-nodes-langchain.outputparserstructured, n8n-nodes-base.set

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Sergey Skorobogatov.

Original n8n.io source

1.1 Workflow description

Title
Generate stock market insights with technical analysis, AI, and Telegram publishing
Workflow name
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.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - AI Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 2 - OpenRouter Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenRouter - lmChatOpenRouter
Config choices
Version 1

Block 3 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 4 - Execute Auth Login

Type / Role
n8n-nodes-base.executeWorkflow - executeWorkflow
Config choices
Version 1.2

Block 5 - Execute Auth Trade API

Type / Role
n8n-nodes-base.executeWorkflow - executeWorkflow
Config choices
Version 1.2

Block 6 - Telegram Trigger

Type / Role
n8n-nodes-base.telegramTrigger - telegramTrigger
Config choices
Version 1.2

Block 7 - Ошибка публикации

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 8 - Успешно опубликовано

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 9 - Structured Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 10 - Get Action Type

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 11 - Exist type and id

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 12 - Get Post By Id

Type / Role
n8n-nodes-base.postgres - postgres
Config choices
Version 2.6

Block 13 - Ошибка генерации

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 14 - Исторические данные

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.1

Block 15 - Рассчет TA

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - ID Generation

Type / Role
n8n-nodes-base.crypto - crypto
Config choices
Version 1

Block 17 - Отправка поста на валидацию

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 18 - Публикация постав в Профите

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 19 - Развилка

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.2

Block 20 - Собираем пост

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 21 - Send a text message

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 22 - Сохранение поста

Type / Role
n8n-nodes-base.postgres - postgres
Config choices
Version 2.6

Block 23 - Данные для анализа (тут указываются ticker)

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 24 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Showing the first 24 of 25 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Generate stock market insights with technical analysis, AI, and Telegram publishing
Complexity advanced
Nodes 25
Categories Crypto Trading, AI Summarization
Author Sergey Skorobogatov
Published 31 Aug 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/8094/8094.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Generate stock market insights with technical analysis, AI, and Telegram publishing do?

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 dat...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Crypto Trading, AI Summarization use case.