HumationHuman + Automation
Back to Catalog

Real-time cryptocurrency price monitor with CoinGecko & multi-channel alerts

Oneclick AI SquadOneclick AI Squad
669 views
2/3/2026
NotificationSlackOpportunitySalesforceCRM
Official Page

This automated n8n workflow monitors real-time cryptocurrency prices using CoinGecko API and sends smart alerts when price conditions are met. It supports multi-coin tracking, dynamic conditions, and instant notifications via Email, Telegram, and Discord.

Good to Know

  • Reads crypto watchlist data from Google Sheets.
  • Monitors prices at defined intervals (24/7 monitoring).
  • Handles upper and lower price limits with direction-based alerts (above, below, both).
  • Implements cooldown logic to avoid duplicate alerts.
  • Updates last alert price and timestamp in Google Sheets.
  • Supports multiple alert channels: Email, Telegram, Discord.
  • Uses CoinGecko API for price data (Free tier supported).

How It Works

  1. 24/7 Crypto Trigger – Runs every minute (or custom interval) to check latest prices.

  2. Read Crypto Watchlist – Fetches symbols and conditions from Google Sheets.

  3. Parse Crypto Data – Converts Google Sheet data into structured JSON.

  4. Fetch Live Crypto Price – Uses CoinGecko API to get latest market price for each coin.

  5. Smart Crypto Alert Logic – Compares live price with upper/lower limits and evaluates conditions:

    • Above – Trigger alert if price > upper_limit.
    • Below – Trigger alert if price < lower_limit.
    • Both – Trigger alert if either condition is met.
    • Implements cooldown_minutes to prevent repeated alerts.

  6. Check Crypto Alert Conditions – Validates alerts before sending notifications.

  7. Send Crypto Email Alert – Sends email alert if condition is true.

  8. Send Telegram Crypto Alert – Sends Telegram alert.

  9. Send Discord Crypto Alert – Sends Discord alert.

  10. Update Crypto Alert History – Updates last_alert_price and last_alert_time in Google Sheet.

  11. Crypto Alert Status Check – Ensures alert process completed successfully.

  12. Success Notification – Sends confirmation message on success.

  13. Error Notification – Sends an error alert if something fails.

Google Sheet Columns (A-G)

| Column | Description | | ------ | ---------------------------------- | | A | symbol (BTC, ETH, SOL, etc.) | | B | upper_limit (e.g., 45000) | | C | lower_limit (e.g., 40000) | | D | direction (both / above / below) | | E | cooldown_minutes (e.g., 10) | | F | last_alert_price (auto-updated) | | G | last_alert_time (auto-updated) |

How to Use

  1. Import the workflow into n8n.

  2. Configure Google Sheets credentials and link your watchlist sheet.

  3. Add your CoinGecko API endpoint in the Fetch Price node (Free tier).

  4. Set up Email, Telegram, and Discord credentials for notifications.

  5. Test with sample data:

    • Example: BTC, upper_limit=45000, lower_limit=40000, direction=both.

  6. Execute the workflow and monitor alerts.

Requirements

  • n8n environment with execution permissions.

  • Google Sheets integration (with API credentials).

  • CoinGecko API (Free tier supported).

  • Notification channels:

    • Email (SMTP settings in n8n).
    • Telegram Bot Token.
    • Discord Webhook URL.

Customizing This Workflow

  • Add more coins in Google Sheet.
  • Modify alert conditions (e.g., percentage change, moving averages).
  • Add SMS or WhatsApp notifications.
  • Integrate with Slack or Microsoft Teams.
  • Use AI-based price predictions for smarter alerts.

Real-time Cryptocurrency Price Monitor with Multi-Channel Alerts

This n8n workflow provides a real-time cryptocurrency price monitoring system that fetches prices from CoinGecko and sends alerts to multiple channels (Email, Telegram, Discord) if a predefined price threshold is crossed. It also logs the fetched prices to a Google Sheet for historical tracking.

What it does

  1. Schedules Checks: Triggers at a regular interval (e.g., every 5 minutes) to fetch the latest cryptocurrency prices.
  2. Fetches Cryptocurrency Prices: Makes an HTTP request to the CoinGecko API to get the current price of a specified cryptocurrency (e.g., Bitcoin).
  3. Logs to Google Sheets: Appends the fetched cryptocurrency price and timestamp to a Google Sheet for historical data tracking.
  4. Evaluates Price Threshold: Compares the current cryptocurrency price against a predefined threshold.
  5. Sends Email Alert: If the price crosses the threshold, an email notification is sent to a specified recipient.
  6. Sends Telegram Alert: If the price crosses the threshold, a message is sent to a Telegram chat.
  7. Sends Discord Alert: If the price crosses the threshold, a message is sent to a Discord channel via a webhook.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • CoinGecko API: No API key is strictly required for basic public endpoints.
  • Google Sheets Account: A Google account with access to Google Sheets. You will need to create a new spreadsheet for logging.
  • Email Account: An SMTP server configured in n8n for sending emails.
  • Telegram Account: A Telegram bot token and chat ID for sending messages.
  • Discord Account: A Discord webhook URL for sending messages to a channel.

Setup/Usage

  1. Import the Workflow:
    • Copy the provided JSON code.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the "Import from JSON" button and paste the copied JSON.
  2. Configure Credentials:
    • Google Sheets: Set up a Google Sheets credential. You'll need to grant n8n access to your Google account.
    • Send Email: Configure your SMTP credentials for the "Send Email" node.
    • Telegram: Set up a Telegram credential with your bot token. You'll also need to specify the Chat ID in the node's settings.
    • Discord: Set up a Discord credential with your webhook URL.
  3. Customize Nodes:
    • Cron (Node ID: 7): Adjust the schedule as needed (e.g., every 5 minutes, every hour).
    • HTTP Request (Node ID: 19):
      • Verify the CoinGecko API URL to fetch the desired cryptocurrency. Example: https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd
      • Modify the Code node (Node ID: 834) to extract the correct price path from the CoinGecko API response.
    • Google Sheets (Node ID: 18):
      • Specify the Spreadsheet ID and Sheet Name where you want to log the data.
      • Ensure the data being sent (timestamp, price) matches your sheet columns.
    • Code (Node ID: 834): This node likely contains logic to extract the cryptocurrency price from the HTTP Request node's output and define the price threshold for alerts. Adjust the threshold as per your monitoring needs.
    • If (Node ID: 20): This node compares the fetched price with the threshold defined in the Code node. Review and adjust its conditions if necessary.
    • Send Email (Node ID: 11):
      • Set the To email address.
      • Customize the Subject and Body of the alert email.
    • Telegram (Node ID: 49):
      • Enter the Chat ID for your Telegram channel or user.
      • Customize the Text of the Telegram message.
    • Discord (Node ID: 60):
      • Ensure the correct Discord credential is selected.
      • Customize the Content of the Discord message.
  4. Activate the Workflow: Once all configurations are complete, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.

The workflow will now run on its defined schedule, monitor cryptocurrency prices, log them, and send alerts when your specified conditions are met.

Related Templates

Generate song lyrics and music from text prompts using OpenAI and Fal.ai Minimax

Spark your creativity instantly in any chat—turn a simple prompt like "heartbreak ballad" into original, full-length lyrics and a professional AI-generated music track, all without leaving your conversation. 📋 What This Template Does This chat-triggered workflow harnesses AI to generate detailed, genre-matched song lyrics (at least 600 characters) from user messages, then queues them for music synthesis via Fal.ai's minimax-music model. It polls asynchronously until the track is ready, delivering lyrics and audio URL back in chat. Crafts original, structured lyrics with verses, choruses, and bridges using OpenAI Submits to Fal.ai for melody, instrumentation, and vocals aligned to the style Handles long-running generations with smart looping and status checks Returns complete song package (lyrics + audio link) for seamless sharing 🔧 Prerequisites n8n account (self-hosted or cloud with chat integration enabled) OpenAI account with API access for GPT models Fal.ai account for AI music generation 🔑 Required Credentials OpenAI API Setup Go to platform.openai.com → API keys (sidebar) Click "Create new secret key" → Name it (e.g., "n8n Songwriter") Copy the key and add to n8n as "OpenAI API" credential type Test by sending a simple chat completion request Fal.ai HTTP Header Auth Setup Sign up at fal.ai → Dashboard → API Keys Generate a new API key → Copy it In n8n, create "HTTP Header Auth" credential: Name="Fal.ai", Header Name="Authorization", Header Value="Key [Your API Key]" Test with a simple GET to their queue endpoint (e.g., /status) ⚙️ Configuration Steps Import the workflow JSON into your n8n instance Assign OpenAI API credentials to the "OpenAI Chat Model" node Assign Fal.ai HTTP Header Auth to the "Generate Music Track", "Check Generation Status", and "Fetch Final Result" nodes Activate the workflow—chat trigger will appear in your n8n chat interface Test by messaging: "Create an upbeat pop song about road trips" 🎯 Use Cases Content Creators: YouTubers generating custom jingles for videos on the fly, streamlining production from idea to audio export Educators: Music teachers using chat prompts to create era-specific folk tunes for classroom discussions, fostering interactive learning Gift Personalization: Friends crafting anniversary R&B tracks from shared memories via quick chats, delivering emotional audio surprises Artist Brainstorming: Songwriters prototyping hip-hop beats in real-time during sessions, accelerating collaboration and iteration ⚠️ Troubleshooting Invalid JSON from AI Agent: Ensure the system prompt stresses valid JSON; test the agent standalone with a sample query Music Generation Fails (401/403): Verify Fal.ai API key has minimax-music access; check usage quotas in dashboard Status Polling Loops Indefinitely: Bump wait time to 45-60s for complex tracks; inspect fal.ai queue logs for bottlenecks Lyrics Under 600 Characters: Tweak agent prompt to enforce fuller structures like [V1][C][V2][B][C]; verify output length in executions

Daniel NkenchoBy Daniel Nkencho
601

Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct

Synchronize WooCommerce Inventory & Create Products with Gemini AI & BrowserAct This sophisticated n8n template automates WooCommerce inventory management by scraping supplier data, updating existing products, and intelligently creating new ones with AI-formatted descriptions. This workflow is essential for e-commerce operators, dropshippers, and inventory managers who need to ensure their product pricing and stock levels are synchronized with multiple third-party suppliers, minimizing overselling and maximizing profit. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. --- How it works The workflow is typically run by a Schedule Trigger (though a Manual Trigger is also shown) to check stock automatically. It reads a list of suppliers and their inventory page URLs from a central Google Sheet. The workflow loops through each supplier: A BrowserAct node scrapes the current stock and price data from the supplier's inventory page. A Code node parses this bulk data into individual product items. It then loops through each individual product found. The workflow checks WooCommerce to see if the product already exists based on its name. If the product exists: It proceeds to update the existing product's price and stock quantity. If the product DOES NOT exist: An If node checks if the missing product's category matches a predefined type (optional filtering). If it passes the filter, a second BrowserAct workflow scrapes detailed product attributes from a dedicated product page (e.g., DigiKey). An AI Agent (Gemini) transforms these attributes into a specific, styled HTML table for the product description. Finally, the product is created in WooCommerce with all scraped details and the AI-generated description. Error Handling: Multiple Slack nodes are configured to alert your team immediately if any scraping task fails or if the product update/creation process encounters an issue. Note: This workflow does not support image uploads for new products. To enable this functionality, you must modify both the n8n and BrowserAct workflows. --- Requirements BrowserAct API account for web scraping BrowserAct n8n Community Node -&gt; (n8n Nodes BrowserAct) BrowserAct templates named “WooCommerce Inventory & Stock Synchronization” and “WooCommerce Product Data Reconciliation” Google Sheets credentials for the supplier list WooCommerce credentials for product management Google Gemini account for the AI Agent Slack credentials for error alerts --- Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node --- Workflow Guidance and Showcase STOP Overselling! Auto-Sync WooCommerce Inventory from ANY Supplier

Madame AI Team | KaiBy Madame AI Team | Kai
600

Document RAG & chat agent: Google Drive to Qdrant with Mistral OCR

Knowledge RAG & AI Chat Agent: Google Drive to Qdrant Description This workflow transforms a Google Drive folder into an intelligent, searchable knowledge base and provides a chat agent to query it. It’s composed of two distinct flows: An ingestion pipeline to process documents. A live chat agent that uses RAG (Retrieval-Augmented Generation) and optional web search to answer user questions. This system fully automates the creation of a “Chat with your docs” solution and enhances it with external web-searching capabilities. --- Quick Implementation Steps Import the workflow JSON into your n8n instance. Set up credentials for Google Drive, Mistral AI, OpenAI, and Qdrant. Open the Web Search node and add your Tavily AI API key to the Authorization header. In the Google Drive (List Files) node, set the Folder ID you want to ingest. Run the workflow manually once to populate your Qdrant database (Flow 1). Activate the workflow to enable the chat trigger (Flow 2). Copy the public webhook URL from the When chat message received node and open it in a new tab to start chatting. --- What It Does The workflow is divided into two primary functions: Knowledge Base Ingestion (Manual Trigger) This flow populates your vector database. Scans Google Drive: Lists all files from a specified folder. Processes Files Individually: Downloads each file. Extracts Text via OCR: Uses Mistral AI OCR API for text extraction from PDFs, images, etc. Generates Smart Metadata: A Mistral LLM assigns metadata like documenttype, project, and assignedto. Chunks & Embeds: Text is cleaned, chunked, and embedded via OpenAI’s text-embedding-3-small model. Stores in Qdrant: Text chunks, embeddings, and metadata are stored in a Qdrant collection (docaiauto). AI Chat Agent (Chat Trigger) This flow powers the conversational interface. Handles User Queries: Triggered when a user sends a chat message. Internal RAG Retrieval: Searches Qdrant Vector Store first for answers. Web Search Fallback: If unavailable internally, the agent offers to perform a Tavily AI web search. Contextual Responses: Combines internal and external info for comprehensive answers. --- Who's It For Ideal for: Teams building internal AI knowledge bases from Google Drive. Developers creating AI-powered support, research, or onboarding bots. Organizations implementing RAG pipelines. Anyone making unstructured Google Drive documents searchable via chat. --- Requirements n8n instance (self-hosted or cloud). Google Drive Credentials (to list and download files). Mistral AI API Key (for OCR & metadata extraction). OpenAI API Key (for embeddings and chat LLM). Qdrant instance (cloud or self-hosted). Tavily AI API Key (for web search). --- How It Works The workflow runs two independent flows in parallel: Flow 1: Ingestion Pipeline (Manual Trigger) List Files: Fetch files from Google Drive using the Folder ID. Loop & Download: Each file is processed one by one. OCR Processing: Upload file to Mistral Retrieve signed URL Extract text using Mistral DOC OCR Metadata Extraction: Analyze text using a Mistral LLM. Text Cleaning & Chunking: Split into 1000-character chunks. Embeddings Creation: Use OpenAI embeddings. Vector Insertion: Push chunks + metadata into Qdrant. Flow 2: AI Chat Agent (Chat Trigger) Chat Trigger: Starts when a chat message is received. AI Agent: Uses OpenAI + Simple Memory to process context. RAG Retrieval: Queries Qdrant for related data. Decision Logic: Found → Form answer. Not found → Ask if user wants web search. Web Search: Performs Tavily web lookup. Final Response: Synthesizes internal + external info. --- How To Set Up Import the Workflow Upload the provided JSON into your n8n instance. Configure Credentials Create and assign: Google Drive → Google Drive nodes Mistral AI → Upload, Signed URL, DOC OCR, Cloud Chat Model OpenAI → Embeddings + Chat Model nodes Qdrant → Vector Store nodes Add Tavily API Key Open Web Search node → Parameters → Headers Add your key under Authorization (e.g., tvly-xxxx). Node Configuration Google Drive (List Files): Set Folder ID. Qdrant Nodes: Ensure same collection name (docaiauto). Run Ingestion (Flow 1) Click Test workflow to populate Qdrant with your Drive documents. Activate Chat (Flow 2) Toggle the workflow ON to enable real-time chat. Test Open the webhook URL and start chatting! --- How To Customize Change LLMs: Swap models in OpenAI or Mistral nodes (e.g., GPT-4o, Claude 3). Modify Prompts: Edit the system message in ai chat agent to alter tone or logic. Chunking Strategy: Adjust chunkSize and chunkOverlap in the Code node. Different Sources: Replace Google Drive with AWS S3, Local Folder, etc. Automate Updates: Add a Cron node for scheduled ingestion. Validation: Add post-processing steps after metadata extraction. Expand Tools: Add more functional nodes like Google Calendar or Calculator. --- Use Case Examples Internal HR Bot: Answer HR-related queries from stored policy docs. Tech Support Assistant: Retrieve troubleshooting steps for products. Research Assistant: Summarize and compare market reports. Project Management Bot: Query document ownership or project status. --- Troubleshooting Guide | Issue | Possible Solution | |------------|------------------------| | Chat agent doesn’t respond | Check OpenAI API key and model availability (e.g., gpt-4.1-mini). | | Known documents not found | Ensure ingestion flow ran and both Qdrant nodes use same collection name. | | OCR node fails | Verify Mistral API key and input file integrity. | | Web search not triggered | Re-check Tavily API key in Web Search node headers. | | Incorrect metadata | Tune Information Extractor prompt or use a stronger Mistral model. | --- 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. We can help you set it up for free — from connecting credentials to deploying it live. Contact: shilpa.raju@digitalbiz.tech Website: https://www.digitalbiz.tech LinkedIn: https://www.linkedin.com/company/digital-biz-tech/ You can also DM us on LinkedIn for any help. ---

DIGITAL BIZ TECHBy DIGITAL BIZ TECH
1409