HumationHuman + Automation
Back to Catalog

Extract market cap data from Yahoo Finance with Bright Data & visualize in Telegram

IncrementorsIncrementors
1390 views
2/3/2026
AWS S3IMAPAttachmentsEmailAWS SNS
Official Page

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

  1. Copy the provided JSON workflow code
  2. In n8n: Go to Workflows β†’ + Add workflow β†’ Import from JSON
  3. Paste the JSON content and click Import

Step 2: Configure Bright Data Integration

Set up Bright Data Credentials:

  1. In n8n: Navigate to Credentials β†’ + Add credential β†’ HTTP Header Auth
  2. Add Authorization header with value: Bearer BRIGHT_DATA_API_KEY
  3. Replace BRIGHT_DATA_API_KEY with your actual API key
  4. 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:

  1. Create a Telegram bot using @BotFather
  2. Get your bot token and chat ID
  3. In n8n: Credentials β†’ + Add credential β†’ Telegram API
  4. Enter your bot token
  5. Update the "πŸ“€ Send Chart on Telegram" node with your chat ID
  6. 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

For any questions or support, please contact:
info@incrementors.com
or fill out this form: https://www.incrementors.com/contact-us/

n8n Form to Telegram with Data Extraction and Conditional Logic

This n8n workflow simplifies the process of receiving form submissions, extracting specific data, and conditionally notifying a Telegram channel. It's designed to automate responses based on the values submitted through a simple form.

What it does

This workflow automates the following steps:

  1. Listens for Form Submissions: It is triggered whenever a new form is submitted via the n8n Form Trigger.
  2. Extracts Data (Code Node): A Code node processes the incoming form data, likely extracting specific fields or transforming the data as needed.
  3. Conditional Logic (If Node): It evaluates the processed data using an If node. This node checks if a certain condition is met (e.g., a specific value in a form field).
  4. Sends Telegram Notification (Conditional):
    • If the condition in the "If" node evaluates to true, it sends a message to a configured Telegram chat.
    • If the condition evaluates to false, the workflow proceeds to the "Wait" node.
  5. Waits (Conditional): If the condition in the "If" node is false, the workflow pauses for a specified duration using the "Wait" node.
  6. Makes an HTTP Request: After the conditional wait (or immediately if the "If" condition was true), it makes an HTTP request. This could be used for various purposes like sending data to another API, triggering an external service, or fetching additional information.
  7. Writes to Google Sheets: Finally, it writes the processed data to a Google Sheet, likely for logging or further analysis.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n instance: A running n8n instance to import and execute the workflow.
  • Telegram Bot Token and Chat ID: For sending notifications to Telegram.
  • Google Sheets Credentials: To write data to a Google Sheet.
  • Bright Data Account (Implied by directory name, not explicit in JSON): While not explicitly defined in the JSON nodes, the directory name "6489-extract-market-cap-data-from-yahoo-finance-with-bright-data--visualize-in-telegram" suggests that an external service like Bright Data might be used in the HTTP Request node for web scraping or data extraction from sources like Yahoo Finance. You might need credentials for this service.

Setup/Usage

  1. Import the workflow: Download the JSON provided and import it into your n8n instance.
  2. Configure Credentials:
    • Telegram: Set up your Telegram Bot credential in n8n.
    • Google Sheets: Set up your Google Sheets credential in n8n.
  3. Configure the "n8n Form Trigger" node:
    • Activate the trigger by clicking "Activate" in the node settings.
    • Copy the webhook URL provided by the node and use it as the submission endpoint for your form.
  4. Configure the "Code" node:
    • Review and modify the JavaScript code to extract and transform the specific data fields you need from your form submissions.
  5. Configure the "If" node:
    • Define the condition(s) that will determine whether a Telegram message is sent. This will depend on the data extracted in the "Code" node.
  6. Configure the "Telegram" node:
    • Select your Telegram Bot credential.
    • Specify the Chat ID where messages should be sent.
    • Customize the message text using expressions to include data from the form submission.
  7. Configure the "Wait" node:
    • Adjust the duration for which the workflow should pause if the "If" condition is false.
  8. Configure the "HTTP Request" node:
    • Set the URL, method, headers, and body for your HTTP request. This is where you would integrate with services like Bright Data or other APIs.
  9. Configure the "Google Sheets" node:
    • Select your Google Sheets credential.
    • Specify the Spreadsheet ID and Sheet Name.
    • Map the data from your workflow to the columns in your Google Sheet.
  10. Activate the workflow: Once all nodes are configured, activate the workflow to start processing form submissions.

Related Templates

AI multi-agent executive team for entrepreneurs with Gemini, Perplexity and WhatsApp

This workflow is an AI-powered multi-agent system built for startup founders and small business owners who want to automate decision-making, accountability, research, and communication, all through WhatsApp. The β€œvirtual executive team,” is designed to help small teams to work smarter. This workflow sends you market analysis, market and sales tips, It can also monitor what your competitors are doing using perplexity (Research agent) and help you stay a head, or make better decisions. And when you feeling stuck with your start-up accountability director is creative enough to break the barrier 🎯 Core Features πŸ§‘β€πŸ’Ό 1. President (Super Agent) Acts as the main controller that coordinates all sub-agents. Routes messages, assigns tasks, and ensures workflow synchronization between the AI Directors. πŸ“Š 2. Sales & Marketing Director Uses SerpAPI to search for market opportunities, leads, and trends. Suggests marketing campaigns, keywords, or outreach ideas. Can analyze current engagement metrics to adjust content strategy. πŸ•΅οΈβ€β™€οΈ 3. Business Research Director Powered by Perplexity AI for competitive and market analysis. Monitors competitor moves, social media engagement, and product changes. Provides concise insights to help the founder adapt and stay ahead. ⏰ 4. Accountability Director Keeps the founder and executive team on track. Sends motivational nudges, task reminders, and progress reports. Promotes consistency and discipline β€” key traits for early-stage success. πŸ—“οΈ 5. Executive Secretary Handles scheduling, email drafting, and reminders. Connects with Google Calendar, Gmail, and Sheets through OAuth. Automates follow-ups, meeting summaries, and notifications directly via WhatsApp. πŸ’¬ WhatsApp as the Main Interface Interact naturally with your AI team through WhatsApp Business API. All responses, updates, and summaries are delivered to your chat. Ideal for founders who want to manage operations on the go. βš™οΈ How It Works Trigger: The workflow starts from a WhatsApp Trigger node (via Meta Developer Account). Routing: The President agent analyzes the incoming message and determines which Director should handle it. Processing: Marketing or sales queries go to the Sales & Marketing Director. Research questions are handled by the Business Research Director. Accountability tasks are assigned to the Accountability Director. Scheduling or communication requests are managed by the Secretary. Collaboration: Each sub-agent returns results to the President, who summarizes and sends the reply back via WhatsApp. Memory: Context is maintained between sessions, ensuring personalized and coherent communication. 🧩 Integrations Required Gemini API – for general intelligence and task reasoning Supabase- for RAG and postgres persistent memory Perplexity API – for business and competitor analysis SerpAPI – for market research and opportunity scouting Google OAuth – to connect Sheets, Calendar, and Gmail WhatsApp Business API – for message triggers and responses πŸš€ Benefits Acts like a team of tireless employees available 24/7. Saves time by automating research, reminders, and communication. Enhances accountability and strategy consistency for founders. Keeps operations centralized in a simple WhatsApp interface. 🧰 Setup Steps Create API credentials for: WhatsApp (via Meta Developer Account) Gemini, Perplexity, and SerpAPI Google OAuth (Sheets, Calendar, Gmail) Create a supabase account at supabase Add the credentials in the corresponding n8n nodes. Customize the system prompts for each Director based on your startup’s needs. Activate and start interacting with your virtual executive team on WhatsApp. Use Case You are a small organisation or start-up that can not afford hiring; marketing department, research department and secretar office, then this workflow is for you πŸ’‘ Need Customization? Want to tailor it for your startup or integrate with CRM tools like Notion or HubSpot? You can easily extend the workflow or contact the creator for personalized support. Consider adjusting the system prompt to suite your business

ShadrackBy Shadrack
331

Automated YouTube video uploads with 12h interval scheduling in JST

This workflow automates a batch upload of multiple videos to YouTube, spacing each upload 12 hours apart in Japan Standard Time (UTC+9) and automatically adding them to a playlist. βš™οΈ Workflow Logic Manual Trigger β€” Starts the workflow manually. List Video Files β€” Uses a shell command to find all .mp4 files under the specified directory (/opt/downloads/单词卑/A1-A2). Sort and Generate Items β€” Sorts videos by day number (dayXX) extracted from filenames and assigns a sequential order value. Calculate Publish Schedule (+12h Interval) β€” Computes the next rounded JST hour plus a configurable buffer (default 30 min). Staggers each video’s scheduled time by order Γ— 12 hours. Converts JST back to UTC for YouTube’s publishAt field. Split in Batches (1 per video) β€” Iterates over each video item. Read Video File β€” Loads the corresponding video from disk. Upload to YouTube (Scheduled) β€” Uploads the video privately with the computed publishAtUtc. Add to Playlist β€” Adds the newly uploaded video to the target playlist. πŸ•’ Highlights Timezone-safe: Pure UTC ↔ JST conversion avoids double-offset errors. Sequential scheduling: Ensures each upload is 12 hours apart to prevent clustering. Customizable: Change SPANHOURS, BUFFERMIN, or directory paths easily. Retry-ready: Each upload and playlist step has retry logic to handle transient errors. πŸ’‘ Typical Use Cases Multi-part educational video series (e.g., A1–A2 English learning). Regular content release cadence without manual scheduling. Automated YouTube publishing pipelines for pre-produced content. --- Author: Zane Category: Automation / YouTube / Scheduler Timezone: JST (UTC+09:00)

ZaneBy Zane
226

Monitor bank transactions with multi-channel alerts for accounting teams

Enhance financial oversight with this automated n8n workflow. Triggered every 5 minutes, it fetches real-time bank transactions via an API, enriches and transforms the data, and applies smart logic to detect critical, high, and medium priority alerts based on error conditions, amounts, or risk scores. It sends multi-channel notifications via email and Slack, logs all data to Google Sheets, and generates summary statistics for comprehensive tracking. πŸ’°πŸš¨ Key Features Real-time monitoring every 5 minutes for instant alerts. Smart prioritization (Critical, High, Medium) based on risk and errors. Multi-channel notifications via email and Slack. Detailed logging and summary reports in Google Sheets. How It Works Schedule Trigger: Runs every 5 minutes. Fetch Transactions: HTTP request retrieves real-time transaction data. API Error?: If condition for error logic is met, sends error alert. Enrich & Transform Data: Advanced risk calculation enhances data. Critical Alert?: If condition (50% or risk > 8) is met, raises alert. High Priority?: If condition (5% or risk > 7) is met, raises alert. Medium Priority?: If condition is met, raises alert. Log Priority to Sheet: Google Sheets appends critical, high, or medium priority data. Send Critical Email: HTML email to execute sheets append. Send High Priority Email: Email to finance team. Send High Priority Slack: Slack notification to finance team. Send Medium Priority Email: Email to finance team. Merge All Alerts: Combines all alerts for comprehensive tracking. Generate Summary Stats: Code block for analytics. Log Summary to Sheet: Summary statistics storage. Setup Instructions Import the workflow into n8n and configure the bank API credentials in "Fetch Transactions." Set up Google Sheets OAuth2 and replace the sheet ID for logging nodes. Configure Gmail API Key and Slack Bot Token for alerts. Test the workflow with sample transaction data exceeding risk or amount thresholds. Adjust priority conditions (e.g., 50%, 5%, risk > 8) based on your risk policy. Prerequisites Bank API access with real-time transaction data (e.g., https://api.bank.com) Google Sheets OAuth2 credentials Gmail API Key for email alerts Slack Bot Token (with chat:write permissions) Structured transaction data format Google Sheet Structure: Create a sheet with columns: Transaction ID Amount Date Risk Score Priority (Critical/High/Medium) Alert Sent Summary Stats Updated At Modification Options Adjust the "Schedule Trigger" interval (e.g., every 10 minutes). Modify "Critical Alert?" and "High Priority?" conditions for custom thresholds. Customize email and Slack templates with branded messaging. Integrate with fraud detection tools for enhanced risk analysis. Enhance "Generate Summary Stats" with additional metrics (e.g., average risk). Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
333