Extract Market Cap Data from Yahoo Finance with Bright Data & Visualize in Telegram

Description

Financial Insight Automation: Market Cap to Telegram via Bright Data

📊 Description

An automated n8n workflow that scrapes financial data from Yahoo Finance using Bright Data, processes market cap information, generates visual charts, and sends comprehensive financial insights directly to Telegram for instant notifications.

🚀 How It Works

This workflow operates through a simple three-zone process:

1. Data Input & Trigger
User submits a keyword (e.g., "AI", "Crypto", "MSFT") through a form trigger that initiates the financial data collection process.

2. Data Scraping & Processing
Bright Data API discovers and scrapes comprehensive financial data from Yahoo Finance, including market cap, stock prices, company profiles, and financial metrics.

3. Visualization & Delivery
The system generates interactive market cap charts, saves data to Google Sheets for record-keeping, and sends visual insights to Telegram as PNG images.

⚡ Setup Steps

> ⏱️ Estimated Setup Time: 15-20 minutes

Prerequisites
Active n8n instance (self-hosted or cloud)
Bright Data account with Yahoo Finance dataset access
Google account for Sheets integration
Telegram bot token and chat ID

Step 1: Import the Workflow
Copy the provided JSON workflow code
In n8n: Go to Workflows → + Add workflow → Import from JSON
Paste the JSON content and click Import

Step 2: Configure Bright Data Integration

Set up Bright Data Credentials:
In n8n: Navigate to Credentials → + Add credential → HTTP Header Auth
Add Authorization header with value: Bearer BRIGHT_DATA_API_KEY
Replace BRIGHT_DATA_API_KEY with your actual API key
Test the connection to ensure it works properly

> Note: The workflow uses dataset ID gd_lmrpz3vxmz972ghd7 for Yahoo Finance data. Ensure you have access to this dataset in your Bright Data dashboard.

Step 3: Set up Google Sheets Integration

Create a Google Sheet:
Go to Google Sheets and create a new spreadsheet
Name it "Financial Data Tracker" or similar
Copy the Sheet ID from the URL

Configure Google Sheets credentials:
In n8n: Credentials → + Add credential → Google Sheets OAuth2 API
Complete OAuth setup and test connection

Update the workflow:
Open the "📊 Filtered Output & Save to Sheet" node
Replace YOUR_SHEET_ID with your actual Sheet ID
Select your Google Sheets credential

Step 4: Configure Telegram Bot

Set up Telegram Integration:
Create a Telegram bot using @BotFather
Get your bot token and chat ID
In n8n: Credentials → + Add credential → Telegram API
Enter your bot token
Update the "📤 Send Chart on Telegram" node with your chat ID
Replace YOUR_TELEGRAM_CHAT_ID with your actual chat ID

Step 5: Test and Activate

Test the workflow:
Use the form trigger with a test keyword (e.g., "AAPL")
Monitor the execution in n8n
Verify data appears in Google Sheets
Check for chart delivery on Telegram

Activate the workflow:
Turn on the workflow using the toggle switch
The form trigger will be accessible via the provided webhook URL

📋 Key Features

🔍 Keyword-Based Discovery: Search companies by keyword, ticker, or industry
💰 Comprehensive Financial Data: Market cap, stock prices, earnings, and company profiles
📊 Visual Charts: Automatic generation of market cap comparison charts
📱 Telegram Integration: Instant delivery of insights to your mobile device
💾 Data Storage: Automatic backup to Google Sheets for historical tracking
⚡ Real-time Processing: Fast data retrieval and processing with Bright Data

📊 Output Data Points

| Field | Description | Example |
|-------|-------------|---------|
| Company Name | Full company name | "Apple Inc." |
| Stock Ticker | Trading symbol | "AAPL" |
| Market Cap | Total market capitalization | "$2.89T" |
| Current Price | Latest stock price | "$189.25" |
| Exchange | Stock exchange | "NASDAQ" |
| Sector | Business sector | "Technology" |
| PE Ratio | Price to earnings ratio | "28.45" |
| 52 Week Range | Annual high and low prices | "$164.08 - $199.62" |

🔧 Troubleshooting

Common Issues

Bright Data Connection Failed:
Verify your API key is correct and active
Check dataset permissions in Bright Data dashboard
Ensure you have sufficient credits

Google Sheets Permission Denied:
Re-authenticate Google Sheets OAuth
Verify sheet sharing settings
Check if the Sheet ID is correct

Telegram Not Receiving Messages:
Verify bot token and chat ID
Check if bot is added to the chat
Test Telegram credentials manually

Performance Tips
Use specific keywords for better data accuracy
Monitor Bright Data usage to control costs
Set up error handling for failed requests
Consider rate limiting for high-volume usage

🎯 Use Cases

Investment Research:** Quick financial analysis of companies and sectors
Market Monitoring:** Track market cap changes and stock performance
Competitive Analysis:** Compare financial metrics across companies
Portfolio Management:** Monitor holdings and potential investments
Financial Reporting:** Generate automated financial insights for teams

🔗 Additional Resources

n8n Documentation
Bright Data Datasets
Google Sheets API
Telegram Bot API

For any questions or support, please contact:
[email protected]
or fill out this form: https://www.incrementors.com/contact-us/