Automated US stock portfolio analysis with Telegram, Perplexity AI & PDF reports

Name: Automated US stock portfolio analysis with Telegram, Perplexity AI & PDF reports
Availability: InStock
Rating: 4.5 (51 reviews)
Author: Solido AI

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

System Architecture Two integrated N8N workflows providing automated US stock portfolio management through Telegram:

FLOW 1: Conversational Portfolio Manager

Telegram bot for interactive portfolio management
PDF upload & analysis via LlamaIndex Cloud API
Natural language portfolio updates via GPT-4.1-mini
Real-time user registration and data management

FLOW 2: Automated Weekly Reports

Schedule-triggered weekly analysis (every 7 days)
Perplexity AI sonar-deep-research for market analysis
Professional PDF report generation via PDFco
Automatic Telegram delivery to all registered users

Solido AI

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

advanced

Published 05 Jul 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Generate intraday AAPL trade signals using live data, OpenAI, Telegram and Notion

## 📘 Description This workflow automates short-interval market signal evaluation for intraday trading using live technical indicators and deterministic decision logic. It is designed for traders, analysts, and automation teams who want fast, auditable trade signals without manual chart monitoring or subjective interpretation. On a fixed 5-minute schedule, the workflow fetches live price, volume, RSI, and EMA data for AAPL and combines them into a unified market snapshot. A deterministic computation layer derives clear trend and momentum signals, ensuring indicator logic remains transparent and non-AI. These signals are then evaluated by a strict, rule-based AI decision engine that returns a structured verdict—APPROVE, WAIT, or REJECT—along with confidence and a concise reason. Trade decisions are routed instantly to Telegram for real-time visibility and logged to Notion for historical analysis and auditability. Built-in error handling ensures any workflow failure is reported immediately. ## ⚠️ Deployment Disclaimer This workflow is intended for self-hosted n8n instances only. It relies on frequent polling, external market data APIs, and advanced AI agent orchestration not suitable for n8n Cloud. ⚙️ What This Workflow Does (Step-by-Step) ⏰ Scheduled Market Data Polling Runs automatically every 5 minutes to capture fresh market data. 📡 Fetch Live Market Indicators Pulls AAPL price, volume, RSI, and EMA from the market data provider. 🔗 Merge Indicator Streams Combines all indicators into a synchronized market snapshot. 🧮 Compute Trend & Momentum (Deterministic) Derives bullish, bearish, or neutral signals using fixed logic—no AI. 🧠 Evaluate Trade Decision (AI) Applies strict rule-based logic to return verdict, confidence, and reason. 🔀 Route Trade by Verdict Separates approved vs non-approved signals automatically. 📣 Send Telegram Trade Alerts Delivers real-time trade decisions directly to Telegram. 🗂 Log Decisions to Notion Stores every verdict for tracking, analysis, and audit. 🚨 Workflow Error Handler → Email Alert Sends immediate notifications if any step fails. ## 🧩 Prerequisites • Self-hosted n8n instance • Market data API (e.g., Twelve Data) • OpenAI API credentials • Telegram Bot API • Notion API access ## 💡 Key Benefits ✔ Fully automated intraday signal monitoring ✔ Transparent, auditable indicator calculations ✔ Strict, deterministic AI decision logic ✔ Real-time Telegram alerts without opening n8n ✔ Centralized trade history in Notion ✔ Reliable error detection and reporting ## 👥 Perfect For Active traders and market analysts Quant and rule-based trading teams Automation engineers building trading assistants Founders prototyping decision-support trading systems

View

Analyze crypto markets with CoinGecko MCP and C1

## Analyze crypto markets with interactive graphs using CoinGecko and C1 by Thesys This n8n template can answer questions about **real-time prices, market moves, trending coins, and token details** with **interactive UI in real time** (cards, charts, buttons) instead of plain text using C1 by Thesys. Data is fetched through the **CoinGecko Free MCP tool**. ### [Check out a working demo of this template here](https://www.thesys.dev/n8n?url=https://www.thesys.dev/n8n?url=https%3A%2F%2Fasd2224.app.n8n.cloud%2Fwebhook%2F51638b0c-7765-4fa8-9b95-a0422128e203%2Fchat). ### What this workflow does 1. A user sends a message in the **n8n Chat** UI (public chat trigger). 2. The **AI Agent** interprets the request. 3. The agent calls **CoinGecko Free MCP** to fetch market data (prices, coins, trending, etc.). 4. The model responds through **C1 by Thesys** with a **streaming, UI** answer. ### Example prompts you can try right away Copy/paste any of these into the chat: - “What’s the current price of Bitcoin and Ethereum?” - “Give me today’s market summary: total market cap, BTC dominance, top gainers/losers.” - “Compare ETH vs SOL over 30 days with a chart.” > Note: This template is for information and visualization, not financial advice. ### How it works 1. User sends a prompt 2. C1 model based on prompt will use CoinGecko MCP to fetch live data 3. C1 Model generates a UI Schema Response 4. Schema is rendered as UI using Thesys GenUI SDK on the frontend ### Setup Make sure you have the following: #### 1️⃣ Thesys API Key You’ll need an API key to authenticate and use Thesys services. 👉 Get your key [here](https://console.thesys.dev/keys) ### What is C1 by Thesys? C1 by [Thesys](https://www.thesys.dev/) is an API middleware that augments LLMs to respond with **interactive UI (charts, buttons, forms)** in real time instead of text. ### Facing setup issues? #### If you get stuck or have questions: - #### 💬 Join the [Thesys Community](https://discord.com/invite/Pbv5PsqUSv) - #### 📧 Email support: [email protected]

View

Analyze stock sentiment with GPT-4o and create Asana tasks with Slack alerts

![image 7.png](fileId:3893) ## 📘 Description This workflow analyzes real-time stock market sentiment and intent from public social media discussions and converts those signals into operations-ready actions. It exposes a webhook endpoint where a stock-market–related query can be submitted (for example, a stock, sector, index, or market event). The workflow then scans Twitter/X and Instagram for recent public discussions that indicate buying interest, selling pressure, fear, uncertainty, or emerging opportunities. An AI agent classifies each signal by intent type, sentiment, urgency, and strength. These insights are transformed into a prioritized Asana task for market or research teams and a concise Slack alert for leadership visibility. Built-in validation and error handling ensure reliable execution and fast debugging. This automation removes the need for manual social monitoring while keeping teams informed of emerging market risks and opportunities. ## ⚠️ Deployment Disclaimer This template is designed for self-hosted n8n installations only. It relies on external MCP tools and custom AI orchestration that are not supported on n8n Cloud. ## ⚙️ What This Workflow Does (Step-by-Step) - 🌐 Receive Stock Market Query (Webhook Trigger) Accepts an external POST request containing a stock market query. - 🧾 Extract Stock Market Query from Payload Normalizes and prepares the query for analysis. - 🔎 Analyze Social Media for Stock Market Intent (AI) Scans public Twitter/X and Instagram posts to detect actionable market intent signals. - 📡 Social Intelligence Data Fetch (MCP Tool) Retrieves relevant social data from external intelligence sources. - 🧠 Transform Market Intent Signals into Ops-Ready Actions (AI) Structures insights into priorities, summaries, and recommended actions. - 🧹 Parse Structured Ops Payload Validates and safely parses AI-generated JSON for downstream use. - 📋 Create Asana Task for Market Signal Review Creates a prioritized task with key signals, context, and recommendations. - 📣 Send Market Risk & Sentiment Alert to Slack Delivers an executive-friendly alert summarizing risks or opportunities. - 🚨 Error Handler → Slack Alert Posts detailed error information if any workflow step fails. ## 🧩 Prerequisites • Self-hosted n8n instance • OpenAI and Azure OpenAI API credentials • MCP (Xpoz) social intelligence credentials • Asana OAuth credentials • Slack API credentials ## 🛠 Setup Instructions - Deploy the workflow on a self-hosted n8n instance - Configure the webhook endpoint and test with a sample query - Connect OpenAI, Azure OpenAI, MCP, Asana, and Slack credentials - Set the correct Asana workspace and project ID - Select the Slack channel for alerts ## 🛠 Customization Tips • Adjust intent and sentiment classification rules in AI prompts • Modify task priority logic or due-date rules • Extend outputs to email reports or dashboards if required ## 💡 Key Benefits ✔ Real-time market sentiment detection from social media ✔ Converts unstructured signals into actionable tasks ✔ Provides leadership-ready Slack alerts ✔ Eliminates manual market monitoring ✔ Built-in validation and error visibility ## 👥 Perfect For - Market research teams - Investment and strategy teams - Operations and risk teams - Founders and analysts tracking market sentiment

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.