# templates

name: Automated Range Trading with Uniswap V3, Telegram Alerts & MetaMask Delegation
author_name: 1Shot API
author_username: oneshotapi
categories: []
created_at: 2025-09-09T18:08:54.617Z
updated_at: 2025-09-09T18:08:54.617Z
url: https://n8n.io/workflows/8427
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  Simple Range Trading w/ Uniswap V3

  This workflow will monitor the price of a token trading pair (default is ETH - USDC) and automatically buy into ETH or sell into USDC based on a price window configured by the user. 

  Additionally, the workflow will notify the user on Telegram before a trade is executed, giving the user 1 minute to cancel the trade before the workflow proceeds. 

  Transaction are executed via MetaMask's Delegation Framework, so trades are fully non-custodial, you retain full control of your assets at all times. 

  Check out the YouTube tutorial for a full walkthrough.

  Maintain Complete Trading Control with MetaMask Delegations

  With the MetaMask Delegation Framework, you never relinquish control of your funds to any 3rd party, not even 1Shot API. Furthermore, with this workflow, you have full control of your trading parameters and the assets you trade against. Lastly, by running your own trading setup, you can bypass fees incurred through centralized exchanges or hosted frontends that reduce your profitability. 

  Human-in-the-Loop with Telegram Notifiactions

  This workflow uses Telegram to send you real-time updates on whats happening with your trades. Specifically, the Telegram human-in-the-loop node is used to give you a change to cancel trades before they happen or immediately approve them. 

  Setup

  Create a free 1Shot API account, and create an API key.
  Import the workflow into your n8n portal.
  Create a credential for the 1Shot API nodes to communicate with your 1Shot API account.
  Trigger the sub-workflow to generate an Arbitrum server wallet and import all required smart contract methods. 
  Point the 1Shot API nodes at the appropriate smart contract methods in you 1Shot API account.
  Create a Telegram credential for notifications & input the chatID of your Telegram bot.
  Set your desired trading price range in the Swap Configs node.
  Start your trading workflow.

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-1shot.oneShot","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-1shot.oneShot","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-1shot.oneShotSynch","n8n-nodes-1shot.oneShotSynch","n8n-nodes-1shot.oneShotSynch","n8n-nodes-1shot.oneShotSynch","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-1shot.oneShot","n8n-nodes-base.manualTrigger","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-1shot.oneShot","n8n-nodes-base.if","n8n-nodes-1shot.oneShot","n8n-nodes-base.code","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 10644 characters]

metadata_json:
  {"categories":["FinTech","DeFi","Trading"],"complexity":"medium","use_cases":["monitor cryptocurrency prices","execute automated trades","set price alerts","manage risk with stop-loss"],"estimated_setup_minutes":30,"required_services":["Uniswap","Telegram","MetaMask","Ethereum Blockchain","JSON-RPC"],"key_features":["non-custodial trading","telegram integration","price range monitoring","auto-execution on price breach"],"target_audience":["crypto traders","DeFi developers","trading enthusiasts"]}


name: Create Viral Ads with AI: NanoBanana & publish on socials via upload-post
author_name: Dr. Firas
author_username: drfiras
categories: []
created_at: 2025-09-09T18:30:50.820Z
updated_at: 2025-09-09T18:30:50.820Z
url: https://n8n.io/workflows/8428
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:20
description:
  💥 Create viral Ads with NanoBanana & Seedance, publish on socials via upload-post

  Who is this for?  
  This workflow is designed for marketers, content creators, and small businesses who want to automate the creation of engaging social media ads without spending hours on manual design, video editing, or publishing.

  What problem is this workflow solving? / Use case  
  Manually creating ads for multiple platforms is time-consuming and repetitive. You need to generate visuals, edit videos, add music, and then publish them across social channels.  
  This workflow automates the end-to-end ad production pipeline, saving time while ensuring consistent, professional-quality output.

  What this workflow does  
  Receives ad ideas via Telegram.  
  Uses NanoBanana to generate and edit realistic product images.  
  Transforms images into engaging short videos with Seedance.  
  Generates background music with Suno.  
  Merges video and audio into a polished final ad.  
  Reads brand info and generates ad copy with AI (OpenAI).  
  Publishes ads to Instagram, TikTok, YouTube, Facebook, and X via upload-post.  
  Stores media and campaign data in Google Drive and Google Sheets for tracking.  
  Sends back notifications and previews via Telegram.

  Setup  
  Connect your accounts:  
     Telegram  
     Google Drive  
     Google Sheets  
     OpenAI API  
     NanoBanana API  
     Seedance API  
     Suno API  
     Upload-post  

  Prepare Google Sheets:  
     Add a sheet for brand details (name, category, features, website).  
     Add another sheet for video logs (status, links, captions).  

  Configure upload-post:  
     Ensure your social accounts (TikTok, Instagram, YouTube, Facebook, X) are linked to upload-post.  

  How to customize this workflow to your needs  
  Prompts* → Adjust the *image/video/music prompts** to better reflect your brand’s tone and products.  
  Ad copy* → Modify the AI prompt inside the *Ads Copywriter Generator** to control wording, style, and structure.  
  Publishing scope* → Choose only the platforms you want (TikTok, Instagram, etc.) inside the *upload-post** node.  
  Storage** → Update Google Drive folder IDs and Google Sheets document IDs to match your own workspace.  

  👉 With this template, you get a fully automated viral ad production system powered by AI visuals, video rendering, and auto-publishing across social platforms. Perfect for scaling your content strategy while saving time.


  📄 Documentation: Notion Guide

  Demo Video

  🎥 Watch the full tutorial here: YouTube Demo
  Need help customizing?
  Contact me for consulting and support : Linkedin / Youtube

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.telegramTrigger","n8n-nodes-base.googleDrive","n8n-nodes-base.code","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-upload-post.uploadPost","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-upload-post.uploadPost","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 11664 characters]

metadata_json:
  {"categories":["Marketing"],"complexity":"medium","use_cases":[],"estimated_setup_minutes":30,"required_services":["NanoBanana","Seedance","telegram","googleDrive"],"key_features":["automated ad design","social media scheduling","media generation","cross-platform publishing"],"target_audience":["marketers","content creators","small business owners"]}


name: AI Video Automation Engine - Generate & Publish YT Shorts with Veo-3 or Sora 2
author_name: SuS
author_username: sulieman-said
categories: []
created_at: 2025-09-09T19:02:30.830Z
updated_at: 2025-09-09T19:02:30.830Z
url: https://n8n.io/workflows/8429
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:20
description:
  Product Overview

  Scale short-form content without scaling your team. This template turns idea discovery → prompt & text generation → Veo-3 video rendering → vertical formatting → multi-channel publishing into one cohesive pipeline. It’s built natively on n8n, so you keep full control, self-host if you want, and extend every step with your own logic.

  What’s Inside (Modular Building Blocks)

  Idea Engine** – AI generates concise, surprising facts and a visual metaphor per topic (swappable LLM/provider).  
  Prompt & Text Composer** – Crafts an 8-second, cinematic Veo-3 prompt + title, caption, description, hashtags, tags in a consistent brand voice.  
  Renderer Integration** – Kie.ai → Veo-3 (16:9, 1080p) for fast, cinematic clips.  
  Vertical Formatter** – FFmpeg pipeline converts to 1080×1920, adds top/bottom text bands (15–20 words), and preserves loop smoothness.  
  Multi-Channel Distribution** – Uploads to YouTube Shorts and Telegram for internal review/approvals.  
  Scheduler & Orchestration** – CRON triggers, retries, and lightweight polling make the system dependable for daily publishing.  

  Why These Components (and why they work together)

  Veo-3 via Kie.ai* provides a sweet spot of *quality + speed**, ideal for short loops where style coherence matters.  
  n8n* brings *vendor-neutral orchestration**: swap LLMs, add rate limits, branch flows, or trigger on events—without rewriting your stack.  
  FFmpeg* ensures a *platform-native look** (9:16, crisp text bands, no blurry hacks).  
  Separation of concerns* (idea → text → render → edit → publish) makes it easy to *A/B test** any stage independently.  

  Key Benefits

  Hands-Free Consistency** – Daily output with a repeatable creative pattern that audiences recognize.  
  Brand-Safe Copy** – Titles, descriptions, and hashtags follow a controlled structure—polished by design.  
  Time Savings** – Replace fragmented tooling with one pipeline; no manual re-formatting, captioning, or re-uploads.  
  Creator-Grade Quality** – Cinematic loops optimized for watch time and retention on Shorts/Reels.  
  Own Your Stack** – Self-hosted orchestration and storage; no lock-in.  

  Reuse & Extension Ideas

  Topic CMS** – Feed topics from Google Sheets / Notion and mark each as “published”—perfect for content calendars.  
  Multi-Language** – Duplicate the text composer for EN/DE outputs; upload the same clip with localized metadata.  
  Thumbnail/Preview Track** – Add an image generator step for platform cards or YouTube custom thumbnails.  
  Analytics Feedback Loop** – Fetch video performance, score ideas, and prioritize winning angles automatically.  
  Compliance & Fact Trails** – Store sources next to each post for quick audits and edits.  
  Storage & Delivery** – Push masters to S3/Backblaze, serve via CDN for faster IG ingestion.  
  More Channels** – Add TikTok, X, LinkedIn publishers or a newsletter export.  
  A/B Creative** – Render multiple Veo-3 seeds, rotate captions/CTAs, and compare retention.  

  Who It’s For

  Agencies** wanting repeatable, branded Shorts at scale.  
  Creators & Media Teams** who need daily output with minimal overhead.  
  Product Marketing** looking to convert docs/reports into snackable, evergreen video facts.  
  Startups** building audience fast without adding headcount.  

  Technical Notes (at a glance)

  Orchestration:** n8n (self-hosted or cloud)  
  Video:** Veo-3 via Kie.ai (16:9 render → FFmpeg vertical remaster 1080×1920)  
  Text Stack:** Any LLM provider (swappable); outputs normalized for each platform  
  Distribution:** YouTube Data API v3,  Telegram Bot API  
  Security:** API keys via n8n credentials/ENV; public URL endpoint only serves whitelisted .mp4 filenames with proper headers  
  Reliability:** CRON triggers, bounded retries/polling, and safe fallbacks to avoid stuck runs  

  Who to use it

  To enhance the completeness, add specific step-by-step setup instructions for users to implement the workflow easily:

  Install Prerequisites
     Set up n8n on your server or local machine (production mode with reverse proxy).
     Install FFmpeg and ensure fonts (e.g., DejaVu Sans) are available.

  Configure API Credentials
     Get a Perplexity API key for idea generation.
     Request a Kie.ai API key for Veo-3 video rendering.
     Set up YouTube OAuth2 (enable YouTube Data API v3 in Google Cloud Console).
     Create a Telegram bot token via BotFather.
     Store all keys as environment variables in n8n (avoid hardcoding).

  Prepare Storage
     Create a working directory accessible by n8n with read/write rights.
     Ensure enough disk space for video caching (approx. 50–200 MB per run).

  Set Scheduling
     Add CRON triggers for automatic execution (e.g., twice daily).
     Example:
            0 12 04 * * * → 04:12 AM daily
       0 12 16 * * * → 04:12 PM daily
       
  Define Variables
     File naming conventions:
       name_vorher = raw 16:9 video
       name_nachher = final 9:16 video
     Set topic = content niche (e.g., history, ocean, futurism).

  Build Workflow Steps in n8n
     Idea Generation: Perplexity node for viral fact.
     Prompt Agent: Expand into full package (prompt, caption, hashtags).
     Video Generation: Kie.ai Veo-3 API request (poll until success).
     Download & Edit: Save raw file, convert to 9:16 with FFmpeg overlays.
     Notifications & Uploads:
       Telegram node → send video.
       YouTube node → upload with title, description, tags.
       

  Test End-to-End
     Run the workflow manually once.
     Verify video rendering, FFmpeg subtitles, Telegram message, YouTube & IG uploads.

  Go Live
     Enable CRON triggers.
     Monitor first runs for errors (API limits, FFmpeg paths, token expiry).

  Why Buy This Template

  You’re not buying a script—you’re buying a production-ready system with a deliberate creative pattern, best-practice formatting, and shipping-grade integrations. It reduces ramp-up from weeks to hours and gives you a flexible base you can keep evolving.

nodes_used:
  ["n8n-nodes-base.youTube","n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.perplexity","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.readWriteFile","n8n-nodes-base.executeCommand","n8n-nodes-base.readWriteFile","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.wait"]

workflow_json_compressed:
  H4sIAAAAAAAAE62YS2/bRhDHvwqhQy/Vuvt++NQiaYMc2gZJmh6KoNjHrE1EIlWJamwE/u4Z0qlFS0tJTnOz6N3ZH2dn/jPDT7MldH52+WlWN5vONxFeptnlTNLMHUilAqNBQKZGcye0kMolmr12SlprkpQp+cQsGOmVEs5LazIHgNl81sFytfAdPFtD2ryBbrt61uIT6AAP6NZbuJvPmjbBZnb5F57en8oE9ZELSWL0kkgmOPHWCEItpz7TyBNVaLnxS8DVf6wWrU+Vr/6tE7T9iber/nljGzIYJsFv4OK23b7dhp5o1W7qrm4bPJBRSedc0vf41K/RXgdrBPl0d2/lHf4aFrK7+X9s1trskyQ8R0tkVox4xiWxIUQJyVCu3I7tTbyGtF1A9XZdX13BepJu82Xhbt2Ikggr50Q6fRLzgj+AWkTJJjuiA0tEAoIGZYAICsxQZgMXbAf6om2vEPMFLOumrp5d+676FekWO+AfkfiHHfXCN1fx2tfNxWLZL783cL//MT1Xek44l+f7WAJlzHpBgoyZSC8EcTRY5JeGWgiKWzryMQZR7LYYXtXv22617apXfr2BNTuDvR023K/f2XnML6U9j/9CPLwBxCx4soZISjGCvcvEi0SJyCkILll0AsZvUMcPt9VvbQd8OkKGRf2ax3jO8TmTB3Sz2DYdNB0amk17OjureBKMMKc4Rpi0xHqjCIuWaacjpUoXOcWTORmlvR+p/TpSr1JyAZ0ZTMCYAAfE6mwIMwkFKgQLNu9I3/VSUL1M4Cc5V7BGFbqpu9vHnPrMVNuRoQOlAXRfEphomGTEZuEIMAmBW8lyGvnw1RrVr6u+q97CTVf9dNW/+Ok49V/WjdMKlescUD7SBOkcCrgJBKMw4OagiffUE4Y5anxMPiQxvm6/7qrBlXg8rP1w8pQ/r7tu9Rr+2cJmD1T3+X8GqByBYpVRCksPEUx6VFkZiA/OkQRWRG6YkXSksi/gG2AyavicKH2yFow5EcPaHsxEoFipXCT4yxCTTFbJugja7UXljrHKqJWb60FvyrB13mPk7jxfPrp0rRTXyhGnHTJCwhzPIRLPUYkUZz5EV8xx+eQcF+hBbfjXZbhKXtjILeFeCyI1Z8Ra1lctznIAJySYIqd6Mqcy6EbDD676PFDmnFNCUaKCwizyMRKXNSpTCCxCVp5bvwN93n5shgbl3dH2ZDoulUbdlOLAq8fiMnGVhMOsSQyrjvQQiIsskIweFUqICGxUQf9c1x3c81UYls/rzYdJzjX4NKz/pV7sK7zBUnQO6c6VxhnrMsqmoY71AtrnueXECsGdkRrLvdxx/pzq7oQb4QbiFpvNdrn0zV4h55TpJ/JlwzM2uYIYGzEmsRoSD9ET2+uTS8ZEw3d8r9E3D0l9AvSIH01/4foJ/VJy3g6NBqPYNGPProlLjJLoAXtxb7NLo9r4BprU502d63hcKztYwBUSlIRy0KCPEK7b9sMwKhgWjbKZE9FrjcSBAWUmJZIZ1hptnQ22T9+z+1cuguTaYm4xiwU/CmyhKGRU2khxzMjYevuiHOintyZGyv+hB47aqFWKhBvTV1UUrhC8JoGrmKmwWcVRsvX33f+5qb6vunZVx2lc2JMCwvR5NV9cyJ2sUi6c8oooj4GLjZPDmg8K3Zq1zRl9muJICjym2Lbp6sXZFfUjbnnMafuOWR5EiAMqVaCORKlxdPI40WFs4lhHcaDkRvBg9ekIYXdoFu+lgdgfN1zTSBjw1xI7JqTAabKnPJWXw+o5jr0JbmaX9O79ezxz1D+WDB5t4ooG96pAyehRFS4a3Zt8R0aHfx8Mn6VTj4Rj8czD9SWrpf67aK7Uuk0aPNo6Fc2XLqpk/kSrW7Rdiqqi7Wm93bc7f9g09VGjSFKKnBJJqX4WDZbdUQzaM/SifPFTHxzwFF//3Y8+W5x6vjw7N/cOdhYTuxRHpZebat0OXmj+DRwy/Rnj3iPjTxVPcsijjQehM41b8sjRSavwWnd3nwG6bJNhWRQAAA==

metadata_json:
  {"categories":["Content Creation","AI/ML","Marketing"],"complexity":"medium","use_cases":["generate YouTube shorts","automate video content creation","publish short-form video"],"estimated_setup_minutes":45,"required_services":["YouTube","Perplexity","Google Gemini","Lovable"],"key_features":["LLM-powered script generation","AI video rendering with Veo-3 or Sora 2","automated video formatting and publishing","modular workflow for customization"],"target_audience":["content creators","social media managers"]}


name: Create Custom ASMR Sound Effects with ElevenLabs API and Google Drive
author_name: phil
author_username: phil
categories: []
created_at: 2025-09-10T07:14:40.631Z
updated_at: 2025-09-10T07:14:40.631Z
url: https://n8n.io/workflows/8439
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Generate royalty-free sound effects for all your projects: ASMR, YouTube videos, podcasts, and more. This workflow generates unique AI-powered sound effects using the ElevenLabs Sound Effects API.

  Enter a text description of the sound you envision, and the workflow will generate it, save the MP3 file to your Google Drive, and instantly provide a link to listen to your creation. 

  It is a powerful tool for quickly producing unique ASMR triggers, ambient sounds, or specific audio textures without any complex software.

  Who's it for

  This template is ideal for:
  Content Creators**: Generate royalty-free sound effects for videos, podcasts, and games on the fly.
  Sound Designers & Foley Artists**: Quickly prototype and generate specific audio clips for projects from a simple text prompt.
  Developers & Hobbyists**: Integrate AI sound effect generation into projects or simply experiment with the capabilities of the ElevenLabs API.

  How to set up

  Configure API Key:
      Sign up for an ElevenLabs account and get your API key.
      In the "ElevenLabs API" node, create new credentials and add your ElevenLabs API key.
  Connect Google Drive:
      Select the "Upload mp3" node.
      Create new credentials to connect your Google Drive account.
  Activate the Workflow:
      Save and activate the workflow.
      Use the Form Trigger's production URL to access the AI ASMR Sound Generator web form.

  Requirements

  An active n8n instance.
  An ElevenLabs account for the API key.
  A Google Drive account.

  How to customize this workflow


  Change Storage**: Replace the Google Drive node with another storage service node like Dropbox, AWS S3, or an FTP server to save your sound effects elsewhere.
  Modify Sound Parameters**: In the "elevenlabs_api" node, you can adjust the JSON body to control the output. Key parameters include:
      loop (boolean, optional, default: false): Creates a sound effect that loops smoothly. Note: Only available for the ‘eleven_text_to_sound_v2’ model.
      duration_seconds (number, optional, default: auto): Sets the sound's duration in seconds (from 0.5 to 30). If not set, the AI guesses the optimal duration from the prompt.
      prompt_influence (number, optional, default: 0.3): A value between 0 and 1 that controls how strictly the generation follows the prompt. Higher values result in less variation.
  Customize Confirmation Page**: Edit the "prepare reponse" node to change the design and text of the final page shown to the user.


  .

  Phil | Inforeole | Linkedin

  🇫🇷 Contactez nous pour automatiser vos processus

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.googleDrive","n8n-nodes-base.html","n8n-nodes-base.form","n8n-nodes-base.stickyNote","n8n-nodes-base.formTrigger"]

workflow_json_compressed:
  H4sIAAAAAAAAE51Y3XLbxhV+lQ3cTiQPl8I/QUppR7FlxxPJ1kiKPR5Lo9nFLoiNQCwCLEUxCl8huette9c36PS6j9IXaB+hZxcACf7I8ZTkkMTu4pzv/J+DR2vCFbFGj5bIK0XymL9h1sjyieOQhFEvDtyE2cOIe5zwYUKYT71hwhKH0phxx3eTYBgSxogfxoNhwL0wpJ4bWj1L8UmREcVflJxVl1xNixcSVrjiwECVU77oWblkvLJGn4C75kqZO3RpkuDQGYbYH9IAR0ngYmZ7xAnC4SByhkA5JxMOp3nG73meEVrdkkJojvNCr+dRjg1hTEnF+6lSxQX/acorpe+VSnO09Go1OjhQ5by/ItQX8qCS05zh5AEOF7ISSsgcEDqh3bNvYImUwF3xstI6m5ZZhxag2KB17zTkxjznJTG0elrjqdTynr+7vIJrWegNTRBUUvGcfSvZvNZRff0dJ8xwrJcobJ+v4eiiAmU2ClL8QYt8T7Kpvvzm8RH9Ye/r4zfo+PLsAr2uIcny6/2+AGP1f6xk3j+bViJGi4W16C3pyKkqpuo2keWEdAlOCu/W9x3bvnXcyFrcAPrUIP0ScA8Cg77wHZ9vQjQ4Tk5P3p+8PT3+9vL2+PzN7fcnHw2om8WiseGb/FUmZ61KtOnfAwdjLL/vavTGpRISkAS8FQfgXNjnsYcJiWPsBNEgiYkX88hZuRSwQt8bRLt9qeJdH3rNFZrLaYlOjNFPweio1p+mA5KhEXraz7T0E3163dFw6O9wtDUXIVUlxvmE58rsrV0uQymyAzK0Q8yYC6EE0uKhT13MGQ1o7BFKSCeUtrW9UkGlSpGPO0YyImu7fZk1vL6/tEbMnWHMBg52Qs/HfkIcHLmUYhIkNKJRzMMgWKH6ocgkYQjc7EmDjKUcZ/xlKe75uhq9MNqhxoawUXu/psv0vTrnPVq3tzqcaxEmwANOZqLqevzZHNW8FhtRm8gM/P5LyZRS6suYxClnF7yaZuptjewA7V3AJqrp7VtawTEkUDCuIJmRoSPyu+OpSt1jSH6jVsHLsxiul5rcdQ96sTxr2KwbbWkynw98JxhEOAkTB/sDbS3KOI48mwTcocM62zeMipKDxjmCH9AN/0xSnmTrBgsG4Q6DmXMj6+irl+9eXH08P0F64U/X+ZH+RRnJx99cWzy/tvQaE/eoUvOMw1oic4UTMhHZfIQqkle44qVIDhEl8d24NEk5lpksR+iZ4+r3IWqvua3fh4iJCioY3J9k/OEQ/TitlEjmcFuuQG8jFMM3Lw8RySD+sM6h1WpxInKccjFO4SCkyPsUlkg5FvkIAekCSiZE1Qi5dgGkqXzAlfjZrFBZgukxLB0asRC81kTbJQHX78P23pIwMQUsTqiJL3n5hpeuCthAXoGdCaZSg/OPGuYDbhYCewUvJUzOADycKh6Qp7/KMSV7dg81n36w30IAWrBfyUyw+pQbBD20+rL7zv5KvC0RjfVAIVxDMAiWMo9QJnJOSjzWUgL+PT9gfNxDz3we+HEEf6Jk6CcUsOAZp3dC4a7GMlGMjA5W20YjiciyVp+qBIfRfpyr1mpgD6XkpDEYIP/vX3/9+9EBgO7KkDpLEVrTJOZ1iDoiuZEWySzMGg8Z2HbHP1ol25rRR51uTcW+1BIgUaELqLLzr44OUqfLvNilvtoFNmTwjE5lQWKhwL3tfqQZXaUcQXOQkgo17QpniKBpLqB5qhGYZgaQl7ru9Y8Oig7/3zel627JHWq5N1W1E+3Si51g3SFaozXOaN59d38rGKLiYd3j9GvZb5BqUl4JlXH0yy/o2rqEJJwCO/QhhSQAyejagv6jI2Jj+c4KQWnJE5B4SRPc673gs1OR3+mbraVOlolF5NqZMc1kfNdEJuOxrDvFEcplzrfV8//Fwpr+Gp1uaKgOtW37POFOI+OkWqf//ss//vPP39ApVDmeo7dydnRA2szVKGr1azK4tVlwnE7P5ofhwA1gDIhg8IDeJfDgn27hhrHv0IR51PFXJadR5mfbBN26rpebQVS3WWCjVMo7M/SEYURj4vjY8RnDPqHA16cxjsiAsMhxYAAxzdpGZ9Y29lB96wGn7vJLXkENZB+ESnUXlcrZVd2P1xsVN5fdntfUNNN6b+hmqZlg6IE6IhsT1wbNOKGDaRgzHDmD0A5jOxkMO13dpRLx3RzsoZ4uxJU50xzptqHuwO1h33O3SrIpDdYogIHIqgscdNw2XDR1EXg8e9ZOF03emIESkIL80umUdY9MIJtM6y5PSfTadCl1h6VD6xnQ+ZAShYRCTPLqOr+CaEQzWd4l0G2iopT3AiSBJFUJrXkE1tTZaWJSFMnR1qyDoPODqN6G0kcnuhQCKR2FCKjGpTAdHpKJOV/nPsh7iOf3QlumZ/DrvSWkGVSRZfYE3D3oPe65OXN27iEoMlxLalrorrg1qXoEV9m8FQ3gZDp7wC1ZHVztzdDoGa/rt4r6DrjDJkwooNHr3On/62/o+XOYu1Ez1Dx/PkLLiaUdUJJSTuqVTx19wIAEwqqbvd+fkvcN8IJURlyQADBoaa/bWQrSnnY3wOnWkF7IPOexWhNfY9N9qW5HY625LQW1mIBDQ381HaxYeDWL41iJeyCjyV5q/WuMpFlcNxjA5TmhWb38SvvOVSnGY3CFHy5O+5+JxcRmzB9GAbajgGLf9xJMkySCVOXFAxqFXkjszmS56YmfzVUNhB0huZmzoBXnfJAwzBMnBhTUx5AdE2wPXEp8j5LQ9nbkrHZ0gQ2TnsxE1D6lMODoFKqvdgeuG/DLKZ0InbxIUfCcHSsYCuGEAdY8yzG4dQV9Qlq9/0rwjBm+ZhSq59VEL7aMztqJOCMxT80UBKsvTTjSxi86rcgejID9no44XbpndbGGCIe4M9YFuDreIYpnUrIehA2EU6aXCgIn9/smH/80FTALGXCNODeNQC9XeQBgmGR0J4Av5IQOCsgruRQVhyxlEsQMglh7lglS/uctJ3Kh2N2YhKkjoTVF+/AB/k6I0Bb/dKNxdMbgztajeXj2uZHLnOxZAJc/WCN7YYhtPDTbRXDX2L2T1ibnXcR2Vued1LZ9Zhe9rSc0m7R6y6NPPR/cwX2x+B91DmEvCBUAAA==

metadata_json:
  {"categories":["AI/ML","Content Creation","Data Processing"],"complexity":"medium","use_cases":["generate custom sound effects","create ASMR audio triggers","produce YouTube background sounds","make podcast ambient noise"],"estimated_setup_minutes":15,"required_services":["ElevenLabs API","Google Drive"],"key_features":["natural language prompt processing","automatic audio file generation","direct cloud storage upload","instant asset delivery"],"target_audience":["content creators","audio producers","podcasters"]}


name: Automated Daily AI Summaries from WhatsApp Groups
author_name: Daniel Lianes
author_username: daniellianes
categories: []
created_at: 2025-09-10T08:22:27.546Z
updated_at: 2025-09-10T08:22:27.546Z
url: https://n8n.io/workflows/8442
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:20
description:
  Automated Daily AI Summaries from WhatsApp Groups using a Custom AI Agent

  Transform your WhatsApp group conversations into actionable business intelligence through automated AI analysis and daily reporting. This workflow eliminates manual conversation monitoring by capturing messages in real-time, processing voice notes, and delivering structured insights directly to your team.

  Overview

  This workflow provides complete conversation intelligence automation from message capture to insight delivery. It eliminates manual monitoring, analysis, and reporting by using Evolution API integration, OpenAI transcription, and advanced LLM analysis for hands-free business intelligence that scales your team's awareness of important discussions.

  Core Function: Autonomous conversation analysis that transforms WhatsApp group chatter into structured business insights with zero manual intervention, maintaining consistent daily reporting while capturing emerging opportunities and trends before your competition.

  Key Capabilities

  Real-time message capture - Monitors multiple WhatsApp groups simultaneously with instant processing and smart filtering
  Voice message transcription - Automatic conversion of audio messages to searchable text using OpenAI Whisper
  AI-powered insight extraction - Advanced LLM analysis identifies trends, opportunities, and actionable information while filtering noise
  Automated daily reporting - Scheduled intelligence summaries delivered directly to your team via WhatsApp
  Multi-group organization - Separate tracking and analysis for different communities with unified reporting
  Smart content filtering - AI agent trained to focus on business-relevant discussions (AI, automation, tech trends, opportunities)

  Tools Used

  n8n: Workflow orchestration managing the entire intelligence pipeline from capture to delivery
  Evolution API: WhatsApp Business API integration for real-time message monitoring and sending
  OpenAI Whisper: Voice message transcription ensuring no important audio content is missed
  OpenRouter/GPT-4.1: Advanced AI analysis for intelligent insight extraction and content filtering
  Google Sheets: Organized message storage with timestamps and metadata for historical analysis
  Custom AI Agent: "WhatsOn" - specialized business intelligence detective for tech and automation insights

  How to Install

  Import the Workflow: Download the JSON file and import into your n8n instance
  Configure Evolution API: Set up WhatsApp integration and webhook endpoints for message capture
  API Credentials Setup: Add OpenAI, OpenRouter, and Google Sheets credentials in n8n
  Group Configuration: Update group IDs in the "Set Info" node with your monitored groups
  Google Sheets Setup: Create organized spreadsheet with separate tabs for each group
  Schedule Configuration: Set your preferred daily summary delivery time
  Test Execution: Run manual test to verify message capture and AI analysis work correctly

  Use Cases

  Business Intelligence Automation: Stay informed about industry discussions without manual monitoring
  Opportunity Detection: Identify emerging trends, tools, and business opportunities in real-time  
  Team Knowledge Sharing: Automated distribution of relevant insights from multiple communities
  Competitive Intelligence: Monitor industry discussions to stay ahead of market developments
  Community Management: Track engagement patterns and important conversations across groups
  Voice Message Processing: Ensure audio-based insights aren't lost in team communications

  Setup Requirements

  Evolution API account: WhatsApp Business integration with webhook capabilities
  OpenAI API: Voice transcription access through Whisper API
  OpenRouter account: Access to GPT-4.1 for advanced conversation analysis
  Google Sheets: Message storage and organization with proper permissions configured
  WhatsApp Groups: Access to business or professional groups with relevant discussions

  Total setup time: 15-20 minutes once all API accounts are properly configured.

  How to Customize

  Analysis Focus: Modify the AI agent's system prompt to target your industry or specific topics. Adjust keyword priorities, conversation themes, or insight categories based on your business needs.

  Group Management: Add additional groups by extending the Switch node logic, creating new Google Sheets tabs, and updating group ID variables. Scale from 3 to unlimited group monitoring.

  Delivery Schedule: Change summary frequency from daily to weekly, multiple times per day, or custom schedules. Add multiple delivery destinations for different team segments.

  AI Intelligence: Customize the "WhatsOn" agent personality, adjust insight priorities, modify filtering criteria, or add sentiment analysis for deeper conversation understanding.

  Storage & Organization: Modify Google Sheets structure, add custom metadata fields, integrate with other databases, or connect to business intelligence dashboards for advanced analytics.

  Advanced Features

  Smart Voice Processing
  Automatically transcribes voice messages to text using OpenAI's Whisper API, ensuring critical audio-based discussions are captured and analyzed alongside text conversations.

  Intelligent Content Filtering  
  The AI agent is specifically trained to identify valuable business insights while filtering out casual conversation, ensuring your daily summaries focus on actionable information that drives decisions.

  Multi-Fragment Delivery System
  Large intelligence summaries are automatically broken into properly formatted WhatsApp messages with natural pacing to avoid delivery issues and improve readability.

  Historical Analysis Capability
  All conversations are stored with full metadata in Google Sheets, enabling historical trend analysis, keyword tracking, and long-term pattern recognition for strategic planning.

  Ready to transform group conversations into competitive intelligence? This template converts casual WhatsApp discussions into structured business insights delivered automatically to your team, ensuring you never miss important industry developments or opportunities.

  Google Sheets Template

  The workflow includes a pre-configured structure for tracking:
  Message timestamps and sender information  
  Full conversation content with voice transcriptions
  Group-specific organization and categorization
  Daily summary delivery logs and performance metrics

  Was this helpful? Let me know!

  I truly hope this WhatsApp intelligence system helps streamline your team's awareness of important conversations. Your feedback helps me create better automation resources for the n8n community.

  Ready to Build Something Great?

  If you're looking to take your n8n skills or business automation to the next level, I can help.

  🎓 n8n Coaching: Want to become an n8n pro? I offer one-on-one coaching sessions to help you master workflows, tackle specific problems, and build with confidence.
  ➡️ Book a Coaching Session

  💼 n8n Consulting: Have a complex project, an integration challenge, or need a custom workflow built for your business? Let's work together to create a powerful automation solution.
  ➡️ Inquire About Consulting Services

  Stay Updated on Automation
  For more content automation strategies, AI workflow tips, and business automation insights:
  Follow me on LinkedIn

  Happy Automating!

  Daniel Lianes

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.merge","n8n-nodes-base.noOp","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.outputParserAutofixing","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.if","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-evolution-api.evolutionApi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-evolution-api.evolutionApi","n8n-nodes-base.aggregate","n8n-nodes-base.aggregate","n8n-nodes-base.aggregate","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.set","n8n-nodes-base.aggregate","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 18512 characters]

metadata_json:
  {"categories":["AI/ML","Communication","Data Processing"],"complexity":"medium","use_cases":["capturing chat messages","scheduling daily summaries","summarizing conversations","extracting business intelligence","integrating WhatsApp with spreadsheets"],"estimated_setup_minutes":60,"required_services":["WhatsApp Cloud API","OpenRouter AI API","Google Sheets API","Evolution API","Open WebUI"],"key_features":["Real-time webhook polling","Voice note transcription","Daily Insight generation","Multi-channel data aggregation","No-code summarization"],"target_audience":["Team Leads","Communications Managers","Operations Staff"]}


name: Monitor social media trends across Reddit, Instagram & TikTok with Apify
author_name: Allan Vaccarizi
author_username: growthai
categories: []
created_at: 2025-09-10T13:44:08.027Z
updated_at: 2025-09-10T13:44:08.027Z
url: https://n8n.io/workflows/8450
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:19
description:
  📺 Full walkthrough video: https://youtu.be/Me4d4BILvHk

  What it does
  This workflow automatically monitors trending content across Reddit, Instagram, and TikTok using keywords you define. It scrapes the most engaging posts, calculates platform-specific engagement scores, ranks content in a unified leaderboard, and delivers a professional HTML email dashboard — while storing historical data in a structured table for long-term trend tracking.

  No manual research. No tab switching. Just the top-performing content in your inbox, automatically.

  Who's it for
  Social media managers, content creators, brand managers, marketing teams, and agencies who need to track keyword performance and trending content across multiple platforms for competitive analysis, content inspiration, and influencer discovery.

  How it works
  The workflow runs a full scraping cycle for each keyword in your list:

  Reddit Monitoring**: Searches top posts by keyword with upvotes and comment data
  Instagram Monitoring**: Scrapes hashtag-based posts with likes and comments
  TikTok Analysis**: Tracks hashtag content including views, likes, shares, and comments
  Engagement Scoring**: Applies platform-specific algorithms to rank content objectively
  Unified Ranking**: Combines all platforms into a single top 15 leaderboard
  Email Report**: Delivers a formatted HTML dashboard with clickable links to original posts
  Data Storage**: Pushes all results into a DataTable for historical tracking and trend analysis

  Requirements

  Apify account (free tier works — no recurring cost)
  Gmail account for report delivery
  n8n instance (cloud or self-hosted)
  Platform scrapers: Reddit Scraper Lite, Instagram Scraper, TikTok Scraper

  How to set up

  Step 1: Configure Apify credentials
  Set up Apify API authentication in n8n
  Ensure access to the required scrapers:
    Reddit: trudax~reddit-scraper-lite
    Instagram: apify~instagram-scraper
    TikTok: clockworks~tiktok-scraper
  Install the Apify community node: https://docs.apify.com/platform/integrations/n8n

  Step 2: Add your keywords
  Open the "Query social media" DataTable and add one keyword per row. The Loop Over Query node automatically runs a full Reddit + Instagram + TikTok scraping cycle for every keyword — no limit on the number of keywords.

  Step 3: Configure search parameters

  Reddit:
  Search terms via searches array
  Sort: top (alternatives: hot, new, relevance)
  Time period: month (alternatives: hour, day, week, year, all)
  Limits: maxItems 50, maxPostCount 25

  Instagram:
  Target hashtags via directUrls
  Results type: posts
  Time filter: onlyPostsNewerThan: 7 days
  Result limit: 15

  TikTok:
  Target hashtags via hashtags array
  Results per page: 20
  Time filter: oldestPostDateUnified: 7 days

  Step 4: Set up email reporting
  Configure Gmail OAuth2 credentials in n8n
  Update the recipient email address in the Send a message node
  Customize subject and styling as needed

  Step 5: Schedule the workflow
  Add a Schedule Trigger to run the workflow automatically — daily, weekly, or at any interval that suits your monitoring needs.

  Engagement scoring methodology

  Platform-specific algorithms

  Reddit
  Score = (upvotes × 1) + (comments × 2)
  Comments weighted higher as they indicate deeper community engagement.

  Instagram
  Score = (likes × 1) + (comments × 2)
  Focused on recent content to capture trending moments. Carousel sub-items excluded to avoid duplicates.

  TikTok
  Score = (likes × 1) + (comments × 2) + (shares × 3) + (views ÷ 1000)
  Shares heavily weighted (×3) as the strongest viral indicator. Views normalized to balance with other metrics.

  Performance levels
  Content is automatically classified into three tiers:
  High**: Score ≥ 10,000 — viral or highly engaging content
  Medium**: Score ≥ 1,000 — solid engagement, worth monitoring
  Low**: Score &lt; 1,000 — baseline engagement

  Results & dashboard

  The automated email report includes:
  Cross-platform leaderboard**: Top 15 posts ranked by unified engagement score
  Platform breakdown**: Total score per network (TikTok / Reddit / Instagram)
  Per-post detail**: Author, content preview, score, level, and direct link to original post
  Historical DataTable**: One row per post with keyword, source, score, date — queryable over time

  How to customize

  Keyword targeting
  Add as many keywords as needed — one row per keyword in the DataTable
  Use brand names, product names, competitor terms, or campaign hashtags
  Adjust for seasonal trends or campaign periods

  Scoring adjustments
  Modify the Code nodes to:
  Change metric multipliers based on your priorities
  Add recency bonuses for fresher content
  Filter out low-quality or spam content
  Integrate sentiment scoring for brand monitoring

  Reporting enhancements
  Add multiple email recipients
  Export results to Google Sheets or Airtable
  Set alert thresholds for high-performing content
  Connect to Slack or Teams for real-time notifications

  Use cases

  Brand & competitive monitoring
  Track brand mentions, competitor content performance, and market positioning across all three platforms simultaneously.

  Content strategy
  Identify top-performing content formats, discover effective hashtags, and spot emerging trends before they peak.

  Influencer discovery
  Find creators driving the most engagement in your niche and evaluate potential collaborators based on real performance data.

  Campaign tracking
  Monitor hashtag campaigns, track sponsored content performance, and measure share of voice over time.

  Limitations

  Subject to Apify scraper quotas (free tier: ~$5 credit/month included)
  Some private or restricted content may not be accessible
  30-second processing waits between platforms to prevent rate limiting
  Dependent on third-party scraper availability and maintenance

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE71YzXIbNxJ+lSn6sLGXcOF/AFXtwbtVSqnKG2dtV3KwfMBPQ5rScMidGdpWXD7uM+wlb5M32SfZxpCUKWooiXSSg20aAzS+/rrR/QGfJzPo3eTk86Rqut41Ac7i5GQirAjOgtCOJcM8TVqKUPLSciu1UwkUSAteGi0ZfneSCg4K/zG8NFyLyZfppJlH6CYn79B0NqmUF9wrR4TglEjQQFxwQKyzmnpBwQGd4Co3A5z9pq/C1XXxw7wHHOyvF3mwMQ0ZrBLvOnjeDXPWUxbzruqreYMbMqXNlHP5Hkddi/Z6aLvsYpg3PTQ9Wsr4stGf8MuwiH2ZrnFKUzInjCFQgiNSA+IUWhNbehnxjw8gRnEyfRxScjTU4LhLUkdiqBVE2mCJpdISgOA9UEaDTeNQy4OhCib0VJX6OKSeRe5KJYhm3BKZMAMMh0hKC9pTJnmp4zhScxxSqY8Nv3bBOqZJTN4TqYwg1mtOJAbfQgiY6+OccnZ4+Ck1UynNcUg5UB0ETyQEromkiNloA8RbPGAuCiEiG0fKD0YqGePHRz9qDjJyICxJhnmKKWClF1gJGHCsIzwFNR79g4EaaaaZ1iODTzHCDOOetJZEYgoQBwhZ++hFGRITSY9TenjsBTdTrHxHMkohOSUjYc6WWEzx0PtoLQlJG1amVNLh4NwFKg4HWmLotTmSUSU9w3xUJCidiGT4y1qrSFIR484cL9N46OVxQBk9tpj6aGyZYx+ZR6QJO4AxURFwJfamKJlz4yXq8LLPucHYW34cUBCi5AmLZwKmiORKE5e0Is6GYKVg3IgwCvTwoo+m+NTQI5OUSlcGIYGo0uck5Zx48IaU0ZUWu5MJxm8BhSYW389cVRevYTFv+71oL/KkvBDxdpuV0V12fu7aWHys+suiny8KRot5KvpLKGbzri+guXAXVXNRLPL/dh01dMqYybnzEfzlfH416CBVOo01S5BEE4oBEJ4YLIPE6hRAR+ZMmbvBLXKQEPgEYdnDK5RTk5O+XcIa7FlzWs8/boZu0caffyWulFrokBIWSI310pWJOK88UYx5JiMYT/lX4l675qp4UdfFj7Xr07yddXuZC/hzmzhkuSscLs2UdMVfi4vqA2TGZjhSNTgUYYHsZtbmTf5QtUVdXUGeG+azGeZAt8Ok0jdM7tLyIAc3DAgftbIUc9yb3HsZFmKTO4YuwQcjYlByh4HXEGPVFz9mTw4jYLFesu0FpXRq2J1+d5ATTImypAkIaIEHlUoMIxUMywpYZU1iSu2G8W119XZ+9Xs6gSC+zYvknBNKBKI8NwQVv0MHAlZIjAVPBrWH2/Li50toijfhEuKyhuK0amG/H9162tu2uriAdqeRW41ppO+0nTvl5vlW1kSjwFhKtHAIlTFJMFkCidwbZX2kJYetguMw1zPrmN0dFozirfP1/ttGdL3bzLhTOagaI3lPXUQtFWmyqC4poHBLeM1AfFhUOGWQABu52LoJfQ998a8ltBUeutTOZ8fBZIzKx/G51WeUcRRK4gc2JepLV5aSRGppoFGBNVtsvpxjxX31AdoN2P1hX9RVf9b83fUY/52UZaJ8XNjF12KJ6hwUdsJAHd4rbSmI93joNP4tXUKhFLfy8xRw11vHrPhQueLFokrXexFf9v3iNfx7CV2/de7y6qG7tKtPuUK6tZ1bskTvPYW3+kRydTfeKFro2+tXzWlue2OHVW6dAZl8Ut5Qwq0KeH0VSAfH0wuRCwUM7wzO79KxXTr/FDrGK+sfwAZHkWEdVgQrB0GPtznnsIJpo1A9h5hC2Ooj/4T2Am7aKNLSLet76vAsT9+pBtixH5e/2yETMUUPjFghsdlF7PTOYuPnBqQukynLoHdDdpZfay5wgz8zice7+h8QNqahtFYqEoFm5egtStwyEsFiyY2N2jux0zl3CHls83zy5Enx86VbcdBddz1KnziH7uS8eemWTa5QW6YvXXeJP4sutEgSiqIb2v+yPW34DO158wZcO5hoIaBUWsus72qHRJcoWa+7p8WyiVg0uwWEKlUQN3t0583ZbFHDILEKQUkHKLpjsWjnAboub/7R4aHFTC1yzUc5VtcQcryyMsOV+ed58xppr+DDLTcGATwsqppQLwd5N6i66Y2omxYONwtuka0gltOqzhEfRtcQ0CQK8WbjFHzamAqunS87qIsK2Vwt6fp57glPz5sXCyz/22jI2vWwEuiDw8ggzkdT2bv1XaNoV636HJ169uyrM2/WU0/xyC5rd/Ls2XlDipfZnZOCrXRsAS5c5uF/rN07KfhG4eZPiH62QOKrX7KlGbgG/03LegvS07z8tGpcPYCD4m8Yx0EJ//bfgj1FPfzdhrs8wp9mnDm7VlUE8+l/v/6neLu6lty+j9wOTFdUEa0MybBa9FPVLXHbDQ+YWbk85bdahIrRDd0QqGW7WXDWpHoJ+L0dyPftEMv18i2W0dHu66pN3RsNyML1GP8mR9PV179AHJOa36r6fWSRSk1JEk5gIdSoOAJevvAOJmRSjFsYf9U4/JEw38CPv9gGLQXNz5clYI+leCv03GtSegchqqR18KM47ZGPGuLQlzecjd+bVT0Ypt/VZziYzy9u8u799N3n4b3+0ZJgWDmdVFi8Pk1OaKbm1vqHFNZD6x/R33ZNvH+PPNy9Cm65ebPHQ41+v+lbF7RvN81Xpu++fYyZvkdi7wd8+2FgzOw9Dy/7o/TQ5WkU0NjlcAzRQ1ee/d7uqoBvjxBbWd8D6fcI0x48Y6bve+oZtX3vYd67w/hTyj0b7DntezcYf+a4Z4P95WDvHnsF4cg2X778Hxep5+gIHQAA

metadata_json:
  {"categories":["Marketing","Data Processing"],"complexity":"medium","use_cases":["track social media trends","scrape cross-platform content","calculate engagement scores","generate trend reports","monitor Reddit activity"],"estimated_setup_minutes":25,"required_services":["Apify","Reddit","Instagram","TikTok","Email Service"],"key_features":["cross-platform scraping","keyword-based filtering","unified leaderboard ranking","historical data storage","HTML email dashboard"],"target_audience":["marketers","social media managers","trend analysts"]}


name: Auto-Backup n8n Workflows to OneDrive with Cleanup & Email Notifications
author_name: Wessel Bulte
author_username: uuessel
categories: []
created_at: 2025-09-10T14:07:57.308Z
updated_at: 2025-09-10T14:07:57.308Z
url: https://n8n.io/workflows/8451
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:20
description:
  Automatically BackUp Your n8n Workflows to OneDrive

  This workflow automates the backup of your self-hosted n8n instance by exporting all workflows and saving them as individual .json files to a designated OneDrive folder. Each file is timestamped for easy versioning and audit tracking.

  After a successful backup, the workflow optionally cleans up old backup files and sends a confirmation email to notify you that the process completed.

  How it works

  Uses the HTTP Request node to fetch all workflows via the /rest/workflows API.
  Iterates through each workflow using SplitInBatches.
  Converts each workflow to a .json file using Set and Function nodes.
  Uploads each file to a target Microsoft OneDrive folder using OAuth2.
  Deletes old backup files from OneDrive after upload, with the option to keep backups for a configurable number of time.
  Sends an email notification once all backups have completed successfully.

  Setup instructions

  Enter your n8n Base URL and authentication details in the HTTP Request node.
  Set up Microsoft OneDrive OAuth2 credentials for cloud upload.
  Configure the Email node with SMTP credentials to receive backup confirmation.
  (Optional) Adjust the file retention logic to keep backups for a set duration.
  A Cron trigger to schedule the workflow automatically (e.g., daily or weekly).

  👉 Sticky notes inside the workflow explain each step for easy setup.

  Need Help

  Need Help
  🔗 LinkedIn – Wessel Bulte

nodes_used:
  ["n8n-nodes-base.n8n","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.code","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.switch","n8n-nodes-base.splitInBatches","n8n-nodes-base.merge","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.convertToFile","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 16596 characters]

metadata_json:
  {"categories":["Automation","Data Processing"],"complexity":"medium","use_cases":["Automate workflow backups","Version control n8n workflows","Audit tracking","Email notifications"],"estimated_setup_minutes":15,"required_services":["n8n Self-Hosted Instance","Microsoft OneDrive","Microsoft Outlook"],"key_features":["Automatic JSON export","Timestamped file naming","Version management","Scheduled execution","Cleanup automation"],"target_audience":["n8n administrators","DevOps engineers","System administrators"]}


name: Send automated weekly news digest from Google News to Discord
author_name: Allan Vaccarizi
author_username: growthai
categories: []
created_at: 2025-09-10T14:24:51.234Z
updated_at: 2025-09-10T14:24:51.234Z
url: https://n8n.io/workflows/8452
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  📺 Full walkthrough video: https://youtu.be/QHvfykuSbF8

  ⚠️ Self-hosted only — This template uses a community node (Firecrawl) and cannot run on n8n Cloud.

  Who it's for

  This workflow is for community managers, SEO professionals, or team leads who want to deliver a curated, AI-written news digest to a Discord channel automatically — without manually browsing news sources every week.

  How it works

  A schedule trigger fires every Monday at 9am and fetches a list of watch topics from a NocoDB data table.
  For each topic, the workflow queries Google News via SerpAPI and extracts the top 3 article URLs.
  Each article is scraped using Firecrawl, and the raw markdown is cleaned before being passed to Claude Sonnet.
  Claude writes a structured French-language digest entry per topic, with media name, date, URL, and a 2–3 sentence summary.
  All topic digests are aggregated and split into Discord-safe chunks (under 2000 characters).
  An intro message is sent to Discord first, then each chunk is sent in a loop, followed by a closing conclusion message.

  How to set up

  [ ] Configure the Schedule Trigger with your desired run frequency
  [ ] Connect NocoDB credentials and point the table node to your watch topics table
  [ ] Add your SerpAPI API key to the Search Google News node
  [ ] Add your Firecrawl API key to the Scrape Article Content node
  [ ] Add your Anthropic credentials to the Claude Sonnet sub-node
  [ ] Connect your Discord bot and set the correct server and channel IDs

  Requirements

  NocoDB (or compatible data table) account
  SerpAPI account
  Firecrawl account
  Anthropic API key
  Discord bot with message permissions

  How to customize

  Swap NocoDB for Airtable or Google Sheets to manage your watch topics list
  Edit the AI prompt in the "Draft Watch Summary with AI" node to change the language, tone, or output structure of the digest
  Adjust the DISCORD_CHAR_LIMIT constant in the "Split Text for Discord" code node to handle different message size constraints

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatAnthropic","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-serpapi.serpApi","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.aggregate","n8n-nodes-base.code","n8n-nodes-base.discord","n8n-nodes-base.discord","n8n-nodes-base.discord","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.dataTable","@mendable/n8n-nodes-firecrawl.firecrawl","n8n-nodes-base.code"]

workflow_json_compressed:
  [encoded data, 8396 characters]

metadata_json:
  {"categories":["Communication","Content Management"],"complexity":"medium","use_cases":["schedule automated news digests","curate content from news sources","push news updates to Discord"],"estimated_setup_minutes":25,"required_services":["Discord","Google News (via SERP API)","NocoDB","Anthropic (AI)","firecrawl"],"key_features":["scheduled execution","AI content generation","web scraping"],"target_audience":["community managers","SEO professionals","team leads"]}


name: Create Ideal Customer Profile from Websites Content to Google Doc
author_name: Simeon Penev
author_username: monkatagpt
categories: []
created_at: 2025-09-10T18:44:25.443Z
updated_at: 2025-09-10T18:44:25.443Z
url: https://n8n.io/workflows/8461
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who’s it for
  Growth, marketing, sales, and founder teams that want a decision-ready Ideal Customer Profile (ICP)—grounded in their own site content.

  How it works / What it does
  On form submission* collects *Website URL* and *Business Name** and redirects to Google Drive Folder after the final node.  
  Crawl and Scrape the Website Content* - crawls and scrape *20 pages** from the website. 
  ICP Creator* builds a *Markdown ICP** with:  
  A) Executive Summary
  B) One-Pager ICP
  C) Tiering & Lead Scoring
  D) Demand Gen & ABM Plays
  E) Evidence Log
  F) Section Confidence
  Facts vs. Inferences, confidence scores and tables. 
  Markdown to Google Doc* converts Markdown to Google Docs batchUpdate requests. Then this is used in *Update a document** for updating the empty doc. 
  Create a document* + *Update a document* generate *“ICP for &lt;Business Name&gt;”** in your Drive folder and apply formatting.

  How to set up
  1) Add credentials: Firecrawl (Authorization header), OpenAI (Chat), Google Docs OAuth2.  
  2) Replace placeholders: {{API_KEY}}, {{google_drive_folder_id}}, {{google_drive_folder_url}}.  
  3) Publish and open the Form URL to test.

  Requirements
  Firecrawl API key • OpenAI API key • Google account with access to the target Drive folder.

  Resources
  Google OAuth2 Credentials Setup - https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/  
  OpenAI API key - https://docs.n8n.io/integrations/builtin/credentials/openai/  
  Firecrawl API key - https://take.ms/lGcUp

nodes_used:
  ["@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleDocs","n8n-nodes-base.httpRequest","n8n-nodes-base.formTrigger","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 13052 characters]

metadata_json:
  {"categories":["Marketing","Data Processing","AI/ML"],"complexity":"medium","use_cases":["Build Ideal Customer Profile","Scrape Website Content","Generate Marketing Documents"],"estimated_setup_minutes":10,"required_services":["Google Docs","Form","AI/ML"],"key_features":["Website Crawling","ICP Generation","Document Auto-creation"],"target_audience":["marketers","sales teams","founders"]}


name: Create & Send GA4 Report with Insights via Email
author_name: Simeon Penev
author_username: monkatagpt
categories: []
created_at: 2025-09-10T19:44:36.583Z
updated_at: 2025-09-10T19:44:36.583Z
url: https://n8n.io/workflows/8463
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:20
description:
  Who’s it for
  Marketing, growth, and analytics teams who want a decision-ready GA4 summary—automatically calculated, clearly color-coded, and emailed as a polished HTML report.

  How it works / What it does
  Get Client (Form Trigger)* collects *GA4 Property ID (“Account ID”), **Key Event, date ranges (current & previous), Client Name, and recipient email.
  Overall Metrics This Period / Previous Period (GA4 Data API)** pull sessions, users, engagement, bounce rate, and more for each range.
  Form Submits This Period / Previous Period (GA4 Data API)** fetch key-event counts for conversion comparisons.
  Code** normalizes form dates for API requests.
  AI Agent* builds a *valid HTML email**:  
    Calculates % deltas, applies green for positive (#10B981) and red for negative (#EF4444) changes.
    Writes summary and recommendations.
    Produces the final HTML only.
  Send a message (Gmail)** sends the formatted HTML report to the specified email address with a contextual subject.

  How to set up
  1) Add credentials: Google Analytics OAuth2, OpenAI (Chat), Gmail OAuth2.  
  2) Ensure the form fields match your GA4 property and event names; “Account ID” = GA4 Property ID. 
  Property ID - https://take.ms/vO2MG
  Key event - https://take.ms/hxwQi
  3) Publish the form URL and run a test submission.

  Requirements
  GA4 property access (Viewer/Analyst) • OpenAI API key • Gmail account with send permission.

  Resources
  Google OAuth2 (GA4) – https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/  
  OpenAI credentials – https://docs.n8n.io/integrations/builtin/credentials/openai/  
  Gmail OAuth2 – https://docs.n8n.io/integrations/builtin/credentials/google/  
  GA4 Data API overview – https://developers.google.com/analytics/devguides/reporting/data/v1

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.formTrigger","n8n-nodes-base.gmail","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 12588 characters]

metadata_json:
  {"categories":["Marketing","Data Processing","Communication"],"complexity":"medium","use_cases":["automate GA4 performance summaries","generate color-coded reports","trigger email alerts with analytics insights"],"estimated_setup_minutes":15,"required_services":["Google Analytics 4 API"],"key_features":["AI-powered metric interpretation","automated HTML report generation","email delivery with attachments"],"target_audience":["marketing managers","growth analysts","data analysts"]}


name: Find Perfect Jobs & Generate Tailored Cover Letters with Gemini & Google Jobs
author_name: Khairul Muhtadin
author_username: khmuhtadin
categories: []
created_at: 2025-09-11T17:14:46.028Z
updated_at: 2025-09-11T17:14:46.028Z
url: https://n8n.io/workflows/8487
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:20
description:
  Say goodbye to endless applications and hello to more time for perfecting your interview skills!

  The JOB Hunter Agent uses the power of Google Gemini and SerpAPI to find the perfect job match and generate a personalized cover letter. 

  Result example:

  💡 Why Use JOB Hunter Agent?
  Save Precious Time: Stop sifting through countless job boards; this agent does the heavy lifting, saving you hours every week.

  Land Your Dream Job Faster: Get laser-focused job matches and a custom-crafted cover letter that speaks directly to the hiring manager, increasing your chances of getting noticed.

  Never Miss an Opportunity: Your personal AI assistant works 24/7, ensuring you're always on top of the latest openings, even while you sleep!

  Stand Out from the Crowd: A perfectly tailored cover letter generated on the fly gives you an edge over generic applications, making you look like a superstar.

  ⚡ Perfect For
  Job Seekers: Anyone actively looking for a new role who wants to streamline their application process.
  Busy Professionals: Those with limited time who need an efficient way to find relevant opportunities.
  Career Changers: Individuals exploring new industries who need a helping hand in crafting compelling applications.

  🔧 How It Works
  ⏱ Trigger: You submit your CV and job preferences through a simple n8n form.
  📎 Process: Your CV is extracted from the PDF, and your preferences (location, job type, salary, email) are neatly organized.
  🤖 Smart Logic: The "Job Hunter Agent" uses Google Gemini and SerpAPI to find the single best job match for you and then drafts a bespoke cover letter based on your CV and the job description. It's like magic, but with more code!
  💌 Output: A beautifully formatted HTML email containing your profile summary, the best job match, your personalized cover letter, and handy application tips is sent straight to your inbox.
  🗂 Storage: All the initial data from your form submission is processed and used to craft your perfect job application package.

  🔐 Quick Setup
  Import JSON file to your n8n instances
  Add credentials: Google Gemini (Gemini 2.5 Pro model) and SerpAPI
  Customize: Adjust the system prompt in the "Job Hunter Agent" to fine-tune the cover letter tone or length, update the email footer, and expand job filters.
  Update: Ensure your Gmail OAuth2 credentials are valid for sending emails.
  Test: Run the workflow with your own CV and preferences to see the magic happen!

  🧩 You'll Need
  Active n8n instances
  Google Gemini API key (for Gemini 2.5 Pro)
  SerpAPI account for Google Jobs search results
  A Gmail account for sending personalized job match emails

  🛠️ Level Up Ideas
  Integrate with LinkedIn, Jobstreet, or Indeed APIs for a wider range of job sources.
  Allow the agent to find multiple job matches and present them as a curated list.
  Add an option to attach a parsed CV summary as a PDF to the email for quick reference.

  Made by: khaisa Studio  
  Tags: AI, Gemini, Google Jobs, Job Search, Automation, Cover Letter  
  Category: job hunter  
  Need custom work? Contact me

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.formTrigger","n8n-nodes-base.extractFromFile","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.gmail","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.toolSerpApi","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8312 characters]

metadata_json:
  {"categories":["Career Development","Productivity","AI/ML"],"complexity":"medium","use_cases":["search jobs","generate cover letters","automate job applications"],"estimated_setup_minutes":25,"required_services":["Google SerpAPI","Google Gemini API"],"key_features":["AI-powered job matching","automated cover letter creation","web search integration"],"target_audience":["job seekers","career counselors","hr professionals"]}


name: 📩 Automated Email Management System with GPT-5, Multi-Agent AI & Pinecone DB
author_name: Zawanah
author_username: zawanah
categories: []
created_at: 2025-09-12T02:28:35.878Z
updated_at: 2025-09-12T02:28:35.878Z
url: https://n8n.io/workflows/8490
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Categorise and route emails with GPT 5
  This workflow demonstrates how to use AI text classifier to classify incoming emails, and uses a multi-agent architecture to respond for each email category respectively.

  Use cases
  Business owners with a lot of incoming emails, or anyone who has huge influx of emails 

  How it Works
  Any incoming emails will be read by the text classifier powered by GPT 5, and routed according to the defined categories where respective agents will take next steps. 
  Workflow is triggered when an email comes in
  GPT will read email's "subject","from" and "content" to route it accurately to respective designated categories
  For customer support enquiries, customer support agent will take knowledge from the pinecone vector database about FAQs and policies, reply via gmail, and label the email as "Customer Support"
  For finance-related queries, finance agent will label email as "Finance" and assess if email is about making payment or receiving from customers. If payment-related, email will be sent to the payments team to take action. If receipts-related, email will be sent to the receivables team to take action. User will be notified via telegram after any email is sent.
  For sales/leads enquiries, leads agent will label the email as "Sales Opportunities", take knowledge from the pinecone vector database about the business to generate a response and draft into gmail and user will be notified via telegram to review and send. If there is lack of information for agent to generate a response, user will be notified of this via telegram as well. 
  Any internal team member emails will be routed to the internal agent. The agent will label message as "Internal" and send user a summary of the email message via telegram. 

  How to set up
  Set up Telegram bot via Botfather. See setup instructions here 
  Setup OpenAI API for transcription services (Credits required) here
  Set up Openrouter account. See details here
  Set up Pinecone database. See details here

  Customization Options
  Other than Gmail, it is possible to connect to Outlook as well. Other than Pinecone vector database, there are other vector database that should serve the same purpose  eg. supabase, qdrant, weviate

  Requirements
  Gmail account
  Telegram bot
  Pinecone account
  Open router account

nodes_used:
  ["n8n-nodes-base.gmailTrigger","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.embeddingsOpenAi","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.gmail","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.vectorStorePinecone","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.textClassifier","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.gmail","n8n-nodes-base.gmailTool","n8n-nodes-base.telegram","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.telegram","n8n-nodes-base.gmail","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.vectorStorePinecone","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 9776 characters]

metadata_json:
  {"categories":["AI/ML","Communication","Data Processing"],"complexity":"medium","use_cases":["automatic email classification","automated email routing","AI-powered email response","multi-agent email handling"],"estimated_setup_minutes":60,"required_services":["OpenRouter","Pinecone"],"key_features":["text classification","multi-agent architecture","vector store integration","automated routing"],"target_audience":["business owners","administrators","operations teams"]}


name: Track Forex Factory News Releases with MyFxBook, Telegram & Google Sheets
author_name: Harry Gunadi Permana
author_username: harrygp
categories: []
created_at: 2025-09-12T02:45:00.415Z
updated_at: 2025-09-12T02:45:00.415Z
url: https://n8n.io/workflows/8491
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  Get Forex Factory News Release to Telegram, Google Sheets. Record News Data and Live Price from MyFxBook for Affected Currency Pairs.
  This n8n template demonstrates how to capture Actual Data Releases as quickly as possible for trading decisions.

  Use cases:
  Get notified if the actual data release is positive or negative for the relevant currency.
  Use the Telegram chat message about the news release as a trigger to open a trading position in MetaTrader 4.
  Record news data and live price to google sheets for analysis.

  Currency Pairs
  EURUSD, GBPUSD, AUDUSD, NZDUSD, USDJPY, USDCHF, USDCAD, XAUUSD

  How it works
  A news release event acts as the trigger.
  Only news with a numerical Forecast value will be processed. Events that cannot be measured numerically (e.g., speeches) are ignored.
  Extract news details: currency, impact level (high/medium), release date, and news link.
  Wait 10 seconds to ensure the Actual value is available on the news page.
  Scrape the Actual value from the news link using Airtop.
  If the Actual value is not available, wait another 5 seconds and retry scraping.
  Extract both Actual and Forecast values from the scraped content.
  Remove non-numeric characters (%, K, M, B, T) and convert values to numbers.
  Determine the effect:
  If the Actual value is lower than the Forecast value (and lower is better), send it to the True branch.
  Otherwise, send it to the False branch.
  Record news data and live price from MyFxBook to Google Sheets.

  How to use
  Enter all required credentials.
  Create or Download Google Sheets file like this in your Google Drive: https://docs.google.com/spreadsheets/d/1OhrbUQEc_lGegk5pRWWKz5nrnMbTZGT0lxK9aJqqId4/edit?usp=drive_link
  Run the workflow.

  Requirements
  Google Calendar credentials
  Airtop API key
  Telegram Chat ID
  Telegram Bot API token
  Enable Google Drive API in Google Cloud Console
  Google Sheets credentials

  Need Help?
  Join the Discord or ask in the Forum!

  Thank you!

  Update Sept 26, 2025:
  Add new edit node

nodes_used:
  ["n8n-nodes-base.googleCalendarTrigger","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.noOp","n8n-nodes-base.set","n8n-nodes-base.airtop","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.set","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.noOp","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.wait","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set"]

workflow_json_compressed:
  [encoded data, 9616 characters]

metadata_json:
  {"categories":["Trading"],"complexity":"medium","use_cases":["get real-time forex news alerts","automate trading signals","track currency news events"],"estimated_setup_minutes":45,"required_services":["Telegram","Google Sheets","MyFxBook","MetaTrader 4"],"key_features":["custom alert triggers","multi-platform data capture","conditional news processing"],"target_audience":["traders","financial analysts"]}


name: Jarvis: Productivity AI Agent for Tasks, Calendar, Email & Expense using MCPs
author_name: Jitesh Dugar
author_username: jiteshdugar
categories: []
created_at: 2025-09-12T06:41:03.347Z
updated_at: 2025-09-12T06:41:03.347Z
url: https://n8n.io/workflows/8500
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who’s it for
  This template is designed for anyone who wants to use Telegram as a personal AI assistant hub.  
  If you often juggle tasks, emails, calendars, and expenses across multiple tools, this workflow consolidates everything into one seamless AI-powered agent.

  What it does
  Jarvis listens to your Telegram messages (text or audio) and processes them with OpenAI.  
  Based on your request, it can:
  ✅ Manage tasks (create, complete, or delete)  
  📅 Handle calendar events (schedule, reschedule, or check availability)  
  📧 Send, draft, or fetch emails with Gmail  
  👥 Retrieve Google Contacts  
  💵 Log and track expenses  

  All responses are returned directly to Telegram, giving you a unified command center.

  How to set up
  Clone this template into your n8n workspace.  
  Connect your accounts (Telegram, Gmail, Google Calendar, Contacts, etc.).  
  Add your OpenAI API key in the Credentials section.  
  Test by sending a Telegram message like “Create a meeting tomorrow at 3pm” or “Add expense $50 for lunch.”  or "Draft a reply with a project proposal to that email from Steve"

  Requirements
  n8n instance (cloud or self-hosted)  
  Telegram Bot API credentials  
  Gmail, Google Calendar, and Google Contacts credentials (optional, if using those features)  
  OpenAI API key  
  ElevenLabs API Key (optional, if you need audio note support)

  How to customize
  Swap Gmail with another email provider by replacing the Gmail MCP node.  
  Add additional MCP integrations (e.g., Notion, Slack, CRM tools).  
  Adjust memory length to control how much context Jarvis remembers.  

  With this template, you can transform Telegram into your all-in-one AI assistant, simplifying workflows and saving hours every week.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpClientTool","n8n-nodes-base.googleTasksTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.telegramTrigger","n8n-nodes-base.switch","@elevenlabs/n8n-nodes-elevenlabs.elevenLabs","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleTasksTool","n8n-nodes-base.googleTasksTool","n8n-nodes-base.googleTasksTool","n8n-nodes-base.googleTasksTool","n8n-nodes-base.telegram","n8n-nodes-base.googleContactsTool","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpClientTool","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.filter","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.telegram","@elevenlabs/n8n-nodes-elevenlabs.elevenLabs","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 12976 characters]

metadata_json:
  {"categories":["AI/ML","Communication"],"complexity":"medium","use_cases":["Personal productivity assistant","Task and calendar management","Expense tracking","Unified inbox"],"estimated_setup_minutes":15,"required_services":["OpenAI","Telegram","Google Calendar","Google Tasks","External Spreadsheets"],"key_features":["MCP integration for external tools","Voice and text input support","Multi-domain automation","Natural language commands"],"target_audience":["productivity enthusiasts","personal assistants","automation managers"]}


name: Nano banana AI product image creator via WhatsApp
author_name: Roshan Ramani
author_username: rawsun007
categories: []
created_at: 2025-09-13T07:15:44.824Z
updated_at: 2025-09-13T07:15:44.824Z
url: https://n8n.io/workflows/8549
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:19
description:
  Nano Banana AI Product Image Creator via WhatsApp

  Transform ordinary product photos into premium marketing visuals instantly using Gemini AI for prompt enhancement and Nano Banana AI for image generation through WhatsApp.

  Who's it for
  Small business owners
  E-commerce sellers
  Social media managers
  Anyone selling products online

  What it does
  • Takes your normal product photo
  • Gets your text/caption as input
  • Gemini AI improves your basic prompt into professional instructions
  • Nano Banana AI generates new premium ad image using enhanced prompt
  • Keeps your original product exactly the same
  • Returns social media-ready marketing image

  Key Benefits
  Smart Prompt Enhancement - Gemini AI makes your simple text into professional prompts  
  Superior Image Generation - Nano Banana AI creates premium visuals
  Original Product Protected - Your product stays 100% unchanged  
  Fast Results - Get enhanced image in under 60 seconds  
  Easy to Use - Just send photo via WhatsApp  
  Social Media Ready - Perfect for Instagram, Facebook, ads  

  How it works
  Send Photo + Caption → Upload product image with your text
  AI Prompt Magic → Gemini AI turns your caption into professional prompt
  Image Generation → Nano Banana AI creates new premium ad using improved prompt
  Receive Result → Get marketing-ready image back instantly

  The Magic Process
  Your Input: "Make this look premium for Instagram"  
  Gemini AI Enhanced Prompt: "Create luxury product advertisement with professional studio lighting, marble background, elegant typography, commercial photography style, high-end visual appeal..."  
  Nano Banana AI Generated Result: Professional marketing image created with your improved prompt

  What you get
  • Better Prompts - Gemini AI turns simple text into detailed instructions
  • Professional Images - Studio-quality marketing visuals generated by Nano Banana AI
  • Same Product - Your original item stays unchanged
  • Quick Results - Ready in under 60 seconds

  Perfect for
  Instagram posts
  Facebook ads  
  Online store images
  Social media marketing

  Why This Combo Works Best
  Gemini AI** - Expert at understanding and enhancing text prompts
  Nano Banana AI** - Specialized for high-quality product image generation
  Best of Both** - Combines prompt expertise with image generation power
  Faster Results** - Optimized dual-AI workflow

  Perfect solution for creating professional product ads from simple WhatsApp messages using the power of both Gemini AI and Nano Banana AI.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.whatsAppTrigger","n8n-nodes-base.whatsApp","n8n-nodes-base.httpRequest","n8n-nodes-base.extractFromFile","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.whatsApp"]

workflow_json_compressed:
  H4sIAAAAAAAAE62WXW/bNhSG/4qgi12ZGUmRIpWruUnaGduSIElXDEMQ8OPQFmpTnsQ0DQr/91G2UdmuFHvAbiny5XO+XupbuoCg0vNvaemboLyBiU3P079uPt49Ta7vH8bXF1dPk8t0lAZYLOcqwEUNtrmH8Ly8qOIKBIgHQv0Mq1HqKwtNev53VGtVGJaGGmFQBlghpniOtFKALMky5pzTmhVR2asFxN33oTSfX5PrKkB73euyXfTSo7VqPNnAWbPes92yrJoylJWPF6IcyxGilD3GZVVHwQB104ZlKh/AhyiVrjaqf8Yv61NkNdqCaqqJ0ZwhpSxFDDuKVG4zJKmSwopCCC070E8zFZrxcpn8AU2jppDcgYHyS8zDEPbL9sRDXU6nUO+zMzliRR7BX0DPqupzV4BPV+9+vbn5bZP/vbCGQ7GOGbAuptuaAjGjHSoUF0hbRUleaJaZvAvlA4QYhS1V8vHu96P4+9xUngD+RE9Hl5m1YBVHOZERvWAGFbjQSHBsBaYWFNmpwmX14ueVsslk0dbgfTkfbptZCMs7+OcZmrAfA2dsG8ObjOyMfqdULi8Mj2zG5BlixABSRSaRwo7HbhEis6qj3MCFKnkXOXI2SAhfQ61MeF9Xi20kO5RS4hHD+Bhll8kCgBOZUQRGCMSkFEhZTJFROWBMqeIOOsbxJLmEppz6ZOzV/LUpmw7zl8j5c8c6V35qZqr0Z9Oqms7hAyxKX/5Iywt6Oq0T0oCjCmVYScQ0uDh92iJHhMJacJbZHdroOrr0sC37Tz3MB6ldQD09SCihGJ9S92yn7oApywlkiOSGI8aVRpq72AbSESN5ToxzHeVtDVEZkvHtJLlVr22jDgKayh7yRec8ha+j45YwY1yGBDamzWGOCkMlkpjlFAulohHsjr2HOnp5cuVnredvh+i/zw/J2UmgewMEudQql4hGr0LM6QxpJx2yMlqTIwVkzu6W23+BOmznp52kt1HNZv9D9eMYESnoKbDkrOtNlmeYAzHxZTAYMUHjy8AJRZwCl4ZwKDTdecLAH0vlgJdiiU8w0+y4mUaFmAIPplVev4D7Hh8XFnF+453xlW65jlnpevco/h5Y+Jqe49XjY7z00Nb6VI8Paq90jxv9H+pko94Xap/8oG8fMo++H3nLRnsj7fOIPpaj09qrPjQ4fTf09W2v6BBKf4WOTO4A9kBd+65402V75Yf/3foz3/t71KO8Wv0L9saqyEoLAAA=

metadata_json:
  {"categories":["Marketing","Media Processing"],"complexity":"medium","use_cases":["transform product photos","generate marketing visuals","enhance prompts via AI"],"estimated_setup_minutes":10,"required_services":["Google Gemini","Nano Banana AI","WhatsApp API","File Storage"],"key_features":["automatically enhance product prompts","generate professional marketing images","WhatsApp-integrated image generation"],"target_audience":["ecommerce sellers","social media managers","small business owners"]}


name: Bulk verify WhatsApp numbers using Rapiwa API and Google Sheets
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-09-13T11:18:08.297Z
updated_at: 2025-09-13T11:18:08.297Z
url: https://n8n.io/workflows/8555
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  WhatsApp Bulk Number Verification in Google Sheets Using Unofficial Rapiwa API

  Who’s it for
  This workflow is for marketers, small business owners, freelancers, and support teams who want to automate WhatsApp messaging using a Google Sheet without the official WhatsApp Business API. It’s suitable when you need a budget-friendly, easy-to-maintain solution that uses your personal or business WhatsApp number via an unofficial API service such as Rapiwa.

  How it works / What it does
  The workflow looks for rows in a Google Sheet where the Status column is pending.
  It cleans each phone number (removes non-digits).
  It verifies the number with the Rapiwa verify endpoint (/api/verify-whatsapp).
  If the number is verified:
    The workflow can send a message (optional).
    It updates the sheet: Verification = verified, Status = sent (or leaves Status for the send node to update).
  If the number is not verified:
    It skips sending.
    It updates the sheet: Verification = unverified, Status = not sent.
  The workflow processes rows in batches and inserts short delays between items to avoid rate limits.
  The whole process runs on a schedule (configurable).

  Key features
  Scheduled automatic checks (configurable interval; recommended 5–10 minutes).  
  Cleans phone numbers to a proper format before verification.  
  Verifies WhatsApp registration using Rapiwa.  
  Batch processing with limits to control workload (recommended max per run configurable).  
  Short delay between items to reduce throttling and temporary blocks.  
  Automatic sheet updates for auditability (verified/unverified, sent/not sent).  

  Defaults recommended in this workflow
  Trigger interval: every 5–10 minutes (adjustable).  
  Max items per run: configurable (example: 200 max per cycle).  
  Delay between items: 2–5 seconds (example uses 3 seconds).  

  How to set up
  Duplicate the sample Google Sheet: ➤ Sample  
  Fill contact rows and set Status = pending. Include columns like WhatsApp No, Name, Message, Verification, Status.  
  In n8n, add and authenticate a Google Sheets node pointed to your sheet.  
  Create an HTTP Bearer credential in n8n and paste your Rapiwa API key.  
  Configure the workflow nodes (Trigger → Google Sheets → Limit/SplitInBatches → Code (clean) → HTTP Request (verify) → If → Update Sheet → Wait).  
  Enable the workflow and monitor first runs with a small test batch.

  Requirements
  n8n instance with Google Sheets and HTTP Request nodes enabled.  
  Google Sheets OAuth2 credentials configured in n8n.  
  Rapiwa account and Bearer token (stored in n8n credentials).  
  Google Sheet formatted to match the workflow columns.

  Why use Rapiwa
  Cost-effective and developer-friendly REST API for WhatsApp verification and sending.  
  Simple integration via HTTP requests and n8n.  
  Useful when you prefer not to use the official WhatsApp Business API.  
  Note: Rapiwa is an unofficial service — review its terms and risks before production use.

  How to customize
  Change schedule frequency in the Trigger node.  
  Adjust maxItems in Limit/SplitInBatches for throughput control.  
  Change the Wait node delay for safer sending.  
  Modify the HTTP Request body to support media or templates if the provider supports it.  
  Add logging or a separate audit sheet to record API responses and errors.

  Best practices
  Test with a small batch first.  
  Keep the sheet headers exact and consistent.  
  Store API keys in n8n credentials (do not hardcode).  
  Increase Wait time or reduce batch size if you see rate limits.  
  Keep a log sheet of verified/unverified rows for troubleshooting.

  Example HTTP verify body (n8n HTTP Request node)
  {
    "number": "{{ $json['WhatsApp No'] }}"
  }

  Notes and best practices
  Test with a small batch before scaling.
  Store the Rapiwa token in n8n credentials, not in node fields.
  Increase Wait delay or reduce batch size if you see rate limits or temporary blocks.
  Keep the sheet headers consistent; the workflow matches columns by name.
  Log API responses or errors for troubleshooting.

  Optional
  Add a send-message HTTP Request node after verification to send messages.  
  Append successful and failed rows to separate sheets for easy review.

  Support & Community

  Need help setting up or customizing the workflow? Reach out here:

  WhatsApp: Chat with Support  
  Discord: Join SpaGreen Server  
  Facebook Group: SpaGreen Community  
  Website: SpaGreen Creative  
  Envato: SpaGreen Portfolio

nodes_used:
  ["n8n-nodes-base.splitInBatches","n8n-nodes-base.wait","n8n-nodes-base.limit","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE62X227bRhCGX4XgtdbY88F3iVEXLto4yKFBWuRiD7MSa5lURdqOY/jdO5RcS7KpyFJyIxDQ7uw3Mzv/zN6VVSqPy38+v//rw2euvlWfb25OfjstR+UldL48viuruu18HeGsXxeD8wyU4MxoE7RgWgtpuBWScWFAaRm4ssYHpoKR0VNvHQTKvRLSyqTL+1FZ+0tAU58mvmtfzWbF66vpRfHm6jLAvPgT5lWuou+qpi6quvi1acZTKN5PALq2+NhW9bj4WDcZ11R+Wrzzs+rGF6/eniFw58dtefz3FzyhSdB/3i2doyEJrnQizqdIkEITz7QjMkIOnFLJXSgfuX5vmllxfo0wZx1ctr3h21n/R21rsrBMgm/hqJ1Nq+6sfu27OIF+2axpq54bD2ZW6ZHSFFlmfo52O5gj0B16D18hXnVwjhEtj7OftrA8AD1vF5vF/eiB22cOIsdApFfIzRgjgVJBmNfRBCMYN2nF/clX3VbYm+Wfa4jCGEQ0GhFvIEya5mKRYJ6AQrSZUCczHmwkCcbh6ZhO4FZbm2z53KsND9gRe/QBWOZaskhykJRInjLa84ZIYFxKiNJEuRb76vI7Tkwf/l0PtKJyS6A3kR6BRHY6Wq6JxewTREjEGwjEaUcdCwz0elDfd1W8uC3eNB2w7TdhsahfswlHR8Q+IytjU3dQd2im3E4paQraIBtXDINlo0BeQYnmKmH1GWcMrCjP8la2Km8ycW34SGq5K2D8iK9CxiAkqQ2eLhiRmgkSeKIkQoiMhwg6qxXMKWBBFK+m0+It1Kkv2BP02Ees39z8X+H1eCvxeFHyy4p/kmxu6ZZk1xj89qw+nTY3j1U1h25+e16f+mo6XGnySK98jFRlayMJ0nsiTbbEuWAIZBOcU9ql7FY+nkx8PUZZ6nwHRZOLd81N28vVyQTiBaQDfOtVdCSfX5eneVln9oxqm1HSFE+YF4HS4HwAQjEtDjVCR/BrVxm6BfBV+5CD73BG/HzCR1HRhN19bx7prIkgtU1EG4oRtRaIYwzpOOVM6mCdcoN0H+vrA/mWcvZCPkcx3FoaYhKmXaKWEuxSgRjA2AFNKQa6lvEp+Lp47FnLdrUHH7osX5LfFZ8PCZhHNKeoQiXGgvOCZcKCVU5Yj3W3JgGLlN4+BXzomMs2uZV20nWzd/DvFbRP1JULbbdA72xjck1AdDIqB4u3ICn8AZWJdagnPAbgOFEY7/LKlQ/zajxG9l/wGtwWjBZ/VPXVQlu3yC/233Q1hYd9my44+bL+sE7LQFIGgpggBZEq4cUFlOKQlVU0Wck2Lu6qQ+zdIIzQh7cIHrxUWWkCeIuJRJHC6QC/UogKBRu9iGEQk+/NyRjeg4NBUxSgorTEpx7UGk6c8ZmozJzy2MuCi4OgYm9QjjV9OCgLCnQUHM/I2HQ1XljnpSaoDzyK5CQYMwgq94+oYfxw0Kyw7UJ2KFh9RFHpMaJC411VOVMBKF0wCKr2j6jm8gfGGJUc5ckRi1MLzttJEhwhA4kR5y5tJaeMDYLqvUGF0D8wb+FYlfCJoAgC96nHsnIOO1b2SG4oFpS0g6Bmf9CDUo+rcYSqrldq20LXobgvti7VGJeezxMq4HF5zXob18v9i8EeOLXYgxOhOBfgYwI9tJlnEoXKPgqhnO3rDSFqiL2phWGcLPH30lc9Ob6nev92zRKL1SN8Nyb4Wh5TRB/cONTmn239gl4sHjZDFFtfaoNmlm+Ln2Dnyeo1i+ue7hgYBk0PhXUI+MXj5+Apw2RD5+w1VOzyaC3fP9+nbTPD0El7P1CGo7iDd+jkzSf6oNmXhHzI9PoTcNDwS70eLJDNZ/mA/fv7/wDVy+xaSRIAAA==

metadata_json:
  {"categories":["Marketing","Communication"],"complexity":"medium","use_cases":["bulk whatsapp verification","phone number validation","contact list management"],"estimated_setup_minutes":30,"required_services":["Google Sheets","Rapiwa API"],"key_features":["automate number verification","read/write to spreadsheets","batch processing"],"target_audience":["marketers","small business owners","freelancers"]}


name: Send bulk WhatsApp messages from Google Sheets using Rapiwa API
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-09-13T13:51:21.257Z
updated_at: 2025-09-13T13:51:21.257Z
url: https://n8n.io/workflows/8558
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  Bulk WhatsApp Campaign Automation with Rapiwa API (Unofficial Integration)

  Who’s it for
  This n8n workflow lets you send bulk WhatsApp messages using your own number through Rapiwa API, avoiding the high cost and limitations of the official WhatsApp API. It integrates seamlessly with Google Sheets, where you can manage your contacts and messages with ease. Ideal for easy-to-maintain bulk messaging solution using their own personal or business WhatsApp number.
  This solution is perfect for small businesses, marketers, or teams looking for a cost-effective way to manage WhatsApp communication at scale.

  How it Works / What It Does
  Reads data from a Google Sheet where the Status column is marked as "pending".
  Cleans each phone number (removes special characters, spaces, etc.).
  Verifies if the number is a valid WhatsApp user using the Rapiwa API.
  If valid:
    Sends the message via Rapiwa.
    Updates Status = sent and Verification = verified.
  If invalid:
    Skips message sending.
    Updates Status = not sent and Verification = unverified.
  Waits for a few seconds (rate-limiting).
  Loops through the next item.
  The entire process is triggered automatically every 5 minutes.

  How to Set Up
  Duplicate the Sample Sheet: Use this format.
  Fill Contacts: Add columns like WhatsApp No, Name, Message, Image URL, and set Status = pending.
  Connect Google Sheets: Authenticate and link Google Sheets node inside n8n.
  Subscribe to Rapiwa: Go to Rapiwa.com and get your API key.
  Paste API Key: Use the HTTP Bearer token credential in n8n.
  Activate the Workflow: Let n8n take care of the automation.

  Requirements
  Google Sheets API credentials
  Configured Google Sheet (template linked above)
  WhatsApp (Personal or Business)
  n8n instance with credentials setup

  How to Customize the Workflow
  Add delay between messages**: Use the Wait node to introduce pauses (e.g., 5–10 seconds).
  Change message format**: Modify the HTTP Request node to send media or templates.
  Personalize content**: Include dynamic fields like Name, Image URL, etc.
  Error handling**: Add IF or SET nodes to capture failed attempts, retry, or log errors.

  Workflow Highlights
  Triggered every 5 minutes** using the Schedule Trigger node.
  Filters messages** with Status = pending.
  Cleans numbers* and *verifies WhatsApp existence** before sending.
  Sends WhatsApp messages** via Rapiwa (Unofficial API).
  Updates Google Sheets** to mark Status = sent or not sent and Verification = verified/unverified.
  Wait node** prevents rapid-fire sending that could lead to being flagged by WhatsApp.
  Setup in n8n
  1. Connect Google Sheets
  Add a Google Sheets node
  Authenticate using your Google account
  Select the document and worksheet
  Use filter: Status = pending

  2. Loop Through Rows
  Use SplitInBatches or a Code node to process rows in small chunks (e.g., 5 rows)
  Add a Wait node to delay 5 seconds between messages

  3. Send Message via HTTP Node
  How the "Send Message Using Rapiwa" Node Sends Messages
  This node makes an HTTP POST request to the Rapiwa API endpoint:  
      https://app.rapiwa.com/api/send-message
  It uses Bearer Token Authentication with your Rapiwa API key.
  When this node runs, it sends a WhatsApp message to the specified number with the given text and optional image.
  The Rapiwa API handles message delivery using your own WhatsApp number connected to their service.

  JSON Body**:
  {
    "number": "{{ $json['WhatsApp No'] }}",
    "message": "{{ $json['Message'] }}"
  }
  Sample Google Sheet Structure
  A Google Sheet formatted like this sample  

  | SL | WhatsApp No   | Name                  | Message             | Image URL                                                                 | Verification | Status  |
  |----|----------------|------------------------|----------------------|---------------------------------------------------------------------------|--------------|---------|
  | 1  | 8801322827799 | SpaGreen Creative      | This is Test Message | https://spagreen.sgp1.cdn.digitaloceanspaces.com/...                      | verified     | sent    |
  | 2  | 8801725402187 | Abdul Mannan Zinnat    | This is Test Message | https://spagreen.sgp1.cdn.digitaloceanspaces.com/...                      | verified     | sent    |
  Tips
  Modify the Limit node to increase/decrease messages per cycle.
  Adjust the Wait node to control how fast messages are sent (e.g., 5–10s delay).
  Make sure WhatsApp numbers are properly formatted (e.g., 8801XXXXXXXXX, no +, no spaces).
  Store your Rapiwa API key securely using n8n credentials.
  Use publicly accessible image URLs if sending images.
  Always mark processed messages as "sent" to avoid duplicates.
  Use the Error workflow in n8n to catch failed sends for retry.
  Test with a small batch before going full-scale.
  Schedule the Trigger node for every 5 minutes to keep automation running.
  Useful Links
  Dashboard:** https://app.rapiwa.com
  Official Website:** https://rapiwa.com
  Documentation:** https://docs.rapiwa.com

  Support & Community
  Need help setting up or customizing the workflow? Reach out here:
  WhatsApp: Chat with Support  
  Discord: Join SpaGreen Server  
  Facebook Group: SpaGreen Community  
  Website: SpaGreen Creative  
  Envato: SpaGreen Portfolio

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.limit","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE62Y308jNxDH/5XVPvQpPvn32rxd6VEh9X5y15Na3cPYHsOKZDfNbuAo4n/vbEAk4TYHgb6gKLFnPjOe+XrMdVmn8qD8y/rfPl79G7o3n08WR81ROSln2EN5cF3WTddDE/F4WBeDB4FGSVHZKlglrFW6kk5pIVWFxuogjasgCBMqHYGD8xi4BKO008mS3R5n8yn0eLjA1J1gv5wftvQN9kgO+sUSbyZlAzMkbyfYpCIsp+fF1zPou9fzeTHDroNT7Iq8aGfF7217OsXi5Ayx74plVzenxSeY15dQvP5wPDiD0648+PsbmWwTDh+vbwO2OaesnGCBQ2Jaq8yCjJJpBcHa4ETWorwHOcI+nhWvp9PiAyENXj4ucVEPGO2ieLtiom8Hh1fzYUPjGrbyyAJ0+Op0xXmLSYvmbVf3ddsQDqVNTiiZRDiHBXnrcUGY10MS2h674+Zo2l6WBxmmHU7KBfaLq/fNEdTT++8Gl3/SrpVB/creTO5iTCKjqLhjoao40yFx5oUODIMDKy0XCt06xj/adl68v8BFcUxH1O2MpZtP6/64+RUoJfgwGi/5jmjwO8Zlj++pksbJ1T23UJkrqhdmpVJ0IpyzYKNjmLxDpyx4tcldz+p+J+307tdNSGPdDsgtIHEPFI2A6GLFQFrLdJSZQUTLVLYcMakcKrkG+ryoT08pjW8ol1eFKd7WDQW+O5+UxrSc4t22bVYvdlXHNuoreQ+rBXrrvWcAlWZaJMdcMoF5KzBGEWPkuIY9nCI06/Z6t5yFFcM4a6SP24BSSj2hY3+McM2Xk+dWcMksDp3HM/Wgk4IJoy23gQ4423JbAm4bDIsvGw2+k/Gs7+ef8J8ldg/OXSnLJ9I8qzj1RoIVR2M0pTVySeWZYRARYRhG6YQUGZxNGwH0dTy/Kt61PyuB1Zq7JRvEldMTJrl7SFzGtumx6clSubtqjeA6oKVCiNYx7eiPTz5QtoXlErk2lRvllHuDCnL1ElKsDCoVWUATmfaZhEqBYYZXAoBTvoUeJVX7k2pjX0CqZTYVnTbjWSJdG35F6lmMGUyQgjrNj5Lq/Ukddy8gDaSiwWVgPEaSAfCZueAiozs6qspKl/gG6eEZxvPiAqZ1Ki4HMQASg2YlBltdJ/ZvO2kGDXtcITZbjOcstCaF5ZGETIOgNJNqMFEl9N4JynUYTbPge+dZUje8IM8SK5WM5Sxrboa7wTCfJbDsFf1gk0apRlH9/qSVkS8gteCytwQJpAokvLpi3pAeeBrTklSABmE8qfsLgpL8JUklcQpSA9KF60m6IEvmKmo4X4WAAaKiWW0cdX9FWKFq/8O18MQ2kxFxyKKJNF7pqCXzEjRT0fEICErzjdvsK/xkVLmEh5MKXVh8QrVFaJcYztr2fDWE26grjUbTIEeaqXNMLGhDdaedkpI46BYqH50Y1jG4KmaeONK8lTPNW9lTtj0MhREUXWZGi41uO847I6jzg4IdxhetHh8ONlofrTE5GsuS06SwLigGQ6yJhvIsrXM2bukWNDQYnPT0oCjaXHxqL7uibgoyXecaU/FLcTKc4f6D+Sr349PCzoFbxsq6RFoAUg8dVlU0uGbLIgoSBprGLcrH2b80F2t6qtdnRzDMO7fV8+QIkvNSBlsxJxxFIJEm3UD1ABkRKuV4Cma08czefceI7xkSQash9vXFelDrsO/phlptvR3kaOn7RaI59qC8EIONi9v9q+5JQQYfs2NZKLpbPD0sACU9MehtIRzVurFDtRNEg3EwtTJMVU9/Z1AP6PSIHAJ82ni62jOhZ3TC7+UBpwDW259ZAj+Y/EYxrrRljHHnw27UzO1z6n+w82D1hsWtDPz8/TFqenzPGPIzxppRjzuedGMu9/5XwajD3XU1HuaeKjie1idaGSPYvthGzT81MaOlt/3G34H/1LMe87B5q+2VnfFWfVaObm7+A/a0Cs6OEwAA

metadata_json:
  {"categories":["Data Processing","Communication"],"complexity":"medium","use_cases":["send bulk whatsapp messages","manage contacts via google sheets","automate whatsapp campaigns","integrate sms with spreadsheets","schedule whatsapp blasts"],"estimated_setup_minutes":15,"required_services":["Google Sheets","Rapiwa API"],"key_features":["bulk message sending","sheet-based contact management","personal number support","cost-effective messaging","scheduled campaigns"],"target_audience":["marketers","small business owners","customers"]}


name: AI Shopify Product Descriptions: GPT-4o Vision + Claude + Analytics
author_name: Kumar Shivam
author_username: shivam840708
categories: []
created_at: 2025-09-13T20:07:15.240Z
updated_at: 2025-09-13T20:07:15.240Z
url: https://n8n.io/workflows/8562
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  Complete AI Product Description Generator
  Transforms product images into high-converting copy with GPT-4o Vision + Claude 3.5
  The Shopify AI Product Description Factory is a production-grade n8n workflow that converts product images and metadata into refined, SEO-aware descriptions—fully automated and region-agnostic. It blends GPT-4o vision for visible attribute extraction, Claude 3.5 Sonnet for premium copy, Perplexity research for verified brand context, Google Sheets for orchestration and audit trails, plus automated daily sales analytics enrichment. Link-header pagination and structured output enforcement ensure reliable scale.



  To refine according to your usecase connect via my profile
  @connect

  Key Advantages

  Vision-first copywriting
  Uses gpt-4o to identify only visible physical attributes (closure, heel, materials, sole) from product images—no guesses.

  Premium copy generation
  anthropic/claude-3.5-sonnet crafts concise, benefit-led descriptions with consistent tone, length control, and clean formatting.

  Research-assisted accuracy
  perplexityTool verifies vendor/brand context from official sources to avoid speculation or fabricated claims.

  Pagination you can trust
  Automates Shopify REST pagination via Link headers and persists page_info for resumable runs.

  Google Sheets orchestration
  Centralized staging, status tracking, and QA in Products, with ProcessingState for batch/page markers, and Error_log for diagnostics.

  Bulletproof error feedback
  errorTrigger + AI diagnosis logs clear, non-technical and technical explanations to Error_log for fast recovery.

  Automated sales analytics
  Daily sales tracking automatically captures and enriches total sales data for comprehensive business intelligence and performance monitoring.

  How It Works

  Intake and filtering
  httpRequest fetches /admin/api/2024-04/products.json?limit=200&{page_info}
  code filters only items with:
    Image present
    Empty body_html
    The currSeas:SS2025 tag
  Extracts tag metadata such as x-styleCode, country_of_origin, and gender when available

  Pagination controller
  code parses Link headers for rel="next" and extracts page_info
  googleSheets updates ProcessingState with page_info_next and increments the batch number for resumable polling

  Generation pipeline
  googleSheets pulls rows with Status = Ready for AI Description; limit throttles batch size
  openAi Analyze image (model gpt-4o) returns strictly visible features
  lmChatOpenRouter (Claude 3.5) composes the SEO description, optionally blending verified vendor context from perplexityTool
  outputParserStructured guarantees strict JSON: product_id, product_title (normalized), generated_description, status
  googleSheets writes results back to Products for review/publish

  Sales analytics enrichment
  Schedule Trigger** runs daily at 2:01 PM to capture previous day's sales
  httpRequest fetches paid orders from Shopify REST API with date range filtering
  splitOut and summarize nodes calculate total daily sales
  Automatic Google Sheets logging with date stamps and totals
  Zero-sale days are properly recorded for complete analytics continuity

  Reliability and insight
  errorTrigger routes failures to an AI agent that explains the root cause and appends a concise note to Error_log.

  What's Inside (Node Map)

  Data + API
  httpRequest (Shopify REST 2024-04 for products and orders)
  googleSheets (multiple sheet operations)
  googleSheetsTool (error logging)

  AI models
  openAi (gpt-4o vision analysis)
  lmChatOpenRouter (anthropic/claude-3.5-sonnet for content generation)
  AI Agent** (intelligent error diagnosis)

  Analytics & Processing
  splitOut (order data processing)
  summarize (sales totals calculation)
  set nodes (data field mapping)

  Tools and guards
  perplexityTool (brand research)
  outputParserStructured (JSON validation)
  memoryBufferWindow (conversation context)

  Control & Scheduling
  scheduleTrigger (multiple time-based triggers)
  cron (periodic execution)
  limit (batch size control)
  if (conditional logic)
  code (custom filtering and pagination logic)

  Observability
  errorTrigger + AI diagnosis to Error_log
  Processing state tracking
  Sales analytics logging

  Content & Compliance Rules

  Locale-agnostic copy**; brand voice is configurable per store
  Only image-verifiable attributes** (no guesses); clean HTML suitable for Shopify themes
  Optional normalization rules (e.g., color/branding cleanup, title sanitization)
  Style code inclusion supported when x-styleCode is present
  Gender-aware content generation when gender tag is present
  Strict JSON output** and schema consistency for safe downstream publishing

  Setup Steps

  Core integrations
  Shopify Access Token** — Products read + Orders read (REST 2024-04)
  OpenAI API** — gpt-4o vision
  OpenRouter API** — Claude Sonnet (3.5)
  Perplexity API** — vendor/market verification via perplexityTool
  Google Sheets OAuth** — Products, ProcessingState, Error_log, Sales analytics

  Configure sheets
  ProcessingState** with fields:
    batch number
    page_info_next
  Products** with:
    Product ID
    Product Title
    Product Type
    Vendor
    Image url
    Status
    country of origin
    x_style_code
    gender
    Generated Description
  Error_log** with:
    timestamp
    Reason of Error
  Sales Analytics Sheet** with:
    Date
    Total Sales

  Workflow Capabilities

  Discovery and staging
  Auto-paginate Shopify; stage eligible products in Sheets with reasons and timestamps.

  Vision-grounded copywriting
  Descriptions reflect only visible attributes plus verified brand context; concise, mobile-friendly structure with gender-aware tone.

  Metadata awareness
  Auto-injects x-styleCode, country_of_origin, and gender when present; natural SEO for brand and product type.

  Sales intelligence
  Automated daily sales tracking with Melbourne timezone support, handles zero-sale days, and maintains complete historical records.

  Error analytics
  Layman + technical diagnosis logged to Error_log to shorten MTTR.

  Safe output
  Structured JSON via outputParserStructured for predictable row updates.

  Credentials Required

  Shopify Access Token** (Products + Orders read permissions)
  OpenAI API Key** (GPT-4o vision)
  OpenRouter API Key** (Claude Sonnet)
  Perplexity API Key**
  Google Sheets OAuth**

  Ideal For

  E-commerce teams** scaling compliant, on-brand product copy with comprehensive sales insights
  Agencies and SEO specialists** standardizing image-grounded descriptions with performance tracking and analytics
  Stores** needing resumable pagination, auditable content operations, and automated daily sales reporting in Sheets

  Advanced Features

  Dual-workflow architecture**: Content generation + Sales analytics in one system
  Link-header pagination with page_info persistence in ProcessingState
  Title/content normalization (e.g., color removal) configurable per brand
  Gender-aware copywriting** based on product tags
  Memory windows (memoryBufferWindow) to keep multi-step prompts consistent
  Melbourne timezone support** for accurate daily sales cutoffs
  Zero-sales handling** ensures complete analytics continuity
  Structured Output enforcement for downstream safety
  AI-powered error diagnosis** with technical and layman explanations

  Time & Scheduling (Universal)

  The workflow includes two independent schedules:
  Content Generation**: Every 5 minutes (configurable) for product processing
  Sales Analytics**: Daily at 2:01 PM Melbourne time for previous day's sales

  For globally distributed teams, schedule triggers and timestamps can be standardized on UTC to avoid regional drift.

  Pro Tip

  Start with small batches (limit set to 10 or fewer) to validate both copy generation and sales tracking flows. The workflow handles dual operations independently - content generation failures won't affect sales analytics and vice versa. Monitor the Error_log sheet for any issues and use the ProcessingState sheet to track pagination progress.

nodes_used:
  ["@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.errorTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.perplexityTool","n8n-nodes-base.stickyNote","n8n-nodes-base.perplexityTool","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheets","n8n-nodes-base.limit","n8n-nodes-base.cron","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.limit","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.set","n8n-nodes-base.manualTrigger","n8n-nodes-base.code","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.summarize","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 17144 characters]

metadata_json:
  {"categories":["E-Commerce","Marketing"],"complexity":"medium","use_cases":["generate product descriptions","process product images","extract product attributes","create SEO-optimized copy","enhance e-commerce listings"],"estimated_setup_minutes":20,"required_services":["Shopify","OpenRouter","Google Sheets","Perplexity"],"key_features":["GPT-4o Vision for image analysis","Claude 3.5 Sonnet for copy generation","Perplexity for brand research","Region-agnostic text translation","SEO-aware content creation"],"target_audience":["e-commerce managers","digital marketers"]}


name: Automated WhatsApp welcome messages for sales leads with Google Sheets & Rapiwa
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-09-14T07:40:19.761Z
updated_at: 2025-09-14T07:40:19.761Z
url: https://n8n.io/workflows/8572
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  Automated WhatsApp Welcome Messages for Sales Leads with Google Sheets & Rapiwa

  Who is this for?

  This automation is ideal for sales teams, digital marketers, support agents, or small business owners who collect leads in Google Sheets and want to automatically send WhatsApp welcome messages. It's a cost-effective and easy-to-use solution built for those not using the official WhatsApp Business API but still looking to scale communication.

  What this Workflow Does

  This n8n automation reads leads from a connected Google Sheet, verifies if the provided WhatsApp numbers are valid using the Rapiwa API, and sends a personalized welcome message. It updates the sheet based on delivery success or failure, and continues this process every 5 minutes — ensuring new leads are automatically engaged.

  Key Features
  Automatic Scheduling**: Runs every 5 minutes (adjustable)
  Google Sheets Integration**: Reads and updates lead data
  WhatsApp Number Validation**: Confirms number validity via Rapiwa
  Personalized Messaging**: Uses lead name for custom messages
  Batch Processing**: Sends up to 60 messages per cycle
  Safe API Usage**: Adds 5-second delay between each message
  Error Handling**: Marks failed messages as not sent and unverified
  Live Status Updates**: Sheet columns are updated after each attempt
  Loop Logic**: Repeats continuously to catch new rows

  How to Use

  Step-by-step Setup

  Prepare Your Google Sheet
     Copy this Sample Sheet
     Ensure it includes the following columns:
       WhatsApp No
       name  (note: trailing space is required)
       row_number
       status, check, validity

  Connect Google Sheets in n8n
     Use OAuth2 credentials to allow n8n access
     Set the workflow to fetch rows where check is not empty

  Get a Rapiwa Account
     Sign up at https://rapiwa.com
     Add your WhatsApp number
     Retrieve your Bearer Token from your Rapiwa dashboard

  Configure HTTP Request Nodes
     Use Rapiwa's API endpoints:
       Verify Number: https://app.rapiwa.com/api/verify-whatsapp
       Send Message: https://app.rapiwa.com/api/send-message
     Add your Bearer Token to the header

  Start Your Workflow
     Run the n8n automation
     It will read leads, clean phone numbers, verify WhatsApp validity, send messages, and update the sheet accordingly

  Requirements
  A Google Sheet with correctly formatted columns
  Active Rapiwa subscription (~$5/month)
  A valid Bearer Token from Rapiwa
  Your WhatsApp number connected to Rapiwa
  n8n instance with:
    Google Sheets integration (OAuth2 setup)
    HTTP Request capability

  Google Sheet Column Reference


  | name            | number        | email             | time                        | check   | validity   | status    |
  |-----------------|--------------|-------------------|-----------------------------|---------|------------|-----------|
  | Abdul Mannan	  | 8801322827799| contact@spagreen.net| September 14th 2025, 10:34  | checked | verified   | sent      |
  | Abdul Mannan	  | 8801322827798| contact@spagreen.net| September 14th 2025, 10:34  | checked | unverified | not sent  |

  Workflow Logic Summary
  Trigger Every 5 Minutes
  Fetch All Rows with Pending Status
  Limit to 60 Rows per Execution
  Clean and Format Phone Numbers
  Check Number Validity via Rapiwa
  Condition Check:
     If valid → Send Message
     If invalid → Update status as not sent, unverified
  Send WhatsApp Message via Rapiwa
  Update Sheet Row
     On success: sent, verified, checked
     On failure: not sent, unverified
  Delay 5 seconds before next message
  Repeat for next lead

  Customization Ideas
  Add image or document sending support via Rapiwa
  Customize messages based on additional fields (e.g., product, service)
  Log failures to a separate sheet
  Send admin email for failed batches
  Add support for multilingual messages

  Notes & Warnings
  The column name "name " includes a space — do not remove or rename it.
  International number format is required for Rapiwa to work correctly.
  If you're sending many messages, increase the Wait node delay to prevent API throttling.

  Support
  WhatsApp Support: Chat Now
  Discord: Join SpaGreen Community
  Facebook Group: SpaGreen Support
  Website: https://spagreen.net
  Developer Portfolio: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.limit","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if"]

workflow_json_compressed:
  H4sIAAAAAAAAE61XTW/bRhD9K4QOPWmN/f7wLTWSwEASt3GTHIoc9mPWJkKRqkhZcQ3/9w4lx1IU0pbtXgSC2p158/bN2+HNpEyT48nq89UH//rMVm9pdfr+30+T6WQGnZ8c30zKuu18HeG0XxeD8wyU4MxoE7RgWgtpuBWScWFAaRm4ssYHpoKR0VNvHQTKvRLSyqQxbgezeeU7OFlAas+hW85PGnwDHWCCbrGE2+mk9jPAbK+WXTPDpan4cum79tV8XnyBKjYzKN5D2/oLaIvcLIpzX+HTO/CpLVZld1m8bZqLCorzS4CuLX4rPvp5ufJ9cn/RTo7//oopmgT9482GAKoUzVJzEhzTRJokSICQSVBUJU+ZNzlN7oGdd2X8dl18aDrog17P+5e1rck6Kgm+haN2veZuybxpy65sakxIuBF6SqyliGLuFxixg0XbUx2buoO6w1iT203Yz/jPehu7nf5AaiXL1FNiqOREUumI1fikk6TOmhw1NVukb6CLl8Wrqir+gDqV9UXx5xIW5R1xGxbxLRst42JN5YbJvUIYNXxKpNP7hfQniHW3p/WbqllNjrOvWphOFtAtrs/qN76s7t/9VKQ80vdlcsO1oFwRmhgjEnQgIVtJUrYguHYxcbkt8105K7vxIqr+7z30Wukx8CPMQ1ImBRuJZtwQqSTKw3hGglbeGGsMmLCFdFKBr7fC/bCcBViMQ4z4+DNC1uP7VSX7+Pg9PgOM0pRifzCAylCOOBqRNxkhi6Si8DvKeNc08+LsChbFKbZkO67jeVV2p/XvHoUE+xKQbJRE+A5x2cEZWsfwaYt74Mm7BDkrpNMhsQ5/PAdOlOMiU5dNZHan+VDIP/q/+NT2mt709zi5l103/wj/LKHdU4Ht8TNuHyNZHm1p9qBCjpmSzKJCBrwiPklLeKYxOpm9F3GL9tM8oYMVi2bVHhfYFUWLHY6WtKyR+jKXkJ7Tez3ux6Wx2085sqC4UyShnREpAJBjo4jgWangsKGCHEF9h/gleBmV9ECit5AVl1FL7H5jOXoyIOXecEFAZ28kM8oGt4X8xT/kACu/bwBrSGsOVxAum+bb+oLTURoJShIIIhKZY8L2UYo4aQXnMVHG+yQPO8bR1jNYdtmBQsadkCgWdLAgUx8UZZK4UMzviOXkEuK34spXZSpWvXN4dI567RwvVTrn8iA72VW6YFEwJzLxUeEBeLDEcs4I1ZAtN5lSgMFL0Tz9VmSaokLsr1Zy2K2YGbqzdannGc/N403uchBEhZBptiJQrwah2mdA5dK+AKoV3jGlFUEfQUkoxYi3wRAtqYlABY06DEJ1T4dq9EuQqsyUjf01EnukUQriDFXExqCtFMGjDAaRMvocVl8CVVAPOGRakkV//qDR3kB61KtTMSLJqIJhqOO9NAZVavkCpJxCtBApgczRFmgGVCreeDYzFjllEAzbIv1rUV5cYPe/Rve9LlTxvqzxUn0AM17SaVnB3b59jhWVhw09Oy5gNI7wzjuifA5E8iwIytURrlMIlktH+c5ofJpHsZX5ZzhK0+nj4w0iwTU+duXVdpBooevQDtesbwYNXHy2SFjx8eSK9fRfbSKsXR1Z1snzTBRTAuvHYgJznkQqtFJGRAY9Njy/GmIfah0YS8HfmS97sPih0Jdy4Pyx3jTFb6cE3yfHFCvY7n/SRPBLoK9Y2uaqG8I2OtQNxrmbmv+HQHurdyLuVv7YSDwYe2TTEOhnXJ+DKceabijn0z+wBlM+IKqhrAfOZ4OpHt47lG1vtHo86oiqnxv7YI4Hlbz3aTgssoOVM5Ri1/MGwt/e/ge3iuLLZhEAAA==

metadata_json:
  {"categories":["Communication","Sales","Marketing"],"complexity":"medium","use_cases":["Send WhatsApp welcome messages","Process sales leads","Notify sales teams"],"estimated_setup_minutes":15,"required_services":["Google Sheets","RapiWA"],"key_features":["Batch message processing","Conditional message routing","AI content generation"],"target_audience":["sales teams","digital marketers","small business owners"]}


name: Forum pulse for Telegram: community monitoring with Gemini & Groq AI models
author_name: Nguyễn Thiệu Toàn (Jay Nguyen)
author_username: nguyenthieutoan
categories: []
created_at: 2025-09-14T08:35:16.127Z
updated_at: 2025-09-14T08:35:16.127Z
url: https://n8n.io/workflows/8573
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  ForumPulse for n8n – Daily Pulse & On-demand Deep Dives

  Author: Nguyen Thieu Toan  
  Category: Community & Knowledge Automation  
  Tags: Telegram, Reddit, n8n Forum, AI Summarization, Gemini, Groq

  How it works

  ForumPulse is an AI-powered assistant that keeps you connected to the latest discussions around n8n.  
  The workflow integrates Reddit (r/n8n) and the n8n Community Forum, fetches trending and recent posts, and uses Gemini/Groq AI models to generate clean, structured summaries.  

  It works in two complementary modes:

  Daily Pulse (Automated Digest):  
     Runs on schedule (default: 8:00 AM) to gather highlights and deliver a concise summary directly to your Telegram.

  On-demand Deep Dive (Interactive):  
     Listens to Telegram queries in real-time, detects intent (search, deep dive, open link, or chat), and provides summaries, comments, and insights for any chosen post.  

  When AI intent detection confidence drops below 0.7, the bot automatically asks for clarification before proceeding—ensuring accuracy and transparency.

  Step-by-step

  1. Setup & Prerequisites
  n8n instance** (cloud or self-hosted).  
  Telegram Bot** (created via BotFather).  
  MongoDB** (optional, for persistent memory).  
  API keys** for Gemini and Groq.  
  Your Telegram user ID** (to receive replies).  

  ⚠️ Replace all test credentials and tokens with your own. Never commit real secrets into exported templates.

  2. Daily Pulse Automation
  Schedule Trigger** runs the workflow every morning at the configured time.  
  Reddit + Forum Search** collects hot/new topics.  
  Merge Results** combines both sources into a unified dataset.  
  AI Summarizer Overview** condenses the results into a short, engaging digest.  
  Telegram Output** delivers the digest, automatically split into safe chunks under 2000 characters.

  3. On-demand Interaction
  Telegram Trigger** listens for incoming messages.  
  Intent Analysis (AI Agent)* classifies the query as *Search | Open Link | Deep Dive | Chitchat.  
  Confidence Gate**: if confidence &lt; 0.7, sends a clarification prompt to the user.  
  Branch by Intent**:  
    Search: Query Reddit/Forum with filters.  
    Open Link: Fetch details of a specific post.  
    Deep Dive: Retrieve comments and metadata.  
    Chitchat: Respond conversationally.  
  AI Summarizer** structures the output, highlighting trends, issues, and takeaways.  
  Telegram Delivery** formats and sends the reply, respecting HTML tags and message length.

  4. Deep Dive Details
  Post Extraction** fetches titles, authors, timestamps, and stats.  
  Comment Parsing** organizes replies into structured data.  
  Merge Post + Comments** builds a complete context package.  
  Summarizer** produces detailed, actionable insights.  

  5. Error Handling & Safety
  Confidence Check** prevents wrong answers by requiring clarification.  
  Error Paths** handle API downtime or unexpected formats gracefully.  
  Auto Chunking** avoids Telegram’s message length cap (2000 chars).  
  Safe Defaults** ensure fallback queries when inputs are missing or unclear.

  Customization Options

  Sources**: Add or replace platforms by editing HTTP Request nodes.  
  Schedule**: Change the cron time in the Schedule Trigger (e.g., 7:30 AM).  
  Filters**: Adjust default sort order, time ranges, and result limits.  
  AI Persona**: Reword the systemMessage in AI Agent nodes to change tone (professional, casual, emoji-rich).  
  Languages**: Auto-detects user language, but you can force English or Vietnamese by editing prompt settings.  
  Memory**: Enable MongoDB nodes for persistent user context across sessions.  
  Integrations**: Extend beyond Telegram—send digests to Slack, Discord, or email.  
  Models**: Swap Gemini/Groq with other supported LLMs for experimentation.  

  ✨ Crafted by Nguyen Thieu Toan with a focus on clarity, reliability, and community-driven insights.  
  This workflow is not just functional - it reflects a design philosophy: automation should feel natural, transparent, and genuinely useful.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGroq","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.memoryMongoDbChat","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.html","n8n-nodes-base.html","n8n-nodes-base.httpRequest","n8n-nodes-base.html","n8n-nodes-base.html","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.memoryMongoDbChat","n8n-nodes-base.merge","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.memoryMongoDbChat","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.memoryMongoDbChat","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegramTrigger","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 37100 characters]

metadata_json:
  {"categories":["Communication","AI/ML","Community Management"],"complexity":"medium","use_cases":["monitor community forums","summarize discussions","post to Telegram","track trending topics","extract insights from forums"],"estimated_setup_minutes":30,"required_services":["Telegram Bot API","Reddit API","Google Gemini API","Groq API","MongoDB"],"key_features":["AI-powered summarization","real-time monitoring","trending topic detection","Telegram notifications","multi-model AI integration"],"target_audience":["community managers","developers","ops engineers"]}


name: Automated web form data collection and storage to Google Sheets
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-09-14T10:18:48.583Z
updated_at: 2025-09-14T10:18:48.583Z
url: https://n8n.io/workflows/8574
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  Automated Web Form Data Collection and Storage to Google Sheets

  Overview

  This n8n workflow allows you to collect data from a web form and automatically store it in a Google Sheet. It includes data cleanup, date stamping, optional batching, and throttling for smooth handling of single or bulk submissions.

  What It Does

  Accepts data submitted from a frontend form via HTTP POST
  Cleans and structures the incoming JSON data
  Adds the current date automatically
  Appends structured data into a predefined Google Sheet
  Supports optional batch processing and a wait/delay mechanism to control data flow

  Features

  Webhook trigger for external form submissions  
  JavaScript-based data cleaning and formatting  
  Looping and delay nodes to manage bulk submissions  
  Direct integration with Google Sheets via OAuth2  
  Fully mapped columns to match sheet structure  
  Custom date field (submitted_date) auto-generated per entry  

  Who’s It For

  This workflow is perfect for:

  Developers or marketers collecting lead data via online forms  
  Small businesses tracking submissions from landing pages or contact forms  
  Event organizers managing RSVP or booking forms  
  Anyone needing to collect and store structured data in Google Sheets automatically

  Prerequisites

  Make sure the following are ready before use:

  An n8n instance (self-hosted or cloud)  
  A Google account with edit access to the target Google Sheet  
  Google Sheets OAuth2 API credentials** configured in n8n  
  A web form or app capable of sending POST requests with the following fields:
    business_name
    location
    whatsapp
    email
    name

  Google Sheet Format

  Ensure your Google Sheet contains the following exact column names (case-sensitive):

  | Business Name | Location   | WhatsApp Number | Email               | Name           | Date       |
  |---------------|------------|------------------|----------------------|----------------|------------|
  | SpaGreen      | Bangladesh | 8801322827753    | spagreen@gmail.com   | Abdul Mannan   | 2025-09-14 |
  | Dev Code Journey  | Bangladesh | 8801322827753   | admin@gmail.com   | Shakil Ahammed | 2025-09-14 |

  &gt; Note: The "Email" column includes a trailing space — this must match exactly in both the sheet and column mapping settings.

  Setup Instructions

  1. Configure Webhook

  Use the Webhook node with path:  
    /93a81ced-e52c-4d31-96d2-c91a20bd7453  
  Accepts POST requests from a frontend form or application  

  2. Clean Incoming Data

  The JavaScript (Code) node extracts the submitted fields  
  Adds a submitted_date in YYYY-MM-DD format  

  3. Loop Over Items (Optional for Batches)

  The Split In Batches node allows handling bulk form submissions  
  For single entries, the workflow still works without adjustment  

  4. Append to Google Sheet

  The Google Sheets node appends each submission as a new row  
  Mapped fields include:
    Business Name  
    Location  
    WhatsApp Number  
    Email  
    Name  
    Date (auto-filled)

  5. Add Delay (Optional)

  The Wait node adds a 5-second delay per loop  
  Helps throttle requests when handling large batches

  How to Use It

  Clone or import the workflow into your n8n instance  
  Update the Webhook URL in your frontend form’s POST action  
  Connect your Google Sheets account in the Google Sheets node  
  Confirm that your target sheet matches the required column structure  
  Start sending data from your form — new entries will appear in your sheet automatically  


  &gt; This setup ensures form submissions are received, cleaned, stored efficiently, and processed in a controlled manner.
  Notes

  Use the Sticky Notes in the workflow to understand each node’s purpose  
  You can modify the delay duration or disable looping for single submissions  
  For added security, consider securing your webhook with headers or tokens  

  Ideal Use Cases

  Contact forms  
  Lead capture pages  
  Event signups or bookings  
  Newsletter or email list opt-ins  
  Surveys or feedback forms  

  Support
  WhatsApp Support: Chat Now 
  Discord: Join SpaGreen Community 
  Facebook Group: SpaGreen Support 
  Website: spagreen 
  Developer Portfolio: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.splitInBatches","n8n-nodes-base.webhook","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.wait"]

workflow_json_compressed:
  H4sIAAAAAAAAE6WW224iRxCGX2U017TV54PvEie7cuTEUZA2iiJf9KEao4UZNNPYu7J499QMDsbO4MjiCkQXf3116Kp+qpepvqzn7cOXG/9Xnz7f/PrL7828ntVrKL6+fKqXTV98E+F6sIvBeQZKcGa0CVowrYU03ArJuDCgtAxcWeMDU8HI6Km3DgLlXglpZdKoW2C9WfkCVx2kfg5lu7lq8RcogA5Kt4XdrG78GtDbD9vSrtE0VX9CqD613br6yRdfXbWrFcSybJvKN6mal7bzC6hKW31u28UKqvk9QOkHZ37R15d/36Fkm2D4+rQPOGYOSYEg2WlPpE2c+Mw5EZqCoNSFKFJ9ALlp2011+wBddY34o/D3zXDQ2IaMyiT4Hi76zWpZrpsffYn3MJi1zc9d13aDw7Ypy2YLf8Biu/Ld7bZstgUtNm2/HCJBNMaZnglOkXbjO/RcoEPkpyEhbYH+uvm0ah/ry+xXPewRvqDF+Gexmz1HJihzTlNGQmCGSMiZeAVAKFVKAY2ceXiJDBN737ZfT0b0eDg/AlWMP3M+H4+94YS3LEIioHgkMglGnMa8Rsc8pyEZqUT939BehcEPYfCcZDZUkOCMJFIGSlwOigiWwDFqcqb0JYyhBWDfHMtmX/6TIS3GHjm0yHEBlOIzLqcK8IpSXugDp7GOSmUdyTZwIhVEElJWiJ2iNoYFFcUL59UKfFN10G/apocqIfBJzohfX/NZaU/0x4kkWgPOaqWJtgqTmDQngcdMdNDYGExYRfVxEpfx6/fqN+y10x0+2jybHKERo+0Mb499Czc2PjQFpeq3oOylaUFTyrgjOFUEkUFaYo0MxLEcODeYSp4nQdmHSQWVZ4By5jx1ORIDTBOpBSVYYUVYtlGKJJNzbhKUfxjUcHoGaBYmBaETodzigKM423yQkgS8hS7TiGmFSVDxYVDGzktplibzjLNKCCRVyuDlAUty9lbjuMLy+0lS+XFSyc8hZdTaILIkSmqccDRF4qQUhPmgmfHgsTUmSdXHSS095z4BLl3PNBC88oxIr/A+cRzISVnGo3bgAjtaAn55elw+7g+P2Zyamv/eeqlMUjgJbcI6skh8VAyzk5mJVgoV6P/Nf3bBdijrcbk/wGHT9VBwdy7G8OEbxO0ActslGBbrAxvy8LBXGEGSlxyywApxbHgcJo645DWxFF8sQXKX1FAmTGSzf0WMwmMS8HPtl0OQ+FAYkvDe8h8tZ/hASvCtvqS7uzsE+XehTim9O/0n1d76PlK9m70Iv7v+JoWnUM4PfopjSvV1w01I7Xb/AElB8YmZCgAA

metadata_json:
  {"categories":["Data Processing","Marketing"],"complexity":"simple","use_cases":["collect submission data automatically","store form inputs in spreadsheets","timestamp incoming requests","process over throttling limits"],"estimated_setup_minutes":10,"required_services":["Google Sheets","Webhooks"],"key_features":["HTTP POST to parallelize requests","automatic data transformation","date stamping","batching capabilities"],"target_audience":["developers","data practitioners","marketing"]}


name: WhatsApp number verify & confirmation system with Rapiwa API and Google Sheets
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-09-14T12:36:23.627Z
updated_at: 2025-09-14T12:36:23.627Z
url: https://n8n.io/workflows/8576
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  WhatsApp Number Verify & Confirmation System with Rapiwa API and Google Sheets
  Who is this for?
  This n8n workflow makes it easy to verify WhatsApp numbers submitted through a form. When someone fills out the form, the automation kicks in—capturing the data via a webhook, checking the WhatsApp number using the Rapiwa API, and sending a confirmation message if the number is valid. All submissions, whether verified or not, are logged into a Google Sheet with a clear status. 

  It’s a great solution for businesses, marketers, or developers who need a reliable way to verify leads, manage event signups, or onboard customers using WhatsApp.

  How it works?
  This n8n automation listens for form submissions via a webhook, validates the provided WhatsApp number using the Rapiwa API, sends a confirmation message if the number is verified, and then appends the submission data to a Google Sheet, marking each entry as verified or unverified.

  Features
  Webhook Trigger**: Captures form submissions via HTTP POST
  Data Cleaning**: Formats and sanitizes the WhatsApp number
  Rapiwa API Integration**: Checks if the number is registered on WhatsApp
  Conditional Messaging**: Sends confirmation messages only to verified WhatsApp users
  Google Sheets Integration**: Appends all submissions with a validity status
  Auto Timestamping**: Adds the submission date in YYYY-MM-DD format
  Throttling Support**: Built-in delay to avoid hitting API or sheet rate limits
  Separation of Verified/Unverified**: Distinct handling for both types of entries

  Nodes Used in the Workflow
  Webhook**
  Format Webhook Response Data** (Code)
  Loop Over Items** (Split In Batches)
  Cleane Number** (Code)
  check valid whatsapp number** (HTTP Request)
  If** (Conditional)
  Send Message Using Rapiwa**
  verified append row in sheet** (Google Sheets)
  unverified append row in sheet** (Google Sheets)
  Wait1**

  How to set up?
  Webhook

  Add a Webhook node to the canvas.
  Set HTTP Method to POST.
  Copy the Webhook URL path (/a9b6a936-e5f2-4xxxxxxxxxe0a970d5).
  In your frontend form or app, make a POST request to:
  The request body should include:
  {
    "business_name": "ABC Corp",
    "location": "New York",
    "whatsapp": "+1 234-567-8901",
    "email": "user@example.com",
    "name": "John Doe"
  }

  Format Webhook Response Data

  Add a Code node after the Webhook node.
  Use this JavaScript code:
  const result = $input.all().map(item =&gt; {
    const body = item.json.body || {};
    const submitted_date = new Date().toISOString().split('T')[0];

    return {
      business_name: body.business_name,
      location: body.location,
      whatsapp: body.whatsapp,
      email: body.email,
      name: body.name,
      submitted_date: submitted_date
    };
  });
  return result;

  Loop Over Items

  Insert a SplitInBatches node after the data formatting.
  Set the Batch Size to a reasonable number (e.g. 1 or 10).
  This is useful for processing multiple submissions at once, especially if your webhook receives arrays of entries.

  Note: If you expect only one submission at a time, it still helps future-proof your workflow.

  Cleane Number

  Add a Code node named Cleane Number.
  Paste the following JavaScript:
  const items = $input.all();
  const updatedItems = items.map((item) =&gt; {
    const waNo = item?.json["whatsapp"];
    const waNoStr = typeof waNo === 'string' ? waNo : (waNo !== undefined && waNo !== null ? String(waNo) : "");
    const cleanedNumber = waNoStr.replace(/\D/g, "");
    item.json["whatsapp"] = cleanedNumber;
    return item;
  });
  return updatedItems;

  Check WhatsApp Number using Rapiwa

  Add an HTTP Request node.
  Set:
     Method: POST
     URL: https://app.rapiwa.com/api/verify-whatsapp
  Add authentication:
     Type: HTTP Bearer
     Credentials: Select or create Rapiwa token
  In Body Parameters, add:
     number: ={{ $json.whatsapp }}
  This API call checks if the WhatsApp number exists and is valid.

  Expected Output:
  {
      "success": true,
      "data": {
          "number": "+88017XXXXXXXX",
          "exists": true,
          "jid": "88017XXXXXXXXXXXXX",
          "message": "✅ Number is on WhatsApp"
      }
  }

  Conditional If Check

  Add an If node after the Rapiwa validation.
  Configure the condition:
     Left Value: ={{ $json.data.exists }}
     Operation: true
  If true → valid number → go to messaging and append as "verified".
  If false → go to unverified sheet directly.

  Note: This step branches the flow based on the WhatsApp verification result.

  Send WhatsApp Message (Rapiwa)

  Add an HTTP Request node under the TRUE branch of the If node.
  Set:
     Method: POST
     URL: https://app.rapiwa.com/api/send-message
  Authentication:
     Type: HTTP Bearer
     Use same Rapiwa token
  Body Parameters:
     number: ={{ $json.data.phone }}
     message_type: text
     message: 
            Hi {{ $('Cleane Number').item.json.name }},
       Thanks! Your form has been submitted successfully.
       
  This sends a confirmation message via WhatsApp to the verified number.

  Google Sheets – Verified Data

  Add a Google Sheets node under the TRUE branch (after the message is sent).
  Set:
     Operation: Append
     Document ID: Choose your connected Google Sheet
     Sheet Name: Set to your active sheet (e.g., Sheet1)
  Column Mapping:
     Business Name: ={{ $('Cleane Number').item.json.business_name }}
     Location: ={{ $('Cleane Number').item.json.location }}
     WhatsApp Number: ={{ $('Cleane Number').item.json.whatsapp }}
     Email : ={{ $('Cleane Number').item.json.email }}
     Name: ={{ $('Cleane Number').item.json.name }}
     Date: ={{ $('Cleane Number').item.json.submitted_date }}
     validity: verified

  Use OAuth2 Google Sheets credentials for access.

  Note: Make sure the sheet has matching column headers.

  Google Sheets – Unverified Data

  Add a Google Sheets node under the FALSE branch of the If node.
  Use the same settings as the verified node, but set:
     validity: unverified

  This stores entries with unverified WhatsApp numbers in the same Google Sheet.

  Wait Node

  Add a Wait node after both Google Sheets nodes.
  Set Wait Time:
     Value: 2 seconds

  This delay prevents API throttling and adds buffer time before processing the next item in the batch.

  Google Sheet Column Reference
  A Google Sheet formatted like this ➤ Sample Sheet  

  | Business Name      | Location     | WhatsApp Number | Email      | Name    | validity   | Date  |
  |---------------------|--------------------|------------------|----------------------|------------------|------------|------------|
  | SpaGreen Creative   | Dhaka, Bangladesh  | 8801322827799| contact@spagreen.net | Abdul Mannan    | unverified | 2025-09-14 |
  | SpaGreen Creative   | Bagladesh          | 8801322827799| contact@spagreen.net| Abdul Mannan   | verified   | 2025-09-14 |

  &gt; Note: The Email  column includes a trailing space. Ensure your column headers match exactly to prevent data misalignment.

  How to customize the workflow
  Modify confirmation message with your brand tone
  Add input validation for missing or malformed fields
  Route unverified submissions to a separate spreadsheet or alert channel
  Add Slack or email notifications on new verified entries

  Notes & Warnings
  Ensure your Google Sheets credential has access to the target sheet
  Rapiwa requires an active subscription for API access
  Monitor Rapiwa API limits and adjust wait time as needed
  Keep your webhook URL protected to avoid misuse

  Support & Community
  WhatsApp Support: Chat Now  
  Discord: Join SpaGreen Community  
  Facebook Group: SpaGreen Support  
  Website: spagreen.net  
  Developer Portfolio: Codecanyon SpaGreen  

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.webhook","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.wait","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE62X224bNxCGX2Whi16JBs8H36UuWhhtkyBGmwJFLobk0FpY3lW0azuG4XfvrKxYirOKZas39moP/3wc/hwO7yZ1nhxPLt68O/v98+f3/8xPmrpry2Q6ucQeJsd3k7rpemgSng7vpRhAoFFSOOuiVcJapZ30SgupHBqrozTeQRQmOp2Agw8YuQSjtNfZkm6Pl4s59HiyxNydYX+1OGnpDvZIAfrlFd5PJw1cIkX7OIO+e7NYVG+vLiMuq79xWZfb6qfqpG1KvbyEvm6b6uy2I83qpu5n1QdY1DdQvXl/WkGTq9/a9nyO1dkMse+G2HDeTY7//UQR2ozD5d3D+G1KLkh0DKMGpjEg88EHphT9s9ybEv3kketkjtDgmmqQvV0MtxvfsJUui9DhUaJLerhou3rgpGDMSj0VWlP8BSxJq8clQdzdP0jQ8LrVi/J+uuYyjrucRGDBBsk0z5GuimYeJbcic+RRbrj+aNtF9e6aMnVKGel2knWLed2fNj9Dn2bYPWEMQU6F9M8xqkdG552SXBuWXSZGqzPzJhqGmtsAzhabzYbxI8ZZ217sZLt5fL4NJYz5SrV+YWVHCNFCUJahKRQ668RCKoEJLzNyCI6vQu+ZbG6KzlwoVoxJTCvILHBQDIPKUSiw2m8l+7TsHENdvsUXdq9ZP9pC0akU6xIzAjnTRlgWpKOBKaVDDBFyiRuUq+Z6WBk15goWCyTjL9ubqm6qbjD+Tszz1ep4XBxbwDrYKc3pc8T6yG6cyoPVzhCiTEQsUTFQHpgFJZwMKhZIG+L/mdeRO5iSL+HNCGC9lIzsaYk3aQYyZWa1DT45Z4XYyvBHqHux27P09AmQ9esEbtvVJu00Gk1VRpHBCoWL2hgWtFeSgnMhxXN2FUdi45Iki/XaMUM1mPQMsFBAMLSqUO21KJPYjOHXdqiY1XoBVh+wW7RNh9UvQIX+BUVMSHLHHhViy82FxucFJzeXTFWMbBGiFsz6JGTmACXkDefZYIg/sevgHKu/uro5X5f1nZCzvl98wM9X2D2ZBiP9fr7YsFpygQnDUuOBWFFxKimaDz8BsUht1VYROOvrdHFbvW173F1tV++sX9lOpLTGTpn2362zSWqbHpuetCbfzf8jaSxBpyCpXCmliBQM8ykL5qVWquSAQZatPWuG6aK6hnmdq5thX6WVVzUP++phSWZ6v/q2nWXqHSTtqeR/GQIJeMVitDQAkzxVCi45iNEs716EO9NMPYo+IM2Jo82RI0WRhWntkQEtWJYs0O1sFRcwiipfgcq9PwQVUizKeSpilFAtITHaf4FBllJQel1WbhRVvRzVqUO8K1BG8OTdDKCZdpYz7ySyIo016IX2eZxUvyKp+pDpd2BCUIYzTn0s7cTWspipIYOh58lUY70wo6TmxaSkeAAo7bNZCV5YocVFMtQGhWQKsyWXrHgBNHkU1L4KVOoXctLbkPr6muIUmHc4nXTY91R4Vp/iF0xXg/y7ZaaemjoEMWhcP3y/2j2jT1wXT/U4UjuknadSx0tiikwvRAhGp2EoBNFgGqRWwtSm0d9LqAdwaveH4e23yay+mdL5J+OXyTGnAWw+37fj+k7jEw3qaws8xrXfJj0q++2pZEz85XvAaKCnx4ytUNs52nFKGpXcPR1j4zgg9z/M71isnWeqUfkfko3JP2ksR0WfMdtrZfd2w1iA7dPPiPr9/X/5Im0DWRAAAA==

metadata_json:
  {"categories":["AI/ML","Communication","Data Processing"],"complexity":"medium","use_cases":["verify phone numbers","collect and log user data","send confirmation messages","automate form submissions"],"estimated_setup_minutes":15,"required_services":["Rapiwa API","Google Sheets","HTTP/Webhook service"],"key_features":["real-time phone number validation","automated confirmation messaging","detailed logging and status tracking","workflow automation based on number validity"],"target_audience":["business owners","customer support teams","developers"]}


name: Extract Purchase Orders from Gmail using Gemini AI and Save to Google Sheets
author_name: SayOne Technologies
author_username: sayonetech
categories: []
created_at: 2025-09-15T05:54:18.889Z
updated_at: 2025-09-15T05:54:18.889Z
url: https://n8n.io/workflows/8585
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  🚀 AI-Powered Email to Purchase Order Workflow  

  Automatically scan your inbox for new purchase order requests, extract order details using Gemini AI, and log them into Google Sheets — all without manual effort.  

  ✨ Core Capabilities  
  ⏱ Runs every minute to check unread emails  
  📧 Filters emails by subject  
  🤖 Uses Gemini AI to summarize email content & extract structured order details  
  📅 Formats dates into ISO calendar weeks  
  📊 Adds product data from Google Sheets to complete order info  
  ✅ Appends final purchase order records into a Google Sheet (without replacing previous ones)  

  🛠 Setup Essentials  
  📩 Gmail account for fetching unread emails  
  🔑 Google Gemini (PaLM) API credentials  
  📒 Google Sheet with predefined purchase order headers  

  📖 Activation Guide  
  ⚙️ Configure Gmail & Google Sheets credentials in n8n  
  🎯 Adjust the subject filter to match your email rules  
  🔌 Connect Gemini AI with your API credentials  
  📑 Create a Google Sheet with the required headers  
  ▶️ Activate the workflow and let it run in the background  

  🎨 Customizing the Workflow  
  🔍 Email Filters → Change keywords in the filter node to match your purchase order email subjects  
  🏷 Order Fields → Modify Set and Append to Google Sheet nodes if your schema differs  
  ✍️ AI Instructions → Adjust the AI Agent’s prompt to fit your company’s email style or product details  
  ⏲ Frequency → Update the Cron node if you want to scan emails less often  
  📂 Target Google Sheet → Point to a different sheet or tab depending on your department or customer  

nodes_used:
  ["n8n-nodes-base.gmail","n8n-nodes-base.cron","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  [encoded data, 5296 characters]

metadata_json:
  {"categories":["AI/ML","Productivity"],"complexity":"medium","use_cases":["automate purchase order processing","extract data from emails","convert unstructured text to structured tables"],"estimated_setup_minutes":30,"required_services":["Google Gmail","Google Gemini AI","Google Sheets"],"key_features":["email monitoring","AI-powered data extraction","structured data formatting","automatic date standardization"],"target_audience":["procurement managers","data analysts","office managers"]}


name: Automate Job Search with AI Cover Letters using Google Jobs, RemoteOK & GPT-3.5
author_name: Shelly-Ann Davy
author_username: SheCodesFlow
categories: []
created_at: 2025-09-15T08:27:48.723Z
updated_at: 2025-09-15T08:27:48.723Z
url: https://n8n.io/workflows/8589
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Automated Job Search with AI-Generated Cover Letters

  🎯 What This Template Does

  This workflow transforms your job search from a time-consuming daily chore into a fully automated system. Every 24 hours, it searches Google Jobs and RemoteOK for positions matching your criteria, generates unique AI-powered cover letters for each role, and delivers a polished HTML email digest straight to your inbox.

  ⚡ Key Features

  Multi-Platform Search**: Simultaneously queries Google Jobs (via SerpAPI) and RemoteOK
  Smart Filtering**: Automatically removes duplicates and low-quality postings
  AI-Powered Cover Letters**: Uses OpenAI GPT-3.5 to write personalized 60-word cover letters for each position
  Beautiful Email Digests**: HTML-formatted emails with job details, descriptions, and apply buttons
  Zero Manual Work**: Runs automatically every 24 hours
  Cost-Effective**: $0 for first 3 months using free API tiers, then $3/month

  ⏱️ Time Saved

  | Method | Time Required |
  |--------|---------------|
  | Manual Job Search | 2-3 hours daily |
  | With This Workflow | 0 minutes (fully automated) |
  | Annual Time Savings | ~800 hours per year |

  📋 Prerequisites

  1. SerpAPI Account
  Cost**: FREE tier (100 searches/month)
  Sign up**: https://serpapi.com/
  What you need**: API key from dashboard

  2. OpenAI Account
  Cost**: FREE ($5 trial credits)
  Sign up**: https://platform.openai.com/
  What you need**: API key (requires phone verification)

  3. Email Service
  Cost**: FREE (use existing email)
  Options**: Gmail, Outlook, or any SMTP provider
  Gmail users**: Use App Password (requires 2FA enabled)

  🚀 Quick Start Guide

  Step 1: Get API Keys (10 minutes)

  SerpAPI Setup
  Go to https://serpapi.com/ and sign up
  Verify your email
  Log in → Dashboard
  Copy your API key

  OpenAI Setup
  Go to https://platform.openai.com/
  Create account and verify phone number
  Profile icon → View API keys
  Create new secret key
  Copy immediately (shown only once)

  Gmail Setup (if using Gmail)
  Google Account → Security
  Enable 2-Step Verification
  Search for "App Passwords"
  Generate app password for Mail
  Copy the 16-character password

  Step 2: Add Credentials to n8n (5 minutes)

  Add SerpAPI
  n8n Credentials → Add Credential
  Select "HTTP Query Auth"
  Name: api_key
  Value: [paste your SerpAPI key]
  Save

  Add OpenAI
  Add Credential → OpenAI
  Paste your API key
  Save

  Add SMTP
  Add Credential → SMTP
  Configure:
     Host: smtp.gmail.com
     Port: 587
     Security: STARTTLS
     Username: your-email@gmail.com
     Password: [app password]
  Save

  Step 3: Configure Your Search (2 minutes)

  Click the "Settings" node and update:

  query - Your target job title
  ✅ Good: senior react developer
  ✅ Good: product manager saas
  ✅ Good: data scientist machine learning
  ❌ Bad: developer (too broad)

  location - Where you want to work
  For remote: Remote
  For city: San Francisco, CA
  For city: New York, NY
  For state: Texas
  💡 Tip: Start with Remote for most options

  email - Your email address
  Use the SAME email from SMTP setup
  Example: yourname@gmail.com

  Step 4: Connect Credentials

  Click "Search Google Jobs" node → Select SerpAPI credential
  Click "Generate Letter" node → Select OpenAI credential
  Click "Send Email" node → Select SMTP credential
  Click "No Results Email" node → Select SMTP credential

  Step 5: Test & Activate

  Click "Execute Workflow" button (top right)
  Watch nodes light up green ✅
  Wait 30-60 seconds
  Check your email inbox
  If successful → Toggle "Active" switch
  Done! You'll receive daily job digests

  📧 What You'll Receive

  Each day, you'll get an email containing:

  Up to 4 highly relevant job listings**
  Company name and location for each
  Job description snippets
  AI-generated personalized cover letter** for each position
  Direct "Apply Now" button
  Source attribution (Google Jobs vs RemoteOK)

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.emailSend","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.aggregate","n8n-nodes-base.code","n8n-nodes-base.emailSend"]

workflow_json_compressed:
  H4sIAAAAAAAAE6WWTVPbMBCG/4pHZycTJ4FCbpShDP2ATtPpheEgnMVRcaRUkgMMk//elQNFsldg00vGjtfvs7vaDz8yyVfAZuyosmpggOt8mfxW1ya5E3aZHJ0ludqATkqwFrRhKbO8MGx2yZwR3nLhfvDlFbdCSbzJuQbQ7CplUi3A2T4+Q+ZW5LcPybmykAySCxTeCLhzog9r91weyEH90uCaGxia2txZo8laGVETZpfj6SjNRiMkrLlG5dqz2SPLlbQgLQqx7U7zFz6p38m2acSLOdhq3duF/YP/cyFfwqIqIc59MvipRVFgNsP490fptA1vAYdjH4knKGRh4kiwIWbaDTMZTgJMXUKnShUlJJ93RUIDl9auf8CfCoxtJ3cyfRM8bcRXg3/ACg/r4sv7qBhyP+o30EX8FFdPTz3K4ahTUsdDv1y+a5WDMa+nM8fLkJVlHWEe6ngJ+S1m0VSljbPETYM06U86V8+Y5GTFRRmFgXs6B7loMPeQOembyvm6FPb1RBpnciY/cotNaAjoXoem8JAn91bzvIb2ObwP3Uh+Sk9BguY41r7W47p/D2SH3aBhExyr1bWQb1LbMY6z/jEeFYWGgtt413HPwodNusH8avmkNO61N+qTiKtjlYTzSy7e1wjjrpWCjYA2WIpig+o3vDSQMvO8F3B7wT3klVO90As8yBnbZG6N4VKTkLv/a6vdzMMLdMfx3X53KYjNqdosZUIu4J7NRturK9T8twEpnfauojU81wmN+CJqqqXNt9pbhHTgpRYpD+jioSN5mUqUEjlBSCHfklKKTghSLYiATnK7aEmloDIopcjeIcVCW0otvltagqkXDbEbaAfCgUd5QIwpUqp5IGRuIvM10hRhBVOCja+WUCcLdPz+6S1Vu+TG0O4r9lhV7tM42/4FdcLiaXYMAAA=

metadata_json:
  {"categories":["Career","AI/ML"],"complexity":"medium","use_cases":["Automate job search","Generate cover letters","Deliver email digests"],"estimated_setup_minutes":30,"required_services":["Google Jobs via SerpAPI","RemoteOK","GPT-3.5"],"key_features":["Multi-platform job search","AI-generated content","Scheduled automation"],"target_audience":["job seekers","career changers","developers"]}


name: AI Personal Assistant for Google Tasks
author_name: minh
author_username: minh
categories: []
created_at: 2025-09-15T08:46:04.948Z
updated_at: 2025-09-15T08:46:04.948Z
url: https://n8n.io/workflows/8591
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:20
description:
  Who’s it for
  This template is designed for anyone who wants to use Telegram as a personal AI assistant hub.
  If you often juggle tasks, emails, calendars, and expenses across multiple tools, this workflow consolidates everything into one seamless AI-powered agent.

  What it does
  Jarvis listens to your Telegram messages (text or audio) and processes them with OpenAI.
  Based on your request, it can:

nodes_used:
  ["n8n-nodes-base.stickyNote","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","n8n-nodes-base.merge","n8n-nodes-base.googleSheets","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegramTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.googleDrive","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 13960 characters]

metadata_json:
  {"categories":["AI/ML","Communication","Data Processing"],"complexity":"medium","use_cases":["AI-powered task management via Telegram","WhatsApp-to-email routing integrated into conversations","voice-to-text task capture from Telegram","cross-platform calendar and expense synchronization","AI-driven response generation to natural language queries"],"estimated_setup_minutes":60,"required_services":["Telegram Bot API","OpenAI","Bark SMS","Google Calendar","Google Tasks","Google Sheets","Slack Webhooks"],"key_features":["Natural language processing to interpret user requests","automated task creation and assignment","ai-driven conversation context management","multi-platform synchronization","structured spreadsheet data handling"],"target_audience":["individual productivity users","team admins","workflow automation enthusiasts"]}


name: Fireflies Transcripts to Meeting Summaries & Task Extractor to Slack & ClickUp
author_name: Hashir Bin Waseem
author_username: hashirxn8n
categories: []
created_at: 2025-09-15T10:20:02.945Z
updated_at: 2025-09-15T10:20:02.945Z
url: https://n8n.io/workflows/8592
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  AI-powered Meeting Summaries and Action Items to Slack and ClickUp

  How it Works  
  Webhook Trigger: The workflow starts when Fireflies notifies that a transcription has finished.  
  Transcript Retrieval: The transcript is pulled from Fireflies based on the meeting ID.  
  Pre-processing: The transcript is split into sentences and then aggregated into a raw text block.  
  AI Summarization: The aggregated transcript is sent to Google Gemini, which generates a short summary and a structured list of action items.  
  Post-processing: The AI response is cleaned and formatted into JSON. Action items are mapped to titles and descriptions.  
  Distribution:  
     The meeting summary is posted to Slack.  
     Action items are created as tasks in ClickUp.  

  Use Case  
  This workflow is designed for teams that want to reduce the manual effort of writing meeting notes and extracting action items.  

  Automatically generate a clear and concise meeting summary  
  Share the summary instantly with your team on Slack  
  Ensure action items are not lost by automatically creating tasks in ClickUp  
  Ideal for distributed teams, project managers, and product teams managing recurring meetings  

  Requirements  
  n8n instance** set up and running  
  Fireflies.ai account** with API access to meeting transcripts  
  Google Gemini API (via PaLM credentials)** for AI-powered summarization  
  Slack account** with OAuth2 credentials connected in n8n  
  ClickUp account** with OAuth2 credentials connected in n8n

nodes_used:
  ["@firefliesai/n8n-nodes-fireflies.fireflies","n8n-nodes-base.splitOut","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.clickUp","n8n-nodes-base.slack","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.code"]

workflow_json_compressed:
  H4sIAAAAAAAAE5VYbY/buBH+K6zugPOiplcvlES52KKLoMmluGTT7OZaNBsklDiylZUlQ5R3190Y6Nd+7of+v/slHVKyLduyu0GArEyNhuTzzDwz5JOVSWtsZb/e/ENdLpPJ1+VVfv/3S2tozaAW1vjJygpViyKB19ouCCPhQxBFQRLGPAw9D0QkRRAGQRQw13ecFNzUcR1fugEXnLPIiUScxtLx0lTG6LeG2TwXNbyoQKprqBfzFyWOQA04QV0tYDW0CjEDnM2rJJkB1FkxIWoxm4lqOSS1UHdK+xETZY0/fkLrUoJ+fGr2kkJqB34KVMZcUCbsmArGUurYQrjc5X7kMmszxyuoiSB1JQqVVNm81p6Xc/3mT2lWQZpnoER2XvCCmnnoZnS0ecJv5qXK6qwscBlOYA9tXNZcVDhFDZXSMG5nMEBePD2RH7+qshjFpVyO2l2+lmS1shCABMGBos5Ebj7ezHQ5zwwn2sXWhuLvzYa6tuTFxsZarZqd/YoLMgt1VsPWUxRH3A9cm4bcCSnzQo9yCH3KghgHPBEBd7cTXM/zrCZXiw5UW3RioWCktEVj0MHF46wHl3KuX+tHXF+aQS5vyuv192NLilqMFG4BMASVdXwPNti+4zG9hwAoY35A49hzaeILO4ztwMFf2z1cTiYVTDAKj+5BdCw6m/DD4FmbUDfldg7DoNlZZ+xj36BViYfPNTzW1urTCcKYBN8G8GgimKRMxh6Nk1TSgPEkZoz7oc07IV6WkxzIK5hlBYbEVNTkDW4074Q6br4T4rkoJslUZMUon2nzxkHz/S4cnPGhEwanAZnpyd42azHP6nxifFF3ZNM0F2pK62lW3GEGUHicU9SPqCcLJmYZ70Q+e0Ya7Bg/Mw/CxE+FkyY0ZjbGEHd0DIFDuRvLEHMgcj17OwP6RM60eKAiHY2jJM+Suw/zfYng9pA6jnsAXJ4pHfaR7XDH5szx/U7mbUWjzmpkFLVC66mYrb/wecAjHwfVXCTQjgaOi9mgJS8tcwlVDko1Sju0xKKealwS0azMKi9xRE8ppDSrFflLE896cUmp87DeWQlu1KgamhrtOqStReDKeH4Gc/v2zyTPD0Lbdj1BQasAi8OYxlhyqO37LHaCNPC75F1DIZG6GWIhJsdVQOUiuevhLmDI3APE07K8M3oehoyFkHAa2FFMGfiSxn6UUB/xDxw7DVJXZ+ReTdCJ3gWzLXINsQpySPR7TMWiMOnaPukZn6zPn6t8zaNOK7Q00TO07kW+MBFqR9Ff30e2e/NBfyySKcj3oBZ53WajyHOalBWwkOqNC6UmOu9KDIrqqpvCx+LkkG2D2LO53rU+ybQ78jZcu+AKz3YEppApU0bsXU5BxG4EsQ9RGm0neWkq4pL8reHrKNkPm/cdulEGjOB3ycYeKHG5w6ijNZgFPKWRjALKbeyAUinigMkDsueinnbLs0G8BR9DsNDE7cjmtK7nb6CelnrKd1fXNwfVzx1tw59Hge/Gvo9dT4hdT+o7VHhCUt/zWBAEiYelvBP+baC9ggIqUZfVM2rBepFd+ffcvlanDet3OSCsZNLMoZVyHd9lSlDw1aa52zZHJCuITwOSZwXge/GYzRazEVoD/sB380WF8wPBj2usTMONSzUtF7kkMRDdLZC6JFoYtTuV6faSCEx4XM+SPJSVVOQhq6dGAGS2mJEcign+1isfkqKsyT2gz7wsJp2fOEVVj26L2+IyVyXZ6L/OOr0lkRgVzLDDVSStylmz7HaPev5yUc8XuMeaaB4k6YjniBink+weyKJAmSaObRNEvkK3+KtRfJwFMI27UxkcSIYbynOyQGiEMt6JWenPULVgbVdys0F7rE026rPuPVB+9Ph77M2rgizLRYWLVw+4CHT9l+urtw14d7BU+zE7x13P65smkiSkyGJP1LrbRkYI1EvATHI9jrKJys0TxmnEYo4nCC/hzO9ELQrQ3ZK8LU/0bcrYtCbdPMZqO6SuzQ/C9SGTOjOZE2DOQTaZYvBiDzXslLsffliLB/l9Bz6CEFUZoNxqvFqLMRpkkwmi9YCSSV6u850gGJma4oPoiXsTAe8hAeR/kxevpeFw/4gyJi+hTrQnzWq6QN47CWQCbzvrQpmJ0BC5uc8kyI73E/10zBLOkxQLWsRdytw4plGIrVESuwLPdXHopbyXGee7qfG84DQztn2KmQ4f76oSTwl6xxq3zUFlTMyj2tUZlIiskBlishA52ZwxyGD3zHHWZPy6Rx8jS19LPBR3vjC+ygJInJfJnU5STCUjJiQtq1aisn+a2nkK88CRUtqOT0OfMYrNn0ujyA0oi9IET9siFl7Qi7n73ZiHAR9Sz2bPwhzr6x7ml6/3sd4vKIg5tlg7kBtAtDBjMP7yy5tGRfT1QrUwcqb0y3W1MNL023//TS43Ej/wf/vXf9rSMFzLulZzXEPDUmPfq8cDo5ut6hslbyVV63JHhxtHx45MY/KixA4MFVlqMVzvpE2tSm9gXmql1G8QpEtdM09R7jixHXphSuMAUACDyMNWInWxnREux6YCOLBeyr3vptxxkdNnc44RuMf5u1LVdL5hXW/vytQzDdgLrPVIII5VoObIJSbK4RgZ4MQKmioyxOFZqeUuwcWTtJNtf36sddlTOxSOyWZ4vwYOCRRqUelVYcLNkK0nQ+6wy+zKJKO5PjqZhFJyF0BQbOaQEZ2OUcw8ih18wGNIY4j6hY99PyOBp2sSP6p8nu92GHH3la+BX2H26TaaDHYPNWdjQ9lu7V/nksQCkdTYFLf5aJql9ngxagg1pzAy2Dnmos/mt2qA1P3V2lKje9CcrNMZO7MlRsIp4BkEThrZNoZojBUnAUkjwR0aRh4kceTaEELn9H0QXMeP4PpwtJcKbVe/i/pX9aI5R1VN6/PxtiDkSf9HiO6QxiZuRyaGB80wIT9mBZKgLwNVPTgbmU6q6fNGFcyRGBicf/nyRY9/w7/n2FH+9NNZ87X5g83Wpz/cFod90vZuK3SkcCRQx0uwLriOpCJhMeUO920820vf63RJvcnzPeAwduRyYoMPRqGqW2G96EWgmftzY/LtG/mot3hbZCkZ/O6yqsRylCnzd2BMzrSNeRq1rfjFxQWxzxr013RoH6Y1PT/XOoxNed1E3JPe+l6ym6LcJwO3ReuvmW8m5gORkYs/koGZrCG6Zd18PiYiG5mWGhd5a30ozKi8tYaNUce5Me1eiZgv8F/D8+rsrJ9phFojdg/rA72CWuergR0eIVlob1cV1hiE/97RLu6bz82JNAkTyfD8R8GHFI+sKZ4po9ShQeA6wnaxgCehZdRDF6+2X7d2bij18QrZ//hk7tNPnxGN7dDC9gkerbG9+vQJ17O9F+7z1nPj2utl91at48m83T/K9810/Ea/d8ID814sDu+8+zE4wKzP2ynt6gfl8IPeVR651Nr3Odx88X+0oncx/d/07rP/hrSfhmOX1OhYZJ/1NcQCN9WOPS9MD77bnXS1+h+pocRL/hoAAA==

metadata_json:
  {"categories":["AI/ML","Communication","Productivity"],"complexity":"medium","use_cases":["automate meeting summaries","extract action items","sync tasks to project management"],"estimated_setup_minutes":25,"required_services":["Fireflies","Google Gemini","Slack","ClickUp"],"key_features":["transcript processing","AI summarization","structured task extraction","multi-platform integration"],"target_audience":["team leads","product managers","knowledge workers"]}


name: Smart stock trading recommendations with GPT-4, TwelveData & NewsAPI analysis
author_name: Jitesh Dugar
author_username: jiteshdugar
categories: []
created_at: 2025-09-15T10:32:18.789Z
updated_at: 2025-09-15T10:32:18.789Z
url: https://n8n.io/workflows/8594
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:19
description:
  Smart Stock Trading Recommendations with GPT-4, TwelveData & NewsAPI

  What It Does
  This template automates stock analysis by combining technical analysis, news sentiment, and real-time market data to generate actionable trading recommendations with confidence scores, risk management parameters, and entry/exit levels.

  Why It's Useful
  Data-Driven Decisions:** Eliminates emotional trading by synthesizing multiple data sources
  Time-Saving:** Analyzes a stock in seconds instead of hours of manual research
  Risk Management:** Automatically calculates stop losses and risk/reward ratios
  Real-Time Context:** Combines historical trends with breaking news and latest sentiment

  How It Works

  Technical Analysis (TwelveData)
     Fetches 4-hour, 1-day, and 1-week price trends
     Calculates moving averages and identifies support/resistance levels

  News Sentiment (NewsAPI + GPT-4)
     Pulls recent news articles about the stock
     Uses AI to score sentiment impact on price (-1.0 to +1.0)
     Distinguishes between "bad news" and "sell pressure"

  Live Market Intelligence (Perplexity API)
     Checks for real-time catalysts (earnings, Fed announcements, rumors)
     Catches breaking news that historical data might miss

  Visual Confirmation (Chart-Img API)
     Generates 1-week chart visualization for quick pattern recognition

  AI Decision Engine (GPT-4)
     Synthesizes all signals using quantitative decision rules
     Outputs: BUY/SELL/HOLD verdict with confidence level, entry zone, stop loss, and profit target

  Trade Setup Output
  Each recommendation includes:
  Verdict:** BUY, SELL, or HOLD (with confidence score)
  Entry Zone:** Optimal price to enter
  Stop Loss:** Risk protection level
  Target:** Profit objective
  Risk/Reward Ratio:** Trade viability metric

  Required API Keys
  TwelveData (stock prices)
  NewsAPI (news articles)
  OpenAI (GPT-4 analysis)
  Perplexity (live sentiment)
  Chart-Img (optional - for chart visualization)

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.aggregate","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.perplexityTool","n8n-nodes-base.switch","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.chat","@n8n/n8n-nodes-langchain.chat","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.merge","n8n-nodes-base.aggregate","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7272 characters]

metadata_json:
  {"categories":["AI/ML","Finance","Data Processing"],"complexity":"medium","use_cases":["auto-generating stock analysis","synthesizing financial data sources","producing trading recommendations","monitoring market sentiment","calculating risk parameters"],"estimated_setup_minutes":30,"required_services":["OpenAI","TwelveData","NewsAPI"],"key_features":["LLM sentiment analysis","multi-source data aggregation","confidence score generation","risk parameter calculation","technical indicator integration"],"target_audience":["traders","financial analysts","quantitative researchers"]}


name: Build Your First AI Agent with ChatGPT-5
author_name: Dr. Firas
author_username: drfiras
categories: []
created_at: 2025-09-15T12:21:07.592Z
updated_at: 2025-09-15T12:21:07.592Z
url: https://n8n.io/workflows/8597
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:21
description:
  Build Your First AI Agent with ChatGPT-5 

  Who is this for?  
  This workflow is designed for beginners and professionals who want to build their first AI-powered assistant with n8n. It’s perfect for anyone managing online trainings, consultations, or services that require both a knowledge base and appointment scheduling.  

  What problem is this workflow solving?  
  Manually handling client questions, checking your availability, and confirming bookings can be time-consuming and error-prone. This workflow automates the process, ensuring quick, accurate answers and seamless scheduling directly through chat.  

  What this workflow does  
  Answers user questions using your knowledge base stored in Google Sheets.  
  Checks availability in Google Calendar and proposes alternative time slots if needed.  
  Books 1-hour appointments in Paris time only after client confirmation.  
  Sends a professional confirmation email with all appointment details.  

  Setup  
  Import this workflow into your n8n instance.  
  Connect your Google Sheets, Gmail, and Google Calendar credentials.  
  Add your knowledge base into Google Sheets (questions, answers, policies, packs, etc.).  
  Test the workflow using the Connected Chat Trigger node to start conversations with the AI Agent.  

  How to customize this workflow to your needs  
  Update the Google Sheets database with your own training packs, services, or company FAQs.  
  Adjust the email template to reflect your branding and communication style.  
  Modify the appointment duration if you need sessions longer or shorter than 1 hour.  
  Add extra nodes (e.g., CRM integration) to capture leads or sync appointments with external systems.  
  📄 Documentation: Notion Guide

  Need help customizing?
  Contact me for consulting and support : Linkedin / Youtube

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.gmailTool","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.memoryBufferWindow"]

workflow_json_compressed:
  [encoded data, 6644 characters]

metadata_json:
  {"categories":["AI/ML","Communication"],"complexity":"medium","use_cases":["Automating client inquiries","Scheduling appointments","Answering questions","Booking consultations","Building AI assistants"],"estimated_setup_minutes":45,"required_services":["OpenAI/ChatGPT","Google Calendar","Google Calendar API"],"key_features":["AI-powered responses","Automatic appointment scheduling","Styled responses","Memory context","Tool-based reasoning"],"target_audience":["beginners","business owners","consultants"]}


name: Analyze Cryptocurrency Market Data with HTX API, GPT-4o and Telegram
author_name: Don Jayamaha Jr
author_username: don-the-gem-dealer
categories: []
created_at: 2025-09-15T18:15:24.272Z
updated_at: 2025-09-15T18:15:24.272Z
url: https://n8n.io/workflows/8604
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:20
description:
  A fully autonomous, HTX Spot Market AI Agent (Huobi AI Agent) built using GPT-4o and Telegram. This workflow is the primary interface, orchestrating all internal reasoning, trading logic, and output formatting.

  ⚙️ Core Features

  🧠 LLM-Powered Intelligence: Built on GPT-4o with advanced reasoning
  ⏱️ Multi-Timeframe Support: 15m, 1h, 4h, and 1d indicator logic
  🧩 Self-Contained Multi-Agent Workflow: No external subflows required
  🧮 Real-Time HTX Market Data: Live spot price, volume, 24h stats, and order book
  📲 Telegram Bot Integration: Interact via chat or schedule
  🔄 Autonomous Runs: Support for webhook, schedule, or Telegram triggers

  📥 Input Examples

  | User Input      | Agent Action                                  |
  | --------------- | --------------------------------------------- |
  | btc           | Returns 15m + 1h analysis for BTC             |
  | eth 4h        | Returns 4-hour swing data for ETH             |
  | bnbusdt today | Full day snapshot with technicals + 24h stats |

  🖥️ Telegram Output Sample

  📊 BTC/USDT Market Summary

  💰 Price: $62,400  
  📉 24h Stats: High $63,020 | Low $60,780 | Volume: 89,000 BTC

  📈 1h Indicators:
  • RSI: 68.1 → Overbought  
  • MACD: Bearish crossover  
  • BB: Tight squeeze forming  
  • ADX: 26.5 → Strengthening trend

  📉 Support: $60,200  
  📈 Resistance: $63,800

  🛠️ Setup Instructions

  Create your Telegram Bot using @BotFather
  Add Bot Token in n8n Telegram credentials
  Add your GPT-4o or OpenAI-compatible key under HTTP credentials in n8n
  (Optional) Add your HTX API credentials if expanding to authenticated endpoints
  Deploy this main workflow using:

     ✅ Webhook (HTTP Request Trigger)
     ✅ Telegram messages
     ✅ Cron / Scheduled automation

  🎥 Live Demo

  🧠 Internal Architecture

  | Component          | Role                                                     |
  | ------------------ | -------------------------------------------------------- |
  | 🔄 Telegram Trigger | Entry point for external or manual signal                |
  | 🧠 GPT-4o          | Symbol + timeframe extraction + strategy generation      |
  | 📊 Data Collector  | Internal tools fetch price, indicators, order book, etc. |
  | 🧮 Reasoning Layer | Merges everything into a trading signal summary          |
  | 💬 Telegram Output | Sends formatted HTML report via Telegram                 |

  📌 Use Case Examples

  | Scenario                               | Outcome                                                 |
  | -------------------------------------- | ------------------------------------------------------- |
  | Auto-run every 4 hours                 | Sends new HTX signal summary to Telegram                |
  | Human requests “eth 1h”                | Bot replies with real-time 1h chart-based summary       |
  | System-wide trigger from another agent | Invokes webhook and returns response to parent workflow |

  🧾 Licensing & Attribution

  © 2025 Treasurium Capital Limited Company
  Architecture, prompts, and trade report structure are IP-protected.

  No unauthorized rebranding permitted.

  🔗 For support: Don Jayamaha – LinkedIn

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.telegramTrigger","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 11084 characters]

metadata_json:
  {"categories":["AI/ML","Financial Services"],"complexity":"medium","use_cases":["Monitor crypto market data","Generate trading analysis","Set up autonomous trading agents"],"estimated_setup_minutes":45,"required_services":["HTX API","OpenAI GPT-4o","Telegram Bot API"],"key_features":["LLM-powered reasoning","Multi-timeframe indicator analysis","Autonomous agent workflow","Real-time market data integration","Self-contained tooling without external subflows"],"target_audience":["cryptocurrency traders","AI developers","quants"]}


