# templates

name: Automated POV video creation with AI scripts, visual generation & YouTube
author_name: PrideVel
author_username: n8nwizard
categories: []
created_at: 2025-12-08T05:15:27.565Z
updated_at: 2025-12-08T05:15:27.565Z
url: https://n8n.io/workflows/11589
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  POV Faceless Video Generator

  Create viral POV-style faceless videos automatically — from topic → visuals → sounds → rendered video → upload.
  This workflow is built for creators, YouTubers, automation agencies, and content studios that want to scale short-form content production without showing their face.

  🧾 Overview

  This n8n automation takes a video topic as input and generates:

  Titles
  Scripts
  Visuals
  AI video clips
  Background audio
  Final rendered POV-style faceless video

  A Publishing Agent module can even upload the final output directly to YouTube.
  Everything — prompts, images, videos, audio, transitions, and uploads — is generated end-to-end with zero manual editing.

  ⚙️ Key Features

  🎯 Topic-based generation → Just input your niche or daily idea
  ✍️ LLM-generated scripts & prompts using high-quality OpenAI models
  🖼️ AI visual generation (image & video clips)
  🔊 Text-to-speech narration with MP3 export
  🎬 Automated video renderer (assemble clips, audio & overlays)
  📤 Auto-upload to YouTube via Publishing Agent
  🧱 Modular design — easily replace or upgrade image/video/sound models

  🧱 Workflow Breakdown

  1️⃣ INPUT: Video Topic

  Nodes:

  Schedule Trigger / Google Sheets → pull new topics automatically
  Generate Titles → produces 5–10 title variations
  OpenAI Model → Title Parser → formats selected title

  This section generates the creative foundation for the entire video.

  2️⃣ Generate Prompts (Script & Shot List)

  Produces:

  A cinematic POV-style script
  Camera directions
  Image prompts
  Video prompts

  All outputs are optimized for AI image/video generators.
  Uses: OpenAI / OpenRouter LLM

  3️⃣ Generate Images (AI Art Module)

  Nodes:

  Text-to-Image
  Wait
  Get Image

  Generates multiple POV-style still images (hands, walking scenes, object interactions). Good for:

  Intro shots
  Cutaways
  Thumbnails

  4️⃣ Generate Videos (AI Video Clips)

  Nodes:

  Image-to-Video / Prompt-to-Video
  Wait
  Get Video

  Creates 3–6 second POV clips for each step in the script. Examples:

  Walking through a hallway
  Opening a door
  Typing
  Grabbing an object

  All clips flow into the rendering module.

  5️⃣ Generate Sounds (Narration + Background Audio)

  Nodes:

  Text-to-Speech
  Upload MP3
  Update Access

  This module handles:

  Full voiceover narration
  Ambient background audio / SFX
  Preparing audio files for final video rendering

  6️⃣ OUTPUT: Final Video Assembly

  Nodes:

  Merge
  List Elements
  Render Video
  Final Video Link

  This stage assembles:

  AI-generated clips
  Narration audio
  Background ambiance
  Text overlays
  Intro/outro elements

  Outputs a polished MP4 file ready for publishing.

  7️⃣ Publishing Agent (YouTube Auto-Upload)

  Nodes:

  Schedule Trigger → Get Video Link
  Get Video File
  YouTube Upload

  This module:

  Pulls the latest generated videos
  Uploads automatically to your YouTube channel
  Supports title, description, tags, visibility, thumbnails
  Perfect for scheduled daily posting

  🧰 Setup Instructions

  Connect OpenAI / OpenRouter

  One credential for script/prompt generation
  Another optional credential for image/video models

  Choose your AI image/video providers

  Compatible with:

  DALL·E
  Midjourney API
  Stability
  RunwayML
  Pika
  Luma Dream Machine
  Flux models

  Connect Google Sheets (optional)

  For:

  Topic management
  Content tracking

  Enable YouTube OAuth

  Required for auto-upload.

  Customize styles:

  POV type
  Video duration
  Voice style
  Background music
  Prompt templates

  Run a test to confirm all connections and render timing.

  🧩 Customization Options

  | Goal                         | How to Modify                                          |
  | ---------------------------- | ------------------------------------------------------ |
  | Change POV style             | Edit prompt templates in “Generate Prompts”            |
  | Use different video model    | Replace video nodes (Pika, RunwayML, Luma, Flux, etc.) |
  | Add subtitles                | Use Whisper/OCR + FFmpeg overlays                      |
  | Add transitions              | Add FFmpeg transitions in Render Video                 |
  | Generate vertical videos     | Set output to 1080×1920                                |
  | Auto-publish to Shorts/Reels | Duplicate Publishing Agent and configure platforms     |

  🧠 Example Use Case

  A faceless creator wants to upload daily POV Motivation or POV Business Advice videos.
  The workflow generates:

  Titles
  Visuals
  Voiceover
  Full edit
  YouTube upload

  100% automated — no editing required.

  ✅ Benefits

  Produce 10× more faceless videos daily
  Fully automated end-to-end pipeline
  Consistent POV aesthetic
  No camera or studio required
  Instant upload to YouTube
  Ideal for agencies selling bulk video packages
  Perfect for Shorts, Reels, TikTok & YouTube videos

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserItemList","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.youTube","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","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","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE51ZbW8buRH+K4Y+iyk5HL7lUw9p72Dg0hwu6RXFISj4MrSFyJJrr3sJAv/3m5VcayVxbWkDOIm11PDZmWdeHvL77Ia6OHv7fbZY3XdxlemyzN7OMnoFtTrv0WRpCgSDNqBWhK56irFaXWqJriYVU1EGPAbQPgWbq7J2Np91dHO7jB29u6Ny/5G6h9t3a/6EOuINursHepzPVutC97O3v/Pu/a5ekS+JvJC+eIHaKeFzLsIjgSeJoCCy5VW8IV79MV9TeVjSxae7xdUV3fV7frvtn6z8SmxMixTv6c3908Ldutv1/aJbrFe8tbAo56jhM38a79hyR3cM6fvj1tpv/NtmoXoDj/MnnMVa9BRQ1GoU41RexGCr0AaoepnQG7vD+dN6fcUoP14TdfejIK82q54XDRGyc09BiG/MM0LpVNEks1DGokBin3r+gLcKYJEcEdYBQlrRHYfq4tOiW9IA418Z5F92QJdxdZWv42L1ZvP3z8ubA6QoT/TlDiloqOATCJt8EBgLiFSgiKqc9sr6YK3ZIf1wS6sfLi/eXcfu4j1jWp6AdXnTL998c3GAV3ucGyvPiT0p0h6SFrInKlpAkYxOQsti0PlcQxjE/pKz4OLnxX138eGhu33oLn6Jd/dDqo6iXm/Wb5f3VnojB+jB2JPQP2N3FSuCIQFZ96xISgTF+aVkzAlRJpA4yK9ukb98u/jHuqPx1NqseVoyxOa0nWvrD7HN8nrV0apjS7NxnFl5n5NLAhJExlm9SGALe7taLjHaJOcPOXGKSxsUUIhzi68TwO9Sy4LOTqJQBbVAh0VE/iMSFWuytlpq33Sikme7Uc6PonuaB30p0UiKoqjKHiwyiJiMFzobDzHEWLxtg5yAEXAiyhDJErIDa7ZJYAKuo1zpRZFGVSBdQtI7lJ/oaye6tbi8iVfjjLzuuttf6b8PdJguFudavhppHKR6AJN9dFok7J1IpYqkI4jiFIDzVntNO3j/iotuFNUf24cDOAD/x/MHpev1+sum71YTuDpnEkZGzlAXvAgapJAVTXFgit0w/xWy7jxcuIt7S1IYYjdjZcs+IjcumZ0voZQ9HvxE3cVE7/aV9Ez3MilDSeze4oErP+ggQi1JkMcUPSqXITQ5ChM4in4iRwuHmWx0wljNvR51ZI7aIHJwToUgPZg0qPe993qS/rYotJ5EUoPnkVSrUpEnEK9j3z9VEVwhQaCPEkAW9Bb3STqe4m2WbgENWWoKOVuTESpKyaxyJCKnh1CgSoiGdIr5HJZCQZV1ziK50velmPltPAprQy46Jn6K+yyd6N5Nvz/PvzLqhJpDn3ThdzXc76Nid6dcs8w5YzGyyVI9gaUOJrI0l2QKFw8BlSyjLJYnUocCSBXPwx53AXlcST+uH1ZlEkm9fHXsGDpRcZ0JBYEJw7FFqOzEmoNQibMnWZ0tDZLon7fLdSwX738Zd+F2Wv7b3eJ/dEzYE8DpYRUCaUwRtjj2nGMfBk2KZQFTD12JGnEIrfRz8g850/1rs3wDXc+/s9Bxp8kxVyeiNVVgYOKFwLNbcNwfsVTWYe0aqc5v5Fb66SMb68PMg5ni5shzG0rluNEkKZIqTldyzsi8A/qe7l5oMjdPT4fYHMwRj7CNO85WnmwTkCAkLos1gIhMNZYVnApYHBsbMG4zof99STf8nuNhzfzffVi+1zuvj48D9cByTPoseRBTYasefEUrciom+lS1ygO18yutCt1NLXahl41NcPSV8kNHH1jtb6X4S6kbOANIctfzmsddYpdG0JVrPUt9HSCDGmjyHxeruNwCZtmz+jJB7irZx/p1pw7lLqhac+T6HDSLXNSZ0yRZYAoadraszMShsDk4OHhhnnjp5EDpUQePqkcLrMw1C93EAzqnCXH8UwVhNBnQSqZKZQf03+uHTw9pPFG+PT8fwmJunwRrR8psC1ruFiTBca5wT2fxxS603DVspeipLQvV+T2up830KmOCVxG4cdRcGGlRhh3puVizS00EyKQG6fM8KEymIrLCPpOKCbM3IEHYrLifKGB5CDbyxK3IsVtjdK1Z5uLHy+WEsVvZ0yrQMKMdz/wlJicU5wxPjNxdArLQUNG7qJC4QLpmuHHaMcBx2T4t2CrxdMmVWmg0cXsaGKSrLBe0jl5Jj4GaOM00nM4cHVydBlQjy4BIrj+z4sEbJTs0RVa1RBQgKW1KG6idMCL255VTzwSSrRWsCJlFLDOTk8ewktE8xkrQNlnXjrubArMhBk+DyfzLKC1rVKiGZUx/KJATComKxwpV5Jg3/QSYIUyMeY4KKEQlvHJ9W+Rmk4iHnugj539SNso2yjABpdJqKkwVbJEsr2VVPHinvmB66BPec6vMuRRb26X9fJHdz49TVXb2NbkckzCeswdD1YJ/nEg1guPqxD0otnGen+w9Ts73aUAjqyzbnwlFW3jSsCxnYmG5zTOSsd45AD3SK89P9k2vVMcHvKchBW08z77ciEIvqo2xIgXumpXnJAPRsPZqp7s6P983SM/2Ka/m5yvKvZXN8s0ZGv97Exe92d+/b26I2idTmzXz2YJH5K+zt/Lx82feYSssWhZGRvymle0pyRiOg3G8aeHpTLplYuQYs2lm99otS2OHTaOmtuteAnVwInBoaf78hQMFt79Qbbcc6PjWniNaeuKesN1zTzK1dh1XKG237V3etSkxcnnWtLdPw5a9tuhrGtunUsvY/qH0i0a2oW8H6vg8pmlqP6ItUy+GUB8wdTsTt8wcCaOXKb8N9Iv5fDB/N+0d5NuYv9WrsPYJ07JzeKc1MSmedjy6KW+6on1N/UJ5G17DssW4+E9/1/bATnr67JQsOfrWa+DhlUCekNRjt7LblxjevJ78Dntf2t/v8fFPE+sRW2UhAAA=

metadata_json:
  {"categories":["Content Creation","Marketing","AI/ML"],"complexity":"medium","use_cases":["Generate viral POV faceless videos","Automate short-form content production","Create AI-driven video scripts","Auto-generate visual content from topics","Publish videos to YouTube automatically"],"estimated_setup_minutes":30,"required_services":["YouTube Data API","OpenAI","DALL-E","Google Drive","Descript","Alt:text to image API","Text-to-speech API","Background music API"],"key_features":["AI-generated video titles and scripts","Auto-creation of visual clips from topics","Background audio generation","Faceless POV-style video rendering","Direct YouTube publishing automation"],"target_audience":["content creators","YouTubers","marketing agencies"]}


name: Create & publish inspirational videos with FFmpeg, Google Drive & YouTube
author_name: DuyTran
author_username: duytran82
categories: []
created_at: 2025-12-08T08:01:45.062Z
updated_at: 2025-12-08T08:01:45.062Z
url: https://n8n.io/workflows/11591
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  More workflow: https://aitool.wiki/

  Auto Video Merge & Social Upload Automation
  An end-to-end workflow for generating, merging, and publishing short-form inspirational videos across YouTube, TikTok, Instagram, Threads, X, and Facebook.
  📌 Overview:

  This workflow automates the entire video production and publishing pipeline. It takes random quotes, background videos, and background music from Google Sheets & Google Drive, merges them into a final video using an API, uploads the output to multiple social platforms, and updates the content tracking sheet automatically.

  Perfect for creators who publish motivational or short-form content daily.

  🚀 Key Features
  Trigger Options

  Manual Trigger – Generate videos anytime.

  Scheduled Trigger – Auto-generate videos every 5 minutes or at your preferred interval.

  Source Data Collection

  The workflow retrieves content from Google Sheets & Google Drive:

  Quotes – From Quotes_status sheet

  Background Videos – From a Google Drive folder

  Background Music – From a Google Drive folder

  Each item is appended back into Sheets for status tracking.

  Nodes used:

  Retrieve Quote Data

  List Video Background Files

  List Music Background Files

  Retrieve Video Background Data

  Retrieve Music Background Data

  Random Content Selection

  A Code node selects one random:

  Quote

  Video background

  Music track

  This ensures each final output video is unique.

  Node:

  Select Random Video, Music & Quote

  Video Generation & Merging

  The workflow sends selected video + music URLs to an FFmpeg merge API:

  Initiates the video merge

  Continuously polls the status API until the job finishes

  Downloads the merged MP4 file

  Saves the final video locally (video1.mp4)

  Nodes:

  upload and gen video

  check status

  If

  Wait

  download video

  Save Final Video

  Optional: Upload to TikTok / Instagram / X / Threads

  Disabled by default but preconfigured for:

  TikTok

  Instagram

  X (Twitter)

  Threads

  These nodes use upload-post.com API for multi-platform posting.

  Nodes (disabled):

  Upload Video and Description to Tiktok

  Upload Video to Instagram

  Upload Video to X

  Upload Video to Threads

  Each platform’s upload result is written back into Google Sheets:

  TiktokURL

  InsURL

  XURL

  ThreadsURL

  Upload to YouTube (Enabled)

  The merged video is published to YouTube via the YouTube OAuth2 node.

  Generates title using filename

  Uses the quote as a description

  Uploads as a public YouTube Short

  Node:

  Upload to YouTube1

  After uploading, the YouTube link is saved into the Google Sheet.

  Google Sheets Status Update

  Once the workflow finishes uploading:

  Updates the row associated with the selected quote

  Mark status as DONE

  Stores YouTube / TikTok / Instagram / X / FB URL

  Nodes:

  Tiktok Update Quote Upload Status

  Update Instagram status

  Update X status

  Update FB status

  File Upload to Google Drive

  The final MP4 is also stored back into a designated Google Drive folder.

  Node:

  Upload file

  Telegram Notifications

  The workflow sends Telegram messages to notify:

  Merge status

  YouTube Upload ID

  Nodes:

  Send a text message


  📁 Files Used

  Workflow JSON: /mnt/data/Video merge and upload Youtube.json

  🧩 Ideal Use Cases

  Motivational video channels

  TikTok/Reels/Shorts content farms

  Automated inspirational quote pages

  Multi-platform social media distribution

  Zero-touch daily video generation

  🌟 Summary

  This n8n workflow is a complete video-automation system. It builds an original video using randomized components, merges it through an external API, publishes it across multiple social platforms, and updates your content tracking sheet—all without manual effort.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleDrive","n8n-nodes-base.set","n8n-nodes-base.googleDrive","n8n-nodes-base.googleSheets","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.readWriteFile","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.readWriteFile","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.googleDrive","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","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","n8n-nodes-base.telegram","n8n-nodes-base.httpRequest","n8n-nodes-base.youTube","n8n-nodes-base.youTube","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE91a224bRxL9lQEfgl1AbfT9oocFHDt2lNi52E7sJMhDX6qliShSSw5lK4aB/Yf9w/2SrSZlcUTOkEPZ+5DNgxHT3V1nqqtOnaqZ96M6jY5HPz795s3rr97EP3/48ezXd/U3o6PRBTR+dPx+VE/mjZ9EOCnrfIpCgIwuSR0ZVYYpB8kqSz3nigpmomJGyEBNBpFMcp5HHwKnzlrhNJ7bwMXl2DfwaAZp/hKaxeWjKf4CDaCBZraAD0ejib8AtPbLdNEsAlSvcEvZ6U/no+Pf3q8gf21OXowlfbt49fY5Cye/jG63Pfezc2jqySn+FGeAttLDBn/nlCvCGOHmFaXHwh4z94BZ/SsuW1ym/cs+HN2YfvPHdw+fLa6fzlN+MhE/1WvTD0+G2BRykM2y7NbmH+6bsfnaffuwltafuW/XNj86dIhlrQZZLss+/I4WpglaLndOcikMJZZyTaTkjDiuE+GKaQwM/McY17heNn7WVA8XzfTRuL6sXk9n53k8fVsu8vqyLJjYCVlaIMHP4cGFnyz8+NWsPj2FGa66nM7rpp5O0D4RisojIilFUJd+hgYamCGy9x9Wp/2Mf1suZbcOc8Y4pgIlLCRLpMNntNokkkIAaTSwkFtgX0Azq+EKqp/rBNPqSx/PT2fTxSRVjz3mQR/m0+n0dAwvzwCa+SZkqvQR/in3QZYP1C1oDZajky3RRksiDXXE6+QJaOZVcipryztA/7iYNnB/pNxSdK7TByF13gUDkYiQMRa8w6gQNhOplGfeOfRvWCN9Vs+bbdc+qccw34P48ay+gk7AA1wrbuFasAJ4pkRyUUAChi6yFMnMpcyzt9yINdxH00muTxczqJ4v5nW8g3k6TjCrTh734p5D04mXMb4X7wN5izgLAyryRJySDEM/AfHGSmKTTTqF5HLWGw7eBntfBy9jdwjgW7iK6xy980RJ7jFyZSRe2UQyzR4w3bgwriNytyDfN4i5FXwQ5HYQ5yy4kSoRowWmG0dqw+D1JHoQJihtBWuBfg6zU1j6tHoJY4jF9G68F2XHJlBN7RHh/IDgZYHbwJwgWEYTkclrErKKRILJOmqXFW/l2gpb9cJP0vRilXRHN37+YsUUvXgj/u8mXGGReTm1++DytVepzlxrTgzjjmC5QhKznhMhUCmY4LwStB0KPlVY6C8XTZXRt73gsLal17O6gSerVW2UTMpBl8+ORn781l/Pv18aXF7ecfbjOaydjbXeJQUkMIF1gxlOghHo7BCSEBkiBsga/UnuxVvnTZBcD0PJH/BWRYjALJbb5JMgUqRAvNeKxAROCBUCptsaTpq+nYyn6NCrcu290M6a5vIF/HMB802qYlQOoyr5gO/3pbI80YwKQSobkBSwPvjAkCMMw1ruKLJYi3XjGcTzCtVms+gnrR3QndCDIlW23OshCM0pJYonhMk4EqymRddkkMA5U16tES4ul87FzKpOYXJvJ3Om6cFIlaLMOu1IcJZj6jMk2Gw0iUwxK6PS6NE10te+bnqRvV39490Esvbjvb+FcDadnp/cSD7kHGmJVYC0nrDWOxMtMYGbEEPGXFnm4s6ke7BWZagyJMVCQcBBiQiG/nYBoztSJywGO2esRWUYEmmBfLtWhT0192bhDvUo93qbtbydjdGagSFaKkw7hyHho8dCkbEqxKCw+WFtFmAH0ADSIt6+OYgGpJQqBypJCAzlFhVIAwEpllIWBc3KC2XWeH5axelKcDXT6qT0cKdoamCwTrBIIKLRU5jADFuFqp5Uq9gn+CQN1omLqjkDPPoc06Ckg0+pGCo/YhOSYNLUyARlX/npDKkbZuQfpRs4m87qP31xxnH18LI+h+vqb6tzzmAGf0frqZ77MP7YDt5xnjKY4p03uYR8MnlSOoybfb2pJHmIJueMgeFREXqG4W2R4hWLwXpUtsbGtjNLt7T24T6G2hApO57GUtrzNL2KhWMN4TxHwpMG5CvJi44FLLXeSacEl0n1x8Gb/4f7x1r/iffvGDawWQZCtUQnWoMCxUMRgF5IlH5YErbv/83nvffup+i9d5ROXCDLI0VbWxpDQRxFLWCxemllrTTpjgQsV1I18K6pLmA+96f9sqpBuXhDDdsFQWi7URCs4wFFnCI0BxR3xkfsSAKyo8eqZqjCqm73F4T1XVBlqAEfUBOUgDYRay/DrkdYH0DwxCJLrQfzV0WBT/x4FdT3EouWDWtu1lWLGZesx+YrCY4gJeafNYkRrfFKMioxCWIrYJ58+XkjBoX4IRETgkIeE4JkHkUZnWS8KJQ3kimhuAhetCvY44/Ccdne5Bkm+NMluupjf3ioyFFuaD+2DgbDXOQckN1AYZSrgN1vkPgIy7TMgnrZCoav3jUzj51OgVx+ql7XyC7YRuA/wGR5+gE9urYHt+jJoJiRlhGGQqgkJboY4xkVEmMaA1dFtb+O8Ht0uyuVfmDlyNg2GJOJjqXXpQwZxAVONHfM6WSBZrtVOXY2ZL3zg4FtzrrBpcmDicoTLlELSu4UkoByKMqFSgodqyPvr2pPvvzLlzXdl96HlDXujIkeFbUUzBVZ41EbxEwCdjJgOGVStzTi91cwu6qhfx47b+p4fv3dal7QThXsCJYqbGsYO4rTCWZeGSuP+skUOweFpO+JCFGW8YAi1jMgzLPADCoYJVpZ82h1ZPUMb6menFb/+de/q6ez6eLycNxClCkB8tL9cGOiJGbLzDBh+UOUmEA2RXSvVTwnxbJsjzVW45f1oOgTgHNteOf0exhwTCAhDdcE2RPjInBFghVAouUuWkZR9GxNuX6YTSMKh09CLUudvTdq7L5ZQI8TmymizljEvMvY+SYbveU2Wqe3OOGL6odFGNfzs08CzsuEDtHfD7jRKUcZE4nJlRcPyGgoFhS6u3TpOjGV8xr4Kyxh5yWwV+XhkzzOXJnV3Rs4RCwDDCsE1gOGxyB/WOEzMdEYFTEvufNDPN7fC/chV6UjVtuKeGB8a2qxAU6EWcOKnC8TOxqJZznifwb1fMvht0rnfrWNHzwZ90ozGbnDwutlec1iicu5TPNRLltrg26Lmg7p3q8QurX7as4o/9fKPVBa3qN4EpJGPpQJw8U5PI+64EBarlzeVbT7w+QvVLV7pngHTSMyAyUs9vDOFT96S3w0lgCASNJKrjxs+REf75fp4tUiQL8br1cLNlJNdlNEf3pxxZmywpHEc8CwUmUEKZEWgpBANWhqWiOH59OrchXV5dhfIy00B8Izupt6d8BjKEcYei650udEyMQBdpFCJBODwhKS4hC6PZy1CFu+Jju4wuFqbFsKs6zG5UcjbEfK9wrLrfAO4qJY+H6GYYonXLFyxtVq/yqTS9efLCXUeYNqD9k6qCQIpQIJBRSNpjAKgpisxMfy4JNc/rzwdcH+2/vly/0drwyWC49G9STBu9ExRdTrPd2T+q0dvyPuMhrtMrtzRLHL9t3JdqfN5ZIuo+23NZ07221P1wE9xaPzrDtO6kbD9hxx11zXGbvoYPPIo81d3WQ8fFvHWHn45jf3A7rHYxvR3Bl5vTOkzhO33k/uuIYBUbFlfWeY7ZvGdJvYfGvSZeKwTxz6b2jQlx3923d+wtL5dNsFpvtC9g1bduV/K0h3HL49ER50JsbwjkM7poa7Tm0nftepO8pxT7Rv30fnufu/hRjojDu4l2s637J2gTigDPV9jNZ17EEx+dky4dMS8sa5PUE/sADvy47+S+82MPw7lEGxsi43B2T8Hhu7vpvaGRt7PlzqN9YTITuN7fkocXcmdyP9LEnNN0x14/wsptiGIuqpjF22DnlP0OnKAQd0X1/fl03dFLU/X7qs7P4mpdPSIKrpsjXoK8MOkx8+/BfrVkJDaC4AAA==

metadata_json:
  {"categories":["AI/ML","Video Production","Social Media","Marketing","Communication"],"complexity":"medium","use_cases":["generate short videos automatically","merge text quotes with background media","publish videos to multiple social platforms","extract random quotes from Google Sheets","upload video to Google Drive and YouTube"],"estimated_setup_minutes":30,"required_services":["Google Sheets","Google Drive","Telegram","YouTube Data API","Video Processing API"],"key_features":["automated video production pipeline","multi-platform social media distribution","media extraction from cloud storage","automatic video merging and rendering","publication scheduling across platforms"],"target_audience":["content creators","social media managers","marketing teams"]}


name: Sync Zoom webinar attendees to Mailchimp with double opt-in and email filtering
author_name: Easy8
author_username: easy8
categories: []
created_at: 2025-12-08T08:39:45.942Z
updated_at: 2025-12-08T08:39:45.942Z
url: https://n8n.io/workflows/11593
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Description

  Use this workflow to automatically sync Zoom webinar registrants into Mailchimp, filter out internal contacts, and send double opt-in confirmation emails. Ideal for keeping your newsletter audiences clean, accurate, and enriched with new leads—without manual export/import steps.

  About Workflow

  This workflow connects Zoom Webinars with Mailchimp via API to automate the onboarding of webinar attendees into your marketing audience.  
  It retrieves registrant data from Zoom (based on Webinar ID and Occurrence ID), extracts attendee emails, filters out internal domains, checks whether the contact already exists in Mailchimp, and then creates or updates each record.  
  New contacts receive a double opt-in confirmation email, and all newly added leads are tagged for segmentation inside Mailchimp.

  Use Case

  Perfect for marketing teams running webinars who need to transfer participants into Mailchimp quickly and reliably.  
  This automation streamlines attendee follow-up, ensures compliance with double opt-in requirements.

  How it works

  Manual Trigger – Execute workflow**  
    The workflow starts manually. You can optionally replace the manual trigger with a Schedule Trigger if you want to automate recurring webinars.

  Manual Input – Set Webinar ID and Occurrence ID**  
    The workflow includes a Set node that requires you to enter:
    webinar_id
    occurence_id  
    These define which Zoom webinar instance will be synced.

  Zoom API – Get Webinar Attendees**  
    Retrieves registrants for the selected webinar occurrence using the Zoom API.

  Code Node – Extract Registrant Emails**  
    Processes the Zoom API response and extracts the email addresses of all registrants.

  Filter Node – Filter Out Internal Emails**  
    Removes internal/company email addresses by checking that they do not contain your domain.  
    (This is fully configurable.)

  Mailchimp – Update a Member**  
    Attempts to update the contact in Mailchimp based on their email address.  
    This determines whether the contact already exists.

  IF Node – If ID Doesn’t Exist**  
    Checks if Mailchimp returned an id during the update attempt.  
    If Mailchimp did not return an ID, the contact is treated as new and continues through the creation + confirmation path.

  Code Node – MD5 Hash Email**  
    Hashes the email using MD5. Mailchimp uses this hash as the unique identifier for list members.

  Mailchimp – Send Double Opt-In Email**  
    Creates the contact with “pending” status and sends a double opt-in email.

  Mailchimp – Add Leads Tag**  
    Tags the contact with "Leads" immediately as part of the creation process.

  How to Use

  Import the workflow into your n8n instance

  Configure credentials:
     Zoom OAuth2 credential  
     Mailchimp HTTP Basic Auth credential

  Enter webinar details:
     Set webinar_id and occurence_id in the Type in IDs node

  Adjust internal email filtering:
     Update the domain in the “Filter Out Internal Emails” node (e.g., change @yourcompanydomain.com)

  Configure Mailchimp nodes:
     Replace LIST_ID_HERE with your Mailchimp Audience/List ID  
     Adjust tags if needed

  Test the workflow:
     Run it with a real webinar and confirm behavior:
       internal emails are excluded  
       existing contacts are updated  
       new contacts receive the double opt-in email  
       tags are applied correctly

  Example Use Cases

  Automated lead generation from webinar attendance  
  Keeping marketing lists clean and external-only  
  Recurring webinars with scheduled syncing  
  Easy double opt-in compliance with no manual steps  

  Requirements

  Zoom account** with API access  
  Mailchimp account** with API access  
  n8n instance** with correctly configured credentials  

  Optional Enhancements

  Replace the manual trigger with a Webhook for recurring syncs  
  Auto-detect the latest webinar ID using a Zoom API call  
  Add additional filters (e.g., job title, country, language)  
  Add Slack/email notifications summarizing new leads  
  Add error-handling paths for retrying failed API calls  

nodes_used:
  ["n8n-nodes-base.mailchimp","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.manualTrigger"]

workflow_json_compressed:
  [encoded data, 4128 characters]

metadata_json:
  {"categories":["Marketing","Customer Outreach"],"complexity":"medium","use_cases":["Automate webinar lead capture","Clean contact lists","Send double opt-in emails"],"estimated_setup_minutes":15,"required_services":["Zoom","Mailchimp","Gmail"],"key_features":["Automatic attendee sync","Double opt-in implementation","Internal contact filtering","API-based data transfer"],"target_audience":["marketing managers","event planners","sales team leads"]}


name: Interactive recruitment customer service with WhatsApp, Google Sheets CRM
author_name: Mira Melhem
author_username: melhem
categories: []
created_at: 2025-12-08T12:09:28.460Z
updated_at: 2025-12-08T12:09:28.460Z
url: https://n8n.io/workflows/11604
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:20
description:
  👔 Recruitment Office WhatsApp Automation

  Automate WhatsApp communication for recruitment agencies with an interactive, structured customer experience. This workflow handles pricing inquiries, request submissions, tracking, complaints, and human escalation while maintaining full session tracking and media support.

  Good to know

  Uses WhatsApp Interactive List Messages for user selection and navigation.
  Includes session-state logic and memory across messages.
  Includes a 5-minute cooldown to avoid spam and repeated triggers.
  Supports logging for all interaction types including media files.
  Includes both a global bot shutdown switch and per-user override.

  How it works

  A customer sends a message to the official WhatsApp number.
  The workflow replies with an interactive menu containing 8 service options:
    💰 Pricing by nationality (8 supported countries)
    📝 New recruitment request submission
    🔍 Tracking existing applications via Google Sheets lookup
    🔁 Worker transfer link distribution
    🌍 Translation service information
    📄 Required documents and instructions
    ⚠️ Complaint submission and routing
    👤 Request a human agent
  The workflow retrieves or stores data based on the selection using Google Sheets and Data Tables.
  If the customer requests human help or the logic detects uncertainty, the workflow:
    Pauses automation for that user
    Notifies a designated staff member
  All interactions are logged including files, text, timestamps, and selections.

  Features

  📋 Structured WhatsApp service menu
  📄 CRM-style recruitment request logging
  ✨ Pricing logic with nationality mapping
  🔍 Lookup-based status tracking
  📎 Support for media uploads (PDF, images, audio, documents)
  🧠 Session tracking with persistent user state
  🤝 Human escalation workflow with internal notifications
  🛑 Anti-spam and cooldown control
  🎚 Bot master switch (global + per-user)

  Technology stack

  | Component | Usage |
  |----------|-------|
  | n8n | Automation engine |
  | WhatsApp Business API | Messaging and interactive UX |
  | Google Sheets | CRM and logs |
  | Data Tables | State management |
  | JavaScript | Custom logic and routing |

  Requirements

  WhatsApp Business API account with active credentials
  n8n Cloud or self-hosted instance
  Google Sheets for CRM storage
  Data Tables enabled for persistent session tracking

  How to use

  The workflow uses a Webhook trigger compatible with common WhatsApp API providers.
  Modify menu content, pricing, optional steps, and escalation flows as needed.
  Link your Google Sheets and replace test sheet IDs with production values.
  Configure human escalation to notify team members or departments.

  Customising this workflow

  Replace Google Sheets with Airtable, HubSpot, or SQL storage.
  Add expiration and reminder messages for missing documents.
  Add AI-powered response logic for common questions.
  Enable multi-country support (Saudi/UAE/Jordan/Qatar/Kuwait/etc.)
  Connect to dashboards for reporting and staff performance analytics.

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.respondToWebhook","n8n-nodes-base.switch","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.respondToWebhook","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.switch","n8n-nodes-base.dataTable","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.dataTable","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, 29236 characters]

metadata_json:
  {"categories":["Human Resources","Customer Service","Marketing"],"complexity":"simple","use_cases":["Recruitment automation","Customer inquiries","Pricing requests"],"estimated_setup_minutes":120,"required_services":["WhatsApp","Google Sheets"],"key_features":["Interactive list messages","Session state tracking","Human escalation"],"target_audience":["Recruiters","Customer service managers","Agency owners"]}


name: Clone and change your voice 🤖🎙️with Elevenlabs and Telegram
author_name: Davide Boizza
author_username: n3witalia
categories: []
created_at: 2025-12-08T13:42:12.200Z
updated_at: 2025-12-08T13:42:12.200Z
url: https://n8n.io/workflows/11606
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  This workflow creates a voice AI assistant accessible via Telegram that leverages ElevenLabs* powerful voice synthesis technology. Users can either clone their own voice or transform their voice using pre-existing voice models, all through simple voice messages sent to a Telegram bot.

  *ONLY FOR STARTER, CREATOR, PRO PLAN

  This workflow allows users to:
  Clone their voice by sending a voice message to a Telegram bot (creates a new voice profile on ElevenLabs)
  Change their voice to a cloned voice and save the output to Google Drive

  For Best Results

  Important Considerations for Best Results:
  For optimal voice cloning via Telegram voice messages:


  1. Recording Quality & Environment
  Record in a quiet room with minimal echo and background noise
  Use a consistent microphone position (10-15cm from mouth)
  Ensure clear audio without distortion or clipping

  2. Content Selection & Variety
  Send 1 voice messages totaling 5-10 minutes of speech
  Include diverse vocal sounds, tones, and natural speaking cadence
  Use complete sentences rather than isolated words

  3. Audio Consistency
  Maintain consistent volume, tone, and distance from microphone
  Avoid interruptions, laughter, coughs, or background voices
  Speak naturally without artificial effects or filters

  4. Technical Preparation
  Ensure Telegram isn't overly compressing audio (use HQ recording)
  Record all messages in the same session with same conditions
  Include both neutral speech and varied emotional expressions

  How it works

  Trigger  
     The workflow starts with a Telegram trigger that listens for incoming messages (text, voice notes, or photos).

  Authorization check  
     A Code node checks whether the sender’s Telegram user ID matches your predefined ID. If not, the process stops.

  Message routing  
     A Switch node routes the message based on its type:
     Text → Not processed further in this flow.
     Voice message → Sent to the “Get audio” node to retrieve the audio file from Telegram.
     Photo → Not processed further in this flow.

  Two main options  
     From the “Get audio” node, the workflow splits into two possible paths:
     Option 1 – Clone voice  
       The audio file is sent to ElevenLabs via an HTTP request to create a new cloned voice. The voice ID is returned and can be saved for later use.
     Option 2 – Voice changer  
       The audio is sent to ElevenLabs for speech-to-speech conversion using a pre-existing cloned voice (voice ID must be set in the node parameters). The resulting audio is saved to Google Drive.

  Output  
     Cloned voice ID (for Option 1).  
     Converted audio file uploaded to Google Drive (for Option 2).

  Set up steps

  Telegram bot setup  
     Create a bot via BotFather and obtain the API token.  
     Set up the Telegram Trigger node with your bot credentials.

  Authorization configuration  
     In the “Sanitaze” Code node, replace XXX with your Telegram user ID to restrict access.

  ElevenLabs API setup  
     Get an API key from ElevenLabs.  
     Configure the HTTP Request nodes (“Create Cloned Voice” and “Generate cloned audio”) with:
       API key in the Xi-Api-Key header.  
       Appropriate endpoint URLs (including voice ID for speech-to-speech).

  Google Drive setup (for Option 2)  
     Set up Google Drive OAuth2 credentials in n8n.  
     Specify the target folder ID in the “Upload file” node.

  Voice ID configuration  
     For voice cloning: The voice name can be customized in the “Create Cloned Voice” node.  
     For voice changing: Replace XXX in the “Generate cloned audio” node URL with your ElevenLabs voice ID.

  Test the workflow  
     Activate the workflow.  
     Send a voice note from your authorized Telegram account to trigger cloning or voice conversion.

  👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n.

  Need help customizing?  
  Contact me for consulting and support or add me on Linkedin. 

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.telegramTrigger","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","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, 4308 characters]

metadata_json:
  {"categories":["AI/ML","Communication","Voice AI"],"complexity":"medium","use_cases":["Clone personal voice","Transform voice identity","Create voice AI assistant","Send voice messages via Telegram"],"estimated_setup_minutes":20,"required_services":["ElevenLabs","Telegram"],"key_features":["Voice cloning","Text-to-speech","Telegram bot integration","Voice message support"],"target_audience":["developers","content creators","voice enthusiasts"]}


name: Automate YouTube Shorts creation from Telegram prompts using Gemini and VEO
author_name: Hyrum Hurst
author_username: hyrum-hurst
categories: []
created_at: 2025-12-09T01:52:15.475Z
updated_at: 2025-12-09T01:52:15.475Z
url: https://n8n.io/workflows/11617
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:19
description:
  Who this workflow is for

  This workflow is designed for content creators, marketing teams, and automation builders who want to produce short-form video content at scale without manual editing.

  It is especially useful for teams posting consistently to YouTube Shorts, Instagram Reels, or TikTok who want a repeatable, automated content pipeline driven by AI.

  What this workflow does

  This n8n automation converts a single Telegram message into a fully generated short-form video using AI.

  When a message is sent to a Telegram bot, the workflow:
  Generates a structured short-form video script using Gemini
  Creates multiple cinematic video clips using VEO
  Merges clips into a single short video
  Generates a title, description, and hashtags optimized for short-form platforms
  Delivers the finished video asset and metadata back to Telegram or storage

  The entire process runs automatically without requiring manual scripting, editing, or clip assembly.

  How the workflow works

  A Telegram message triggers the workflow with a short content idea
  An AI model generates a multi-part script optimized for short-form video
  Video clips are generated for each script segment using VEO
  Clips are merged into a final vertical video
  Metadata (title, description, hashtags) is generated and attached
  The completed short is delivered for review or publishing

  How to set up the workflow

  Connect your Telegram bot credentials
  Configure your Gemini and VEO credentials
  Review the prompt templates used for script and clip generation
  Adjust output destinations (Telegram, Google Drive, or manual upload)
  Activate the workflow

  All required credentials are stored securely using n8n credential management.

  Requirements

  Telegram Bot
  Google Gemini credentials
  VEO video generation access
  n8n instance (cloud or self-hosted)

  How to customize the workflow

  Modify the AI prompts to match your content style or niche
  Change clip length or number of generated scenes
  Add automatic posting to YouTube Shorts or other platforms
  Extend the workflow with analytics or scheduling steps

  Author: Hyrum Hurst  
  Company: QuarterSmart  
  Contact: hyrum@quartersmart.com

nodes_used:
  ["@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.telegramTrigger","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.googleDrive","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.set","n8n-nodes-base.googleDrive","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.wait","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.youTube","n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.googleGemini","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, 9872 characters]

metadata_json:
  {"categories":["AI/ML","Content Creation","Marketing"],"complexity":"complex","use_cases":["Generate short-form video content","Automate social media posts","Convert text prompts to video"],"estimated_setup_minutes":30,"required_services":["Google Cloud Vision","Google Gemini","Google VEO","Google Drive","Telegram Bot"],"key_features":["AI-powered video generation","Text-to-video conversion","Automated content pipeline","Multi-platform export"],"target_audience":["content creators","marketing teams","automation engineers"]}


name: Automated stock technical analysis with xAI Grok & multi-channel notifications
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-12-09T03:41:07.840Z
updated_at: 2025-12-09T03:41:07.840Z
url: https://n8n.io/workflows/11621
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  Who is this for?
  This workflow is designed for stock traders, financial analysts, investment enthusiasts, and anyone interested in automated stock market analysis. It's particularly useful for those who want to make data-driven trading decisions based on technical indicators without spending hours manually analyzing charts and data.

  Who is this for?
  This workflow is designed for:
  Stock traders** who want automated technical analysis
  Investment enthusiasts** seeking data-driven insights
  Financial analysts** who need daily market summaries
  Portfolio managers** tracking multiple stocks
  Anyone interested** in algorithmic trading signals

  What this Workflow Does / Key Features
  Automatically triggers daily at 9 PM to analyze stock market data
  Checks if the market is open before proceeding with analysis
  Fetches historical price data for major tech stocks (GOOGL, NVDA, META, AMZN, TSLA, MSFT)
  Calculates technical indicators:
    RSI (Relative Strength Index) to identify overbought/oversold conditions
    MACD (Moving Average Convergence Divergence) to identify trend changes
  Generates Buy/Sell/Hold signals based on technical indicators
  Uses AI (xAI's Grok model) to analyze and interpret the technical data
  Distributes analysis results through multiple channels:
    Email via Gmail
    Personal Telegram chat
    Telegram channel
    WhatsApp via Rapiwa
    Google Sheets for historical tracking
  Fetches market news via RSS feed to enhance analysis

  Requirements
  Alpaca API credentials (for market data)
  xAI API credentials (for AI analysis)
  Gmail OAuth2 credentials (for email notifications)
  Telegram Bot API credentials (for Telegram notifications)
  Rapiwa API credentials (for WhatsApp notifications)
  Google Sheets OAuth2 credentials (for data storage)

  How to Use — step-by-step Setup
  1. Configure Credentials
  Alpaca API**: Add your Alpaca API credentials to n8n (named "Custom Auth account" in the example)
  xAI API**: Add your xAI API credentials to n8n (named "xAI account" in the example)
  Gmail OAuth2**: Set up Gmail OAuth2 credentials (named "Gmail account" in the example)
  Telegram Bot API**: Configure Telegram Bot API credentials (named "Telegram account" in the example)
  Rapiwa API**: Add Rapiwa API credentials (named "Rapiwa account 2" in the example)
  Google Sheets OAuth2**: Set up Google Sheets OAuth2 credentials (named "Google Sheets" in the example)

  2. Configure Stock Symbols
  In the "Currency/Symble List" node, modify the JSON to include your preferred stock symbols
  Default symbols are: "GOOGL, NVDA, META, AMZN, TSLA, MSFT"

  Useful Links
  n8n Documentation**: docs
  Alpaca API Documentation**: docs
  xAI API Documentation**: docs)
  Telegram Bot API**: [docs
  Technical Analysis Concepts**: docs

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.gmail","n8n-nodes-base.httpRequest","n8n-nodes-base.telegram","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.telegram","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.rssFeedReadTool","@n8n/n8n-nodes-langchain.lmChatXAiGrok","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.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VYWW/bRhD+KwKftc7eh5/qumgRoGmLuCeCoNhjVmYtkSpJxXEN//cOZcU6TFmS0T4YFqXh7Df3N3tflKk4L97+8NcfF//wu18W0+9nf/3UFuNiBp0vzu+Lsmo7X0V428vF4DwDJTgz2gQtmNZCGm6FZFwYUFoGrqzxgalgZPTUWweBcq+EtDJp1NvBbD71HVw2kNor6Bbzyxq/gQ7wgK5ZwMO4qPwM8LSrro43o3e+uYFudFH56V1btqOLRVfPfFfWVa/NT9ri/MNHfKdO0H+8f7QoIahoeSYBwBMZkyUhOUFUYl4LY7IzqVifFK8hLaYw+rkpJxNoes138/6XylZkqZoE38JZuxJcy83rtlyCOf+g5VhKi1jmvkG9HTQI6P7hUdev+LQUY2f8YbxCaQVVlvlMIqOaSCMV8SYLkikoaYKVMcMa5dsKVc4bdMY3HoOzD2PEj9vAGKd0LCk9BG0NLFNrtbKZZBEMkQodiV8AYUGpqK22LG4Ae+/n5e0goGb5y1nzRWATlON0rBw/6K+1t5K2ispAfEqKyASSWM04UZIKTW3AB70RU6jSyI9m0LZ+Anu9NZn5cjqAjGkEdgvhuq5vlrlvaNIxcE9C7mPFTSIhuEhikuC8loJmUxxy8NnaGhGA4x8lhnK0RodELPeWRHzOWDUsBra25lvo4vVoqyJeTILrrpu/h78X0Hbbxjmjj0kFuZWlHivJKKKiDURmzFdHNSU0SQXgUnTK7/j91jdVWU0Oer+DKUwQxjZGo/gqMzYDwDhYAVQRG6nDnIyRuKA1gRSkdT6hP9mhAGwWn1EpWxECwWxGszQqdZRTDIC2mXLBrbE7Zq08f7WYzXxz90rrlunFqd3NLx4EVhcn1hssORkw0yxHQz01Avssp4yfYl5wWnqJLc9iImFvYZ744DCIFs1GVyosprV572BWN3drS75CU96szZn6ahKvfVmdzZaCXy9yhua3skr17Y51aMJYc3m4DYonqMnLDEl7gu9SjKx02G3wE/XYhhSzOEU2oK4nwQSq7gjIfiW3iVJae1RH3MwXCo5bnYhmNGEZiEiss5rEjCWgccYZxl7Olx+r0eW1ryqYviZlHuH+nymTrVfJGNRC+xaHw4x4m4Fwn4SUOBMg0rWF36FlKwMv6yqVX0byaf1IUJyaTp/SjyjowBjaqXxGY0PiBBMdH6PB771Q2W7MgctrWPdMzJp6DtWbOK3b/XVb5m2MittjMG4mS4CMPUllYny2iDHitNCgiDFRCs6dSHpjgF4umgaqePfm6m4WkIZ8X7bdXnQtdM/b5RG5LM7kOpcN51lFIA7QcUgzHPFO4CyyJoM0SYmYN+b71dXoPfi0F1LTtt8CpF7m57reHafa0uM6wtp94KmkUUhEhekoWaQk9BEP2BKQTDrJ2UZH+Hzx9og2MJ1h8XW/X5TfNfXNbjvg8iiITwA1xtHTyAhVJmJ8NfJLJRQRVrmckxWObpTKVVfGm7vRD3W3P+napcxKZLNAOHKRZ8EtYo1sENvaeVG8gFKqJABhJWwOiJIDQQYViUFykYHS4GMYRMlOhqkNH4tnZO44mOhISbWMSC9DT+wUFgtHLmxtNhCd91zFQZj8ZJgM15Uxfx7p44BizSTjgBOTkP9In3EEiOSJzZwL4TW3Lg0CFaf7EwcU+vR1OJPFLY0KQ7TU6FCjkCmD5lhIOC500MlnP4hTnu5QJN1jnDavA0qFD4kFS7jpSYozOPkFEjGOnJha6nQWehCoOh2ow0lDnnfx44CCTi5TyojoGSOuux5VpYBHaqWoSUEHNwhUnwyU9KWEC/brgBqPrsO6JsAEYGdnFns8JquLOhqWscvnDY9ezOc9T2nq21FZjdprgP1zZ1LXkylc9TLtAD3BKXR4iJsnnMykRHHPIZ4xLCXJALmL10TniHuWpiLI4cib0yOPXH6M9fQ6h0rMxCRUIAmQQkuOW7DFWUeSksLwBEILuTHJp4gBN5+9IGe+WvjpvvuDo/ZhlPCxKz+h9uynLYwLpAQdHro0Cj5DXPQaf2wSnnBefGK9dZ8e31/yRrAOmEIbhEt0lcxWCYJdQQebRaai33zQPRXEXtVScT9l8Z8v/+xn6gJZ9Ts0a4rAP9wvr19e4ObPXhoXuDvA5+KcPnz8iPBW+8ej/tnq4TjFsy+ry7bGp0igTtzxqy11L3PXpfiuvicS9Iix63nOkQi7R060rW9HfgjlviuMXXzj7TcOban7X9+9yDntoKH1Zr+GF1vPYAR27r+GPLYvCIP6nt36/UeZMsjmh3QfvNQZVD+IaEj9MZvP4An7cA0dsu9Sctgz+xENGvDiWvTshPFO5ey9hBrA9vDwL+fPOeMLFwAA

metadata_json:
  {"categories":["Finance","Trading"],"complexity":"medium","use_cases":["perform automated technical analysis","send multi-channel alerts","analyze stock indicators"],"estimated_setup_minutes":45,"required_services":["xAI Grok","Telegram","Rapiwa"],"key_features":["AI-driven analysis","multi-channel notifications","scheduled execution","coded calculations"],"target_audience":["traders","analysts","investors"]}


name: Zip code-based business lead generation with Google Maps and Sheets
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-12-09T04:03:30.506Z
updated_at: 2025-12-09T04:03:30.506Z
url: https://n8n.io/workflows/11622
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:20
description:
  Who Is This For?
  This workflow is perfect for anyone who wants to automate lead generation using n8n without paying for expensive scraping tools. It uses simple Google Maps API requests and Google Sheets to pull business data by ZIP code and category, then extracts emails at no extra cost.

  What This Workflow Does
  Automated Lead Generation**: Runs on a schedule to process ZIP codes and business categories automatically.
  Data Extraction**: Queries Google Maps for businesses based on each ZIP code + subcategory combo.
  Data Processing**:
    Skips entries with a STATUS = "N/A"
    Removes duplicate results using place.id
    Extracts and formats relevant business details
  Error Handling**:
    Uses exponential backoff when hitting rate limits
    Stops after 10 retry attempts
  Data Storage**:
    Saves results directly to Google Sheets
    Tracks which ZIP/subcategory pairs have been completed

  Requirements
  Google Maps API** (business lookup)
  Google Sheets OAuth2** (data storage)
  Telegram Bot API** (notifications)
  Rapiwa API** (WhatsApp alerts)

  How to Use — Step-by-Step Setup
  1. Set Up Credentials in n8n
  Add your Google Maps API credentials (named "Google MAP")
  Add Google Sheets OAuth2 credentials (named "Google Sheets")
  Add Rapiwa API credentials (named "Rapiwa account 2")

  2. Prepare Your Google Sheet
  Create one Sheet document with these tabs:
  zip** — ZIP codes to process
  maps categories** — Business categories/subcategories
  result** — Where extracted business data will be stored
  Then update:
  The document ID inside the workflow nodes
  The sheet IDs (gid values) so they match your actual tabs

  3. Customize the Workflow
  Change the Limit node to control how many ZIP codes run per batch (default: 10)
  Adjust retry limits in the relevant nodes (default: 10 attempts)
  Modify the Schedule node to set your preferred run frequency (default: hourly)
  &gt; This gives you a simple, scalable, nearly free system for generating targeted leads automatically.

  Useful Links
  MAP API Create Project & API
  How to Use google map docs
  Rapiwa**: Get your WhatsApp API credentials

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.removeDuplicates","n8n-nodes-base.wait","n8n-nodes-base.code","n8n-nodes-base.wait","n8n-nodes-base.splitInBatches","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.filter","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.googleSheets","n8n-nodes-base.limit","n8n-nodes-base.telegram","n8n-nodes-base.noOp","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.discord","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.if","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:
  H4sIAAAAAAAAE7VZ2W4bRxb9FYLPLKH2xW+OkzEMJOOMNQtmgjzUcksmTLIZsuVljPz7nCZtsUl1U6STeZBAidW3Tt3tnFv9eTov02fTf89/DO//9nL57pZe2teL36az6ZLaOH32eTpfbdu4yvSqW5dTiIKMksJZl6wS1irtpFdaSOXIWJ2k8S4mYZLTOfLoAyUuo1Ha62Jht6XlehFberGhsr2l9n79osF/qCVs0G7u6ffZdBWXhN2e37fNEkvL5GXT3C1o8lNcbyc/UsQ/aEWb2M6b1eT20xY2O8vxbjt99suveL4p1H38vD+d4a5kbzJLTiqmEzcskXfMVEeSRy2tzdOHXf+xLthzctvG9n47aZvJ7X3OtN12O3xadytWfsV2W7AUt3RztwN3+5ao7RY1qx82m2bTeatZtfPVPe3+fn3fru9bfL9utvMOOPApuG7GPAfkddxg+5Y2wP0ZLqCPlO9beg3P792y3/2fWLB7Vt/I2TQuPsRP273l72MXr70Dv5w7GbIpy8Ki4RHn9oaFEIiFlANPOhgu0uHcz0uZbJoP28l89dXfD2f60w+uhJxJPXTwq08ZHHFbtWTc8MK0D56ljD+F5lypJCq+PZzyh4/rZkWAFxeT72J+19Q6er6Mjye4jeQz5fVTuOUDOlO84yZZVkXMQJcKcs9UVl0MIrjgk6ADuje0bN7T5Pv79WKekYXjvt/sVh4t7OMUXF/iX3EjHpDqlIKJqA1rjGM6psR8iZKhph1qPREVfkD6rzhvR8F92H95mul7x32g9LZp3u36CfFcsYlihP2YDpxYTLkwnnk2JgXuddczLj6DdRRg0rHoXWUakFlULrHoog6pKK4tP5sL4ppkCMrO4J7LkyFLU2vQlXEhiGmpLfMefi7BhozKpBz0sYvH8Tz2MXqw/4Kn72PruENlaDhVoz5qrSwJFZgolicSFLP11/hYRBWNKYpZkpJpo5DR3sNyRsCCjlr1M/rHplmjgyYk6Xgyb5HF7avVd7HNb09TWQTrZ5L7p7ysHgAqk6RzoTDjtAFAgbbnd/3BB6UzcVK9JLjFluV+QePgviz4+2Z+d0ebY3QGfUwEeU2dZem9zoi6TOAgrYpFelYkau2KAMEIYMIHeC/eUn43WcaP8+X9crKhdjOn7c0o2Hk9yQl1YY7eHLKUg7KtUMCWhUZRKgMC8ZyVCupUVIv1vQDfUTvZ7uJLd83m07gb6SRdISH4RYG90Yduyp3gQVimRACj8Y7MFIHTM4fw0FpkJw7Q/jJfwGYP3XwUXd0tPQFoLsu8vu9QCWjxqjIBacR0iZpFLRQrBtVNhUSmntR4Cd/dHnw3qc1mOdl2fHop5/bhqlF/XiAmDulpcgxZc6ZMlwI2KBY4lyzLYJP1CazCj8v728oacC+pnENZe2gW7+BaW4tnGm0GXIHmoy3o1ZbQqdJj1z5fLCb/ma8nL/at+1qHOnD9MMJr/KlMdMah0qXynfhED8ZPYFwjVUw1Odt+u5wvz/Dq4su3PZDhwgb0gKcUopolZ8IBhZaK2I6BNQpdRV6zDrLXHWlVJnHS0sd2soQIjnfjnmxpQXfAcNKBOjdKecpKIaugXa5MRSFQydozH41Aq6pkUhTeknmalQ5uttWJWKUHl0IA6ogDRgwfzBsqQZXYDSqHY33fTFZN+3a+uhs9zap5vR7QMBf0g4OvyXkvq0YFpU6AK5GZz04xZ6qPkGjR9SXVm7ief4hDgDa7b242Xxecuvfp/t6Lf7Lcu+KYkw707YpkUWpiCZOC8hIqsIpH8X8q9GW+zc2mDEB7rPlKMcV5yxl3FSJIwzNeqgxN5IRzpEOt+qnIH+KOnElCJsGkAZHqjJxGSURmks8Fc12CHukfp538vIj5DNuf0pQMl40qfZpyOWduAmjKla6yCgZO0DpTKDwlPeckej4+D+ix7pTuMnF/cBKqyWrJkXjgIUhA1+GpHEOIVKgzSST9Ac+r8YnoVF7ITv/si/tiikSMrFcgmEx6x9wW8xp8FYLpWlCizHvz2mHynzz/+dUosLdtu35Dv93T9jR8nQC6AGG/ZafkeY5Q6NlKCCCX0JusjczGnCvJIoQPxzn13/kZFnyUUVA+l0DqZ1SpJQYNvU0qcXSSVJnnaCfCYNrJNqCM3Ymu2N1f/D9mdzPWca6hRaFJeINRL0IMIyUjUrIKz9ATkkgUVKCej/cq+Kf4cfJmr4AvzlAVLpzY+xlqbNUO6seCWcFNmJjQryrD/Oi08wlyqMclt+08v/s0+WvT0vi0tt0t6tYcw7MG8lw/opRdFDCZwtB0vJVL1K4zVrJAFnmKsYbF7IjVqDJEcihU/CBOeTVOKbSeQdQ+EhqXISUMNlqb2Mk2iEoH5gne5W4uB9frGni1g0jV1UgVdOqMgdu+DWkBKdfc3RtEg0LTKXTdCRO78jxV8hH1N4hUX+9TieB/a+yR0pGk1qwm0l1DKGBRMgw0o6uMTmQ57FFzNU5tvf8DsQdDY5BSlnkME6j0hE9SYui1VkokhuDVDCK1VyNlYEUglVf6FKtjbufvsVONiy3aFno2muDd7tF9V8PS15tCXYd8Lzob7/fPv9rzfamygjC8LhhIXEbSpCjRNarCwJdFcF3JAcSKcmdqZxg8i9/LOO+g//J5d2s9emOyWzabzleFPk6fcWA+PHEiIB4t/RVwd4Nab7v+85eMoYNGd5eAQ2c406+H0e0GmzFvPPHw/vhDDw/IvdFziDMHGb9+GTT3VREMGRzTM8OGvt5NDVoanXBHQY176szF86C13gA1aO5klDm1MeuF6MyA+eRjTz6xA9uTQ0Ngn37hc674hkbJ0Qp8qOtvSPXZcV4fSc7hYx+n2tCWfak/aOP0du8PNKyvkTjK2UF7x3cgg4YeN5ghSxfFpufXC16BDaJ5XD1DaL7V+sA15pD50YvYQaND78GGrB6/57nU1HAzPXmhcSawjxrunxHdb6jzDtHoY38OeZ9/CTWIaDyRxnjidBi8EtAl/XVYPwwBOnctP2D/99//B2LqrUelIAAA

metadata_json:
  {"categories":["Marketing","Business Growth"],"complexity":"medium","use_cases":["lead generation by location","business data extraction","email harvesting","sheet automation"],"estimated_setup_minutes":15,"required_services":["Google Maps API","Google Sheets API","Email Scraping Service","Automation Scheduler"],"key_features":["scheduled execution","ZIP code filtering","category selection","duplicate removal"],"target_audience":["sales teams","business developers","marketing managers"]}


name: Automate Data Extraction with Zyte AI (Products, Jobs, Articles & More)
author_name: Zyte
author_username: zyte
categories: []
created_at: 2025-12-09T19:28:29.465Z
updated_at: 2025-12-09T19:28:29.465Z
url: https://n8n.io/workflows/11637
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:21
description:
  Automated AI Web Scraper

  This workflow uses the Zyte API to automatically detect and extract structured data from E-commerce sites, Articles, Job Boards, and Search Engine Results (SERP) - no custom CSS selectors required.

  It features a robust "Two-Phase Architecture" (Crawler + Scraper) that handles pagination loops, error retries, and data aggregation automatically, ensuring you get a clean CSV export even for large sites with thousands of pages.

  If you prefer to use your own parsing logic and just need raw data, it provides a "Manual Mode" for that capability as well.

  Supported Modes
  E-commerce / Product:** Extract prices, images, SKUs, and availability.
  Articles / News / Forums:** Extract headlines, body text, authors, and dates.
  Job Boards / Postings:** Extract salaries, locations, and descriptions.
  SERP (Search Engine Results)**: Extract search rankings, organic results, and snippets.
  General Scraping:** Get raw BrowserHtml, HTTP Response codes, Network API traffic, or Screenshots to parse yourself.

  How it works
  Input:** You enter a URL and choose a goal (e.g., "Scrape all pages") via a user-friendly form.
  Smart Routing:** A logic engine automatically configures the correct extraction model for the target website.
  Two-Phase Extraction:** (Active only for "Scrape all pages") Phase 1 maps out all available URLs (Crawling), and Phase 2 extracts the rich data (Scraping), filtering out errors before saving to CSV.

  Set up steps
  Get your API Key: You need a free Zyte API key to run the AI extraction. Get it here.
  Run: Open the Form view, paste your key, select your target website, and hit Submit.
  Export: The workflow will process the data and output a downloadable CSV file.

  Resources
  Zyte API Documentation
  Get Help (with API errors & extraction logic)

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.switch","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.form","n8n-nodes-base.form"]

workflow_json_compressed:
  [encoded data, 14832 characters]

metadata_json:
  {"categories":["Data Processing","AI/ML"],"complexity":"medium","use_cases":["extraction web product data","scrape job board listings","collect article content","gather SERP results","export structured CSV files"],"estimated_setup_minutes":15,"required_services":["Zyte API","CSV"],"key_features":["Two-Phase Crawler and Scraper","AI-driven structured data detection","Built-in pagination","Automatic error retry logic","No custom CSS required"],"target_audience":["web developers","data analysts","market researchers"]}


name: News collection & multi-platform publishing with GPT, DALL-E, & social media API
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-12-10T11:53:56.097Z
updated_at: 2025-12-10T11:53:56.097Z
url: https://n8n.io/workflows/11652
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who it's for
  This n8n workflow automatically generates AI-powered content about local news and publishes it across multiple social media platforms. The workflow runs on a schedule, fetches the latest news about a specific topic, creates relevant images with watermarks, and posts the content to various platforms including WordPress, Facebook, Telegram, LinkedIn, and Discord.

  Features
  Scheduled Content Generation**: Triggers every 4 hours to create fresh content
  AI-Powered News Collection**: Uses LangChain agent with OpenAI and SerpAPI to find the latest news about a specific topic (Sirajganj district)
  Image Generation**: Creates AI images based on the news content using OpenAI's image generation capabilities
  Watermarking**: Automatically adds branded watermarks to all generated images
  Multi-Platform Publishing**: Posts content and images to:
    WordPress (with featured images)
    Facebook
    Telegram
    LinkedIn (both profile and company pages)
    Discord
  Notification System**: Sends confirmation messages via WhatsApp (Rapiwa), Telegram, and Gmail after successful posting
  Content Validation**: Checks if news was found before proceeding with image generation and posting

  Requirements
  OpenAI API credentials** for content generation and image creation
  SerpAPI credentials** for news search
  WordPress API credentials** for posting articles and media
  Facebook Graph API credentials** for page posting
  Telegram Bot API credentials** for channel posting
  LinkedIn OAuth2 API credentials** for profile and company page posting
  Discord Bot API credentials** for channel posting
  Rapiwa API credentials** for WhatsApp notifications
  Gmail OAuth2 credentials** for email notifications

  Configure Credentials
  OpenAI API**: Set up credentials with access to GPT-4 and DALL-E models
  WordPress API**: Configure access to your WordPress site
  Social Media APIs**: Set up credentials for Facebook, Telegram, LinkedIn, and Discord
  Notification Services**: Configure Rapiwa for WhatsApp and Gmail for email

  Important Notes
  Topic Configuration**: The workflow is currently set to fetch news about "Sirajganj district", but this can be modified in the "Add tropic" node
  Image Watermarking**: All images are watermarked with "Sirajganj APP" and Playstore information
  Content Validation**: The workflow includes a check to ensure news content exists before proceeding with image generation
  Platform-Specific Formatting**: Each platform receives appropriately formatted content and image dimensions
  Notification System**: After successful posting to all platforms, confirmation messages are sent via multiple channels

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.editImage","n8n-nodes-base.wordpress","n8n-nodes-base.editImage","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.telegram","n8n-nodes-base.linkedIn","n8n-nodes-base.linkedIn","n8n-nodes-base.httpRequest","n8n-nodes-base.noOp","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.telegram","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.discord","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolSerpApi","n8n-nodes-base.set","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:
  H4sIAAAAAAAAE6VZyW4bSRL9FYJnpSb3xacR7JluHTwW2sb40DAGuURKNaZIDllquWHo3/sVJZslsYqLRgeBS2bUi8iIFy+S36dNmb6Zmuv031/z2+W32/b+dvn+3fRsekttnL75Pm3m6zbOM11263IKUZBRUjjrklXCWqWd9EoLqRwZq5M03sUkTHI6Rx59oMRlNEp7XSzstnS7nMWW3q6orD9Se7d8u8An1BIe0K7u6OFsOo+3hKdd3LWLWyydvL+btQ27wra6WN1OPi5yE2eT91SaOPm4pNzUJk/eLuYtzdsJDMe2Wcwn9017M7m47J4Zr9fTN79/geVFoe7l90e/k6xUiQLLQlmmtecs2lqZLmTIRqpRxulPPB/zDZW7GXUW/1x2n8z9nG1MshTXdL5+WvBp1Vxf0wrrlot104HBI5nwxp4pyQFjGVcw2dIKWL4/PJr7N95tVopz+XD2BLCSVMIpzkLhkulqIkskJbOuOuKqyBTyFuDn2LSj4O4fv+wjcl6fKa4B6J7SzWLxdXPIXoacExlGsXumkJ6l7DPTygeXcoQfZnrQB7H1wRrPTZEsZu9gRRSWTLHMuCLJRxOo6q0Pl3XUg6a+wB+CPCagshdQIZzgXApmK/7poInFQpHJlElVm7UtcgvmopTJZ2Tg6jauvo7iQh62l7fxmp7D8/wpuPsj9RMactCpohKznCMFA/AF6o4BleYSd5qC20LbpDlNPi9W5WpF6/XkarHec/hYtuyWPYeIjD9jOODjQTpJsbhgmKwJFWOkwSkgTXKJUXFftesn5D8QmcmP0JwWvJORyWh9rLEwr0JiWnrJvBCVFe80SCgGXusW2d1ytohlcrvhkHYxuV+OIrxp2+Vv9L87Wr+oH8E1Pwqk7iVgUElbkTLzlBUqulSWnLMoDm5ANyrJJHdgNl2AOpgdK09KbOMr0MojQ9pHS8WmSsYzJ6pnmkvOfI6GmZRDKjJmMr3aXVM7qUjLO3D7I+ZXwNSvCGriNXIfcexaGLB3USxkG8CVlXwlVLXvBfWfgJ3Ado+ZOVnuK5z6tPaXVVzeXCyb3fqxJ5S48dWJ5D0DiRbg1JwlQYVFl2OoKPGSyhbnJ5rRNeweg7N9WruLT8qXBC9r8VrjFLPHeWpNgqFTRxZktjyaCIzlMMFvo1+IFw0uZ95IeKXBDvDRMdK5JkiE7IXcIa7lalGbGT2l9l7fZs38K5XL+a5vmh/upts+ZJw0hhOzwiGXRUcQKTkGgLqGnLTkaRdmh+7/wmjsKRh5iKXqzMjUgARR6JVkJRNQXgK6SsV+KH/99Olq8lRF4vRSs9Ajp1aaTlpABVRGNgGgzF3a8O4t6D+5YF3p8f+7xWS+aG+a+fUouvniw/IFAwjIEneETvoJypLnQSP3is3onMppFlIEqORtcCS0Mb2o/RaXzf0gga4235yvfix4RkvyRFDc2pJEJuaUASfhDzIqgkmzdORNCaJP9B9pXiboRPStBcmv1/u4c7jWNwgfk61f7MF4lblVLBuhOw2nmZdJMYsEE6bW6pU7pdij1yJVHZmvAQngZWUxIhWicV5ElbLMtOPWIY+ub2MzG3DH+5fuKCFI+qAh2CrEaTZgHY38w0l7xyk5aPZD7sieOHUhJKeQxZGDh3UEKaRaIyvcVi411GXuTwBtk7/+OfnXot0zBGzWPC15ltZGnulgX2bQND8OLrA0Hc+mELIrwUJ3SRkZFAR0KwU0ksKhbAiEnnqNuNOCE4xA75p1hvKbvL2J8znNRjGXx3W75PWY8c8OIClno9SMc4IAxDsoGRmYCirqitSW/vABbPWFqsEjnRimxY015BUJ5JXSARarSqkf/rFZb+vY3+HZ37bezeL8Ot/EZn6O9Ju/nH+EEicPEIizMwIJqB3SBFwTmO+KwHKVyHnOi+ip9F9oTquuj1ytMOW2r8RpnD1mlOjDJNQjRp3MkrTo8QKvgkZ0LZIF7ZhjVhdbmB+WNL+47NKknbwHoNkRQGe33fLNzmYoruYI8d7XxTJrVT1G8ZhRiFBdUEXIBCl9CoQqResbiGucP3ZncQTixRBW6eRRY9q533KGssEYBQ4txnX6SUHPyS7UmJwdjyJztSe2x0DdE9wuGbQ/6RbBIJpZdSzpZDeBZ4Mqi+hHxfNqQXKkdZ+zV8uLq8sjULaLxWyz+qUuZkJYf1QGbJWPy6FkUVhWaUNwHBK+IAk0WnnBqxh60rgbzNvVYtnkcR6mnXK3YLQjyl2d623ohBZW+MqM2ugdh/kycVSUKy5KYSt66WB/GNdjYw0CYvaMKfXKBmGABrmnoIG6go8Q4ZFnjGsBg4XylpdnfXkLVJ0MFPVt+ZnkO6d7JFKjqXoIIxtdd+kmMX5olLsjHjBVBm3EcEj16Uhx4CLI1+GUTlVTuinB6y4jM1Qljyhznmogr8hFM4jTnI7TYugdUOLHAa01VcxtEJlOE4BGi6d1OVpE9tYml4wbBCpfcfTW4+j1Tg0dh1QEDOJVWihzI1BNBSENqlPrGBq5wwRc+CBSezpSGSQO/8RqwuqY2+YPPKjG2ZrOujuNFvPLZit9o3zX2f+wKrSChT9EZ+OPx/0beVQ1lL1KkEcJk6auUYLGuGcYPoMV0Jold0MmQMwpd6Y2hi9r9x8iuEP++/fNNfXOfe7m67NpMy/0bfqGP3z5gmdvlgztHVUeg2Z+cD4sxeY/Ha8/M3aE8Pqxbcfyj0vzIZBDND6Ir7dwyM4R+AbN9ubTIbMvJ8WXNs62APaNbwe3HdyxAdu7TB0Cu+9GczSm28vtIZMH7pjH/dp7wza+be+F1/i2I26UDm8eu+cZ33lwyBqM+vM7m6GoD12aD5p6WeJ7aWBAKA8a3R0FHjmhU3132P/02cnk8Hz/qCtbmGN8MfB7zHGOiIOejHLmQfwDxbenRvdd5w/6MlyIQ08YuRIctDqWwEN2h27yhjvJaDYMme3/2jdobjxiQ+b2/QAxYP7h4S/ufEQRAB8AAA==

metadata_json:
  {"categories":["AI/ML","Social Media Management","Content Creation"],"complexity":"medium","use_cases":["automate social media content creation","publish news to multiple platforms","generate AI images for content","schedule content automatically"],"estimated_setup_minutes":120,"required_services":["OpenAI","DALL-E","Newspaper Service","WordPress","Facebook Graph API","LinkedIn","Telegram","Discord","Image Hosting","RSS Feed Service"],"key_features":["multi-platform publishing","scheduled triggers","AI-generated content","custom image watermarking","cross-channel distribution"],"target_audience":["content managers","social media managers","marketing teams"]}


name: Generate and publish AI short videos using Gemini, Sora-2, Apify, and Google Sheets
author_name: giangxai
author_username: giangxai
categories: []
created_at: 2025-12-11T04:16:32.498Z
updated_at: 2025-12-11T04:16:32.498Z
url: https://n8n.io/workflows/11676
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  1. Overview

  This workflow automates the process of collecting viral content ideas, generating videos using AI services, and publishing posts to social media platforms.

  It uses scheduled triggers and external APIs to run the entire content pipeline with minimal manual input. Google Sheets is used as the central data layer to store ideas, track processing status, and prevent duplicate content.

  The workflow is designed to support continuous content production by connecting idea discovery, content generation, and publishing into a single automated system.

  2. What Can This Workflow Do?
  This workflow can be used for:
  Automatically collecting viral content ideas on a scheduled basis
  Generating videos from text-based ideas without manual recording or editing
  Publishing video content to social media platforms using a single workflow
  Managing content status and processing history through Google Sheets
  Running automated content pipelines for multiple niches or channels

  The workflow is suitable for users who want to reduce manual work while maintaining a structured and repeatable content production process.

  3. Required API Keys & Credentials

  The following credentials must be configured before running the workflow:

  Apify API Token: Used to scrape and collect viral content data
  Google OAuth2: Required for Google Sheets API access
  Gemini API Key: Used by the AI Agent for content analysis and generation
  Video Generation API Key: (Kie.ai, GeminiGen.ai, fal.ai...) Required to generate AI videos
  Blotato API Key: Used to automatically publish content to multiple social media platforms

  ⚠️ All API keys and credentials must be properly set up in n8n Credentials before executing the workflow.

  4. High-Level Architecture

  The system is divided into two main workflows:

  Get Content Viral: Collects and stores viral content ideas automatically

  Create Video and Auto Post
  Transforms ideas into AI-generated videos and publishes them automatically
  Google Sheets as the Central Database
  Google Sheets serves as the central data layer to:
  Act as the main content database
  Prevent duplicate content processing
  Track content status throughout the entire pipeline

  **5. Workflow 1 – Get Content Viral
  Purpose**

  This workflow is responsible for automatically discovering and collecting viral content ideas, then storing them in Google Sheets for further processing.

  It acts as the idea intake layer of the entire AI Content Factory.
  Workflow Steps

  Scheduled content execution
  The workflow is triggered automatically based on a predefined schedule (e.g. daily or multiple times per day). This allows the system to continuously collect fresh viral content ideas without manual intervention.

  Run Apify Actor & Get Dataset

  Executes an Apify Actor to scrape viral content data from selected sources
  Retrieves a dataset containing raw content ideas, links, and metadata
  This step is responsible for data collection and crawling.

  Normalize scraped content data

  Cleans and normalizes the scraped data
  Removes unnecessary fields
  Formats the content into a standardized structure suitable for storage
  This ensures consistency and data quality.

  Save to Google Sheets (Viral Content)

  Appends the processed content ideas into a dedicated Google Sheet
  Each row represents a single viral content idea

  Google Sheets serves as the central idea repository for downstream workflows.

  Output:
  After the workflow completes, you will have:
  A continuously updated list of viral content ideas
  Structured data ready for video generation
  A centralized idea database accessible by other workflows

  **6. Workflow 2 – Create Video and Auto Post
  Purpose**

  This workflow is responsible for transforming viral content ideas into AI-generated videos and automatically publishing them to social media platforms.

  It acts as the production and distribution layer of the AI Content Factory.

  Workflow Steps
  Scheduled video generation
  The workflow runs automatically based on a predefined schedule. This allows you to control how many videos are generated and published per day.

  Get Viral Content (Google Sheets)
  Retrieves a single unprocessed content idea from Google Sheets
  Ensures that each idea is used only once
  This step prevents duplicate content generation.

  Analyze Content
  Analyzes the selected content idea
  Extracts key context, topic, and intent
  This prepares structured input for the AI Agent.

  AI Agent (Gemini + Structured Output Parser)
  The AI Agent generates:
  Video title
  Video description
  Video generation prompt

  A structured output parser is used to ensure consistent and predictable results for downstream steps.

  Format AI output for video generation
  Cleans and formats the AI-generated output
  Prepares the final payload for the video generation API
  This step ensures compatibility with the video generation service.

  Create Video (Video Generation API)
  Sends the prepared prompt to the video generation API
  Starts the AI video rendering process
  The video is generated asynchronously.

  Wait → Get Video → Switch

  Wait: Pauses the workflow while the video is rendering
  Get Video: Checks the current rendering status
  Switch:
    If Processing: wait and retry
    If Completed: continue to publishing
    If Failed: handle errors or retry

  Create Post (Blotato)
  Publishes the generated video to selected social media platforms
  Uses:
    Title
    Description
    Generated video
  Blotato handles multi-platform posting automatically.

  Update Google Sheets
  Updates the corresponding row in Google Sheets with:
   Processing status
   Published post URL
   Timestamp
  This provides full visibility and tracking across the pipeline.

  Output
  After the workflow completes, you will have:
  An AI-generated video
  Automatically published content across social platforms
  Updated tracking data in Google Sheets

  8. Notes, Limitations & Best Practices

  Notes
  The overall content quality depends heavily on:
  The quality of scraped viral ideas
  The AI prompts used for analysis and video generation
  The capabilities of the selected video generation API

  This workflow is designed for automation, not manual fine-tuning.
  Google Sheets is used as a lightweight database and works best for small to medium-scale content pipelines.

  Limitations

  API rate limits and quotas may restrict:
  The number of videos generated per day
  The frequency of scraping and posting 

  Video generation APIs may:
  Fail occasionally due to rendering issues
  Produce inconsistent results depending on prompt complexity

  Social media platforms may impose:
  Posting limits
  Content moderation restrictions

  Best Practices

  Start with a low posting frequency and gradually scale up

  Regularly review and refine:
  AI prompts
  Video formats

  Use Google Sheets status fields to:
  Monitor failures
  Prevent duplicate processing


  Add error handling and retry logic for:
  Video generation
  Posting steps

  Periodically clean and optimize your Google Sheets data to maintain performance

  Watch the tutorial video on YouTube..

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.outputParserStructured","@blotato/n8n-nodes-blotato.blotato","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.googleGemini","@apify/n8n-nodes-apify.apify","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.wait","n8n-nodes-base.set","n8n-nodes-base.set","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.scheduleTrigger"]

workflow_json_compressed:
  [encoded data, 7552 characters]

metadata_json:
  {"categories":["AI/ML","Marketing","Content Creation"],"complexity":"medium","use_cases":["generate AI short videos","collect viral content ideas","automate social media posting","create daily video content"],"estimated_setup_minutes":210,"required_services":["Google Gemini","Apify","Sora-2","Google Sheets","Social Media APIs","blotato"],"key_features":["scheduled content generation","centralized data management","duplicate content prevention","structured data parsing"],"target_audience":["content creators","marketers","social media managers"]}


name: Publish RSS articles to WordPress and social media platforms
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-12-11T04:17:55.334Z
updated_at: 2025-12-11T04:17:55.334Z
url: https://n8n.io/workflows/11677
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who it's for
  This n8n workflow automatically fetches RSS articles, extracts featured images, and publishes them across multiple social media platforms. The workflow runs on a schedule, processes news articles from an RSS feed, extracts the main image from each article, and posts the content with images to various platforms including WordPress, Facebook, Telegram, LinkedIn, and Discord.

  Features
  Scheduled Publishing**: Auto-posts content on your set schedule
  RSS Integration**: Fetches latest articles from specified sources
  AI Image Extraction**: Identifies and extracts featured images
  Image Optimization**: Downloads and resizes for platform-ready display
  Multi-Platform Posting**: Supports WordPress, Facebook, Telegram, LinkedIn, Discord
  Notifications**: Confirms posts via WhatsApp, Telegram, Gmail, and Discord
  Content Validation**: Ensures valid images before posting

  How It Works
  The workflow triggers on a schedule to check for new RSS articles
  It reads the RSS feed from the configured news source
  Each article's link is processed by an AI agent to extract the featured image URL
  The image is downloaded and converted to binary data
  The content is published simultaneously to:
     WordPress as a blog post with the image set as featured
     Facebook as an image post
     Telegram channel as an image post
     LinkedIn (both personal profile and company page)
     Discord channel
  After successful publishing, notifications are sent to multiple channels

  Requirements
  OpenAI API credentials** for image extraction using the AI Agent
  WordPress API credentials** for posting articles and media
  Facebook Graph API credentials** for page posting
  Telegram Bot API credentials** for channel posting
  LinkedIn OAuth2 API credentials** for profile and company page posting
  Discord Bot API credentials** for channel posting
  Rapiwa API credentials** for WhatsApp notifications
  Gmail OAuth2 credentials** for email notifications

  Important Notes
  RSS Feed Configuration**: The workflow requires a valid RSS feed URL to function properly
  Image Processing**: All images are resized to 5000x5000 pixels for consistency
  Content Validation**: The workflow includes a check to ensure valid image URLs exist before proceeding with posting
  Platform-Specific Formatting**: Each platform receives appropriately formatted content and image dimensions
  Notification System**: After successful posting to all platforms, confirmation messages are sent via multiple channels

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.wordpress","n8n-nodes-base.editImage","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.discord","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.rssFeedRead","n8n-nodes-base.httpRequest","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.linkedIn","n8n-nodes-base.linkedIn","n8n-nodes-base.telegram","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.telegram","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.gmail","n8n-nodes-base.discord","n8n-nodes-base.if"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VZ224byRH9lQGfNoBa6ftFT1HsbKAgaxtWsAvEMILq7mppYGrIkCNrDUP/vtWULI7E4U1BbMCipJqa06dup9rfJ22enE345V+LXvT28uO/i3zf/mNyMrnBHiZn3ydtt+yhS3hR7VIMINAoKZx10SphrdJOeqWFVA6N1VEa7yAKE51OwMEHjFyCUdrrbMlvjzfzKfT4ZoF5eYn97fzNjH6CPdIL+sUt3p9MOrhBetuH2zhtl9fNx8vL5nzRt2mKy6afNb/NFvnDApfLBrrcXM5SC9PmF8wtNB/IdZktbpb1TXC1nJx9+kz+Zhnrx++Pp3VaO88lywYC01xrBhAM0wmNSIqHpNLkCQUBJbiDl36YLfvq/tu8/rrzHVv5ZxGWeHpHZvNqRhbz2bLt21lHbxZa8xOmrSY0c1iQ5x4XBOn7/YOjX+m7laW4P3lEKUyIwXLNpFSWaQ2GQaFPsqRcjNMxoluj/Ftu++biBq5wKzQiqP9hMYTmpT4SGsTgrY+BKSUL00poFkvWzCWnTeDORJnX0G7n0xnk5mYVIArf3XwrxOu+n3/E/97iiuEhSKv9CVOS7wOpT+UTTBdEgWIV4UoE03NgMWXHOJdRF5uMtpsw28pQhVkLoMlAVXA82hWlR6I1pjipuWAcgmIVHwvcS6YK0k8D8Rv5Gu0S+6ZQYt5SGT1gPh6m5JwfDZOKnQpeKGa0ikwbo1g0xjPunYqqaLTOr2GeXzTnV9gN6uUvhO7Pa4RT6K7SNbTdKTzaDQAaIU+YsPvgyWHMC2GwGplBCrzmubAQbWHecx7od8bggMW3s6ab9ddtd7WVvW72fv6CNmlspe3werEmR8lFZspqybRMgkWZOLMAiTqRFzAM7SV1ui/fmnezfntMlyubR5MRbBshnaRZ11eCzyaT7UATOG2DFUS69UyD5ywU5MxQD5LS8ZidGgUqjkYqVKDgWv1KpFGrHGsaJqOotnmxDBxwlp2lvhgDz9qukdaW3cy65m27TNSgmzfX0HU43Qo6P9iN9HDla5+8w3g9m31ZzUTKemdBamorSH2avmMeJfXGoEAX6VD62kJ2Z/DTuXhyPPFAlRVqF3DO1dkUmaGBFXWgTpDlaATk8RGgTPGvpF8GGXOCzKQwjmmMiYG0mYF1VnnvVclxFKZ6RUrr1+PUKFW2mIjJIus/nEHOQDVofeE6Jl/KKE59NM5VswobzeownMGpJJxHKt067LmJlER14tPgq39AbukQ5micwf0PcQfwpkRLrctJwXQGT6IkJcaR+0Jc5hIHI/X9HLvziwN6//SGKrJfmbcvWLX8RIT9vXYwAlKIKFPUzAeXaZD6wqIlAcB5EqgMiKz0KJfuaC6ZM3VCiQ18h7HpFWIqgMxpV6MuaOQj5akCn4CgOsvDGmme3XVrifJaDXWA0BuOe+r4HAXPNKsUBTxxzrxLinnIyvJUSCsPCv0855Van7bdl+1k4gtgVh8y5dWpfkKluLfK0mBSPmmaU5wGfDaWGWt8tEgVrwdpWBF9RCLu7ewGunYrsMVy+TNirqbPASp+EMJhEiJKiDSgWFCBeIuFZBLJAOrjIsScFe1EsEZY+aqaM7YdLL69IrT8MEnyTMhp4WluWVKZteVkXvUmABMycxJzIiQ7SL7LdI35dorNvxbt1RUutkf30XBtN6wXIf2xTNIIpK4DtK1lpBaO3hCTOjJKPNIq2kgeB4Lzx6T/JzH6BfPFu+bDYlba6fZ6qdyTYTcy7I/ZibSWLtPCwTJmTssGIaybEBPovKCEVEWIcZiY3zXzXRW9AyENx8MhOhCS+CMZKixtu7ZK99q8iV9bihZAfzchNj1O8YpesFc1/TAcW30feuRQN8mS/WqrTV4SYRoFg5p/QSbLwUBxIu/TTcM8KSGABOrz0TlShJYbCkDxJDExGp015cmIIvwZEkaCtDsC5dHq7wuYX5/P27ETSnfERhC0BYQSGDeJ9BPBY0B7NEPvXS7BRp6GMg+73ECdUW1pE6xee1wQZJ2jjxCHQQjGq8RtldG0xGtSt8zLqJg1JQhTSqFt75ggKFQhggmkwxWpLEMaFmygICRZqE49lGeNGebtHTQ/LWlSNnekAJYwnz875p/GzrlYPXb68GXsnCMDeXsoqNsF9LQ6WOrXlDdOMB85gacM5BxImEHZGYrtu8/VDbTTEYB2Y4cQgtaEoJmMVaYmg8zTTsOit57mb3RY9u8Qp4O7I+5BW0QWTKjyXBua2rTMkQAOwVinyjMJVOk/ML1GN6PVoR5a0f9vM8LIbfGSxBIvJOsipZY3Cpmgtc8bcBw8rs90UZqfaBKlLystMppGq/O05flRfN2KDrtyIBtIffuVvBaYLvGkXsr0bXe1EoD4O6bb6vT9ItMYPJt8FVUJfn3w8FB8ghJMFFFVDOUbDVwGCTQLuuQk0boItfhISnaYqquV40dRTZ+g/U+V0LfUuX6hE00J/qfvq8vO0ZuXDfOTSdtl/H1yxu8/fyZsT4+Qb8rc7pm/rYSuLF+6GlysjDk7qvBfvuDkyc3OvnjUY+LA57bXySgNg1vZMRp23YyO+numr0eJ3SZ1R9292CjGHI7dK4/6eiFhx3ztuUnfTvyeYb3/wR0aZv/DO6TkYQ9vCrztz43dSO5/y9Z7rdFQvSzlsVht20g2HJ58Wvl8mXhjPjdb0ii8jVVj1Nfopjnqb6TKdhTjrvv/UffjWT32hm0L/C7UI3DGXO/674AR9/f3fwDtCXy7+RsAAA==

metadata_json:
  {"categories":["Social Media Marketing","Content Management"],"complexity":"medium","use_cases":["Automated content publishing","Social media management","RSS feed processing"],"estimated_setup_minutes":30,"required_services":["WordPress","Facebook","Telegram","LinkedIn","Discord"],"key_features":["Scheduled publishing","Multi-platform distribution","Image extraction","RSS feed integration"],"target_audience":["Content Marketers","Social Media Managers","Bloggers"]}


name: Generate UGC product video ads from a reference image with OpenAI and Kie.ai
author_name: Jannik Hiller
author_username: jannik-mtm
categories: []
created_at: 2025-12-11T12:32:05.730Z
updated_at: 2025-12-11T12:32:05.730Z
url: https://n8n.io/workflows/11701
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  How it works

  Analyzes a reference product image using AI vision to extract brand elements, colors, and design

  Generates UGC-style prompts for image and video creation based on your specifications

  Calls external APIs to generate product images and videos at scale

  Polls for completion and retrieves the generated media files

  Uploads all videos to Box and Google Drive, then logs results to Google Sheets

  Set up steps

  Connect OpenAI credentials for image analysis

  Configure your image generation API credentials

  Configure your video generation API credentials

  Connect Google Drive and Box for file uploads

  Connect Google Sheets for tracking and logging

  Keep detailed descriptions of your UGC style preferences in the sticky notes inside your workflow

nodes_used:
  ["n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.box","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@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.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.splitOut","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.splitOut","n8n-nodes-base.httpRequest","n8n-nodes-base.aggregate","n8n-nodes-base.googleSheets","n8n-nodes-base.switch","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  [encoded data, 11804 characters]

metadata_json:
  {"categories":["Marketing","Advertising","AI/ML"],"complexity":"medium","use_cases":["generate UGC video ads","create product visuals","scale content production","automate media upload"],"estimated_setup_minutes":45,"required_services":["OpenAI","Kie.ai","Box","Google Drive","Google Sheets"],"key_features":["AI vision analysis","prompt generation","media API integration","workflow polling","cloud storage sync"],"target_audience":["marketing managers","content creators","social media managers"]}


name: Generate Ideal Customer Profiles & Find Lookalike Companies in Germany
author_name: as311
author_username: implisense
categories: []
created_at: 2025-12-11T15:07:10.467Z
updated_at: 2025-12-11T15:07:10.467Z
url: https://n8n.io/workflows/11709
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:21
description:
  This workflow generates a data driven  Ideal Customer Profile (ICP) and retrieves lookalike companies in Germany from the official data source (Handelsregister). It starts by ingesting a set of base company IDs, serializes them, and sends a recommendation request to the Implisense API to fetch similar companies. When explanation mode is enabled, the workflow extracts and processes term features to create a structured keyword digest and uses an LLM to generate an ICP narrative. The pipeline outputs both a clean list of lookalike companies, enriched with CRM-ready fields, and a detailed ICP report derived from Implisense feature statistics.

  How it works
  Input → Serialization → Lookalikes → Lists/Report

  Setup steps

  1. Data Source
  ☐ Replace "Mock ICP Companies" with matched companies from the Implisense database
  ☐ Ensure output has: id

  2. Configure Credentials: Set up RapidAPI API credentials
     Get your API key here: https://implisense.com/de/contact
     Insert your API Token in get_lookalikes (Basic auth)

  3. Configure ICP Filters
  ☐ Edit "Build Recommendation Request" node
  ☐ Set locationsFilter (e.g., de-be, de-by, de-nw)
  ☐ Set industriesFilter (NACE codes, e.g., J62 for IT)
  ☐ Set sizesFilter (MICRO, SMALL, MEDIUM, LARGE)

  4. Tune Results
  ☐ Adjust THRESHOLD in "Filter & Normalize Results" (default: 0.5)
  ☐ Adjust MIN_BASE_COMPANIES in "Collect Base Companies" (default: 3)
  ☐ Adjust size parameter in "Configuration" URL (default: 100)

  5. CRM Integration
  ☐ Map fields in "list_of_companies" to match your CRM schema
  ☐ Add CRM upsert node after "list_of_companies"
  ☐ Use implisense-ID or domain as unique identifier

  Additional advice

  Strengthen Base Company Quality
  Use only highly representative base companies located in Germany that strongly match the intended ICP segment. Templates with dozens of mixed or heterogeneous IDs dilute the statistical signal in the /recommend endpoint and reduce relevance.

  Refine Filters Aggressively
  Limit recommendations by state, region, NACE code, or size class. Implisense returns cleaner results when the recommendation space is constrained. Removing unnecessary geography broadens noise.

  Increase the Size Parameter
  Raise the size parameter when building the request to give the ranking model more candidates. This materially improves downstream sorting and selection.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.merge","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.function","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.switch","n8n-nodes-base.splitOut","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.function","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.code"]

workflow_json_compressed:
  [encoded data, 7556 characters]

metadata_json:
  {"categories":["Marketing","Data Processing"],"complexity":"medium","use_cases":["generate ideal customer profile","find lookalike companies","extract term features","create customer narrative"],"estimated_setup_minutes":15,"required_services":["Implisense API"],"key_features":["ICP generation","Lookalike company matching","LLM narrative creation","Feature extraction"],"target_audience":["marketers","sdr teams","sales operations"]}


name: Extend and merge UGC viral videos using Kling 2.1, then publish on social media
author_name: Davide Boizza
author_username: n3witalia
categories: []
created_at: 2025-12-11T15:07:38.030Z
updated_at: 2025-12-11T15:07:38.030Z
url: https://n8n.io/workflows/11710
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:20
description:
  This workflow automates the full pipeline for extending short Viral UGC-style videos using AI, merging them, and finally publishing the output to cloud storage or social media platforms (TikTok, Instagram, Facebook, Linkedin, X, and YouTube). It integrates multiple external APIs (Fal.ai, Runpod/Kling 2.1, Postiz, Upload-Post, Google Sheets, Google Drive) to create a smooth end-to-end video-generation system.

  Key Advantages

  1. ✅ Full End-to-End Automation

  The workflow covers the entire process:

  Read inputs
  Generate extended clips
  Merge them
  Save outputs
  Publish on social platforms

  No manual intervention required after starting the workflow.

  2. ✅ AI-Powered Video Extension (Kling 2.1 or other models like Veo 3.1 or Sora 2)

  The system uses Kling 2.1 (Kling 2.1 or other models like Veo 3.1 or Sora 2) to extend short videos realistically, enabling:

  Longer UGC clips
  Consistent cinematic style
  Smooth transitions based on extracted frames

  Ideal for viral social media content.

  3. ✅ Smart Integration with Google Sheets

  The spreadsheet becomes a control panel:

  Add new videos to extend
  Control merging
  Automatically store URLs and results

  This makes the system user-friendly even for non-technical operators.

  4. ✅ Robust Asynchronous Job Handling

  Every external API includes:

  Status checks
  Waiting loops
  Error prevention steps

  This ensures reliability when working with long-running AI processes.

  5. ✅ Automatic Merging and Publishing

  Once videos are generated, the workflow:

  Merges them in the correct order
  Uploads them to Google Drive
  Posts them automatically to selected social platforms

  This drastically reduces time required for content production and distribution.

  6. ✅ Highly Scalable and Customizable

  Because it is built in n8n:

  You can add more APIs
  You can add editing steps
  You can connect custom triggers (e.g., Airtable, webhooks, Shopify, etc.)
  You can fully automate your video-production pipeline

  How It Works
  This workflow automates the process of extending and merging videos using AI-generated content, then publishing the final result to social media platforms. The process consists of five main stages:

  Data Input & Frame Extraction**  
    The workflow starts by reading video and prompt data from a Google Sheet. It extracts the last frame from the input video using Fal.ai’s FFmpeg API.

  AI Video Generation**  
    The extracted frame is sent to RunPod’s Kling 2.1 AI model to generate a new video clip based on the provided prompt and desired duration.

  Video Merging**  
    Once the AI-generated clip is ready, it is merged with the original video using Fal.ai’s FFmpeg merge functionality to create a seamless extended video.

  Storage & Publishing**  
    The final merged video is uploaded to Google Drive and simultaneously distributed to social media platforms via:
    YouTube (via Upload-Post)
    TikTok, Instagram, Facebook, X, and YouTube (via Postiz)

  Progress Tracking**  
    Throughout the process, the Google Sheet is updated with the status, video URLs, and completion markers to keep track of each step.

  Set Up Steps
  To configure this workflow, follow these steps:

  Prepare the Google Sheet  
     Use the provided template or clone this sheet.
     Fill in the START (video URL), PROMPT (AI prompt), and DURATION (in seconds) columns.

  Configure Fal.ai API for Frame Extraction & Merging  
     Create an account at fal.ai.
     Obtain your API key.
     In the nodes “Extract last frame”, “Merge Videos”, and related status nodes, set up HTTP Header Authentication with:
       Name: Authorization
       Value: Key YOUR_API_KEY

  Set Up RunPod API for AI Video Generation  
     Sign up at RunPod and get your API key.
     In the “Generate clip” node, configure HTTP Bearer Authentication with:
       Value: Bearer YOUR_RUNPOD_API_KEY

  Configure Social Media Publishing  
     For YouTube:  
       Create a free account at Upload-Post and set your YOUR_USERNAME and TITLE in the “Upload to Youtube” node.
     For Multi-Platform Posting:  
       Sign up at Postiz and configure your Channel_ID and TITLE in the “Upload to Social” node.

  Connect Google Services  
     Set up Google Sheets and Google Drive OAuth2 credentials in their respective nodes to allow reading from and writing to the sheet and uploading videos to Drive.

  Execute the Workflow  
     Once all credentials are set, trigger the workflow manually via the “When clicking ‘Execute workflow’” node.
     The process will run autonomously, updating the sheet and publishing the final video upon completion.
     👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n.

  Need help customizing?  
  Contact me for consulting and support or add me on Linkedin. 

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-postiz.postiz","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.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8116 characters]

metadata_json:
  {"categories":["Marketing"],"complexity":"medium","use_cases":["viral video extension","social media publishing automation","UGC video processing","cross-platform deployment"],"estimated_setup_minutes":30,"required_services":["Fal.ai","Runpod","Kling-2.1","Postiz","Google Sheets","Google Drive","TikTok","Instagram","Facebook","LinkedIn","X","YouTube"],"key_features":["end-to-end video automation","AI-driven content merging","multi-platform distribution","cloud storage integration"],"target_audience":["social media managers","content creators","digital marketers"]}


name: Sync tasks between Todoist and Notion with Redis-powered 2-way logic
author_name: Yuvraj Singh
author_username: yuvrajsingh
categories: []
created_at: 2025-12-11T17:07:04.940Z
updated_at: 2025-12-11T17:07:04.940Z
url: https://n8n.io/workflows/11715
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Purpose

  This solution enables you to manage all your Notion and Todoist tasks from different workspaces as well as your calendar events in a single place. This is 2 way sync with partial support for recurring 

  How it works

  The realtime sync consists of two workflows, both triggered by a registered webhook from either Notion or Todoist.
  To avoid overwrites by lately arriving webhook calls, every time the current task is retrieved from both sides.
  Redis is used to prevent from endless loops, since an update in one system triggers another webhook call again. Using the ID of the task, the trigger is being locked down for 80 seconds.
  Depending on the detected changes, the other side is updated accordingly .Generally Notion is treaded as the main source. Using an "Obsolete" Status, it is guaranteed, that tasks never get deleted entirely by accident.
  The Todoist ID is stored in the Notion task, so they stay linked together
  An additional full sync workflow daily fixes inconsistencies, if any of them occurred, since webhooks cannot be trusted entirely.
  Since Todoist requires a more complex setup, a tiny workflow helps with activating the webhook.
  Another tiny workflow helps generating a global config, which is used by all workflows for mapping purposes.

  Mapping (Notion &gt;&gt; Todoist)

  Name: Task Name
  Priority: Priority (1: do first, 2: urgent, 3: important, 4: unset)
  Due: Date
  Status: Section (Done: completed, Obsolete: deleted)
  &lt;page_link&gt;: Description (read-only)
  Todoist ID: &lt;task_id&gt;

  Current limitations

  Changes on the same task cannot be made simultaneously in both systems within a 15-20 second time frame.
  Subtasks are not linked automatically to their parent yet.
  Tasks names do not support URL’s yet.

  Credentials

  Follow the video: 

  Setup credentials for Notion (access token), Todoist (access token) and Redis.

  Todoist

  Follow this video to get Todoist to obtain API Token.
      
      Todoist Credentials.mp4
  Notion

  Follow this video to get Notion Integration Secret.

  Redis

  Follow this video to get Redis

  Setup

  The setup involves quite a lot of steps, yet many of them can be automated for business internal purposes.

  Just follow the video or do the following steps:

  Setup credentials for Notion (access token), Todoist (access token) and Redis - you can also create empty credentials and populate these later during further setup
  Clone this workflow by clicking the "Use workflow" button and then choosing your n8n instance - otherwise you need to map the credentials of many nodes.
  Follow the instructions described within the bundle of sticky notes on the top left of the workflow

  How to use

  You can apply changes (create, update, delete) to tasks both in Notion and Todoist which then get synced over within a couple of seconds (this is handled by the differential realtime sync)
  The daily running full sync, resolves possible discrepancies in Todoist.

  This workflow incorporates ideas and techniques inspired by Mario (https://n8n.io/creators/octionic/) whose expertise with specific nodes helped shape parts of this automation. Significant enhancements and customizations have been made to deliver a unique and improved solution.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.webhook","n8n-nodes-base.notion","n8n-nodes-base.notion","n8n-nodes-base.filter","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.filter","n8n-nodes-base.redis","n8n-nodes-base.notion","n8n-nodes-base.filter","n8n-nodes-base.switch","n8n-nodes-base.executionData","n8n-nodes-base.executionData","n8n-nodes-base.executionData","n8n-nodes-base.executionData","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","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.stopAndError","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.notion","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.noOp","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.executionData","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.notion","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.noOp","n8n-nodes-base.httpRequest","n8n-nodes-base.noOp","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.notion","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.todoist","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.notion","n8n-nodes-base.if","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.notion","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.respondToWebhook","n8n-nodes-base.respondToWebhook","n8n-nodes-base.webhook","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.notion","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.form","n8n-nodes-base.form","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.formTrigger","n8n-nodes-base.form","n8n-nodes-base.crypto","n8n-nodes-base.code","n8n-nodes-base.form","n8n-nodes-base.formTrigger","n8n-nodes-base.form","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 20844 characters]

metadata_json:
  {"categories":["Productivity","Data Processing"],"complexity":"complex","use_cases":["Manage tasks across platforms","Synchronize calendars","Handle recurring events"],"estimated_setup_minutes":15,"required_services":["Todoist","Notion","Redis"],"key_features":["Two-way task synchronization","Webhook-based triggers","Loop prevention with Redis","Handles partial recurring events"],"target_audience":["Product managers","administrators"]}


name: Generate News Digest Videos from WordPress to YouTube with Shotstack
author_name: Alexandru Burca
author_username: alex13
categories: []
created_at: 2025-12-11T21:38:02.291Z
updated_at: 2025-12-11T21:38:02.291Z
url: https://n8n.io/workflows/11724
scraped_at: 2026-05-02 08:04:48
metadata_generated_at: 2026-05-02 08:36:21
description:
  Daily News Digest Video Generator for YouTube Shorts

  Instalations Instructions

  Youtube Instalation Instructions

  Overview

  This workflow automatically creates and publishes daily news digest videos from WordPress articles to YouTube. It runs every evening at 7 PM, compiling the day's top stories from a news portal into a professionally formatted vertical video (1080x1920px) optimized for social media platforms like YouTube Shorts.

  What It Does

  1. 🕐 Scheduled Trigger
  Runs automatically every day at 19:00 (7 PM)

  2. 📰 Fetches Today's Articles
  Retrieves all published WordPress posts from the current day

  3. ✅ Validates Content
  Ensures there are at least 3 articles before proceeding

  4. 🎬 Video Detection
  Scans article content HTML for embedded videos
  Extracts MP4 URLs from WordPress video players
  Parses wp-playlist-script JSON data
  Falls back to ` and &lt;source&gt;` tag detection

  5. 🧹 Data Processing
  Extracts** article titles, links, and featured media IDs
  Decodes HTML entities**: Converts &#8211; to –, &quot; to ", etc.
  Fetches featured images** from WordPress Media API
  Assigns default images** for articles without featured media
  Calculates reading time** per article (3-7 seconds based on word count)
  Cleans text**: Removes HTML tags and normalizes whitespace

  6. 🎥 Video Generation (via Shotstack API)

  Intro Slide (3 seconds)
  Black background
  Large logo (centered)
  Title on center
  Current date in DD-MM-YYYY format

  News Slides (3-7 seconds each)
  Each article is displayed with:
  Background**: Video (if available) or featured image, cropped to fit
  Dark overlay**: 40% opacity black layer for text readability
  Article headline**: Large white text at top
  Small logo**: Top-right corner
  Pagination counter**: Bottom-right white badge (e.g., "1 / 22")
  CTA button**: Centered CTA
  Background music**: Subtle looped audio track
  Transitions**: Smooth fade in/out between slides

  Outro Slide (3 seconds)
  Identical to intro slide
  Provides clean ending to the video

  7. ⏳ Processing Wait
  Waits 30 seconds for Shotstack to render the video
  Polls Shotstack API to verify video completion

  8. 📥 Download Video
  Retrieves the finished MP4 file from Shotstack
  Downloads video data for YouTube upload

  9. 📤 YouTube Upload
  Automatically uploads to YouTube with:
  Title**: "Daily Digest - [Day] [Weekday], [Year]"
  Description**: Same as title
  Category**: News & Politics
  Made for kids**: Yes
  Tags**: dailydigest

  ✨ Key Features

  Intelligent Content Handling
  ✅ Automatic video/image detection and intelligent media selection
  ✅ Dynamic reading time calculation for optimal viewer engagement
  ✅ HTML entity cleaning for proper text display (WordPress compatibility)
  ✅ Fallback default images for articles without media
  ✅ Video background support with automatic muting

  Professional Video Production
  ✅ Vertical format optimized for mobile viewing (1080x1920px)
  ✅ Professional branding with logos and consistent styling
  ✅ Smooth fade transitions between slides
  ✅ Background music with looping support
  ✅ Dynamic pagination counters
  ✅ Call-to-action buttons for engagement

  Customization
  ✅ Centralized variables for easy branding updates
  ✅ Configurable logos, colors, and text
  ✅ Adjustable reading time calculation
  ✅ Flexible date formatting
  ✅ Customizable audio track

  🎯 Use Cases

  Perfect for:
  📰 News websites wanting to repurpose daily articles
  📱 Media outlets creating social media content
  🎥 Content creators automating video production
  🔄 Publishers maximizing content distribution
  📊 Marketing teams driving traffic from social platforms

  🔧 Customization Options

  Easy Changes
  Update logos by changing logo_big and logo_small URLs
  Modify branding colors via button_bg_color variable
  Adjust button text with button_text variable
  Change video title with daily_digest_text variable
  Update background music by replacing audio URL

  Advanced Customization
  Adjust reading time formula in calculateReadingTime() function
  Modify date format in getRomanianDate() function
  Change video dimensions (currently 1080x1920)
  Update font family and sizes
  Adjust overlay opacity and colors
  Modify transition effects

  📋 Prerequisites

  Required Credentials
  WordPress API - Access your WordPress site
  Shotstack API - API key for video rendering (Stage environment)
  YouTube OAuth2 - Authenticated YouTube account for uploads

nodes_used:
  ["n8n-nodes-base.wordpress","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.youTube","n8n-nodes-base.set","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.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8924 characters]

metadata_json:
  {"categories":["AI/ML","Data Processing","Marketing","Content Creation"],"complexity":"medium","use_cases":["automate YouTube Shorts creation","compile daily news into video","schedule social media content","generate vertical video digests"],"estimated_setup_minutes":60,"required_services":["WordPress","YouTube","Shotstack","News Portal API"],"key_features":["scheduled automated execution","cross-platform integration","dynamic content aggregation","professional vertical video generation"],"target_audience":["content creators","digital marketers","social media managers"]}


name: Chat with Google Drive documents using OpenAI and Pinecone RAG search
author_name: Pinecone
author_username: pinecone
categories: []
created_at: 2025-12-16T17:43:56.592Z
updated_at: 2025-12-16T17:43:56.592Z
url: https://n8n.io/workflows/11870
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Try it out

  This n8n workflow template lets you chat with your Google Drive documents (.docx, .json, .md, .txt, .pdf) using OpenAI and Pinecone vector database. It retrieves relevant context from your files in real time so you can get accurate, context-aware answers about your proprietary data—without the need to train your own LLM.
  Not interested in chunking and embedding your own data or figuring out which search method to use?

  Try our n8n quickstart for Pinecone Assistant here or check out the full workflow to chat with your Google Drive documents here.

  Prerequisites

  A Pinecone account
  A GCP project with Google Drive API enabled and configured
  An Open AI account and API key
  A Cohere account and API key

  Setup

  Create a Pinecone index in the Pinecone Console here 
  	Name your index n8n-dense-index
  	Select OpenAI's text-embedding-3-small
  	Set the Dimension to 1536
  	Leave everything else as default
  	If you use a different index name, update the related nodes to reflect this change
  Use the Connect to Pinecone button to authenticate to Pinecone or if you self-host n8n, create a Pinecone credential and add your Pinecone API key directly
  Setup your Google Drive OAuth2 API, Open AI, and Cohere credentials in n8n
  Download these files and add them to a Drive folder named n8n-pinecone-demo in the root of your My Drive
  	https://docs.pinecone.io/release-notes/2022.md
  	https://docs.pinecone.io/release-notes/2023.md
  	https://docs.pinecone.io/release-notes/2024.md
  	https://docs.pinecone.io/release-notes/2025.md
  	https://docs.pinecone.io/release-notes/2026.md
  Activate the workflow or test it with a manual execution to ingest the documents
  Enter the chat prompts to chat with the Pinecone release notes
  	What support does Pinecone have for MCP?
  	When was fetch by metadata released?

  Ideas for customizing this workflow

  Use your own data and adjust the chunking strategy
  Update the AI Agent System Message to reflect how the Pinecone Vector Store Tool will be used. Be sure to include info on what data can be retrieved using that tool.
  Update the Pinecone Vector Store Tool Description to reflect what data you are storing in the Pinecone index
  Need help?

  You can find help by asking in the Pinecone Discord community or filing an issue on this repo.

nodes_used:
  ["@n8n/n8n-nodes-langchain.vectorStorePinecone","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.vectorStorePinecone","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.rerankerCohere","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDriveTrigger","n8n-nodes-base.googleDrive"]

workflow_json_compressed:
  [encoded data, 5388 characters]

metadata_json:
  {"categories":["AI/ML"],"complexity":"simple","use_cases":["chat with documents","retrieve file context","generate answers from data","query knowledge base"],"estimated_setup_minutes":5,"required_services":["Google Drive","OpenAI","Pinecone","Cohere"],"key_features":["RAG search","file type support","context retrieval","no data training needed"],"target_audience":["knowledge workers","developers"]}


name: Smart human takeover & auto pause AI-powered Facebook Messenger chatbot
author_name: Nguyễn Thiệu Toàn (Jay Nguyen)
author_username: nguyenthieutoan
categories: []
created_at: 2025-12-18T10:58:16.772Z
updated_at: 2025-12-18T10:58:16.772Z
url: https://n8n.io/workflows/11920
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  🤖 Facebook Messenger Chatbot - Smart Human Takeover, Auto Pause & Context-Aware
  Adaptable to n8n 1.113+ and 2.x
  by Nguyen Thieu Toan (Jay Nguyen)

  📖 Overview

  An intelligent Facebook Messenger chatbot that automatically detects human agent intervention and pauses AI responses accordingly. Features smart pause management, full context preservation, and seamless handoff between AI and human support.

  Perfect for:
  💼 Customer support with AI + human escalation
  🎯 Sales conversations requiring manual intervention
  🛠️ Technical support needing human expertise
  🤝 Any chatbot requiring human oversight capability

  Requirements: n8n v1.113.0+, Facebook App with Messenger, Google Gemini API key (or compatible LLM)

  🔗 Complementary Workflow  
  Smart Facebook Messenger Chatbot – Message Batching & History

  Enhances Messenger automation with intelligent batching, conversation tracking, and context-aware responses.  
  Messages are grouped, stored, and processed with full history for smoother interactions.

  Why combine?  
  🧩 Smart Batch (v3): Efficient multi-message handling, reduced spam  
  📜 Conversation History: Maintains context across sessions  
  🤖 AI Responses: Natural, context-aware replies  
  ⚡ Scalability: Sequential processing for reliable delivery  

  👉 Access workflow
  Smart Facebook Messenger Chatbot – Message Batching & History

  ⚡ Key Features

  Core Capabilities

  | Feature | Description |
  |---------|-------------|
  | 🔍 Human Takeover Detection | Automatically detects when admin/human sends messages from page via metadata checking |
  | ⏸️ Smart Auto-Pause | Bot pauses for configurable duration (default 60s) when human joins conversation |
  | 📝 Context Preservation | Saves both AI and human responses in conversation history for seamless continuity |
  | 📋 Whitelist Management | Tracks paused users with timestamp-based auto-resume (no manual intervention needed) |
  | 🔄 Seamless Handoff | Smooth transition between AI and human, then automatic resume after timeout |
  | 🏢 Multi-Page Support | Single workflow handles multiple Facebook Pages via page_id differentiation |
  | 📊 Full History Context | AI sees both previous AI and human responses when resuming |

  Technical Highlights

  ✅ Metadata-based detection (message.metadata == "bot_rep")
  ✅ Timestamp-based pause management (auto-expires)
  ✅ Upsert operation for whitelist (updates if exists, inserts if new)
  ✅ Composite key indexing (user_id + page_id)
  ✅ Zero manual cleanup required
  ✅ Full conversation context preserved across handoffs

  🏗️ How It Works

  ┌──────────────────────────────────────────────────────────┐
  │ 1. Message Intake                                        │
  │ • The system receives incoming messages from different   │
  │   sources and identifies their type.                     │
  └──────────────────────────────────────────────────────────┘
                           ↓
  ┌──────────────────────────────────────────────────────────┐
  │ 2. Human Interaction Recognition                         │
  │ • Detects when a human is involved and records the event │
  │ • Adjusts automated handling accordingly.                │
  └──────────────────────────────────────────────────────────┘
                           ↓
  ┌──────────────────────────────────────────────────────────┐
  │ 3. Pause & Resume Control                                │
  │ • Temporarily pauses automation when needed              │
  │ • Resumes once conditions are met.                       │
  └──────────────────────────────────────────────────────────┘
                           ↓
  ┌──────────────────────────────────────────────────────────┐
  │ 4. Automated Response                                    │
  │ • Processes messages with context                        │
  │ • Generates and delivers appropriate replies.            │
  └──────────────────────────────────────────────────────────┘

  🛠️ Setup Guide

  Step 1: Facebook App Setup

  Step 2: Data Storage Preparation

  Step 3: Workflow Configuration

  Step 4: Testing

  👤 About the Author

  Nguyen Thieu Toan (Nguyễn Thiệu Toàn / Jay Nguyen)

  AI Automation Specialist | n8n Workflow Expert | Business Optimization Consultant

  Services: AI Automation Solutions, n8n Workflow Development, Custom Chatbot Implementation, Team Training Programs

  Contact:
  🌐 nguyenthieutoan.com
  📘 Facebook
  💼 LinkedIn
  🐦 X (Twitter)
  📺 YouTube
  📧 me@nguyenthieutoan.com

  GenStaff Company: genstaff.net | contact@genstaff.net

  📄 License

  After purchase, use in commercial/personal projects. No redistribution or resale. Keep author attribution when sharing.


  Last Updated: December 18, 2025 | Version: 1.0 | n8n Compatibility: v1.123.18+ and v2.4.8+ | Facebook API: v23.0/v24.0

  Ready to enable intelligent human-AI collaboration in your Facebook Messenger? Import this workflow and transform your chatbot today! 🚀

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.set","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.wait","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.respondToWebhook","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.dataTable","n8n-nodes-base.httpRequest","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.if","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.dataTable","n8n-nodes-base.if","n8n-nodes-base.code"]

workflow_json_compressed:
  H4sIAAAAAAAAE7Vay3IbxxX9lSms2Uq/H9oktmQ5rLIilx7xwqVy9ZOcMjGggaElloqrfEE+IZVFKpWFK1trmfyI/iRnQJoYAjN4kMoGIoSZxunb95x77h18mExz6yePP0zqZtH6JubjNHk8MUJZqx2VvnBGtRRFCiuc9ErYjLdGFhqD9IGJkpxMzlCqnDXS8qQV95Oro0kzS3kxefw9lu6WtFwwb6MjIZpCpPKS+BIyoV7LYkOk1KsJ7vLTjKuf+ZjDbPZj9V0Op/gXn7SX590njW3IcmkS/CI/enf7+flsUbf1rMFXMk2POGP87dHk5vPlrgLjURWRiTfJEGwhk5CYJSZIWgw+okl0C/k5QLR5DvQfrq6/+M94t1ybP2JXRzdb4koIFm0hoShsKcdMrOGGWEGT4s4k6vlqS69yWz2ZNW1+347uZpHbuzvRXGIn3L7dAUs8krewvDAu+BKJ9T4R6SRgZYMXHVNKWcWkUi/Ss/nUt1WZzavboL+4aM8vxlFG/HkXpqQUEVfLiG8P3yp4BemlSyGWFovDQNyQUJKIhA9KYcw7t0L59Wx2cparr/O0burqySkQPweKsxXGPwDk71ZAz3xzEk993Tw6m3aXXy9wff9d7EIJfcSN2ol9dfDOOZG9ZEQm5JBUOhInvCExJF68S9570cOOg2eqavK7vGir+ezd4oDICioRWcR3Z2SPJv7snb9cXB/eU9/Rup1f5FvUwhfqUwlEei6JjFEQR30kKjmaslBOOr9C/TSf+cvqy9y+y7mpnufFwp/kceTvfN0lTDNrO9Lf3M0onS6qk/rTx198Ff/zt1i1dVM1p59+/aWp/vvXTx//0r3++vdpFfA6q9rTTx//WbWfPv57Lb3kMr2WNOgT2gqNXHaCMKuwo+I5QeZ7UigLUQgXFXO7CM16hM4luswE0tEYjTDZ2JEmk4SvifguniJbReib2ey8evFznlfHbZ6Oh2Zxfla3x82Xvo2nywj+FqTlAu3Fp1//0Sw3Xf104bs//tWc9AK1Fgrm+F5MEyumWS0i05qkwJCy2lPiOHP4qzisJgPlPaY9mU2xbr2YAVM9zftLFdMWh0TlQVpFA2VaOUqgm5BQnhLElHtiY5LKShyH62nV8aJatPXZWfWtv1jk349iq8saNNdRfA9o/NEqbKY4Z0t2SCmFaqGUIiEjisE5KiRDDeRxBe15np/k6o/1op3NLyvfpOpZjZfndfPD8dND+M4F/0x8zwknkgsjRTuoFHPYQJTYgKbG2uyxEbPawJsFErleVC9zrPN5nZsDqhTrRIpZe1iZQjBZpIxwykVHNkNccV0B4CrS6KhSehPeq9ykPD8E2rKCSnkItFCgXMoKGAUGXTEskGC8I5AUwaiFh/A9pTxugK2t2tl1WqbqG2TBKMKEg3rtw1keYM8+IezrlQ9BFW8E0SLjhHUEs1XRhDHNVNAyhCxXOF/m6eznXJX5bPoQpJxTuxeZ+kijNwFRVYTa0FV7wYiH6yIleCg18zqF0tegptTz6U7zN8+L81mTXs++G3KBy6IBedmNU93i1KKA7tqRIjRwJkiRsyC9EuC+gDExJt/Ro2U0z1Ea91cjy/Reng5iNMTx4s8WK5KXYgqVkZGYLSUyCEHgtAsBw6Oh2saS2SbgL44PEE+h98vMvniiqiRqImqOKxBPicIDS0pJDtxLy1KWVG0w6PRi6ptqns8PJk+n74eSJwWBaIHVEY4TpUdnkEeg4kfGXIjMONWL3Cu4oFFYp217/jL/dJGXbJo1X83ns3mX9bD7dXORX+aTizM/v7XVfTbJrmqiYdkFXfaiKzwLXsbuqOHfEOpIlm8Zd1EYLThNciO6r6FP81mEkcvpXpw/NMA4f2ojCqhMCbXdKAqUmRIdYPSt117kNITyTXN+b5zLaO5RPfs4ZdYual2IiBacz+gNLTwRsU5KzbnkwvQSoXPzpzdlfnrtig9GaaXdF+XOKu+MS6BaIZGHLhdsgGLxBAGT1nNmbIqhn8YwJa8vz+vm5P+RzUIpuBeYykOyOVvPIu98SuKdVkh4QBUj0UkGrkNBptjVDm5yuFoarvRbY7JHH4irmkG4w2Z6ntv55Yvmma/PriO+4RdwNl3Xc9MivZ7XnamHcbjdmAUBHAMvEw6ioymFuBhPJOUxMpWjyW79aLZNB+4eTL/S6a4kq90lpR92H1mBVihS4MKgf0wTl9FBoStXJjEYJ9tD9+YcyZzhG+ByXx6u0GASbBhXexTj3SkfsuCOUwEn281xbMjEJgg54yxHnpSkzG4gf/bFN6++6kza65dvvjoYPtrwzwZfO8NgMNFYcAnjqynaHYW3QkavZJQu0p4uPjnLKIo3jcXBuJeJ8ZlwJ5dz8NqQILq5kvCZeB0tYVF7LZOiLPY8HKzGLnlcdxpLw7aHVe8bjaiQCcYZwihyVxYNjtHA0OvCq0lQIoZ+FW/r+ONl9Sc04Gy8h1he1F2z5jKYlUeMbQ6KlsrYicvjyWR8aMRssoqzRKiSnczlRODRBCk8FS+sViHbQaT8YKRdbXkA0miE6coHlCGobrwVkKBwwtxrTqnPDrEeRCoORoqOij8kpqh+hXsYIS8DkQ69RWBGkUSl87Ca2ZdhpPIep49SAWd1P6DeMpGo0yTDAuHw/dJjJMIUjKcVycNyDgJV90vT+yPViBwoFdBQgODSQ52CiTh8GTVH/4sDy4NI9cFIiZIPIlQM0dGoSIxdTJ3rZjNZwgilHCwyADwbRHqvs78/TnApRW4MUWghu14I/iagehmvVYR4OqvkIE5zOJ2ceghSKCfcIiw69w7E17DtYRlWZaTgIflUehF9cprjjw+aeXA9OpvJ73O8aPOLJuablvceFUuVIrKSijAtJYQM9h4BUlCLXKKIqGCuX7Ga/mYOaJCl4QfXrRSh/RAvpEJnepWDh7FZE12sRnes0X72H3+g6Xju3x8/XU4We9b3gMki12bPyeIVrkC+NDl2ty7TZ2VO8WYKO40Fv/+wfMa3bRK+vPJoUjcpv588pldv3+LLes5gaLHB52RjC91OM3orvT1aLbZjNje4bB/AEMCRqc9WiNfXDq22be66seTR5n3rA9FBGGsXD+HYwubBJdefE4xEanhePxyrNf4Nohx7OrEtVDtGC+u3HvVSsT/0GTvgO1scDMO2Acw24DsntoOQ1tk4mHVbm6JtmHY9FxzOv7XucfBohxudwfU2fh4wnCsjU+Rt29v7pqN+lm90OsOU2aDYcLaMlKHBNQceLg8tuufjqa3i0VOobbJ4Z7Y8inl9hDa04rYH59vS7G5Wb0n/zWnGiDAN6ccY4h11ets3rJWpLVoyMCofXHiErcN1d2P+NLjkyABuaMl9flsy+B1jwrddXT+/uo/+7ARAfP1DN1y8wOZv/q8HateUcuPmIY4MZ9JY3o0OpYcVdPxoHu7wtqvNePKtzaXHj25XeAdQXV39D+st/ObsJgAA

metadata_json:
  {"categories":["Communication","Customer Support"],"complexity":"medium","use_cases":["AI chatbot handoff","Auto pause chatbot","Human agent takeover","Customer message triage"],"estimated_setup_minutes":30,"required_services":["Facebook Messenger","Google Gemini"],"key_features":["Human intervention detection","Automatic chatbot pause","Context saving and restoration","AI-guided human support"],"target_audience":["Customer support managers","Developer engineers","Chatbot administrators"]}


name: Generate scored B2B leads from Google Maps websites to Google Sheets
author_name: Jannik Hiller
author_username: jannik-mtm
categories: []
created_at: 2025-12-18T13:43:10.220Z
updated_at: 2025-12-18T13:43:10.220Z
url: https://n8n.io/workflows/11924
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  This n8n workflow is a sophisticated B2B Lead Generation Scraper. It automates the entire journey from discovering businesses on Google Maps to extracting, scoring, and saving high-quality contact emails.

  Here is a breakdown of the workflow stages:

  Stage 1: Google Maps Search & Pagination
  The workflow starts with a list of search queries (e.g., "Dentist New York").

  Looping: It processes each query one by one.

  Smart Pagination: Google Maps usually limits results per page. This workflow detects the nextPageToken and automatically re-calls the API until all available businesses for that query are collected.

  Filtering: It immediately filters out closed businesses, keeping only those marked as "OPERATIONAL".

  Stage 2: Deep Web Scraping
  For every business found with a website, the workflow performs a two-step crawl:

  Homepage Fetch: It visits the main URL to find immediate contact info.

  Contact Page Discovery: A code node scans the homepage for links containing keywords like "Contact", "About", "Team", or "Impressum". It then visits these specific sub-pages to find hidden emails.

  Stage 3: Email Quality Control & Scoring
  This is the most advanced part of the logic. Instead of just grabbing any email, it uses a Scoring System to rank them:

  The Filter: It removes technical or junk emails (e.g., sentry@, noreply@, or image files disguised as emails).

  The Scorecard:

  +30 Points: Domain match (e.g., info@company.com matches www.company.com).

  +20 Points: Personal touch (detects dots or names like john.doe@).

  -40 Points: Generic prefixes (penalizes info@, admin@, sales@).

  -25 Points: Free providers (penalizes @gmail.com, @yahoo.com).

  Selection: It sorts all found emails by score and keeps only the top-ranked email for each business.

  Stage 4: Final Output
  Deduplication: It ensures no duplicate businesses are added to your list, even if they appeared in multiple search queries.

  Data Storage: The final, cleaned data—including Business Name, Address, Phone, Website, and the Best Email—is appended to a Google Sheet.

nodes_used:
  ["n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.merge","n8n-nodes-base.merge","n8n-nodes-base.splitOut","n8n-nodes-base.filter","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.httpRequest","n8n-nodes-base.removeDuplicates","n8n-nodes-base.code","n8n-nodes-base.removeDuplicates","n8n-nodes-base.code","n8n-nodes-base.sort","n8n-nodes-base.limit","n8n-nodes-base.aggregate","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, 9004 characters]

metadata_json:
  {"categories":["Marketing","Sales"],"complexity":"medium","use_cases":["scrape business contact info","generate B2B leads","extract data from search results","score leads automatically","store leads in spreadsheets"],"estimated_setup_minutes":30,"required_services":["Google Maps","Google Sheets"],"key_features":["scrapes business listings","extracts contact emails","scores leads by quality","handles pagination","duplicates removal"],"target_audience":["sales teams","marketing managers","business developers"]}


name: Automate product Hunt lead generation with Apify and Google Sheets
author_name: Jay Emp0
author_username: jay-emp0
categories: []
created_at: 2025-12-19T10:28:47.308Z
updated_at: 2025-12-19T10:28:47.308Z
url: https://n8n.io/workflows/11947
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Product Hunt Scraper - Automated Lead Generation Workflow

  &gt; Watch the full Youtube Video Tutorial 

  Turn Product Hunt Launches Into Qualified Leads and Reach out Automatically

  Stop manually searching Product Hunt for potential customers. This n8n workflow automatically scrapes the latest products from Product Hunt every day, enriches them with contact details, and delivers organized lead lists straight to your Google Sheets.

  What You Get

  This powerful automation workflow delivers:

  Daily Lead Generation**: Automatically scrapes top 50 Product Hunt products every day at 9 AM
  Weekly Top Performers**: Every Monday, captures the top 100 products from the previous week (configurable)
  Rich Contact Data**: Extracts emails, Twitter handles, LinkedIn profiles, Discord usernames, phone numbers, and more
  Organized Google Sheets**: All leads exported to a structured spreadsheet with product details, maker info, and contact data
  Automated Outreach**: Optional email system to reach out to makers with personalized messages
  Fresh Leads Daily**: Never miss a new product launch or potential customer

  Why This Workflow Is a Game Changer

  For Sales & Business Development Teams

  Build a targeted prospect list** of innovative companies launching new products
  Reach decision makers directly** with founder emails and social profiles
  Beat your competition** to newly launched products looking for partnerships or tools
  Scale your outreach** without hiring additional SDRs

  For SaaS Founders & Indie Hackers

  Find integration partners** by identifying products that complement yours
  Discover competitors** and track their launches in real time
  Connect with fellow makers** for collaboration opportunities
  Source beta testers** from engaged Product Hunt communities

  For Marketing & PR Agencies

  Identify potential clients** who just launched and need marketing support
  Build media lists** of active founders for outreach campaigns
  Track industry trends** and emerging products in your niche
  Automate lead qualification** by capturing product categories and descriptions

  For Investors & VCs

  Monitor emerging startups** launching on Product Hunt
  Track portfolio company launches** and engagement
  Discover investment opportunities** in specific categories
  Build deal flow** with minimal manual research

  Key Features

  Intelligent Data Extraction



  The workflow captures comprehensive product data:

  Product name, description, and tagline
  Product categories and launch date
  Upvotes and engagement metrics
  Maker information with social profiles
  Website URLs and demo links
  Banner images and screenshots

  Multi Channel Contact Discovery



  Advanced contact enrichment pulls:

  Primary email addresses** (founder emails, sales, feedback, hello)
  Secondary email addresses** for CC'ing multiple contacts
  Social media profiles**: Twitter, LinkedIn, Discord, Facebook, Instagram
  Communication channels**: YouTube, TikTok, Telegram, WhatsApp, Reddit
  Phone numbers** (when publicly available)
  Company domains** for additional research

  Automated Daily Operations

  Set and forget scheduling**: Runs automatically every morning at 9 AM
  Smart deduplication**: Removes duplicate entries to keep your data clean
  Error handling**: Continues processing even if individual products fail
  Webhook driven architecture**: Efficiently processes results as they're ready
  Batch processing**: Handles large datasets without overwhelming your system
  Gmail integration**: Professional email sending via Gmail API for better deliverability

  Automated Outreach System



  The workflow includes a sophisticated Gmail powered email system that:

  Sends personalized outreach emails** to product makers with their product details
  CCs secondary email addresses** for better reach
  Professional HTML email templates** that are customizable to your brand
  Better deliverability** through Gmail API (not SMTP)
  Tracks delivery and engagement** through Gmail
  Free to use** - 500 emails/day (personal Gmail) or 2,000/day (Workspace)

  Email Template Features:
  Dynamic product name and details
  Reference to Product Hunt launch
  Personalized value proposition
  Clear call to action
  Unsubscribe link for compliance
  Your branding and contact info

  What's Included

  When you purchase this workflow, you get:

  Complete n8n workflow JSON file** ready to import
  Detailed technical setup guide** with step by step instructions
  Pre configured Apify actors** for Product Hunt scraping and contact enrichment
  Email templates** for outreach campaigns

  Real Results

  Cost Effective Lead Generation



  Run this workflow for approximately $65 to $95/month and generate:

  1,900+ leads per month** (50 products/day × 30 days + weekly top 100)
  Cost per lead: ~$0.03 to 0.05** which is far cheaper than any lead database
  Fresh, verified contacts** that aren't available in purchased lists
  Zero manual work** after initial setup

  Sign up for Apify: Use our affiliate link or referral code 99h7ds

  Technical Highlights

  Built on n8n - the powerful open source automation platform
  Uses Apify actors for reliable scraping at scale
  Google Sheets integration** for easy data access and sharing
  Gmail API integration** for professional email outreach
  Webhook based architecture** for real time processing
  Smart batching** to stay within API rate limits
  Modular design** making it easily customize which data points to collect
  Error recovery** built into every step
  Active testing data** pinned for easier debugging

  Requirements

  To run this workflow, you'll need:

  n8n instance (cloud or self hosted on Railway or Hostinger)
  Apify account (use referral code: 99h7ds - free tier available, paid recommended)
  Google account (for Sheets, Drive and Email integration)

  Detailed setup instructions are provided in the Technical Setup guide.

  Comparison: DIY vs This Workflow

  | Task | Manual Process | With This Workflow |
  |------|---------------|-------------------|
  | Find daily products | 30 mins/day checking Product Hunt | Automatic |
  | Extract contact info | 5 mins per product × 50 = 4+ hours | Automatic |
  | Organize in spreadsheet | 30 mins/day | Automatic |
  | Send outreach emails | 3 mins per email × 50 = 2.5 hours | Automatic |
  | Total time saved | 7+ hours/day | 0 hours |
  | Monthly cost | Your time + assistant salary | ~$50/month |

  Customization Options

  This workflow is fully customizable:

  Adjust scraping schedule**: Change from daily to twice daily or weekly
  Filter by category**: Only scrape products in specific categories (AI, Developer Tools, etc.)
  Modify top N products**: Increase/decrease the number of products scraped
  Custom email templates**: Edit the outreach message to match your brand
  Add email verification**: Integrate ZeroBounce or similar services
  Connect to your CRM**: Pipe leads directly to Salesforce, HubSpot, or Pipedrive
  Slack/Discord notifications**: Get alerted when new leads are found

  Support & Updates

  Lifetime updates**: Get all future improvements and bug fixes
  Email support**: Questions? We're here to help with setup, Email Us
  Community access**: Join our Skool community with other users sharing tips and customizations
  Documentation**: Comprehensive guides covering every feature

  Get Started Today

  Stop losing leads to competitors. Start automatically capturing fresh Product Hunt leads every single day.

  → Purchase Workflow - One time payment, lifetime access

  → View Technical Setup Guide - See what's involved

  → Join Community - Connect with other users

  Frequently Asked Questions

  Q: Do I need coding skills?
  A: No! The workflow is pre built and ready to import. Basic n8n familiarity is helpful but not required.

  Q: What are the ongoing costs?
  A: Approximately $65 to $95/month total ($40-60 for Apify scraping services + $20 for n8n cloud, or $0 if you self host on Railway or Hostinger).

  Q: Is this legal?
  A: Yesm all data is publicly available on Product Hunt and product websites. Follow ethical outreach practices.

  Q: Can I scrape more/fewer products?
  A: Absolutely! The workflow is fully customizable. Adjust the "topNProducts" parameter in the config.

  Q: What if emails bounce or accounts get banned?
  A: The guide includes best practices for email deliverability and warnings about sending volume limits.

  Q: Can I use this for specific product categories?
  A: Yes! You can filter by category in the Apify scraper configuration.

  Q: Does this work with Gmail?
  A: Yes! The workflow now uses Gmail API by default for better deliverability and tracking. You can customize it for other providers by using the SMTP node

  Ready to automate your lead generation? Get the Product Hunt Scraper workflow today and start building your pipeline on autopilot.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.dataTable","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.dataTable","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.webhook","n8n-nodes-base.dataTable","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.aggregate","n8n-nodes-base.dataTable","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 9256 characters]

metadata_json:
  {"categories":["Marketing","Lead Generation","Data Processing"],"complexity":"medium","use_cases":["scrape product launches","enrich lead data","export to spreadsheets","automate outreach"],"estimated_setup_minutes":15,"required_services":["Product Hunt","Google Sheets","Apify"],"key_features":["daily automation","web scraping","data enrichment","batch processing","contact extraction"],"target_audience":["marketers","business developers","entrepreneurs"]}


name: Crypto volume change Discord alerts (5-20%) with CoinGecko (Top 1000 coins)
author_name: Malik Hashir
author_username: malikx
categories: []
created_at: 2025-12-19T17:50:22.436Z
updated_at: 2025-12-19T17:50:22.436Z
url: https://n8n.io/workflows/11966
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Purpose and Audience
  This professional-grade n8n workflow automation is designed for crypto traders, investors, and market analysts who need real-time volume change alerts across different market cap segments. Whether you're day trading, swing trading, or conducting market research, this workflow keeps you informed of significant volume movements that often precede major price action.

  What It Does
  This automated system monitors the top 1,000 cryptocurrencies and sends detailed Discord notifications when significant volume changes are detected. The workflow intelligently segments coins into three market cap tiers:
  Large Cap (&gt;$1B): Alerts on volume changes &gt;5%
  Mid Cap ($100M-$1B): Alerts on volume changes &gt;10%
  Small Cap (&lt;$100M): Alerts on volume changes &gt;20%

  Each alert includes comprehensive data: previous vs. current volume, volume change percentage and dollar amount, current price, 24h price change, market cap, volume/market cap ratio, and market cap rank. The system automatically filters out stablecoins and low-volume noise to ensure you only receive actionable alerts.

  How It Works
  The workflow operates on a 2-hour schedule (fully customizable) and executes the following process:
  Data Collection: Fetches fresh market data for 1,000 cryptocurrencies from CoinGecko API across 4 paginated requests
  Volume Analysis: Compares current volume against previously stored data to calculate percentage changes
  Tier Filtering: Segments coins by market cap and applies appropriate volume change thresholds
  Alert Generation: Identifies top 20 volume movers per tier and formats rich Discord embeds with detailed metrics
  Data Management: Automatically deletes old data and stores new baseline data for the next execution cycle
  Discord Delivery: Sends formatted alerts to your Discord channel with embedded guides explaining how to interpret the signals

  The workflow includes built-in intelligence to handle rate limits, batch processing for Discord's 10-embed limit, and comprehensive error handling.

  Who Is It For
  Active cryptocurrency traders seeking early volume spike signals
  Portfolio managers monitoring multiple market cap segments
  Market researchers tracking crypto market dynamics
  Trading communities wanting automated alert systems
  Discord servers focused on crypto trading and analysis

  How to Setup
  Please watch the provided setup tutorial for complete step-by-step instructions. Setup time is approximately 15-20 minutes and requires:
  n8n instance (self-hosted or cloud)
  CoinGecko API key (https://www.coingecko.com/en/api)
  Discord webhook URL
  Basic familiarity with n8n interface

  The tutorial covers API configuration, Discord webhook setup, data table initialization, and schedule customization.

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.dataTable","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.noOp","n8n-nodes-base.dataTable","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.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61a225bxxX9FYJAixTgGHO/+KFAa6OFgSQOaiMvgR/23GQiEqmSVJrA0L93HVqxjsQ5POfQ9oMhU+M9i/uy9toz82l5Uw60fPlpud7sD7RJ5U1evlw6W43VqYQiqg62kE3KKFWFMdlI4UgJcjqKaGUspHhSzmkZtCNyubi0vF8tN9tc9suXv8B0Z9JwyyknxyxVyTRPhUUeIstFZh8d58rSEv+LbgpW/6sc0sfFT3RVFgKfHv647T7d+A07mmWR9uXFx8Ph9j/lv3dlf8Ca2+1+fVhvN9iSCWH9SgT5AR/TDiYPZQcsn+4/m/oZ/zqu1C/E/eoBIEWXCq+JVS8101FZ5qWwLNYsaqom8GqbAOWlAJX1cwDKJKMT3DOnnWdaiMiiU4HpGnIKVuXEUxOguhSg0XoOwGSNpxwL80IkwBIIMSViwjkL36qisnkE+EPZXZVBZDcPv+1jcl6vNOdjkNQL+QVSMFUoYR2TMRemKTsWbLUsZc+5CdqQNU2f6Ut95uQowL7PlJRkYwwMRUBMG8sZZYPwJu21MLXmWh4BvqYDLX7abVPZ79ebq0GMCT8+AwfLK61GK6LnushFCVozJ1Gm2pvMfDCWiUI+iWS1pl66vfpY0q+Lut0tftte392UBV2X3WE/iHBdn+Lzwa4kH60H2YstDzp4GQRLAIR0SwKuQ2VIQ1zKnIspPde9394uJP8T3c32t26D6f4Tmk9ilB48UyK3tQPlHdNFOeYdmKWKqCR57sm7Xuptdzd0WOT1Pm13eXGDANOZ8mgAtJ7PAyhCUI5cYmA+pF7WqWPkzAoJExD9mr14BPjvcljstv8b9llGbr6neP088YT0A4lXfi/p7lDeoussXx52d+UZ1Mcq8U5XDxbuctEyrUKAL5NBLyGhagpZiV4Zf79FrN8iwIs3h3IzjHh/e70+vNn8k1D1Zf8UNpqcneJO9QVjBReHDIJRngOj7BwLaCxnNMqQjQUB9uK9vobFBcK++J5AdYtXdDsnH63mk+rlMR2dr8kX25Eg/kLXRrSzZCYl44pWXlFtwvthnS8BN4trihIxxqIZT13niMUz4grh5oVIOxOEUU1w727o+voSeNbNgFfRMwx5yBaTBZjGFhYEpIzgpeTstXPRjlLhsI5pceEU9/W4UFZPKqjInJNoHui9LJYOK8VUrLdkXT3PhcPwBshQCzvdg6lrb6QFq1xwNLecWeAok5CiV8kIIgpjZDgLYceG8xAKW4RFQXDloBSiq6gPKgAsjSwuRFVokGKGoY1yzASQjxwTjUQR+8ik8AizygQJCMqWMQWtlDVRyNFEHNarrUScUii9RKQsbKBCTFJEoB11qsFJaLdkVQlo1SKdT8RheK1ElHplzYwwexRItRJ+i1KBpUkyj9pgWeZonJceQ81YIs5C2CXiLISGI4iuFqZkAOPYmEA2EK/GBevJWlNCHUzEYWjnEzHIKSAfE1GlEJGDAm24dMNSQbUIiqxYKENTS7a2B/LV9gZ2y+Lnz3H+Kwj7Ot1d0wFt7yNtrsp+8d3fzV/+NsOvEoGf1f8smBowDVS6B2KOmFMgYiqBOA0mP9T/TMSCz4Y8qytCQ8SskKGK6wwqRxnF4DQz3mPe88VYNxeynA95VqeMlTJGBchJmQ00ZagsKDQjlaA1rHWi6p7ofYdUzHfXZfF+t766Krvh5H1Y+LjuicK0Gu3Ij85doj88SIc5MHOWTEGVZQnxS7oyQymDqaqw1PPtm80ezNnp37nyVxuUltatRH0ifytd74f1r8jW2a7IlEzIBKOIeUIGKxWNcjoR8f4s8TjG+vljrHKYFJW5RLD3B1vMN1Rs9cxZgVZVi2JEBuM3spqT08rm9nlPuBCykaNOHoHsvc8iVcuykJAAAelAJXQDpUyq616qiCZkwS/EbP3XYiaeYnbaMk4Gyll0HEFQVwTpLEnpXF1Pmj47P5ijqBAwP5DIA1xA0CeOpGPOFCRt59PgbcJAhD5W0eNCbbvzQmdCTX2lM5123CLSzEddupyFOAhJYoQNxuKPyrw3hhwPsIZd2DjBgtabpEr7J1ioIgHxrJioEXObQZTJcmgCHZPwMVohegH+cbt4e1t21G24WuTtYrM9fDx3UrTZvr195ksp7BTGOjuwQ0knSH2IP0m8O/xAH5AWqjAIrkqOTqZe7F+Xa+zS0et3++H2NMCwMrghvAPgShIZLV+zELoztwQ9EIOCKMBckrSoNYQeNb07rNOvfyx+3B6Gj2P2xzUPS560Ju39KpwEfJm2m0PZHGBpeQanNwbzr2dGIid1iaU74EIVQaoKnQ3YPzdxDrP+IFDp5MU4k8PoXpztJCC8GCp6qU6C8SCVLpxUsa6Jc5jqh3AizhfDtFoFJ4xltWq40wMrGesZzxihXPUdLTVhnqH3IZxCfgVQnamo3GmTyB38iXkvGkwAmXsRc6nBuNQGemYOHQAqPeaTS4E6I5GJMoAgK6o8i4AUMBxTgNVCU+BODnh0+EpiOEMx365ORd7E2BcjndaG2aADepHnzHOJygo5GWu85ccgN5CemaiGYg9tfrFLpY1cY4ICySdwk6sYrIJ2SFKoE8l1NbKnS9+VTX48P1z84zjfLw7bxevPE+v8TirRnqYMVrrXoqoomlfHmZUKaWA0upOTBiRQShZFSSnUM8x/Hip+M8gTBqsnkFNVSaaK4V8JDNnJdg3VY07xNfBslXd8yM3fDvSE0aoPGkI6KTAgWsHxMgsJ4rs5FlKP1yy9Q5a3k/iCxuWkXyl/cv93PouxGr/flNSZOS7/fMuHH25o3Rn+5dPxYvhUiz5CPK5cLdebXH5fvuT3Hz5gowexNcGQGLH05SKjZeuCIfr5Jqt5xsS3NGbO2Tp++77MbjnguagdM9IOybO73TEjcr4RcWJEzTciT4zo+UbUiRF/gWdPv0+4wMrDF3qqp1tmxueE0cDzC/A9+Op56bcMnd43NhE9v+vrmfqwerQ2vVE2dzmhmBbi1iHRFMziLOgpnXLKLu0aG5i8TgwOunI+rpNDvxau9vufYXZsP8eZtF7NXK/HaqRxddpsNaPXhE3zzXcMTReOvCgYA9+7lp4Bf7r93tXtDPtnojvonna5jl4yTrbfLq3Ru6O2g9pRa20w+MyhaXgoXi3L59/KzMDd9vzw5ekM022nD1+HzXFKG/bIrfmcDdrgR25DmxsMNvIRVp1Jen7m+jBzff+Ipd01RnrhN8izUY3w9UU43ju/RVJPnRSaKXL+XdLlGx7nnJEdT58aXb6fnLBf6/VQY8f7+/8DuBI+wyctAAA=

metadata_json:
  {"categories":["Finance","Communication","AI/ML"],"complexity":"medium","use_cases":["Alerts for volume spikes","Tracking crypto trends","Market analysis notifications"],"estimated_setup_minutes":25,"required_services":["Discord","CoinGecko"],"key_features":["Monitors top 1000 cryptocurrencies","Detects 5-20% volume changes","Real-time notifications"],"target_audience":["crypto traders","investors","market analysts"]}


name: Generate & publish SEO-optimized Shopify blog articles with Gemini & ChatGPT
author_name: Jay Emp0
author_username: jay-emp0
categories: []
created_at: 2025-12-22T17:51:29.844Z
updated_at: 2025-12-22T17:51:29.844Z
url: https://n8n.io/workflows/12042
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  AI Powered Blog Automation for Shopify

  &gt;Watch the Youtube Tutorial Video

  Transform Your Shopify Store with Automated, AI Generated Blog Content

  Stop struggling with content creation. This n8n workflow automatically generates high quality, SEO optimized blog posts for your Shopify store every single day while you focus on growing your business.

  See It In Action: Real Results from Pink Matcha

  Visit Pink Matcha Blog - A real Shopify store powered by this exact workflow.

  Real Traffic, Real Results



  50+ SEO optimized articles** published automatically
  Consistent daily content** without hiring writers
  Multiple categories** with targeted content
  Professional formatting** that converts visitors to customers

  What You're Getting

  ✅ Automated Content Generation
  AI creates unique articles** from curated industry sources
  SEO optimized** with proper headings, keywords, and meta descriptions
  800 to 1200 words per article** with actionable insights
  Plagiarism free** content that ranks in Google

  ✅ Multi Category Organization



  Fitness, Nutrition, Wellness, Personal Growth, or YOUR niche
  Each category gets targeted, relevant content
  Build authority across your entire product range
  Cross sell opportunities through strategic content

  ✅ Direct Shopify Integration
  One click publishing** to your Shopify blog
  Professional HTML formatting
  Automatic categorization
  SEO metadata included
  Draft or publish modes

  ✅ Multi Blog Support
  Manage multiple blogs** within the same Shopify store
  Create separate blogs for different product lines or audiences
  Each blog can have its own RSS feeds and categories
  Run workflows independently or simultaneously

  ✅ Smart Product Integration
  Automatically embed product links** within articles
  AI intelligently references relevant products from your catalog
  Include product cards, images, and CTAs
  Drive traffic directly to product pages
  Turn readers into buyers with strategic product placement

  ✅ AI Generated Featured Images
  Automatically creates branded images** for every blog post
  AI generates custom visuals that match your brand style
  Include your logo or signature products in every image
  Customizable style instructions for perfect brand consistency
  No need for stock photos or graphic designers
  Every article gets a unique, professional featured image

  ✅ Smart Content Intelligence
  MongoDB vector search** prevents duplicate topics
  Sources content from trusted RSS feeds in your niche
  Learns your brand voice
  Maintains consistency across all articles

  🔥 Game Changing Features

  Multiple Blogs, One Workflow



  Run multiple blogs within the same Shopify store:
  Create separate blogs for different product lines (e.g., Men's vs Women's, Premium vs Budget)
  Target different audiences with customized content strategies
  Each blog has its own RSS feeds, categories, and publishing schedule
  Manage everything from a single n8n instance
  Perfect for multi brand stores or diverse product catalogs

  Example Use Cases:
  Fashion Store**: Separate blogs for Men, Women, Kids, and Accessories
  Wellness Store**: Different blogs for Fitness, Nutrition, Mental Health, and Supplements
  Tech Store**: Blogs for Gadgets, Software Reviews, How To Guides, and Industry News

  Intelligent Product Integration



  AI automatically embeds your products within blog content:
  Analyzes article topics and matches relevant products from your catalog
  Inserts product cards with images, descriptions, and "Buy Now" buttons
  Creates contextual product mentions throughout the article
  Links to product pages to drive direct sales
  Customizable product placement rules

  Turn Every Article Into a Sales Machine:
  Blog post about "Best Workout Routines" → Automatically includes your yoga mats, resistance bands, and protein powder
  Article on "Winter Skincare Tips" → Embeds your moisturizers, serums, and face masks
  Guide to "Home Office Setup" → Features your desk organizers, chairs, and lighting products

  AI Generated Featured Images with Brand Consistency



  Every article gets a unique, professionally designed featured image:
  AI generates custom images matching your brand aesthetic
  Automatically includes your logo or signature product in each image
  Configure your brand style once, AI applies it to all future images
  Customizable image generation instructions for perfect consistency
  Wide, natural looking scenes (no generic stock photo vibes)
  No need for Canva, designers, or stock photo subscriptions

  How It Works:
  Configure your Branding Logo (product image or logo URL)
  Set your Branding Style ("Image should contain a girl holding this drink")
  Define Image Style guidelines ("Wide, natural scene with no square framing")
  AI automatically generates unique images for each article topic
  Images are uploaded to Shopify and set as featured images

  Example:
  Article: "5 Morning Rituals for Better Energy"
  Generated Image: Wide, natural scene of a person holding Pink Matcha drink during sunrise, perfectly matching your brand aesthetic

  No more spending hours on:
  Finding stock photos
  Editing images in Canva
  Ensuring brand consistency
  Resizing for different platforms
  Worrying about image licensing

  Why Store Owners Love This Workflow

  💰 Save Thousands on Content Creation

  Traditional Approach:
  Freelance writers: $100 to 300 per article
  30 articles/month = $3,000 to 9,000/month
  Plus time for editing, SEO, uploading, formatting

  With This Workflow:
  $30 to 60/month** in API costs
  Unlimited articles
  Zero manual work
  Save $2,940 to 8,940 per month**

  ⏰ Reclaim Your Time

  Before:
  4 to 6 hours writing each article
  2 hours researching topics
  1 hour formatting and uploading
  7+ hours per article**

  After:
  Click one button
  AI generates, formats, and publishes
  0 hours of your time**

  📈 Grow Your Organic Traffic



  Fresh content signals to Google you're active
  More pages = more chances to rank
  Long tail keywords across every article
  Internal linking boosts your entire site

  🎯 Perfect for E commerce

  Educational content** that supports your products
  How to guides** featuring your items
  Category pages** that drive purchase decisions
  Build trust** before customers buy

  Live Examples from Pink Matcha

  Fitness Content

  Nutrition Content

  Self Care Content

  Personal Growth Content


  Every single one of these articles was generated automatically by this workflow.

  Perfect For Every Shopify Store

  🏋️ Health & Wellness Brands
  Generate workout tips, nutrition guides, supplement education, and wellness advice that positions your products as solutions.

  👗 Fashion & Apparel
  Create style guides, trend reports, outfit inspiration, and care instructions that showcase your clothing line.

  🏠 Home & Lifestyle
  Produce decorating tips, organization hacks, product care guides, and seasonal content that drives home goods sales.

  💄 Beauty & Skincare
  Develop routine guides, ingredient education, application tutorials, and trend analysis that supports cosmetics sales.

  🎮 Hobbies & Collectibles
  Write product reviews, how to guides, industry news, and collector tips that engage enthusiasts.

  📱 Tech & Gadgets
  Generate setup guides, comparison articles, tech news, and troubleshooting content for electronics stores.

  What's Included in Your Purchase

  4 Complete n8n Workflows
  Shopify Blog Automation - The core automation engine
  Gemini Image Generator Tool - AI powered featured image creation with brand consistency
  Web Search Tool - Real time web research using OpenAI GPT 4O Search
  Link Validator Tool - Ensures all URLs work before publishing

  Complete Documentation
  Step by step setup guide** (Technical Setup.md)
  Video walkthrough** (coming soon)
  Google Sheets templates** for RSS feeds and categories
  Example configurations** for multiple niches

  Lifetime Access & Updates
  All future workflow improvements
  New features as they're released
  Updated documentation
  Priority email support

  How It Works (Simple 3 Step Process)

  Step 1: Configure Your RSS Feeds
  Add trusted content sources from your industry into a Google Sheet. The workflow monitors these for fresh content daily.

  Step 2: AI Generates Unique Articles
  Google Gemini reads source articles, understands your niche, and creates completely original blog posts optimized for SEO and your brand voice.

  Step 3: Auto Publish to Shopify
  Articles are automatically formatted, categorized, and published to your Shopify blog—no manual work required.

  That's it. Your blog grows on autopilot.

  Technical Specs (For the Curious)

  AI Content Engine**: Google Gemini for blog content generation
  AI Image Engine**: Google Gemini 3 Pro Image Preview (16:9 branded images)
  Web Search**: OpenAI GPT-4O SEARCH PREVIEW for real time research
  Vector Search**: MongoDB Atlas (prevents duplicate topics)
  Embeddings**: OpenAI text-embedding-3-small for semantic matching
  Platform**: n8n workflow automation
  Integration**: Native Shopify Admin API & OAuth2
  Social**: Auto post to Twitter (optional)
  Scalability**: 1 to 10+ articles per day with custom featured images

  Full technical documentation included with purchase.

  Frequently Asked Questions

  Q: Do I need coding skills?
  A: No! Import the workflows, configure your credentials, and you're ready. Full setup guide included (~60 to 90 minutes).

  Q: What are the monthly costs?
  A: ~$30 to 60/month (Google Gemini API + OpenAI + MongoDB free tier + n8n self to hosted). Way cheaper than hiring writers.

  Q: How many articles can it generate?
  A: Unlimited. Run it daily for 30 to 90 articles/month, or adjust frequency to your needs.

  Q: Will the content be unique?
  A: 100% original. AI creates new content inspired by sources, never copies. Vector search prevents duplicate topics.

  Q: Can I use this for my niche?
  A: Yes! Works for ANY niche. Just configure your RSS feeds and categories. Tech, fashion, home, beauty, gaming—anything.

  Q: Does it work with WordPress or other platforms?
  A: This version is built for Shopify. The workflow can be adapted for WordPress, Ghost, Medium, or custom sites.

  Q: How long are the articles?
  A: Configurable. Default is 800 to 1200 words. Adjust AI prompts for shorter (500w) or longer (2000w+) content.

  Q: Can I review articles before publishing?
  A: Yes! Set to "draft" mode, review in Shopify, edit if needed, then publish manually.

  Q: What languages does it support?
  A: Google Gemini supports 100+ languages. Configure the AI prompts to generate content in your target language.

  Q: What's your refund policy?
  A: No refunds. Please review this page and the live examples before purchasing.

  Still Not Sure? See The Results



  Visit pinkmatcha.co to see this workflow in action. Every article. Every category. All automated.

  Read the articles. Check the formatting. See the SEO optimization. Experience the quality.

  Then imagine this running on YOUR Shopify store.

  Questions? We're Here to Help

  📧 Email: jay@emp0.com

  💬 Community: Join our Skool

  📚 Documentation: Comprehensive guides included

  🎥 Videos: Setup tutorials (coming soon)

  About emp0

  We build production ready n8n automation workflows used by hundreds of businesses worldwide. Our workflows save companies thousands of hours and tens of thousands of dollars every month.

  🛍️ Premium Workflows: store.emp0.com
  🆓 Free Workflows: emp0.com/automation-workflows
  🐦 Twitter: @emp0_com
  🎯 Live Example: Pink Matcha Blog

  Don't Let Your Competitors Outrank You

  While you're manually writing one blog post per week, your competitors could be publishing daily with AI automation.

  Every day you wait is another day without:
  Fresh SEO content ranking in Google
  Educational articles converting visitors
  Authority building thought leadership
  Traffic flowing to your products

  The solution is one click away.

  Powered by n8n • Google Gemini • OpenAI • MongoDB • Shopify

nodes_used:
  ["n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.rssFeedRead","n8n-nodes-base.set","n8n-nodes-base.aggregate","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.vectorStoreMongoDBAtlas","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.crypto","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.mongoDb","n8n-nodes-base.mongoDb","n8n-nodes-base.googleSheets","n8n-nodes-base.limit","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitOut","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.vectorStoreMongoDBAtlas","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.mongoDb","n8n-nodes-base.mongoDb","n8n-nodes-base.aggregate","n8n-nodes-base.mongoDb","n8n-nodes-base.mongoDb","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.mongoDb","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.mongoDb","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.memoryMongoDbChat","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.aggregate","n8n-nodes-base.mongoDb","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.if","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.limit","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.mongoDb","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.mongoDb","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.mongoDb","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.aggregate","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.twitter","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.mongoDb","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.aggregate","n8n-nodes-base.shopify","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.mongoDb","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflow","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if"]

workflow_json_compressed:
  [encoded data, 10672 characters]

metadata_json:
  {"categories":["Marketing","E-Commerce","AI/ML","Content Creation","Automation"],"complexity":"medium","use_cases":["Automate blog post creation","Generate SEO content","Schedule daily articles","Integrate AI content generation","Optimize e-commerce copy"],"estimated_setup_minutes":15,"required_services":["Shopify","Google Gemini","ChatGPT","MongoDB","Google Sheets"],"key_features":["Daily automated content publishing","SEO optimization built-in","Multi-AI content generation","High-quality blog post drafting","Store-specific content tailoring"],"target_audience":["E-commerce owners","Content marketers","SEO specialists"]}


name: Monitor Reddit for sales opportunities with GPT-4o and create Asana tasks
author_name: Rahul Joshi
author_username: rahul08
categories: []
created_at: 2025-12-24T13:59:52.919Z
updated_at: 2025-12-24T13:59:52.919Z
url: https://n8n.io/workflows/12102
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  📊 Description
  Automate sales opportunity discovery by continuously analyzing Reddit discussions for real buying intent using AI. 🔍🤖 This workflow runs every two hours, searches Reddit posts via Google, evaluates each discussion with a conservative AI model, and determines whether it represents a genuine sales opportunity. High-quality opportunities are enriched with intent level, problem summary, confidence score, and recommended next action—then automatically converted into Asana tasks with real-time Google Chat alerts. Ideal for sales and growth teams looking to capture demand signals without manual monitoring. 🚀📊

  🔁 What This Template Does
  1️⃣ Runs automatically every 2 hours using a scheduled trigger. ⏰
   2️⃣ Searches Google for Reddit posts containing buying-intent keywords. 🔍
   3️⃣ Extracts Reddit titles, snippets, and post URLs from search results. 🌐
   4️⃣ Processes each Reddit post individually to avoid batching issues. 🔄
   5️⃣ Uses an AI agent to analyze intent based strictly on post text. 🤖
   6️⃣ Determines whether the post is a real sales opportunity. 🚦
   7️⃣ Classifies intent level as High, Medium, or Low. 📊
   8️⃣ Summarizes the core problem and suggests a reasonable next action. 📝
   9️⃣ Assigns a confidence score (0–100) for opportunity strength. 🎯
   🔟 Routes opportunities based on intent level.🔀
   1️⃣1️⃣ Creates Asana tasks for qualified leads with full AI context attached. 📋
   1️⃣2️⃣ Sends real-time Google Chat alerts for sales visibility. 💬
   1️⃣3️⃣ Triggers Gmail alerts automatically if any workflow error occurs. 🚨

  ⭐ Key Benefits
  ✅ Discovers real buyer intent from organic Reddit conversations
   ✅ Eliminates manual Reddit scanning and lead qualification
   ✅ Uses conservative AI logic to avoid false positives
   ✅ Automatically turns insights into actionable sales tasks
   ✅ Provides confidence scores and problem summaries for context
   ✅ Keeps sales teams informed with instant Google Chat alerts

  🧩 Features
  Scheduled Reddit discovery via Google Search (SerpApi)
  AI-based opportunity detection using GPT-4o-mini
  Strict structured JSON output for reliable automation
  Intent-based routing (Low / Medium / High)
  Automated Asana task creation with detailed notes
  Google Chat alerts for real-time notifications
  Gmail-based error handling
  Scalable batch-safe processing

  🔐 Requirements
  SerpApi API key
  OpenAI API key (GPT-4o-mini recommended)
  Asana OAuth2 credentials
  Google Chat OAuth2 credentials
  Gmail OAuth2 credentials (for error alerts)

  🎯 Target Audience
  B2B sales and outbound teams
  Growth and demand-generation teams
  SDR and lead qualification teams
  SaaS founders monitoring market demand
  RevOps and automation teams

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.cron","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.googleChat","n8n-nodes-base.asana","n8n-nodes-serpapi.serpApi","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.switch","n8n-nodes-base.googleChat","n8n-nodes-base.asana","n8n-nodes-base.googleChat","n8n-nodes-base.asana","n8n-nodes-base.errorTrigger","n8n-nodes-base.gmail"]

workflow_json_compressed:
  [encoded data, 5376 characters]

metadata_json:
  {"categories":["Sales","Marketing","Development"],"complexity":"medium","use_cases":["Monitor subreddit discussions for sales leads","Generate Asana tasks from AI-processed Reddit data","Automate sales opportunity tracking"],"estimated_setup_minutes":15,"required_services":["Reddit","Google Serp API","Asana","Google Chat"],"key_features":["AI-driven conversation analysis","Automated lead scoring","Real-time opportunity detection","Task automation"],"target_audience":["sales managers","marketing teams","small business owners"]}


name: AI Virtual Try-On Image, Video Generation for Telegram, Discord & YouTube
author_name: AttenSys AI
author_username: attensys
categories: []
created_at: 2025-12-24T17:52:38.421Z
updated_at: 2025-12-24T17:52:38.421Z
url: https://n8n.io/workflows/12115
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:20
description:
  🧥 Virtual Try-On Image & Video Generation (VLM Run)

  📌 Overview

  This n8n workflow enables a Virtual Try-On experience where users upload a dress image and the system:

  Combines it with a fashion model image
  Generates a realistic try-on image
  Generates a fashion walking video
  Automatically shares results via:

    Telegram
    Discord
    YouTube

  🚀 Use Cases

  Virtual fashion try-on
  AI fashion marketing
  Clothing e-commerce previews
  Social media fashion automation
  Influencer & brand demo pipelines

  ✨ Key Features

  🖼️ Image-based virtual try-on (model wearing the dress)
  🎥 AI-generated fashion video
  🔗 Multi-platform publishing (Telegram, Discord, YouTube)
  🧩 Modular, extensible workflow design

  🧠 Workflow Architecture

  🟨 Input

  Dress Image** – Uploaded by user (Form Trigger)
  Model Image** – Downloaded from predefined URL
  Prompt** – Auto-constructed inside workflow

  🟦 Output

  🖼️ Try-On Image
  🎥 Fashion Walk Video 
  📤 Shared to:

    Telegram (image/video)
    Discord (image)
    YouTube (video upload)

  🔐 Required Credentials

  You must configure the following credentials in n8n:

  | Service  | Credential Type    |
  | -------- | ------------------ |
  | VLM Run  | VLM Run API      |
  | Telegram | Telegram Bot API |
  | Discord  | Discord OAuth2   |
  | YouTube  | YouTube OAuth2   |

  ⚠️ Community Node Warning

  &gt; Important: This workflow uses a Community Node
  &gt; @vlm-run/n8n-nodes-vlmrun

  What this means:

  This node is NOT installed by default in n8n
  You must manually install it before using the workflow

  📦 Installation

  Run the following command in your n8n environment:

  npm install @vlm-run/n8n-nodes-vlmrun

  Then restart n8n.

  📖 Community Nodes Documentation:
  https://docs.n8n.io/integrations/community-nodes/

nodes_used:
  ["n8n-nodes-base.formTrigger","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.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.discord","n8n-nodes-base.wait","n8n-nodes-base.set","@vlm-run/n8n-nodes-vlmrun.vlmRun","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.aggregate","@vlm-run/n8n-nodes-vlmrun.vlmRun","@vlm-run/n8n-nodes-vlmrun.vlmRun","@vlm-run/n8n-nodes-vlmrun.vlmRun","n8n-nodes-base.youTube","n8n-nodes-base.stickyNote","@vlm-run/n8n-nodes-vlmrun.vlmRun","@vlm-run/n8n-nodes-vlmrun.vlmRun"]

workflow_json_compressed:
  [encoded data, 4888 characters]

metadata_json:
  {"categories":["AI/ML","Marketing","E-commerce"],"complexity":"medium","use_cases":["Virtual fashion try-on","AI image generation","Fashion video creation","Social media automation","Product demos"],"estimated_setup_minutes":15,"required_services":["Telegram","Discord","YouTube","Video Generation Model","Image Generation Model"],"key_features":["Multi-modal AI integration","Realistic image compositing","Video generation from static models","Automated cross-platform posting","Customer-facing image uploads"],"target_audience":["Fashion marketers","E-commerce managers","Content creators"]}


name: Create AI-powered 3D product videos from images with VEO3 for Shopify
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-12-25T04:33:54.811Z
updated_at: 2025-12-25T04:33:54.811Z
url: https://n8n.io/workflows/12122
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who Is This For?
  This n8n workflow is designed for e-commerce businesses, digital marketers, and content creators who want to automatically generate professional 3D product videos from product images. It's perfect for online stores, marketing agencies, and product managers who need to create engaging product showcase videos without manual video editing.

  What This Workflow Does
  Accepts product image submissions through a web form
  Creates a dedicated folder for each product in Google Drive
  Removes background from product images using AI
  Analyzes product images to generate optimized video prompts
  Creates 3D cinematic product videos using Veo3 AI
  Tracks all product data in a Google Sheets spreadsheet
  Provides access to generated resources through shareable links

  Features
  Web form submission for product images and titles
  Automatic folder creation in Google Drive for each product
  AI-powered background removal from product images
  Image analysis for generating detailed video prompts
  3D video generation using Veo3 AI model
  Progress tracking with status checks and retry mechanisms
  Comprehensive data storage in Google Sheets
  Public sharing of generated resources

  Requirements
  Remove.bg API credentials for background removal
  Google Drive and Google Sheets API access
  OpenAI API credentials for image analysis
  Fal.ai credentials for Veo3 video generation
  HTTP authentication credentials for video status checking

  Notification Integration
  You can extend the workflow to send notifications when videos are ready, using platforms like email, Slack, or Telegram.

  Useful Links
  Remove.bg API**: https://www.remove.bg/api
  Google Drive API**: https://developers.google.com/drive
  OpenAI API**: https://platform.openai.com
  Veo3 Documentation**: https://docs.fal.ai

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.googleDrive","n8n-nodes-base.code","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.noOp","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.gmail","n8n-nodes-base.discord","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Z227bSBL9FUJPO4Da2/eLnzaTbAYGJuNBnGQegsGi+mYRlkmtSMXjCfLvW5Rsi5JIWzIWsA1ZalafrsupU63vkzJOziffVrPZjH24eP/NX1x+WpjJdHKbWpicf5+UVdNCFdJFty54BywpwZnRxmvBtBbScCsk48IkpaXnyhrwTHkjA1CwLnnKQQlpZdRot023izm06e0yxeYqtavF2xrfSW3CDdrlKv2YTiq4Tbjb1axelPm+EO+K35d1XIW2+FLGVBcf4CYti7ysb4uLW7hOTfG5Kavr4su/L0W3BVw3k/Ovf6KhOqbu5ffNMVMKATTjxESgRCJMYnNyxDsDVhqrmbKTp+0vq+J9vbwtrlb+tmyasq462/eL7rPKVmRtnHho0lnGdZ+W5fV1WuKaRd2Ubbf8/Cv6aSqZRih3yc/q+mbtRuMslUwmEpRzRKqciLNgiMyRRcYZUxI6O7BEJG1a4hG+/9js/QX/W5vmZ/zH9OFcQlLutZUka4H2TM4Esg9EOKqopBokp9tz/VJ+S8WbEFLTFG1d5Hoe17CHj3Zd19fz9G6JD+0eTVP7cLRncYonlErHANkkkj1YIlnSBKRmRAXFEXjMUsgeytRuglu8L+dpFF7Al7u4rJYjuNJfKazadInZvEm16WSZ2uX9ZfUeyvnjW7tenk5gfgf3zeWqXazad9AVxSZLH0/Fo9BKWwKJaowlz8QzoQlPNAFWRnbCbE/1eTGvIRYf022NQfj5l6Lsjni685lgfKq4Pd77UvPIVDCYGREzzSZPPIdEksxGcUpVBr3FidWJNYr5/7rcEHYsBiPogkrZ5oApqyLmBjWaWBUTiS5KzpA7MFu26B7ct0mPnyHcXC/rVRVHcc7advEx/XeVmnbPjdTaETfuJEuGebOfGrJfgEHpoGgklmpJpLPIKUkZ5JkEzhvjhWdb+BdVk5Zt8Vu6e+S1Fzx8NUupbfagMyqnQrzoY3mmnmAyHz2ABRJ8QJ5IyBhOKY+0oVzgNNIIqp+rscuBDeX+WlY3r0FpkSWclKegdOBT5NETF4ERqX0iwNCZmQceQWKL8XyXJ5b13T+an4qyKpoOw2twytFE2MNpnnBSZTnTVBLKQsaK4hxri1vCsqdS0hQS73nzzUXx5jpVPXD/QnT/3CKcQ3UdZlBWZ/CwrodPCj7FgNOX8PW7gvY+Y7sTBFNQESkCJ95AJAF7HYvOcpV6XeFdXVR1O8M2Ouq+qr5c7MLiFHFpw1+CxZ5AZRplcAJIBsAUBM2J0+g5ZXKKwVgTTOoVOizKOxgCtFx/crZ8XNAHJTTGkp0ACtuSC4oFAlxi+cZIkcOxKUvFQGHqycDCFtRVqmIBxS32z2e5+7ZrKofINu7qywHBWOLWScJ95kQiFxIrKfYRq62hyZuUj5AD2+MYYZONThHlMgae6UxsQnsMAvXADAPZY6Pf66Yt6urF88SyCfUyDpzISrt/Ii+MRmcSSrHLS/wPEXCHgkSAzNzgcV8+0Za2snSUBiBG6S4oBmWbC4x4nbD1Ar4JsReetgw398VvdZvY6GGa9aJuzX5CMxRs+oCvJqGu2q4qzyeT8TwCp5hVPhMnjeuOjRzGOCUaidfwFJEnXE9fLlL15uIIPpjfvp1Bu15e7tEComXcvdgEWI8WMkIMDKUv7dq/RLlOkAo4oQDCciwFmnv0+mm2Q/yjGNu6nj+u7QHEMjwS4NaLOvGsUuJYDhYBGukIspgnKOyioFRHnEF66QtL7KbFRp8dAbReL9w8dYVKLrQrnEQOpe2pbpWWOiM5OjNjg5XWeOxaLhBPmY3a06w477PtXbVWguvu+grhgorzuL66RYgjm0ycWhIcdgHJLeYp1mdHM3hYbrlwvex8O0vh5qH5X7XQrppXoEQhfFTb6sOUToSYhCAOlTWyockbMtbZGZGpoVn2OsSbCub3f6d9HT0e/oEq4l24j0DJzuy2ZTDmnBS2y09E2U1bQLGKvEYvgw1SadiiLPOo89Yf7Sh7KU9u9ZQygdHz6C4eUH8qQCnCgLAgvbJJamC+L5mqtIRuv4f4rnam59NibCk9OcTI3p5F1COcdRUOGtW+z5FkJhwkRoXXvUnwQYduZ6bPH399jcTTlh4n8bZSVIGkXlBB8IXqiroLMDYizo2Wxkb8hcHOc3LjYRh1nJpe13ciACoInEGZRF7vmAgpPeGolwzDdit11HQQJj8Zp0XBJ+grcaL8YCFYJEXeCRPngVjwlPAQBDiGP14P4hzPy3F/Kmzk9iAtj2zkGPPoNPJ4d0sjo1UonQ0Qj0okikR3OagHVJ4OVNOpcwdi9TicFFyWKgFRGctHQkRKjxbT1cWsrE4y5DyIU52OsxuV3aGqPg4ot1FppylRHn2JM10k0KEFA5AN40j4PYf+AWVbcDrece5wwUBDZCi29pQozQy3sJpklVGJconJJygOHcwHQzve1OYlJdoXJyKJLJzH+R6pFocq2slQbwjDmUpj+cUc/aDHzckeJ93QdzIn4GoIbXcj83hr0aS2RX5fP7q51cCll8vuYud88o11Nr5tnl97LGeGwjA5ooX23SUpJc6BJRp1mUB30kg7mYAgqhQ6U2vD2MbwL448HfKv39c3r8/onPXC6aSsYvprck4R9faZw+gfrP4TMW/UJm4K5X869bmz7+G0/bhq38yDCt/Y6XTCCoXEB7RyhMHd5fuWnx4ZcsxRPXjw3E/uGTL7nGobtNYb+4fs7Q/g+zamTyvHpuLxJ0YHz0Ggu0JvCOthiAYN7V5tDsbm+QvyQau7Y8gmm/qjxsvJtLP6MEw7dTSE+pnrukHEexfsg9F/6Z51PLjP3XEOwjmEP8wnh7dUw1E+LIQhe31hPmhn4Eugwbobvi8fdfz+jeUzAR3Rvc85cfeRwVoZHpuG8Q6WwzCpDX9nM4J18KuQMbujd7yDxscyd9jPz38nMxLEcf7+PxDzjx//A4ed5GWaHQAA

metadata_json:
  {"categories":["Marketing","E-Commerce","AI/ML","Media Production","Automation"],"complexity":"medium","use_cases":["Generate product showcase videos","Create 3D product visuals","Automate content creation","Enhance product listings"],"estimated_setup_minutes":120,"required_services":["Google Drive","VEO3 AI","Google Sheets"],"key_features":["Image to 3D video conversion","Automated folder organization","Form-based image submission","AI-powered generation"],"target_audience":["e-commerce businesses","digital marketers","content creators"]}


name: Estimate construction costs from text, photos and PDFs with Telegram, GPT‑4/Gemini and DDC CWICR
author_name: Artem Boiko
author_username: datadrivenconstruction
categories: []
created_at: 2025-12-26T12:53:12.303Z
updated_at: 2025-12-26T12:53:12.303Z
url: https://n8n.io/workflows/12176
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  A full-featured Telegram bot that accepts text descriptions, photos, or PDF floor plans and returns detailed cost estimates with work breakdown. Powered by GPT-4 Vision / Gemini 2.0, vector search, and the open-source DDC CWICR database (55,000+ construction rates).

  Who's it for

  Contractors & Estimators** who need estimates from any input format
  Construction managers** evaluating scope from site photos or drawings
  Architects** getting quick cost feedback on floor plans
  Real estate professionals** assessing renovation costs
  Project managers** doing rapid feasibility checks via mobile

  What it does

  Receives text / photo / PDF via Telegram
  Analyzes input with AI (Gemini 2.0 Flash or GPT-4 Vision)
  Extracts work items with quantities and units
  Searches DDC CWICR vector database for matching rates
  Generates professional HTML report with full cost breakdown
  Exports results as Excel or PDF

  Supports 9 languages: 🇩🇪 DE · 🇬🇧 EN · 🇷🇺 RU · 🇪🇸 ES · 🇫🇷 FR · 🇮🇹 IT · 🇵🇱 PL · 🇧🇷 PT · 🇺🇦 UK

  How it works

  ┌─────────────────────────────────────────────────────────────────────┐
  │                        TELEGRAM INPUT                                │
  │  📝 Text Description  │  📷 Construction Photo  │  📄 PDF Floor Plan │
  └─────────────────────────────────────────────────────────────────────┘
                                      ↓
  ┌─────────────────────────────────────────────────────────────────────┐
  │                         MAIN ROUTER                                  │
  │  Parse message → Detect content type → Route to handler (17 actions) │
  └─────────────────────────────────────────────────────────────────────┘
                                      ↓
           ┌──────────────────────────┼──────────────────────────┐
           ↓                          ↓                          ↓
  ┌─────────────────┐     ┌─────────────────┐     ┌─────────────────┐
  │  Text LLM       │     │  Vision API     │     │  Vision PDF     │
  │  Parse works    │     │  Analyze photo  │     │  Read floor plan│
  │  from text      │     │  GPT-4/Gemini   │     │  Gemini 2.0     │
  └─────────────────┘     └─────────────────┘     └─────────────────┘
           └──────────────────────────┼──────────────────────────┘
                                      ↓
  ┌─────────────────────────────────────────────────────────────────────┐
  │                    CALCULATION LOOP                                  │
  │  For each work item:                                                 │
  │  1️⃣ Transform query → 2️⃣ Optimize search → 3️⃣ Get embedding         │
  │  4️⃣ Qdrant search → 5️⃣ Score results → 6️⃣ AI rerank → 7️⃣ Calculate  │
  └─────────────────────────────────────────────────────────────────────┘
                                      ↓
  ┌─────────────────────────────────────────────────────────────────────┐
  │                      OUTPUT                                          │
  │  📊 Telegram message  │  🌐 HTML Report  │  📑 Excel  │  📄 PDF      │
  └─────────────────────────────────────────────────────────────────────┘

  Input Types

  | Type | Description | AI Used |
  |------|-------------|---------|
  | 📝 Text | Work lists, specifications, notes | OpenAI GPT-4 |
  | 📷 Photo | Construction site photos (up to 4) | GPT-4 Vision / Gemini |
  | 📄 PDF | Floor plans, architectural drawings | Gemini 2.0 Flash |

  Route Actions (17 total)

  | # | Action | Description |
  |---|--------|-------------|
  | 0 | show_lang | Language selection menu |
  | 1 | ask_photo | Request photo upload |
  | 2 | lang_selected | Save language preference |
  | 3 | show_analyze | Photo analysis options |
  | 4 | analyze | Run AI vision analysis |
  | 5 | show_edit_menu | Edit work quantities |
  | 6 | works_updated | After quantity change |
  | 7 | ask_new_work | Add manual work item |
  | 8 | start_calc | Start cost calculation |
  | 9 | show_help | Display help message |
  | 10 | view_details | Show resource details |
  | 11 | export_excel | Generate CSV export |
  | 12 | export_pdf | Generate PDF export |
  | 13 | process_pdf | Analyze PDF floor plan |
  | 14 | analyze_text | Parse text description |
  | 15 | refine | Re-analyze with context |
  | 16 | fallback | Handle unknown input |

  Prerequisites

  | Component | Requirement |
  |-----------|-------------|
  | n8n | v1.30+ with Telegram Trigger |
  | Telegram Bot | Token from @BotFather |
  | OpenAI API | For embeddings + text parsing |
  | Gemini API | For Vision (photos/PDF) — or use GPT-4 Vision |
  | Qdrant | Vector DB with DDC CWICR collections |
  | DDC CWICR Data | github.com/datadrivenconstruction/DDC-CWICR |

  Setup

  1. Configure 🔑 TOKEN Node
  {
    "bot_token": "YOUR_TELEGRAM_BOT_TOKEN",
    "AI_PROVIDER": "gemini",
    "GEMINI_API_KEY": "YOUR_GEMINI_KEY",
    "OPENAI_API_KEY": "YOUR_OPENAI_KEY",
    "QDRANT_URL": "http://localhost:6333",
    "QDRANT_API_KEY": "YOUR_QDRANT_KEY"
  }

  2. Vision Provider Selection
  AI_PROVIDER: "gemini" → Gemini 2.0 Flash (recommended for photos + PDF)
  AI_PROVIDER: "openai" → GPT-4 Vision (photos only)

  3. n8n Credentials
  Settings → Credentials → Add → Telegram API
  Enter bot token, save
  Select credential in Telegram Trigger node

  4. Qdrant Collections
  Load DDC CWICR embeddings for target languages (example for Russian):
  RU_STPETERSBURG_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR

  5. Activate & Test
  Activate workflow
  Send /start to your bot
  Select language → send photo/text/PDF

  Features

  | Feature | Description |
  |---------|-------------|
  | 📷 Photo Analysis | GPT-4 Vision or Gemini 2.0 for site photos |
  | 📄 PDF Processing | Floor plan analysis with room extraction |
  | 📝 Text Parsing | Natural language work lists |
  | 🔍 Vector Search | Semantic matching via Qdrant + OpenAI embeddings |
  | 🤖 AI Reranking | LLM-based result scoring for accuracy |
  | ✏️ Inline Editing | Modify quantities via Telegram buttons |
  | 📊 HTML Report | Professional expandable report with KPIs |
  | 📑 Excel Export | CSV with full work breakdown |
  | 📄 PDF Export | HTML-based PDF document |
  | 🌍 9 Languages | Full UI + database localization |
  | 💾 Session State | Multi-turn conversation support |
  | 🔧 Refine Mode | Re-analyze with additional context |

  Example Workflow

  User: /start  
  Bot: Language selection menu (9 options)

  User: Selects 🇷🇺 Russian  
  Bot: "Отправьте фото, PDF или текстовое описание работ"

  User: Sends bathroom photo  
  Bot: "📷 Анализ фото... ⏳"

  Bot: Shows detected works:
  🏠 Ванная комната — 4.5 m²

  Найдено 12 работ:
  Демонтаж плитки стен — 18 m²
  Демонтаж плитки пола — 4.5 m²
  Гидроизоляция пола — 4.5 m²
  Гидроизоляция стен — 8 m²
  Стяжка пола — 4.5 m²
  Укладка плитки стены — 18 m²
  Укладка плитки пол — 4.5 m²
  Установка унитаза — 1 шт
  Установка раковины — 1 шт
  Установка смесителя — 2 шт
  ...

  [✏️ Редактировать] [📊 Рассчитать]

  User: Taps 📊 Calculate  
  Bot: Shows progress per item, then final result:

  ✅ Смета готова — 12 позиций

  💰 Итого: ₽ 89,450

  Работа: ₽ 35,200 (39%)
  Материалы: ₽ 48,750 (55%)
  Механизмы: ₽ 5,500 (6%)

  [📋 Детали] [↓ Excel] [↓ PDF] [↻ Заново]

  HTML Report Features

  KPI Cards:** Total cost, item count, labor days, cost breakdown %
  Expandable rows:** Click work item to show resources
  Resource tags:** Color-coded (Labor/Material/Machine)
  Scope of work:** Expandable detailed descriptions
  Quality indicators:** Match quality dots (high/medium/low)
  Responsive design:** Works on mobile and desktop
  Export buttons:** Expand/Collapse all

  Notes & Tips

  Photo tips:** Capture full room, include reference objects (doors, tiles)
  PDF support:** Works best with clear floor plans and room schedules
  Text input:** Supports lists, tables, free-form descriptions
  Rate accuracy:** Depends on DDC CWICR coverage for your region
  Session timeout:** User sessions persist across messages
  Extend:** Chain with CRM, project management, or notification tools

  Categories

  AI · Communication · Data Extraction · Document Ops

  Tags

  telegram-bot, construction, cost-estimation, gpt-4-vision, gemini, pdf-analysis, qdrant, vector-search, multilingual, html-report

  Author

  DataDrivenConstruction.io  
  https://DataDrivenConstruction.io  
  info@datadrivenconstruction.io

  Consulting & Training

  We help construction, engineering, and technology firms implement:
  AI-powered estimation systems (text, photo, PDF)
  Multi-channel bot integrations (Telegram, WhatsApp, Web)
  Vector database solutions for construction data
  Multilingual cost database deployment

  Contact us to test with your data or adapt to your project requirements.

  Resources

  DDC CWICR Database:** GitHub
  Qdrant Documentation:** qdrant.tech/documentation
  Gemini API:** aistudio.google.com
  n8n Telegram Trigger:** docs.n8n.io

  ⭐ Star us on GitHub! github.com/datadrivenconstruction/DDC-CWICR

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.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.telegramTrigger","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.code","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 77008 characters]

metadata_json:
  {"categories":["Construction","Data Processing","AI/ML"],"complexity":"medium","use_cases":["generate cost estimates from text","process construction photos","analyze floor plan PDFs","extract construction RTOs","provide work breakdown estimates"],"estimated_setup_minutes":60,"required_services":["Telegram API","OpenAI / GPT-4 Vision","Google Gemini API","DDC CWICR Database","Vector Search Engine"],"key_features":["multimodal input processing","LLM-based cost analysis","integrated construction rate database","bot deployment on Telegram"],"target_audience":["contractors","estimators","construction managers"]}


