HumationHuman + Automation
Back to Catalog

Real-time stock monitor with smart alerts for Indian & US markets

Oneclick AI SquadOneclick AI Squad
4734 views
2/3/2026
JavaScriptData ExtractionNotionDatabaseAPI
Official Page

Monitor Indian (NSE/BSE) and US stock markets with intelligent price alerts, cooldown periods, and multi-channel notifications (Email + Telegram). Automatically tracks price movements and sends alerts when stocks cross predefined upper/lower limits.

Perfect for day traders, investors, and portfolio managers who need instant notifications for price breakouts and breakdowns.

How It Works

Market Hours Trigger - Runs every 2 minutes during market hours Read Stock Watchlist - Fetches your stock list from Google Sheets Parse Watchlist Data - Processes stock symbols and alert parameters Fetch Live Stock Price - Gets real-time prices from Twelve Data API Smart Alert Logic - Intelligent price checking with cooldown periods Check Alert Conditions - Validates if alerts should be triggered Send Email Alert - Sends detailed email notifications Send Telegram Alert - Instant mobile notifications Update Alert History - Records alert timestamps in Google Sheets Alert Status Check - Monitors workflow success/failure Success/Error Notifications - Admin notifications for monitoring

Key Features:

  • Smart Cooldown: Prevents alert spam
  • Multi-Market: Supports Indian & US stocks
  • Dual Alerts: Email + Telegram notifications
  • Auto-Update: Tracks last alert times
  • Error Handling: Built-in failure notifications

Setup Requirements:

1. Google Sheets Setup:

Create a Google Sheet with these columns (in exact order):

  • A: symbol (e.g., TCS, AAPL, RELIANCE.BSE)
  • B: upper_limit (e.g., 4000)
  • C: lower_limit (e.g., 3600)
  • D: direction (both/above/below)
  • E: cooldown_minutes (e.g., 15)
  • F: last_alert_price (auto-updated)
  • G: last_alert_time (auto-updated)

2. API Keys & IDs to Replace:

  • YOUR_GOOGLE_SHEET_ID_HERE - Replace with your Google Sheet ID
  • YOUR_TWELVE_DATA_API_KEY - Get free API key from twelvedata.com
  • YOUR_TELEGRAM_CHAT_ID - Your Telegram chat ID (optional)
  • your-email@gmail.com - Your sender email
  • alert-recipient@gmail.com - Alert recipient email

3. Stock Symbol Format:

  • US Stocks: Use simple symbols like AAPL, TSLA, MSFT
  • Indian Stocks: Use .BSE or .NSE suffix like TCS.NSE, RELIANCE.BSE

4. Credentials Setup in n8n:

  • Google Sheets: Service Account credentials
  • Email: SMTP credentials
  • Telegram: Bot token (optional)

Example Google Sheet Data:

symbol          upper_limit  lower_limit  direction  cooldown_minutes
TCS.NSE         4000         3600         both       15
AAPL            180          160          both       10
RELIANCE.BSE    2800         2600         above      20

Output Example:

Alert: TCS crossed the upper limit. Current Price: ₹4100, Upper Limit: ₹4000.

Real-Time Stock Monitor with Smart Alerts for Indian & US Markets

This n8n workflow provides a robust solution for real-time stock monitoring, allowing you to track stock prices from both Indian and US markets and receive smart alerts via Telegram and email when predefined conditions are met. It simplifies the process of staying informed about your investments without constant manual checking.

What it does

This workflow automates the following steps:

  1. Schedules Execution: Triggers periodically (e.g., every 5 minutes during market hours) using the Cron node.
  2. Fetches Stock Data: Retrieves stock data from a Google Sheet, which acts as your watchlist for both Indian and US market stocks.
  3. Makes API Calls: For each stock in the watchlist, it makes an HTTP request to a stock API (e.g., Finnhub, Alpha Vantage, or a custom API) to fetch the latest price and other relevant data.
  4. Processes Stock Data: Uses a Code node to parse the API response and extract the current stock price and other necessary details.
  5. Evaluates Conditions: Checks if the current stock price meets predefined alert conditions (e.g., price crosses a threshold, percentage change).
  6. Sends Smart Alerts:
    • If a condition is met, it sends a detailed alert message to a specified Telegram chat.
    • Additionally, it sends an email notification with the alert details.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance (self-hosted or cloud).
  • Google Sheets Account: A Google Sheet containing your stock watchlist, including stock symbols, target prices, and market (Indian/US).
  • Stock Market API Key: An API key for a stock market data provider (e.g., Finnhub, Alpha Vantage, Yahoo Finance API, or a custom API that provides real-time stock data).
  • Telegram Account & Bot Token: A Telegram bot and its API token to send messages. You'll also need the chat ID where you want to receive alerts.
  • SMTP Server Details: Credentials for an SMTP server to send email notifications.

Setup/Usage

  1. Import the Workflow:
    • Download the provided JSON file.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
  2. Configure Credentials:
    • Google Sheets: Set up a Google Sheets credential. Ensure n8n has access to the specific Google Sheet you'll be using for your watchlist.
    • HTTP Request (Stock API): Configure the HTTP Request node with your chosen stock API endpoint and API key. You might need to adjust headers or query parameters based on your API provider's documentation.
    • Telegram: Set up a Telegram credential with your bot token.
    • Send Email: Configure an SMTP credential with your email server details.
  3. Prepare Google Sheet Watchlist:
    • Create a Google Sheet with columns for Symbol, Market (e.g., "IN" for India, "US" for United States), TargetPriceHigh, TargetPriceLow, etc.
    • Populate this sheet with the stocks you wish to monitor.
  4. Customize Alert Logic:
    • Code Node: Modify the "Code" node to parse the specific JSON response structure from your chosen stock API and extract the current price. You'll also define the logic for comparing the current price against your target prices from the Google Sheet.
    • If Node: Adjust the conditions in the "If" node to trigger alerts based on your desired criteria (e.g., currentPrice > TargetPriceHigh or currentPrice < TargetPriceLow).
  5. Configure Alert Messages:
    • Telegram Node: Customize the message content in the "Telegram" node to include relevant stock details (symbol, current price, alert type).
    • Send Email Node: Customize the subject and body of the email in the "Send Email" node for clear and informative alerts.
  6. Activate the Workflow:
    • Ensure the "Cron" node is configured to run at your desired intervals (e.g., every 5 minutes during market hours).
    • Activate the workflow to start monitoring your stocks.

Related Templates

Track competitor SEO keywords with Decodo + GPT-4.1-mini + Google Sheets

This workflow automates competitor keyword research using OpenAI LLM and Decodo for intelligent web scraping. Who this is for SEO specialists, content strategists, and growth marketers who want to automate keyword research and competitive intelligence. Marketing analysts managing multiple clients or websites who need consistent SEO tracking without manual data pulls. Agencies or automation engineers using Google Sheets as an SEO data dashboard for keyword monitoring and reporting. What problem this workflow solves Tracking competitor keywords manually is slow and inconsistent. Most SEO tools provide limited API access or lack contextual keyword analysis. This workflow solves that by: Automatically scraping any competitor’s webpage with Decodo. Using OpenAI GPT-4.1-mini to interpret keyword intent, density, and semantic focus. Storing structured keyword insights directly in Google Sheets for ongoing tracking and trend analysis. What this workflow does Trigger — Manually start the workflow or schedule it to run periodically. Input Setup — Define the website URL and target country (e.g., https://dev.to, france). Data Scraping (Decodo) — Fetch competitor web content and metadata. Keyword Analysis (OpenAI GPT-4.1-mini) Extract primary and secondary keywords. Identify focus topics and semantic entities. Generate a keyword density summary and SEO strength score. Recommend optimization and internal linking opportunities. Data Structuring — Clean and convert GPT output into JSON format. Data Storage (Google Sheets) — Append structured keyword data to a Google Sheet for long-term tracking. Setup Prerequisites If you are new to Decode, please signup on this link visit.decodo.com n8n account with workflow editor access Decodo API credentials OpenAI API key Google Sheets account connected via OAuth2 Make sure to install the Decodo Community node. Create a Google Sheet Add columns for: primarykeywords, seostrengthscore, keyworddensity_summary, etc. Share with your n8n Google account. Connect Credentials Add credentials for: Decodo API credentials - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard OpenAI API (for GPT-4o-mini) Google Sheets OAuth2 Configure Input Fields Edit the “Set Input Fields” node to set your target site and region. Run the Workflow Click Execute Workflow in n8n. View structured results in your connected Google Sheet. How to customize this workflow Track Multiple Competitors → Use a Google Sheet or CSV list of URLs; loop through them using the Split In Batches node. Add Language Detection → Add a Gemini or GPT node before keyword analysis to detect content language and adjust prompts. Enhance the SEO Report → Expand the GPT prompt to include backlink insights, metadata optimization, or readability checks. Integrate Visualization → Connect your Google Sheet to Looker Studio for SEO performance dashboards. Schedule Auto-Runs → Use the Cron Node to run weekly or monthly for competitor keyword refreshes. Summary This workflow automates competitor keyword research using: Decodo for intelligent web scraping OpenAI GPT-4.1-mini for keyword and SEO analysis Google Sheets for live tracking and reporting It’s a complete AI-powered SEO intelligence pipeline ideal for teams that want actionable insights on keyword gaps, optimization opportunities, and content focus trends, without relying on expensive SEO SaaS tools.

Ranjan DailataBy Ranjan Dailata
161

Auto-reply & create Linear tickets from Gmail with GPT-5, gotoHuman & human review

This workflow automatically classifies every new email from your linked mailbox, drafts a personalized reply, and creates Linear tickets for bugs or feature requests. It uses a human-in-the-loop with gotoHuman and continuously improves itself by learning from approved examples. How it works The workflow triggers on every new email from your linked mailbox. Self-learning Email Classifier: an AI model categorizes the email into defined categories (e.g., Bug Report, Feature Request, Sales Opportunity, etc.). It fetches previously approved classification examples from gotoHuman to refine decisions. Self-learning Email Writer: the AI drafts a reply to the email. It learns over time by using previously approved replies from gotoHuman, with per-classification context to tailor tone and style (e.g., different style for sales vs. bug reports). Human Review in gotoHuman: review the classification and the drafted reply. Drafts can be edited or retried. Approved values are used to train the self-learning agents. Send approved Reply: the approved response is sent as a reply to the email thread. Create ticket: if the classification is Bug or Feature Request, a ticket is created by another AI agent in Linear. Human Review in gotoHuman: How to set up Most importantly, install the gotoHuman node before importing this template! (Just add the node to a blank canvas before importing) Set up credentials for gotoHuman, OpenAI, your email provider (e.g. Gmail), and Linear. In gotoHuman, select and create the pre-built review template "Support email agent" or import the ID: 6fzuCJlFYJtlu9mGYcVT. Select this template in the gotoHuman node. In the "gotoHuman: Fetch approved examples" http nodes you need to add your formId. It is the ID of the review template that you just created/imported in gotoHuman. Requirements gotoHuman (human supervision, memory for self-learning) OpenAI (classification, drafting) Gmail or your preferred email provider (for email trigger+replies) Linear (ticketing) How to customize Expand or refine the categories used by the classifier. Update the prompt to reflect your own taxonomy. Filter fetched training data from gotoHuman by reviewer so the writer adapts to their personalized tone and preferences. Add more context to the AI email writer (calendar events, FAQs, product docs) to improve reply quality.

gotoHumanBy gotoHuman
353

Ai website scraper & company intelligence

AI Website Scraper & Company Intelligence Description This workflow automates the process of transforming any website URL into a structured, intelligent company profile. It's triggered by a form, allowing a user to submit a website and choose between a "basic" or "deep" scrape. The workflow extracts key information (mission, services, contacts, SEO keywords), stores it in a structured Supabase database, and archives a full JSON backup to Google Drive. It also features a secondary AI agent that automatically finds and saves competitors for each company, building a rich, interconnected database of company intelligence. --- Quick Implementation Steps Import the Workflow: Import the provided JSON file into your n8n instance. Install Custom Community Node: You must install the community node from: https://www.npmjs.com/package/n8n-nodes-crawl-and-scrape FIRECRAWL N8N Documentation https://docs.firecrawl.dev/developer-guides/workflow-automation/n8n Install Additional Nodes: n8n-nodes-crawl-and-scrape and n8n-nodes-mcp fire crawl mcp . Set up Credentials: Create credentials in n8n for FIRE CRAWL API,Supabase, Mistral AI, and Google Drive. Configure API Key (CRITICAL): Open the Web Search tool node. Go to Parameters → Headers and replace the hardcoded Tavily AI API key with your own. Configure Supabase Nodes: Assign your Supabase credential to all Supabase nodes. Ensure table names (e.g., companies, competitors) match your schema. Configure Google Drive Nodes: Assign your Google Drive credential to the Google Drive2 and save to Google Drive1 nodes. Select the correct Folder ID. Activate Workflow: Turn on the workflow and open the Webhook URL in the “On form submission” node to access the form. --- What It Does Form Trigger Captures user input: “Website URL” and “Scraping Type” (basic or deep). Scraping Router A Switch node routes the flow: Deep Scraping → AI-based MCP Firecrawler agent. Basic Scraping → Crawlee node. Deep Scraping (Firecrawl AI Agent) Uses Firecrawl and Tavily Web Search. Extracts a detailed JSON profile: mission, services, contacts, SEO keywords, etc. Basic Scraping (Crawlee) Uses Crawl and Scrape node to collect raw text. A Mistral-based AI extractor structures the data into JSON. Data Storage Stores structured data in Supabase tables (companies, company_basicprofiles). Archives a full JSON backup to Google Drive. Automated Competitor Analysis Runs after a deep scrape. Uses Tavily web search to find competitors (e.g., from Crunchbase). Saves competitor data to Supabase, linked by company_id. --- Who's It For Sales & Marketing Teams: Enrich leads with deep company info. Market Researchers: Build structured, searchable company databases. B2B Data Providers: Automate company intelligence collection. Developers: Use as a base for RAG or enrichment pipelines. --- Requirements n8n instance (self-hosted or cloud) Supabase Account: With tables like companies, competitors, social_links, etc. Mistral AI API Key Google Drive Credentials Tavily AI API Key (Optional) Custom Nodes: n8n-nodes-crawl-and-scrape --- How It Works Flow Summary Form Trigger: Captures “Website URL” and “Scraping Type”. Switch Node: deep → MCP Firecrawler (AI Agent). basic → Crawl and Scrape node. Scraping & Extraction: Deep path: Firecrawler → JSON structure. Basic path: Crawlee → Mistral extractor → JSON. Storage: Save JSON to Supabase. Archive in Google Drive. Competitor Analysis (Deep Only): Finds competitors via Tavily. Saves to Supabase competitors table. End: Finishes with a No Operation node. --- How To Set Up Import workflow JSON. Install community nodes (especially n8n-nodes-crawl-and-scrape from npm). Configure credentials (Supabase, Mistral AI, Google Drive). Add your Tavily API key. Connect Supabase and Drive nodes properly. Fix disconnected “basic” path if needed. Activate workflow. Test via the webhook form URL. --- How To Customize Change LLMs: Swap Mistral for OpenAI or Claude. Edit Scraper Prompts: Modify system prompts in AI agent nodes. Change Extraction Schema: Update JSON Schema in extractor nodes. Fix Relational Tables: Add Items node before Supabase inserts for arrays (social links, keywords). Enhance Automation: Add email/slack notifications, or replace form trigger with a Google Sheets trigger. --- Add-ons Automated Trigger: Run on new sheet rows. Notifications: Email or Slack alerts after completion. RAG Integration: Use the Supabase database as a chatbot knowledge source. --- Use Case Examples Sales Lead Enrichment: Instantly get company + competitor data from a URL. Market Research: Collect and compare companies in a niche. B2B Database Creation: Build a proprietary company dataset. --- WORKFLOW IMAGE --- Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|-----------| | Form Trigger 404 | Workflow not active | Activate the workflow | | Web Search Tool fails | Missing Tavily API key | Replace the placeholder key | | FIRECRAWLER / find competitor fails | Missing MCP node | Install n8n-nodes-mcp | | Basic scrape does nothing | Switch node path disconnected | Reconnect “basic” output | | Supabase node error | Wrong table/column names | Match schema exactly | --- Need Help or More Workflows? Want to customize this workflow for your business or integrate it with your existing tools? Our team at Digital Biz Tech can tailor it precisely to your use case from automation logic to AI-powered enhancements. Contact: shilpa.raju@digitalbiz.tech For more such offerings, visit us: https://www.digitalbiz.tech ---

DIGITAL BIZ TECHBy DIGITAL BIZ TECH
923