# templates

name: AI-Powered Facebook Messenger Chatbot with Smart Message Batching and History
author_name: Nguyễn Thiệu Toàn (Jay Nguyen)
author_username: nguyenthieutoan
categories: []
created_at: 2025-10-02T12:42:39.709Z
updated_at: 2025-10-02T12:42:39.709Z
url: https://n8n.io/workflows/9192
scraped_at: 2025-12-24 13:02:43
description:
  🤖 Facebook Messenger Smart Chatbot - Smart Batch, Format & History with n8n Data Table v3
  Version 2026 - Adaptable to n8n v1.113+ and v2.x
  by Nguyen Thieu Toan (Jay Nguyen)

  📖 Overview

  A production-ready, enterprise-grade chatbot solution for Facebook Messenger built entirely in n8n. Features intelligent message batching, session-aware conversation tracking, multi-page support, and natural AI-powered responses.

  Perfect for:
  💼 Customer support automation
  🛒 E-commerce product inquiries
  📅 Appointment scheduling & consultation booking
  🎓 Educational assistants & training
  🤝 Lead qualification & sales automation

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

  🔗 Complementary Workflow

  Facebook Messenger Chatbot – Smart Human Takeover, Auto Pause & Context-Aware

  Adds intelligent human agent detection and automatic AI pause. When a human joins, AI pauses for configurable duration, then resumes automatically.

  Why combine?
  Smart Batch (v3): Multi-message batching, spam reduction
  Human Takeover: AI pauses for humans, smooth collaboration

  👉 Access workflow

  ⚡ What's New in Version 3

  Major Upgrades

  | Feature | Impact |
  |---------|--------|
  | 🏢 Multi-Page Support | Manage multiple pages within one workflow |
  | ⏱️ Flexible Timing | Adjustable wait times instead of fixed delays |
  | 🔒 Improved Detection | More reliable identification of system vs. user messages |
  | 📦 Smart Delivery | Sequential message handling to avoid overload |
  | 🧹 Automatic Cleanup | Removes outdated records to keep storage efficient |
  | 📊 Better Context | Clear separation of past vs. current sessions |
  | 🔄 Ordered Updates | Ensures actions run in the right sequence |
  | 📝 Simplified Naming | Clearer labels for easier understanding |

  Architecture Comparison:  
  Previous version had fixed timing, parallel updates, no multi-page handling, and no cleanup.  
  New version introduces flexibility, sequential processing, and scalability for real-world use.

  🎯 Key Features

  🔄 Smart Batching**: Groups consecutive messages within configurable window (default 7s)
  🧠 Session-Aware Context**: Distinguishes old vs. current sessions for temporal awareness
  📋 Full History**: Stores complete chat logs with both user and page responses
  👀 Natural UX**: "Seen" marker and "Typing..." indicator for human-like feel
  🎯 AI Integration**: Extensible prompts for domain-specific consulting (Gemini, Groq, or any LLM)
  🌐 Multi-Language**: Handles Vietnamese (anh/chị/em) with customizable settings
  🏢 Multi-Page Ready**: Single workflow serves multiple Facebook Pages simultaneously

  Technical Highlights: Idempotent processing, timezone-aware timestamps (Asia/Ho_Chi_Minh), Facebook API v24.0 compatible, sequential delivery with rate limiting protection, auto cleanup (keeps last 15 rows)

  🏗️ How It Works

  🔄 General Flow

  Reception & Validation → Batching & Storage → Context Aggregation  
          ↓                      ↓                      ↓  
     Identify input        Store for later use     Combine with history  
     Filter duplicates     Apply short delay       Build conversation context  

                                ↓  

                  AI Processing → Delivery & Cleanup  
                           ↓                ↓  
                   Generate response     Format & send  
                   Add signals           Maintain records  
                   Ensure continuity     Clean old data  

  🛠️ Setup Guide

  Step 1: Facebook App  
  Create app, add Messenger, set webhook, get token, subscribe page  

  Step 2: Data Table  
  Prepare tables for messages batching

  Step 3: Workflow  
  Import template, set context, link tables, connect AI 

  Step 4: Test  
  Activate workflow, send test messages, verify pause/resume  

  👤 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, 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: 3.0 | n8n Compatibility: v1.123.0+ and v2.0.0+ | Facebook API: v24.0

  Ready to transform your Facebook Messenger into an intelligent AI assistant? Import this workflow and start automating today! 🚀

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.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.respondToWebhook","n8n-nodes-base.if","n8n-nodes-base.httpRequest","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.if","n8n-nodes-base.set","n8n-nodes-base.dataTable","n8n-nodes-base.wait","n8n-nodes-base.dataTable","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VYy24byRX9lQa3USn1fniTZPyYCBjHAz/ihWEE9ZSIobo5ZCuyYHiVL8gnBFkEQRaDbO1l8iP+k5ymLLFFdkuk7GwosVl969R9nHtuvZ+c5tZPHryfTOtl6+uYj9LkwcQIZa12VPrCGdVSFCmscNIrYTO+GlloDNIHJkpyMjlDqXLWSMuTVtxPDiZtPp3PfJsfLnJavsjt2fxhgye5zdigXZzlDweTukl5OXnwBruvdvU8iSwpcZwFIovIJBgpiU5ZO+asLYHBcu1PM1a/aKfxp4vqD02bu6ftxbx7WtuarMyS4Jf5cLla1K3BknmznLbTpsaO9IAYbd/imV/AXJsXy84JsanbXLewM/lwafKP+GX1CvtwcAUToCxVgSidDJE8JeKK1SRTWnx0FK6JgzD53jAZZ/orkAYRHUtRkMRc51ADpNoYwotAKI1VjuZBpGJvpJxT+xVI4TcmfNCEIcYEiVWwXUYmJONNCqqEIAaRyr2REkYNPxBC3w+pErqoLjW1R8wlPonnTJGcAufeGcPMMFJ1jyS9N0qpeEnBFMJ04vCn9SRkIwg1RsucStHGD6LU+/uTc/k15ZThNJG5INqipqQ3iDozmqhMteFaKavoGuoTH3Nomp+q1zmc4O8o3PPr32/GHli1BNIvv6/oLjAeVzFFrqGiCwXxJGaJCZIWg59o6mJ643CbB+KH6yOxyDVNihIWCnLEa0ZCFAhGosHZZAXnfSLLbfWw89S7dtz5ud04iebygGm66fNNWOJQXsNKYKicKPKBwt1gAI36KpmAF6ygNMWSbM/TzeLUt1VpFtW105+dtfOzcZQR/27QgqCAabayeMt71yBt4fCc8sSrnAAyB+IicqKYoJI2KvDs1iC/b5rjWa6+z6fTelo9PAHgpwAxW0P8LTD+eo1z5uvjeOKn9eHstFt+aeDy/Q3utfAwiP4u6Ouwl8Jz8iERS4MiUvpIgoa7YylCOc+kKaoHHWFnqqrzeV621aI5X+7hV9jiu4SfH0z87NxfLC8j98h3zf6y+17xmUnc6wwWYyAJaXwmzuOrE9QrsG9whq9BP8ozf1F9l9vznOvqaV4u/XEeB37up1221CCN5fXbjNLTZXU8/fzpF1/F//wtVu20ruqTzx9/qav//vXzp790nx//floFfDZVe/L50z+r9vOnf2/kllHwgeMbxWyFTio5QZhVEsXsOXHBe1IoQxEKFxVzdxUz6xezQc+UUpPAkYZSgZqC4omomJhkEbpH9Aj/h6aZV8/+nBfVERTQuGeW89m0Paq/8208WTnwykcrA+3Z54//qFdnrn4+890//6qPe37a8ITidpcqEz2GMjnamLveVaBh0ClsdMjcEjxISwqpwvpQYKcyXZzeybmLvJw3dXrZvB4kXyuB8k6Q7FCtYXJuvUiCgIIB0wlJAjOrWCoWUkzU9QTM0bIqi+a0miMnfzMKclo2YEmxWykdiqFiKn62zD2KzYp6aNbiPADbzNDMGPouqMtGI6CmeZ/5cz2K86Rt58/zz2dgB6xp6seLRbPAsq6pTuuz/Dwfn8384pqSe0eyUA78rvPIw3U6hKyp0yISbizaQ5QZ6WAdmCAlzrhGr7A3metkumybxUV1ekkBo6dIcNJLH2Zbwlbv1L5QiHcymGYU+qZQkh1FW4vWEGSwIUwwEyNkrr/p8zpVLy/m0/r4/+F65rTd0/kawpdbaARlINWliY5Yi94XHEaL4NBQ+gz846KJ8Dm4d3Gc0xUF79DvsKreAsvpCG8scru4eFY/8dPZpbu3dAUC09H7l17wcjHt6Avcvm6HkE/BaEps4iBOTiHsvHeEhpIEQ5wwLG7G5TYNdDMqffpzRn9pBDs7vWjFTHCZUNcNHMEHEqwWJFAmUseMQfd69as58jhXP8KH1fM83zfbudMUUuJbJHtJRXvVaQwpoDGCQrInSEueTOTUREg5uoX7ye9+ePG4apvq5fNXj/cGb4T+RuC15JjkjEOlmk7qW+hszzWxTOjoY6DayRt0fhe7bHH5ZYvZhcvXAohHcB8GzgQpRCTj4D6WFQFv5EC5ZVr10vTVEq19uqy6dM2LPfR6Nx/vqdddxvRObVc2AUoG7YP4CJK2KbKgoGS07EnhoxrQ2uplU72q55ckkdO+wUbn2I2V1yC5E5bmTkl0cguiCO7DIE+lp5i0qaCsdxvy+lIQ3qoW+7lnr5x2Y1yDdDEMPUpF5qDwCtSq7nquDZ2SzTGVtI/Cc0wXMGFEOZXUKbxOMUZFHIcpbrlQpdzsfmdrD9+3A0qn93a1T0yFrr0li/JhJXZSHZmarA4SvvLM3cT51L+rjh5Vv+p3iz2mDMN3Sof18MapE4WCk4zJ3SAt4UQBDZSUAzdp1H7/2gEFfglwd7Hm2K5aba1tUjQ6JlANd2hDUibinc4Eo6SGqlTInx7prBxV/f6LuvHoSU+m+Hg6rY8e7TOf6d0q6e75LGtNZexGYSmhDjRaaaCQZrzYGEVi0P49+A9n2ddX8PdNScEwUH0jphfCZ+1Ud9WAVI3I0iCgzlQ2kqLBmph7qHv3T/e8zrv/9ZNTGn5EjoaUu54EveI5Kita7SJNvLuGGkRq7gFV8fvclGE1fq9z7Oyslq9oFH9PIexg+M371VX6LuS0euNggpzO7yYP6Ie3b7HfWnsN2RwdaQdt9Yp6DODo7LBl8ODNlc2rtUM2By/QRg66XjlkaWSCHDtob23PGlBfGxyTC4MWNxYPH7U/MW5aOVgf5HYxMLj9ZpyH9r9dUA7E7/rNu26Ohj2yobuHII1Q3qC9rdvjQYNjtx23HW/nlw76ybZbeQ7cFA7h3q11je6wWZVj1Tt2Z3lbAG/myy2JtT1hDdfeYHoP2b0pOAeNjWTmcPltDamDJkeG9CGTu1yzj8ZsiOrH4na7FhzdYvC1Ee7cUnPDVsfu7GHVT//U3Vic4SBfnvV2uOvqY+vlrfIf9/XXN75by288mTZuosbp4q7TD4D68OF/Onv9aOAfAAA=


name: Automate Video Voiceover & Subtitles with Whisper, OpenAI TTS & FFmpeg
author_name: Lenouar
author_username: aureusr
categories: []
created_at: 2025-10-02T15:07:53.929Z
updated_at: 2025-10-02T15:07:53.929Z
url: https://n8n.io/workflows/9197
scraped_at: 2025-12-24 13:02:46
description:
  Automate Video Editing with AI

  Who’s it for
  This workflow is ideal for content creators, training providers, agencies, and businesses that need to quickly turn raw videos into polished, captioned, or narrated content — without hiring editors or spending hours in manual editing tools.  

  It’s especially valuable for those who want full freedom of video editing capacity on their own platform instead of relying on costly SaaS tools with heavy limitations, recurring fees, or watermarks.  
  With this template, you get enterprise-grade AI editing self-hosted in your n8n, under your control.

  Perfect for:  
  E-learning & educators** producing accessible multilingual lessons  
  Corporate trainers** automating internal tutorials and compliance walkthroughs  
  Social media teams** creating captioned, high-engagement clips  
  Product teams** generating quick demos and explainer videos  

  How it works / What it does
  This template combines AI transcription, TTS voiceover, and video editing with FFmpeg into a single automated pipeline:  

  Voiceover Mode**  
    Transcribes video with OpenAI Whisper  
    Cleans text using on-screen frames for accuracy  
    Generates natural AI voiceovers (EN/AR) with OpenAI Speech  
    Re-times the video to match the narration → synced professional dub  

  Subtitle Mode**  
    Merges multiple video clips with FFmpeg  
    Transcribes or translates audio to generate SRT subtitles  
    Hardcodes captions directly into the final MP4 (style customizable)  

  ✅ Output: a ready-to-publish MP4 with AI voiceover or burned-in subtitles.

  Requirements
  n8n self-hosted or cloud instance  
  Server with FFmpeg installed  
  OpenAI API key** (Whisper + Speech)  
  (Optional) Google Drive credentials for delivery  

  How to customize the workflow
  Swap voices in the OpenAI Speech node (change “ash” / “verse” to another).  
  Add languages by extending the dropdown in the Upload Video form.  
  Change subtitle style (font, margins, background) in the Apply Subtitle node.  
  Route final videos to Slack, Notion, or Dropbox instead of Drive.  

  Why it matters / Benefits
  ⚡ Save hours of manual editing — no need for Premiere/DaVinci for basic voiceovers and captions.  
  💰 Cut production costs — avoid hiring voice actors and editors for every video.  
  🌍 Multilingual content instantly — create English ↔ Arabic versions without re-recording.  
  📈 Boost engagement — subtitles increase video watch time on social media.  
  🎨 Professional results on autopilot — clean transcripts, natural AI voices, synced visuals.  

  💡 SaaS vs Self-Hosted  
  Descript, Kapwing, Synthesia** → $30–100/month per user, limited exports, watermarks on free tiers.  
  This workflow* → one-time template + your own server, only pay *OpenAI usage (~$0.006/min for Whisper)**.  
  You get unlimited exports, no restrictions, and full data ownership.  

  What you win buying this template
  A ready-made AI editing studio inside n8n.  
  End-to-end automation: upload → AI → polished video.  
  Works for solo creators and agencies delivering client-ready assets.  
  Scales with your content: handle 1 video or 100, just drop them in.  

  👉 By purchasing, you get:  
  Full workflow JSON file.  
  Email delivery with setup guidelines.  
  Access to a step-by-step walkthrough video.  
  Contact Us** via services@quantumti.ae.  

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.formTrigger","n8n-nodes-base.set","n8n-nodes-base.ftp","n8n-nodes-base.ssh","n8n-nodes-base.ftp","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.ssh","n8n-nodes-base.merge","n8n-nodes-base.ftp","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.ftp","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.ftp","n8n-nodes-base.ssh","n8n-nodes-base.ftp","n8n-nodes-base.formTrigger","n8n-nodes-base.code","n8n-nodes-base.ftp","n8n-nodes-base.code","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ftp","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.ftp","n8n-nodes-base.ssh","n8n-nodes-base.ftp","n8n-nodes-base.googleDrive","n8n-nodes-base.ssh"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VZ21IbSRb8lQk9q9i6X/y0DGYi5oFlwoD9MOGHupzCigGJQWJnvA7+fbPlixpRTauJGD84CKGqzj6VJ09m8WV2S5s4e/NltliuN3GZ6dcyezPjOrusqnBaeSWE16SjpRKrqIHbkmLi2WmTc/DJx6qoOmt5SlTJ6Zz0bD7b0O3dTdzQyT2V9QVtHu5OVviENoQHbO4f6HE+W64KrWdvfsfTu6cKYXQyZBjXWjItrGeBZGZV1uRlClXJhJ2X8Zbw7YvNIv/x+af/rDbUPe7zXffh0i/ZdleW4pqO1tvvfPvK3Wq92CxWSzyQCavkXBivP+LzeI8dN3S/7uqQV8sNLTfYa/b4ddv3+M12mXicf0MaKWZfbWIuesW0N46lEgVzwSZuQhDKtpHKyVCFtXoujX0dUArGBZcN8ypqhlM1LFGQzEmyRXldsjVNoOKVNfX2lSVVJAwXPrJIqKuuyrHgRWU1V26UjSKI2ESqXon01TXNUUqbqmA5GtXR1DHvbGTW6xisUlSE3CH9dYnHxpvF/+inX1Y3pXvQEN7buHyIN5f3i+trut+DbIKcGyH3EQ+jlMnE6GpmUdSKk8ehh0SRCbKeV8po8B5F3w0Xcf1pDwpoMw2KJhUNKsZc1806g46BsmCKc+cKN9ZVv4NycvbLBDBial2qVVlFa5kr0jBtJbEYBQ5TVGNcCiWq0ANzMQWLnQYlcx4Uj5VxlwPTJQgWs9UsuRpk5qbayndQrt4PQqmr+9s2bSz382A5MP1F6dNq9cdW3n20KarMWfFcoAb4yWeuGAXnwGLLS+wYvP8a9Dflhw2dY0p8lfC9N5NHaj6LN3/Fz+vzh83dw+Zt7GZLjTdr2vHSBS9lyKwEBTKkAG3iCkqvs0FTFZf6In8yXH7aNHj59V1frL860jvR4UJE7QmtYXRHhsA8ecu4rVqim0WppSc6Lx3B5q7BzAPg7OjghK5FRsMqaoGhktG72mGyYKCEKHxQrqeAp8fTmDkJSrVo2WQSixySob2sLHmdugrZFDCSlOox8+LtMJZndRH6oFPqYamgI6fEiFRhWnLLogN1pAJZMxwHpHGH5cPlIJRPm83dO/rzgdZ7zFGSHwJJH8kdcXQpWRIxwYVj2nHPooeuGRUiFR+y6RuAD8MqkvHjUzTaH4Rmh0Uop6RLHkfEofTVgjc1Oqa0UhbIhOwX6HSCulp9EJTeEDfS+Owkni04lN5kliwOTCifsiGMxtKzG2fDk5Dur/eHdtfenRUd7+9daawKJXMHdc/CQmGzZqFrchtc0ZFDB43v83i4Nu3+PgRPj8lOGOVLYeQIeu+tZCk4dJXiKggUGrB2aI57YP4NNP/aIbqJy+v8KS6WR6s7Wh4vnnf7QcCO/A9oKXInLUk0GSwYACUWjJSswNk7FVRUsieE74ab7Dmfu4Y/BE6vuRAvIL7EMAPpKxhflWY8JOdrkvALeQfmfLi5Xuz4QzD1W55E5CqjOrxynB7B8cWUCrMSxqG4qO3Win4fXMOjot3y00qEaCaQxwqTutMf7xR8s+csB7AdcUSEqp8MrmE//4zZXddPI3aqyRKnykrhmFyIaYhDxbDsCXhUlFR6nupsGEur7zs2a+6ntH1FCENJYCocbK+2hrNOkRlBmiBPBszuTdKfh03GAJsPgCP7hhPmIndjPXepliOCwWsynmXh0qN2mp4c1XBGfHZUWx4fgKbnxb2r2kF5nIndPFeKhQAWF6EN51EKSnWH5nJYop8Niy2JJ2HJ0YrqXWGYE6hMrRiiEglVdPcISSuXSu2r8wT3teXwNDCKpLAeukcKuUAXeOKCXGA5Qf/gwYCpZ8bPXuPGuxAn3DM7LkJCSBORherQPoY4jF+JjGJVniOpJ63/KTuegsc/7Vn1CWfAOWJiRSiIhjREXyWIce8MJnQKU9Z/f9sDW4VctiJLhxhUu2QdOleFM4iRZMop6kT+SasMZ//n81ryw+D05rVEYPYIiB6ZEM5TGPjhBEqomIN2Cs60JyMn51OK06napNpIDBvjFEd38C63koWMCMLAzqYQskOIPfPwAj2fNe5W0iYVphirCniK0Axphc1MXWYlFEY5iThpKPfcwunxC5dJ+2C2ijYJjNLwUDnBKCR4YK000lypELiChInO0lE/zSoTRuFW0yahCT6KYqNiXBMoDB1i3mT8ZLLwwqaaba80Hy6HwQyal622HQCqb160dU4mJaDzsqtUcAi6pbuwlNLEUL2yPfPy2/B10MBEDFPMS3GSOFfElOqC7vbKo5JjJLkz2Tmu3JOJOKw67YF4AJhe6oa5jUhQ0AeLiFCdZV4YzUikgoolcKvnpI4n3AdtyTMJC+J+ChW5X8YMLBEp11fHWTFelUzahtwvzNvJrm4SmpqJjEbwDskiV8oCzvAgmJEiKmsh1ln0b2RX9/R+UWg1iOl6tbq+obf3i//uU0h2t/FOj2e7H+CAJDuLXvcumE6CMiyeVxixlGL0LuHjnjbfUFxe3U3RxO20GEckHvGNvFouKXdLt7fIJ91/t4hn2Oj3L9u/cuzfHm1/O58tloX+nr3hjx8/YuOz9rp+Km2ue9dc9+QetbnuYginGlmIaNpa2Y+FzXU/D1ZGjqzEcG2tPBsrKWLYwBPFyMrT44HTOB5b2C7O2dAy8e3wRXNZP5y0SdN+wydDt7nwvH38J2Ml/a1Ntycy3abpZbswLwCd//jW+djul0PdM/Y+V+0CjtX9Q7t8py803XycDN83b5fqw1gRup5vvszYwo4uA3Qf41HXEU2wY2rQCVtr4fGobr0d6OrGCGpvcNU+vOOxMl0MkOV0TBSuBtp07IGdQWyt6zu0oVNpr3xiOYfKO0CGw+s7sMNwr4sfK2Vz5eVYy2zHVpP752Mrd6/VXL/vHZqbNP7M2xyRL27z+Ph/naNNbpAhAAA=


name: Automate & Publish Video Ad Campaigns with NanoBanana, Seedream, GPT-4o, Veo 3
author_name: Dr. Firas
author_username: drfiras
categories: []
created_at: 2025-10-02T18:13:46.700Z
updated_at: 2025-10-02T18:13:46.700Z
url: https://n8n.io/workflows/9200
scraped_at: 2025-12-24 13:02:41
description:
  💥 Automate video ads with NanoBanana, Seedream 4, ChatGPT Image and Veo 3

  Who is this for?
  This template is designed for marketers, content creators, and e-commerce brands who want to automate the creation of professional ad videos at scale. It’s ideal for teams looking to generate consistent, high-quality video ads for social media without spending hours on manual design, editing, or publishing.

  What problem is this workflow solving? / Use case
  Creating video ads usually requires multiple tools and a lot of time: writing scripts, designing product visuals, editing videos, and publishing them across platforms.  
  This workflow automates the entire pipeline — from idea to ready-to-publish ad video — ensuring brands can quickly test campaigns and boost engagement without production delays.

  What this workflow does
  Generates ad ideas from Telegram input (text + product image).  
  Creates product visuals using multiple AI image engines:  
     🌊 Seedream 4.0 (realistic visuals)  
     🍌 NanoBanana (image editing & enhancement)  
     🤖 ChatGPT Image / GPT-4o (creative variations)  
  Produces cinematic video ads with Veo 3 based on AI-generated scripts.  
  Merges multiple short clips into a polished final ad.  
  Publishes automatically to multiple platforms (TikTok, Instagram, LinkedIn, X, Threads, Facebook, Pinterest, Bluesky, YouTube) via Blotato.  
  Stores metadata and results in Google Sheets & Google Drive for easy tracking.  
  Notifies you via Telegram with the video link and copy.

  Setup
  Connect your accounts in n8n:
     Telegram API (for input and notifications)  
     Google Drive + Google Sheets (storage & tracking)  
     Kie AI API (Seedream + Veo 3)  
     Fal.ai API (NanoBanana + video merging)  
     OpenAI (for script and prompt generation)  
     Blotato API (for social publishing)  
  Prepare a Google Sheet with brand info and settings (product name, category, features, offer, website URL).  
  Deploy the workflow and connect your Telegram bot to start sending ad ideas (photo + caption).  
  Run the workflow — it will automatically generate images, create videos, and publish to your chosen channels.

  How to customize this workflow to your needs
  Brand customization**: Adjust the Google Sheet values to reflect your brand’s offers and product features.  
  Platforms**: Enable/disable specific Blotato nodes depending on which platforms you want to publish to.  
  Video style**: Edit the AI agent’s system prompt to control tone, format, and transitions (cinematic, playful, modern, etc.).  
  Notifications**: Adapt Telegram nodes to send updates to different team members or channels.  
  Storage**: Change the Google Drive folder IDs to store generated videos and images in your preferred location.  

  This workflow lets you go from idea → images → cinematic ad video → auto-published content in minutes, fully automated.

  📄 🎥 Watch This Tutorial: Step by Step

  📄 Documentation: Notion Guide

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

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

workflow_json_compressed:
  [encoded data, 18824 characters]


name: AI secretary for scheduling with WhatsApp and Telegram
author_name: Thiago Vazzoler Loureiro
author_username: thiagovazzoler
categories: []
created_at: 2025-10-02T23:06:36.380Z
updated_at: 2025-10-02T23:06:36.380Z
url: https://n8n.io/workflows/9211
scraped_at: 2025-12-24 13:02:42
description:
  🏥 AI secretary for scheduling with WhatsApp and Telegram

  &gt; ⚠️ Community Disclaimer  
  &gt; This workflow is community-maintained and self-hosted.  
  &gt; It is not officially affiliated with or supported by n8n GmbH, OpenAI, or Google.  
  &gt; Users are responsible for their own configuration, security, and data compliance (e.g., HIPAA, LGPD, GDPR).  
  &gt; Always secure API keys and ensure compliance with your local privacy regulations.

  🧠 Description

  This template deploys an AI-powered virtual medical secretary that automates appointment scheduling, rescheduling, and cancellations for clinics and healthcare professionals.  
  It seamlessly integrates OpenAI for natural language understanding, Google Calendar for real-time booking, and Evolution API (WhatsApp) or Telegram for patient communication.

  Patients can chat naturally via WhatsApp or Telegram, receiving empathetic, professional, and human-like responses — while your calendar stays automatically synchronized in real time.

  💡 What Problem Does This Solve?

  Managing appointments manually is time-consuming and error-prone, often requiring staff to handle repetitive tasks like checking availability, confirming times, or rescheduling.  
  Traditional systems lack conversational capabilities, forcing patients to call or text staff directly.

  This template solves that by creating a conversational AI assistant that interacts with patients through familiar messaging channels, reducing administrative workload and ensuring accurate real-time scheduling through Google Calendar.

  ⚙️ Key Features

  📅 Google Calendar Integration — Real-time synchronization of consultations and exams  
  🤖 AI Assistant Powered by OpenAI — Understands patient intent and replies naturally  
  💬 Multi-Channel Support — Works with WhatsApp (via Evolution API) and Telegram  
  🔄 Automated Workflow — Handles booking, rescheduling, and cancellations  
  🏥 Healthcare-Focused Design — Tailored for clinics, doctors, and medical secretaries  
  ✅ Customizable Responses — Modify prompts, message flows, and confirmation texts  
  ⏰ Reminders & Follow-ups — Reduce no-shows with automated notifications  

  🧩 Setup Instructions (Step-by-Step)

  Obtain Required Credentials:
     OpenAI API Key  
     Google Calendar API Credentials (OAuth or Service Account)  
     Evolution API Token (for WhatsApp)  
     Telegram Bot Token (if using Telegram)

  Configure n8n Environment:
     Add your credentials under Settings → Credentials.  
     Ensure your n8n instance has internet access to the APIs.

  Configure Node “Variables Config” & Update Nodes:
     Set nm_Clinic → Name of the clinic  
     Set nm_Agent → Name of the AI agent  
     Set ds_Address_Clinic → Address of the clinic  
     Set nm_Health_Plan → Name of the health insurance provider  
     Set nm_Evolution_Instance → Name of your Evolution API instance  
     Set nm_City_Clinic → City where the clinic is located  



  Customize the Conversation Flow:
     Edit OpenAI prompt nodes to match your clinic’s tone of voice.  
     Update Google Calendar event templates with your preferred titles and descriptions.

  Deploy and Test:
     Test both WhatsApp and Telegram channels.  
     Verify that appointments appear correctly in Google Calendar.  
     Review conversation logs to fine-tune the responses.

  🚀 Suggested Use Cases

  Ideal for:
  Clinics and medical offices wanting 24/7 automated appointment management  
  Healthcare professionals reducing manual scheduling and follow-ups  
  Multi-channel (WhatsApp + Telegram) patient interaction  
  Reducing no-shows with reminders and confirmations  
  Clinics seeking to modernize patient communication and optimize staff time  

  This assistant ensures every patient request is handled naturally — while Google Calendar remains the single source of truth for scheduling.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.switch","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-evolution-api.evolutionApi","n8n-nodes-base.stickyNote","n8n-nodes-base.telegramTrigger","n8n-nodes-base.telegram","n8n-nodes-base.dateTime","n8n-nodes-base.wait","n8n-nodes-base.set","n8n-nodes-base.splitOut","n8n-nodes-base.webhook","n8n-nodes-base.if"]

workflow_json_compressed:
  H4sIAAAAAAAAE61aaW8bRxb8KwN+WGQBtrfvw192aYmxlVgHTDrZIAgWfcpEKFKQaDuG4f++NdTBkTjDK7ZggJJm3lS/fq+qXo++9iap97L3Kf12MZ/lcz79ko4HPy96/d5VXvjey6+9yex24Wcxn9TXOeusjjJFGmTgvriSqNY6cSWLDZZmnXXgVMrMiygi5xSN5pI754oMKve+9Xszf5UR6jSnSfTTanB9PZ/MFld5tqhG8UNOH6eT2WU1uL2d1A9eVJ8niw/V+XWeDU761ev5/HKaqyM/zbPkb6p/VKf59tZfLm+5vr4F8IW/vO29/P0PPGmecv3x690iqafeGuaIiEkRyakngblMXEjKmkSt9qX3iG+0mMQ/v1Rn80VmddQv1/VPZ3ZGlmFJ8Lf5xe3yovoaXHI9v50sJvMZnkiYs7LPuAWKa3+DiIt8c1unM85nCywVoepc1FF/wW+Wd7Fv/XukJibpkmYkFpOBVGcSZOREGmZZLiFKE1qR8kOQattnlB4IlUqtQ+GK5KwYkZYH4jnXxNOUs1CMaelaoYoDoCqh+87xw5C6wIyWPpEiuCAyZEZCdo5Q40y0wUuXG0gfK2xwUg0u6+CPcP8DvP9aYZ762WX84CezF/7+ujXMah3zGs4XZpVT5YSPxhOjtCGySE6czIZE5DPnolxktjWn+6dUWMP7ktLDUmptpNpit6l3kkjlOQmUUZKy1U4V7fiyIu+Bvhsen4wqUh0PX52/Pzsa4uNoOO7EfAOCuH0OV0vbt0xvzeYjRAG6cjQVEmJJqE9niC/SEM14Kko4UJjcCPH1vhA5IOr1duqGKHXhyWRHVJSeSCc48UoVorzXPpTAkMeNEI+Hb4fj4V4oORDuVJaPKH1mXEqBRq9zKLMFJ/GsSQgx5mCMA+OtUJ6/+ml4NK5OR6+B7+j87GgwHp4NNoCM+Pgco9A7YeSPGItn1FqQkWI0oHGUI04wTpiR0cUQlFGxtXHMAWTE/g4ZKVq4VxyNTSW0yBtGvBeJGOirYYVxkOgK6S+DdyeDV2+Ho7tk/njyuhtvfs5Amjrdt2JrGsULueLKlLhgPhDtCuAlKxAdFarrVuKhFCtzI5GTq2uI8mm+mt982YEnr5YXvvpYSr75dTJL88/Pcysl7TO5QxO9ECsyclpSbgP6xlAiY44k6FJARspaBfIHIzUKdGkoqqMPflGdAt90B9zTq/ry5Z2T54ithYoKvUak64hX5ep0NkEl1KcNKNeoFbTTCNA+LFOWUAHdrp1y73Kl/QMpngsYu5gCoS6nmuIdOp4XYhOF98s+leAbqvkhxz8fbFy3HF0uXdyDxI7n8+nzdFIO+yTMdqJvFACXIQkTNPwdMilN0cQ6JNblAnICexnakM2jm+wXuWk/D4dr7P5osysBq7REMjgRaRKESbFAorHR+6Ckd6xpR2DBp98HrdJ0b7Reg6ysKYSbAqXXqFIrQyEaZUATOk9lukL7ZjCqxienw+piMBoNj//dXa4w9/HDc94Hq+6ioKLRSjxwBg8CN2dNRDbB/BYtRKIFNBZCyb69lez+zK+50n3p1vK3W0MFDaNskb/AOHQ0MlgTVgSJPtLsFFfcNjJ59GZ49HN19GZwdjZ8u2ca7U7qKRq7zKQKnqHZhcyYO1KBfkaXCIfA+8SEtB36qQ4gJMyFB05HMlrGiiEcLgTaadE5dftEKiiL+OdMg+jfnp9fVKfD0WjwuvZKv74ZjEeDi4tuwNfTyeJk9sojo/mZbVKM9/kOhfkIFYaOWeGxu9IjoQX77JIyJFGMH1FkwYzphDqGrXv9bnB6EFQp+C5GeQUVYpyYZhiKlAUfeRkI5mL0UjYwUzrkWBqO5AFbbUi2Fee6I3FG9yFy+zgSxtElVGHUKBTTW0E6PfoQZl5h3x31OjTI/WGXD4dXK9A++IQMymnMPjwihzIpC50MifhAvc3Uhqxls633BqUAysodSHGFSYfEnJMgGB7hL3I0xHpvCEVFmiS1TLSLajYcebRxjeJ1ue3iMVcF5xRzKYBnWKJ1wemI3nCWZG6zEE7FEhqHHE8GCmzvaLypiVumCanB2vi/+zShYb8wHmeSAofmGYtqM4GSyASFxywRXx0At7ZuF8C2g5huhDZJRRlkznJZH764QCxmHcw7FL7SU2FZakO4R91J8N1ORNKouyQxPcTI65MgwKJoA2tphoxYlUTxJqqGZxwNz44fWW8TPedP8+nHGhfx15MXj98Nrp+ZcQwCfbGdXRrHGNJJGgP2OElIMmcwjthiQiU6xYC/edGtsuf2Nw8KM0Jf2AOlrxjOYyqUOIa9hs2RBNAx71rOQhGJW9HY8HGe5ks8oxrfTC4v800n2sX9havrnrhbCTN+1zmfc/gwn/+5PAumDhSZYGCZQ8lJYQykg6JHZKQe5OKDqbHsPg2VYCIXnnBvIeu0PvWKAmylHbw7aLTY2FE1W9vtYYHrheKWI1tzXR5qB2fhMZoLTmQAdVoeIdwUlBmtzyHGfdYlDCZ9nw0pKH+sK3oSnKg3rhRNC6cuNZTreDAeVmfnv3YuJWFqGU+u1urKcLsLAzdwYZMcCoekYpDvBKKzwtRnJz4JFpURSTQUdXAyvvP0pFLVaHh0fnY8ejyE6kT72U+eMwqvp6U7pM20cx11BGkRk+CSpHEaRV5TbqSR02J85nJ72htNzZPj2nASg69PWDANBqU5MUGIwrWu54JGOV28xfrej4bvHovqh5Ozi/fjf+7BlVjUbo57RZXWYGpJtD7lxSAgM1OYrLUkmsF2FQrLXRqbcA9tVJ2cjc+rn0bnZ9Xg3bvBb5sd4vnH50BrL7HX4R91cNUZGmOjgyVkyCPaUZAcvJSaG+dFozfns2qWP1dXyzczufph+EDV3cm8r4Q25mF0jXqSDBqziCDKYYMlLDWAKZSurF8zpZIyVdtqhTdqxaQIa44oJtfnhlxAsBJkNUiELY4LGxq0evJjNfzvyWj8UCmdi5qUp+vRkvbBZVtbFOSBa3xcTD4havHT29zvodwWk9nlUivyXzkuE3p+k0DXL3ufWC0an+4i3LGYzSFFuOQoYEUhcLDzlEdiS+IYQdEBud4xqM4sxzrUMvCDL8XHKz+pMf/+dfkabcsh5PLifm8yS/mv3kv67Y8/AOeRytqidbnN1kgN59IWa9uLhdaYTyfrtrBbJ8e1uP3Om9cVqhXU05NUgPKT/13df9NMXvfLqdUNGxfMWle8xWRvWu8W+9u+BU9PC++Wu6gPrHZf7OLufOtp4LXzpx2r5vmLlE0L3lUQW1e+RiFtALdYnO9ffWt+sQ3Vpsm/fZfX9q91sTsIcDs3rB3k39VRfWz/EfJz/7OdC+rpfeuLWTuH/X5l23Ik/f2Ct+xbOy/vsqctWtAWbN3MtkZrOa05HFo7EW1mu31CPtLi3wrZ3ts7qNCuQtI6VH8flavjd7wob3tA98uAXSOPOiJve1vfGr8rn40HNJm02+ztEr0t883oW84+Wh/ROQRstVn7lHnznX1r4G4G2nVb79V2qxFp/fOB9qrvFpG2p2wfp1qfsmG8aXvKprPodjrc7Cy+Uyd8+/Z/Tn5T3fwnAAA=


name: Extract Contact Information from Business Cards with Mistral OCR and GPT-4o-mini
author_name: Wolfgang Renner
author_username: naviqo
categories: []
created_at: 2025-10-03T02:42:30.216Z
updated_at: 2025-10-03T02:42:30.216Z
url: https://n8n.io/workflows/9212
scraped_at: 2025-12-24 13:02:41
description:
  🧠 Business Card Scanner – Automate Contact Extraction

  This workflow automates the process of extracting contact details from business cards (PDF or image) and saving them directly into an n8n Data Table.  
  No more manual data entry — just upload a card and let AI do the rest.

  ⚙️ How It Works

  Upload the business card via a web form (PDF or image).  
  The uploaded file is converted to Base64 for processing.  
  The Base64 data is sent to the Mistral OCR API, which extracts text from the image.  
  The OCR output is parsed into JSON.  
  An AI Agent (OpenAI GPT-4o-mini) interprets the extracted text and converts it into structured business card information (e.g., name, company, email, phone).  
  The Structured Output Parser validates and aligns the data with a predefined schema.  
  The workflow upserts (inserts or updates) the contact details into an n8n Data Table named business cards, using the email address as the unique identifier.

  ✅ Result: Seamless digitization of business cards into structured, searchable contact data.

  🧩 Prerequisites

  Before importing the workflow, make sure you have the following:

  n8n Instance with access to the Data Table feature  
  OpenAI Platform account and API key (configured in n8n)  
  Mistral AI account and API key (configured in n8n)

  🛠️ Setup Steps

  Import the Workflow  
     Download and import the JSON file into your n8n instance.

  Create a Data Table  
     Name it business_cards (or adjust the workflow accordingly).  
     Add the following fields:  
            firstname
       name
       company
       jobdescription
       phone
       mobil
       email
       street
       postcode
       place
       web
       
  Configure API Credentials  
     Mistral OCR API → Add your API key under HTTP Bearer Auth.  
     OpenAI API → Add your API key under OpenAI Credentials.  
       Model: gpt-4o-mini (recommended for speed and low cost).

  Activate the Web Form Trigger  
     Enable the trigger node to make the business card upload form accessible via a public URL.

  Test the Workflow  
     Upload a sample business card.  
     Confirm that extracted contact data automatically appears in your Data Table.

  💡 Example JSON Output

  {
    "firstname": "Anna",
    "name": "Müller",
    "company": "NextGen Tech GmbH",
    "jobdescription": "Head of Marketing",
    "email": "anna.mueller@nextgen.tech",
    "phone": "+49 821 1234567",
    "mobil": "+49 170 9876543",
    "street": "Schillerstraße 12",
    "postcode": "86150",
    "place": "Augsburg",
    "web": "https://nextgen.tech"
  }

nodes_used:
  ["n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.dataTable","n8n-nodes-base.formTrigger","n8n-nodes-base.extractFromFile","n8n-nodes-base.extractFromFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE71Z627bOhJ+FcFd4LSA5eh+8eIAm6ZJT9uTyybOudVFQJGUrcaWVIlK4gb+uW+xwO6/fa99gn2EnSFlW7Zlp8Ui618WOZzLx+FwZvjYSVin3wm9w8i/GN2Zx++rwfThQ6fbmXJBOv3HTpKWgqSUv0M6GkShy62Qmr5p+ZFlWrHh8Jg6JDZ4EPAo4MyPwzgiNIwN17QpoZYROz4PeOCxCPgKPs0nRPCjgrPyiosqP8pghAsOAkRR8Xm3k5IpB2mvqzJJeVlqlBRMKylJU14gCzIqO/2Pj0r3eJzeT60HK00m9v3Rm6+d5fo0SDVGBIlIyWGUFhzkskMBU5Zhubpp6IY9MKy+GfZdv2fY7h9AVuXsabJ5t5b+1TVufz/z/jh6fX8kPvNwJf00KUVBJtr50eVe4Zbbd8Oeb/r7hTfIlsLfkfsPo+osHf16+cWZXPOV8POcp4fvdsn1kKFt992gF/rWTrmbZPNPwD9jvAE+tW2bRh7TA9vzdMcMqR7FnOs0tEMncFloWlYrJNrhBaonZnm9U7rkrONe9cZC5Jf8S8VLATR5ViYiyVKQ6vpe1w0t0CMnBfAUvCjRSatiAlxwWdk/OCB50psqUT2SHNyZBxktlEuPM9T64vxqAN9Zjmwlg4KXOfzlu/6fZMWUIDhxMkGYs0rklbgospwXYnamzAMpN2qi97kEfedz8GX89zpjM5j/8XGYatqwMwVLJ8NOH/8qNXVYquOpKMWw01VULKPVlKcCCeVCHES81MrF9A3YXq/RtoYlIZyAPsnzSUIJ2nuQs/jPCLPndB8ftT+hgj0k0ubzYQf5zGsNkpROKsZvkikZ8Ru1BHniKR2mc4Ch5ClTxuEYfOecJvGstleC0O2QSoxBo1o8jI84nOOEYgTAcTIZoBd0F+OHQD9QfoE7+pqTghc4CI6P/lwvkvu2QdCv3fLkt8uv789Prk6i916Yzd62u6CuqaXa7+fXlzeD8w/HZzc/HV8ea4TSrEpFB/cPEf8F3Eyq7vSs5eHzLSf0jIDpMbfA9R3q65FtE92jxIw927EiGq/kHr7TDsE+sfL5v4DTH6wcf0LSER2TJO2Rmq7h96YRBK2OL/gDeuWPy1B5BKES/KW5r70cOJYfjU+9KSluWXafwk6vu385KyEunwIDIAV+v2eVBshoRIvWYjAEEwZ4iTER8n8Jf7mMsVpcZFP5hYQ93KocRnJR7yTjMfABqWNSnqvDQ4oSwvki5q/hbDVwJjykIXE8Pba5AyHGiPSAE08nnmNaJjHd2LA3A592hBqe4jn7BsAnUySXK5NN3I2gG5jeFu7yCOOfmxsMPcr7cRDkTBIZtu7IpMLPUS50J9OnSYrM4UIcc3bJy2oi6rDRJJg3t2W+7e+ZVPIwT5aunv9h/Eb/OplOrAvzmFyPN6BIdjuz2QDZ9X0M46Zuha6hO9QjehR6vu5wwwki34NfA+QrsJeKClTT1F5q9WY+jXXW2PsVmw3UbasddXTpK8BvSo4fCCYNIAlC4xBiZJwUpUD1VNCTERHHN4ZUkKTgmCSdbY3f82hrDIQlk61RCCKci61hMEJQsHh7YkJoy+g4S7dHp1kEl8zW8OcsAihpkUj/WExjHN7eWHu5sY5thx6HC50EEJtgY6ke+BHRWcxZFIeAtBs0NjZBVLVTPs2K2Tfs5lQSvq7imBe/JinElo2dNG2vdSdLCClA8oGrexHC1csf3mAYEZmmLpofXvUSiEnyJu2VVTRNhExQVOyq179jdXihVSmyKbLbBwZ1bc+JqAUBxAAwYtvRSeg5uu97tkHjwGIGWYFxnYOPQpzL7l+Wr3bmKhj8BiSSWUHTcmdHxKbZpJqqqFtHiMeFwB+XYbvOInBc2Su9sI1ETiga6U1tNHKipkE/bKXBCUWj/K+NSM3UOyBPQBuVmlFU9UlrI6unar3qg9OqWj2nKJcHvY10Oalo149M24IlBRLgInCfUkaYRoGxlLj0ATAxSUfwzZISkFvmPwWchzssZGKI1/KbsPN0MmsMfKmSokFRM6ivgqYouDEJXBKnRNBxTb505P+PNt+gyGJ/n12XlaB96mxs+LNrtSVvn3LqDD+7Tgsx+1RRoeLZVVmI2adKHW2eXZelnH3K1EHt2ZVZytm7SYuY+Pz7tJK0VyF5eTy/NrWYNlXgOp1CLQtyT9VtoeqK13wiU48p0sLk0eKS/QgLiMCekxhkR1l6Bzc6pgzlUjZVgycJn7BykF0poxaWY72/urlTltS5OdwNt3zzxMHIL3XSv/uenn+SOT4vFtVwJdMMtHeRSWCr7Vsqi18HH3IzG12/PTNujfyNt1FeXMumyAGUYZ85FeXBQ/WzPXvzVpz618VFenx5gAIFCiwPnmBVG7pWDJYtFcXSVYzIC0MjpLrruDGknQ6BBDQO9cAxXNswfW7zZrcq1eKsmGoyzZOJ3c50C+kGRTIayWqjmXBZi3wLsvhxlt3KhiUhcRzZpqNz2wx1J6C2HhBi6KZrk9hl1AoC2tlM0RoVGDgACkzEZF9DEmmUAy3TOuUjMQ7WKWrdOZJDP5MIy8cloDfIEP0XsE4gAz8B2nLrvEgRdcH8qVbtzVp+c51PMsK2yvaXF29OtKzQZCPn1VaKbDVSZEb9mDmxrxsGhfLPcWw9jAOm+55lusS1uNnsca6n7Ds3jT+IglBxUmTTk2QzU7ZdqzVRbrQnbjnPr7KqkKlrlKlOUPMMRUlKitkgUw05zBLUyEaDbh3uLe+FUDG5J7O6P4G2bUbAwAhMlxumHhg20x3bhLrKMwKoJ1js8Mi2GTVX6Ly/Oj/bqoy/BxqonJ6AZgMHbMK8V123VgC2OpQ7DzDjVhBz19Aj2/d0JzKJHnqM6kYU8cD1TNuhjQN8JRJ6O9POMsF3WlpKmpqkuf9W1w6ctjopKzp9v9sZ82Q0hkrDMQwZrgW2x/qdF1qlvP0uIeDxcOplEBmmOYu72ud81NV68Ntjo2vEAeG2p7uMYTnoET3wYke3OHFZbNIwJm6rjeZ3Gwlx5gkr7xOGDUzP9fZYjF1LNHejkT5MX7zQPr7JaPnp5aIJ3miAp/y+PGh0mrcjwAoTj3seMamj05gZusNopAeuFes+I65hBtyxGWvFxPpuTELP+DZMnLCBCT4BrGFyrE6Q6kTKbIBp9bzCRT4yaSTVMtUbBMA0uKoBqgVW+CCFvtNDCpJgaYqPCDpQlfvAiuzYtQKLgZ2RqzuWZ0E4ME3wJ9Mjlu1BkIhawbK/GyzT8f+HcyIbGYtWLcoZphgKR3JMpSaEsQIvDFIiOBqWxLxIyHBfkAi4azngGLrvMA5BgkCQoL6vh9yMAQFKbMNotX/3VbHLfh3C7D773dUJAsKdWLzQ/vOPf/1TW2uXa1fqIh+mw3QwTkrtPituY0goNVKJDFLKhJLJZKbVobqU3oUex7gA5ErV+lbBCHxv/eqVV26Jly/cwaWmUG8eX5IyrW5av70YLBrBXdyZVCvJHVc99nLVcpXt9iSFaxd8Gt845S0sM8ce2iD9vY/tT7M3FIeMaTO4O5dCa/fXXv40GFzseAF5hYyE1Vx+vnZ4tJeLRvuqP60W2bDoSD46QlBeaaahE6zAkTcwIJ2IsSYzohKDtyTqanWt31We2dVkGQlfgkoJDkg4TiVTRAaf5rQ6JcRcpL4V1nNVCTM+r8kliw2WcP3773/TVJbb31pUcE29fwvYf5aMwBu/ghUS/BKQo2OpxtIh8LWl5bxgEUJFcseXKV3JhQBPkB7MHzit0M3PC4YPIp07E3ncqfUyjQ1cw4BU1tJDO7Ig0Fhcj1zf0QPbgezW8iPT9mW3DfyYLtOm5ZsTPliQBI8R5KSpqiV2dDclXbeTpIw/dPrG/BMmms1Epo3X9uNWK5v17jIwIsnNtP7Yy21Ft8lyIwFtU27no3OrjpvUbRxb87pWbtuvUcpq7KBXEBjqsaeMXyffErJdPbVpvStXb9+qXS88Sv9s7QXvKfXXqNclzef/BVdVu4KCIgAA


name: Real-Time Crypto Price Bot for Telegram with Gemini AI & CoinGecko
author_name: Malik Hashir
author_username: malikx
categories: []
created_at: 2025-10-03T10:55:17.328Z
updated_at: 2025-10-03T10:55:17.328Z
url: https://n8n.io/workflows/9230
scraped_at: 2025-12-24 13:02:46
description:
  Purpose
  Transform your Telegram into a powerful cryptocurrency price tracker! This n8n workflow creates an intelligent Telegram bot that instantly fetches and beautifully formats real-time crypto market data. Simply send any cryptocurrency ticker symbol, and get comprehensive market information in seconds.

  Who Is This For?
  Perfect for:
  Crypto traders and investors who need quick price checks
  Portfolio managers tracking multiple cryptocurrencies
  Automation enthusiasts building custom bot solutions
  Teams needing shared crypto price information
  Developers learning n8n and bot automation
  Content creators monitoring crypto markets

  No coding experience required! All code is pre-written and ready to use.

  What It Does
  This workflow creates a fully functional Telegram bot that:
  ✅ Intelligent Ticker Recognition - Uses Google Gemini AI to extract crypto symbols from natural language (understands "BTC", "$ETH", "Check Solana price", etc.)
  ✅ Real-Time Market Data - Fetches live data from CoinGecko API including:
  Current price (6 decimal precision)
  24-hour high/low prices
  Price change percentage with trend indicators (📈/📉)
  Market capitalization and rank
  24-hour trading volume
  All-time high (ATH) and all-time low (ATL) with percentage difference
  Circulating and total supply
  Last update timestamp
  Direct link to CoinGecko page

  ✅ Beautiful Formatting - Professionally formatted messages with:
  Emoji indicators for easy reading
  Bold text for key metrics
  Markdown formatting optimized for Telegram
  Clean, mobile-friendly layout

  ✅ Instant Responses - Get market data in under 2 seconds

  Setup Guide
  Prerequisites:
  n8n instance (cloud or self-hosted)
  Telegram account
  Google account (for Gemini AI)
  CoinGecko account (free tier available)

  Quick Setup (15 minutes):
  Step 1: Telegram Bot
  Open @BotFather on Telegram
  Send /newbot and follow prompts
  Copy your bot token
  Add "Telegram API" credential in n8n

  Step 2: Google Gemini AI
  Visit Google AI Studio
  Generate free API key
  Add "Google Gemini API" credential in n8n

  Step 3: CoinGecko API
  Sign up at CoinGecko
  Get your free Demo API key from Dashboard
  Replace the API key in the HTTP Request node header
  Free tier: 30 calls/minute, 10,000/month

  Step 4: Import & Activate
  Import the workflow JSON into n8n
  Configure the three credentials
  Activate the workflow
  Test by sending "BTC" to your bot!

  Features & Benefits
  Key Features:
  AI-powered natural language processing
  Real-time data from CoinGecko
  Works with any Telegram client
  Mobile-optimized formatting
  Professional emoji-enhanced design
  Direct links to detailed coin pages
  Lightning-fast responses
  Supports all CoinGecko-listed cryptocurrencies (14,000+)

  Technical Highlights:
  Modular node structure (easy to customize)
  Error handling built-in
  Efficient API usage
  Scalable architecture
  Well-documented with sticky notes
  Clean, maintainable code

  Use Cases
  Personal Price Tracking - Quick market checks on your phone
  Team Collaboration - Share bot in Telegram groups for team-wide access
  Trading Signals - Integrate with your trading strategy workflows
  Learning Tool - Study n8n automation and bot development
  Client Services - Offer crypto price checking as a service
  Portfolio Monitoring - Quick checks before trading decisions
  Content Creation - Get accurate data for crypto content.

  API Limits & Scaling
  Free Tier (Included):
  CoinGecko: 30 calls/min, 10,000/month
  Gemini AI: Generous free quota
  Telegram: Unlimited messages

  Perfect for:
  Personal use: 100+ price checks daily
  Small teams: 500+ checks daily
  Moderate usage: Plenty of headroom

  Need more? Easy upgrade to CoinGecko Pro for higher limits.

  What's Included
  ✅ Complete n8n workflow (JSON)
  ✅ 7 comprehensive sticky notes with setup guides
  ✅ Pre-written, tested code
  ✅ All API integration configured
  ✅ Professional message formatting
  ✅ Direct links to all required services
  ✅ Example test messages
  ✅ Troubleshooting tips

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.httpRequest","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.set","n8n-nodes-base.telegramTrigger","n8n-nodes-base.code","n8n-nodes-base.telegram"]

workflow_json_compressed:
  H4sIAAAAAAAAE6WWy27jRhBFf0Xg2u30o/rlVQADY3gxniQ2sgm86Ee1TFgiPWIbyWCgf09RM5EEWXRkeyeRzarD27du83uzxBqai+9N2w01dAmvc3PRWFO0gYQeRQFvMJiktFJFaJ21FDYoESxEEY2MGBRPylqQHmwINqNNzVlTcfm0CBUvV5iHW6zPT5c9XcGK1KCunnF91nR9xqG5+Iu6j11FiTxLBcznFBhYqZmTSrFcFHKQSnObqXIXlkirb2ubHr/NbvqKMza7wwXOV2E5u1u18zmuRoJvT+O6znVs04jFMOD5sHlsfIqWPPVDW9u+IwYDZ0JzuKeLgeoQ52oYdUl9V7GrVKhZ/6j5J93ZPCPWZz/JE4SStS1MeKEYKGFZdBwYGOtENlpaUFPkV7hsu/bNvFaZDwBH6YxKOTBjvGbghGa+eMuUV5CVI2gXpoBpM2d3dOEdIgtw7gPUgfM4uowZ7yIDiZa5kg2D4ixXCtHkSYNc9m13hemxfzO05H6UWvL3QZcsgxAYGU/aM/BZsMgVJ+jgfOJZWWemoD/1q2Wote3mb6ZWfCP1e6m1U4CS0wSKIBgEZ5g3rjAfspcqOxu0mzZIl7cD+XZwC/ABcA8uCkFTiEk7Aqcp9CIkVkzkQZRAVrFT4L8/07/ZbQ2r+mZsBoJcIr15H7aSISoFgVGsIuVG1ixA4ixYBWQXF4reG8grGsHfVm36z9jz0dhikvmh1qc/8OszDvXA2taQSax5ofUhKJzLLSpXIgVuyMaQyNDgOHVBTgorJyXdKrin8GcchjDHWZgtCWixB/krUf6yI12Ebp4eQtudz/t+vsBtLu7nhxhT7wTenbCmRB2d5yypXMakEJQZkeBt1DLbpIqTe37YZtu0mgMeqCi85CdRqXPYcuWMRhhHe+0SDZjmkZCMY8g1QRabrNE7rsPjbZqu/ly5Owf3SGE85X6A/o3xoe8fN8e9Qm+tjIVFRQQgLZnPO8lMiOBjVhn4eKS/rvieQ0aDSCHGUhnGenmUW7ISczZCBUd7ceTddmk3/XqJfh7khT7Rwzs+4IJLrugFvSdIDpk5TwlHZx9Ylyn35H64jXF2+eX6ZnZ98+nLrPbbbPv/XTiQH5Q8pj9GKwPShw/yZBlk0j96A6wIURxqjLLkU/SnshQ2Haax3yZ79v1Mf5c0XsRBH1wj6wlBsnngjD4OM/7TXPD1/T31fTHSxyofnaSj5V56+1i96Rx5vei+qY5znrC7R1tMaHesyesWP1J9vf4Xe3J8tZoLAAA=


name: Generate Exam Question Papers with GPT-4 and Email Delivery
author_name: Gracewell
author_username: gracewellai
categories: []
created_at: 2025-10-03T18:06:46.625Z
updated_at: 2025-10-03T18:06:46.625Z
url: https://n8n.io/workflows/9248
scraped_at: 2025-12-24 13:02:44
description:
  Who Is This For?

  This workflow is designed for educators, universities, examination departments, and EdTech institutions that need a faster, smarter, and standardized way to prepare exam question papers.

  What Problem Does This Solve?

  Creating balanced, outcome-based question papers can take hours or even days of manual effort. Faculty often struggle to:

  Ensure syllabus coverage across units
  Maintain Bloom’s Taxonomy alignment
  Keep a consistent difficulty balance
  Format papers in institution-specific templates

  How it works

  This workflow automatically generates an exam question paper based on syllabus topics submitted via a form and sends it to the entered email address.

  Here’s the flow in simple steps:

  Form Submission – A student or faculty fills out a form with subject code, syllabus topics, and their email.

  AI Question Generation – The workflow passes the syllabus to AI agents (Part A with 2 Marks, Part B with 13 Marks, and Part C with 14 Marks) to create question sets. The marks and the no. of question generated can be customized according to the convenience. 

  Merging Questions – All AI-generated questions are combined into a single structured document.

  Format into HTML – The questions are formatted into a clean HTML exam paper (can also be extended to PDF).

  Send by Email– The formatted exam paper is sent to the user’s email (with option to CC/BCC).

  Set up steps

  Connect Accounts 

  Connect your OpenAI (or LLM) credentials for AI-powered question generation.
  Connect your Gmail (or preferred email service) to send emails.

  Prepare Form

  Create an n8n form trigger with required fields:
     Subject with Code
     Syllabus for Unit 1, 2, 3…
     Email to receive the paper

  Customize Question Generation

  Modify the AI prompts for Parts A, B, and C to fit your syllabus style (e.g., 2-mark, 13-mark, 14-mark).

  Format the Exam Paper

  Adjust the HTML template to match your institution’s exam paper layout.

  Test & Deploy

  Submit a test form entry.
  Check the received email to ensure formatting looks good.
  Deploy the workflow to production for real usage.

  Need help customizing?

    
       ✉️ Contact Me
    
    
       💼 LinkedIn
    

nodes_used:
  ["n8n-nodes-base.formTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.merge","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.html","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5528 characters]


name: Automate Telegram Message Processing - Separate Text and Files 💬📁
author_name: EoCi - Mr.Eo
author_username: eocimreo
categories: []
created_at: 2025-10-03T20:35:17.472Z
updated_at: 2025-10-03T20:35:17.472Z
url: https://n8n.io/workflows/9254
scraped_at: 2025-12-24 13:02:41
description:
  Introduction
  Tired of manually downloading a file through different Telegram messages? This workflow acts as a smart receptionist for your Telegram bot, automatically processing incoming messages to cleanly separate text from file attachments, getting them ready for any automation you can dream up! 📥

  🎯 What This Does
  This workflow solves the challenge of handling varied Telegram messages within a single automation workflow. Incoming messages can be just text, just a file, or a file with a caption. This template intelligently identifies the message type and routes it down the correct path, isolating the text content and downloading the file attachment. It's perfect for community managers, support teams, or anyone building a Telegram-powered chatbot.

  🔄 How It Works
  Listens for New Messages: The workflow starts the moment a new message is sent to your connected Telegram bot.
  Checks Message Content: A Switch node instantly determines if the message contains:
      Text only
      Attachment only
      Attachment with a message (text caption)
  Separates Message and File: Based on the content, the workflow isolates the text (from the message or caption) and the file's metadata (file_id, file_name).
  Downloads the Attachment: For any message containing a file, the workflow automatically downloads it, making the binary data available for the next steps in your automation.
  🧩 Nodes Used
  Telegram Trigger
  Telegram
  Switch
  Set
  Split Out
  No Operation - NoOp (as a placeholder for your next steps)
  🚀 Setup Requirements
  Credentials:** You'll need a Telegram Bot API Token (Key) and Chat ID.
  Accounts:** A Telegram account.
  Setup Time:** Less than 5 minutes.
  Set up steps
  Create a Telegram Bot: 
  	First, you need a bot. Open Telegram and send a message to the official @BotFather.
      Send the command /newbot.
      Follow the prompts to choose a name and username for your bot.
      BotFather will provide you with a unique API Token. Copy this token, it's what you'll need for the next step.
  Add Credentials to n8n:
      In your n8n workflow, navigate to the Credentials section in the left panel.
      Click Add credential, search for "Telegram," and select it.
      Paste the API Token you copied from BotFather into the Access Token field.
      Click Save to create your credential.
  Connect Your Bot to the Workflow:
      Back on the canvas, open the Waiting For Message (Telegram Trigger) node.
      In the Credential for Telegram API dropdown, select the credential you just created.
      Open the Get & Download Attachment (Telegram) node and select the same credential.
  Activate and Test!
      Click the Activate toggle in the top right corner of your screen.
      Now, send a few different messages to your new bot on Telegram to test all the paths:
          A simple text message (e.g., "Hello!").
          A file (like a PDF or Notepad) with no text.
          A file with a caption(message).
      You can check the Executions tab in n8n to see each test run successfully! The NoOp nodes at the end of each path show you the final, cleanly separated data.
  💎 Benefits / Why It Matters
  This template provides a robust and reliable foundation for any Telegram automation. By neatly separating text from files, you can seamlessly connect Telegram to any other service whether you're archiving documents to Google Drive, analyzing feedback with Gemini, or logging support requests in a database. It saves development time and ensures your automations run smoothly

nodes_used:
  ["n8n-nodes-base.telegramTrigger","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.set","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","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:
  [encoded data, 6104 characters]


name: YouTube Channel Monitor with Gemini AI Transcription & Summarization
author_name: Muhammad Asadullah
author_username: asadtech
categories: []
created_at: 2025-10-04T21:06:10.585Z
updated_at: 2025-10-04T21:06:10.585Z
url: https://n8n.io/workflows/9268
scraped_at: 2025-12-24 13:02:41
description:
  This n8n workflow monitors YouTube channels 24/7, transcribes new videos with AI, and scores them by relevance—all automatically saved to Google Sheets.

  About

  This n8n workflow automatically monitors YouTube channels, transcribes new videos, and generates AI-powered summaries with relevance scoring. It pulls channel URLs from a Google Sheet, fetches recent videos (last 14 days), transcribes them using Google Gemini, and saves detailed summaries back to your spreadsheet with relevance scores based on custom criteria.

  How It Works

  Schedule Trigger: Runs weekly (every 7 days at 7:05 AM)
  Fetch Channels: Reads channel URLs and filter criteria from Google Sheets
  Process Channels: Loops through each channel and fetches recent videos via YouTube RSS feeds
  Filter Videos: Only processes videos from the last 14 days that don't already exist in the database
  Transcribe: Uses Google Gemini API to transcribe video content
  Summarize & Score: AI agent analyzes transcripts against your criteria and generates:
     Full 500-word summary in markdown
     Short bullet-point summary
     Topic classification
     Relevance score (1-10)
     Relevance reasoning
  Save Results: Appends or updates video data in Google Sheets

  Setup Instructions

  Prerequisites
  n8n instance (cloud or self-hosted)
  Google account with Sheets API access
  Google Gemini API key

  Step 1: Google Sheets Setup

  Create a new Google Spreadsheet with two sheets:

  Google Sheet Template: Click here to access
     Make a copy to your Google Drive
     Configure the two sheets as described below

  Sheet 1: "channels"
  Column A: category (e.g., "AI Tools", "Marketing")
  Column B: channels (comma-separated YouTube channel URLs)
  Column C: video filter criteria (describe what makes videos relevant)

  Sheet 2: "videos"
  Columns: id, title, video url, date, channel, category, topic, summary, short sumary, transcript, relevance score, relevance reason

  Step 2: Configure n8n Workflow

  Import the workflow JSON into n8n
  Google Sheets Authentication:
     Connect your Google account in both "Get row(s) in sheet" nodes
     Update the document ID to match your spreadsheet
  Gemini API Key:
     In the "set channel" node, replace the placeholder API key with your own Gemini API key
     Get your key from: https://makersuite.google.com/app/apikey

  Step 3: Adjust Settings (Optional)

  Video lookback period**: Edit line 6 in "Videos Posted in Last X days" node (default: 14 days)
  Videos per channel**: Modify the "Limit" node (default: 4 videos)
  Schedule**: Change the "Schedule Trigger5" node timing as needed
  Wait times**: Adjust wait nodes to respect API rate limits

  Step 4: Test & Activate

  Add a test channel URL to your "channels" sheet
  Run the workflow manually to verify it works
  Activate the workflow to run on schedule

  Notes

  The workflow includes rate limiting (wait nodes) to avoid API throttling
  Videos are checked for duplicates before processing
  Failed transcriptions continue to the next video without stopping the workflow
  Results are automatically saved to Google Sheets after each video processes

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.rssFeedRead","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Z224byRH9lQGfdgG10/eLX3Jx7IUBJ15YwSbBwgj6Ui0NTA0Zcri2YejfU03K4ojsIYfKPuhG9VSfqq46darn2+wOej97+W3WduvedxHeptnLWdABBNcyMaq0yEpkTTNjTmsVIDNJmVOaWWMD8GxEpAZCkpxScFypmGdXsx7ulnPfw6sVpPU19JvlqwV+Aj3gBv1qA/dXs26RYD17+SvuXnblAhL1UhJmsiAypUScTYZobaJlItjINVru/B3g6ms0EvsNmm/eb/rlpm9+9qs1rFjZ/OuyLPlTZ7s/4BfZbkTmvruJt77tXiy2D+zW7+3gg8vFuu3bRYegCLeUXklKP+LHfoWb9rBCtN/ud/Z/wb+2K9kLfn/14ALLSkaJ6LM26AINQIKknngGAVhyKtq8d+GnxeJmDs1PcNd2bfPq1vfN3xDpnIkJPszvygM7EzsLh/idnob/Eb2P0ZkYPAmcInoOmbhoLQkui2glUCFhj/4rRnEToPmtTbBo1pu7O79qMaATsG+/v5vfHSAWlMsrxm0F8Qr61df33Rvfznfpc3QI6tGNEHJKigcCzgORDByxggLxkVoatWY5qr0bb7PcI96DDX4NL9p8gFA6bq+0PBdSPkgJSyXlXFMSglUY1IBoZGCEqixTTNyAtXs07xaLZfP+N1g1v5SwrkehrZfztn/b/cX38RbWhzA1BlLW4vgEpngEqaxRiVNJokyOyJAVccoL4jjPjkXDuRN7kK9T2zdvWpinNRsHCP3h8XKmR473KawX8mrm55/91/Wusv/qC0ftSOMBsGNeKpBAWIiqAI64qzV40LkQEBci+z3gfz+k6j9WvlvHVRswvo81U4d/2/fLD/DfDayLG4vu9Wq1WOGyuOj6ttvAB7jZzP1qB/DQUcP4FZNn00S+4GcdVRQPI9tIqFSMSJNiSSRDkGksUMcyqDRgFOib1eLzD+sfm7Zr1rewPYS6hzdb6rguaw7zR1OkPiLsBA/MI1LATFHMcIKJE7DseCZeOkec8wabCTdWxD1SzNr4qWlz851G5m33aXohYlvikxAOS9Fh+fNoaSG0RKSSyHQ2KGKEwWxKTmTKBg2mVBiGsV/gt9QizW38fAtzvCoj/nqI1GItTkK6P3NsfTo4Rbg0lsgMnFjjKSkcHB3k7EyVMpBWuw7mzyQNJbBfkAkNY08bXnvsCloTgXIBgZaODQqIypnjASHaRPdAkRG+Q7yANRRT004aaeMRGOJBICGjU9Q+tIDEJKEhUWZtZnnL+oOqebUD1iTUQ+2JED7lhSeka6WdWDSD7iCC0igRiJKodAqlYZsyWDleUGRkYB4GQK/7Nn762vx90cN4BLdrHpY87V3b8z3uXltOg65HW7NxcRBFEAqlGJKDQcZ1PhHrQeNZA83gnRfDFvHh+rr5AD41P3yv74eT38mF9Y+j+Ffr9RuAVB4+dEDJaZXEXuxh2ySsMZgJRiaJmWAZcRKT1WjLtEePqBsEeNd0m58Xa9SphULf+XXf/KtJSNHND8WFG2gWXWEBaPS4ExUekGJiHp/vCYwbyYw0JImYUSgLhjyGjAZBSK5s9Dy5vU87fXYur48LDxl8Wj4PC88YliUSKUExgdrLCaTYiNRFLXgZnGaBDbLkbW76tp/DH6cTv3B0Ip1OaK7ZgA8WLE4cHGnCYJsNGfuDcRHTRXP8F9+j9fPv2XuJ6NEoeiax6iCKOjKvGVCiVUZWSNhKA54ric4Hw1HeRqEOkrYp7jW+Sw3qG9yi9ZccNVbEFdNTMJ6PqdNRShAkKodNlupIrMMhIhmlMKjCQzAnBcu4pDyhWCQvo8N5D1CwnNeWeO4cJwgStdeoLVNpvyoS4w0FjRIMzKC8UMJ0i76BL+26f/ThgoSWdFrsh0ImRrA0ZWy5qAGR0lGue588iRnjQK3RQOFplT0I3+UD0PEMPi44KekUMTvEl6lQDHUfZi3DXlHaREB5gWVmYtZgpRGDSf7PyyVg3i5WzWaZfA8lIf4v+cq14VMGjaF6dRocQ8lAFM/IqTjxEhesI6hpdHY8gcoDbfi6SxcxKXZewS9hgMhTdCFi0oFDBogllgb7rjc85RxL1xpK1b0uODGQjQoDbZHo7VEGTtMFQXjlM9Y7CgE8a4OYXbkBCQyFK5RWpHQVKb8cqWCcPh8pqiuHoDIasNiblMOszNoRHbVxDuWqobyKVDwDqcWYMv08oNqmHExR1IgLjwdwrsWWT5A/XUw24QgzoNBr1PJpMy/TbXtzM7x/OQT7sHC/7snMh8QxUV0N7rs8d9whNwYQmKaBYaPiKLFwSqE06gR2eNXyT48DFW/WEEcxfsYlRwRUgHFVgvkZwu1i8Wl7SQk4tHGPos7EgCToJCfOUEeSSx4o6mkbS+JNVorcZExVDDNQuR1mUCkmJUkUMhqKcc/BH/hiVXGmCMJcLqYucYoj6x/7ZBXyOvI5oTnbUpiGeIU8D4a5MpRTqfklPqUUGKM24YFYVL+m3EdGKQhNkIKIkKg6PB9Dtz5lpOMOvvQ7xXOJa9iJke0UP3DNOZekDJIwJrD6EirXEDIlnkaRsKFhS3CXuOasCR4lGsFHA5HoCnHaAJ4eDYDTp3I+Vqt5/LpvtJpxm5KC9KijnK5nXI3/7yAWO9vl5bIRf9z5ttj99dv2Cvzktd926dWs7RJ8mb2k9x8/4j573VwzVtOpVTODejwN6vhioWpvsHHNXq38q3aGFwU1Qyfn9arFJzeWNZPnL7Ordp/OVjXDlRGnaukoA2rGnsiOIzNX+4VnR4IqhqNOMhb80SvGM6495lE9UnKac9V7pOrOtUSpbX3BbcXoPocxqe0z6UpxvFQP2k1th+cdfHUKq5k/N+yMstXR/FFN7+p7hVOpcLILV8HU751/F/obCU7N9pQXEmf9PtOpqxjH8mNipZ86lmJ+lEZr9ifOfXWqGn37izv59j/DN7wXEv3h00fFMv7Wdrd3ec+58Tew/fTyzZ8+XiWC+sn/DsLiRF6ONbfxm4X6wZ2gwNoWZ94TVfc4nVij0uQ59XS+c4yy9HOumcdr+gJrNUQjl8SV/e7v/wdmPUdXNSIAAA==


name: GPT 4.1 - Freelancer.com Job Alert System with Auto Proposal Generator
author_name: SuS
author_username: sulieman-said
categories: []
created_at: 2025-10-04T21:57:40.400Z
updated_at: 2025-10-04T21:57:40.400Z
url: https://n8n.io/workflows/9270
scraped_at: 2025-12-24 13:02:41
description:
  Be first. Be relevant. Get hired.  
  This ready-to-import n8n workflow automates your entire Freelancer.com job search:  
  it scans new listings, filters the best ones with AI, writes proposal drafts, and sends them to Telegram instantly — all while logging every opportunity into Google Sheets.

  💡 Why Freelancers Love It

  ⚡ Instant Alerts: Get notified within minutes of new high-quality jobs.  
  🧠 AI-Powered Scoring: Filters scams, vague clients, and low-value gigs automatically.  
  ✍️ Smart Proposal Drafts: GPT-4.1 crafts 150–200 word personalized proposals for you.  
  📱 Telegram Integration: See job details + AI proposal in one alert message.  
  📊 Auto Tracking: Logs every lead in Google Sheets with scores, notes, and timestamps.  

  Spend less time searching — and more time winning projects.

  🧩 What’s Included

  ✅ n8n Workflow (.json) — ready to import and launch  
  ✅ Setup Guide (Markdown) — complete 5-step configuration walkthrough  
  🧰 Requirements

  Free n8n Cloud account (or self-hosted instance)  
  OpenAI API key** (GPT-4.1 or GPT-4-mini)  
  Telegram bot** + Chat ID (takes 2 minutes to create)  
  Google Sheets** account  

  🪜 5-Step Setup Guide (Detailed)

  1️⃣ Prepare Your Tools
  Get your OpenAI key → platform.openai.com  
  Create a Telegram bot via @BotFather → copy your token  
  Use @userinfobot to get your Chat ID  
  Create a Google Sheet with headers:  
    Timestamp | Job | Description | Link | AI Score | Reasoning | Red Flags | Client Type | AI Proposal | Alert Timestamp  
  Keep all keys and URLs ready.

  2️⃣ Import the Workflow in n8n
  Open n8n → + Workflow → Import from File → choose the .json provided below.  
  Once imported, open these nodes and connect your credentials:
    OpenAI nodes → add your API key  
    Google Sheets nodes → sign in with Google  
    Telegram node → paste your bot token + chat ID  
  Confirm the Schedule Trigger runs every 5 minutes (default).  

  3️⃣ Personalize Your Keywords & Filters
  Open Settings (Keyword & Wishlist):
    Job Keyword: e.g., react, seo, logo design, automation
    Wishlist: e.g., Budget &gt; $500, clear brief, long-term clients
  The RSS node auto-fetches new jobs from Freelancer.com:
      https://www.freelancer.com/rss.xml?keyword={{$json['Job Keyword']}}
      Optional filters:  
    &min_price=500 → only projects $500+  
    &max_price=5000 → skip mega-projects  
  Adjust Filter Job Quality:
    Description &gt; 100 chars  
    Posted within the last 2 hours  
  Tune AI Score Threshold (Gate Node) to &gt;= 7 for balanced alerts.

  4️⃣ Test Your Automation
  Click Execute Workflow once.
  If everything is set:
    🟢 Nodes turn green (success)
    📩 Telegram shows your first job alert
    📊 Google Sheet updates with a new job entry
  If empty, try:
    Broader keyword (e.g., python instead of python scraper)
    Increase freshness (2 → 6 hours)

  5️⃣ Go Live & Expand
  Activate your workflow.
  Let it run for 24–48 hours, then refine:
    Raise score threshold to 8–9 for higher quality
    Add RSS nodes for new categories (design, dev, content)
    Extend alerts to Slack, Discord, or Email
    Replace Google Sheets with Airtable or Notion
  Pro Tip:* Use *Apify** to scrape Upwork, Fiverr, or niche job boards → feed results into the same analyzer chain.

  ⚙️ How It Works (Behind the Scenes)

  Schedule → Fetch RSS → Filter → AI Analyze (score 1–10)
          → If score ≥ 7 → AI Proposal → Log to Sheets → Send Telegram Alert

  You still review and apply manually (TOS-safe), but you’ll always be among the first 5 applicants.

  🔌 Future-Proof Extensions

  | Extension | Description |
  |------------|--------------|
  | Apify Integration | Scrape Upwork, Fiverr, or niche boards with structured data |
  | Multi-Channel Alerts | Add Slack, Discord, or email digests |
  | Team Routing | Send design jobs to one chat, dev jobs to another |
  | Advanced Scoring | Add client history or location weighting |
  | Database Sync | Replace Sheets with Notion, Airtable, or PostgreSQL |

  🧾 Terms & Notes

  Manual review required (no auto-apply)  
  API costs: OpenAI ~$5–10/month  
  Respects Freelancer.com Terms of Service  
  All keys stored securely inside n8n credentials  

  🏁 Summary

  Automate your freelancing workflow.  
  This system finds, filters, and drafts proposals for you while you sleep.  
  ⚙️ Plug it into n8n → 🔑 Add keys → 🎯 Go live → 💰 Start winning faster.

nodes_used:
  ["n8n-nodes-base.rssFeedRead","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.aggregate","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.if","n8n-nodes-base.googleSheetsTool"]

workflow_json_compressed:
  H4sIAAAAAAAAE6VZ224jxxH9lQYRG2uEQ839IsCOuRIl09YuZZKyYVuG0TPdQ441nGHmIoneFeCXBEiQxIHtlzgG7AQwgiBALm/5Hv1A/Ak53cPLkCK1G+WFoIbdVT11quqcaj1rTHhBG/vPGlGSFzQJeJc19humGuoeNy3L11Tf4KHq2Lpn2IZpeUwNqe1Zpus6zDQZo0xzuWNSyzI8arpOqHPOG81GwSfTmBb8IOMsH/CinB6keMILDgdFVvKbZiNJGc8b+x/Bu/DKQp1Zrk4V29N1xVSppVDDCRWTe67tW14Y6CosJ3TCsfqIF8GYHGWcx+LcWStIJ6Q/GAjfs6lYkbiJIl0oPs15K8vzI85Zn1MmrKSF8N348bvf/F5sI0ed4cFb5Pbzr4k87XkiHfCcFGNOxJvkBfk09XMSZnC07rd1npwnB2eDYe9J98MOOeuf7J8nt5//mfzsgs+u0oy9Lj6mGc/z6vmrkyj5ZJpFAX/dUtXFM3q9eqYKk51rKmIGY+OimOb7e3tXV1etcM33Ht6rdT2J77radHKe/Pjdl38iZzknkzIuIliWby5jRMI0Wz2e28pbiNQ0zaMiShMA5dlNRzU/xjOaAYWCZwjhs5t5NLvJUZxeVehWILyHBXKn1tJvmguYTdtSPdtWVJUFihlaoeIF+MZ54KvctXWdaTWYoxhuyNupT94taRwVs50Ah3JpDdvbb39B3j1rn3SHH5Cj7smw05f4HpR5kU6izzgwK7OMJwXJypjnc8wOeR5k0VS8MnmDaKpKgjHN5sCdpjkymFxFxThKkBZICp2M01L8fp70Tofd3tP2Av3HJRvxAgkENMZpzHLyKAqJwEb4xP4Q+fhatbbPf15GqJU9fh3EJYOPBQbC8LB7uk8GBc0KEqdpzpukiEbjgieEhiI82u3nX+mE0dkmYpZpPhCyFWAmDwPqm7YS6o6LutS44mm2pjguZ9QIzMDy7RVg7a4Eq53QePaZhGOO1puAa28FGTJ4hMBGSYuOEI61kvzL9wRm2ojkBx/OQZsX5SBIs3lNohjle2tqk/BrNBu0MJJxmqdJlIyaJIzpCA+i/CJvEpowEgCuPAoj7A/iSEAgTtZaxvcdzqdANh/HEWDNpzzA4oAUKayyMuAolAhpth5gx3YfGuBaTRi+YXuu7ymh7amKyVyE2NWYgl6l6VTlhmrXamIAa0FR4lSkVxbTsiCnSNCXinUq11fLV2bWg/9X0jsbnp4NyWm7P1iEv6B+JKoPfTHNAoQwL9BZCvL2oPeU5Clh6RUYBOGfkKoO8704HY2ABEn4JVLUx28Xm/1Ed5soMPdBHcVYRo8HqqearqnwwLMUUJOqUNPUFFOnrqM6NLQcfS1BT7MUp6AxOeYJz2iRvlTopjxpR2vt5bf/+fcX5LTfO+0N2ifk/X53S4vpsKgg540nMzK4iOI4P2+QvervzvWUZ8jDgOOZSFCGY5E04ci3mF9SJOg0zYowjaOUxFFy0Vr2cE99BRHHSn8mKuX2l18Syhia1SsENlEBeLciLYPxRsA148H9oB5w6jme64Wewhxmg58dT/FC3VZcVTccHeJA9bxVwE/SkSii4zQdgVoGY86LfGcTH8lVy0WrtPzq1+Tt3mNy0js+Xm8J7SmAYXtnUwaSFgE5QaiEQ3qZRghqOY2jQPC3DF+fgzMn2IDiCdK4nCT5PhlGE9A7uJY8l83r+RoJPK8sPheRlv0HX/uLPiO/M3Ikm81zclA1liHerdqwTDX8FXP076WvTWjsB7Or2TKX0FiOo/qmGSrMNjzUgqUr1FW5Ytqe6ZhcN8C8tU6CQJAhsm0Ej9UBdyJTzJeto/IvMuycdI777Sd1TKD6JBhpIamSvPk4LY4ouna2zNUivQB9gQQDNCDELKJxLn88fEJmIFS5WfwtKPRgTAvSPSSXESVvluhdURKmYoEomylYmBPYrvXyNjz4ZVGk4ASxSVpEiyJX3B+n6YWUOyjIKYoRCQTU2CYenq7O8ZjvkdLY9Zhv2ypEKmOi1+ih4jPuKyw0TapbqqubVuP/E0ih5vpM567CXAfA6b6rQG1TJXR82wmZbnmBUyeDKLiYQR10hmenZDBs94c7Iczl2qc4y/q7gs/1pmnom7nXCNKkEOS832jcbJ541Q00nXsqEs0NQFmmavuKZzHoA8AcMovavlEnL4hqBrm1TzqghRmxyJMoKREdbfex51uGWTQarSu8L/5Jhv3uqiXMV6LOy0TIhCgnEFEXIeJO+NzfpPInk+X22y9ED19q97lyM8Qi8jqBHs6ogo4x5QWCdQkNEImhoFqlqUJ+WPO1cIH0bp920VfyYtmqa9INOVwtFllblGjfm+qNiPdl4ABCZbO4FB1qU3KgzaoPbuIr2FzN1plhOcjk0BfjFlM8WzcU37ddrvse9z1a7xRFgXYHCftOpUvJq+T9uVZ67R7oeF3Z3X7zBxFtpOqw+/R4UO8YhzyMEBBZpxPQ7UL+yljJp+cNoc2IcAi+RHfGa0e0VZuTFgpetPD5KfcJlPc0CmdNIQ2DoklynlarFqffh+W5Un+D/ASTUhPykNOM5AEovwnVRy7pqOTQNdecKXKgOm+s43sQCzKW6SZeXmrGMrk7T4l+JzCLYx6TRxOejarZMnttE2PLeSgbGDU2cEwnsLRAVKUKNrA8Q4HKDBXbsS0HYkAP/LBO1JQBD7RlQXiAeo2y70F5N2n/QA47h2enHTLonfUPOnXEhbdcTEOXUVrm8QxfUwhLkf+xdC8HbQk9ijC4EGSbCxcSctnu5niLiVZMBDleA7odQDO5kND59J6KtlGtPZCcD8jFKyKPJlBqGB+iRcV+/SUoG50iKfKVdKiqcXO2UgxLfzhjNxs0vkLJVwr+kIprmOpeZDF2ea5uM40qruOhPj22mJNtxqmp+YbJzRV2eK+YQ4+v4NsNFx2NMj6ikgVquv/vpH183O8ct4drOD0uIzG6UoIBNbgQ8+dFCZkaIigi0jNUFFzOIQOriohDXZVTPp8ENsOm6Q8dmbQXBs0FIzueypQQdIas9wPFd7iNeUBzTR9K1dBqXHTIlRXGc+W4O2x37hd+/O6bvy3ye0P19xKR0Jg3qzujqzGGdhkjIltEsQweGoJM8VVmy4bSDeeP8YHJc4xMLsUNnR9XZjDS5lBWwVgKXfH7WEDyCCwV858KJbzZUQz9oaRRH1R9zbMNnYZQJBTaBDyB+Boa5I/rmxq0j2nVSOPk5Al51BNzU7fePXaOWPFECL3enUGrog1h7XH74J3O08N6fp6JjiHmoPmNA4hpKbqlg1VURaMYTQvFTBXQcCTTFXM+Z3uCshFhcEguAo+ZFUYzwfXZ6k5hI6KChh88vdauV1wd5WJjekVNK6ajI2V93VR0NTBCBtHHPGMV0mNAuz8fQ25/9QPZma1RuJapv/sHGRz0+h2yLO97slVI9nzpwpEBtCFxJuJR1QubxMWDVG7M+CQqJ5v6WXt4wq3uCi2MlH6AGRMiBR+Wq3iGayueafqeTjmz6vx18B55VJEQGaZp/JKEJZauheqP30uR8lanMxyQYa93IsPVk8MgjeUFCCaYS3EDC3lSIohU/AS+hOFWk0zLOBZktRre8yTCkAoKbZEBDaU8YFEuixlpKEafeLYZPlM3m57+kOQyW84NtkG7J2AEcTIh5ddrEQ9o9ImovJKO+BNEJobTj57JO/n7bvHu7Go2IgzT14199ebjj3G6zZ3wJPTcmvXdSSyXbpq8s3ybzRdc62w1fDdhqrgUIiX+B+OLLZv2t1xe7zj69mBvP/QWpt9m9cX/INlqfuttzTb7994dbDW9PYrbbN9/ZbTV+HYu3xqYe/6lsNX0zkhus/4CTbHVwc4L3Sod65e2L12la5vuONw9hG+H+uWGv+0vd//m7fC/7CCyI4VfsH2bz3sF9BY3Nzf/BWuYYmc9HQAA


name: Automate Google Classroom with Gemini AI: Topics, Assignments & Student Tracking
author_name: Mantaka Mahir
author_username: mantakamahir
categories: []
created_at: 2025-10-05T11:52:02.880Z
updated_at: 2025-10-05T11:52:02.880Z
url: https://n8n.io/workflows/9277
scraped_at: 2025-12-24 13:02:41
description:
  Automate Google Classroom: Topics, Assignments & Student Tracking

  Automate Google Classroom via the Google Classroom API to efficiently manage courses, topics, teachers, students, announcements, and coursework.

  Use Cases

  Educational Institution Management
  Sync rosters, post weekly announcements, and generate submission reports automatically.

  Remote Learning Coordination
  Batch-create assignments, track engagement, and auto-notify teachers on new submissions.

  Training Program Automation
  Automate training modules, manage enrollments, and generate completion/compliance reports.

  Prerequisites
  n8n (cloud or self-hosted)  
  Google Cloud Console access for OAuth setup  
  Google Classroom API enabled  
  Google Gemini API key** (free) for the agent brain — or swap in any other LLM if preferred  

  Setup Instructions

  Step 1: Google Cloud Project
  Create a new project in Google Cloud Console.  
  Enable Google Classroom API.  
  Create OAuth 2.0 Client ID credentials.  
  Add your n8n OAuth callback URL as a redirect URI.  
  Note down the Client ID and Client Secret.

  Step 2: OAuth Setup in n8n
  In n8n, open HTTP Request Node → Authentication → Predefined Credential Type.  
  Select Google OAuth2 API.  
  Enter your Client ID and Client Secret.  
  Click Connect my account to complete authorization.  
  Test the connection.

  Step 3: Import & Configure Workflow
  Import this workflow template into n8n.  
  Link all Google Classroom nodes to your OAuth credential.  
  Configure the webhook if using external triggers.  
  Test each agent for API connectivity.

  Step 4: Customization
  You can customize each agent’s prompt to your liking for optimal results, or copy and modify node code to expand functionality.  
  All operations use HTTP Request nodes, so you can integrate more tools via the Google Classroom API documentation.  
  This workflow provides a strong starting point for deeper automation and integration.

  Features

  Course Topics
  List, create, update, or delete topics within a course.

  Teacher & Student Management
  List, retrieve, and manage teachers and students programmatically.

  Course Posts
  List posts, retrieve details and attachments, and access submission data.

  Announcements
  List, create, update, or delete announcements across courses.

  Courses
  List all courses, get detailed information, and view grading periods.

  Coursework
  List, retrieve, or analyze coursework within any course.

  Notes
  Once OAuth and the LLM connection are configured, this workflow automates all Google Classroom operations.  
  Its modular structure lets you activate only what you need—saving API quota and improving performance.

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agentTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agentTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agentTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agentTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agentTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agentTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8384 characters]


name: Automated Google Business Reports with GPT Insights to Slack & Email
author_name: Peyton Leveillee
author_username: peyton-leveillee
categories: []
created_at: 2025-10-06T02:10:50.394Z
updated_at: 2025-10-06T02:10:50.394Z
url: https://n8n.io/workflows/9290
scraped_at: 2025-12-24 13:02:43
description:
  Created by: Peyton Leveillee  
  Last updated: October 2025  

  🧠 TL;DR  
  Marketing companies charge hundreds or even thousands per month for automated “Google Business Pulse” reports that show visibility, reviews, and engagement trends.  
  Now you can do it for free — right inside n8n.  
  This workflow pulls Google Business data, compares weekly and 12-week trends, runs it through an LLM for insight summaries, and sends out Slack updates and weekly email reports — automatically.

  🔥 Name: Google Pulse Pro
  Your AI marketing analyst that runs 24/7 — no subscription, no fluff.

  🧩 Categories
  Business Intelligence  
  Marketing Automation  
  AI Summarization  
  Multichannel Reporting  

  💬 Overview
  Google Pulse Pro automates weekly Google Business reporting for multiple companies or locations.  
  It combines data collection, trend analysis, and AI commentary into a fully automated system — delivering updates through Slack and email.  
  Perfect for agencies or businesses that want client-ready, insight-driven updates without paying for SaaS dashboards.

  ⚙️ Good to Know
  Uses OpenAI Chat Models for summarization and insights  
  Integrates Google Business API, Google Sheets, Slack, and Email (Gmail or SMTP)  
  Compares this week vs last week and 12-week averages  
  Outputs LLM-generated summaries formatted for Slack Blocks and email templates  
  100% no-code friendly — ready to deploy instantly  

  🧠 How It Works

  Read Companies (Google Sheets)  
     Loads company info, Google Business IDs, Slack channels, and recipient emails.

  Pull Google Business Data  
     Queries the Google Business API for impressions, actions, CTR, and reviews across:
     This week  
     Last week  
     12-week average  

  Summarize & Compare  
     Code nodes calculate trends and append results back to Google Sheets.

  AI Summaries (OpenAI)  
     Three separate LLMs generate insight lines:  
     Impressions one-liner → Visibility & engagement shifts  
     Reviews one-liner → Sentiment & reputation trends  
     Overall one-liner → Combined marketing summary  

  Format & Distribute  
     All one-liners merge per company. Recipients are attached, and messages are formatted for output.  

  Send Reports  
     Slack: Beautifully formatted updates via Slack Blocks  
     Email: Branded Weekly Google Business Pulse summaries  

  📈 Example Output

  Slack Message:

  Weekly Google Reviews & Impressions
  Number 1 Auto Repair
  Sept 22–28, 2025

  • Impressions down 41% vs last week
  • CTR 3pp lower than 12-week avg
  • 2 new reviews, 100% positive sentiment

  Email Pulse:

  🧾 Requirements
  Google Business API credential** (OAuth2)  
  Google Sheets credential** (OAuth2)  
  Slack credential** (OAuth2) — chat:write, users:read, channels:read  
  Gmail or SMTP credential** (for email pulse delivery)  
  OpenAI credential** (for summaries)

  ✏️ Customizing
  Add other KPIs (Google Ads, GA4, POS data)  
  Adjust scheduling cadence (daily, bi-weekly, monthly)  
  Send reports to Notion, Airtable, or HubSpot  
  Update Slack + email branding for your agency  

  💡 Use Cases
  Agencies automating client reporting  
  Multi-location businesses monitoring reputation  
  Service centers tracking performance trends  
  Anyone tired of paying for “Google Business Pulse” dashboards  

  🎯 Why It Matters
  Most marketing firms hide behind “AI dashboards” to sell visibility reports.  
  Google Pulse Pro gives you that same power — automated, AI-enhanced, and free.

  Unchain your reporting. Impress clients.  
  And keep your marketing dollars where they belong — in your business.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.googleBusinessProfile","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleBusinessProfile","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleBusinessProfile","n8n-nodes-base.code","n8n-nodes-base.googleBusinessProfile","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/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.gmail","n8n-nodes-base.merge","n8n-nodes-base.code","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.stickyNote"]

workflow_json_compressed:
  [encoded data, 38784 characters]


name: Create Your First AI Agent
author_name: DevCode Journey
author_username: devcodejourney
categories: []
created_at: 2025-10-06T13:27:26.116Z
updated_at: 2025-10-06T13:27:26.116Z
url: https://n8n.io/workflows/9311
scraped_at: 2025-12-24 13:02:45
description:
  Who is this for?

  This workflow is designed for anyone who wants to automate AI-driven chat responses integrated with Google Docs and Google Sheets, using the Google Gemini (PaLM) language model via n8n. It’s perfect for teams looking to:
  Automatically generate AI replies to chat messages,
  Pull content dynamically from Google Docs,

  What this Workflow Does

  Receives chat messages via a webhook trigger.
  Sends the chat input to the Google Gemini AI Chat Model for generating replies.
  Optionally retrieves a document from Google Docs if a URL or ID is provided.
  Uses an AI agent node to coordinate between the AI model and tools like Google Docs.

  Key Features

  Integration with Google Gemini (PaLM) AI for natural language understanding and response generation.
  Ability to fetch and use data from Google Docs dynamically.
  Modular structure using n8n nodes for flexibility and easy customization.
  Credential management for Google APIs (Docs, Gemini) via n8n’s built-in credential system.

  Get Your Google AI API Key
  Visit Google AI Studio.
  Click "Create API key in new project".
  Copy the API key that appears.

  Add Your Credential in n8n
  On the workflow canvas, go to the Connect your model (Google Gemini) node.
  Click the Credential dropdown and select + Create New Credential.
  Paste your API key into the API Key field.
  Click Save.

  Start Chatting!
  Go to the Example Chat node.
  Click the "Open Chat" button in its parameter panel.
  Try asking it one of the example questions:
     "What's your name?"
     "What time now in bangladesh?"
     "What's the weather in bangladesh?"

  You're now ready to chat with your personal AI agent powered by Google Gemini! 🎉

  Requirements
  n8n instance with internet access.
  Google Cloud account with:
    Access to PaLM API (Google Gemini).
  Proper OAuth2 credentials configured in n8n for Google APIs.
  🙋 For Help & Community
  👾 Discord: n8n channel
  🌐 Website: devcodejourney.com
  🔗 LinkedIn: Connect with Shakil
  📱 WhatsApp Channel: Join Now
  💬 Direct Chat: Message Now

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.googleGeminiTool","n8n-nodes-base.googleDocsTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE8VY3W7b2BF+lbNM0diGjsT/HwMF6nVgW9nEMexs0nQdJIfkUGJMkSp/JCuBgdz0anvRdgsUWxTodYHe9AV60UfJE/QROnMOJVG2k3W6BRZBEpucM2fm++aX77Q01na1y7GxmBnZbP/gmVUdjY+0njaBWmi777Q0r2qRRzAkuSgMhAGOZRqe64WuZbiuZXumb9mGaXnguHZoOr4nQsMJPTsSuvADCHVTOJbt27GLemuYTDNRw34JcXUGdTPdL/AJ1IAX1GUDVz0tFxPA21AEBdmLoinZQVpWNdsbsr0R5DXpEaNK2/3mJUoXMdCP75QvkSN0K9FN7ruJ4LYZ29y3kph7geuGdpA4bpJoqzu6GhdTevLL3M8H+JdLvTwT+SgaizTvi1ZuWlRpnRY5Xqn3dDRgKkpUVkNZEWDFlF7Sj1dXSukzfCPlzb5x1WvNdCzLFpahc133Em5bwuNB4js8Md3IC0w/cZJ4beZZnUYXC3Zc1LC2dG1kKCroV1KmFekYyQ2kqMct84ap8zSux9quoeN7bQzpaFzjb4aDv0VFXpO7u9o99mQG5SyF+Xl+nj8dpxXb2cGrd3bYvCgvkqyYsyytULpiSVGyNI+KSZqPGKJWswlUFQJX9VhTAZ08LIpRBuwQUCZlWyfi0eNtVDVLBb58hGDvE9j4pC7YtCwiPM9QawnTbNFjClyRZQt8IuKKibXKB0VU4bkkxZ/TBG/OSRbiHhN5zLJiVLGwqMesHgMZQ5ZOm1q+pEd7Q44EQ4khF6PyaookoqIc7SBP+uT9vXvsAGOywdfnOWdPy3Q0AgxkNh9DjrZ0XWYIVAkRpDOISfhr8v8W7wftLydlsS1hWIGgIpPOPlm73WIC5HrHcRYXUTNpxR8XcZOJkmFopKOcfXj/HQNRLQjSqKlqpOcttO58+Otv2Sn8pklLoNOVenyPPS2KrGI/Z2dEPV7IjgFi5chrJP81W9YFtlVBlvBxURFuyBS+7UdZ0cTbJLzp8N7JUDlNgh2/O5JnY4C6kqx03RMReS2x2GvqsckihJ0YFpkKu1YYb6gYBm+SjhoiBlFEg87z1t3//O0v79kRRixCgYQwGc7P2zBWnht9tr88z55DOC6KC7ZPxLZ0n2N0HmPa7WKwvX5OxG/QvuT8tYwQ0k85yiIxlXFzPfzaY0vczT7bWrK9zY4QBkKvA8SQTpF0x4hDwDBeRQD53Dkh7Rgmq3vvV+sIzaOsiWUoZWl+QaQMH7Ai2QitHp5cOlFCXaYwA8VPlWLhTpMUf01r5S1cj170G/HByFVaRIPRJ7BQyViWWZPWGKc1RET62ocSEkwsjK8lMFYfA0alJ7WB0zZBryOxEW6SNUwGyCQIa9PKoqlhjUM9xgcjVRnaoxM6JZGr2bIskIHVRJR1j8nyeFk3IluVio3i1FRUAWuZRFvQH/V7ij0qWlBur6Lx+2/ZAaJ+BNkUkw074aTJ03pB7zm+/sO/2IO0iooy3mXfYBxTpOU5ZC+3xnU9rXYHg1i97o9Gg+DswcFXh/nYfLGtTv/u9xS/2AcAT8cwi9CnN9hMc1j0sUZ3lNx412r405/ZIwwMiIc5qsC0yJEnNk+xip6NxUXaMWQ+n/czKYutEjUM0nxQSZnpaNCq++6f7DlSUu1Np8QNeYJqHxbIyHEx7+giITGdSj2tywNdN4NnoZO5D5sHTy++cr48fXJ6nOtftrr/+A+EqiTziHVU+7gld1Oz6E9g4Pu6gbOLZeqB421r19v0uknrgRm6wnB4YIDLbYCA+yF4PIlsJ8ahwov1aN2kVejcYZIYyShV4lRoN/u1Yds907vZrWVI0hj2Tnv1qszUtNSTj/EyasGoZyayhn6VwtVgJO/gZh8Hi0xUY5SIRDSGGPOnyepjZfjHhBGYzjRDM6Fq5mSCvEiNXWWRrbRo3dHhEOsgJpkqd/QPT7B8YElbqH7ex6TI72OCtXICExNbdBoxQhBlMrHoa1cvaZDq1Hu6XkF4IrLJ3jSVcyrx9Wb+9jS6jMwD7/DkyYv8RYebbmFQUwfDk9RXigaNvTGrrYMgSUJHDx2fW5bvc9vRbR56hsHDxAidyDDDOOwMlJTmHx3RlNUkcpN2pPxW2mWVJV2/ePeODWjy4lRF18MKglpMcHopcEwr0xh2Buxn6tHW/TNVohf3e+z16x67H+K1IPL72+zqSiN2SYW8XxsBxc+yAH99+uh/vBK9ezV88KooX6GO5b0V9o18pK79GJkEi2ruXUqbafGiGc6GRye/TkaXYnGD0uV4cDuN5orGUE9ccIOIR6YVclu4MRdxrHMn8RLDNyLd8Oy1cpqJoKo/yiQVlFbmJpXW7Uw2lLTashQpp/vRZKD1PrU02P21D5YpfMeILW6Ch6EYYj0KdC/mviFcS7esIAj16/VI1sM7FKVsQoKHndJ0fY1w9Vvd2rT9p8tTy3Bsm3a+IA6B254N3Pf0hHtGAK7hJkZsOOuL9jsz2x3QoRGvnf+uwWLpttwC52pUlHty4LihYzoRTwKBpoCIuC9M4GHsxxb+cQObduFNHKdNmKXRsqxvFF7EghB9vKq/2lHKjkWefkFDwrc3O1hn0dRDMBLc2jl4poX7cIi2WJ7NPUfXkyCwDV+HWxdN87M3TYwPx70RH1GRFaW26/WW+6Zt++t107Lcbss4z2//wznvLiaLolGTJQ4HIxhgIuNEissd9hkaupiQIiWOKtWYhThm57i+qBEU2xRObbSJXMBCzrGy/VQFNqBY1ILR9CEvmAscRHFRkO+pYYmFbEyfGBhcNzCEFyeYLC5u9bpr8MDWA+5GZgJm7MZWZN4KtvX5a71p3xFv07Q/E+8V2mqzkYh9AnIlcFfMPwGf5cQJJE7AdRccbLW2iSkcYX2zROyGrp5EoUcThhQeXlwaL8yDt8ODLzP41cNpmA5vhda4YyCjMzK1/v13Zuqmwx41Ebp0AgtsXZosbKImYLVrLzaKgev3eHAXTtxODpibnOxFdTqjPUdit/rIIleusShB7imqWiiCsNFSnGa4BkpCcMkU2QU9koQsv3F98Qnk7SAwAz8U3A08mnQtnYe67XAP924/NvUIh9/PR/6OUf3/QN7Xe9zU/R9G3grcTjZQKep867qnvjYiYmK5ve6e50af7eycqr0et8zlGMxo5JFkEAvnuUliZ5DhEkLfr/B5SbdsroFz9AUp6mF2zKseg4lIM1xhLHUFrZIxfVmjFSvD63psjLth0mB65dUcfVIJuhe/aapa0Sst/fD+e/q6draoapiwtlFIK3Anw9Grx0IYi1lalOpzGJUzXNz7t+f/LYGCwAqKS+Qywd6OHaqCukbNCmXceqE8KTAkF4jjMmarA0ToDNl4Ms9l4xQzdFeEGQzzx/snK1VwCVFDTD4pcT1GBTODTJip62VLFUZi2q7lccu2Y27btsF9LAkcNzFT6IaAxHXU8kE7ats61TSO/4v0FbGAgYL7Sq42ppuffpdS1HBjuNR29auXL9GOdhz60XqWQ+WPVrSSpLUQxxNS07FUjXzqFhphGowF+Rnkh6/bFL9+78bQ1Ln7EzqlyKaeq6v/AgvIsP53GAAA


name: Auto-Summarize Blog Posts to Social Media with Gemma and Postiz
author_name: Kyriakos Papadopoulos
author_username: lzrd
categories: []
created_at: 2025-10-06T15:41:06.688Z
updated_at: 2025-10-06T15:41:06.688Z
url: https://n8n.io/workflows/9316
scraped_at: 2025-12-24 13:02:41
description:
  Auto-Summarize Blog Posts to Social Media with Gemma and Postiz

  This workflow automates fetching the latest post from a Blogspot RSS feed, summarizes it with an LLM (e.g., Gemma via Ollama), extracts and uploads an image, generates three relevant hashtags, and posts to Facebook, LinkedIn, X (Twitter), and Instagram via the Postiz API.

  It ensures content fits platform limits (e.g., 280 characters for X) and prevents duplicates using hashing.

  Pros:  
  Efficient for content creators  
  Local LLM ensures privacy  
  Customizable for any RSS/blog source  

  Cons:  
  Dependent on stable APIs (Postiz/social platforms)  
  LLM outputs may vary in quality without human review  

  Target Audience: Bloggers, content marketers, or social media managers looking to automate cross-platform posting from RSS sources, especially those focused on niches like health, tech, or personal development. Ideal for users with technical setup skills for self-hosting.

  Customization Options:  
  Adapt prompts in "Generate Summary and Hashtags with LLM" for tone/style (e.g., professional vs. casual).  
  Modify maxChars/hashtag reserve in "Calculate Summary Character Limit" for different platforms.  
  Extend for multiple RSS feeds by adjusting "Calculate Summary Character Limit" array.  
  Add error handling (e.g., IF node after "Create and Post Content via Postiz API") for API failures.

  Disclaimer: This template is designed for self-hosted n8n instances to leverage local Ollama for privacy. For cloud use, modify as follows: 1) Use an n8n cloud account, 2) Replace Ollama with a cloud API-based LLM like ChatGPT in the "Configure Local LLM Model (Ollama)" node, 3) Switch to cloud-hosted Postiz in the HTTP Request node.

  Template Image:

  How it works

  Set the RSS feed URL in "Set RSS Feed URLs".  
  Fetch the latest post via RSS.  
  Normalize fields and calculate the maximum summary length.  
  Use the LLM to summarize the text, append hashtags, and include the link.  
  Extract and process an image from the post HTML.  
  Validate inputs and post to social platforms via the Postiz API.  

  Setup Instructions

  Install n8n (self-hosted recommended for Ollama integration).  
  Set up Ollama with the Gemma (or a similar) model using "Ollama Model" credentials.  
  Add Postiz API credentials in the "Create and Post Content via Postiz API" node.  
  Replace placeholders:
     RSS URL in "Set News RSS Feeds"
     Integration IDs in the Postiz HTTP body  
  (Optional) Add error handling for API failures.  
  Activate the workflow and test with a sample post.  

  Uncertainties

  Changes in social media APIs may break posting functionality.  
  LLM output consistency depends on model choice and prompt configuration.  

  Required n8n Version

  Tested on n8n v1.107.3 (self-hosted).  
  Works with the community node n8n-nodes-langchain.  

  Resources

  n8n Docs: RSS Feed Read  
  n8n Docs: HTTP Request  
  Ollama Setup  
  Postiz Documentation   

nodes_used:
  ["n8n-nodes-postiz.postiz","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.splitOut","n8n-nodes-base.rssFeedRead","n8n-nodes-base.set","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmOllama","n8n-nodes-base.code","n8n-nodes-base.set","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.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.editImage","n8n-nodes-postiz.postiz","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.code"]

workflow_json_compressed:
  [encoded data, 9448 characters]


name: Send One-Time Email Alerts for Urgent Tasks with Google Sheets and Gmail
author_name: Yassin Zehar
author_username: yassinzehar
categories: []
created_at: 2025-10-06T19:31:12.163Z
updated_at: 2025-10-06T19:31:12.163Z
url: https://n8n.io/workflows/9324
scraped_at: 2025-12-24 13:02:46
description:
  Description

  This workflow sends a personalized email when a task in a Google Sheet is marked as Urgent, but only once per task.

  It prevents duplicate notifications by updating the sheet after the email is sent. Ideal for collaborative task tracking where multiple people edit the same spreadsheet.

  Context

  When working with shared task lists in Google Sheets, it’s easy to miss critical updates — or worse, trigger multiple alerts for the same task.

  This workflow ensures that each "Urgent" task only sends one email notification, and then marks it as “Notified” to avoid duplicates.

  Target Users
  Project Managers using Google Sheets
  Operations or support teams managing collaborative task boards
  Anyone who needs alert automation with built-in anti-spam logic

  Technical Requirements

  Google Sheets account with edit access

  Gmail account for sending notifications

  Google Sheet with columns:

  	Priority

  	Notified

  	Task

  	Owner

  	Deadline

  	Status

  	Next Step

  Workflow Steps


  Trigger: Watches for changes in Google Sheets (e.g., edits to the "Priority" column)

  IF Node – Checks that:

  Priority = Urgent

  Notified is empty

  row exists (required for update)

  Send Email: Sends a personalized message with task details

  Update Row:  Writes “Yes” in the Notified column to avoid duplicate alerts

  Setup Instructions

  To set up this workflow:

  Connect your Google Sheets and Gmail credentials in n8n.

  Copy the spreadsheet structure or use your own 

  Import the workflow, select your Sheet (and the column to check if you use a different Google Sheets template), and test by marking a task as “Urgent”.

  Check that an email is sent and the “Notified” column updates to “Yes”.-

  Key Features

  ✅ One email per urgent task — prevents duplicates
  📧 Dynamic email content with task info
  🧠 Built-in anti-spam logic
  📋 Simple to configure and reuse
  💬 Customizable for any team’s needs

  Expected Output

  An email alert is sent only once per task marked as Urgent


  The Notified field is updated in the Google Sheet


  A clean and scalable alert system with no duplicates

  Tutorial video:
  Watch the Youtube Tutorial video

  About me :
  I’m Yassin a Project & Product Manager  Scaling tech products with data-driven project management.
  📬 Feel free to connect with me on Linkedin

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1Z227cuBl+FUIpuglgjXU+GElaJ2tng43tbOzEycZBQIq/PIw10qyk8dgxBtibXrU3xfa+QFGgV32pfYI+Qn+S0ow8lo9Z9KIIEsMzJP8D//NHnxmCG2vGd/tD/zh/l7+Nx5Bn+/vGijGCmhprZ4bIq5rmCTyX5yzPtcLQ4dTx05Al1IlZ6kPqMMe3rSigkZ8yz4oD33JpkIaR7TsBdx0GKbfciAfIt4bROKM1PC2BV7tQT8ZPC1yBGlBAXU5gtmLkdAQobRdyTnZyMPfECMjGiIqMrGdQ1hVJi5K8Lg8hr8kerY4qMhX1kDwrisMMyO4QAM9QpH4miaRUelgZa+/P9HXDzxvTF5tPs2N4+2Qj4cyYizzUHCrJAVeTElBVvl7jlmM5vmlFph3tWeGaHaw5ziD0gx/x2GTMrz82W2mkw/rn7Y3dn1683p/ub5UbcUd6o+21Yq34RmLlsdkHZF9w6Fzf5akfeABmBMw3PScNzCgMUtN17RRinoRx7C2U2q1FcnRKtosabGnJ07FczaPcVGxNRisYVOqQPINHxkUlalHkKNG0PW/FDKwItRjTEjnWUFYyrpIiK0pjzV0xpoLXQ/xkeSvGEMThEO9jhwGaochr9DBKu3ePvIKfJgJj5iA/yH/9+R+tryvta7QYx6OCZs2uCpbFKlpfaf4GpSvN7Lk73DjxfJcmpu26aA2On2hgMxOiNA59l7lpZPVa49bGkJfqtUVjAT+wFhaILGvJAvYDsleKw0MoV8imyJCY/J68KqbkeZ4W0izN7tpBbi6lQrND7hc5SYY0PwQicnJgvCxFUYr69MAg6I/JKH8g+WjmIj9UnJ5vEnk3kqrVihS5Wm5JySPko1PxwJAbeG+RCuBEVARzHZnjYllMP+aTEUMd4ERUdSXlPIGqRj40QXuBYrqeTekpenMIyRH5+BGpmuNEpOS0mBAsHTmpC6JDn9TDJgK0RnCMWlSkwrqB2pPRJKsFlhZCddFgp2RSyQ2KKrdq4tWxwNWTSrLYyKtJCVheJllG6KQuRlT6Du1cQiYoExne+IpY8mM/ZnbqmizkGEvgOibzKZiWawOLbBrF3O2NJefWwRT6zpWJ5c8Ty7Giq8LKeUBUoVX1VbpFF9ptVEE7GvkWOc3EZ/TpCKqKYvTIcqt2ZfUl8j7yy840h1J++BYoz0SuFnfn1l1PlDHLTib3BcHrCogkJgzLIJb2+wcH+QNV8fEHHVJLF2L4gtKTFfx0sKQnqSbsEyS1agHNZWXUiNG4LI6BJBlVoSu30d3jIq8Ehg7eDTldXSpiliRgBhFnppfYAfootk3fdVKLyypi273udW/t3viyWtG41+uvmxfd6z4gr3WydEuCtHyzLCtI4+zG+mvddH1Ezs7I7z6haQed1dlMuRbq85mENj4w3kGFH9FdNbZtzK3R+BI/a/mUHNNsApK2xu0jTGpaq8zWDp5SldEqxdePC8EXCc4n40wkyKQiOZzUSuCiJsgC1LRISbtFj/AcFpGSVKcVjiEq78GkU1rCFU4PAogjFkWmC0mA3dKKTZxzQtOlLA1Szw8Dt+P0ttJOh5C3E4quL5eGgJ45dKVuyM/Hgkxg60IgFGO53cYE1u5qr9indYIh8X5e2I0PM8kqy+QIpc4KvLkaBUaogZxGjqE83RL5BCNwJk8r222r25wZWIMzPZattAQZ1mPUTzlNziyCP5L9MaFYtfkrqLDovpZExrCux9Xa6iovkqq55CApRqvVGPOa68a9yldt6n2cvPv47PPnp0cvXvFN5/Q0Hu1Zez988tnbqjzZebKxnz/bCaKt+PUqcFHf6xOpFTY2YSIyDHJbOhQFT0boADm63uQqt9Hkf3rjP0yq8SNeYo2q+FH/xV/BuChlZTRmMzVANoOP8nlPhO2sT+qhsz4WKiZknL/Z2inefV/xcv3ojfPDzrtFTPfPEjRJiglGt6ckXpI81EtcL/RTM3C5a3oxtUzmhjhqeowGfuIF+L8jCHTiy76vC82NkuZ8tnh2cGW2fA3x//cQvxjbsR++3EmyZ3z33fabb9NPl8V2G9PuxZj2BuEiqiH1Ym5h9+dOZHpW6CJkiBE3eJRZlh/bMXSi+mmB3UpNPtjiZOtaNLdLw1uk54M6cLzrgjppxSx3h+P2Cs6KkUFav2liQVm5Ahz+pJhjaCNHXRvnKE61cKOqS5HUhpIxYiKntZxADJyejPNiW4DJuMsZ/jMjjzmmR53YZEngm9TCWsDBiSwm71eModS8zlpbaZAxaHcGOCpKB8/NJFXBAGhptX7Nodn56z06O1Njy/suzPkwmyFxKYel9pxu0gt4nrqIA1MITRZ7qLwXofLobNPmaQieB9y23CXlWx+2JaurXF7UGxIF4bLEHhk0cpunjiWN+yatZYU7qqZYXQPqmC7H+cQLaWpGju2bzEtwIIUIPAf6Ve234631nGO9Pi0/XMghZ+DMdXfc0HZ8LzStyMOxKgw5dgY7MpMAUjdKXQ5JusghjUkUjru8JTQZ1UmbyEWQZHseZs4U2LAojtQzVgiWFwSWZ3JmUYT8TmBGDJsUT3nqWF7iecw3lpNNZu5egdRyhByo9P0jnFD5diUroHoyU+BIWug7sfKQlY/lz0G+TmqJkoY4yDLAsXBEyyO0GX59yB7r8Hu4yh5LTCMrA2IUBV7UNCzHXFVVBwt+//n7L3+RpBJ7rSnKRajLNRXm7dG//lMeVchs+ayGa93Dv/xJHm7R2/L5Oao7R/JnSaJB3jJBA/26x//1b3l8W07ruzWMlynUBg7n4zmRJnyZAboYwdqxgClaCUd7ZVOJDQqsrPgb3V4Jhs5YUP3689/kBxXm3fav0SH6aZ0kWBcQQmRLLkozikMOX3aJfhfs6T4yGnTbmfecrXhzujc8ect3f3zm7G8XnZ6jg1n3moudxhks5qck9i3mM8v0LZBPdQHWVOaCmUQeMN/lmP2dTtMgKjk+UYmUVPCM6egOU5RteVabOhcAqAQbqrPoXD+bQ0CUgOhPloJ5AWvrxf1vLk533zwYSDgy6Kl50k04AYzooqvI0O7pBFxU44yett2rfV0w1lJ0Dsz3myGiYcIhpThZbGm81JxMKKJUxL+Y5s2GLn6NfJUuX6xAy+UuGrQJ+MVKdBjdRY/dJUB7Ry3mbO6iw7xSfLEaXU530WSOtb9UkQ6jO1mkTcIb6DEqjjtqXGegBeO76CV+e43ERV00n2tUqYcSpTz/7RXqML6LiTLKIHvOb5RSt9Krw/guenXK+MqFKfdazSjfybObBv85UbfRFRvUiI7HaK0tDXmRGEvbE8iKqRzK5FHcfNq2rfddUUhMa/knyXqvQJyGUKnew2tWC6F6cVNAxqu9Yle7Re/OluaK7iytHx6Nr28NX98a7vbWICMz0bC8CcUK1J8+lApwAslEhtpOydWMdaxc1EB9DXICiB2OOJbaDAGWjVArtqLQxCVmR9zxgjDR+D2HZP5Y0AVa+BW/yWkQR7Bc+/j6EVORrBgi53BirFmzD/JRuedlr4/7jZ5KegVc8e7eJ+iql8Ze/ldp1iegF7D2cJ7N/guUzIRwgyEAAA==


name: One Telegram Chat to Edit, Thumbnail & Auto-Post Your Videos Everywhere
author_name: Juan Carlos Cavero Gracia
author_username: carlosgracia
categories: []
created_at: 2025-10-07T21:18:20.726Z
updated_at: 2025-10-07T21:18:20.726Z
url: https://n8n.io/workflows/9363
scraped_at: 2025-12-24 13:02:43
description:
  This workflow turns any Telegram bot into an AI-powered social media command center for photos, videos and voice notes.

  video demo

  From one Telegram chat you can:

  Send a photo and auto-post it to Instagram, TikTok and Pinterest with AI captions.
  Send a video and:
    Let AI generate titles + descriptions and upload it to TikTok, Instagram and YouTube.
    Use /thumb to generate 4 custom thumbnails with Nano Banana Pro.
    Use /edit ... to run FFmpeg edits (cut, mute, resize, speed, etc.) via Upload-Post FFmpeg jobs and get the edited video back in Telegram.
  Send a voice note and turn it into posts for LinkedIn, X (Twitter) and Threads, then auto-publish.
  Keep human approval in the loop: every caption or text post is shown in Telegram for you to accept before publishing.

  Out of the box, the captions and long descriptions are optimized for Spanish (es-ES), but you can easily change the prompts to any language or brand voice.

  What You Can Do From Telegram

  1. Photo → Instagram, TikTok & Pinterest

  Just send a photo (or image as document) to your Telegram bot:

  The workflow downloads the photo from Telegram.
  Gemini 2.5 Flash** analyzes the image plus your caption/text (if any).
  An AI Agent generates platform-specific descriptions for:
    TikTok (short hook, 90 chars)
    Instagram
    Pinterest (title + description)
  You receive a message in Telegram with all the proposed descriptions.
  You approve or reject with inline buttons.
  On approval, Upload-Post publishes the photo to:
    Instagram
    TikTok
    Pinterest (to the board you configured)  
    and sends back a status message with success flags, post URLs and error messages.

  2. Video → TikTok, Instagram & YouTube (no commands)

  If you send a video with no special caption:

  The workflow treats it as a standard video post.
  It fetches the file from Telegram.
  Gemini 2.5 Flash** analyzes the video and describes its content.
  An AI Agent turns that description + your caption into:
    TikTok description
    Instagram description
    YouTube title + description
  You get a Telegram message with the three platform descriptions to review.
  Once you approve:
    It shows “Uploading…” in Telegram.
    The video is sent to Upload-Post, which uploads to TikTok, Instagram and YouTube with the generated text.
    Finally, you receive an upload report for each platform (success, URL, error message).

  3. /thumb → AI Thumbnails for Your Video (Nano Banana Pro)

  If you send a video with caption exactly /thumb:

  The workflow downloads the video.
  Gemini 2.5 Flash* generates a *long, SEO-rich description in Spanish** of everything that happens in the video.
  A second AI Agent uses that detailed description to create 3 concepts:
    Each concept has: title, description, and a full prompt_thumbnail (Spanish, single line) specially crafted for Nano Banana Pro.
  In Telegram you see the 3 concepts (titles) and select:
    0, 1, 2 or “create new”.
  Once you choose a concept:
    The prompt is sent to Nano Banana Pro (fal-ai/nano-banana-pro/edit) with your reference face image (configurable).
    Nano Banana Pro generates 4 thumbnails (16:9).
    The workflow downloads the 4 images and sends them back to you in Telegram as photos so you can pick and use your favorite in your YouTube/Upload-Post pipeline.

  Use /thumb whenever you already have the video and just want killer thumbnails generated with AI.

  4. /edit … → Natural-Language FFmpeg Video Editor

  If you send a video with a caption starting with /edit, for example:

  /edit cut the first 3 seconds and remove the audio
  /edit crop to vertical 9:16 and speed up x1.5
  /edit blur the background and keep the subject centered

  The workflow behaves as a text-to-FFmpeg command generator:

  An AI Agent (powered by Gemini) reads your /edit instructions.
  It generates a safe FFmpeg command in JSON format:
    Always uses ffmpeg -y
    Uses {input} and {output} placeholders
    No semicolons and no dangerous shell characters
  The workflow then:
    Downloads the original video from Telegram.
    Calls Upload-Post FFmpeg jobs API with the video and the generated full_command.
    Polls the job status until it’s finished.
    Downloads the processed (edited) video.
    Sends the edited video back to you in Telegram with a simple sendVideo node.

  This makes Telegram a front-end for a remote FFmpeg engine: you describe the edit in natural language, and the workflow handles all the FFmpeg complexity.

  &gt; Note: The edited video is returned to Telegram; if you want to auto-post it, simply send the new video again without /edit so it goes through the normal multi-platform publishing path.

  5. Voice Notes → LinkedIn, X & Threads (Text Posts)

  For voice messages:

  The Telegram Trigger detects message.voice.
  The workflow downloads the audio file.
  OpenAI Whisper** transcribes the recording.
  An AI Agent turns the transcription into:
    A LinkedIn post (Spanish, long-form dev/creator style, based on your examples).
    A Threads post (Spanish, up to ~500 chars).
    A Tweet / X post or thread (English, using hooks + hashtags like #n8n, #automation, #dev).
  In Telegram you see a preview message with the suggested copy for Threads, LinkedIn and X.
  After you approve:
    You get an “Uploading…” message.
    Upload-Post publishes:
      To your LinkedIn organization page (configured by ID).
      To X (Twitter).
      To Threads.
    The workflow sends a status message with success flags and URLs for each platform.

  This is perfect for “talk to your phone, ship content to all your text platforms”.

  How the Workflow Is Structured

  Telegram Trigger**  
    Listens to every incoming message and routes by type:
    /start → No-Op
    voice → Audio pipeline
    document/photo → Photo pipeline
    video → Video/thumbnail/editor pipelines (/thumb, /edit or normal)

  AI Blocks (Gemini + OpenAI)**  
    Gemini 2.5 Flash for:
      Photo understanding.
      Short video descriptions (for auto-posting).
      Long, detailed video summaries (for thumbnail generator).
    OpenAI Whisper for voice transcription.
    Multiple AI Agents (Gemini chat) with structured JSON output parsers for:
      Per-platform social captions.
      Threads/LinkedIn/X posts.
      Thumbnail prompts and title concepts.
      FFmpeg command generation.

  Upload-Post Integration**
    Photos → Instagram, TikTok, Pinterest.
    Videos → TikTok, Instagram, YouTube.
    Text → LinkedIn page, X, Threads.
    FFmpeg job endpoint for server-side video editing.
    All uploads return status, URL and error messages back into Telegram.

  Human-in-the-Loop**
    All critical AI outputs go through sendAndWait nodes in Telegram:
      You review and choose whether to publish or not.
      You choose which thumbnail concept to use.

  Requirements & Setup

  Accounts & APIs**
    Telegram bot (via @BotFather).
    Upload-Post.com account with your social profiles connected.
    OpenAI API key (Whisper).
    Google Gemini API key (AI Studio).
    Nano Banana Pro / fal.ai key (for thumbnails).

  Runtime**
    n8n instance (cloud or self-hosted).
    FFmpeg available where n8n runs (Docker image, VM, etc.) for local checks if needed (the heavy lifting is delegated to Upload-Post FFmpeg jobs).

  Configuration**
    Create Telegram credentials with your bot token.
    Create Upload-Post credentials with your API token.
    Set upload_post_user and pinterest_board_id in the Edit Fields node.
    Optionally replace:
      Example face image URL used for Nano Banana Pro.
      LinkedIn organization ID.
      Any language / tone in the AI agent system prompts.

  Ideal Use Cases

  Creators & influencers* who want to post to every platform from *one Telegram chat**.
  Agencies** who want a “content butler” clients can use without touching n8n.
  Solo devs & makers** who publish workflows, devlogs and product updates and want:
    Multi-platform video posts.
    Voice → LinkedIn/X/Threads posts.
    Easy text-based video editing and thumbnail generation.

  Install this template, plug in your keys, talk to your bot in Telegram, and turn it into your all-in-one AI social media machine.

nodes_used:
  ["n8n-nodes-base.telegramTrigger","n8n-nodes-base.switch","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.openAi","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.telegram","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.googleGemini","@n8n/n8n-nodes-langchain.googleGemini","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.telegram","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-upload-post.uploadPost","n8n-nodes-upload-post.uploadPost","n8n-nodes-upload-post.uploadPost","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.debugHelper","n8n-nodes-base.telegram","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.switch","n8n-nodes-base.wait","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.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, 24176 characters]


name: Automated Law Firm Lead Management & Scheduling with AI, Jotform & Calendar
author_name: iamvaar
author_username: iamvaar
categories: []
created_at: 2025-10-08T17:13:30.017Z
updated_at: 2025-10-08T17:13:30.017Z
url: https://n8n.io/workflows/9383
scraped_at: 2025-12-24 13:02:41
description:
  Youtube Explanation: [https://youtu.be/KgmNiV7SwkU](https://youtu.be/KgmNiV7SwkU
  )

  This n8n workflow is designed to automate the initial intake and scheduling for a law firm. It's split into two main parts:

  New Inquiry Handling: Kicks off when a potential client fills out a JotForm, saves their data, and sends them an initial welcome message on WhatsApp.
  Appointment Scheduling: Activates when the client replies on WhatsApp, allowing an AI agent to chat with them to schedule a consultation.

  Here’s a detailed breakdown of the prerequisites and each node.

  Prerequisites

  Before building this workflow, you'll need accounts and some setup for each of the following services:

  JotForm
  JotForm Account**: You need an active JotForm account.
  A Published Form**: Create a form with the exact fields used in the workflow: Full Name, Email Address, Phone Number, I am a..., Legal Service of Interest, Brief Message, and How Did You Hear About Us?.
  API Credentials**: Generate API keys from your JotForm account settings to connect it with n8n.

  Google
  Google Account**: To use Google Sheets and Google Calendar.
  Google Sheet**: Create a new sheet named "Law Client Enquiries". The first row must have these exact headers: Full Name, Email Address, Phone Number, client type, Legal Service of Interest, Brief Message, How Did You Hear About Us?.
  Google Calendar**: An active calendar to manage appointments.
  Google Cloud Project**:
      Service Account Credentials (for Sheets): In the Google Cloud Console, create a service account, generate JSON key credentials, and enable the Google Sheets API. You must then share your Google Sheet with the service account's email address (e.g., automation-bot@your-project.iam.gserviceaccount.com).
      OAuth Credentials (for Calendar): Create OAuth 2.0 Client ID credentials to allow n8n to access your calendar on your behalf. You'll need to enable the Google Calendar API.
      Gemini API Key: Enable the Vertex AI API in your Google Cloud project and generate an API key to use the Google Gemini models.

  WhatsApp
  Meta Business Account**: Required to use the WhatsApp Business Platform.
  WhatsApp Business Platform Account: You need to set up a business account and connect a phone number to it. This is **different from the regular WhatsApp or WhatsApp Business app.
  API Credentials**: Get the necessary access tokens and IDs from your Meta for Developers dashboard to connect your business number to n8n.

  PostgreSQL Database
  A running PostgreSQL instance**: This can be hosted anywhere (e.g., AWS, DigitalOcean, Supabase). The AI agent needs it to store and retrieve conversation history.
  Database Credentials**: You'll need the host, port, user, password, and database name to connect n8n to it.

  Node-by-Node Explanation

  The workflow is divided into two distinct logical flows.

  Flow 1: New Client Intake from JotForm

  This part triggers when a new client submits your form.



  JotForm Trigger
      What it does: This is the starting point. It automatically runs the workflow whenever a new submission is received for the specified JotForm (Form ID: 252801824783057).
      Prerequisites: A JotForm account and a created form.

  Append or update row in sheet (Google Sheets)
      What it does: It takes the data from the JotForm submission and adds it to your "Law Client Enquiries" Google Sheet.
      How it works: It uses the appendOrUpdate operation. It tries to find a row where the "Email Address" column matches the email from the form. If it finds a match, it updates that row; otherwise, it appends a new row at the bottom.
      Prerequisites: A Google Sheet with the correct headers, shared with your service account.

  AI Agent
      What it does: This node crafts the initial welcome message to be sent to the client.
      How it works: It uses a detailed prompt that defines a persona ("Alex," a legal intake assistant) and instructs the AI to generate a professional WhatsApp message. It dynamically inserts the client's name and service of interest from the Google Sheet data into the prompt.
      Connected Node: It's powered by the Google Gemini Chat Model.

  Send message (WhatsApp)
      What it does: It sends the message generated by the AI Agent to the client.
      How it works: It takes the client's phone number from the data (Phone Number column) and the AI-generated text (output from the AI Agent node) to send the message via the WhatsApp Business API.
      Prerequisites: A configured WhatsApp Business Platform account.

  Flow 2: AI-Powered Scheduling via WhatsApp

  This part triggers when the client replies to the initial message.



  WhatsApp Trigger
      What it does: This node listens for incoming messages on your business's WhatsApp number. When a client replies, it starts this part of the workflow.
      Prerequisites: A configured WhatsApp Business Platform account.

  If node
      What it does: It acts as a simple filter. It checks if the incoming message text is empty. If it is (e.g., a status update), the workflow stops. If it contains text, it proceeds to the AI agent.

  AI Agent1
      What it does: This is the main conversational brain for scheduling. It handles the back-and-forth chat with the client.
      How it works: Its prompt is highly detailed, instructing it to act as "Alex" and follow a strict procedure for scheduling. It has access to several "tools" to perform actions.
      Connected Nodes:
          Google Gemini Chat Model1: The language model that does the thinking.
          Postgres Chat Memory: Remembers the conversation history with a specific user (keyed by their WhatsApp ID), so the user doesn't have to repeat themselves.
          Tools: Know about the user enquiry, GET MANY EVENTS..., and Create an event.

  AI Agent Tools (What the AI can *do*)
      Know about the user enquiry (Google Sheets Tool): When the AI needs to know who it's talking to, it uses this tool. It takes the user's phone number and looks up their original enquiry details in the "Law Client Enquiries" sheet.
      GET MANY EVENTS... (Google Calendar Tool): When a client suggests a date, the AI uses this tool to check your Google Calendar for any existing events on that day to see if you're free.
      Create an event (Google Calendar Tool): Once a time is agreed upon, the AI uses this tool to create the event in your Google Calendar, adding the client as an attendee.

  Send message1 (WhatsApp)
      What it does: Sends the AI's response back to the client. This could be a confirmation that the meeting is booked, a question asking for their email, or a suggestion for a different time if the requested slot is busy.
      How it works: It sends the output text from AI Agent1 to the client's WhatsApp ID, continuing the conversation.

nodes_used:
  ["n8n-nodes-base.jotFormTrigger","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.whatsAppTrigger","n8n-nodes-base.if","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.memoryPostgresChat","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.whatsApp","n8n-nodes-base.whatsApp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8028 characters]


name: Automate LinkedIn Engagement with GPT-4o Sentiment Analysis & Smart Comments
author_name: Punit
author_username: punitkumar
categories: []
created_at: 2025-10-08T17:45:45.746Z
updated_at: 2025-10-08T17:45:45.746Z
url: https://n8n.io/workflows/9385
scraped_at: 2025-12-24 13:02:45
description:
  LinkedIn Auto-Engagement AI Agent

  Automatically find, analyze, and engage with relevant LinkedIn posts using AI-powered sentiment analysis and comment generation

  📋 Template Overview

  This workflow automates LinkedIn engagement by searching for relevant posts, analyzing their sentiment, generating contextual comments using AI, and posting them automatically. Perfect for DevOps professionals, cloud architects, and automation enthusiasts who want to maintain an active LinkedIn presence without spending hours manually commenting.

  🎯 What This Workflow Does

  Searches LinkedIn for posts from the last 24 hours based on your chosen keywords (Kubernetes, Azure, AWS, AI, Automation, SaaS, n8n)
  Filters quality content - Only engages with posts over 350 characters that are original (not reposts)
  Analyzes sentiment using AI to categorize posts into 7 types:
     Informational/Educational Content
     Happy Announcement
     Sad/Negative Feelings
     Hiring Posts
     Not English Language
     Neutral
     None of the Above
  Generates contextual comments using AI that are witty, professional, and add genuine value
  Posts comments and adds reactions to the LinkedIn posts
  Logs everything to Google Sheets for tracking and analysis
  Sends Telegram notifications when the workflow completes

  🔧 Prerequisites

  Before you can use this workflow, you'll need:

  Required Accounts & Credentials

  n8n Account (Cloud or Self-hosted)
  Unipile Account - For LinkedIn API access
     Sign up at: https://unipile.com
     Get your API key
     Connect your LinkedIn account to Unipile
  OpenRouter Account - For AI capabilities
     Sign up at: https://openrouter.ai
     Get your API key
     Recommended model: openai/gpt-4o-mini (cost-effective)
  Google Account - For Google Sheets logging
  Telegram Account - For notifications (optional but recommended)

  Technical Requirements

  Basic understanding of n8n workflows
  Ability to create and manage Google Sheets
  Ability to create a Telegram bot (5 minutes, step-by-step below)

  📦 Setup Instructions

  Step 1: Import the Workflow

  Copy the workflow JSON
  In n8n, click + Add workflow
  Click the three dots (...) in the top right
  Select Import from File or Import from URL
  Paste the JSON

  Step 2: Set Up Google Sheets

  Create a new Google Sheet with these exact column headers in Row 1:

     | Post URL | Post Content | Name of Author | Author's Profile Headline | Profile URL of Author | ID | Sentiment of Post | Comment Generated by AI | Error |
     |----------|--------------|----------------|---------------------------|----------------------|-------|-------------------|------------------------|--------|

  Name the sheet tab: "Open - New n Random Niche Posts Comment"
  Share the sheet with your Google account connected to n8n
  Copy the Sheet ID from the URL (between /d/ and /edit)

  Step 3: Configure Google Sheets Nodes

  Update the Sheet ID in these 4 nodes:
  Append row in sheet2
  Update row in sheet9
  Update row in sheet10
  Update row in sheet11

  For each node:
  Click the node
  Find the Document field
  Either select your sheet from the dropdown OR paste your Sheet ID
  Click the Refresh icon to load columns
  Save

  Step 4: Set Up Unipile (LinkedIn API)

  Sign up at Unipile: https://unipile.com
  Connect your LinkedIn account in the Unipile dashboard
  Get your Account ID and API Key
  Update these nodes with your credentials:
     LinkedIn Search
     Get Post from LinkedIn2
     Comment On Post2
     Leave Reaction on Post2

  For each node:
  Find the X-API-KEY header parameter
  Paste your Unipile API key
  Find the account_id parameter
  Paste your Unipile account ID

  Step 5: Set Up OpenRouter (AI)

  Sign up at OpenRouter: https://openrouter.ai
  Get your API key from the dashboard
  Add credits to your account ($5-10 is plenty to start)
  Configure these nodes:
     OpenRouter Chat Model6
     OpenRouter Chat Model7
     OpenRouter Chat Model8

  For each node:
  Click the node
  Click Credentials dropdown
  Select Create New
  Paste your OpenRouter API key
  Save

  Step 6: Set Up Telegram Notifications (Optional)

  Create a Telegram Bot:
     Open Telegram and search for @BotFather
     Send /newbot
     Choose a name (e.g., "LinkedIn Bot")
     Choose a username (must end in 'bot')
     Save the API Token BotFather gives you

  Get Your Chat ID:
     Start a chat with your bot
     Send any message
     Visit: https://api.telegram.org/botYOUR_TOKEN/getUpdates
     Find your Chat ID in the JSON response

  Configure the Telegram Node:
     Open Send a text message2 node
     Add your Bot Token in credentials
     Replace the chatId with your Chat ID

  Step 7: Customize Keywords (Optional)

  Want to search for different topics? Update the LinkedIn Search URL:

  Current keywords: Kubernetes, Azure, n8n, AWS, AI, Automation, SaaS

  To change:
  Open LinkedIn Search node
  Find the url parameter under Body Parameters
  Modify the keywords= section

  Example for DevOps tools:
  keywords=%22Terraform%22%20OR%20%22Docker%22%20OR%20%22Kubernetes%22%20OR%20%22Jenkins%22

  Step 8: Test the Workflow

  Click Execute Workflow (or use Manual Trigger)
  Watch each node execute
  Check for any errors (red nodes)
  Verify data appears in your Google Sheet
  Check your Telegram for the completion message

  🎨 Customization Options

  Modify AI Comment Style

  Edit the AI Agent2 node prompt to change comment style:

  You're an expert on [YOUR EXPERTISE].

  Look at this post and drop in a thoughtful comment - {{ $json['Post Content'] }}

  Guidelines:
  Write like a [YOUR STYLE]
  [YOUR RULES]
  Maximum 2 sentences

  Only export the response and nothing else.

  Change Sentiment Categories

  Edit the Sentiment Analysis2 node to add/remove categories based on your needs.

  Adjust Filtering Criteria

  Modify the If2 node to change:
  Minimum character count (currently 350)
  Post type filters
  Date range filters

  Schedule Automation

  Add a Schedule Trigger node to run automatically:
  Recommended: 2-3 times per day (morning, afternoon, evening)
  Avoid running too frequently to prevent spam detection

  📊 Workflow Nodes Explained

  Core Processing Flow

  LinkedIn Search - Fetches posts from LinkedIn via Unipile API
  Code4 - Parses the API response into individual posts
  Code5 - Filters posts to last 24 hours only
  Basic LLM Chain2 - Counts characters in each post
  If2 - Filters posts (350+ chars, original content only)
  Append row in sheet2 - Logs qualifying posts to Google Sheets
  Loop Over Items4 - Processes each post one by one

  Analysis & Generation

  Sentiment Analysis2 - AI categorizes post sentiment
  AI Agent2 - Generates contextual comment
  Get Post from LinkedIn2 - Fetches fresh post data
  Comment On Post2 - Posts the AI-generated comment
  Leave Reaction on Post2 - Adds a like to the post

  Logging & Notifications

  Update row in sheet9/10/11 - Updates Google Sheet with results
  Wait nodes - Adds delays to avoid rate limiting
  Send a text message2 - Telegram notification on completion

  ⚙️ Advanced Features

  Rate Limiting

  The workflow includes 1-minute wait times between actions to avoid LinkedIn's spam detection. You can adjust these in the Wait nodes.

  Error Handling

  Failed comments are logged in the "Error" column
  Retry logic built into update nodes (5 retries, 5-second intervals)
  Errors don't stop the workflow from processing other posts

  Multi-Niche Support

  To engage with multiple niches:
  Duplicate the LinkedIn Search node
  Change keywords in each duplicate
  Add a Merge node to combine results
  Connect to the rest of the workflow

  🚀 Usage Tips

  Best Practices

  Start slow**: Run manually 2-3 times to ensure everything works
  Monitor results**: Check your Google Sheet daily
  Refine prompts**: Adjust AI prompts based on comment quality
  Vary timing**: Schedule runs at different times of day
  Stay authentic**: Review and approve comments if needed

  What to Avoid

  ❌ Running too frequently (max 3-4 times per day)
  ❌ Using generic keywords that return spam
  ❌ Commenting on your own posts
  ❌ Using the same comment style repeatedly
  ❌ Engaging with low-quality content

  LinkedIn Best Practices

  Focus on adding genuine value
  Engage with diverse content (not just one niche)
  Avoid hashtags in comments
  Keep comments concise (2 sentences max)
  Build relationships, not just visibility

  📈 Performance & Costs

  Expected Results

  Posts found**: 20-100 per run (depending on keywords)
  Posts filtered**: 10-30 qualifying posts
  Comments posted**: 5-15 per run (after sentiment filtering)
  Time saved**: 1-2 hours of manual engagement per day

  API Costs (Approximate)

  Unipile**: ~$29/month for LinkedIn API access
  OpenRouter**: Free
  n8n**: Free (self-hosted)Subscript
  Google Sheets**: Free
  Telegram**: Free

  Total estimated cost: $30-50/month for full automation

  🐛 Troubleshooting

  Common Issues

  Issue: "Column names were updated" error
  Solution**: Refresh columns in Google Sheets nodes

  Issue: LinkedIn API returns 403 error
  Solution**: Check Unipile account status and API limits

  Issue: AI comments are generic or low quality
  Solution**: Refine the AI Agent2 prompt with more specific guidelines

  Issue: No posts found
  Solution**: Check keyword relevance and time range settings

  Issue: Workflow hangs on Loop Over Items
  Solution**: Check wait times and ensure all nodes are properly connected

  Getting Help

  Join the n8n community: https://community.n8n.io
  Check n8n docs: https://docs.n8n.io
  Unipile documentation: https://docs.unipile.com

  🔐 Security & Privacy

  Data Protection

  All LinkedIn credentials are handled by Unipile (OAuth)
  API keys are stored securely in n8n credentials
  Google Sheets data is private to your account
  No third-party data sharing

  Compliance

  Respects LinkedIn's rate limits
  Follows LinkedIn's Terms of Service
  Only engages with public posts
  No scraping of private data

  Ethical Use

  This workflow is designed for:
  ✅ Authentic professional networking
  ✅ Adding value to discussions
  ✅ Saving time on routine engagement

  Please avoid:
  ❌ Spamming or aggressive self-promotion
  ❌ Misleading or deceptive comments
  ❌ Violating LinkedIn's community guidelines

  📝 Changelog & Updates

  Version 1.0 (Current)
  Initial release
  Core functionality: search, filter, analyze, comment
  Google Sheets logging
  Telegram notifications
  Multi-keyword support

  Planned Features
  Multi-account support
  Advanced scheduling options
  Comment approval workflow
  Analytics dashboard
  A/B testing for comment styles

  👨‍💻 About the Creator

  This workflow was created to solve the challenge of maintaining consistent LinkedIn engagement while focusing on actual work. After spending too many hours manually commenting, I built this automation to handle the repetitive parts while keeping comments authentic and valuable.

  📄 License

  This workflow template is free to use and modify for personal and commercial purposes. Attribution is appreciated but not required.

  🤝 Contributing

  Found a bug? Have an improvement idea? 

  Feel free to:
  Share your modifications
  Report issues in the n8n community
  Suggest new features
  Create your own variations

  🙏 Acknowledgments

  Built with:
  n8n - The workflow automation platform
  Unipile - LinkedIn API integration
  OpenRouter - AI model access
  Google Sheets - Data logging
  Telegram - Notifications

  Ready to automate your LinkedIn engagement? Import this workflow and start building your professional network on autopilot!

  Last updated: October 2025

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.sentimentAnalysis","n8n-nodes-base.httpRequest","n8n-nodes-base.splitInBatches","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.wait","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.telegram","n8n-nodes-base.httpRequest","n8n-nodes-base.manualTrigger","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:
  H4sIAAAAAAAAE+1ZyW4jRxL9FYJnpib3RSe7PbYhQN0y1DP2wTAGuURShaaqNMViqzUN/ftEFSWRIpObRse5NNRkZuTLyBcvFn4f30Lnx+ffx1U973wd4SKNz8eBOcVUsj7HqESg0Tr8QGQOXAvPeJI+Oic4lVImZiNjWjqms3XWCUNh/DgZ1/4W0NTHh9F9037Js+Z+JMaTceen8/H5n3/hgiZB/yee3Z/JE43CJENczo5ImiyxVnBiwGXuuYqcp/GL2c/g23gzuqzqL5Au6tFvzbyb9+Yf7vqva1uTwT4Jfg5nN113dw3/XsC8wzV3zbzqqqbGswkzmk6Mtojnzrdou4MWQX1/XJr6Hf83rJRn/HHyhNTpQJ0ARlT2kkgTGLFOZUIZjVrZKG0MK6Q/f+taH7slwlFum9vRNcwXsz1wI/65iVMJfQzONZRK4GM5RXKUPUrwxDHFSHBGOh6kyomuUP5SzdAiIotQdwe8WYInGD8NnnCGOqMRnlSRSC48PjcYAjEIxV3SbjjkCd5PzeIJ1uinG9/7s7f/AvAHRPi3FcqZr6fxxlf12fDv5ex2Ey619hi47My8ADaMCef6V+fJE+lCJFawSBiPTAUmjcxiy5+XTT0dfWpqcg13e31aZfyqqX9u26bFb2NTd1W9gGuYLma+vVp0d4tN6pojGbHGXIxnaZNJxKDXidQ2kqAhk+w9UxgJ2nO35vRnT4+W7r+8/Dj6iJBnRzh+dou7u6s7qK+bBZooPYBz/OADvEC3ljNDkyACbEI6R2SyRNIEn7gAHZgOZgX9N9/OYbRxgSNgN4Ojh93t565dxG7RQtoA71AyjsF+Jl7Q04CvZSwn2kVKZMQ49I4BUSxLZ6zwia6x/VeoofUdjH68QOS3t3AUdj9drluDytHLjJ8QlUm6LKikJDmBBJEKRZgGS7QPkWvFpNJrJP+x9rOH/8AyLj/j6dWRUOfPawcL82q+4WEtJ8LKww5e0UNEEy11nFAQGeVEC+KspiRTpryHgJK8DjwllDqkBtoZdc1wgdOTx0BiJg/iXM8dXATFOCTiM+1VWSODDVDCRUyKgmHeyzUat02E+fwpd1T16IPv4g3slpH53azqLurVsnWv8uNEb8VaSUEb0bNWRnSqcwljTiliGHVJeM4D6BXYy2a6ZAI69PMNwG6PTptmOoNhzSZGdVwekWf6BSUIy6zAJOJEQJc69Ca+fC/R3gfvlAmOr1D+8y71kfXC1oPJeDdYzFMTdTi61rHyHJRmMRAJ2fY01cRRrwnQAFkkjfIMW1ifJOBUpLf+2z/aqi+x1Gva9qWEKtK2ha59uKp/8dVsfI7yB9tXmYzvfdV9gO4eoH62TyldCbVEgZbZExQ5lBAvUaixOsRsozDnmwga/BrDe8KUZG5vEG4nyuH/pTRpUUu4pKfEKLMOdS46EmIURCYHiAFQUASDqENf4bHXtB9O/x+YNJRPZcV7jyeh0qCqY60aQ8I4xuqduGAZiRjMhgktpV0TnT/Q2OgD5KaF0Sf4hs8z6OTOa/WHF66zFMZ7CDdN8+ViGagqYEVKiUiAfPBGEcepIw7Tt2ZY7GvVM+NozY8C4zs5SbSwaI9ZQ/ADQHkyyECjlKOqfK3le+HLTat6esrFesVfvtP6xZR1LPIQSMyo59JjGrJeS8IYOHAueOwyTrkYeG6kBugTMFYLSqK2gQKScmDcMJ5Nzuut0LOUPWfTd6zU2FE15gp6wHsr9D+hNqPKcaaJTR7xW4nQlVXRvSrrl8r2VPD02fj9oAuNb6VOKDEd9rrWJUa4ygzTRwrEM4ENqe8lk2KDa+Qrt6detu5mMAD/1HRVrqLfGysdzGCKYHBBquY+zLC4fIrqNeR0QjcY5nOWMmNzTI3E6pdHlCSHaYQjL4JziA1igWHwDSI65gr7+qJ4sDXVMw6rj4CGWepLPwwhrFF8IpiubE4ByxOzlux/had27O/QoTS9ofXWkp4qzFFn5aI0GGfIKxQtTXxCp/iouUP/GAS8gvjR1ws/G/3xPH1AZZxOB5KUkd4O61erXvUryN/TAkEG67TVjGjOh4KUEQsBiMZGXAQeHYX1cUZXxS8PPYdgd203rHla8gqcRVXC4m4T3JAc+6R6Ph7vBgpguPYukhT6vrbvrhxgECQdghP4RVS2CJS9ASnqwduRiogVsgyGJIWKIj0KblCSYxBkAVxbiXCLSPnpSLE+mqBqvxFoDk5x4ARywlCyLKMIKkeETgrl0XnraBGoOBkoRtCEvBkoYEetjfPYjwuObSmPWPNg6ZxS9iYx5ykXRaDyZKCM0x7pdtl5HFJHtQUdOQnCYDhJ2fd3qa8ikmEMW1Qs9otI1elIDb49YXpLmvYjxdV9Q/kVT8p+NkepnUOHtel02LpUYlx61SboC9evrLfxdbl/0HhEgQfUMFRbw6bN4hg/usW8hxj//D6MTw+2ssPyybiqE3wbn1MEudp5REG0tf0vxLwl/SVYO+v6osntGrpo82A3vNP46770HY2X5qYl8wcGmDscvT0GKtnenYuLZouMKdk92AgUzZdvWrJ/cEZatF8e7aF9X/1rfXx3ivs3t26eWf61oXSnY6b95Vcpz9LK771nPLgv4g/PPv6/+1129w+6Y3jz/tqzFT+lI/YM54q2dxXPJdsHfosr2t+lLSX7h8ZgZZnY5dPyDY7p5faR5NAofB9Ftpn1jiTZ/SPOUjL7bnrhp/D02Uma+Xrvvid+XV/sIuiOMVrxXnuEdk+uKf++uSOP7ZlNHPLdXok+6Lm9E51DRx9i4oHTHx//C0PXxmsUIAAA


name: AI-Powered Social Media Ad Creation With Website Scraping for FB, IG & Pinterest
author_name: Malik Hashir
author_username: malikx
categories: []
created_at: 2025-10-08T20:21:57.334Z
updated_at: 2025-10-08T20:21:57.334Z
url: https://n8n.io/workflows/9388
scraped_at: 2025-12-24 13:02:45
description:
  Purpose & Audience
  This workflow empowers marketing teams, agencies and solopreneurs to instantly generate on-brand, platform-optimized social media ads — without designers or complex setup.

  Perfect for:
  Running performance marketing campaigns
  A/B testing ad creatives
  Scaling content for multiple platforms
  Non-technical users who want AI-powered design

  Key Features
  Smart Prompt Engineering:
   – Scrapes your provided landing page to auto-extract brand voice, offers, and content
   – Use Gemini AI to craft Ideogram-optimized prompts

  Multi-Platform Ad Generation:
  Facebook, Instagram & Pinterest.
   – Supports 7 formats:
    • Facebook Feed (1200x630)
    • Facebook Story (1080x1920)
    • Instagram Feed (1080x1080)
    • Instagram Story & Reel (1080x1920)
    • Pinterest Pin (1000x1500)
    • Pinterest Story (1080x1920)

  Powered by Ideogram v3 Turbo (Replicate):
   – Public, affordable, around 33 images for $1
   – Understands layout, branding, and text placement
   – ~$0.03/image with $1 free credit

  Delivers Directly to Slack:
   – Get all generated ads in your team channel with auto-captions (platform, offer, context)

  How It Works (Step-by-Step)
  User fills out a simple form with:
   – Business context, offer, brand colors, platform, and desired ad sizes
   – Additional Features: Landing page URL + toggle to scrape & enhance prompt with AI

  If enabled, the workflow:
   – Scrapes your website using Firecrawl
   – Sends content + form data to Gemini to generate a professional Ideogram prompt

  For each selected dimension, the workflow:
   – Calls Ideogram v3 Turbo on Replicate with the correct aspect ratio
   – Downloads the image from the response URL

  All ads are uploaded to Slack with rich captions for easy review & sharing

  How to Set Up
  Get a Replicate API Token
  Sign up at replicate.com
  Replace YOUR_REPLICATE_API_TOKEN in all 7 HTTP Request nodes

  Create a Slack App
  Go to api.slack.com/apps → “Create New App”
  Add files:write scope → Install to workspace
  Add as OAuth2 credential in n8n

  Set Up Firecrawl
  Get API key at firecrawl.dev
  Create a Header Auth credential with: Authorization: Bearer YOUR_FIRECRAWL_TOKEN

  Activate the workflow and share the Form Trigger URL with your team! 

  Value Proposition
  Go from idea to ad in 60 seconds — no design skills, no designers, no information sharing, no hassle.
  This workflow saves hours of manual design work, ensures brand consistency, and leverages cutting-edge AI — all while costing less than $5 for 100 ads. 
  Ideal for agile marketing teams who need speed, quality, and scalability. 

  Available Models: Customization Option
  If you’re comfortable with low-code tools and want to use any other model from the hundreds available at Replicate (https://replicate.com/explore), you’re welcome to do so. Simply update your "POST" request to match the specific schema of the chosen model, and you’re all set. Don’t worry about the schema details—Replicate provides clear, easy-to-follow documentation for each model. Some models are free with limited quotas, while others require payment. Overall, it offers the most comprehensive library of image models available.

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.switch","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.slack","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.slack","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.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/n8n-nodes-langchain.googleGemini","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Zy24j1xH9lQY3TgBd+b4fWsWxZwwDiT0YjZOFx4u6L4mw1GRIyjODwQD5gmycbZBNFvm8fEJOU5JFiU2ym7IWRIvsrnuq7qmqU30/Tq7LiiZnHyfTdrmiNpVv8uRs4mw1VqcSiqg62EI2KaNUFcZkI4UjJcjpKKKVsZDiSTmnZdCOyOXi0uRksirX8ytalS8XJS/Py+pm/uUM35RVwQKrxU35dDJpZ7ksJ2c/YPVu1WKDj15nVlIhpg0l5ilXpnXSiULUwltYbum64O7//fuXfzUvZ4vr5s1ienFRFt2iH+bdT61v2do2i7QspxU3PdzTzlbdopPzF2++f3X2thWnzZeztk4vbhal6W5t6rRc5WVDy2Z5OXvXvm1ld8v8Q/OuxMvZ7Kfm+9d/aqiuyqJZ0s/T9uJtq06b80uCge6nd9PVZXOzLIvl2/bb7968OGveXE6XTaL5Cmss1z8103Z+s1p2CzaUm4vSlgWtprMWCOez5XR9efYDk4rrExGU/fFkcrf8eocos7tnZgvWoe6eowVCA1hw7+On22j8Bf+tTclT9enkLtBEQaekBDMlcKZzEix4EixZ7wXn2meRNgP9z783r2c3q9LED81X0+vSdiaXO+O9RADSZX+ov7haFMofmnQf8nwbLtfke8PNoltruQ77i5biVWk+++5mhXDh6avmzwTjCPpnCGEzm3eBWq434AWly2Z2e+PqdrsR9NkCIZ/P2oxHmuk1XZSNYN/vD0gKqmK/SxdDODqn1eXt5pTO6rJclQTmPoB8sk3O+hPhTbdLe3dBncpfdyEZya3SiSXnLNPOEiPNA/M+Zk66EKVHdP/Hf5uXf2xeFsD4nZCcv7eK/37nJlyuVvPX5W83Zbl6SinNT4Tm/hBWvYHV8BwMkQE4m5lOQmAVMCZ7J63gVpqstrGeg5wfAJZ7/l4EeTxaY0ehrVxpp5NjNWqUjxg189VWVrSLOppKOvsnaL/5+j6ya7D4OBqs03pcaGN2wgbkoZNMC2kZSSmQ+dpIq3w0nG+D/c1Ci2fHoC1R4C9rZkUugOwjI1KOKa8TN9yb6J+SFmhfl3L1G4CVPBzMsEc8SKKAnZHp2rURGxHaUB0rSvigCydhnrL21bSFYSzfXXWQkWcCO3A0ZOnHJRo5HpIg5osHJSQo4YPIrCorrXW6GOF2Qv6tSCH1uDhnMiFVtGttCRSm4llQRjNH0AImcScfg/7lP815afN9OdvdSK4o/fQYnzX2vnhttkPrHAUbESxfDEOUEiMIFkZVicoRNyn4mA6ZgV/xjA5pNaSI4qh3wWWmJCRP4CHWssuj9SaMdum2wm26pA1AOOE6CYD2oGJk3orAVMokgEHFQGNcMgFRicoz1aWv5lIyyDrLvKOapVbC9rt0VxlHe3RbBjc9SgnsJidYqdWD27GwKBLkHjedduQhhzjGoxp8NVmDbCGhFumA9kS+ohapWIRHFuz06LhNuq2Vmy5Fm2Wu2bIUrWA6gDGkSmGUQla8eB5NGedShq72hlnrocxwySgnzkxVvqZqYS7scKmrsWM9uiuomx6pWiyqpWdOJNCkisqiM5LhO0fSOR+1HOOR9TCmrGc8Yr+1QxLhwjBnUGRyCOjTos+jR4V4tF+3VfdROqGKexCPKehdVAjQ0FuZmTQGOW2y9+PSSQhpkujsZTRr2ERv8WBg9tULqwIS9oBfR3HwrjRveoY5ySB9MjJZdmNTwBUmBiZ5DUHwXLK0YzzzkbQoCJKT3oGDstOlnaNw2QcMhlZsdM3z1TT99KH5FlJfiN3erO/qbtqab7w+kWJbMk0wIaxKu4KtyVO04qFO80DOC8WS112br5hktNQMxc4HzoURlPqxyvFYRXgWVs2RQwWtHcIODKxQI9HxikQrMlNBe7GiH+sRYdWcnwS5JT2GRlW6ko1jIXeFNXLJoo2cUTGh1ow6QLkX6RFBXROgTzMPDGrQVI1CbywWjV9pzUigagqZXXU6VM9rL1Q1HqoP6AGoy8chpYh2lLRimLlt1626EQqdg0otmO8TWRN6kerxSFU3jgojj0NaU0i5xsyyS+jT+A9JhcxCfbNkjFZ+R1KZ0UiNkACqttTmQKBRVlt8YhlVAKNT6qRAhQpwHKOerVVJ3QvUHsFT/pyMcpyolmQw2omu+0C0kIRMtsmBp+hG5Dcy6qvZu/ZqRmjr6/cV7LCs3KnnhR0/PqOXZWhFz3IpKKoeGhQjakCNrVBo1Xu5FjV7wO4VjPuxjnwxgXjaJENhKuBDF6oseEMMTA0ymZgV2T1YD4nb/VhHTvpapaIiVJXhDuMopYrGGpBh1Zvk0FzduivtwfocEowc9KE6wVjD74qAKLpTAQnaXSiqgnR0+0hwSJDuxTp2zgcFklMeKjxhqtEY91gw+KhJiqC9cbXSHqzDpOZ+xCPH/CILx9TiGfQ1VLaomVHoBAFFWw2Im8gPQvwMRoyd8q3lmEc91CC6FdqCLSxAJzIZY0JnKM7aTV2YFjQvzXdtaV51oH+eUvNyuij4+t0VXFi/BP98eXsXhPF8Bp+OeF8hXJD3L8gHu+JFwgANnShj6giTIXWqDoxMMp4r7WOMD668Wsyu56vm619fGzd/7V5Zf/HNA9w/AO/nD5ivqL1IlzRtTy9ms4ur8nW5nrbTp8iVs4OQP7QRTjqpShbSPAB3QPRJFMFyyrz6QuD/RrU7LyuAbG7h7+54ZSukXOpBwNSpfoAWvAwGSlEX0ckbY7qQQpgnj+mkyuD5Rg5u9OLRrVj7Z0iGmEmBMehtWQFrhHKM0VlmYgnZgOCF216Y7hjJILo3O/xIaVutMIGkYnE9h3XvhIORhnFvU85Vqar6I+qPGG3QdtHP7JHaFl0NylBU5gmyUVc0NQoYQZFdZLQGZbnphRpGQ12L8NHbj7vxe1vS+riou/1xcuCLa6Qr7P/wcX0sORly7rV+5GQybXN5Pznjn378EStvn0v2GX9medyxcv8RUd/6h1Vb7xI7H+sP4M4XvcOM36uz/ca3NNxg42uFctD4Yx2zO/J9R0iDQj/MgZ1nKUPXGOTHDsr3B+nAieTWEifbD+85sjj4+N4zuyFPP3Px3adaB58ecMw0wsYYP3Zl8a2QPJjGT/Tm4FQbYn57wOk1v1uO9RbafhG0t4Bux3NoCR2Cfzf7hmbyUZvweMrZvxM7JqLd7uzm8yCfxqx3cBga6trgvdqXaCPdG7LmcdKgD8iAwaUHwadP/wc3Xmk3FiYAAA==


name: Automate B2B Lead Generation & Personalized Cold Emails with Apollo, Apify & GPT
author_name: Mirai
author_username: mirai
categories: []
created_at: 2025-10-09T05:06:36.883Z
updated_at: 2025-10-09T05:06:36.883Z
url: https://n8n.io/workflows/9393
scraped_at: 2025-12-24 13:02:42
description:
  This n8n template automates targeted lead discovery, AI-driven data structuring, and personalized cold-email sending at controlled intervals. It’s ideal for sales teams, founders, and agencies that want to scale outreach without losing personalization.

  Good to know

  Can run on an interval (e.g., every 10 minutes) to fetch and process new leads.

  Requires API keys for OpenAI (content + parsing) and Apify (lead discovery).

  Emails are sent one-by-one with delays (the Wait node) to reduce spam risk.

  Lead data is written to Google Sheets—we recommend separate sheets for leads with and without emails.

  Works with Gmail, Outlook, or your own SMTP—just plug in your credentials.

  How it works

  Form Trigger (START)
  A form collects: Job Title, Company Size, Keywords, Location.

  Apollo URL Generator (GPT)
  The model turns the form fields into a precise Apollo search URL.

  Run Apify (Actor)
  Apify fetches contacts/companies that match your preferences for downstream processing.

  Limit
  Caps how many records are prepared per run (e.g., max 5).

  Parse Lead Data (GPT)

  Extracts key fields (full name, email, title, LinkedIn, company, company links).

  Synthesizes a short 2–3 sentence sales-ready summary for each lead.

  Sorting (If)
  Splits leads into with email vs. without email.

  With email → main sheet + email pathway

  Without email → a separate sheet for later enrichment

  Email Magic (GPT)
  Uses the parsed data to personalize your fixed email template for each lead (keeps structure/intent, swaps in the right details).

  Sending Emails (Loop + Wait + Sender)

  Loop Over sends messages individually.

  Wait inserts a pause between sends (fully configurable).

  Delivery via Gmail or SMTP (custom domain / Outlook).

  Confirmation
  After the loop finishes, a Gmail node sends a “campaign complete” confirmation.

  How to use

  Enable the workflow and open the start form.

  Enter preferences: job title, company size, keywords, location.

  Add credentials:

  OpenAI (for parsing + email generation)

  Apify (Bearer token in Run Apify)

  Google (Sheets + optionally Gmail)

  SMTP/Outlook (if not using Gmail)

  Set limits (the Limit node) and send interval (the Wait node).

  Choose sheets for leads with/without email.

  Run—the workflow will fetch leads, prepare emails, and send them with spacing.

  Requirements

  OpenAI API key

  Apify API token (access to the chosen Actor)

  Google Sheets for storage

  Gmail or SMTP/Outlook credentials for sending

  An operational n8n instance

  Customising this workflow

  Email template: Edit the text in “Creating a email” while preserving placeholders.

  Segmentation: Add more conditions (role, industry, country) and route to different templates/sheets.

  Follow-ups: Add a second loop that reads statuses and sends timed reminders.

  Data enrichment: Insert additional APIs before “Parse Lead Data.”

  Anti-spam: Increase Wait duration, rotate senders, vary subject lines.

  Reporting: Add a “send status” sheet and an error log.

  Security & compliance tips

  Store API keys in n8n Credentials, not plain-text nodes.

  Respect GDPR/opt-out—track source and first-contact date in your sheet.

  Start with a small batch, validate deliverability, then scale up.

  In short

  Automated lead capture → AI cleaning + summary → personalized emails → spaced sending → completion notice.
  Scalable, customizable, and ready to plug into your preferred sender and template.

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.formTrigger","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.httpRequest","n8n-nodes-base.limit","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","n8n-nodes-base.wait","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail","n8n-nodes-base.emailSend","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Y224bRxL9lQGf2UrfL3qK10kcZb1WYG82CwTBoi/V4sDkDEMO7RiC/n1rhoI4IpsXOXkhbLFZc6rq1KnTcz+p0+R68qOHLz/+pNTsp/THD7/+94fJdLKAzk+u7yd1s+58E+GmP2dZDlGazKMRmiWfGKVZWSogefyrdFZka6VMJpjEtLWQKEDknnJmlI6Th+mk8QvAUK/beYLq+4Wv59UbaPCJnb9bT65/+x2PtAn6f95v0ckgg7aUE6qTJtIGR6znlrCgE09UJTB28hT4VUpV11Zv2vZuDtWHGUDXB/+y7L9sbEOG6CT4NVzdDYeGM2s8tGzXdVe3DT6aaUqniltEs/QrjNzBCiHdP2xD/Qf/NxyUV+ph+ogTtOJCe02SskCkMJQ4jh8WSxF91FHksMN521S5XS2q9SYs6vUQ7RjM/ty/V/XdHayeo7QI0mnE+BnCrG0/Dk0KXoOLPBFIKhGpMsKw0RHnWRROOp2SnpxJi1/xp7SoDi5QG0m0ymH5uSKWiUCSTNh4qq2nflT+ZTuft9Uv79/2bYWV79rVLrFvMbNvdtnNfXMXZ75urobPt/PFXhcotdsET6JlV+YJLYtOa216imiGTUieeG4M4UJ4472nOvMd2vebpnq1rPOXo7Wfdd3yPfyxgXW3h407fQE2OapkNEoF5SPSQgcipU7EQaREcWRyDIwJGBHkbb2oj1N3/vjtCJEyeqoYP1utJzyeO8YAWykER8LiBBML1BHNBVPaGu5t3OH50K02sdusIFW3m2656aqf/WoNl3S3Hc5vj+/CPEfvGJ9qdUGv+Qh/SDwETUxUFvELrKykmQSUG69Tdi7kHf7h8dVb8Kn6znf+q0lpFL+ozCNSWk4jzmTEkczY+OglcUpkApyrzEE6o2Bc6Dp+/FK9azs42v71cObxyAgcEXxKtNwHN4lt00HTYaDJcT5QjuOCCk449h5hWk+c6VH7ZGU0kiU3mp2bfBRdnffnmMtLajaWHW0ED0J5YhKlOMgskOBQgABYcBGowt0yGpa2XVa3n2BV3XSwWLPjhVvO6+6m+Yfv4gz2RJ8LKi8RffEEUuKkhJAUMRaFRiLrkHwmEIblykonavNoNf3qTwz0Z78/z1wbPjWc7uk7Y/gcQEnzQmFhEqpIkJERDZw6hvs4WndO39kVG+XAtQ05Ep8RucygSICsCbPAQ8z9qk27HN611e2yl3WMM61SWzVtN6ubu6N5Ne3tci8vNA9Toc+WeQcxU2d9Mozk4FCoPIK1HjLOvc5U0GQT0OL8nODBkQFSDgeIuQOqXjZBGnTAZS+JQRNEpMMtjLOfSUoOCQEUx98VgfIXA5WWTsVAjq/A6XBLRs1xuLxDS+U0ssk53JeZSSWY8UiKIk7xYpxMidKevLCeuCOVVAanXqIihX6vZ9Qm3Xec2+jBsiJO+XKcViEr6ddKp+yXOK52EAqBUo1CILVCJRXOJ5QrNMlFoOrFQDkbKHqoppch5UZJyCAIMqA3SLg+g464+QN6V64sD2zU+gWs1/4OKgyd69UCB72CJlVtrj63q4/HjXXv6/dgo7A+Tv1YzaQG5Tl3JEtc31I6iX4ZOAqqsxRtswmRF9QM/oS46eAWbyaTa3QUcLBJdhkLL7D8WZLehCPFBWYs8CZBIWZPs8vYoFFvML8+zYgXlAoe8yhnOXzbn9/PFK2M0vu6TSPOmfOZ5JgMcjnRfldE3NaaBWUYWrF03pfv0kpJgRIoLtEJ1BqKHz55T7jJJltpeLL+VFrVm5PJlVqIN7pSYujSVW8WmOhFD2ggPlBBqLIyRBwKI88upHFiLONYW8B9KoTtGWqJjcwT1E8ecvDW0pGIvl4BLiPMzO9367gdXULzqi6M/wW7n13Z3eZkKrAYFA5jv/1lROtpLSecopvXuJeyGgHtnee6+lx3M7TDZ5h15mIq7IFMHd47dvYzoP5EKhlxVElkSrIEjTOQiLd2K5Wj1o5cytYn9xa5WrRpM4cLKjpfvJ757rZQ154yL7T1EbTAxS5Ql3jGCyxyOliIRMQQLIoWE27s/G7e/bP6+dWH79//JZwO1amw9ks48YyPXf0Jn5T9fI3Ss4aup+AgwltlwsO3q4SXo+vJJ9ar8adthK3meYrOEFCBEkPNC7gxAsPRUcEYk0OMOvX3QNTcBmIfagiMfhs/kTY93N/uh7ck52g1nJ5O6ibBn5NritB3Pzz5ouTgh79jDoN/LWI46r6LcbY321Kgo3e0Ypzd7b0I6vn9uYxkRx4M4ev/9VTZ4ML7F8aYPwt3+sXGwU/3n7SfWQnx+EZVhHugdX9HM/aPl2JeagNO8e3UYi0iOxSicz06Sp+z7Sm8jSvV4TQJilkU0i5Ffn43LEYqDWwp1PGNWA5byqkUt/CyrJzxsRdF2/aNXwZd3L1nP9p/4Bl2lnI5f40tpPbw8H+iezyMMBcAAA==


name: Automated Phone Receptionist for Scheduling with Twilio, ElevenLabs & Claude AI
author_name: Connor Provines
author_username: connorprovines
categories: []
created_at: 2025-10-09T17:50:11.715Z
updated_at: 2025-10-09T17:50:11.715Z
url: https://n8n.io/workflows/9429
scraped_at: 2025-12-24 13:02:41
description:
  Schedule appointments from phone calls with AI using Twilio and ElevenLabs

  This n8n template creates an intelligent phone receptionist that handles incoming calls, answers FAQs, and schedules appointments to Google Calendar. The system uses Twilio for phone handling, ElevenLabs for voice AI and basic conversations, and n8n for complex scheduling logic—keeping responses snappy by only invoking the workflow when calendar operations are needed.

  Who's it for

  Businesses that need automated phone scheduling: service companies, clinics, consultants, or any business that takes appointments by phone. Perfect for reducing administrative overhead while maintaining a professional caller experience.

  Good to know

  Redis memory is essential—without it, the AI must reparse entire conversations causing severe lag in voice responses

  Claude 3.5 Sonnet is recommended for best scheduling results

  Typical response times: ElevenLabs-only responses &lt;1s, n8n tool calls 2-4s

  All placeholder values must be customized or scheduling will fail

  How it works

  Twilio receives incoming calls and forwards to ElevenLabs voice AI

  ElevenLabs handles casual conversation and FAQ responses instantly

  When calendar operations are needed, ElevenLabs calls your n8n webhook

  n8n checks Google Calendar availability using your business rules

  Claude AI agent processes the request, collects required information, and schedules appointments
  Redis maintains conversation context across the call

  Calendar invites are automatically sent to customers

  How to set up

  Connect Twilio to ElevenLabs: In Twilio Console, set your phone number webhook to your ElevenLabs agent URL

  Configure ElevenLabs tools: Add "Client Tools" in ElevenLabs that point to your n8n webhook for checking availability, creating appointments, and updating appointments

  Set n8n webhook path: Replace REPLACE ME in the "Webhook: Receive User Request" node with a secure endpoint (e.g., /elevenlabs-voice-scheduler)

  Configure Google Calendar: Replace all REPLACE ME instances with your Calendar ID in the three calendar nodes (Check Availability, Create Appointment, Update Event)

  Set up Redis: Configure connection details in the "Redis Chat Memory" node

  Customize scheduling prompt: In the "Voice AI Agent" node, replace all bracketed placeholders with your business details:

  [TIMEZONE], [START_TIME], [END_TIME], [OPERATING_DAYS], [BLOCKED_DAYS]
  [MINIMUM_LEAD_TIME], [APPOINTMENT_DURATION], [SERVICE_TYPE]
  [REQUIRED_FIELDS], [REQUIRED_NOTES_FIELDS]


  Test: Make a test call to verify availability checking, information collection, and appointment creation

  Requirements

  Twilio account with phone number
  ElevenLabs Conversational AI account
  Google Calendar with OAuth2 credentials
  Redis instance (for session management)
  Anthropic API key (for Claude AI)

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.respondToWebhook","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleCalendarTool","@n8n/n8n-nodes-langchain.memoryRedisChat","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, 6204 characters]


name: Resume Screening & Candidate Routing with OpenAI, Jotform, and Google Sheets
author_name: Jitesh Dugar
author_username: jiteshdugar
categories: []
created_at: 2025-10-09T18:42:54.388Z
updated_at: 2025-10-09T18:42:54.388Z
url: https://n8n.io/workflows/9435
scraped_at: 2025-12-24 13:02:42
description:
  Revolutionize your recruitment process with intelligent AI-driven candidate screening that evaluates resumes, scores applicants, and automatically routes them based on fit - saving 10-15 hours per week on initial screening.

  🎯 What This Workflow Does

  Transforms your hiring pipeline from manual resume review to intelligent automation:

  📝 Captures Applications - Jotform intake with resume upload
  🤖 AI Resume Analysis - OpenAI parses skills, experience, education, and red flags
  🎯 Intelligent Scoring - Evaluates candidates against job requirements with structured scoring (0-100)
  🚦 Smart Routing - Automatically routes based on AI recommendation:
     Strong Yes (85-100): Instant Slack alert → Interview invitation
     Maybe/Yes (60-84): Manager review → Approval workflow
     No (&lt;60): Polite rejection email
  📊 Analytics Tracking - All data logged to Google Sheets for hiring insights

  ✨ Key Features

  AI Resume Parsing**: Extracts structured data from any resume format
  Intelligent Scoring System**: Multi-dimensional evaluation (skills match, experience quality, cultural fit)
  Structured Output**: Consistent JSON schema ensures reliable data for decision-making
  Automated Communication**: Personalized emails for every candidate outcome
  Human-in-the-Loop**: Manager approval for borderline candidates
  Comprehensive Analytics**: Track conversion rates, average scores, and hiring metrics
  Customizable Job Requirements**: Easy prompt editing to match any role

  💼 Perfect For

  Startups & Scale-ups**: Processing 50+ applications per week
  HR Teams**: Wanting to reduce time-to-hire by 40-60%
  Technical Recruiters**: Screening engineering, product, or design roles
  Growing Companies**: Scaling hiring without scaling headcount

  🔧 What You'll Need

  Required Integrations
  Jotform** - Application intake form (free tier works)
  Create your form for free on Jotform using this link
  OpenAI API** - GPT-4o-mini for cost-effective AI analysis (~$0.15 per candidate)
  Gmail** - Automated candidate communication
  Google Sheets** - Hiring database and analytics

  Optional Integrations
  Slack** - Instant alerts for hot candidates
  Linear/Asana** - Task creation for interview scheduling
  Calendar APIs** - Automated interview booking

  🚀 Quick Start

  Import Template - Copy JSON and import into n8n
  Create Jotform - Use provided field structure (name, email, resume upload, etc.)
  Add API Keys - OpenAI, Jotform, Gmail, Google Sheets
  Customize Job Requirements - Edit AI screening prompt with your role details
  Personalize Emails - Update templates with your company branding
  Test & Deploy - Submit test application and verify all nodes

  🎨 Customization Options

  Adjust Scoring Thresholds**: Change routing logic based on your needs
  Multiple Positions**: Clone workflow for different roles with unique requirements
  Add Technical Assessments**: Integrate HackerRank, CodeSignal, or custom tests
  Interview Scheduling**: Connect Calendly or Google Calendar for auto-booking
  ATS Integration**: Push data to Lever, Greenhouse, or BambooHR
  Diversity Tracking**: Add demographic fields and analytics
  Reference Checking**: Automate reference request emails

  📈 Expected Results

  90% reduction** in manual resume review time
  24-hour response time** to all candidates
  Zero missed applications** - every candidate gets feedback
  Data-driven hiring** - track what works with comprehensive analytics
  Better candidate experience** - fast, professional communication
  Consistent evaluation** - eliminate unconscious bias with structured AI scoring

  🏆 Use Cases

  Technology Companies
  Screen 100+ engineering applications per week, identify top 10% instantly, schedule interviews same-day.

  Agencies & Consultancies
  Evaluate consultant candidates across multiple skill dimensions, route to appropriate practice areas.

  High-Volume Hiring
  Process retail, customer service, or sales applications at scale with consistent quality.

  Remote-First Teams
  Evaluate global candidates 24/7, respond instantly regardless of timezone.

  💡 Pro Tips

  Train Your AI**: After 50+ applications, refine prompts based on false positives/negatives
  A/B Test Thresholds**: Experiment with score cutoffs to optimize for your needs
  Build Talent Pipeline**: Keep "maybe" candidates in CRM for future roles
  Track Source Effectiveness**: Add UTM parameters to measure which job boards deliver best candidates
  Continuous Improvement**: Weekly review of AI assessments to calibrate accuracy

  🎓 Learning Resources

  This workflow demonstrates:
  AI Agents with structured output
  Multi-stage conditional routing
  Human-in-the-loop automation
  Binary data processing (resume files)
  Email automation with HTML templates
  Real-time notifications
  Analytics and data logging

  Perfect for learning advanced n8n automation patterns!

  Ready to transform your hiring process? Import this template and start screening candidates intelligently in under 30 minutes.

  Questions or customization needs? The workflow includes detailed sticky notes explaining each section.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","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.slack","n8n-nodes-base.jotFormTrigger"]

workflow_json_compressed:
  [encoded data, 11632 characters]


name: Course Recommendation System for Surveys with Data Tables and GPT-4.1-Mini
author_name: Robert Breen
author_username: rbreen
categories: []
created_at: 2025-10-09T18:58:45.739Z
updated_at: 2025-10-09T18:58:45.739Z
url: https://n8n.io/workflows/9437
scraped_at: 2025-12-24 13:02:41
description:
  Use the n8n Data Tables feature to store, retrieve, and analyze survey results — then let OpenAI automatically recommend the most relevant course for each respondent.

  🧠 What this workflow does
  This workflow demonstrates how to use n8n’s built-in Data Tables to create an internal recommendation system powered by AI.

  It:
  Collects survey responses through a Form Trigger  
  Saves responses to a Data Table called Survey Responses  
  Fetches a list of available courses from another Data Table called Courses  
  Passes both Data Tables into an OpenAI Chat Agent, which selects the most relevant course  
  Returns a structured recommendation with:
    course: the course title  
    reasoning: why it was selected  

  &gt; Trigger: Form submission (manual or public link)

  👥 Who it’s for
  Perfect for educators, training managers, or anyone wanting to use n8n Data Tables as a lightweight internal database — ideal for AI-driven recommendations, onboarding workflows, or content personalization.

  ⚙️ How to set it up
  1️⃣ Create your n8n Data Tables
  This workflow uses two Data Tables — both created directly inside n8n.

  🧾 Table 1: Survey Responses
  Columns:
  Name
  Q1 — Where did you learn about n8n?
  Q2 — What is your experience with n8n?
  Q3 — What kind of automations do you need help with?

  To create:
  Add a Data Table node to your workflow.  
  From the list, click “Create New Data Table.”  
  Name it Survey Responses and add the columns above.

  📚 Table 2: Courses
  Columns:
  Course
  Description

  To create:
  Add another Data Table node.  
  Click “Create New Data Table.”  
  Name it Courses and create the columns above.  
  Copy course data from this Google Sheet:  
     👉 https://docs.google.com/spreadsheets/d/1Y0Q0CnqN0w47c5nCpbA1O3sn0mQaKXPhql2Bc1UeiFY/edit?usp=sharing

  This Courses Data Table is where you’ll store all available learning paths or programs for the AI to compare against survey inputs.

  2️⃣ Connect OpenAI
  Go to OpenAI Platform  
  Create an API key  
  In n8n, open Credentials → OpenAI API and paste your key  
  The workflow uses the gpt-4.1-mini model via the LangChain integration

  🧩 Key Nodes Used
  | Node | Purpose | n8n Feature |
  |------|----------|-------------|
  | Form Trigger | Collect survey responses | Forms |
  | Data Table (Upsert) | Stores results in Survey Responses | Data Tables |
  | Data Table (Get) | Retrieves Courses | Data Tables |
  | Aggregate + Set | Combines and formats table data | Core nodes |
  | OpenAI Chat Model (LangChain Agent) | Analyzes responses and courses | AI |
  | Structured Output Parser | Returns structured JSON output | LangChain |

  💡 Tips for customization
  Add more Data Table columns (e.g., email, department, experience years)  
  Use another Data Table to store AI recommendations or performance results  
  Modify the Agent system message to customize how AI chooses courses  
  Send recommendations via Email, Slack, or Google Sheets

  🧾 Why Data Tables?
  This workflow shows how n8n’s Data Tables can act as your internal database:
  Create and manage tables directly inside n8n  
  No external integrations needed  
  Store structured data for AI prompts  
  Share tables across multiple workflows  

  All user data and course content are stored securely and natively in n8n Cloud or Self-Hosted environments.

  📬 Contact  
  Need help customizing this (e.g., expanding Data Tables, connecting multiple surveys, or automating follow-ups)?  

  📧 robert@ynteractive.com  
  🔗 Robert Breen  
  🌐 ynteractive.com

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.formTrigger","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.aggregate","n8n-nodes-base.set","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.agent","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.form"]

workflow_json_compressed:
  [encoded data, 5148 characters]


name: Generate & Deliver PDF Invoices from Jotform to Google Drive & Email
author_name: Jitesh Dugar
author_username: jiteshdugar
categories: []
created_at: 2025-10-10T05:04:28.373Z
updated_at: 2025-10-10T05:04:28.373Z
url: https://n8n.io/workflows/9447
scraped_at: 2025-12-24 13:02:41
description:
  Transform your order fulfillment process with complete invoice automation. This workflow automatically generates professional PDF invoices from Jotform orders and delivers them to customers while keeping organized records.

  What This Workflow Does

  ✅ Receives order data from Jotform Trigger  
  ✅ Generates professional HTML invoice with your branding  
  ✅ Converts to PDF using HTML to PDF conversion  
  ✅ Saves invoice to Google Drive for record-keeping  
  ✅ Emails PDF invoice to customer automatically  

  Workflow Steps

  Jotform Trigger - Captures order data when a customer places an order
  Format Invoice Data - Prepares and structures line item data
  Generate HTML Invoice - Creates custom branded HTML invoice
  Generate PDF Invoice - Converts HTML to professional PDF format
  Download File PDF - Prepares PDF for distribution
  Save to Google Drive - Archives invoice for your records
  Email to Customer - Sends invoice PDF directly to customer's inbox

  Requirements

  Jotform account with order form set up Sign up for free here
  PDF generation API key (get yours at pdfmunk.com)
  Google Drive connection for storage
  Email service connection (Gmail, SMTP, etc.)

  Benefits

  Save time** - Eliminate manual invoice creation
  Professional branding** - Customize invoice template to match your brand
  Organized records** - All invoices automatically saved to Google Drive
  Better customer experience** - Instant invoice delivery after order placement
  Scalable** - Handles unlimited orders without additional work

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleDrive","n8n-nodes-base.gmail","n8n-nodes-htmlcsstopdf.htmlcsstopdf","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.jotFormTrigger"]

workflow_json_compressed:
  [encoded data, 6576 characters]


name: Generate MemeCoin Art with Gemini Flash & NanoBanana and Post to Twitter
author_name: Jay Emp0
author_username: jay-emp0
categories: []
created_at: 2025-10-10T16:24:06.817Z
updated_at: 2025-10-10T16:24:06.817Z
url: https://n8n.io/workflows/9470
scraped_at: 2025-12-24 13:02:45
description:
  🐱 MemeCoin Art Generator - using Gemini Flash NanoBanana & upload to Twitter

  &gt;  Watch the Youtube Tutorial video


  Automatically generates memecoin art and posts it to Twitter (X) powered by Google Gemini, NanoBanana image generation, and n8n automation.

  🧩 Overview

  This workflow creates viral style memecoin images (like Popcat) and posts them directly to Twitter with a witty, Gen Z style tweet.  

  It combines text to image AI, scheduled triggers, and social publishing, all in one seamless flow.

  Workflow flow:
  Define your memecoin mascot (name, description, and base image URL).  
  Generate an AI image prompt and a meme tweet.  
  Feed the base mascot image into Gemini Image Generation API.  
  Render a futuristic memecoin artwork using NanoBanana.  
  Upload the final image and tweet automatically to Twitter.

  🧠 Workflow Diagram

  ⚙️ Key Components

  | Node | Function |
  |------|-----------|
  | Schedule Trigger | Runs automatically at chosen intervals to start meme generation. |
  | Define Memecoin | Defines mascot name, description, and base image URL. |
  | AI Agent | Generates tweet text and creative image prompt using Google Gemini. |
  | Google Gemini Chat Model | Provides trending topic context and meme phrasing. |
  | Get Source Image | Fetches the original mascot image (e.g., Popcat). |
  | Convert Source Image to Base64 | Prepares image for AI based remixing. |
  | Generate Image using NanoBanana | Sends the prompt and base image to Gemini Image API for art generation. |
  | Convert Base64 to PNG | Converts the AI output to an image file. |
  | Upload to Twitter | Uploads generated image to Twitter via media upload API. |
  | Create Tweet | Publishes the tweet with attached image. |

  🪄 How It Works

  1️⃣ Schedule Trigger - starts the automation (e.g., hourly or daily).  
  2️⃣ Define Memecoin - stores your mascot metadata:
        memecoin_name: popcat
     mascot_description: cat with open mouth
     mascot_image: https://i.pinimg.com/736x/9d/05/6b/9d056b5b97c0513a4fc9d9cd93304a05.jpg
     3️⃣ AI Agent - prompts Gemini to:
     Write a short 100 character tweet in Gen Z slang.
     Create an image generation prompt inspired by current meme trends.  
  4️⃣ NanoBanana API - applies your base image + AI prompt to create art.  
  5️⃣ Upload & Tweet - final image gets uploaded and posted automatically.

  🧠 Example Output

  Base Source Image:  


  Generated Image (AI remix):  


  Published Tweet:  


  Example tweet text:
  &gt; Popcat's about to go absolutely wild, gonna moon harder than my last test score! 🚀📈 We up! #Popcat #Memecoin

  🧩 Setup Tutorial

  1️⃣ Prerequisites

  | Tool | Purpose |
  |------|----------|
  | n8n (Cloud or Self hosted) | Workflow automation platform |
  | Google Gemini API Key | For generating tweet and image prompts |
  | Twitter (X) API OAuth1 + OAuth2 | For uploading and posting tweets |

  2️⃣ Import the Workflow

  Download memecoin art generator.json.  
  In n8n, click Import Workflow → From File.  
  Set up and connect credentials:
     Google Gemini API  
     Twitter OAuth  
  (Optional) Adjust Schedule Trigger frequency to your desired posting interval.

  3️⃣ Customize Your MemeCoin

  In the Define Memecoin node, edit these fields to change your meme theme:
  memecoin_name: "doggo"
  mascot_description: "shiba inu in astronaut suit"
  mascot_image: "https://example.com/shiba.jpg"

  That’s it - next cycle will generate your new meme and post it.

  4️⃣ API Notes

  Gemini Image Generation API Docs:**  
    https://ai.google.dev/gemini-api/docs/image-generation#gemini-image-editing
  API Key Portal:**  
    https://aistudio.google.com/api-keys

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.twitter","n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.httpRequest","n8n-nodes-base.extractFromFile","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.httpRequest","n8n-nodes-base.set"]

workflow_json_compressed:
  H4sIAAAAAAAAE8VZ/3LbNhJ+FRx7M0k6ggSSIEh6pnN13CTNtE48jZNrE3tcEAAlJuKPkpQTnUdvcPfHPcH9d893j3ALkLQoiZLtu840ntgUCCx2F7vffgvdWIm0jqzg2XspFyeV+/rtj29/KWfWyEpVza2jGyvJqppnQr3U8zzH8SgNWGR7YeTS0IX/nits3w0kD6kKCfV94TNCOQ9k5BDmSNvmsSC2Q3w3BLm1Sos5r9VJqWT1RtWL4iSHEVUr2KAuF2o1sjKeKtgtVakSeZKhJOVThaYqUyWv81JL4dPKOvpwCXNzqfTjTWNJzJmvZEywz1WAqRcoHHrExYErVRwyqtzYs253eFMn4tMSvcprpUfrZaFHsyDDRiyOeKXGlZmk58CUIq+SOskz2NFxAzpyCQUlCl6CwFqVlXaZyOeg5JE/sj4nsp5ZRzQgI2umkumshmGXjWBKVqsMPllfoe9UnGQKddZeZGcleKS+yH799deLrBu+0iqjI1TkheDwMuWVyOsr0FKUSaFVgpfwBn1O6hnKC5WhNF/Us9uZjROP0Kyui+poMknGRZIl6XQs8nQCSn2ZhHJCvAmL4IF4LPKi0BfEs11OYxHKUEg4bzhZ4o0/FtNWvf/v5/jsJZK5qG6V4sl4mufTuRpLdT2ZqhRUxLxIJnrWxJiA2zgAi79qJzTjSsLJZFN0kb1QNdKiP6llT3JVL2SSd/K11SAYw5yqUcZaNRHwDo7RnLC9GrVRFRAnkEEssfK4wNQnBAdcEezaMqZKRYzGcjCq6MOjKoBguVdUebZzIKq0D6p8UYp1ZDV59L+e1Z8+9APp8vGtY0uwZK6qMSQ2MW79XOBWk8mimOdcVhOHON7EJpMmenFeJtMk43MdSE8O+T1wA+45CnMn0n4PI8ypkNhXbujZsR26yhn0u+082PGuC/606V7He2vHO8Ha8Tq1+37/+hS8faK9fVzWcAotZqH//Osff//6YJBRz1aOjDkOBUQa9TmgVmCH2JFO5LjMp9QfDjL2cFshvw/ZSm9t9R2239ZnaYEIWPbvf3ZBcsA8EkecgDjMSRxiKiIXc6YoWOvFksegUhiszYPyAEUCnX9Wqt5rXg1YB5pv2kYdEozgiHZsq9UXrfY3Nzfoz48fHb9Ex4Ak9aMn4wRq0vhjlWdjAMxiUYNc2BWtViCYS2kE8/nzRM2lEcTrmotZCourTp5ZnQIC8atEXlV1qYEIBKzAHwIqHcxN+LxRo1H69TGAs3NcJKbIagfxs3c//vaJPXvz/fsyjYKf1874GWH0bf4pVflnI3HDw86th23CYxWGAQ6g2oKHWYy5x8DNMVO+YCywg7gXQGKm5GIOPoZknBov7gmiduJ6Xh+ubJ8NeruEFQ1/gJFrPjclOtY+hB1mAEyVtbrcMcYer83xA+aa5Aci4WEauyGOROABAvjCETHhocfW5nTnuTbjW7BjsrZlzrOpmPEkG/N2Xt8MdkfQ/JIvEC8V4qg9v46O6IM2AscI5pToYx6hpEJ1juxxl/56mU0Igu1LLvTiJsIAJGAl+huqtHLwUSaikVjPQMYtbjcR2/KE03Z0I3A3WcJqBSxgPkfTHC2KMXL6imyxKc0bCsM3UAwolS5Rg/L32XOXgcDGOmQkgmexKEtwC6rhtzQ25UUitGckX47B/blZo70MUdDocN6cnDS7wpQZr16blDzjZQWh1xHEzQToxQwRNo09HmDiBhGmESOY25xjh7kytIUnA9vuY2i5EPUC8hM126B2n7tjKO+ptRazFVS6KPsO2QkqnVEpb41NebaA9BhBpoDEN+YVDN8AnNYXRo8L6whdWHn0UQkYGTUvwGGFgtKrKv26ma3n68Dqj2zIaIDpwmrerUbdKhMSLe2851r9B36tdhF/7N4eh/R8FRGHA1sSDqZhBNgUEYAl36FORAP4MFzS/IeXNAoZ/LvwpjZTXpo0WVQ6dF/xLEdPeQY/fyRt0gx3XGQHKRPxgzC2vRhoQwyoaUcRDiRUXRXaAQH+Du/YoMuDh7s89Jx7NkCMHnD5W2OthszzBlv/aHqq/YxbnMf2XR4HWsr8WIY4UNBoUuoKDJ6WEOTcpVEQRpKrtcdfmPYDwkx3LuhkBh3bKbh6fg/Mmad6eiOgWb+FN7rPHMKbHtLu8pGmHzrj87RPRl7M40/k7fHpc1rOZFrN1gY0PdcuD1k7BJpu4dl2jFng2phK34fCzUNonoSQLmVE9ll7r1ExR7c3DPWJ/qR+W6hqu3iHezjIopyvCd89SllTGQ3v23TZhqG0V2+4dG0grjH2YgINCgtDHAKPxS5jiqmYcer0su0kz64Bs9Gbnrk67LV5bH+rCBRE04bngM/Pk/l2EtoBHTR+o7zqWsGbFVYEnVe5PM/PTAVZgjjYCViHef+DWsIUg30HQt6hvi8BVnDselBmgajhkAPSEGXbiodEeZ7fP+EWUpMtSG0Q9eEH7npk2ObmwLvU7yjOtdI5tIC92+Yf+v7KQMG1HamaT1KdgFV33eCMPRzPeTVr7hWOWjHQ1DWQZe7GZrn2w9nrN+fbTEYH1NNcLk3kXWQISmcLN6ZSfzBjehRUb4eaEQR11/DNpt7e3ab0qjYE7YWl6/lNJ6v7B8U9m0PgX0le87a4b89Ik1RdtZW+JQOTj4WaGrKB0Pb0TlKjo9HoZZs5mh5sTl9tDrQfL/Wf1eWo8c+ai4KP42TaU7NVZ2dcv+FVAYzoJ72wUcdmR2GngdlIExQEB1QBBW3ORBNI+AwLk3jZHpO2QLd60JBpXBRdohQaKDVoyJNbyDSkrbl13Bo82kLS+yKtjH9gZ/7J99H3bBmxZbanVDw+4z+ePkGwEnEh8gUE4kFkIiRSrvL0RULoA/WS0DiFjGLKuRdEPgljOYBMTw0SaUw6y6Z7E1M0s8/zATjyneFGai8c1flTA0j6mAwuNrhULzvoTuLHTZAJDo0EBJ+qPpDLcZtUY5NGeqCJ8+8gOEfo0b3njnU0P7pjhb274olp73e47xoj3UCXPxJgPyYhYCRnUBocgYl0/RA6E+7GvQPY4UAPR0VK7ENlsEPFhvN0dycGBkHtibm86F5qd/+luc6AbFDTvFx+c/7XZ8/Or16eHr94dhACrVJVBTyqfc/P8zLldZd3Kx3F2/nZer/rkBbzOtEHgaFFTbF2/wPTNQLZZxs+6Xvow836Gwcw2er5r9VA79tE6XfN5qZX08/mVuhVs9ootrpc7YGH/sWPPYwQO1M6kFjEXnr6Lv3yM3nPl8V73r8bMrMRRr0LolLV5fJ19pwn886l20AB3Jwn9VOlG8bsvEz0lyg2IWTN4sIwdBWNsS+BylHJOObM9rAb04hQypiIo7UaW+xqfy+htskbdZ27AYNXVTLN2iu3m82PH24vGN04FszB0vYA8YiQ0GzGBEvf4cz3wyAgPdq5cWOyVrfpcuHzNZ8v9EDTEli3bok4I0yKAHuUQn8VegJzUB9H1I+oG4Q2Eb1Ltt07kgNbDXx7s9435MApiQIWHQZwHH4kcaiYDfsyL4oogZPydvbdItQ7O/5O3wUN3eS5Ywr13QLeCvzrtu6qWl9vmTNUX5RYaI+8LqW+2rGubZ0R140A83Uj8EgH0NLGgrtworYvcWR7gKhBLKJAOZRSfaKAFhkQgQ5/bm8C4TmFvgkiRGc4xODBbsNM1Zkt1RfriKwudSJvh/WQyN2bx0FROzsPybpvhzC4w86N7tAOexN1UORuWRrUevCyflDgMNEYEnqgIg77d19jrfEiuepagHbs4PntTN/x9L6Lw2avfOPO8q6tNmbv89eegBgO8Xu2W3vC9PDqQ1G7hz0O7LNa/RfMdbTCeiAAAA==


name: Automate HR Recruitment with OpenAI Resume Screening & Interview QnA Generator
author_name: Sandeep Patharkar | www.FastTrackAiMastery.com
author_username: sandy4v
categories: []
created_at: 2025-10-12T16:36:46.448Z
updated_at: 2025-10-12T16:36:46.448Z
url: https://n8n.io/workflows/9528
scraped_at: 2025-12-24 13:02:44
description:
  Build an AI HR Assistant to Screen Resumes and Send Telegram Alerts
  A step-by-step guide to creating a fully automated recruitment pipeline that screens candidates, generates interview questions, and notifies your team.

  This template provides a complete, step-by-step guide to building an AI-powered HR assistant from scratch in n8n. You will learn how to connect a web form to an intelligent screening agent that reads resumes, evaluates candidates against your job criteria, and prepares unique interview questions for the most promising applicants.



  | Services Used                               | Features                                                                   |
  | :---------------------------------------------- | :----------------------------------------------------------------------------- |
  | 🤖 OpenAI / LangChain                         | Uses AI Agents to screen, score, and analyze candidates.                       |
  | 📄 Google Drive & Google Sheets               | Stores resumes and manages a database of open positions and applicants.        |
  | 📥 n8n Form Trigger                           | Provides a public-facing web form to capture applications.                     |
  | 💬 Telegram                                   | Sends real-time alerts to the hiring team for qualified candidates.            |

  How It Works ⚙️

  📥 Application Submitted: The workflow starts when a candidate fills out the n8n Form Trigger with their details and uploads their CV.
  📂 File Processing: The CV is automatically uploaded to a specific Google Drive folder for record-keeping, and the Extract from File node reads its text content.
  🧠 AI Screening Agent: A LangChain Agent analyzes the resume text. It uses the Google Sheets Tool to look up the requirements for the applied role, then scores the candidate and decides if they should be shortlisted.
  📊 Log Results: The agent's decision (name, score, shortlisted status) is logged in your master "Applications" Google Sheet.
  ✅ Qualification Check: An IF node checks if the candidate was shortlisted.
  ❓ AI Question Generator: If shortlisted, a second LangChain Agent generates three unique, relevant interview questions based on the candidate's resume and the job description.
  ✍️ Update Sheet: The generated questions are added to the candidate's row in the Google Sheet.
  🔔 Notify Team: A final alert is sent via Telegram to notify the HR team that a new candidate has been qualified and is ready for review.

  🛠️ How to Build This Workflow

  Follow these steps to build the recruitment assistant from a blank canvas.

  Step 1: Set Up the Application Intake
  Add a Form Trigger node. Configure it with fields for Name, Email, Phone Number, a File Upload for the CV, and a Dropdown for the "Job Role".
  Connect a Google Drive node. Set the Operation to Upload and connect your credentials. Set it to upload the CV file from the Form Trigger into a specific folder.
  Add an Extract from File node. Set it to extract text from the PDF CV file provided by the trigger.

  Step 2: Build the AI Screening Agent
  Add a Langchain Agent node. This will be your main screening agent.
  In its prompt, instruct the AI to act as a resume screener. Tell it to use the input text from the Extract from File node and the tools you will provide to score and shortlist candidates.
  Add an OpenAI Chat Model node and connect it to the Agent's Language Model input.
  Add a Google Sheets Tool node. Point it to a sheet with your open positions and their requirements. Connect this to the Agent's Tool input.
  Add a Structured Output Parser node and define the JSON structure you want the agent to return (e.g., candidate_name, score, shortlisted). Connect this to the Agent's Output Parser input.

  Step 3: Log Results & Check for a Match
  Connect a Google Sheets node after the Agent. Set its operation to Append or Update. Use it to add the structured output from the agent into your main "Applications" sheet.
  Add an IF node. Set the condition to continue only if the shortlisted field equals "yes".

  Step 4: Generate Interview Questions
  On the 'true' path of the IF node, add a second Langchain Agent node.
  Write a prompt telling this agent to generate 3 interview questions based on the candidate's resume and the job requirements.
  Connect the same OpenAI Model and Google Sheets Tool to this agent.
  Add another Google Sheets node. Set it to Update the existing row for the candidate, adding the newly generated questions.

  💬 Need Help or Want to Learn More?

  Join my Skool community for n8n + AI automation tutorials, live Q&A sessions, and exclusive workflows:  
  👉 https://www.skool.com/n8n-ai-automation-champions

  Template Author: Sandeep Patharkar  
  Category: Website Chatbots / AI Automation  
  Difficulty: Beginner  
  Estimated Setup Time: ⏱️ 15 minutes

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.formTrigger","n8n-nodes-base.extractFromFile","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE6VX224bRwz9FUHPGnfuFz81SJrLQ5s0dvtSBAZnhiMLkXaF1aqNEfjfy5Xcai2vLMnxg2Dscskz5OEh5/t4gS2ML7+PZ9WqhSrhhzy+HAcTTSooiiwFnBQcnBBegFVSoUUrnRUx5OQhZ+QFlQnC6qKi9YlnKOPJuMXFcg4tvm4wr66wXS9f1/QEW6QAbbPG+8m4qjOuxpd/UfQuarRCucCRRW0y0zElBoUX5kXUCSEXq5A8V7BAsr5qZ+nr3ei3uu0etnfL7mHlK7bxyiKs8GK1sXkwWdarWTurKwrouJ4w7fkXegoN+WuxWXVZSHXVYtWSp/H91umf9GbzkbifPOD0gg4vM2fKomSag2ARsTBrotaBS6eQD+IUZwNlwvKJsS8EanXWAiMwG3Ng2sjAQkbNrCpSZuA2Y9gBfbVczmcJusijUjeLg2C7l9fNbDrF5jFaYSead1j/wXhb1183XEq8cJmLYCEWz7T1hYFSmaF11phYIMguW4+Ot38keSH/P5RRPlqbHTNe0aG0JYL46BgmYSVVxkLuseSXb20DqR0tm7rM5oeZglu7t029eLu1651LaiqC9PtFOJx4FYMyXGniWLRMB2JySIgMtHXFc4ki9RgyXbaaidGC0Mx3AH8mhD/tUM6hmqZbmFUX88XrW2g/LrF6NdvPP1VAySdseQK0l06uTSlCBwY2FqaFT0RmsCwYDBrppUtyB/WP5byGPGrr0bu6ns5x9KaZ/X04q9ON0X82exlVRh4Dqno9hx4VFwwEcUdjUcw77ZnK1vFcnPQHtEHos5vOaz+R/Em5T+u56EI22UmGIEgcVAAWlaDSo6ZDE0xuXB9os07tmjRy9HHdLtft6BM0K2zECTyoNx9s7Xd+9hihuZ+444kWF6rXYI50TSHjsnBGqD2DDJlZGgKgY0gmx90JOh7efHqIuDrChKtbxHZ1XdfzxzCD1hOvjqLUF25HiFIIi5IMJCdCEA1Y5BiYlVJiJoED7vu8zTSLbt5/vump3M3V3YrG1EmY99KqgpwMzI/nAJtQlKLhyBR9yHRKwAImz4K2pGGaBCP3NIGQfr6+unk17Qh3nAvwYNfHyKU+BWNfW1X0NgOl0tJ868QrM2+yIC6bEoUQEKzZYfxQDqZuVvbAUIOeCwZBGdQ2kNBLwTRwSljWhvo+JaWscyWdWOHDc/dwiaVWVGKrzylxKt6IpDVLJSHN22hYpD+G2QqOuiB3cVCkzEsWg5drFKdlrphM4wlF1zuORjIC9Y6WIsjSTewyiNOejVM4IV8OVHvjHSftydZTQlFK6hlRGM8Ssk0hBCd6QLHKIxi1NMu7CfX+8+ga4XB7tzjHabMx6Ned1PKh7v0thhLlg3TIfBKUN/A0ITEgVVpiEUH4XPKxLaY/dkWSWWtSLgihE1lQLDhHIltySdphkcIOlkCeXQJpSQiksS+dZ8UmEQpDWiyYLloxADC0yAUbhYzA+zvkmzv6Z5ZGv69xtVkk32GFDbR1M/oBKZP8tF7sq4fgPFlHQFVOuUswKS26bu3UWfmUSdCGe1Gdvy9QL9KN4rz8kjW9rzBt5yaZk5zS74JyQD7pTtRFPiulm08ndJPL+G18ye+/fKGwjwbJkP/TRuOg70eLK/mG2U1XxzWV8Nfts16c4Yn25JNejMkLcvCcvw3mvX1li7rtNpKTwLbb3eVHMe672UDbv6sMVWsY2GB1ntznhqv//EK/73l33oM3q0EwhxfdbQX6y+xplXj0xX64Z0k9lIf+LjN4gOf3iyGXx8bRYJijLDq3hcWzAe/v/wXC9H1dAhIAAA==


name: Outlook Inbox Tamer: GPT-4.1 Powered Categorization, Auto Replies & Team Alerts
author_name: Sandeep Patharkar | www.FastTrackAiMastery.com
author_username: sandy4v
categories: []
created_at: 2025-10-12T16:47:10.185Z
updated_at: 2025-10-12T16:47:10.185Z
url: https://n8n.io/workflows/9529
scraped_at: 2025-12-24 13:02:45
description:
  Outlook Inbox Tamer: AI-Powered Categorization, Auto Replies & Team Alerts

  This workflow automatically classifies and routes incoming Outlook emails into smart categories using n8n + OpenAI GPT-4.1-mini.  
  It helps professionals and teams stay organized by intelligently sorting and responding to high-priority messages, customer support emails, promotions, and finance-related messages — all without manual effort.

  🧠 Who’s It For
  Professionals or teams overwhelmed by email volume.  
  Customer support, operations, or finance teams needing real-time triage.  
  Anyone who wants AI to help manage and prioritize their Outlook inbox.

  ⚙️ How It Works
  Microsoft Outlook Trigger monitors your inbox for new emails.  
  OpenAI GPT-4.1-mini analyzes each email and classifies it as one of:  
     High_Priority  
     Customer_Support  
     Promotions  
     Finance/Billing  
  Routing node moves emails to matching Outlook folders.  
  AI-generated replies and Telegram notifications keep the right team informed instantly.  
  (Optional) Use Google Sheets + Manual Trigger to test with sample data before going live.

  🛠️ Requirements
  Outlook account connected via Microsoft Outlook OAuth2.  
  OpenAI API key** (set up in n8n credentials).  
  (Optional) Telegram bot token for team alerts.  
  (Optional) Google Sheets for test emails.

  🔧 How to Set Up
  Import the workflow into your n8n instance.  
  Add credentials for:
     Microsoft Outlook  
     OpenAI  
     Telegram (optional)  
  Deploy and activate the workflow.  
  Start sending or receiving emails — watch them get auto-classified and organized!

  🧩 How to Customize
  Update the system prompt in the Email_Classifier_Agent to add more categories (like HR, Legal, etc.).  
  Change Telegram recipients for alerts.  
  Extend the workflow to post classified data into Notion, Slack, or CRM.

  📘 Example Use Case
  An AI agent monitors your Outlook inbox, classifies incoming emails in real time, moves them to their respective folders, creates response drafts, and alerts your team instantly through Telegram.

  💬 Connect with the Creator
  👋 Created by Sandeep Patharkar  
  💼 Connect on LinkedIn  
  🌐 Join my Skool community for n8n + AI automation tutorials, live Q&As, and exclusive workflow templates.

  Category: Email Automation / AI Productivity  
  Difficulty: Intermediate  
  Estimated Setup Time: ⏱️ 10–15 minutes

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail","n8n-nodes-base.microsoftOutlookTrigger","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.telegram","n8n-nodes-base.microsoftOutlook","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.telegram","n8n-nodes-base.switch","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.microsoftOutlook","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VZ224jxxH9FYIPQQKw5b5f9inOZhMHiBPDu0geDIOo7q6mBkvOCOQoWmEhwJ+R/J6/JDXUjeLM8KJdPxDQpS+nqk6dqmp+nq6whembz9Oq3rRQJ/xbnr6ZBhNNKiiKLAWcFBycEF6AVVKhRSudFTHk5CFn5AWVCcLqoqL1iWco07vZtG4ybqZvfqKjuyO113RiUCwmV5gGLCxIzEwo6YyRHLXgU9oFK6TV/77EepKWVfpY1YvJr7/8990nTNctTm6a9ceybG5+/eV/tLq9vepW175m2+tYhA1erKC+huWHdbVY4JpWXTWbqq2amsCYIGdMBPkz/RXWdFeLawL5+e7+rH/Rb9uF4m72gJsbaYy3gvlkLNNCI4tcB5ZK0FYYp2JRz7j/iu1k3dz8fvOHSVVPNpeI7SjMRdMslvi+W7N5idILexJKfeGecELmRVo0TKDnTMeSGKH2zBkRVJE8lWyecb5vybW3k380LY7i22zXPCzZQae8njGteuimqalbrFs6aXrAn4pzB4UzlUPocAq6jdzL0eaYYiJOuB2cWOcJTFa42cBiHOpiBdXyJUrBNX904g3Gy6b5uKW2AWtl9oYlKzLT2WpG7i7MBa2lkgiGx+kRv8uLZ3sseJcwK+ZyNEwbTAx8QSY96myI1Ch27Pm+Sutm05R28s/rdkmYJs80HSHz446HDYO0ttzP6HM6q7P1RQbumEkYmQ7SUTYSv7lO0iTFg1X2GfW7zr3zt0vYbKpS4Xr+7aKL8xPkPxLmb55xL6FepEuo6ovmCutvq73ASGL3KWAv/BNcoSJo8jRLWhG5AToZUYk5bSMF1EeRxDPct2uEFuffVYvL+Q/rqllX7e38R9xcNfUGX4maqMFn9DkHtbKAaIjlSUnJtOXAQIBjXhlAJWMJAPuoiex5DWVcNfb5sAfTK/kAc5f0qLWlVNMMXScOUAoDsJIhEjuNBRNFPkr6J7sCGgei47glIdQ2exaKU8wKmakSoEMheync4qf2aB63uMQFYdgTHG7sgFEJhIvaBFYsEVk7UrwYPVAOBkgiKmOdPmaUuHg2K0vUqhiKVEJyEhW5jmSFkCEQ/bwILu5kcvMfnH9o5m+vN22zopx4f3111axfHThKuZkR+2oFgvtQomcxIwHzzhOFIjJRXOKKHJ5sOD1w2QOlejbMFXKbdo48Bo6qWvTRWxAqQ9wjZFd+HyybvHtQ2Vfnz719RwJinuAaCYryXbIgdBdg0mtPfGU8Uy9SSuEm7fCMClVVbh/DMP+AWxqdzbOBGGhD4ClbJBSKQVDEC5WoITAgjCeiJfDn8MwkyCIFMksL1RVSw7wmK7klziqVE4X62awfm+suCONV+qZq0+WexHqpZ8bZY85WO6gwYBbU7JBYkalaZ84gG2ROSu4NiW+M5iX7J20z6TR28qixX0L9fnp7BQYcyYqTxH8dSf2DJeHnkUulHVJSltOpTzEyIivJjKAeSUsgLVZkoxDZJyTjDaQ9zeoy+4n7/fJxvi73qUW3Q0R0jDpsQoUFWERLv2ohpaT2krrr0200RRVMAVimnoQRpRSVGio6hSsjNHdK4E5Rf3+9WsH6dvI7si19SVY7rs/Jah8NkqQJlhIkSifqP0IAzaTyrjiDwhvsy+wP62bVdLduvoRl91B/O4GlVjsKQ2KFOhFnE7W5AQRSW+VzVglNlOWgYokzJWvLqwGrvrJkWR5dRhrZZOyaZgiRgSyWGRWlMBxd8KbPrNKsJ3+p6m6qnPwZr17bMG5J5sNRNdslWU6O3E3jZfSOHFBoyoBITT/VDO2Ltd5y0yfZA9hv/lQtl4c09wSm3eP97ZgWSsJE0sxs6Do66YCqpKGO2AsfA0Sa+vyenpFcP0Xj71+iY33bvq6OaSo4zkXJnAiCsog6aE91kRGNU0g5CDCpl0UPps2/Q8ivqfsDAfvKSSSysTYG6v9DpC5VeM2CF4IJhVGmVITkO8K3M6GPi8LYiM66dw7pezPWaSO6Qsut4ZTeoGk4dJEg+65qCsygPGTH0yBQdTZQwalT0fqVQEtJ0QsFDGWgUuKIezFKSnqrpCgiaB/0IFB9PlCn9ayvQSfihGQLh0jzFnVUWhZHapRl9/ogYzI0muVhh5qzcdKc93p/GrQl5m5C9dvOlCcaE4mw1DN5Gl9DzikM4rRn45SScu61/uxeWXRIltmiyJ+JkhIyaaGMmWOg3rp4MYjTnY8zuPNx0mr6f43pvmGh5Y9dPP1IQ1R38E+fty+kx3vp7frZtKozfpq+4XT4y62Hh9BTdg/1VqfsGy2Xvc0/k49e9ptDjjjcDw0euvdoMnTqwfeHwUMH/DJ48HADPWx8vwAf8MBwLRs8eOjB+YAXTndAn5FDx5741DYeu/77wij6I/PY4B0jL5dDd/QG7YPc2Of+IYKM98EHr+gl9WgADjzSHEzFHrBR34/0jsP4R9+4h44/9rY8nk7DfDhRWE7SlTFej2dC//l28PiTvt4auuXg90sDV93d/R/BBSfl4hsAAA==


name: Create Deepfake Videos by Swapping Faces with Fal.ai Wan 2.2 and AWS S3
author_name: Sandeep Patharkar | www.FastTrackAiMastery.com
author_username: sandy4v
categories: []
created_at: 2025-10-12T21:55:55.239Z
updated_at: 2025-10-12T21:55:55.239Z
url: https://n8n.io/workflows/9541
scraped_at: 2025-12-24 13:02:45
description:
  Animate Any Face into a Video with Fal.ai
  Create stunning deepfake-style videos automatically by swapping a face from an image onto a source video.

  This workflow provides a powerful, automated pipeline to perform video face-swapping using the Fal.ai API. It's designed to handle the entire asynchronous process: accepting a source video and a target face image, uploading them to cloud storage, initiating the AI job, polling for completion, and retrieving the final, rendered video.

  | Services Used | Features |
  | :--- | :--- |
  | 🤖 Fal.ai | Leverages the powerful Wan 2.2 model for high-quality face animation. |
  | ☁️ AWS S3 | Uses enterprise-grade cloud storage for reliable public file hosting. |
  | 🔄 Polling Loop | Intelligently waits for the asynchronous AI job to complete before proceeding. |
  | 📥 n8n Form Trigger | Provides a simple UI to upload your source image and video. |

  How It Works ⚙️

  📥 Get User Input: The workflow starts when you upload a source video and a face image via the n8n Form Trigger.
  ☁️ Upload to Cloud: Both files are automatically uploaded to a specified AWS S3 bucket to generate the publicly accessible URLs required by the AI model.
  🚀 Start AI Job: The public URLs for the video and image are sent in an HTTP Request to the Fal.ai API, which starts the asynchronous face animation process and returns a request_id.
  ⏳ Wait & Check: The workflow enters a polling loop. It Waits for one minute, then makes another HTTP Request to the Fal.ai status endpoint using the request_id.
  ✅ Check for Completion: An IF node checks if the job status is COMPLETED. If not, the workflow loops back to the Wait node.
  🎬 Retrieve Final Video: Once the job is complete, the workflow makes a final HTTP Request to fetch the finished animated video.

  🛠️ How to Set Up

  🔑 Set Up Fal.ai Credentials: Get your API Key from Fal.ai. In n8n, go to Credentials, add a new Header Auth credential, and save your key. Connect this credential to all three HTTP Request nodes in the workflow.
  ☁️ Configure AWS S3: Add your AWS credentials in n8n. In the two AWS S3 nodes (Upload Video1 and Upload Image1), update the Bucket Name parameter to your own S3 bucket. Ensure your bucket permissions allow for public reads.
  ▶️ Activate and Run: Activate the workflow. Open the Form Trigger URL from the n8n editor, upload your files, and submit. The final video will be available in the execution log of the Get Final Video node.

  Requirements

  An active Fal.ai account and API key.
  An AWS account with an S3 bucket configured for public access.
  Alternative Storage:* For a personal setup, you can replace the AWS S3 nodes with *Cloudinary** nodes. Just ensure the output is a public URL.

  💬 Need Help or Want to Learn More?

  Join my Skool community for n8n + AI automation tutorials, live Q&A sessions, and exclusive workflows:
      👉 https://www.skool.com/n8n-ai-automation-champions

  Template Author: Sandeep Patharkar  
  Category: Content Generation / Content Marketing
  Difficulty: Intermediate  
  Estimated Setup Time: ⏱️ 20 minutes

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.awsS3","n8n-nodes-base.awsS3","n8n-nodes-base.formTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE52WTW8iRxCG/wqaM436u6t9i1Zx5EMSKU42h2gP1d3V3tGagcBYzmrl/54a7ASMZwzsBQmmeOuZ+v7WLKnH5upb03bbHrtMN6W5aqJLLldSVdeKQSuJQSlQ6I025Mnr4FWKJQOWQrKScVF5W03ykGXB2sybnpbre+zpw4bK9pb6h/WHFf9CPbGDfvNAT/OmWxXaNld/sffBqwwm5wxe5ERGWPAoUvFOEPjgvTEWs2PlDpfE1td4v8B29kPXLtnN7Df6+4G2vRpcf10PBh10YudBJNzS4nPfr1+M2Ga92rZ9u+rYuzF+7q38xD/ihrV72jDUt6dnoY/8bWdnF+pp/h+pJh+STsJo9MLmFMUQMpGqzVJyiGrxe9IfS9vPrlu6L1s9ibelIyyhlJ47a09xmYXdc5FmAA4e/08JG8EK0EULzyHkzBBGn0e5zIVcwfhLuLBkX5VGwUUUmYu0SJCsCCowEamgot1z/UybO5oEWr48PUAaiM7IoFno/4mgJMrBgwCsWVjrOFJKKhE1Oem0JkMHRD9RP/vYFlrNbnvsH7aXF1kAO3fhZNAOiyxz4ykVvKg5E7dDjQJBOVEtqahdJohlj3hTJ6HaehQuKeGceO1RtNPBQeBWNJrzp5MUKdooSgSEAFJFQ6+jdd12eP8cs8uDpbQ5K6GH0Yqpyiq9F8G6wC0ps4gUgwg1BmeAuQ9L/09s+0mux+eHB0DOyxeeR0qfV6svuympPEmCisKGUIWV1QkojudBSuSwmFLC4PL9GB++AkLmwlPcvTxLrM0gMNksslHJW3AhWti/wh/r+xWW5xBPTz183N6aowYeBt4Zg2XfLKZW8t5qATElTj+gwOpAFKuSNJaKkvEN2M0S7+hysDMmyx4s5IRIHHyXOGyc9CpidFyctpZqfMrhcK782s3qarMcPma30xNvsPl9097d0eaID4ay1PaoDHzkxvZKCuURuAw4MCATCcyGl2EKLgKdKgO9MPu+L64mHYtA5L1iVWGpyOVsigsSDXupB81227f5y9fZL6t+emRudzYvJocvFLmurXzTZ01edT11PSs100MBwKTIc1SAU9xxMXLcPQVB6FARQMQSRjmni2IS1Fr4flD0SNZVHu44VElKHNoyNKvnOgEJJrtx0He29QSoDnpu4E1rncdZOfEqlyiUrFxIyL0G1QJPNI2kTSVyZpTzne09FVBlhutCw/eRkvbSRG95DEhOfbVGJJOMCD6aatFDUG6U1F1OqiXnHi5MPVvz847yoLIz5/3In0tsB1G+OAfX7+2qneWcz+JC/zRXkhX3f3q9Pd5YfmKencmUw/FTYlTn+RYaEzp5/47qvbpFx2SPjq9TIuZyEfUs8npNjKmM36ejRK+X4QkxfULsaE+MqU0s32O5+fEfjpfiqP83JTJGcHjvjapM1ceY2MmCfnr6F1dqHOAqDgAA


name: Generate Complete Database Schemas with Claude for SQL Databases
author_name: Evervise
author_username: evervise
categories: []
created_at: 2025-10-13T00:27:53.140Z
updated_at: 2025-10-13T00:27:53.140Z
url: https://n8n.io/workflows/9544
scraped_at: 2025-12-24 13:02:41
description:
  Transform database design from weeks to minutes with this intelligent multi-agent system. Perfect for agencies, consultancies, and SaaS companies offering database architecture as a lead magnet or service.

  🤖 4 Specialized AI Agents:
  Agent 1 (Architect):** Designs complete schema with tables, relationships, indexes
  Agent 2 (Reviewer):** Validates design for performance, security, scalability
  Agent 3 (Optimizer):** Adds advanced features and scores the design (0-100)
  Agent 4 (SQL Generator):** Creates production-ready migration scripts

  🔄 Smart Quality Loop:
  Automatically retries up to 3 times if score falls below B grade, feeding previous feedback to improve the design iteratively.

  ✨ What You Get:
  Complete database schema (JSON)
  Comprehensive score card with letter grade
  Review feedback with severity levels (Critical/High/Medium/Low)
  Production-ready SQL migration script
  Optional auto-execution in PostgreSQL/MySQL
  Iteration count and optimization recommendations

  💼 Perfect For:
  Digital agencies offering database design services
  SaaS companies needing rapid prototyping
  Consultancies creating lead magnets
  Developers modernizing legacy systems
  Startups validating data models

  🎯 Use as Lead Magnet:
  Offer free database blueprints to capture leads, then upsell implementation, custom automations, and ongoing optimization services.

  ⚙️ Technical Highlights:
  Optimized temperature settings per agent (0.1-0.5)
  Claude Sonnet 4.5 for maximum quality
  Structured JSON output for easy integration
  Error handling and graceful degradation
  Execution time: 60-90 seconds average
  Cost: ~$0.15-0.30 per run

  Use Cases

  Agency Lead Magnet
     Capture leads by offering free database architecture reviews and blueprints

  Rapid Prototyping
     Quickly generate database schemas for MVP development and validation

  Legacy System Modernization
     Help companies redesign outdated database structures with modern best practices

  Technical Consulting
     Provide instant database assessments and recommendations to clients

  Educational Tool
     Teach database design principles through AI-generated examples and feedback

  Pre-Sales Tool
     Demonstrate technical expertise to prospects before engagement

  Key Features

  ✅ Multi-agent AI collaboration with specialized roles
  ✅ Automatic quality control and iterative improvement (max 3 retries)
  ✅ Support for PostgreSQL, MySQL, MSSQL, MariaDB
  ✅ Production-ready SQL script generation
  ✅ Comprehensive scoring system (Schema/Performance/Scalability/Security)
  ✅ Optional automatic SQL execution
  ✅ Detailed feedback with actionable recommendations
  ✅ Customizable form fields for different industries
  ✅ Error handling and graceful failures
  ✅ Complete audit trail of all agent decisions

  Setup Instructions

  PREREQUISITES:
  Anthropic API key (Claude Sonnet 4.5 access)
  PostgreSQL/MySQL database (optional, for auto-execution)
  n8n version 1.0+ with LangChain nodes

  CONFIGURATION STEPS:

  Import the workflow JSON into your n8n instance

  Configure Anthropic API credentials:
     Add your Anthropic API key in n8n credentials
     Connect all 4 AI model nodes to your credential

  (Optional) Configure database connection:
     In "Execute SQL in PostgreSQL" node, add your database credentials
     Use a TEST/SANDBOX database, never production
     Or disable this node if you prefer manual execution

  Customize the form (optional):
     Edit form fields in "On form submission" node
     Add industry-specific questions
     Adjust required fields based on your needs

  Test the workflow:
     Use the form URL to submit a test request
     Check execution time and quality
     Verify all agents are responding correctly

  Customize agent prompts (optional):
     Adjust system messages for industry-specific requirements
     Modify scoring criteria in Agent 3
     Add custom validation rules in Agent 2

  Deploy:
     Share the form URL as your lead magnet
     Embed in website or landing pages
     Set up email notifications for submissions

  COST CONSIDERATIONS:
  Each execution costs ~$0.15-0.30 in API calls
  Failed attempts (retries) increase cost
  Consider rate limiting for public forms

  Requirements

  REQUIRED:
  Anthropic API Key (Claude access)
  n8n version 1.0+
  LangChain nodes enabled

  OPTIONAL:
  PostgreSQL/MySQL database connection (for auto-execution)
  Email service (for result delivery)
  CRM integration (for lead capture)

  Tags

  #ai-agents #database-design #postgresql #mysql #lead-generation #automation #langchain #claude #schema-design #multi-agent #consulting-tool #saas-tool #development #code-generation #sql-generator

  📖 Website: https://evervise.ai/
  ✨ Support: mark.marin@evervise.com

  N8N Link

nodes_used:
  ["n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.form","n8n-nodes-base.postgres","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.formTrigger","n8n-nodes-base.if","n8n-nodes-base.form","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 10536 characters]


name: Landing Page Analysis & Optimization with Claude's 4-Agent AI System
author_name: Evervise
author_username: evervise
categories: []
created_at: 2025-10-13T00:49:56.638Z
updated_at: 2025-10-13T00:49:56.638Z
url: https://n8n.io/workflows/9545
scraped_at: 2025-12-24 13:02:42
description:
  🎯 AI Landing Page Analyzer & Optimizer

  Transform your landing page audits into a powerful lead generation machine with this professional n8n workflow powered by 4 specialized AI agents.

  What It Does

  This workflow analyzes any landing page and delivers a comprehensive, $2,000-value audit report in under 90 seconds. Perfect for agencies, consultants, and SaaS companies looking to generate high-quality leads while showcasing their expertise.

  🤖 Four Specialized AI Agents

  Design Critic - Analyzes UX/UI, visual hierarchy, CTA placement, mobile responsiveness, and trust signals
  Copywriter - Reviews messaging, headlines, value propositions, and emotional triggers
  SEO Specialist - Audits technical SEO, meta tags, heading structure, and performance indicators
  Growth Strategist - Synthesizes all findings, assigns an A-F grade, and creates prioritized action plans

  ✨ Key Features

  Comprehensive Scoring**: 6-dimension scorecard with detailed justifications
  Actionable Insights**: Top 5 priorities ranked by impact vs. effort
  Conversion Lift Estimates**: Conservative, realistic, and optimistic projections
  Beautiful HTML Reports**: Professional email with all analyses, branded for your business
  Natural Upsell Path**: Built-in CTA for paid optimization services
  Fast Delivery**: Complete analysis in 60-90 seconds

  📊 What Gets Analyzed

  Design & UX
  Visual hierarchy and layout structure
  CTA design, placement, and effectiveness
  Color scheme and whitespace usage
  Trust signals and social proof
  Mobile responsiveness indicators

  Copywriting
  Headline impact and hook effectiveness
  Value proposition clarity
  Benefits vs. features balance
  Emotional triggers and persuasion
  CTA copy strength and action orientation

  SEO & Technical
  Title tag and meta description optimization
  Heading structure (H1, H2 hierarchy)
  Image optimization and alt tags
  Mobile-friendliness
  Analytics tracking setup
  Page speed indicators

  Strategic Overview
  Overall grade (A+ to F) with detailed explanation
  Comprehensive scorecard across all dimensions
  Prioritized action items by ROI
  Estimated conversion lift potential
  Strategic recommendations and next steps

  💼 Perfect For

  Digital Marketing Agencies**: Offer free audits to generate leads
  Freelance Consultants**: Showcase expertise and attract clients
  SaaS Companies**: Lead magnet for conversion optimization tools
  Web Development Agencies**: Pre-sales qualification and demonstrations
  CRO Specialists**: Automated initial assessments

  📋 What You Need

  Required
  n8n instance (self-hosted or cloud)
  Anthropic API key (Claude Sonnet 4.5)
  Gmail account for sending reports (or any SMTP provider)

  Optional Enhancements
  Screenshot API (UrlBox, Puppeteer) for visual captures
  Google PageSpeed Insights API for performance testing
  CRM integration (HubSpot, Salesforce, Pipedrive)
  Slack notifications for lead alerts
  Calendar booking integration (Calendly)

  ⚙️ Technical Details

  AI Model**: Claude Sonnet 4.5 (4 separate agents)
  Average Runtime**: 60-90 seconds
  Cost Per Analysis**: ~$0.15-0.25 (API costs)
  Form Fields**: 6 (landing page URL, industry, goal, conversion rate, frustration, email)
  Output**: Beautiful HTML email report with comprehensive analysis

  🎨 Customization Options

  The workflow includes detailed documentation and is fully customizable:

  Adjust agent prompts for your specific niche
  Modify scoring criteria and thresholds
  Customize email branding and design
  Add/remove form fields
  Integrate with your CRM
  Segment responses by score (different CTAs for different grades)

  📈 Expected Results

  Lead Quality**: High (users actively seeking optimization)
  Conversion Rate**: 15-30% of audit recipients book calls
  Time Saved**: 2-3 hours of manual analysis per audit
  Perceived Value**: $2,000+ professional audit

  🔧 Setup Difficulty

  Intermediate - Requires basic n8n knowledge and API key setup

  Setup Steps
  Import workflow to n8n
  Add Anthropic API credentials
  Configure Gmail/SMTP credentials
  Customize form and email branding
  Test with sample landing page
  Deploy form on your website

  📚 Included Documentation

  Comprehensive sticky notes explaining each component
  Setup instructions and prerequisites
  Customization guide
  Monetization strategy breakdown
  Performance optimization tips
  Enhancement ideas for v2

  🌟 Use Cases

  Lead Magnet: Embed form on your website to capture qualified leads
  Sales Tool: Use during discovery calls to demonstrate value
  Content Marketing: Offer audits in LinkedIn posts, email campaigns
  Partner Program: Provide white-labeled audits to partners
  Upsell Sequence: Follow up with paid optimization services

  ⚡ Why This Workflow?

  Unlike simple template-based audits, this workflow uses real AI intelligence to provide nuanced, contextual insights. Each analysis is unique and considers:

  Industry-specific best practices
  Stated business goals
  Current pain points
  Competitive landscape
  User's experience level

  The result? Reports that feel hand-crafted by experts, not generic checklists.

  🤝 Support

  📖 Website: https://evervise.ai/
  ✨ Support: mark.marin@evervise.com

  N8N Link

  📊 Version History

  v1.0** - Initial release with 4-agent analysis pipeline
  Coming soon: Screenshot capture, competitor comparison, visual mockups

  Tags

  lead-generation marketing-automation ai-agents conversion-optimization landing-pages anthropic claude audit seo copywriting design-analysis lead-magnet

  Ready to turn landing page audits into a lead generation machine? Import this workflow and start attracting high-quality clients today.

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.gmail","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","@apify/n8n-nodes-apify.apify","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 15296 characters]


name: Generate Business Automation Opportunities & ROI Reports with Claude AI
author_name: Evervise
author_username: evervise
categories: []
created_at: 2025-10-13T01:00:14.525Z
updated_at: 2025-10-13T01:00:14.525Z
url: https://n8n.io/workflows/9546
scraped_at: 2025-12-24 13:02:41
description:
  🤖 AI Business Automation Opportunity Finder

  Turn automation audits into high-ticket sales with this ROI-focused n8n workflow powered by 4 specialized AI agents that identify and quantify automation opportunities in any business.

  What It Does

  This workflow analyzes any business and delivers a comprehensive automation blueprint with concrete ROI calculations in under 60 seconds. Perfect for agencies, consultants, and automation experts looking to generate qualified leads and close high-value deals.

  Unlike generic automation advice, this delivers personalized, quantified opportunities ranked by return on investment - making it incredibly easy for prospects to say yes.

  🤖 Four Specialized AI Agents

  Business Analyst - Deep analysis of business model, workflows, pain points, tech stack, and scalability challenges
  Process Mapper - Maps all repetitive processes, calculates time waste, identifies bottlenecks across the entire operation
  Automation Architect - Designs 15+ specific automation solutions with tools, complexity ratings, and implementation steps
  ROI Calculator - Calculates detailed ROI for each automation, ranks top 10, creates 90-day implementation roadmap

  ✨ Key Features

  Concrete Dollar Savings**: Every automation shows exact time saved, labor cost saved, and payback period
  Top 10 Ranked by ROI**: Opportunities prioritized by impact vs. effort with detailed financial analysis
  90-Day Implementation Roadmap**: Month-by-month plan showing progressive savings milestones
  Comprehensive Process Mapping**: Identifies inefficiencies they didn't even mention
  Tool-Specific Recommendations**: Exact tools and platforms needed (n8n, Zapier, Make, etc.)
  Beautiful HTML Reports**: Professional, conversion-focused email with 3-tier pricing built in
  Multiple CTAs**: Strategically placed conversion points throughout the report

  📊 What Gets Analyzed

  Business Analysis
  Business model and revenue streams
  Operational workflows and processes
  Current tech stack assessment
  Team capacity and resource allocation
  Growth stage and scalability blockers
  Industry-specific automation patterns

  Process Mapping
  Comprehensive workflow documentation
  Time waste analysis (hours per month)
  Bottleneck identification
  Process dependencies and integration opportunities
  Quick win vs. strategic project categorization

  Automation Architecture
  For each of 15+ automation opportunities:
  Clear description of what it automates
  Specific tools required
  Step-by-step implementation flow
  Complexity rating (Easy/Medium/Hard)
  Prerequisites and requirements
  Additional benefits beyond time savings
  Real-world use case examples

  ROI Calculations
  For each automation:
  Time saved per week/month/year
  Labor cost savings (calculated from team size/industry)
  One-time implementation cost
  Ongoing monthly costs
  Payback period in months
  12-month net savings
  ROI percentage
  Priority score (0-10)

  💼 Perfect For

  Automation Agencies**: High-value lead magnet that pre-sells your services
  Business Consultants**: Demonstrate ROI before engagement
  No-Code Developers**: Show concrete value of your expertise
  Digital Transformation Consultants**: Quantify the opportunity
  SaaS Companies**: Lead gen for automation/workflow tools
  Freelancers**: Land bigger clients with data-driven proposals

  🚀 Why This Converts Better Than Other Lead Magnets

  Traditional Lead Magnets:
  Generic advice ("You should automate")
  Subjective benefits ("Save time")
  No clear next steps
  Conversion rate: 5-10%

  This Workflow:
  Specific to their business** (personalized analysis)
  Quantified in dollars** ($50K+ annual savings)
  Prioritized action plan** (top 10 ranked by ROI)
  Clear implementation path** (90-day roadmap)
  Conversion rate: 20-30%** to strategy call
  40-50% of calls close** to paid engagement

  📈 Expected Business Results

  Per 100 Form Submissions:
  25-30 strategy calls booked** (25-30% conversion)
  10-15 deals closed** (40-50% call-to-close rate)
  $12K-18K in initial revenue** (mix of Tier 1 & 2)
  2-4 retainer clients** ($30K-60K annual value)
  Total potential: $42K-78K** from 100 leads

  Why It Works:
  Self-qualifying**: Detailed form filters serious prospects
  Pre-sold**: They see the value before the call
  ROI-focused**: Speaks CFO language (dollars, not features)
  Urgency**: Shows money being wasted daily
  Social proof**: Built-in testimonials and case studies

  📋 What You Need

  Required
  n8n instance (self-hosted or cloud)
  Anthropic API key (Claude Sonnet 4.5)
  Gmail account or SMTP provider

  Optional Enhancements
  CRM integration (HubSpot, Salesforce, Pipedrive)
  Slack notifications for high-value leads
  Calendly for automatic call booking
  Zapier/Make for additional workflows
  Analytics tracking (Mixpanel, Segment)

  ⚙️ Technical Details

  AI Model**: Claude Sonnet 4.5 (4 sequential agents)
  Average Runtime**: 50-70 seconds
  Cost Per Analysis**: ~$0.20-0.30
  Form Fields**: 9 (business description, industry, team size, tasks, tools, bottleneck, revenue, email, name)
  Output**: Comprehensive HTML email with all analyses, pricing, and CTAs

  🎨 Customization Options

  The workflow is fully customizable and includes detailed documentation:

  Adjust ROI calculation parameters (labor rates by industry)
  Modify agent prompts for specific niches
  Customize pricing tiers and packages
  Add/remove form fields
  White-label the entire report
  Integrate with your CRM/marketing stack
  Segment responses by company size or revenue
  Add video walkthroughs or personalized messages
  Create industry-specific versions

  📊 Form Fields Explained

  The 9-field form is strategically designed to gather intelligence:

  Business Description (textarea): Core operations and offerings
  Industry/Niche (text): Context for automation patterns
  Team Size (dropdown): Affects ROI calculations and tool recommendations
  Repetitive Tasks (textarea): Gold mine for automation opportunities
  Current Tools (textarea): Integration points and tech stack assessment
  Biggest Bottleneck (textarea): Primary pain point for targeting
  Monthly Revenue (optional dropdown): For accurate ROI estimates and lead scoring
  Email (required): For report delivery
  Name (required): For personalization

  🔧 Setup Difficulty

  Basic - Requires basic n8n knowledge and API configuration

  Setup Steps
  Import workflow JSON to n8n
  Add Anthropic API credentials
  Configure Gmail/SMTP credentials
  Customize branding and pricing in email template
  Test with sample business scenarios
  Deploy form on your website
  Set up follow-up sequences (recommended)

  📚 Included Documentation

  Comprehensive sticky notes** for every component
  Setup instructions** with prerequisites
  Customization guide** for different industries
  Pricing strategy** breakdown and alternatives
  Conversion optimization** tips
  Follow-up sequence** recommendations
  Sales script** suggestions for strategy calls
  Marketing promotion** ideas

  🌟 Advanced Use Cases

  1. Lead Magnet
  Embed on website to capture qualified automation leads continuously

  2. Discovery Tool
  Use during sales calls to demonstrate immediate value and build credibility

  3. Content Marketing
  Offer in LinkedIn posts, email campaigns, YouTube videos for viral growth

  4. Partner Program
  White-label for partners/affiliates to generate leads in their networks

  5. Upsell Sequence
  For existing clients, identify additional automation opportunities

  6. Industry Templates
  Create versions for specific industries (real estate, e-commerce, agencies)

  7. Competitive Intelligence
  Analyze competitor operations and position your services

  ⚡ Why This Workflow Stands Out

  Compared to Generic Automation Audits:
  ✅ Quantified in dollars vs. vague "save time" claims
  ✅ Personalized to their business vs. generic templates
  ✅ Prioritized by ROI vs. random feature lists
  ✅ Actionable roadmap vs. overwhelming possibilities
  ✅ Tool-specific vs. theoretical concepts

  Compared to Manual Analysis:
  ✅ 60 seconds vs. 2-3 hours of consultant time
  ✅ $0.25 cost vs. $300-500 in labor
  ✅ Consistent quality vs. variable analyst experience
  ✅ Scalable vs. bottlenecked by human capacity
  ✅ 24/7 available vs. business hours only

  🤝 Support & Community

  📖 Website: https://evervise.ai/
  ✨ Support: mark.marin@evervise.com

  N8N Link

  🎁 Bonus Resources Included

  Follow-up email sequence** (3 emails over 10 days)
  Sales call script** for strategy calls
  Objection handling** guide
  Pricing calculator** spreadsheet
  Marketing assets** (social media templates)
  Case study template** for testimonials

  Tags

  automation lead-generation roi-calculator business-analysis process-mapping ai-agents anthropic claude workflow-automation business-consulting no-code n8n-workflows high-ticket-sales conversion-optimization saas-tools

  Ready to turn automation audits into recurring revenue? Import this workflow and start attracting qualified leads who can see the exact dollar value you provide before they even talk to you.

  Average user results: $42K-78K revenue from first 100 form submissions.

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.gmail","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, 16992 characters]


