Browse 13,012 Workflows

By Cristina

Automated Weekly Newsletter with AI Research, Editorial Drafting, and Approval Flow This n8n template demonstrates how to automate the full production cycle of a professional weekly newsletter. It combines AI-powered market research, editorial drafting, compliance validation, and an approval loop — all before creating a final Gmail draft ready for distribution. Use cases are many: Wealth managers sending weekly market updates to clients Startups producing recurring research digests Teams creating automated newsletters for marketing or content distribution Good to know At time of writing, each AI call (research, editorial, QC) consumes API tokens from Perplexity and OpenAI. See provider pricing for updated info. Gmail integration requires OAuth setup with your account. You can adapt the prompts to any domain — from finance to tech to education. How it works Schedule Trigger runs every week and sets the date window. Research LLM fetches structured JSON market data using Perplexity. Editorial LLM transforms research into a polished ~2,000 word client-ready newsletter. QC LLM validates factual accuracy and compliance risks before approval. Preview Email is sent with Approve/Revise buttons. Clicking opens a secure n8n-hosted approval form. Final Draft Creation: Once approved, the workflow generates a clean Gmail draft, ready to send. How to use Replace the demo schedule trigger with your own (weekly, daily, or event-based). Set up Gmail OAuth credentials to enable email previews and final drafts. Update branding (logo, disclaimer, signature) in the HTML builder node. Adjust prompts to your audience — e.g., simplify tone for marketing, or keep institutional tone for financial clients. Requirements Perplexity account for research API (or your LLM of choice) OpenAI for editorial and QC steps (or your LLM of choice) Gmail account with OAuth credentials Optional: your own domain to host the approval webhook Customising this workflow This workflow can be extended beyond financial newsletters. Try: Content marketing: Automate weekly digests or trend reports Education: Generate curriculum summaries with approval loops for teachers Internal comms: Automate compliance-checked company updates. An n8n automation workflow template by Cristina.

By Rahul Joshi

Description  Turn Telegram voice messages into AI-generated videos and send the video link back to the chat. This workflow listens for messages, downloads the file, transcribes the audio, generates a video via HeyGen, and returns the final URL. Fast, automated UGC creation right inside Telegram. ✨ What This Template Does  Listens for new Telegram messages and triggers the flow. Downloads attached files (e.g., voice memos). Transcribes the voice memo to text. Generates a video via HeyGen using the transcription. Polls HeyGen for video status, waits with a short buffer, and sends the final video URL back. Key Benefits  Automates UGC creation from Telegram messages ⚡ Reduces manual steps from file handling to final video delivery 🧩 Keeps users in Telegram for a smooth, chat-native experience 📲 Modular nodes make it easy to customize or extend 🔧 Features  Telegram message trigger and message updates 🛎️ File download and retrieval for processing 📥 Voice transcription step for audio-to-text 🎙️➡️📝 HeyGen video generation via POST and status checks via GET 🌐 10-second buffer to allow external processing ⏱️ Automatic return of the video URL to the chat 🔗 Requirements  n8n instance (cloud or self-hosted) ⚙️ Telegram Bot credentials configured in n8n (to receive messages and send replies) 🤖 HeyGen API key for: POST https://api.heygen.com/v2/video/generate GET https://api.heygen.com/v1/video_status.get A transcription step configured in n8n for converting voice memos to text (node present in this workflow) 🗣📝 Target Audience  Teams creating AI UGC directly from chat workflows 📢 Marketing and social teams capturing quick briefs via voice 🧑 Agencies standardizing UGC production pipelines 🏢 Ops and support teams needing rapid content responses 🚀 Step-by-Step Setup Instructions (Concise)  Connect Telegram Bot credentials in n8n and select the chat/channel for Message Trigger 🤝 Add your HeyGen API key in n8n Credentials and map it in the HTTP Request nodes 🔑 Ensure the transcription node is configured to convert audio to text and map output to video generation 🧭 Import the workflow, assign credentials to all nodes, and replace any placeholders 🧩 Run once to test end-to-end; adjust the 10s buffer if videos take longer ⏳. An n8n automation workflow template by Rahul Joshi.

By Rahul Joshi

Description  Automate dress image handling end-to-end: search files, download them, upload to Cloudinary, invoke Azure OpenAI (GPT-4o), parse structured output, and append rows to a sheet. Gain a repeatable, low-touch process for product media and metadata logging. ✨ What This Template Does  Searches files and folders from your connected storage. 🔎 Loops over each item to process them individually. 🔁 Downloads each file for processing. ⬇ Uploads image frames to Cloudinary via REST POST. ☁️ Sends content to Azure OpenAI Chat Model and parses structured output. 🤖 Appends rows to a sheet (two destinations supported) for logging. 📄 Merges inputs where needed to streamline final outputs. 🔗 Key Benefits  Saves time by automating multi-step media handling. ⏱ Ensures consistent uploads and logs for every file. ✅ Adds AI-powered processing via Azure OpenAI when needed. 🧠 Keeps records up to date with automatic sheet appends. 📈 Modular flow that’s easy to adapt to your source/destination. 🧩 Features  File and folder search node for flexible intake. 📂 Item-by-item loop for reliable, scalable processing. 🔁 Cloudinary image upload via HTTP POST endpoint. ☁ Azure OpenAI Chat Model invocation. 🤖 Structured Output Parser for clean, machine-readable results. 🧾 Dual sheet append capability for separate logs. ➕ Requirements  An n8n instance (cloud or self-hosted). 🧭 Cloudinary account with an accessible upload endpoint. ☁️ Azure OpenAI access with a deployed Chat Model (GPT-4o). 🔐 A connected spreadsheet integration in n8n for appending rows. 📄 Access to your file storage where the search and download occur. 📂 Target Audience  E-commerce and catalog teams managing product media. 🛍️ Ops teams standardizing uploads and record-keeping. 🧰 No-code/low-code builders organizing image pipelines. 🧱 Agencies maintaining client product image workflows. 🏷️ Step-by-Step Setup Instructions Connect your file storage credential for Search/Download nodes. 🔌 Configure Cloudinary upload endpoint and credentials in n8n. ☁️ Add Azure OpenAI credentials and set your GPT-4o deployment details. 🤖 Connect your sheet credential(s) and select target sheet(s). 📄 Import the workflow, assign credentials to each node, and replace placeholders. ✅ Run once to test; then enable scheduling or triggers as needed. 🚀. An n8n automation workflow template by Rahul Joshi.

By Rahul Joshi

Description  Automatically ingests new employee data, extracts relevant signals, scores attrition risk, and notifies HR/managers with structured insights and recommended actions. Built on Azure OpenAI Chat with Structured Output Parser and true/false routing for escalation. What This Template Does  Trigger for new data: Starts when a new profile, survey, or report file is added. Download & extract: Retrieves the file and converts PDFs/text into analyzable content. Analyze signals: Uses Azure OpenAI Chat to interpret sentiment, workload, performance notes, feedback, and changes (role, compensation, manager, location). Structured parsing: Maps to fields like risk_score, risk_level, key_drivers, recommended_interventions, escalation_required. Logic routing: Applies thresholds (e.g., risk_score ≥ 0.7) and flags for urgent follow-up. Email alerts: Drafts and sends tailored notifications to HR/manager with action steps. Key Signals Considered  Sentiment & language: Negative tone, burnout cues, disengagement in feedback. Activity trends: Drop in participation, delayed responses, meeting absenteeism. Performance & goals: Recent rating changes, missed OKRs, quality issues. Role & compensation: Lateral moves, pay gaps vs. market, stalled progression. Managerial context: Team churn, conflict mentions, low recognition frequency. Features  Azure OpenAI Chat: Interprets unstructured text into consistent risk fields. Structured Output Parser: Guarantees schema for downstream decisions. Conditional Logic (true/false): Threshold checks for escalation. Memory: Maintains context across multiple files per employee for trend-aware scoring. Calculate avg span: Computes tenure or recency metrics used in risk scoring. Email Composer & Sender: Generates and dispatches HR-ready alerts. Requirements  n8n instance with access to employee data sources (Drive, Inbox, HR folder). Extract From PDF configured for clean text output. Azure OpenAI credentials (e.g., GPT‑4o‑mini) connected to Chat Model. Email service (Gmail/SMTP) set in n8n Credentials. Parser schema aligned to your People Analytics fields (risk_score, drivers, actions). An n8n automation workflow template by Rahul Joshi.

By Don Jayamaha Jr

Create your own Bitcoin Liquidity Exchange Channel with an AI Agent—fully integrated with 10 major centralized exchanges. This workflow acts as a liquidity intelligence agent, connecting multiple exchange order books into a unified dataset, then applying AI analysis to generate actionable trading insights. It’s the ultimate tool for Bitcoin traders, analysts, community managers, and researchers who need cross-exchange liquidity monitoring—delivered instantly through Telegram. 🔌 Supported Exchanges (Integrated) Binance Coinbase Bybit MEXC Gate.io Bitget OKX Kraken HTX (Huobi) Crypto.com 🌟 What Makes This Workflow Special? This isn’t just raw order book data—it’s an AI-powered aggregator that: Fetches BTC/USDT order books (up to 5000 levels deep) from 10 exchanges Normalizes & merges** liquidity data into a single view Uses GPT-4.1 or GPT-4.1-mini to detect liquidity clusters, imbalances, and support/resistance Generates two structured outputs: Liquidity Report (raw snapshots from all exchanges) AI Trading Brief (intraday + weekly signals) Publishes insights directly into a Telegram channel 🔍 What You Can Do 📊 Cross-Exchange Liquidity View Monitor total liquidity depth across top 10 exchanges Spot hidden bid/ask clusters and weak order book levels ⚡ Real-Time Signals Detect when liquidity evaporates at key price points Receive intraday + weekly trading briefs 📢 Community Ready Run your own public or private Telegram channel with automated liquidity updates ✅ Example Alerts “BTC liquidity depth update: $30M bid wall forming at $62,000 across Binance & OKX.” “Ask-side liquidity dropped 20% in the last hour on Bybit + Coinbase.” “Daily summary: Cross-exchange liquidity balanced, net inflow +3.2%.” “Liquidity cluster detected: strong support between $61,800 – $62,150.” 🛠️ Setup Instructions Create a Telegram Bot Use @BotFather to generate a bot token Add the bot to your channel and get the channel ID Configure API Keys OpenAI API Key (GPT-4.1 or GPT-4.1-mini) Telegram Bot Token + Channel ID Import Workflow into n8n Add credentials in the Set node (no hardcoding in HTTP nodes) Configure schedule trigger (15m, hourly, daily, etc.) Deploy & Test Run the workflow and confirm liquidity + AI insights appear in Telegram ⚙️ Workflow Architecture AI Brain** → GPT-4.1 or GPT-4.1-mini Data Sources** → 10 centralized exchanges (BTC/USDT order books) Data Normalization** → Unified liquidity dataset Outputs** → Liquidity Report (raw exchange stats) AI Trading Brief (signals + summaries) Delivery** → Telegram Channel 📝 Included Sticky Notes System Overview** (workflow purpose & design) Exchange Data Integration** (order book depth per CEX) Setup Guide** (Telegram + API keys) Customization Notes** (change frequency, extend signals) Legal Disclaimer** (AI analysis, not financial advice) Your Bitcoin liquidity insights—unified, AI-analyzed, and delivered in real time to Telegram. An n8n automation workflow template by Don Jayamaha Jr.

By Meelioo

How it works This beginner-friendly workflow demonstrates the core building blocks of n8n. It guides you through: Triggers – Start workflows manually, on a schedule, via webhooks, or through chat. Data processing** – Use Set and Code nodes to create, transform, and enrich data. Logic and branching – Apply conditions with IF nodes and merge different branches back together. API integrations** – Fetch external data (e.g., users from an API), split arrays into individual items, and extract useful fields. AI-powered steps** – Connect to OpenAI for generating fun facts or build interactive assistants with chat triggers, memory, and tools. Responses** – Return structured results via webhooks or summary nodes. By the end, it demonstrates a full flow: creating data → transforming it → making decisions → calling APIs → using AI → responding with outputs. Set up steps Time required: 5–10 minutes. What you need: An n8n instance (cloud or self-hosted). Optional: API credentials (e.g., OpenAI) if you want to test AI features. Setup flow: Import this workflow. Add your API keys where needed (OpenAI, etc.). Trigger the workflow manually or test with webhooks. >👉 Detailed node explanations and examples are already included as sticky notes inside the workflow itself, so you can learn step by step as you explore. An n8n automation workflow template by Meelioo.

By Xavier Tai

🎨 TikTok Carousel Replicator & Translator An end-to-end automation system that monitors TikTok accounts for new 3-image carousel posts, extracts text overlays and visual layouts using AI vision analysis, translates content into English, and automatically regenerates brand-new carousel images ready for review and posting. What It Does This workflow eliminates the manual process of: Daily monitoring for new carousel content Screenshot capture and image extraction Text transcription and translation Layout recreation in design tools Manual formatting and brand consistency checks Instead, it delivers 3 production-ready images to your inbox every morning—complete with translated text, matched composition, and side-by-side comparisons for quick approval. Key Features Automated Daily Monitoring** - Checks target TikTok accounts on schedule AI-Powered Vision Analysis** - Extracts text, layout, and composition with Gemini Vision Smart Translation** - Converts text to natural English while preserving intent Intelligent Image Generation** - Recreates carousels with Midjourney/DALL-E based on analyzed layouts Review Dashboard** - Organized Google Sheets with original vs. new comparisons Email Notifications** - Morning digest with clickable previews Who It's For Content creators, social media managers, and marketing teams who need to adapt high-performing carousel content from other languages into English—without spending hours in Canva every day. Time Saved From 3+ hours of manual work → 2 minutes of review per carousel set. Workflow Breakdown Monitor → Extract & Analyze → Translate → Generate → Review & Deliver Each section runs automatically, processing images sequentially and delivering organized results to your review dashboard with email notifications. 🚀 SETUP INSTRUCTIONS Required Credentials: Google Gemini API - For vision analysis Midjourney API (or alternative: DALL-E, Stable Diffusion) OpenAI API - For prompt generation and translation enhancement Google Sheets - For review dashboard Gmail - For notifications Configuration Steps: Replace @USERNAME in TikTok RSS node with target account Set your Google Sheet ID in "Save to Review Sheet" node Update email addresses in notification node Test with a single post before enabling daily schedule Alternative Approaches: Can use TikTok API instead of RSS (if available) Can use Canva API instead of Midjourney for generation Can integrate with Airtable for more advanced review workflows Can add approval workflow with interactive buttons. An n8n automation workflow template by Xavier Tai.

By Blukaze Automations

This n8n template demonstrates how to automatically generate accurate subtitles from any video and optionally translate them into other languages. By combining FFmpeg, OpenAI Whisper, and LibreTranslate, this workflow turns video audio into ready-to-use .srt subtitle files that can be delivered via email. Use cases Auto-generate subtitles for training or educational videos Translate videos into multiple languages for global reach Create accessibility-friendly content with minimal effort Build a backend for media platforms to process subtitles automatically Good to know This workflow requires a self-hosted n8n instance since it uses the Execute Command node. FFmpeg is used for audio extraction and must be installed on the host machine. OpenAI Whisper (Local) is used for transcription, providing highly accurate speech-to-text results. LibreTranslate is used for translating subtitles into other languages. How it works Webhook Trigger – Starts when a video URL is received. Download Video – Fetches the video file from the provided link. Extract Audio (FFmpeg) – Separates audio from the video file. Run Whisper (Local) – Transcribes the extracted audio into text subtitles. Read SRT File – Loads the generated .srt subtitle file. Merge Paths – Combines both original and translated subtitle flows. Translate Subtitles (LibreTranslate) – Translates the .srt file into the target language. Write Translated SRT – Creates a translated .srt file for delivery. Send a Message (Gmail) – Sends the final subtitle file (original or translated) via email. How to use Clone this workflow into your self-hosted n8n instance. Ensure FFmpeg and Whisper are installed and available via your server’s shell path. Add your LibreTranslate service credentials for translation. Configure Gmail (or another email service) to send subtitle files. Trigger the workflow by sending a video URL to the webhook, and receive subtitle files in your inbox. Requirements Self-hosted n8n instance FFmpeg installed and available on the server OpenAI Whisper (Local) installed and callable via command line LibreTranslate service with API credentials Gmail (or any email integration) for delivery Customising this workflow Replace Gmail with Slack, Telegram, or Drive uploads for flexible delivery. Switch LibreTranslate with DeepL or Google Translate for higher-quality translations. Add post-processing steps such as formatting .srt files or embedding subtitles back into the video. Use the workflow as a foundation for building a multi-language subtitle automation pipeline. An n8n automation workflow template by Blukaze Automations.

By Amirul Hakimi

Supercharge your sales and marketing efforts with this powerful automation that transforms a list of LinkedIn profiles into a fully enriched, personalized outreach campaign. This workflow is designed for sales teams, growth marketers, and business development professionals looking to scale their lead generation without sacrificing personalization. It seamlessly integrates LinkedIn scraping, email enrichment with Hunter.io, AI-powered message generation with OpenAI, and data organization in Google Sheets. How It Works Start with Leads: The workflow begins with a list of target LinkedIn profile URLs. Scrape Profile Data: It automatically scrapes each LinkedIn profile to extract key professional information such as name, title, company, and location. A built-in delay helps manage rate limits. Find Verified Emails: Using the scraped company and name, the workflow queries ==Hunter.io to find a verified work email address== for the lead. AI-Powered Personalization: If an email is found, the lead's data is sent to OpenAI (GPT-4), which generates a highly personalized, conversational outreach message based on their role, company, and your value proposition. Sync to CRM/Sheet: Finally, all the enriched data—including the custom AI message—is neatly organized and saved as a new row in your designated Google Sheet. Stop wasting hours on manual lead research and generic outreach. Implement this automated workflow to focus on building relationships and closing deals. An n8n automation workflow template by Amirul Hakimi.

By Oriol Seguí

Instantly map all internal URLs, perform AI-powered (ChatGPT) analysis, and deliver results in HTML via webhook, Google Sheets, or email. All from your own n8n instance! 💡 Why this workflow? Forget expensive tools:** Run deep, visual audits replacing Screaming Frog or Ahrefs. Real URL mapping:** Reads the sitemap, filters only internal URLs, and analyzes each one individually. AI-powered analysis:** ChatGPT detects critical issues, recommendations, and best practices on every page. Error handling:** The workflow includes robust error handling and guides you on what to do in each case. Client-ready results:** Receive a professional HTML report, an email summary, or push it to Google Sheets for team collaboration. Automate by webhook or manually:** Use it in backend integrations or trigger with a button. 🧠 What does the workflow do? Automatically detects the sitemap (robots.txt → sitemap.xml). Filters only internal URLs (ignores assets, images, scripts, etc). Fetches the full HTML content of each URL. Uses ChatGPT (GPT-4o-mini) for professional diagnostics (meta tags, headings, hreflang, Open Graph, links, duplicate content, etc). Groups results (critical issues, recommendations, best practices) and presents them as: 📄 Professional HTML report (ready to send/share) 📊 Google Sheets (collaborative structure) 🔗 Webhook or HTML email (for automation) 🛠️ Technologies / APIs Used n8n** (self-hosted or cloud instance required) ChatGPT API** (required, approx. cost: €0.01 per 20 URLs analyzed) Google Drive/Sheets API** (only for Google Sheets output) Email SMTP/Gmail** (for notifications) ⚡ Who should use it? SEOs and agencies needing technical reports in minutes Freelancers automating client SEO audits Web developers and growth hackers Website owners/businesses with multiple sites 🎯 Problems solved Slow, manual SEO auditing Dependence on expensive SaaS Lack of full-site coverage → every URL is checked with actionable recommendations Fast, visual delivery to clients (HTML “copy-paste” report and/or collaborative sheet) 📝 Quick Setup Import the .json into your n8n. Add your credentials: OpenAI (ChatGPT) API Key Google account (only for Google Sheets output) Run manually or via webhook (you can pass the URL as a parameter). View the results in the generated HTML, Google Sheets, or your email. 💡 Details & Tips Enter only the domain (e.g., example.com) — no https:// and no trailing slash. If any error occurs (unusual sitemap, robots blocked, etc.), the messages are explained clearly. You can change the analysis language (default: Spanish). 100% customizable and extendable for other outputs (Notion, Slack, etc). 📦 What’s included? 🧩 n8n workflow file → SEO n8n.json 📘 Quick install guide (README) 💬 Direct support: oriolrotllant3@gmail.com 📸 More info and photos: oriolrotllant3@gmail.com. An n8n automation workflow template by Oriol Seguí.

By Jitesh Dugar

Who's it for This template is designed for anyone who wants to use WhatsApp as a personal AI assistant hub. If you often juggle tasks, emails, calendars, and expenses across multiple tools, this workflow consolidates everything into one seamless AI-powered agent accessible right from your most-used messaging app. What it does Jarvis listens to your WhatsApp messages (text or audio) and processes them with OpenAI. Based on your request, it can: ✅ Manage tasks (create, complete, or delete) 📅 Handle calendar events (schedule, reschedule, or check availability) 📧 Send, draft, or fetch emails with Gmail 👥 Retrieve Google Contacts 💵 Log and track expenses 🎤 Process voice notes and respond intelligently All responses are returned directly to WhatsApp, giving you a unified command center that works on any device. How to set up Clone this template into your n8n workspace. Set up a WhatsApp Business API account (via Meta Business Suite or providers like Twilio, 360dialog, or MessageBird). Configure the WhatsApp webhook to connect to your n8n instance. Connect your Google accounts (Gmail, Calendar, Contacts, etc.). Add your OpenAI API key in the Credentials section. Test by sending a WhatsApp message like: "Create a meeting tomorrow at 3pm" "Add expense $50 for lunch" "Draft a reply to that email from Steve" "What's on my calendar this week?" Requirements n8n instance** (cloud or self-hosted with public webhook URL) WhatsApp Business API** credentials (not regular WhatsApp) Gmail, Google Calendar, and Google Contacts** credentials (optional based on features) OpenAI API key** ElevenLabs API Key** (optional, for advanced audio note processing) How to customize Swap email providers** by replacing the Gmail MCP node with Outlook, Exchange, or IMAP/SMTP. Add more integrations** like Notion, Slack, Todoist, or your CRM. Adjust AI personality** by modifying the system prompt in the OpenAI node. Control context memory** to determine how much conversation history Jarvis remembers. Add automation rules** like auto-categorizing expenses or auto-scheduling recurring meetings. Multi-language support** by configuring OpenAI to respond in different languages. Key advantages of WhatsApp version 🌍 Universal access - WhatsApp works everywhere, including international numbers 📱 Cross-platform - Seamlessly works on mobile, web, and desktop 🔒 End-to-end encryption for sensitive task and email data 👥 Familiar interface - No need to learn a new app ✅ Read receipts - Know when Jarvis has processed your request With this template, you can transform WhatsApp into your all-in-one AI productivity assistant, simplifying workflows and saving hours every week—all from the app you're already using daily. An n8n automation workflow template by Jitesh Dugar.

By Gerald Denor

This can be your Alternative to Cal AI App Overview: A comprehensive n8n workflow demonstrating advanced AI agent orchestration, stateful conversation management, and multi-modal input processing for nutrition tracking applications. Technical Architecture: This workflow showcases production-ready patterns for building complex conversational AI systems in n8n: Multi-Agent System Design Router Agent: Analyzes user intent and routes to specialized sub-agents Registration Agent: Handles new user onboarding with guided data collection Meal Logging Agent: Processes text, image, and voice inputs for nutrition analysis Update Agent: Manages multi-turn conversations for meal corrections Report Agent: Generates daily nutrition summaries Profile Agent: Handles user preference updates Stateful Conversation Management The workflow implements a state machine using n8n Data Tables: Tracks conversation context across messages Enables multi-step workflows (e.g., "get meal ID → ask for new description → update") Prevents context loss in long conversations Auto-resets state after task completion Multi-Modal Input Processing Text: Direct AI analysis using Google Gemini Images: Gemini Vision API with specialized nutrition analysis prompts Voice: Audio-to-text transcription followed by analysis Unified output format regardless of input type Advanced Prompt Engineering Specialized system prompts for each agent role Structured output formatting for reliable data extraction Regional cuisine knowledge (African/West African foods) Error handling and clarification requests built into prompts Data Persistence Layer Uses n8n Data Tables for: User profiles (calories, protein targets, preferences) Meal logs (descriptions, macros, timestamps) Conversation state (current step, context variables) Telegram Integration MarkdownV2 formatting with auto-chunking for long messages Handles all Telegram message types (text, photo, voice) "Typing" indicators for better UX Learning Outcomes: By studying this workflow, you'll understand: How to build agent hierarchies with specialized roles State management patterns for complex conversations Multi-modal AI input processing techniques Production data persistence strategies in n8n Scalable webhook-based bot architecture Technical Requirements: n8n version 1.0+ (uses Data Tables feature) Google Gemini API access Telegram Bot Token Basic understanding of: AI agents, webhook triggers, data tables Difficulty Level: Intermediate to Advanced Use Cases Beyond Nutrition: The patterns here apply to any domain requiring: Multi-step user onboarding Data collection through conversation Record updates via natural language Report generation Profile management Components: 50+ nodes demonstrating n8n AI features 6 specialized AI agents 3 data tables with structured schemas Custom JavaScript for MIME type handling and markdown formatting Integration with Google Gemini (text + vision + audio models) What Makes This Workflow Unique: Most n8n AI examples show simple Q&A bots. This demonstrates enterprise-grade conversation management with real data persistence, making it suitable for actual production deployment. SETUP GUIDE Need Help? Reach me: https://www.linkedin.com/in/gerald-akhidenor-1ab1a45/ Work with me: https://dominixai.com/ My website: https://jobmonkey.dev My email: denorgerald@gmail.com Cal AI Nutrition Bot - Complete Setup Guide Who This Guide Is For: This workflow is designed for beginner to intermediate no-code builders who want to launch a nutrition tracking bot. You should be comfortable: Creating accounts on platforms (n8n, Google Cloud, Telegram) Following step-by-step instructions Copy-pasting API keys Basic JSON importing No programming experience required. If you can use Zapier or Make.com, you can set this up. Prerequisites (30 minutes to gather) n8n Account Option A (Easiest): Sign up for n8n Cloud at n8n.io (14-day free trial, then $20/month) Option B (Free): Self-host n8n on DigitalOcean/Railway/your server Google Gemini API Key Go to ai.google.dev Click "Get API Key" Create new project (free tier: 15 requests/minute) Copy your API key Telegram Bot Open Telegram and search for @BotFather Send /newbot command Follow prompts to create your bot Copy the bot token (looks like: 1234567890:ABCdefGHIjklMNOpqrsTUVwxyz) Step 1: Import the Workflow (5 minutes) Log into your n8n instance Click "New Workflow" in top left Click the three-dot menu → Import from File Upload the My_workflow.json file you downloaded The workflow will appear with all nodes connected Step 2: Create Data Tables (10 minutes) The workflow uses three data tables to store information. Create them exactly as shown: Table 1: Cal AI Profiles Navigate to n8n Data Tables section Click Create Data Table Name: Cal AI Profiles Add columns: User_ID (Text) Name (Text) Email (Text) Calories_target (Number) Protein_target (Number) Country (Text) Table 2: Cal AI Meals Create new table: Cal AI Meals Add columns: Meal_ID (Text) User_ID (Text) Date (Text) Meal_description (Text) Calories (Number) Proteins (Number) Carbs (Text) Fats (Text) Table 3: Cal AI StateManagement Create new table: Cal AI StateManagement Add columns: User_ID (Text) State (Text) Last_Interaction (DateTime) Context_MealID (Text) Step 3: Configure Credentials (15 minutes) A. Add Google Gemini Credential In any Google Gemini node, click "Create New Credential" Paste your Gemini API key Click Save This credential will auto-apply to all Gemini nodes B. Add Telegram Credential Open any Telegram node Click "Create New Credential" Paste your bot token Click Save C. Link Data Tables Open the "Is User Registered?" node Click the Data Table dropdown Select "Cal AI Profiles" Repeat for all nodes with data table connections (n8n will show which ones need updating) Step 4: Activate Telegram Webhook (5 minutes) Open the "Telegram Trigger" node Click "Execute Node" to register the webhook You'll see "Webhook registered successfully" Click "Listen for Test Event" to verify Send a message to your bot on Telegram You should see the message appear in n8n Step 5: Test Each Function (20 minutes) Test 1: User Registration Send any message to your bot Bot should ask for your name Follow the prompts to complete registration Check the "Cal AI Profiles" data table to confirm your data was saved Test 2: Meal Logging (Text) Send: "I had 2 eggs and toast" Bot should respond with nutrition breakdown Test 3: Meal Logging (Image) Take a photo of food Send it to the bot Bot should analyze and log the meal Test 4: Meal Logging (Voice) Record a voice message: "I had chicken and rice" Send it to your bot Bot should transcribe and analyze Test 5: Update Meal Send: "update meal" Follow prompts to provide meal ID and new description Test 6: Get Report Send: "show my report" Bot should ask for a date and generate summary Step 6: Customize (Optional) Change Bot Personality Edit the systemMessage in each Agent node Adjust tone, add emojis, change coaching style Add Your Branding Update bot responses to mention your app name Customize welcome messages Modify Cuisine Focus Update the nutrition analysis prompts to focus on your target cuisine Current default: African/West African/Nigerian foods Adjust Nutrition Calculations Edit the Gemini Vision prompt in "Analyze image" node Modify portion size assumptions or macro ratios Troubleshooting Bot doesn't respond: Check webhook is activated in Telegram Trigger node Verify Telegram credential is correct Check execution logs for errors "Data Table not found" errors: Ensure all three tables are created with exact names Relink tables in each node Gemini API errors: Verify API key is active Check you haven't exceeded free tier limits (15/min) Try regenerating API key Meals not saving: Check "Append Meal Data" node is connected Verify User_ID matches between tables Going Live Once testing is complete: Click "Active" toggle in top right Share your bot link: t.me/YourBotUsername Monitor the Executions tab for any errors Target Users & Support This workflow is perfect for: Fitness coaches wanting client nutrition tracking without monthly SaaS fees Health tech entrepreneurs building MVP before hiring developers No-code builders learning advanced n8n AI patterns Bootcamp graduates needing portfolio projects with real-world complexity Small app studios prototyping before committing to custom development You'll succeed with this if you: Can follow detailed instructions Are comfortable with web-based tools Want to learn by doing (the workflow itself is educational) Need a production-ready solution quickly You might struggle if: You've never used n8n before (recommend taking their free course first) You're not comfortable with API concepts (keys, webhooks) You need 100% hand-holding (this assumes basic technical literacy) Support: Reach me: https://www.linkedin.com/in/gerald-akhidenor-1ab1a45/ Review Google Gemini documentation for AI customization Telegram Bot API docs for advanced features Next Steps After Setup Invite Beta Users - Start with friends/clients to gather feedback Monitor Usage - Watch which features get used most Customize Prompts - Refine AI responses based on real conversations Add Features - Use this as foundation for recipe suggestions, meal planning, etc. Scale Infrastructure - Move to dedicated hosting as user base grows Estimated total setup time: 1-2 hours for complete beginners, 30 minutes for experienced n8n users. An n8n automation workflow template by Gerald Denor.

By Junichiro Tobe

How it works This workflow automatically analyzes meeting effectiveness and provides constructive feedback: • Retrieve meeting minutes: Automatically searches and retrieves meeting minutes from Google Drive using either a Google Docs URL or meeting name • Multi-dimensional analysis: Comprehensively evaluates meeting effectiveness score, speaking time distribution, communication quality (clarity, friendliness, decisiveness, listening), disagreements, and more • Generate actionable feedback: Outputs a structured report in Japanese with specific improvement suggestions and highlights of what went well Set up steps Setup takes approximately 5 minutes: • Connect Google Drive: Grant permission for the workflow to access your meeting minutes by connecting to Google Drive • First run: Enter the meeting minutes URL or meeting name and execute the workflow For detailed setup instructions and step-by-step explanations, please refer to the sticky notes inside your workflow. An n8n automation workflow template by Junichiro Tobe.

By SpaGreen Creative

Shopify Auto Send WhatsApp Thank-You Messages & Loyalty Coupon Using Rapiwa API Who is this for? This workflow is for Shopify store owners, marketers, and support teams who want to automatically message their high-value customers on WhatsApp when new discount codes are created. What this workflow does Fetches customer data from Shopify Filters customers where total_spent > 5000 Cleans phone numbers (removes non-digit characters) and normalizes them to an international format Verifies numbers via the Rapiwa API (verify-whatsapp endpoint) Sends coupon or thank-you messages to verified numbers via the Rapiwa send-message endpoint Logs each send attempt to Google Sheets with status and validity Uses batching (SplitInBatches) and Wait nodes to avoid rate limits Key features Automated trigger: Shopify webhook (discounts/create) or manual trigger Targeted sending to high-value customers Pre-send verification to reduce failed sends Google Sheets logging and status updates Rate-limit protection using Wait node #How to use? Step-by-step setup 1) Prepare a Google Sheet Columns: name, number, status, validity, check (optional) Example row: Abdul Mannan | 8801322827799 | not sent | unverified | check 2) Configure n8n credentials Shopify: store access token (X-Shopify-Access-Token) Rapiwa: Bearer token (HTTP Bearer credential) Google Sheets: OAuth2 credentials and sheet access 3) Configure the nodes Webhook/Trigger: Shopify discounts/create or Manual Trigger HTTP Request (Shopify): /admin/api/<version>/customers.json Code node: filter customers total_spent > 5000 and map fields SplitInBatches: batching/looping Code (clean number): waNoStr.replace(/\D/g, "") HTTP Request (Rapiwa verify): POST https://app.rapiwa.com/api/verify-whatsapp body { number } IF node: check data.exists to decide branch HTTP Request (Rapiwa send-message): POST https://app.rapiwa.com/api/send-message body { number, message_type, message } Google Sheets Append/Update: write status and validity Wait: add 2–5 seconds delay between sends 4) Test with a small batch Run manually with 2–5 records first and verify results Google Sheet column structure A Google Sheet formatted like this ➤ Sample | Name | Number | Status | Validity | | -------------- | ------------- | -------- | ---------- | | Abdul Mannan | 8801322827798 | not sent | unverified | | Abdul Mannan | 8801322827799 | sent | verified | Requirements Shopify Admin API access (store access token) Rapiwa account and Bearer token Google account and Google Sheet (OAuth2 setup) n8n instance (nodes used: HTTP Request, Code, SplitInBatches, IF, Google Sheets, Wait) Customization ideas Adjust the filter (e.g., order count, customer tags) Use message templates to insert name and coupon code per customer Add an SMS or email fallback for unverified numbers Send a run summary to admin (Slack / email) Store logs in a database for deeper analysis Important notes data.exists may be a boolean or a string — normalize it in a Code node before using in an IF node Ensure Google Sheets column names match exactly Store Rapiwa and Shopify tokens securely in n8n credentials Start with small batches for testing and scale gradually Useful Links Dashboard:** https://app.rapiwa.com Official Website:** https://rapiwa.com Documentation:** https://docs.rapiwa.com Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen. An n8n automation workflow template by SpaGreen Creative.

By Eduard

This n8n workflow template simplifies processing of media group messages sent by users in Telegram. It caches image album messages using Data Tables, and then sends them to a Nano Banana model for processing. This template showcases n8n's new Data Tables feature as a powerful caching layer to process entire image albums from Telegram. How it works Media Group handling**: captures all images and the shared caption when user sends an album via Telegram. Data Table caching**: stores all incoming messages in a Data Table to prevent data loss and allow for batch processing. Scheduled processing**: a timer trigger periodically finds and processes completed image albums from the cache. Multi-modal AI**: sends the full set of images and the text prompt to the NanoBanana model via OpenRouter. User feedback**: automatically notifies the user when processing begins and when the result is ready. How to use Import the workflow template into your n8n instance. Create a new Data Table with the following columns (all of type String): chat_id, message_id, media_group, message, status. Configure your Telegram credentials and connect your bot. Update the "prepare user messages" node with your Telegram bot token to create the image download links. Set up your OpenRouter credentials. Activate the workflow. Now you can send a group of images with a caption to your Telegram bot. Requirements An n8n instance (cloud or self-hosted) with Data Tables enabled. Minimal n8n version is 1.113 A Telegram account and a Telegram bot token. An OpenRouter account with access to the NanoBanana model. Customizing this workflow Adjust the processing schedule: modify the **Schedule Trigger node to change how often the workflow checks for new media groups to process. Handle other message types: The workflow handles only the media groups. You can easily build logic for text messages, documents, or commands by adding nodes instead of the placeholder node ("Process other messages as usual"**). Extend the functionality**: add more nodes after the AI generates an image to perform different actions, such as saving the file, sending it to another service, or creating a social media post. An n8n automation workflow template by Eduard.

By Atharva

🧾An intelligent automation system that turns WhatsApp into your personal receipt manager — integrating Meta WhatsApp Cloud API, Google Drive, Google Sheets, and OpenAI GPT-4o-mini via n8n. 🎥 Demo: Watch the Loom walkthrough ⚙️ What It Does The AI-Powered WhatsApp Receipt Bot automates the complete invoice handling process through a conversational interface. Workflow Summary: User sends a receipt image via WhatsApp. The bot automatically downloads the media using the WhatsApp Cloud API. The image is uploaded to a Google Drive “Invoices” folder. The file is shared publicly, generating a shareable URL. The receipt is analyzed using OpenAI GPT-4o-mini to extract structured data: Store name Items purchased Payment method Total amount The extracted details are appended to a Google Sheet for record-keeping. The bot sends a human-readable summary back to WhatsApp with emojis and the invoice link. Output Example: 🏬 Store: Big Bazaar 📝 Items: Rice, Detergent, Snacks 💳 Payment: Card 💰 Total: ₹1520.75 🔗 Link: https://drive.google.com/file/d/1abcXYZ/view This system eliminates manual expense tracking, improves accuracy through OCR, and provides a seamless way to manage receipts in real time. 💡 Use Cases | Scenario | Description | | ------------------------------------- | --------------------------------------------------------------------------------------------------------------------- | | Personal Expense Management | Automatically store and categorize receipts from daily purchases. | | Business Accounting | Collect employee expense receipts through WhatsApp and centralize them in Google Sheets. | | Freelancer or Consultant Tracking | Keep a digital record of client reimbursements or software purchase receipts. | | Family Budgeting | Family members send receipts to one shared WhatsApp number, all data gets logged centrally. | | E-commerce / Delivery Teams | Drivers or delivery agents send invoices from the field to WhatsApp; data automatically goes to the accounting sheet. | 🔧 Setup 1. Accounts and Tools Needed | Tool | Purpose | Link | | -------------------------- | ------------------------------------------- | -------------------------------------------------------------------------------------------- | | Meta Developer Account | To access WhatsApp Business Cloud API | https://developers.facebook.com/apps | | Google Cloud Account | For enabling Drive and Sheets APIs | https://console.cloud.google.com | | n8n Instance | Workflow automation engine (local or cloud) | https://app.n8n.cloud | | OpenAI API Key | For GPT-4o-mini model OCR + reasoning | https://platform.openai.com/account/api-keys | 2. Meta Developer Setup (WhatsApp Cloud API) Go to Meta Developer Dashboard → My Apps → Create App → Business type. Add WhatsApp product under your app. Retrieve the following from WhatsApp > Configuration: Permanent Access Token Phone Number ID WhatsApp Business Account ID Add these credentials in n8n → Credentials → WhatsApp API. Use the same credentials for WhatsApp Trigger and Send Message nodes. Verify webhook in Meta with your n8n webhook URL. Important: In your HTTP Node, set the header as: Authorization: Bearer <access_token> Replace <access_token> with your WhatsApp Cloud API permanent token. Without this, the workflow will fail to send or receive WhatsApp messages properly. 3. Google Drive Setup Create a folder named Invoices on your Google Drive. Copy the Folder ID (found in the Drive URL). In Google Cloud Console → APIs & Services → Enable APIs: Enable Google Drive API Enable Google Sheets API Go to Credentials → Create Credentials → OAuth 2.0 Client ID. Download the credentials.json file. Upload this to n8n → Credentials → Google Drive OAuth2 API. Authorize the connection on first workflow run. 4. Google Sheets Setup Create a new Google Sheet titled Invoices. Add the following headers in Row 1: store name | discription | image_url | payment | total Copy the Sheet ID (from the URL). Add the ID under the Google Sheets Append node in n8n. Map each field to its corresponding value extracted from the OCR result. 5. OpenAI Setup Generate an API key from https://platform.openai.com/account/api-keys. Add it to n8n → Credentials → OpenAI API. Use model gpt-4o-mini in the “Analyze Image” node. Can upgrade to gpt-4o for better OCR accuracy if account supports it. 6. n8n Workflow Setup Import the provided n8n workflow JSON. Configure credentials for: WhatsApp API Google Drive OAuth2 Google Sheets OAuth2 OpenAI API Activate workflow and set webhook in Meta Developer console. Send a test receipt image to your WhatsApp Business number. The bot will automatically: Download → Upload → Extract → Log → Summarize → Reply 📊 Example Google Sheet Record | store name | discription | image_url | payment | total | | ---------- | ----------------------- | -------------------------------------------------------------------------------------------- | ------- | ------- | | Big Bazaar | Rice, Detergent, Snacks | https://drive.google.com/file/d/1abcXYZ/view | Card | 1520.75 | 🧠 Result A fully automated AI pipeline that transforms WhatsApp into a smart expense-tracking interface — integrating vision, automation, and natural language processing for zero-manual financial documentation. Support & Contact: If you face any issues during setup or execution, contact: 📧 Email: atharvapj5@gmail.com 🔗 LinkedIn: Atharva Jaiswal. An n8n automation workflow template by Atharva.

By Dominic GS

The Google Meet AI Assistant workflow provides intelligent meeting analysis by integrating Google Calendar, Google Drive, AssemblyAI transcription, Anthropic Claude AI, Slack, and Notion. It automates the complete process of fetching meeting data, retrieving recordings, transcribing conversations, analyzing with AI, and distributing actionable insights. Workflow Steps Step 1: Fetch Meetings Retrieves Google Calendar events from the last 24 hours. Filters for confirmed meetings with Google Meet conference links. Step 2: Get Recording Searches for the meeting recording file saved in Google Drive. Downloads the recording for transcription purposes. Step 3: Transcribe Recording Uses AssemblyAI to transcribe the recording. Transcription includes speaker labels, highlights, and sentiment analysis. Step 4: AI Analysis Analyzes the transcript with Anthropic Claude AI. Extracts: Meeting summary (2-3 paragraphs) Action items with responsible parties Mentioned dates or deadlines Overall meeting sentiment Step 5: Distribute Summary Posts meeting summary and insights to a Slack channel. Creates tasks for action items in Notion. Integration Overview Google Calendar: Event retrieval and filtering of Google Meet meetings. Google Drive: Recording search and download. AssemblyAI: Audio transcription with advanced features. Anthropic Claude (Langchain): AI-driven analysis of transcripts. Slack: Notification distribution for meeting summaries. Notion: Task creation for actionable items. Error Handling If a recording is not found, stops execution and returns an error message: "No recording found for this meeting. Please ensure the meeting was recorded and saved to Google Drive." Summary This workflow fully automates the end-to-end process of meeting analysis from calendar event detection to action item task creation using AI, enabling productivity gains for meeting-heavy teams. If further use or support is needed, you can contact me via LinkedIn. If you want, I can also help create a detailed documentation or a formatted description ready for sharing or integration guides. Let me know!. An n8n automation workflow template by Dominic GS.

By Khairul Muhtadin

Ticketing Backend automates registration, QR-ticket generation, email delivery, and check-in validation using Google Sheets, Gmail, and a webhook scanner — reducing manual ticket prep from ~3 hours to under 5 minutes for 200 attendees. Last updated: September 2026. Why Use This Workflow? Time Savings:** Automates ticket generation & delivery. reduces manual processing for 200 attendees from ~3 hours to <5 minutes. Cost Reduction:** Removes dependency on paid ticketing platforms for basic events — save up to $150–$300/month for small organizations. Error Prevention:** Single-source truth in Google Sheets with QR-based check-in reduces double-checkin and human errors by >90%. Scalability:** Runs on a schedule and webhooks; scales from dozens to thousands of tickets (watch API/email quotas). Ideal For Event Organizers / Community Managers:** Sell & distribute tickets for meetups, runs, and local events with immediate QR delivery. Operations / Venue Staff:** Fast, reliable check-in via mobile scanner POSTing to webhook for instant validation. Small Agencies & SaaS Teams:** Lightweight, low-cost ticketing backend that integrates with existing Google accounts. How It Works Trigger (Registration): POST /v1/register receives registration payload (nama, email, no_hp, jumlah_tiket, total_price, payment_method). Data Collection (Registration): Validate input → check existing participant in Register sheet → append registration. Processing (Ticket Generation): Scheduled job (START runs every minute) finds rows with Payment Status = PAID and Email Sent = NO. Intelligence Layer: For each ticket: generate unique Ticket ID (TL-YYYYMMDD-XXXX-N-HASH), build QR payload JSON, create QR image via qrserver API, and build HTML email with embedded base64 QR. Output & Delivery: Send ticket email(s) via Gmail; write one Tickets row per generated ticket and mark Email Sent = YES in Register. Storage & Logging: All participant & ticket records persisted to Google Sheets; check-in events update row (Checked In = YES and Checkin Time). Core Endpoints Registration webhook: POST /v1/register Scanner webhook (check-in): POST /v1/scanner Event Metadata Event:** TABRAK_LARI Event date:** 15 November 2025 Event location:** GOR Pontianak Setup Guide Prerequisites | Requirement | Type | Purpose | |-------------|------|---------| | n8n instance | Essential | Host the workflow and webhooks | | Google account (Sheets + Gmail) | Essential | Store tickets & send emails | | Google Sheet | Essential | Register & Tickets data store | | Public webhook URL / reverse proxy | Essential | Expose /v1/register & /v1/scanner to scanners/clients | | qrserver.com (public API) | Optional | Generate QR images (no credentials) | > Important: Make sure your n8n instance URL is publicly accessible or use a tunneling/reverse proxy so webhooks can receive POSTs. Installation Steps Import the JSON into your n8n instance. Configure credentials: Google Sheets OAuth2: Grant access to Google Drive & Sheets API (spreadsheets.readonly & spreadsheets). Gmail OAuth2: Grant send email scope (Gmail send). Update environment-specific values: Verify Google Sheet ID. Set the public base URL for ticket scanner clients to POST /v1/scanner. Customize settings: Event name/date/location (variables in Generate Ticket Data / Build HTML Email). Email sender address and subject line in Gmail node. Test execution: Use a sample POST to /v1/register with valid fields to create a registration. Mark a row as PAID and Email Sent = NO to trigger scheduled ticket generation. Simulate a scanner POST to /v1/scanner with the barcode JSON payload to test check-in. Technical Details Core Nodes | Node | Purpose | Key Configuration | |------|---------|-------------------| | REGISTER (Webhook) | Accepts registration POSTs | Path: /v1/register | | Validate Input (Code) | Server-side validation | Validates nama, email, no_hp, jumlah_tiket, payment_method | | Get Participant (Google Sheets) | Check duplicate email | Filters Register tab by Email | | Store Data (Google Sheets) | Append registration | Tab: Register (gid=0) | | START (Schedule Trigger) | Finds paid registrations | Runs every 1 minute | | Get Rows (Google Sheets) | Reads Register rows | Reads full Register tab | | Filter Paid Not Sent (Filter) | Finds rows with Payment Status=PAID & Email Sent=NO | Filter node conditions | | Generate Ticket Data (Code) | Generate ticket IDs & QR payloads | Ticket ID format TL-YYYYMMDD-XXXX-N-HASH | | Generate QR Code (HTTP Request) | Calls qrserver.com to build PNG | URL: https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=... | | Build HTML Email (Code) | Builds ticket HTML & embeds Base64 QR | Template contains ticket details & QR | | Send Email (Gmail) | Sends ticket email | To: recipient Email; Subject configurable | | Update Sheet (Tickets) | Append ticket rows | Tab: Tickets (gid=2010454173) | | Parse Data (Code) | Aggregates ticket IDs per email | Updates Register with combined ticket IDs | | SCAN TICKET (Webhook) | Check-in endpoint | Path: /v1/scanner | | Parse Barcode (Code) | Parses incoming scanner payload | Expects JSON in body.barcode | | Get Tickets (Google Sheets) | Lookup ticket by Ticket ID | Filters Tickets tab by Ticket ID | | Ticket Available? (If) | Validates existence & Checked In status | Branches to update or return error | | Update Ticket Status (Google Sheets) | Mark Checked In = YES | Sets Checkin Time to scannedAt | | Checked IN / Already Checked IN (RespondToWebhook) | Respond payloads for scanner | JSON responses with status & metadata | Workflow Logic Registration:** Writes to Register sheet. A scheduled job picks up PAID rows where Email Sent = NO; for each row it generates one record per ticket, calls the QR API for an image, sends an email per ticket (multi-ticket support), then appends Tickets rows and marks Email Sent = YES by updating the Register sheet with combined ticket IDs. Check-in:** The scanner webhook accepts barcode JSON, extracts ticket_id, looks up the Tickets sheet, prevents duplicate check-ins by checking "Checked In" flag, and updates sheet with check-in timestamp on success. Customization Options Basic Adjustments Email Template:** Edit Build HTML Email node to change branding, copy, or layout. Ticket ID Format:** Change code in Generate Ticket Data to alter prefix or hash length. Event Metadata:** Change event_name, event_date, event_location in code nodes. Advanced Enhancements Payment Gateway Integration:** Integrate with payment gateway (e.g., webhook from Stripe) to automatically set Payment Status = PAID — complexity: medium. Cloud Storage for QR Images:** Use cloud storage (S3) for QR images instead of base64-embedding — complexity: medium-high. Batch Email Provider:** Use batch email provider (SendGrid/Mailgun) for high-volume events to reduce Gmail quota risks — complexity: medium. Troubleshooting | Problem | Cause | Solution | |---------|-------|----------| | Invalid QR / scanner returns "Invalid QR code format" | Scanner payload not sending barcode JSON or malformed JSON | Ensure scanner POST body contains valid JSON string under body.barcode; validate payload in Parse Barcode node | | Ticket exists but cannot update | Google Sheets API auth / permission error | Reconnect Google Sheets OAuth2 credential; ensure the service account/user has edit access to the sheet | | Emails not sent | Gmail OAuth2 credential missing or Gmail API quota reached | Reauthorize Gmail credential; consider switching to SendGrid/Mailgun for large volumes | | Duplicate check-in allowed | Logic checking "Checked In" value mismatch (case/format) | Normalize the Checked In field values and use strict comparisons in Ticket Available? node | | Slow generation for many tickets | Sequential QR calls and sends | Use parallel execution or a dedicated email service; increase worker resources for n8n instance | Use Case Examples Scenario 1: Community Fun Run (200 attendees) Challenge:** Manual QR generation and emailing takes ~3 hours. Solution:** After marking registrations as PAID, the scheduled job generates 200 QR tickets and emails them automatically. Result:** Ticket prep completed in <5 minutes; volunteer time reduced by ~3 hours. Scenario 2: Regional Festival (2,000 tickets) Challenge:** High volume requires reliable delivery and check-in speed. Solution:** Use this workflow but replace Gmail with a transactional email provider (SendGrid) and host n8n on a scalable instance. Monitor Google Sheets and email provider quotas. Result:** Automated delivery scales; on-site check-in handled via the /v1/scanner endpoint with near-instant validation. Quick Answers How do tickets get generated? Mark registrations as PAID with Email Sent = NO. The scheduled job runs every minute, generates QR tickets, and emails them. How does check-in work? The scanner POSTs barcode JSON to /v1/scanner. The sheet validates the ticket and marks Checked In. What about quotas at scale? Watch Gmail and Google Sheets API quotas. For high volume, swap in SendGrid or Mailgun. Additional Information Made by: khmuhtadin Category: Event Automation, Ticketing Backend Tags: google-sheets, gmail, qr-code, webhook, ticketing Need custom workflows or help adapting this for your event? Contact me Note: Import the JSON into your n8n instance to get started. My Social: Threads LinkedIn Medium Workflow Collections portfolio Additional info Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/. An n8n automation workflow template by Khairul Muhtadin.

By Krishna Sharma

Stripe → Pipedrive (Automatic Person + Deal Creation) Prerequisites / Requirements n8n instance (cloud or self-hosted) with HTTPS reachable webhook endpoint Stripe account and secret API key Pipedrive account with API access and custom fields defined Users should create custom fields in Pipedrive and copy their field IDs (e.g. amount, payment method, status, Stripe Event ID) How it works (Step-by-Step) Stripe Webhook: n8n triggers on payment events from Stripe via an HTTP POST. Edit / Set node: Extracts eventId, eventType, and payload. HTTP Request: Confirms Stripe event via Stripe API (adds security). Search Person: Looks up Pipedrive contact by email from the Stripe payload. IF: Checks whether the person exists. If exists → skip to deal creation. If node - Check if Event id is not the same If same - Skip the deal creation If different - Create a deal linked to that person with the payment amount If not → create new Person. Create Person: Adds new Pipedrive contact, populates custom fields (amount, payment method, status, source). Create Deal: Creates a deal linked to that person with the payment amount. Description **This workflow connects Stripe to Pipedrive. Whenever a new payment (or checkout success) occurs in Stripe, this automation will: Fetch the full Stripe event data Find or create a customer (“Person”) in Pipedrive Create a “Deal” record corresponding to that payment Log custom fields like amount, source, payment method, status It’s ideal for SaaS Subscription businesses Agencies, or Teams who want payments mirrored inside their CRM without manual work. Modification Notes / Extensions You can extend this workflow by: Adding Slack or Gmail notifications after deal creation. Logging every event in Google Sheets or Notion for audit. Enriching the customer using OpenAI / CRM data. Handling refunds, subscription cancellations, etc. An n8n automation workflow template by Krishna Sharma.

By Abhiman Sundararajan

Quick Summary This workflow connects Telegram, Google Gemini AI, and Notion to make task creation effortless. Whenever you send a message to your Telegram bot, Gemini AI reads your message, understands what task you meant, and automatically creates it in your Notion database - complete with the task name and due date. If you approve, the task is added to Notion and you’ll get a confirmation in Telegram. If you decline, it simply replies that ❌ no task was created. Perfect for anyone who wants to capture ideas or to-dos directly from Telegram without opening Notion every time. Detailed Use Cases Quick task capture from Telegram Send a message like “Buy milk 25 May” to your Telegram bot. The AI extracts the task name and date, asks you to approve, and creates a Notion task once approved. Turn reminders into Notion tasks Message: “Pay rent next Monday” → Approve → Task added to Notion with the correct due date. Perfect for quickly saving reminders while on the go. Tip: For best results, include clear dates in your messages like 25 May or May 25, 2025 so the AI can extract them accurately. Prerequisites / Requirements Before using this workflow, make sure you have the following ready: Telegram Bot Setup Go to @BotFather on Telegram. Create a new bot using the /newbot command. Copy the Bot Token — you’ll need it to connect in the Telegram Trigger and Telegram nodes in n8n. Google Gemini API Key Sign up for a free Google AI Studio account. Create an API key and connect it in your n8n credentials under Google Gemini. This workflow uses the models/gemini-2.5-flash-lite model, which works perfectly on the free tier. Notion Database Setup Create a Notion database for storing tasks. It must have: A Title property — set this as the Task Name (type: Title / text). A Date property — set this as the Due Date (type: Date). Copy your Notion database ID and connect your Notion API credentials in n8n. Optional Security Note In the Telegram Trigger node, restrict the chatId to your own Telegram user ID if this workflow is for personal use. Customization Guide You can easily extend this workflow to capture more details from your Telegram messages using the AI Extract node. Here are a few simple ways to customize it: Add more extracted fields In the AI Extract: TaskName & TaskDue node, open the Attributes section. Add new fields like: Priority → text (e.g., High, Medium, Low) Duration → number or text (e.g., 30 mins, 1 hour) Notes → text (optional extra info) The Gemini model will automatically try to extract these from your message. Example messages you can send “Finish report by Friday — high priority, 2 hours.” “Workout tomorrow evening — medium priority.” Map extra fields to Notion In the Notion: Create Task (Page) node, scroll to the Properties section. Add matching Notion properties for each new field (e.g., Priority, Duration). Map the AI outputs (like output.Priority) to their respective fields. Send confirmation with extra data In the Send and Wait for Response (Approve/Decline) node, include the new extracted details in the Telegram message before approval. Example confirmation message: Task: {{ $json.output.TaskName }} Due: {{ $json.output.TaskDue }} Priority: {{ $json.output.Priority }} Duration: {{ $json.output.Duration }} By doing this, you can build a smarter task capture system that includes priority, time estimation, and other useful details, all directly from your Telegram chat. An n8n automation workflow template by Abhiman Sundararajan.

By Ahmed Sherif

AI-Powered Lead Scraping Automation using APIFY Scraper and Gemini Filtering to Google Sheets This is a fully automated, end-to-end pipeline designed to solve the challenge of inconsistent and low-quality lead data from large-scale scraping operations. The system programmatically fetches raw lead information from sources like Apollo or via Apify, processes it through an intelligent validation layer, and delivers a clean, deduplicated, and ready-to-use dataset directly into Google Sheets. By integrating Google Gemini for data cleansing, it moves beyond simple presence checks to enforce data hygiene and standardization, ensuring that sales teams only engage with properly formatted and complete leads. This automation eliminates hours of manual data cleaning, accelerates the speed from lead acquisition to outreach, and significantly improves the integrity of the sales pipeline. Features Batch Processing**: Systematically processes up to 1000 leads per batch and automatically loops through the entire dataset. This ensures stable, memory-efficient operation even with tens of thousands of scraped contacts. AI Validation**: Google Gemini acts as a data quality gatekeeper. It validates the presence and plausible format of critical fields (e.g., First Name, Company Name) and cleanses data by correcting common formatting issues. Smart Deduplication**: Before appending a new lead, the system cross-references its email address against the entire Google Sheet to prevent duplicate entries, ensuring a single source of truth. Auto Lead IDs**: Generates a unique, sequential ID for every new lead in the format AP-DDMMYY-xxxx. This provides a consistent reference key for tracking and CRM integration. Data Quality Reports**: Delivers real-time operational visibility by sending a concise summary to a Telegram channel after each batch, detailing success, warning, and error counts. Rate Limiting**: Incorporates a 30-second delay between batches to respect Google Sheets API limits, preventing throttling and ensuring reliable, uninterrupted execution. How It Works The workflow is initiated by an external trigger, such as a webhook, carrying the raw scraped data payload. It authenticates and fetches the complete list of leads from the Apify or Apollo API endpoint. The full list is automatically partitioned into manageable batches of 1000 leads for efficient processing. Each lead is individually passed to the Gemini AI Agent, which validates that required fields like Name, Email, and Company are present and correctly formatted. Validated leads are assigned a unique Lead ID, and all data fields are standardized for consistency. The system performs a lookup in the target Google Sheet to confirm the lead's email does not already exist. Clean, unique leads are appended as a new row to the designated spreadsheet. A completion notice is sent via the Telegram Bot, summarizing the batch results with clear statistics. Requirements Apify/Apollo API access credentials. Google Cloud project with OAuth2 credentials for Google Sheets API access. A configured Telegram Bot with its API Token and a target Chat ID. A Google Gemini API Key for data validation and cleansing. This system is ideal for sales and marketing operations teams managing high-volume lead generation campaigns, providing automated data quality assurance and accelerating pipeline development. An n8n automation workflow template by Ahmed Sherif.

By Shelly-Ann Davy

Automate Bug Reports: GitHub Issues → AI Analysis → Jira Tickets with Slack & Discord Alerts Automatically convert GitHub issues into analyzed Jira tickets with AI-powered severity detection, developer assignment, and instant team alerts. Overview This workflow captures GitHub issues in real-time, analyzes them with GPT-4o for severity and categorization, creates enriched Jira tickets, assigns the right developers, and notifies your team across Slack and Discord—all automatically. Features AI-Powered Triage**: GPT-4o analyzes bug severity, category, root cause, and generates reproduction steps Smart Assignment**: Automatically assigns developers based on mentioned files and issue context Two-Way Sync**: Posts Jira ticket links back to GitHub issues Multi-Channel Alerts**: Rich notifications in Slack and Discord with action buttons Time Savings**: Eliminates 15-30 minutes of manual triage per bug Customizable Routing**: Easy developer mapping and priority rules What Gets Created Jira Ticket: Original GitHub issue details with reporter info AI severity assessment and categorization Reproduction steps and root cause analysis Estimated completion time Automatic labeling and priority assignment GitHub Comment: Jira ticket link AI analysis summary Assigned developer and estimated time Team Notifications: Severity badges and quick-access buttons Developer assignment and root cause summary Color-coded priority indicators Use Cases Development teams managing 10+ bugs per week Open source projects handling community reports DevOps teams tracking infrastructure issues QA teams coordinating with developers Product teams monitoring user-reported bugs Setup Requirements Required: GitHub repository with admin access Jira Software workspace OpenAI API key (GPT-4o access) Slack workspace OR Discord server Customization Needed: Update developer email mappings in "Parse GPT Response & Map Data" node Replace YOUR_JIRA_PROJECT_KEY with your project key Update Slack channel name (default: dev-alerts) Replace YOUR_DISCORD_WEBHOOK_URL with your webhook Change your-company.atlassian.net to your Jira URL Setup Time: 15-20 minutes Configuration Steps Import workflow JSON into n8n Add credentials: GitHub OAuth2, Jira API, OpenAI API, Slack, Discord Configure GitHub webhook in repository settings Customize developer mappings and project settings Test with sample GitHub issue Activate workflow Expected Results 90% faster bug triage (20 min → 2 min per issue) 100% consistency in bug analysis Zero missed notifications Better developer allocation Improved bug documentation Tags GitHub, Jira, AI, GPT-4, Bug Tracking, DevOps, Automation, Slack, Discord, Issue Management, Development, Project Management, OpenAI, Webhook, Team Collaboration. An n8n automation workflow template by Shelly-Ann Davy.

By Rahul Joshi

Description This workflow automates the tracking of deal stage updates in HighLevel CRM and syncs them with ClickUp for task management. It filters opportunities based on the most recent update date, creates actionable tasks in ClickUp for recent deals, and sends Slack alerts when older deal updates are detected. This ensures that your sales and operations teams stay aligned, reducing manual tracking and improving visibility of pipeline activity. What This Template Does (Step-by-Step) 📋 Fetch All Deals from HighLevel CRM Pulls a complete list of opportunities with contact details and deal stages. ⏱ Filter Recent Deal Updates Checks if a deal was updated on/after a specific date (e.g., Sept 30, 2025). 🔀 Route Deals via If Node ✅ Recent Updates → Proceed to get contact details & create a task in ClickUp. ❌ Older Updates → Trigger a Slack notification for awareness. 👤 Get Contact Information Retrieves full contact details (name, location ID, etc.) from HighLevel for better context in tasks. 🗂 Create ClickUp Task Generates a new ClickUp task containing deal and contact information, ensuring your team has actionable follow-up tasks. 💬 Send Slack Notification Notifies a specified Slack user when a deal update is older than the defined threshold, highlighting deals that may need attention. Prerequisites HighLevel CRM account & API credentials ClickUp account & API credentials Slack workspace & API credentials n8n instance (cloud or self-hosted) Step-by-Step Setup Connect HighLevel CRM → Fetch all opportunities. Apply Date Filter (If Node) → Split deals into recent vs. old updates. Recent Deals → Fetch contact details → Create task in ClickUp. Old Deals → Send Slack notification to assigned user. Customization Ideas 🎯 Adjust the date threshold for “recent updates.” 📢 Add Slack/Teams alerts for new deals as well. 📚 Sync ClickUp tasks into Notion or Airtable for reporting. 💡 Enrich ClickUp tasks with deal value, stage, or assigned salesperson. Key Benefits ✅ Keeps deal updates transparent and organized ✅ Ensures no recent deal activity is missed ✅ Automates ClickUp task creation for sales follow-ups ✅ Sends real-time Slack alerts for old updates ✅ 100% automated, customizable workflow Perfect For 👥 Sales teams managing multiple deals daily 🏢 Companies using HighLevel CRM & ClickUp 🎯 Teams wanting instant visibility into pipeline changes 📊 Managers tracking deal activity timelines. An n8n automation workflow template by Rahul Joshi.

By Rahul Joshi

Description Never miss a qualified LinkedIn Sales Navigator message again. This automation monitors your Gmail for LinkedIn notifications, cross-references senders with your lead database in Google Sheets, and instantly sends you categorized email alerts. Stay on top of high-value conversations in real time. 🚀 What This Template Does Monitors Gmail inbox for LinkedIn Sales Navigator notifications. 📧 Extracts sender names from LinkedIn email headers. 🔍 Fetches your lead database from Google Sheets (organized by industry or domain). 📊 Cleans and standardizes lead names and categories. 🧹 Merges LinkedIn senders with your lead database. 🔀 Matches senders to known leads and retrieves their categories. 🎯 Sends email alerts when a matched lead contacts you, showing name + category. 📬 Key Benefits Respond faster with instant notifications when qualified leads send messages. ⚡ Prioritize outreach with industry-based categorization. ✅ Reduce manual inbox checking—automated 24/7 monitoring. ⏱️ Ensure no missed opportunities from valuable prospects. 💡 Scales effortlessly across industries and large lead lists. 📈 Features Gmail fetch node with LinkedIn notification filter. 📥 Sender name extraction and cleanup for accuracy. ✂️ Google Sheets integration for lead database. 🔗 Name cleaning to remove dropdown artifacts like "Select...". 🧼 Data merge node combining LinkedIn senders and sheet leads. 🔄 Matching logic with case-insensitive comparison. 🧠 Gmail node for sending categorized alert emails. ✉️ Requirements n8n instance (cloud or self-hosted). 🧰 Gmail account with LinkedIn notifications enabled. 📧 Google Sheet named (e.g., “Edtech”) with columns Name and Category, shared with n8n Google account. 📑 Gmail account credentials configured in n8n. 🔑 Target Audience Sales reps working in LinkedIn Sales Navigator. 📈 Agencies tracking multiple industries and lead lists. 🤝 Founders and B2B startups who rely heavily on LinkedIn messaging. 🚀 Lead management teams needing structured alerts for fast responses. 🧭 Step-by-Step Setup Instructions (Concise) Connect your Gmail account to n8n. 🔐 Update the Google Sheets node with your lead database (Document ID + sheet name). 📋 Test workflow with the manual trigger to fetch sample notifications. ▶️ Replace manual trigger with a Gmail trigger for real-time alerts. ⏱️ Update the recipient email in the alert node to your own address. 📧 Enable the workflow and let it run continuously. 🚦 Security Best Practices Keep your lead database shared only with the n8n Google account. 🔒 Use Gmail API credentials stored securely in n8n, not hardcoded. 🛡️ Validate sender names before merging with leads to prevent mismatches. ✅ Regularly update your Google Sheet to keep categories accurate. 🗂️. An n8n automation workflow template by Rahul Joshi.

By Intuz

This n8n template from Intuz provides a complete solution to automate your entire invoicing process. It intelligently syncs confirmed sales orders from your Airtable base to QuickBooks, automatically creating new customers if they don't exist before generating a perfectly matched invoice. It then logs all invoice details back into Airtable, creating a flawless, end-to-end financial workflow. Use Cases 1. Accounting & Finance Teams: Automatically generate QuickBooks invoices from new orders confirmed in Airtable. Keep all invoices and customer details synced across systems in real time. 2. Sales & Operations Teams: Track order status and billing progress directly from Airtable without switching platforms. Ensure every confirmed sale automatically triggers an invoice in QuickBooks. 3. Business Owners / Admins: Eliminate double-entry between Airtable and QuickBooks. Maintain accurate, audit-ready financial records with minimal effort. How it works 1. Trigger from Airtable: The workflow starts instantly when a sales order is ready to be invoiced in your Airtable base (triggered via a webhook). 2. Check for Customer in QuickBooks: It searches your QuickBooks account to see if the customer from the sales order already exists. 3. Create New Customer (If Needed): If the customer is not found, it automatically creates a new customer record in QuickBooks using the details from your Airtable Customers table. 4. Create QuickBooks Invoice: Using the correct customer record (either existing or newly created), it gathers all order line items from Airtable and generates a detailed invoice in QuickBooks. 5. Log Invoice Back to Airtable: After the invoice is successfully created, the workflow updates your Airtable base by adding a new record to your Invoices & Payments table and updating the original Confirmed Orders record with the new QuickBooks Invoice ID, marking it as synced. Key Requirements to Use This Template 1. n8n Instance: An active n8n account (Cloud or self-hosted). 2. Airtable Base: An Airtable base on a "Pro" plan or higher with tables for Confirmed Orders, Customers, Order Lines, Product & Service, and Invoices & Payments. Field names must match those in the setup guide. 3. QuickBooks Online Account: An active QuickBooks Online account with API access. Step-by-Step Setup Instructions Step 1: Import and Configure the n8n Workflow Import Workflow:** In n8n, import the Client-Quickbook-Invoices-via-AirTable.json file. Get Webhook URL:** Click on the first node, "Webhook". Copy the "Test URL". Keep this n8n tab open. Configure Airtable Nodes:** There are six Airtable nodes. For each one, connect your Airtable credentials and select the correct Base and Table. Configure QuickBooks Nodes:** There are four QuickBooks-related nodes. For each one, connect your QuickBooks Online credentials. CRITICAL:** Click on the "Create Invoice URL" (HTTP Request) node. You must edit the URL and replace the placeholder number (9341455145770046) with your own QuickBooks Company ID. (Find this in your QuickBooks account settings under "Billing & Subscription"). Save and Activate**: Click "Save", then toggle the workflow to "Active". After activating, copy the new "Production URL" from the Webhook node. Customization Guide You can adapt this template for various workflows by tweaking a few nodes: Use a different Airtable Base:** Update the Base ID and Table ID in all Airtable nodes (Get Orders Records, Get Customer Details, Get Products, etc.). Switch from Sandbox to Live QuickBooks:** Replace the Sandbox company ID and endpoint in the “Create Invoice URL” node with your production QuickBooks company ID. Add more invoice details:** Edit the Code and Parse in HTTP nodes to include additional fields (like Tax, Shipping, or Notes). Support multiple currencies:** Add a “Currency” field mapping in both Airtable and QuickBooks nodes. Connect with us Website: https://www.intuz.com/n8n-workflow-automation-templates Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Workflow Automation Click here- Get Started. An n8n automation workflow template by Intuz.

By Beex

Summary Re-engage your customers with your Shopify store through a personalized contact sequence. How it works The workflow is triggered by a Scheduler Trigger and immediately reviews your Shopify customers by retrieving their last_order_id. For customers with a non-null last_order_id, the workflow proceeds to fetch detailed order information from Shopify, including the order closing date and the products involved. Based on the order date, the workflow calculates the number of days the customer has been inactive. If this period exceeds a defined threshold (e.g., 30 days), the corresponding records are sent via API to Beex, where each customer enters a multi-step contact sequence that may include WhatsApp, email, and other channels. Example: "Customers can then expect to receive a limited-time discount coupon invitation as part of the reactivation strategy". How to set up Before importing the template, make sure to install the Beex node using the following package name: n8n-nodes-beex Configure your Shopify credentials according to your store’s settings. You will need to provide: Your store subdomain Your Access Token Your App Secret Key For Beex users with platform access (if you need a trial, please contact frank@beexcc.com), go to the main dashboard and navigate to: Platform Settings → API KEY & Callback There, you can retrieve your API key and insert it into the corresponding Beex node within n8n. Requirements You need accounts for: Beex (omnichannel contact platform) Shopify (E-commerce platform builder) You need in Beex (Node): Portfolio ID Sequence ID The above determines the sequence of contact that customers are subjected to. How to customize You can also change the threshold to define from what extent you consider that a client is inactive. You can configure a particular sequence in Beex to contact your inactive customers to insert them into the node. An n8n automation workflow template by Beex.

By Hassan

Overview This sophisticated n8n workflow transforms raw LinkedIn leads into personalized, high-converting connection requests using GPT-4O AI and PhantomBuster automation. The system processes LinkedIn profile data, generates authentic icebreakers, and automatically sends connection requests twice daily, creating a hands-off lead generation machine that maintains human authenticity while scaling outreach efforts. Key Benefits 🤖 AI-Powered Personalization Generate unique, human-like icebreakers for every LinkedIn connection request using GPT-4O, ensuring each outreach feels personal and authentic rather than automated. ⚡ Automated Workflow Execution Run your entire lead generation pipeline automatically twice daily (10 AM and 5 PM) USA Time with zero manual intervention required. 📊 Smart Data Management Seamlessly manage leads across multiple Google Sheets with automatic data cleanup, duplicate prevention, and organized lead tracking. 🎯 PhantomBuster Integration Leverage PhantomBuster's powerful LinkedIn automation to send connection requests at scale while maintaining platform compliance. 📈 Scalable Processing Process leads in optimized batches of 10 to maintain quality while scaling your outreach efforts effectively and remain within LinkedIn’s weekly connection request limits. 📧 Real-Time Monitoring Receive email notifications whenever connection requests are sent, keeping you informed of your campaign progress. 🔄 Continuous Operation Self-maintaining system that processes new leads, cleans up completed tasks, and prepares for the next cycle automatically. 💼 Professional Template System Uses proven icebreaker templates that follow the format: "Hey [name], loved seeing [personalized detail]. I'm also into [relevant connection], thought I'd connect." How It Works Phase 1: Lead Acquisition & Processing The workflow begins with scheduled triggers that activate twice daily. Upon activation, the system first cleans up previously processed leads from the source Google Sheet to prevent duplicates. It then retrieves fresh LinkedIn profile data including names, titles, company information, locations, and profile URLs. Phase 2: AI-Powered Personalization Engine Retrieved leads are processed in batches of 10 through a sophisticated GPT-4O integration. The AI analyzes each LinkedIn profile and generates personalized icebreakers following a proven template structure. The system is specifically programmed to paraphrase LinkedIn information rather than copy it directly, ensuring messages feel human-written rather than automated. Phase 3: Data Storage & Campaign Launch Processed leads with their AI-generated icebreakers are stored in a dedicated Google Sheet for tracking and analysis. The system then aggregates all processed data and triggers a PhantomBuster agent that executes the actual LinkedIn connection requests using the personalized messages. Phase 4: Cleanup & Notification After successful campaign launch, the system removes processed leads from the source sheet, sends email confirmation notifications, and prepares for the next scheduled execution cycle. Required Setup & Dependencies Core Integrations: Google Sheets API access with OAuth2 authentication OpenAI API key for GPT-4O access PhantomBuster account with API key and configured LinkedIn agent Gmail account for notifications Google Sheets Structure: Source Sheet: Contains raw LinkedIn data (firstName, lastName, title, companyName, location, etc.) Destination Sheet: Stores processed leads with icebreakers and tracking information PhantomBuster Configuration: LinkedIn connection request automation agent Proper agent ID configuration in the HTTP request node Valid API key with sufficient credits Business Use Cases Sales Development Representatives (SDRs) Automate personalized outreach to potential clients while maintaining the human touch that drives connection acceptance rates. Recruitment Agencies Scale candidate outreach with personalized messages that reference specific experience and skills from LinkedIn profiles. Business Development Generate partnerships and collaboration opportunities through targeted, personalized connection requests to industry leaders. Coaches & Consultants Build professional networks by connecting with potential clients using AI-generated icebreakers that reference their specific challenges and opportunities. Marketing Agencies Develop client relationships through personalized outreach that demonstrates understanding of their business and industry. Revenue Potential Direct Lead Generation: Process 20 leads daily (10 per execution × 2 runs) Average 25% connection acceptance rate = 5 new connections daily Convert 10% of connections to qualified leads = 15 qualified leads monthly Close 20% of qualified leads at $2,000 average deal size = $6,000 monthly revenue Agency Services: Offer as white-label service to clients at $500-1,500 monthly recurring revenue per client Manage 10-20 client accounts for $5,000-30,000 monthly recurring revenue SaaS Model: Package as LinkedIn automation SaaS with tiered pricing ($49-299/month) Target 100+ subscribers for $5,000-30,000 monthly recurring revenue Difficulty Level & Build Time Difficulty: Intermediate to Advanced Estimated Build Time: 4-6 hours Technical Requirements: Understanding of API integrations, Google Sheets operations, and basic workflow logic Setup Complexity: API key management and authentication setup Google Sheets structure creation and permission configuration PhantomBuster agent setup and testing AI prompt engineering for optimal icebreaker generation Detailed Setup Steps 1. Google Sheets Preparation Create two Google Sheets: Source Sheet:** Structure with columns for firstName, lastName, location, title, companyName, titleDescription, linkedInProfileUrl Destination Sheet:** Include all source columns plus id, photo_url, icebreaker, email_status fields 2. API Credentials Configuration OpenAI:** Generate API key with GPT-4O access Google Sheets:** Set up OAuth2 credentials in n8n PhantomBuster:** Create account, set up LinkedIn connection agent, obtain API key Gmail:** Configure OAuth2 for notification emails 3. PhantomBuster Agent Setup Create LinkedIn connection request automation agent Configure with proper message templates and targeting parameters Test agent functionality and note the agent ID for n8n configuration 4. Workflow Import & Configuration Import the provided n8n workflow JSON Update all credential references to match your configured accounts Modify Google Sheet IDs in all relevant nodes Update PhantomBuster agent ID and API key in HTTP request node 5. AI Prompt Optimization Review and customize the GPT-4O prompt for your specific use case Test icebreaker generation with sample data Adjust tone and style parameters as needed 6. Schedule Configuration Set appropriate trigger times based on your target timezone Consider LinkedIn usage patterns for optimal engagement 7. Testing & Validation Run workflow manually with test data Verify Google Sheets integration and data flow Test PhantomBuster integration with small batch Confirm email notifications are working Advanced Customization Options Enhanced AI Personalization Integrate additional data sources (company websites, news articles) for richer context Add industry-specific icebreaker templates Implement A/B testing for message variations CRM Integration Connect to Salesforce, HubSpot, or Pipedrive for seamless lead management Add lead scoring based on profile analysis Implement automated follow-up sequences Analytics & Reporting Add detailed tracking and analytics dashboard Implement conversion tracking from connection to closed deal Generate automated performance reports Multi-Platform Expansion Extend to Twitter/X and Instagram outreach Add email finder integration for multi-channel campaigns Implement unified contact management across platforms Advanced Filtering Add AI-powered lead qualification before outreach Implement company size, industry, and role-based filtering Add sentiment analysis for optimal timing This workflow represents a complete, production-ready solution that can immediately start generating leads and revenue while providing a foundation for advanced customization and scaling. An n8n automation workflow template by Hassan.

By Gerald Denor

Transform YouTube Transcripts to Content Assets with AI, Youtube-transcript.io and Google Sheets For content creators, marketers, and video strategists who want to transform YouTube competitors' video transcripts into production-ready content assets using AI-powered automation. Overview This template demonstrates two approaches to YouTube transcript extraction and AI content generation: automated Google Sheets monitoring for batch processing, and direct webhook API calls for on-demand extraction. The workflow includes intelligent parsing, metadata extraction, and AI-powered content transformation. Key Features Dual Workflow Architecture Google Sheets integration for automated monitoring and batch processing Webhook endpoint for real-time API access and instant responses Both paths share core extraction logic while serving different use cases Smart YouTube Parsing Extracts video IDs from multiple URL formats (youtube.com, youtu.be, embed) Regex-based parsing handles edge cases reliably Graceful error handling for invalid URLs Rich Metadata Extraction Video title, channel name, and publish date Duration and category information Transcript text with full timestamp data Fallback handling for videos without transcripts AI Content Generation Transforms raw transcripts into structured content assets Generates Veo3-optimized scripts (8-second scene format) Creates SEO-optimized titles, thumbnail concepts, tags, descriptions Includes virality optimization suggestions (hooks, CTAs) Uses OpenRouter for flexible LLM selection Structured Output Parsing Custom code nodes parse AI responses into consistent formats Organized by content type (Script, Titles, Thumbnails, Tags, etc.) Ready for direct insertion into Google Sheets or API responses Technical Implementation Nodes Used Google Sheets (Trigger & Operations) Webhook (Trigger & Response) HTTP Request (YouTube Transcript API) Code (JavaScript for parsing) LangChain LLM Chain (Content generation) OpenRouter Chat Model External Dependencies YouTube Transcript API (youtube-transcript.io or similar) Google Sheets API credentials OpenRouter API access Use Cases Content Repurposing:** Transform successful videos into new content formats Competitive Analysis:** Batch analyze competitor video strategies Research & Documentation:** Build searchable transcript databases Accessibility:** Generate captions and text alternatives SEO Analysis:** Extract and analyze video content at scale Content Strategy:** Develop data-driven video concepts Setup Requirements YouTube Transcript API credentials Google Sheets with specified column structure (for automated workflow) OpenRouter API key for AI content generation n8n instance (cloud or self-hosted) Customization Options The workflow is designed for easy extension: Swap AI providers by changing the LangChain model node Modify prompt engineering in the Chain LLM nodes Add additional parsing logic in Code nodes Connect to databases, CMS, or other storage solutions Integrate text analysis, summarization, or translation steps Add notification systems for workflow completion Need Help? LinkedIn:** Gerald Akhidenor Work with me:** dominixai.com My websites:** jobmonkey.dev and mediacraftai.com Email:** denorgerald@gmail.com. An n8n automation workflow template by Gerald Denor.

By Didac Fernandez

🤖 Autonomous Email Assistant - AI-Powered Inbox Management > Transform Your Email Workflow with Intelligent Automation This advanced n8n workflow creates a fully autonomous email assistant that processes incoming emails through AI-powered classification, generates contextually-aware responses in your personal brand voice, and automatically organizes your inbox. Perfect for: Professionals managing high email volumes who want to maintain response quality while saving hours each week. 🎯 What This Workflow Does The Autonomous Email Assistant monitors your Outlook inbox and intelligently processes every incoming email through a sophisticated multi-stage pipeline: 🏷️ Smart Classification - Automatically categorizes emails into 7 distinct types (Commercial/Spam, Internal, Meeting, Newsletter, Notifications, Urgent, Other) ✍️ AI Response Generation - Creates draft responses tailored to the email type, maintaining your unique communication style 📅 Meeting Automation - Checks your calendar availability and handles meeting requests automatically ⚡ Priority Handling - Sends Slack notifications for urgent emails requiring immediate attention 📂 Inbox Organization - Files processed emails into categorized folders with AI tagging 📊 Comprehensive Logging - Records all processed emails and responses in Excel for audit trails ✨ Key Features 🔍 Dual Classification System Primary LLM classifier for fast categorization Secondary text classifier for validation 7 predefined categories with smart routing logic 🎨 Brand Voice Integration Maintains consistent communication style across all responses Customizable writing patterns and key phrases Professional tone with configurable formality levels 📆 Intelligent Meeting Handler Calendar integration with availability checking Automatic event creation for confirmed meetings Suggests alternative times when unavailable Maintains 15-minute buffers between meetings Respects working hours (8:30 AM - 5:00 PM) 👤 Human-in-the-Loop for Critical Emails Slack notifications for urgent messages Approval workflow with feedback incorporation Draft responses for review before sending 📥 Complete Inbox Management Auto-marking as read AI category tagging for tracking Organized folder archiving by email type Excel logging for analytics and compliance 🛠️ Workflow Requirements 🔐 Required Credentials Microsoft Outlook OAuth2** - Email access, calendar permissions Microsoft Excel 365** - For logging workbook OpenRouter API** - GPT-5-mini model recommended Slack OAuth2** - Optional, for urgent notifications 💻 Technical Stack | Component | Technology | |-----------|-----------| | AI Model | OpenRouter GPT-5-mini | | Email Provider | Microsoft Outlook | | Data Storage | Microsoft Excel 365 | | Notifications | Slack | | Polling Interval | Every minute (configurable) | ⚙️ How It Works Stage 1️⃣: Email Ingestion Microsoft Outlook Trigger monitors inbox → Information Extractor pulls sender details Stage 2️⃣: Classification Dual AI classifiers determine email category → Routes to appropriate handler Stage 3️⃣: Response Generation General emails** → emailReplier Meeting requests** → AI Agent with calendar tools Urgent emails** → urgentReplier + Slack notification Others** → Context-aware handler Stage 4️⃣: Brand Voice Application All responses pass through brand voice nodes for style consistency Stage 5️⃣: Organization ✅ Mark as read 🏷️ Apply AI category tag 📁 Archive to appropriate folder 📝 Log to Excel 🎛️ Customization Options 📋 Adjust Classification Categories Modify the Virtual Postman categories to match your specific needs. Add industry-specific classifications or merge existing ones. ✏️ Personalize Brand Voice The embedded brand voice prompts can be completely customized: Update key phrases and sign-offs Adjust sentence length preferences Modify formality and tone Add company-specific terminology ⚙️ Configure Response Behaviors Change meeting scheduling preferences Update working hours Modify urgent email criteria Adjust buffer times between meetings 🔔 Notification Preferences Switch Slack to email notifications Add multiple notification channels Customize urgency thresholds 💼 Use Cases | Role | Benefits | |------|----------| | 🎯 Busy Executives | Handle routine correspondence while maintaining personal touch | | 🎧 Customer Support | First-line response generation with consistent brand voice | | 💰 Sales Teams | Automated meeting scheduling and follow-up management | | 📊 Project Managers | Internal communication routing and priority handling | | 💡 Consultants | Client communication management across multiple projects | 🚀 Setup Guide Import Workflow - Import the JSON into your n8n instance Configure Credentials - Add all four required OAuth2 connections Create Excel Workbook - Set up "Email Automator" workbook with specified columns Create Outlook Folders - Add the 7 category folders to your Outlook Customize Brand Voice - Update the brand voice prompts with your writing style Test Classification - Send test emails to verify category routing Activate Workflow - Enable the workflow to start processing ⚠️ Important Notes ⚡ All urgent emails require human approval before sending 📝 Most responses are saved as drafts for review 📊 Comprehensive Excel logging enables quality assurance 🏷️ AI tagging allows easy identification of automated processing 📅 Calendar integration respects existing commitments 🔒 Data Privacy & Security This workflow processes emails locally within your n8n instance. Email content is sent to OpenRouter for AI processing. Review OpenRouter's data policies and ensure compliance with your organization's data handling requirements. 📜 Version History v1.0 - Initial Release 7-category classification system Brand voice integration Meeting automation Excel logging Slack notifications 💬 Support & Community For questions, customization help, or to share improvements, visit the n8n community forum. This workflow is designed to be highly customizable - adapt it to your specific needs! Created by: Didac Fernandez Girona | AutoSolutions.ai - AI Consulting Services Tags: email automation AI assistant outlook calendar management brand voice inbox organization meeting scheduler. An n8n automation workflow template by Didac Fernandez.

By Jack Mason

Generate and send personalized lead emails from Google Sheets via OpenAI to Gmail with Slack alerts Description This template triggers when a new row appears in Google Sheets (from any intake form that writes to the sheet). It validates key fields, performs light deduplication by email or phone, and sends the data to OpenAI to generate a concise, brand-safe first-touch email. At the same time, the model classifies each lead as High, Medium, or Low based on your criteria for budget, services, and timeline. The email is sent immediately from your connected Gmail (or SMTP) account. The sales team is notified in Slack with the lead’s name, contact details, services of interest, budget, and a deep link to the exact Google Sheets row. The Google Sheet is then updated with send status, lead type, and a timestamp for easy tracking. Setup: Connect Google Sheets (read/write), Gmail/SMTP, Slack (webhook or app), and an OpenAI API key. Provide brief classifier rules and a short tone guide with one clear CTA (reply or booking link). Include a one-line opt-out in the email body to stay compliant. Expected headers are: Timestamp, Name, Email Address, Phone Number, Services Interested In, Budget Range, Preferred Contact Time, Project Timeline, and Additional Comments. The trigger checks the sheet every minute and processes after-hours submissions right away. You can extend the flow with calendar booking links, territory routing, or rate limits as needed. An n8n automation workflow template by Jack Mason.

By Shelly-Ann Davy

Extract and Organize Receipt Data with WhatsApp, GPT-4V and Google Sheets 📸 Turn Photos of Receipts into a Smart, Automatic Expense Log — No Typing, No Stress You’re not bad at budgeting. You’re not disorganized. You’re just drowning in paper. A receipt from the school fundraiser. The oil change you forgot to log. That grocery run after soccer practice. The birthday gift you bought last-minute online. They start in your wallet. Then your purse. Then the car seat. Then… gone. And when tax time comes? You’re left guessing. Stress rises. Confidence drops. What if you could just… snap, send, and forget? Introducing Snap & Save — a gentle, powerful automation that turns your phone’s camera into a smart expense tracker, using AI to read receipts, categorize spending, and build a clean, living log — all in the background. No spreadsheets. No data entry. No more “I know I had that receipt!” Just peace of mind. 💡 How It Works: Effortless, Step by Step This workflow runs quietly in the background — like a personal assistant who actually listens. 1. 📸 Snap a Photo of Your Receipt At the store, in the car, at the kitchen table — just take a clear photo of any receipt. It doesn’t matter if it’s crumpled, handwritten, or half-torn. As long as the total is visible, AI can read it. 2. 📲 Send It to WhatsApp Forward the photo to your private WhatsApp number or group (e.g., “My Receipts”). No new apps. No extra steps. Just the tool you already use every day. 3. 🤖 AI “Sees” the Receipt (Using vlmRun) This is the magic moment. The Vision Language Model (VLM) — the same AI tech behind GPT-4V — looks at the image and understands it like a human would. It extracts: 🏪 Vendor (e.g., Walmart, Shell, Etsy) 📅 Date (even if handwritten!) 💵 Total Amount and currency 🧾 Item type (if visible) No OCR errors. No manual typing. Just smart, accurate reading. 4. 🧹 Auto-Categorize with Simple Logic The workflow uses a Function node to sort your spending: “Walmart” → Groceries “Shell” → Fuel “Amazon” → Online “Art Supply Co” → Kids “Therapy” → Self-Care You can customize these rules in plain English — no coding needed. Want to track “Date Nights” or “Gifts”? Just add it. 5. 📊 Save to Google Sheets — Your Living Expense Log Every receipt becomes a row in a clean, organized spreadsheet: | Date | Vendor | Amount | Category | Image Link | |------|--------|--------|----------|------------| | 2025-04-05 | Walmart | $87.42 | Groceries | [View] | You can: Add monthly totals Create charts Share with your partner or accountant Export for taxes And because it’s in Google Sheets, it works on any device — no new software to learn. 🎯 Who Is This For? 👩‍👧 Homemakers & Parents You’re managing a household budget with receipts flying everywhere. This helps you: Track where the money goes Stay within grocery limits Show your partner you’ve got this Feel in control — not overwhelmed 💼 Solopreneurs & Digital Business Owners You’re building a business — not an accounting firm. This helps you: Separate personal vs. business expenses Build clean records for taxes Reimburse yourself fairly Look professional during audits 🧑‍🤝‍🧑 Couples & Shared Households No more “Did you save that receipt?” fights. Both partners can send to the same WhatsApp group — and everything gets logged automatically. 📅 Anyone Prepping for Tax Season Start in January. By April, you’ll have a complete, auditable expense history — no scrambling, no stress. 🔧 Tech That Feels Human We used real-world tools — not sci-fi promises. | Node | What It Does | Why It’s Perfect | |------|-------------|------------------| | whatsAble | Gets your receipt photo from WhatsApp | Mobile-first, no app download | | vlmRun | AI reads the image and extracts data | Cutting-edge, accurate, magical | | function | Auto-categorizes based on vendor | Simple logic, easy to customize | | googleSheets | Stores everything in a familiar format | Exportable, shareable, reliable | And yes — it works even if you’re not techy. Every step includes colorful sticky notes that explain: What the node does Why it matters How to customize it You don’t need to understand AI to use it. You just need to snap and send. It’s like having a mini financial advisor — built by you, for you. 💬 Real Talk: This Isn’t Just About Receipts This is about: 🕊️ Reducing mental load 📊 Feeling financially seen 🛠️ Using tech that serves you — not the other way around 💪 Building systems that make you feel like you’re winning You don’t need perfection. You need a system that’s simple, kind, and actually works. And that’s exactly what Snap & Save is. ❓ FAQs Do I need to be techy? No. If you can take a photo and send it on WhatsApp, you can do this. What if the AI misreads a receipt? You’ll see it in the log — just edit the row. Over time, you can improve the prompt. Can I use this for business expenses? Yes! Perfect for solopreneurs, coaches, and freelancers. What if I don’t use WhatsApp? You can adapt it to email or Google Drive — just let me know, and I’ll send you the tweak. Is the Softr dashboard hard to build? No — I’ll walk you through it step by step, with screenshots. 💬 What People Are Saying (Sample Testimonial) > “I used to lose at least 3 receipts a week. Now I just snap and send. My partner actually trusts my budget now — and I feel like a grown-up for the first time!” > — Lena, mom of two + online course creator 🌿 Final Thought You’re not behind. You’re not failing. You’re just using tools that weren’t built for real life. Snap & Save was. It meets you where you are — in the car, in the kitchen, in the chaos — and says: > “I’ve got this. Just send the photo.” Let the AI do the work. You keep doing what matters. 💛 With love, The WorkFlow Muse @SheCodesFlow Helping homemakers & solopreneurs lead with ease — one smart system at a time. 🔖 Tags receipt-tracker ai-expense-tracker vlmrun whatsapp-automation google-sheets no-code-finance homemaker-tools solopreneur-automation n8n-workflow ai-vision snap-and-save business-expenses tax-prep function-node digital-organization. An n8n automation workflow template by Shelly-Ann Davy.

By Jitesh Dugar

Automated Certificate Generator with Email Validation & Delivery Automatically generate, validate, and deliver professional course completion certificates with zero manual work — from webhook request to PDF delivery in seconds. Overview This workflow transforms certificate generation from a manual design task into a fully automated system. It receives certificate requests via webhook, validates recipient emails using advanced verification, generates beautifully designed HTML certificates, converts them to high-quality PNG images, delivers via professional email templates, and maintains complete audit trails in Google Sheets. Powered by email validation APIs and HTML-to-image conversion, it ensures every certificate meets professional standards while preventing delivery to invalid or fraudulent email addresses. What This Workflow Does Receives certificate requests** via webhook from your LMS, CRM, or custom application Validates recipient emails** using VerifiEmail API with comprehensive checks: RFC compliance verification MX record validation Disposable email detection Spoof and fraud prevention Generates professional certificates** with custom HTML/CSS templates featuring: Purple gradient backgrounds with modern typography Google Fonts integration (Playfair Display + Montserrat) Gold achievement badges Auto-generated unique certificate IDs Formatted completion dates Instructor signatures Converts HTML to PNG** using HTMLcsstoImg API for permanent, shareable images Delivers via email** with branded HTML templates including download links and LinkedIn sharing CTAs Logs everything** to Google Sheets for reporting, analytics, and certificate verification Handles errors** with automatic validation checks and optional Slack notifications Key Features Zero Manual Work**: Fully automated from request to delivery Advanced Email Validation**: Blocks invalid, temporary, and fraudulent email addresses Professional Design**: Print-ready certificates with customizable branding Unique Certificate IDs**: Auto-generated format: CERT-{timestamp}-{random} Instant Delivery**: Certificates sent within seconds of completion Complete Audit Trail**: All certificates logged with 10+ data points Error Prevention**: Validation stops invalid requests before processing Highly Customizable**: Easy to modify colors, fonts, layouts, and email templates Scalable**: Handles hundreds of certificates per day API-Ready**: RESTful webhook endpoint for easy integration Use Cases Educational Institutions Automatically issue certificates for online courses and programs Generate graduation certificates for completed degrees Create participation certificates for workshops and seminars Corporate Training Award compliance training certificates to employees Recognize professional development completions Issue skill certification for internal programs Online Course Platforms Integrate with LMS systems (Teachable, Thinkific, Kajabi) Automate certificate delivery upon course completion Build certificate libraries for student portfolios Event Management Issue attendance certificates for conferences and webinars Generate speaker appreciation certificates Create volunteer recognition certificates Certification Programs Award professional certifications and credentials Generate CPE/CE certificates for continuing education Issue examination completion certificates Prerequisites Required Services & Accounts n8n** (self-hosted or cloud) - Workflow automation platform VerifiEmail Account** - Email validation API HTMLcsstoImg Account** - HTML to PNG conversion Gmail Account** - Email delivery via OAuth2 Google Workspace** - For Sheets logging and tracking Required Credentials VerifiEmail API Key HTMLcsstoImg User ID + API Key Gmail OAuth2 credentials Google Sheets OAuth2 credentials Setup Instructions 1. Import the Workflow Download the certificate-generator.json file In n8n, navigate to Workflows → Import from File Select the JSON file and click Import 2. Configure Credentials VerifiEmail API Sign up at https://verifi.email Navigate to Dashboard → API Keys Copy your API key In n8n: Settings → Credentials → Add Credential Search for "VerifiEmail" Name: VerifiEmail API Paste API key and save Assign to "Verifi Email" node in workflow HTMLcsstoImg API Sign up at https://htmlcsstoimg.com Go to Dashboard → API Copy User ID and API Key In n8n: Credentials → Add Credential → "HTMLcsstoImg" Name: HTMLcsstoImg API Enter User ID and API Key Assign to "HTML/CSS to Image" node Gmail OAuth2 In n8n: Credentials → Add Credential → "Gmail OAuth2" Click Connect my account Follow Google OAuth flow Grant permissions: Send email Name: Gmail OAuth2 Assign to "Send Certificate Email" node Google Sheets OAuth2 Create new Google Sheet: "Certificates Log" Add column headers in Row 1: Certificate ID Recipient Name Course Email Completion Date Generated At Certificate URL Status Instructor Duration In n8n: Credentials → Gmail OAuth2 (same as above works for Sheets) Assign to "Log to Google Sheets" node Select your "Certificates Log" spreadsheet Select "Sheet1" 3. Activate Workflow Click the toggle switch in top-right to activate Copy the Webhook URL from "Certificate Request Webhook" node Format: https://your-n8n-instance.com/webhook/certificate-generator 4. Configure Your Application For LMS Integration: // When course is completed fetch('https://your-n8n-instance.com/webhook/certificate-generator', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ name: student.fullName, course: course.title, date: new Date().toISOString().split('T')[0], email: student.email, instructor: course.instructor, duration: course.duration }) }); For Zapier/Make.com: Trigger: Course completed Action: Webhooks → POST URL: Your webhook URL Body: Map fields to JSON format 5. Test the Workflow Send test request: curl -X POST https://your-n8n-instance.com/webhook/certificate-generator \ -H "Content-Type: application/json" \ -d '{ "name": "Test User", "course": "Test Course", "date": "2025-10-04", "email": "test@gmail.com" }' Verify: Email validation passes Certificate generated successfully Image created at HTMLcsstoImage Email delivered to inbox Entry logged in Google Sheets How It Works Webhook Trigger → Receives POST request with certificate data Email Validation → VerifiEmail checks RFC, MX records, disposable status Field Validation → Ensures name, course, date present and email valid Data Combination → Merges webhook data with validation results HTML Generation → Creates styled certificate with dynamic content Image Conversion → HTMLcsstoImg renders 1200x850px PNG Email Delivery → Gmail sends professional template with download link Database Logging → Google Sheets records all certificate details Error Handling → Catches failures and stops invalid requests Processing Time: 5-10 seconds per certificate API Reference Endpoint POST /webhook/certificate-generator Content-Type: application/json Required Fields { "name": "string", // Full name of recipient "course": "string", // Course or program name "date": "YYYY-MM-DD", // Completion date "email": "string" // Recipient email address } Optional Fields { "instructor": "string", // Instructor name (default: "Program Director") "duration": "string", // Course duration (e.g., "40 hours") "certificateId": "string" // Custom ID (auto-generated if not provided) } Success Response { "success": true, "message": "Certificate generated and sent successfully", "certificateId": "CERT-1728000000-ABC123", "certificateUrl": "https://hcti.io/v1/image/xyz123" } Error Response { "success": false, "error": "Missing required fields: name, course, date, or valid email" } Customization Certificate Design Edit the "Generate HTML Certificate" Code node: Change Brand Colors: // Background gradient background: linear-gradient(135deg, #YOUR_COLOR_1 0%, #YOUR_COLOR_2 100%); // Border color border: 3px solid #YOUR_BRAND_COLOR; Add Company Logo: Modify Fonts: @import url('https://fonts.googleapis.com/css2?family=Your+Font&display=swap'); font-family: 'Your Font', sans-serif; Email Template Edit the "Send Certificate Email" node message: Update Company Info: © 2025 Your Company Name Contact: support@yourcompany.com Change Header Color: .header { background: linear-gradient(135deg, #YOUR_COLOR_1, #YOUR_COLOR_2); } Certificate ID Format In "Generate HTML Certificate" node: // Custom format: COURSE-YEAR-NUMBER const certId = ${data.course.substring(0,3).toUpperCase()}-${new Date().getFullYear()}-${Math.floor(Math.random() * 10000)}; Data Flow Webhook → Email Validation → Field Validation → Combine Data ↓ Generate HTML → Convert to PNG → Send Email ↓ Log to Sheets → Success Response ↓ Error Handling (if failed) Expected Output PNG Certificate Includes: Branded header with logo/company name Recipient name in large display font Course name and duration Formatted completion date Instructor signature section Unique certificate ID Gold achievement badge Professional borders and styling Google Sheets Entry: Certificate ID Recipient details Course information Completion date and time Direct link to certificate image Status: "Sent" Email Notification: Professional HTML template Personalized congratulations message Direct download button Certificate details table LinkedIn sharing encouragement Performance Processing Time:** 5-10 seconds per certificate Daily Capacity:** 250+ certificates (limited by free tier quotas) Image Resolution:** 1200x850px (print-ready) File Size:** ~200-400 KB per PNG Email Delivery:** ~98% success rate Troubleshooting Webhook not receiving data Verify webhook URL is correct Check n8n workflow is activated Ensure POST method is used Validate JSON format Email validation fails Use real email domains (not example.com) Check VerifiEmail API quota Verify API credentials are correct Test with gmail.com addresses first Certificate not generating Check required fields are present Verify date format is YYYY-MM-DD Review "Generate HTML Certificate" node logs Ensure HTMLcsstoImg API key valid Image conversion fails Verify HTMLcsstoImg credits available Check HTML syntax is valid Review API response in execution logs Test HTML locally first Email not delivered Confirm Gmail OAuth2 connected Check recipient email is valid Review spam/junk folders Verify Gmail daily limit not exceeded Google Sheets not updating Re-authenticate Google Sheets OAuth2 Verify spreadsheet permissions Check column names match exactly Ensure sheet exists and is accessible Best Practices Test with small batches before production rollout Monitor API quotas to avoid unexpected failures Use real email addresses during testing (avoid disposable) Archive old certificates periodically from Google Sheets Set up Slack notifications for error monitoring Validate webhook payload before sending Document customizations for team reference Back up Google Sheets regularly Review email deliverability weekly Keep credentials secure and rotate periodically Security Notes All API credentials encrypted in n8n Certificate URLs are publicly accessible via direct link Email validation prevents delivery to fraudulent addresses Webhook uses HTTPS for secure data transmission Google Sheets access controlled via OAuth2 permissions No sensitive data stored in workflow logs Future Enhancements PDF output option for formal certifications Multiple certificate templates (modern, classic, minimalist) QR code verification system Batch certificate generation Multi-language support Certificate revocation capability Analytics dashboard WhatsApp/SMS delivery option Integration with Notion/Confluence knowledge bases Support Resources n8n Documentation n8n Community Forum VerifiEmail Docs HTMLcsstoImage API Gmail API Reference Google Sheets API License This workflow template is provided as-is for free use and modification under the MIT License. Attribution appreciated but not required. Version: 1.0.0 Last Updated: October 2025 Compatibility: n8n v1.0.0+. An n8n automation workflow template by Jitesh Dugar.

By Muhammad Asadullah

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 30 days) using the YouTube Data API v3, grabs each video's views and likes, transcribes them using Google Gemini, and saves detailed summaries back to your spreadsheet with relevance scores based on your 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 Get Channel ID: Uses the YouTube API to look up each channel's ID from its handle Fetch Recent Videos: Pulls up to 20 latest videos per channel via the YouTube API Filter Videos: Only keeps videos from the last 30 days Get Video Stats: Fetches each video's view count and like count from the YouTube API Check for Duplicates: Skips videos already saved in your spreadsheet Transcribe: Uses Google Gemini API to watch and transcribe the video content Summarize & Score: AI agent analyzes the transcript 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 all video data (including views, likes, transcript, summary) in Google Sheets Setup Instructions — Step by Step (Anyone Can Do This!) What You'll Need Before Starting An n8n account — cloud or self-hosted (n8n.io) A Google account (for Google Sheets and API access) A Gemini API key (free to get — instructions below) A YouTube Data API key (free to get — instructions below) Don't worry if you've never done this before — each step is explained simply! Step 1: Make a Copy of the Google Sheet This is where all your channels and video results will be stored. Open the template: Click here to open the Google Sheet Click File → Make a copy and save it to your own Google Drive You'll see two tabs at the bottom: channels and videos The "channels" tab is where you tell the workflow which YouTube channels to watch: Column A — category: A label for the channel group (e.g. "AI News", "Marketing") Column B — channels: Paste one or more YouTube channel URLs, separated by commas (e.g. https://youtube.com/@mkbhd, https://youtube.com/@fireship) Column C — video filter criteria: Describe what kind of videos matter to you (e.g. "videos about AI tools for business owners") The "videos" tab is filled in automatically by the workflow — you don't need to do anything here. Step 2: Get Your Gemini API Key (Free) Gemini is Google's AI — it reads and summarizes the videos for you. Go to: https://makersuite.google.com/app/apikey Sign in with your Google account Click "Create API Key" Copy the key and save it somewhere safe (like a notes app) Step 3: Get Your YouTube API Key (Free) This lets the workflow search YouTube channels and fetch video details like views and likes. Go to: https://console.cloud.google.com Sign in with your Google account Click "Select a project" at the top, then "New Project" — give it any name and click Create Once inside the project, click the hamburger menu (☰) → APIs & Services → Library Search for "YouTube Data API v3" and click on it Click Enable Now go to APIs & Services → Credentials Click "+ Create Credentials" → API Key Copy the key that appears and save it Step 4: Import the Workflow into n8n Open your n8n dashboard Click "New Workflow" → then click the three dots (⋮) menu → "Import from JSON" Paste the workflow JSON and click Import Step 5: Connect Your Google Account The workflow needs permission to read and write to your Google Sheet. In the workflow, click on any node that says "Google Sheets" Under Credential, click "Create new credential" Follow the pop-up to sign in with your Google account and grant access Once connected, all Google Sheets nodes will use this same account Step 6: Add Your API Keys Find the node called "Set channel and API" (it's an orange node near the start of the flow) Click on it to open it Replace your_api_key in the gemini_api_key field with your Gemini key from Step 2 Replace your_api_key in the youtube_api field with your YouTube key from Step 3 Click Save Step 7: Update the Google Sheet ID The workflow needs to know which spreadsheet to use — this is the long string of letters in your sheet's URL. Open your copied Google Sheet Look at the URL — it looks like: https://docs.google.com/spreadsheets/d/THIS_IS_YOUR_ID/edit Copy that ID In n8n, click on any Google Sheets node and update the Document ID field with your ID Do this for all Google Sheets nodes (there are a few — look for the yellow spreadsheet icons) Step 8: Test It! Add a YouTube channel URL to your channels sheet (Column B) Add a category in Column A and a description in Column C In n8n, click "Test Workflow" (the play button) Watch it run — after a minute or two, check your videos tab in Google Sheets for results! Step 9: Turn It On (Activate) Once you're happy it works: Click the toggle switch at the top of the n8n workflow to Activate it It will now run automatically every week at 7:05 AM — no action needed from you! Optional Adjustments Change how far back it looks: The workflow currently checks videos from the last **30 days. To change this, find the "Last 30 days" filter node and edit the number. Change the schedule: Click the **"Schedule Trigger" node and set whatever day/time you prefer. Adjust wait times**: The workflow has built-in pauses between videos to avoid hitting API limits. You can make them shorter if you're processing fewer channels. Good to Know Videos already in your sheet won't be processed again — no duplicates If a video fails to transcribe, the workflow moves on to the next one automatically Each video's views and likes are saved alongside the summary The workflow supports multiple channels per row — just separate URLs with commas. An n8n automation workflow template by Muhammad Asadullah.

By Ahmed Sherif

Telegram AI Bot Workflow An intelligent Telegram bot powered by Google Gemini AI that provides smart responses to both text messages and images. Features Multi-Modal Input**: Handles both text messages and image uploads AI-Powered Responses**: Uses Google Gemini 2.5 Flash for intelligent reply generation Image Analysis**: Automatically analyzes uploaded images and responds with descriptions Conversation Memory**: Maintains context across 20 messages per conversation Formatted Output**: Delivers well-structured, Telegram-friendly responses How It Works User sends a message (text or image) to the Telegram bot Workflow routes the input based on message type Images are downloaded and analyzed using Gemini Vision AI AI agent processes the input with conversation context Formatted response is sent back to the user instantly Requirements Telegram Bot Token (from @BotFather) Google Gemini API Key n8n instance with webhook capability Perfect for building interactive AI assistants, customer support bots, or educational tools on Telegram. An n8n automation workflow template by Ahmed Sherif.

By Pawan

This template provides a complete, two-part automation system for exam preparation providers, educators, or content creators to automatically generate unique Multiple-Choice Questions (MCQs) on a specific syllabus, save them to Google Sheets, and publish them as Telegram polls—all on a schedule and driven by Google's Gemini Chat Model. How it Works / What it Does This template consists of two interconnected workflows: Workflow 1: Quiz Generation & Storage A Schedule Trigger starts the quiz generation process periodically. The AI Agent (powered by the Gemini Chat Model) generates a new MCQ based on a specific syllabus or topic (configured in the agent's prompt). The workflow reads all existing quiz data from a Google Sheet (your quiz database). The AI Agent receives the existing quiz data as memory to intelligently check the newly generated question against the existing ones, ensuring the new MCQ is unique and avoids duplication. The new, unique MCQ is added or updated as a new row in the Google Sheet. Workflow 2: Quiz Posting & Status Update A Google Sheets Trigger listens for new rows (the new unique MCQ) being added or updated in the sheet. It reads the newly added quiz data. A Check New Quiz Added node verifies the data is ready to be posted. The validated quiz is posted to your specified Telegram chat as an interactive poll. The workflow immediately updates the corresponding row in the Google Sheet, marking the quiz as "Posted" to prevent accidental reposting. Finally, it triggers the start of Workflow 1 again to generate the next unique quiz, creating a continuous loop of content creation and publishing. Requirements To set up this template, you will need: n8n Account: A running n8n instance (cloud or self-hosted). Google Account: For the Google Sheets Trigger/Nodes and the Google Gemini Chat Model (via the Google services/credentials). Telegram Account: A Telegram Bot Token and the Chat ID where the polls will be posted. How to Set Up This template is designed to be plug-and-play after connecting your credentials. Connect Google Gemini Chat Model: Authenticate the Google Gemini Chat Model node using your Google account and ensure you have access to the Gemini model API. Configure Google Sheets Nodes: Connect to your Google Sheet where the quizzes are stored. Make sure the sheet has columns for the quiz question, options, answer, and a "Status" column (e.g., Posted or New). Configure Telegram Node: Set up the Send Telegram Poll node with your Bot Token and the target Chat ID. Customize AI Agent: Update the AI Agent's prompt with the specific syllabus, topic, and format instructions for your desired MCQs. How to Customize the Workflow Posting Schedule: Adjust the Schedule Trigger in Workflow 1 to control how often new quizzes are generated (e.g., daily, every hour). Difficulty/Format: Modify the AI Agent's prompt to control the difficulty level, number of options, or required answer explanation for the MCQs. Destination: Easily replace the Send Telegram Poll node with other social media nodes (like X/Twitter, Slack, or Discord) to post your MCQs on different platforms. An n8n automation workflow template by Pawan.

By SpaGreen Creative

Send Automatic WhatsApp Order Confirmations from Shopify with Rapiwa API Who’s it for This n8n workflow helps Shopify store owners and teams automatically confirm orders via WhatsApp. It checks if the customer's number is valid using Rapiwa API, sends a personalized message, and logs every attempt in Google Sheets—saving time and reducing manual work. Whether you're a solo entrepreneur or managing a small team, this solution gives you a low-cost alternative to the official WhatsApp Business API, without losing control or personalization. Features Receives new order details via webhook upon order creation or update. Iterates over incoming data in manageable batches for smoother processing. Extracts and formats customer and order details from the Shopify webhook payload. Strips non-numeric characters from WhatsApp numbers for consistent formatting. Uses Rapiwa API to check if the WhatsApp number is valid and active. Branches the workflow based on number validity — separates verified from unverified. Sends a custom WhatsApp confirmation message to verified customers using Rapiwa. Updates Google Sheet rows with status and validity How it Works / What It Does Triggered by a Shopify webhook or by reading rows from a Google Sheet. Normalizes and cleans** the order payload. Extracts details like customer name, phone, items, shipping, and payment info. Cleans phone numbers (removes special characters). Verifies if the number is registered on WhatsApp via Rapiwa API. If valid: Sends a templated WhatsApp message. Updates Google Sheet with validity = verified and status = sent. If invalid: Skips sending. Updates sheet with validity = unverified and status = not sent. Adds wait/delay between sends to prevent rate limits. Keeps an audit trail in the connected Google Sheet. How to Set Up Set up a Shopify webhook for new orders (or connect a Google Sheet). Create a Google Sheet with columns: name, number, order id, item name, total price, validity, status Create and configure a Rapiwa Bearer token in n8n. Add Google Sheets OAuth2 credential in n8n. Import the workflow in n8n and configure these nodes: Webhook or Sheet Trigger Loop Over Items (SplitInBatches) Normalize Payload (Code) Clean WhatsApp Number (Code) Rapiwa WhatsApp Check (HTTP Request) Conditional Branch (If) Send WhatsApp Message (HTTP Request) Update Google Sheet (Google Sheets) Wait Node (delay per send) Requirements Shopify store with order webhook enabled (or order list in Google Sheet) A verified Rapiwa API token A working n8n instance with HTTP and Google Sheets nodes enabled A Google Sheet with required structure and valid OAuth credentials in n8n How to Customize the Workflow Modify the message template with your own brand tone or emojis. Add country-code logic in the Clean Number node if needed. Use a unique order id in your Google Sheet to prevent mismatches. Increase or decrease delay in the Wait node (e.g., 5–10 seconds). Use additional logic in Code nodes to handle discounts, promotions, or more line items. Workflow Highlights Triggered by Shopify webhook update. Receiving new order data form Shopify using webhook Cleans and extracts order data from raw payload. Normalizing and validating the customer’s WhatsApp number using the Rapiwa API Verifies WhatsApp number using Rapiwa's verify-whatsapp endpoint. Sends order confirmation via Rapiwa's send-message endpoint. Logs every result into Google Sheets (verified/unverified + sent/not sent). Setup in n8n 1. Check WhatsApp Registration Use an HTTP Request node: URL: https://app.rapiwa.com/api/verify-whatsapp Method: POST Auth: httpBearerAuth using your Rapiwa token Body: { "number": "cleaned_number" } 2. Branch Based on Validity Use an If node: Condition: {{ $json.data.exists }} == true (or "true" if string) 3. Send Message via Rapiwa Endpoint: https://app.rapiwa.com/api/send-message Method: POST Body: Hi {{ $json.customer_full_name }}, Thank you for shopping with SpaGreen Creative! We're happy to confirm that your order has been successfully placed. 🧾 Order Details • Product: {{ $json.line_item.title }} • SKU: {{ $json.line_item.sku }} • Quantity: {{ $json.line_item.quantity }} • Vendor: {{ $json.line_item.vendor }} • Order ID: {{ $json.name }} • Product ID: {{ $json.line_item.product_id }} 📦 Shipping Information {{ $json.shipping_address.address1 }} {{ $json.shipping_address.address2 }} {{ $json.shipping_address.city }}, {{ $json.shipping_address.country }} - {{ $json.shipping_address.zip }} 💳 Payment Summary • Subtotal: {{ $json.subtotal_price }} BDT • Tax (VAT): {{ $json.total_tax_amount }} BDT • Shipping: {{ $json.total_shipping_amount }} BDT • Discount: {{ $json.total_discount_amount }} BDT • Total Paid: {{ $json.total_price }} BDT Order Date: {{ $json.created_date }} Warm wishes, Team SpaGreen Creative Sample Google Sheet Structure A Google Sheet** formatted like this ➤ Sample | name | number | order id | item name | total price | validity | status | | ----------- | ------------- | ------------- | ------------------------------ | ----------- | -------- | ------ | | Abdul Mannan | 8801322827799| 8986469695806 | Iphone 10 | 1150 | verified | sent | | Abdul Mannan | 8801322827799| 8986469695806 | S25 UltraXXXXeen Android Phone | 23000 | verified | sent | Tips Always ensure phone numbers have a country code (e.g., 880 for BD). Clean numbers with regex: replace(/\D/g, '') Adjust Rapiwa API response parsing depending on actual structure (true vs "true"). Use row_number for sheet updates, or unique order id for better targeting. Use the Wait node to add 3–10 seconds between sends. Important Notes Avoid reordering sheet rows—updates rely on consistent row_number. shopify-app-auth is the credential name used in the export—make sure it's your Rapiwa token. Use a test sheet before going live. Rapiwa has request limits—avoid rapid sending. Add media/image logic later using message_type: media. Future Enhancements (Ideas) Add Telegram/Slack alert once the batch finishes. Include media (e.g., product image, invoice) in the message. Detect and resend failed messages. Integrate with Shopify’s GraphQL API for additional data. Auto-mark fulfillment status based on WhatsApp confirmation. Support & Community WhatsApp: 8801322827799 Discord: discord Facebook Group: facebook group Website: https://spagreen.net Envato/Codecanyon: codecanyon portfolio. An n8n automation workflow template by SpaGreen Creative.

By Louis

📄 Automated Invoice Processing (n8n + AI + Google Workspace) This workflow automates the extraction and processing of invoice data from PDFs stored in a Google Drive folder. It leverages Google Drive, Google Sheets, and Gemini AI to streamline invoice management. Key Features Automatic Detection:** Monitors a Google Drive folder for new invoices. AI-Powered Extraction:** Uses Gemini AI to extract structured data including Supplier, Buyer, Items, Total Amount, Tax, and Payment Terms. Data Logging:** Appends extracted invoice information to a Google Sheet and tracks processed documents to avoid duplicates. Notifications:** Sends email alerts once invoices are successfully processed. Flexible & Extensible:** Can be integrated with ERP/CRM systems, Slack/Telegram notifications, or OCR for scanned PDFs. 💡 Perfect for: Small to medium businesses, accountants, and operations teams looking to reduce manual invoice data entry and improve accuracy. An n8n automation workflow template by Louis.

By Jitesh Dugar

Customer Support Ticket Documentation Automation Automatically transform resolved support tickets into professional, AI-powered PDF documentation with complete tracking and team notifications. Overview This workflow automates the entire process of documenting resolved support tickets — from receiving ticket data to generating professional PDF case studies, storing them in Google Drive, tracking in spreadsheets, and notifying your team. Powered by AI, it creates consistent, high-quality documentation that can be reused for knowledge base articles, training materials, and compliance records. What This Workflow Does Receives resolved support tickets via webhook from your support platform Extracts and normalizes ticket data (works with Zendesk, Freshdesk, and custom formats) Generates AI-powered summaries using OpenAI GPT-4, creating structured case studies with: Problem description Troubleshooting steps taken Final resolution Key takeaways and prevention tips Creates professional PDF documents with branded HTML templates Uploads PDFs to organized Google Drive folders Tracks all tickets in a Google Sheets database for reporting and analytics Sends Slack notifications to your team with links to completed documentation Handles errors gracefully with automatic alerts when issues occur Key Features Fully Automated:** Zero manual intervention after setup AI-Powered Documentation:** Intelligent summaries that extract insights from raw ticket data Professional Output:** Branded, print-ready PDFs with modern styling Multi-Platform Support:** Works with any support tool that can send webhooks Centralized Tracking:** All tickets logged in Google Sheets for easy reporting Error Handling:** Built-in failure detection with Slack alerts Customizable:** Easy to brand with your company colors, logo, and styling Scalable:** Handles hundreds of tickets per day Use Cases Knowledge Base Building:** Automatically create searchable documentation from real support cases Team Training:** Build a library of resolved issues for onboarding new support agents Compliance & Audit:** Maintain complete records of all customer interactions Performance Analytics:** Track resolution times, common issues, and agent performance Customer Success:** Share professional case studies with stakeholders Process Improvement:** Identify recurring issues and optimize workflows Prerequisites Required Services & Accounts n8n** (self-hosted or cloud) OpenAI Account** with API access PDFMunk Account** (for HTML → PDF conversion) Google Workspace** (for Drive & Sheets) Slack Workspace** (optional but recommended) Support Platform** that can send webhooks (Zendesk, Freshdesk, Intercom, etc.) Required Credentials OpenAI API Key PDFMunk API Key Google Drive OAuth2 credentials Google Sheets OAuth2 credentials Slack Bot Token (OAuth2) Setup Instructions 1. Import the Workflow Copy the workflow JSON. In n8n, click “Import from File” or “Import from Clipboard.” Paste and import. 2. Configure Credentials OpenAI API Get API key from OpenAI Add in n8n: Credentials → OpenAI API → Paste key PDFMunk API Sign up at pdfmunk.com Copy API key → Add in Credentials → HtmlcsstopdfApi Google Drive OAuth2 Create project at Google Cloud Console Enable Drive API Create OAuth 2.0 credentials Add in n8n: Credentials → Google Drive OAuth2 → Connect Google Sheets OAuth2 Enable Google Sheets API in the same project Add in n8n: Credentials → Google Sheets OAuth2 → Connect Slack OAuth2 Create app at Slack API Add scopes: chat:write, chat:write.public Install to workspace Add bot token in Credentials → Slack OAuth2 API 3. Configure Node Settings Google Drive Folder ID Create a folder in Drive for PDFs Copy folder ID from the URL → https://drive.google.com/drive/folders/FOLDER_ID_HERE Paste in the “Upload to Google Drive” node Google Sheets Configuration Create a new sheet titled “Support Ticket Documentation Log.” Add these headers in Row 1: | Ticket ID | Subject | Customer Name | Customer Email | Agent Name | Priority | Category | Resolved Date | Resolution Time | PDF Link | Document Generated | Status | | --------- | ------- | ------------- | -------------- | ---------- | -------- | -------- | ------------- | --------------- | -------- | ------------------ | ------ | Copy Sheet ID from URL → https://docs.google.com/spreadsheets/d/SHEET_ID_HERE/edit Paste it in the “Update Google Sheets” node configuration. Slack Channel ID Right-click your Slack channel → View Channel Details Copy the Channel ID Update it in: “Send Slack Notification” node “Error – PDF Failed” node “Error – Upload Failed” node 4. Configure Webhook in Support Tool Activate the workflow in n8n Copy the Webhook URL from the “Webhook – Receive Ticket” node In Zendesk/Freshdesk: Trigger: “Ticket Status = Resolved” Method: POST Paste the n8n webhook URL Send ticket data as JSON 5. Test the Workflow Click “Execute Workflow” manually Send a test webhook Verify each step completes successfully Check: Generated PDF in Google Drive Row entry in Google Sheets Slack notification delivery How It Works Webhook Trigger → Receives resolved ticket Data Extraction → Normalizes ticket fields AI Summarization (OpenAI) → Generates structured summary HTML Formatting → Styles and adds branding PDF Conversion (PDFMunk) → Converts HTML → PDF Google Drive Upload → Saves and returns shareable link Sheets Logging → Appends ticket info + PDF link Slack Notification → Notifies team with summary Error Handling → Detects and reports failures Result → Clean, documented ticket case study in minutes Customization Branding Update company name, logo URL, and color scheme in the “Format HTML” node. Default color: #4CAF50 → Replace with your brand color. AI Prompt Customization Modify “AI Summarization (OpenAI)” node to add: Industry-specific terms Additional sections or insights Different summary tone or length Notification Customization Add @mentions or emojis in Slack messages for better visibility. Data Flow Webhook → Extract Data → AI Summary → Format HTML → Convert to PDF ↓ Download PDF → Upload to Drive → Log in Sheets → Notify Team ↓ Error Handling (if any) Expected Output PDF Document Includes: Branded header with company name/logo Resolution time badge Ticket metadata (ID, priority, customer, agent, etc.) Full AI-generated case study Professional footer with timestamp Google Sheets Entry: All ticket info Resolution metrics Direct PDF link Status = “Generated” Slack Notification: Summary of ticket Clickable PDF link Timestamp Performance Processing Time:** 10–20 seconds/ticket Capacity:** 100+ tickets/day PDF Size:** 50–300 KB Troubleshooting Webhook not triggering → Check webhook URL, trigger conditions, and public access. PDF generation fails → Verify HTML syntax and PDFMunk API key. Google Drive upload fails → Re-authenticate credentials or check folder permissions. Slack notification missing → Ensure bot token, scopes, and channel ID are valid. Data extraction errors → Adjust field mappings or inspect payload format. Best Practices Test before production rollout Monitor first-week error logs Organize Drive by date/priority Validate Sheets columns Use a dedicated Slack channel Archive old PDFs regularly Review AI summaries weekly Document configuration changes Security Notes All credentials stored securely in n8n PDF links are restricted by Drive sharing settings Webhooks use HTTPS for secure data transfer No sensitive info logged in error messages Future Enhancements Multi-language summaries Integration with Confluence or Notion Customer satisfaction feedback link ML-based issue categorization Analytics dashboard Weekly email digests Public knowledge base generation Support Resources n8n Documentation n8n Community OpenAI API Docs PDFMunk Support Google Drive API Slack API Docs License This workflow template is provided as-is for use with n8n under the MIT License. An n8n automation workflow template by Jitesh Dugar.

By Kaden Reese

SignSnapHome to Multi-CRM Auto Follow-up: Complete Real Estate Open House Automation Transform Your Open House Leads into Clients with Zero Manual Work Are you tired of manually entering open house visitor information into your CRM? Losing hot leads because you didn't follow up fast enough? This powerful n8n workflow automatically syncs every SignSnapHome open house sign-in to three major real estate CRMs and executes a customizeable 7-day follow-up sequence via email and SMS. Setup Video Here 🎯 What This Workflow Does This automation creates a complete, hands-free lead nurturing system for real estate agents using SignSnap Home for open house visitor management. Every time someone signs in at your open house, this workflow: Instantly captures all visitor data from SignSnap Home via webhook Intelligently scores each lead based on agent status and property interest Automatically syncs contact information to three CRMs simultaneously: HubSpot - For marketing automation and pipeline management Follow Up Boss - For real estate-specific lead management Monday.com - For team collaboration and task tracking Logs everything to Google Sheets for complete audit trail and reporting Sends personalized follow-ups over 7 days for qualified leads: Day 0: Immediate thank you email Day 2: SMS text message check-in Day 5: Market update email with consultation offer Day 7: Automatic task created in HubSpot for agent to call 🔥 Key Features Smart Lead Qualification Not all open house visitors are equal. This workflow automatically identifies qualified leads who receive the full follow-up sequence: ✅ Visitors who don't currently have a real estate agent ✅ Visitors who have an agent but haven't signed a buyer agreement Leads who already have representation get the basic treatment (thank you email + CRM sync) to respect existing relationships while still capturing their information for future opportunities. Multi-CRM Distribution Why limit yourself to one CRM? This workflow syncs to three platforms simultaneously: HubSpot**: Creates/updates contacts with full lead scoring and property visit history Follow Up Boss**: Adds leads with source attribution and detailed notes Monday.com**: Creates board items for team visibility and collaboration Complete Activity Tracking Every touchpoint is logged to Google Sheets across three tabs: Lead Master Log**: Complete record of every visitor with lead scores and qualification status Follow-up Activity**: Timestamp of every email, SMS, and task created Errors**: Captures any visitors without email addresses for manual follow-up TCPA-Compliant SMS Follow-up Automated SMS messaging via Twilio includes: Proper consent tracking (via open house sign-in) "Reply STOP to unsubscribe" compliance footer Personalized messaging based on agent status Complete activity logging for audit trail 💼 Perfect For Real Estate Agents** using SignSnap Home for open house management Real Estate Teams** who need centralized lead tracking across multiple CRMs Brokerages** wanting to standardize follow-up processes across agents Property Marketing Teams** managing multiple open houses simultaneously 🛠️ What You'll Need Required Accounts & Credentials: SignSnapHome account with webhook integration enabled HubSpot account (Free or paid tier) with API access Follow Up Boss account with API key Monday.com account with API token Twilio account with SMS-enabled phone number SMTP Email service (Gmail, SendGrid, etc.) Google Sheets with OAuth2 access Technical Requirements: Active n8n instance (cloud or self-hosted) Basic familiarity with n8n workflows 30 minutes for initial setup and credential configuration 📊 Lead Scoring Algorithm This workflow includes intelligent lead scoring to help you prioritize follow-up: Base Score: 50 points Scoring Adjustments: No real estate agent: +30 points (HOT lead!) Property rating 4-5 stars: +20 points Property rating 1-2 stars: -20 points No buyer agreement signed: +10 points Lead Status Categories: 70-100 points**: HOT 🔥 50-69 points**: WARM 40-49 points**: OPEN 0-39 points**: COLD The Day 7 follow-up task is automatically prioritized as HIGH for leads scoring 70+ points. 🚀 Setup Overview Step 1: Import Workflow Download this workflow JSON and import it into your n8n instance. Step 2: Configure Credentials Set up authentication for all seven services: HubSpot OAuth2 or API Token Follow Up Boss HTTP Basic Auth (API key as username) Monday.com API Token Twilio API credentials SMTP email settings Google Sheets OAuth2 Step 3: Create Google Sheets Structure Create one Google Sheet with three tabs: Tab 1: "Lead Master Log" Timestamp First Name Last Name Email Phone Property Lead Score Lead Status Has Agent Buyer Agreement Qualifies for Follow-up Source Tab 2: "Follow-up Activity" Timestamp Contact Email Contact Name Activity Type Message Property Success Notes Tab 3: "Errors" Timestamp Guest Name Property Phone Error Reason Step 4: Update Placeholders Replace these values in the workflow nodes: YOUR_GOOGLE_SHEET_ID_HERE - Your Google Sheet ID (or select manually) YOUR_EMAIL@DOMAIN.COM - Your from email address YOUR_TWILIO_PHONE_NUMBER - Your Twilio phone number (format: +15551234567) YOUR_MONDAY_BOARD_ID - Your Monday.com board ID Step 5: Configure SignSnap Home Activate the workflow in n8n Copy the webhook URL Go to SignSnapHome.com → Settings → Integrations Paste webhook URL and enable "Send on each submission" Step 6: Test! Have someone sign in at your next open house (or use test mode) and watch the magic happen! 📈 Expected Results Time Savings: 15-20 minutes per open house visitor (data entry, CRM updates, follow-up scheduling) Response Rate Improvements: Immediate thank you email: Builds rapport instantly Day 2 SMS: 98% open rate (vs 20-30% for email) Day 5 market update: Re-engages interested prospects Day 7 agent call task: Ensures no lead falls through cracks, make sure you set up your crm or change this to a simple notification node. Conversion Rate Impact: Many agents report 2-3x increase in open house visitor conversions with automated follow-up vs manual processes. 🎨 Customization Ideas This workflow is designed to be easily customizable: Adjust Follow-up Timing Change Wait node durations (Day 2 → Day 1, Day 5 → Day 3, etc.) Add more touchpoints (Day 10, Day 30, Day 90) Remove SMS and use email-only sequence Modify Lead Scoring Edit the JavaScript code in "Parse SignSnap Data" node Add new scoring criteria (property price range, visit duration, etc.) Change threshold values for HOT/WARM/COLD status Expand CRM Coverage Add Salesforce using HTTP Request node Include Pipedrive (native node available) Connect Zoho CRM (native node available) Add your brokerage's proprietary CRM via API Enhance Email Content Add property photos and listing details Include market statistics and neighborhood data Embed video tours or agent introduction videos Add social proof (testimonials, recent sales) Create Property-Specific Sequences Use IF nodes to branch by property address Send different messaging per listing Customize follow-up based on price range Include neighborhood-specific content 🔐 Compliance & Privacy This workflow is designed with real estate compliance in mind: TCPA Compliance (SMS): Consent established via open house sign-in "Reply STOP to unsubscribe" included in all messages Complete activity logging for audit trail Business relationship already established CAN-SPAM Compliance (Email): Easy unsubscribe mechanism Clear sender identification Accurate subject lines Business address included Data Privacy: No data stored in n8n workflow memory All data passed through encrypted connections CRM platforms handle data retention per their policies Google Sheets can be restricted to specific users 🆘 Troubleshooting "No email address" errors Make email required in SignSnap Home form settings Check "Errors" tab in Google Sheet for missed leads Follow up manually via phone using logged information CRM sync failures Verify all API credentials are current and not expired Check API rate limits (especially HubSpot free tier) Review execution logs in n8n for specific error messages SMS not sending Confirm Twilio account has sufficient balance Verify phone number format: +1XXXXXXXXXX (E.164 format) Check that recipient's country allows SMS from your Twilio number Ensure phone number was captured in SignSnap Home Wait nodes not resuming Confirm workflow is ACTIVE (not just saved) Check n8n queue system is running properly Verify execution mode settings allow waiting executions 📚 Additional Resources SignSnap Home: Website: https://signsnaphome.com Documentation: Contact SignSnap Home support Webhook setup guide: Available in app settings n8n Documentation: Webhook nodes: https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.webhook/ Wait node: https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.wait/ Code node: https://docs.n8n.io/code-examples/ CRM API Documentation: HubSpot: https://developers.hubspot.com/ Follow Up Boss: https://docs.followupboss.com/ Monday.com: https://developer.monday.com/ 🌟 Success Story "Before this automation, I was spending 30+ minutes after every open house manually entering contacts into HubSpot, then setting reminders to follow up. Now it's completely hands-free. The SMS follow-up on Day 2 alone has doubled my response rate. Best workflow I've ever implemented!" 🚦 Next Steps Download this workflow from the n8n Creator Hub Import into your n8n instance Follow the setup guide in the sticky notes Test with a sample submission before your next open house Monitor results in your Google Sheets activity log Customize and optimize based on your response rates 💡 Pro Tips A/B test your messaging**: Duplicate the workflow and test different email subject lines or SMS wording Track conversion rates**: Add a "Converted" column to your Google Sheet and update it when leads become clients Segment by property**: Use IF nodes to send different follow-up sequences for luxury vs starter homes Add social media enrichment**: Connect Clearbit or Hunter.io to automatically find LinkedIn profiles Create dashboard reports**: Connect Google Sheets to Data Studio for visual analytics 📞 Support For workflow-specific questions, please comment on this workflow in the n8n Creator Hub. For SignSnap Home account issues, contact SignSnap Home support directly. For CRM-specific questions, consult each platform's documentation linked above. 🏷️ Tags real-estate open-house crm-automation lead-nurturing sms-marketing email-automation hubspot follow-up-boss monday.com twilio google-sheets webhook multi-crm lead-scoring signsnap-home Version: 1.0 Last Updated: January 2025 Compatibility: n8n v1.0+ License: MIT Built with ❤️ for the real estate community. Questions or improvements? Drop a comment below!. An n8n automation workflow template by Kaden Reese.

By Jitesh Dugar

Email List Hygiene - Automated Weekly Validator Overview Validates email lists through automated checks, categorizes results as Valid/Invalid/Risky, updates Google Sheets in real-time, and delivers HTML reports. Runs every Friday at 5 PM via cron scheduling. Workflow Architecture Schedule Trigger → Read Google Sheets → Loop (Process Each Email) → Validate API → IF Branch (Valid/Invalid) → Update Google Sheets → Merge → Loop Back → Calculate Statistics → Send Email Report Loop Mechanism Split in Batches processes one email at a time Each email: validate → branch → update sheet → merge → continue Loop accumulates all results internally "Done" output triggers statistics calculation after all emails processed Health Score Formula Score = (Valid% × 100) - (Invalid% × 20) - (Risky% × 10) Bounded: 0-100 Ranges: 80-100: Excellent (green) 60-79: Good (orange) 0-59: Needs Attention (red) Prerequisites Required: Google account with Sheets access Email validation API (VerifiEmail) n8n v1.0+ Google Sheet Structure | Column | Type | Filled By | |--------|------|-----------| | row_number | Number | Auto-generated | | name | Text | You | | email | Text | You | | status | Text | Workflow | | checked_at | Text | Workflow | | notes | Text | Workflow | Only populate first three columns. Setup 1. Import Template Import JSON file to n8n via Workflows → Add workflow → Import from File 2. Configure Credentials Google Sheets OAuth2 (used by 3 nodes): Create credential via any Google Sheets node Grant spreadsheet permissions Apply same credential to all Google Sheets nodes Validation API: Get API key from https://verifi.email Add credential to "Validate Email Address" node Gmail OAuth2: Add credential to "Send Weekly Report" node Grant email sending permissions 3. Connect Google Sheet In all three Google Sheets nodes: Select your spreadsheet from Document dropdown Select sheet tab Verify "Column to Match On" = row_number (for Update nodes) 4. Set Email Recipient In "Send Weekly Report" node: Change "Send To" from placeholder to your email Optional: Add CC/BCC for multiple recipients 5. Test Add 3-5 test emails (mix of valid/invalid) Click "Execute Workflow" Verify sheet updates and email arrives 6. Activate Toggle "Active" switch. Workflow runs automatically every Friday at 5 PM. Customization Change Schedule: Edit "Weekly Schedule" node cron expression: Daily 9 AM: 0 9 * * * Monday 5 PM: 0 17 * * 1 First of month: 0 9 1 * * Email Design: Edit HTML in "Send Weekly Report" message field. Modify colors (search hex codes), text, or add branding. Archive Invalid Emails: Add Google Sheets Append node after "Update Invalid Status" → create "Invalid_Archive" tab → append email, name, reason, date Slack Notifications: Add Slack node after email report → configure channel → use summary text from statistics Rate Limiting: Add Wait node (1-2 seconds) after validation for large lists to prevent API throttling Troubleshooting "Column not found": Verify exact column names in sheet: row_number, name, email, status, checked_at, notes (case-sensitive) Only processes 1 email: Check Google Sheets node Range field is empty or set to include all rows. Verify "Use Header Row" enabled. Wrong statistics: Enable "Execute Once" in Calculate Statistics node settings (gear icon) Email not arriving: Check spam/promotions folder, verify Gmail credential authorized, confirm recipient address correct API errors: Verify API key valid, check quota not exceeded, test with simple email like test@gmail.com Merge node error: Confirm both Update nodes connect to Merge inputs (top and bottom). Check both branches execute successfully. Validation Checks Each email undergoes: RFC 5322 format compliance MX record existence (domain has mail servers) SMTP verification (mailbox exists) Disposable email service detection Catch-all domain detection Categories: Valid: All checks passed Invalid: Critical checks failed Risky: Disposable or catch-all domain Support Check execution logs in n8n Executions tab for errors. Use "Execute Node" on individual nodes to isolate issues. Visit n8n community forum for additional help. Tags email-validation marketing-automation data-cleaning google-sheets scheduled-workflow deliverability list-hygiene. An n8n automation workflow template by Jitesh Dugar.

By Yang

Who’s it for This template is perfect for TikTok creators, content marketers, and social media teams who want to turn viral comments into engaging short-form videos without manually scripting, recording, or editing. If you want to keep up with trends and consistently publish high-quality avatar videos, this workflow automates the entire process from comment selection to enhanced final video. What it does The workflow takes TikTok video URLs and their top comments from a Data Table, extracts the transcript using Dumpling AI, and uses GPT-4 to write a natural and engaging TikTok script inspired by the comment. It then generates a full AI avatar video through Captions.ai, enhances it with subtitles and B-roll using Submagic, and finally saves all video details into Airtable for tracking. Here’s what happens step by step: Pulls TikTok videos and their top comments from a Data Table Sends video URLs to Dumpling AI to retrieve transcripts Feeds both transcript and comment into GPT-4 to generate a conversational TikTok script Cleans and formats the script using JavaScript Sends the script to Captions.ai to produce an AI avatar video Checks video status and retries if needed Enhances the final video with Submagic for captions and effects Receives the enhanced video via webhook and logs details into Airtable How it works Schedule Trigger: Runs automatically at set intervals to start the workflow Data Table: Retrieves TikTok video URLs and associated comments Dumpling AI: Extracts transcripts from the video URLs GPT-4: Generates a compelling TikTok script based on the comment JavaScript Node: Cleans up script formatting for a smooth avatar generation Captions.ai: Creates an AI avatar video from the cleaned script Wait & Check: Monitors video creation status and retries if necessary Submagic: Enhances the video with captions, zooms, and B-roll effects Webhook & Airtable: Receives final video data and saves URL and ID for future use Requirements ✅ Dumpling AI API key stored as HTTP header credentials ✅ OpenAI GPT-4 credentials ✅ Captions.ai API credentials ✅ Submagic API credentials ✅ Airtable base with fields for Video URL and Caption Video ID ✅ A properly structured Data Table containing TikTok Keywords or video URLs How to customize Adjust the GPT-4 system prompt to shape the tone, style, or format of the TikTok script Change the avatar or creator settings in Captions.ai to match your brand personality Modify Submagic settings to control subtitle styling or B-roll effects Integrate approval steps before final video generation if needed Extend the workflow to auto-publish videos to TikTok or store them in cloud drives > This workflow lets you transform TikTok comments into engaging AI avatar videos with captions and edits, completely on autopilot. It’s a powerful way to scale content output and stay ahead of trends without manual scripting or filming. An n8n automation workflow template by Yang.

By Yang

Who’s it for This template is perfect for content creators, social media strategists, and marketing teams who want to uncover trending questions directly from real TikTok audiences. If you spend hours scrolling through videos to find content ideas or audience pain points, this workflow automates the entire research process and delivers clean, ready-to-use insights in minutes. What it does The workflow takes a keyword, searches TikTok for matching creator profiles, retrieves their latest videos, extracts viewer comments, and uses GPT-4 to identify the most frequently asked questions. These questions can be used to inspire new content, shape engagement strategies, or create FAQ-style videos that directly address what your audience is curious about. Here’s what happens step by step: Accepts a keyword from a form trigger Uses Dumpling AI to search TikTok for relevant profiles Fetches the most recent videos from each profile Extracts and cleans comments using a Python script Sends cleaned comments to GPT-4 to find recurring audience questions Saves the top questions and video links into a Data Table for easy review How it works Form Trigger: Collects the keyword input from the user Dumpling AI: Searches TikTok to find relevant creators based on the keyword Video Retrieval: Gets recent videos from the discovered profiles Comments Extraction: Gathers and cleans all video comments using Python GPT-4: Analyzes the cleaned text to extract top audience questions Data Table: Stores the results for easy access and content planning Requirements ✅ Dumpling AI API key stored as credentials ✅ OpenAI GPT-4 credentials ✅ Python node enabled in n8n ✅ A Data Table in n8n to store questions and related video details How to customize Adjust the GPT prompt to refine the tone or format of the extracted questions Add filters to target specific types of TikTok profiles or content niches Integrate the output with your content calendar or idea tracking tool Set up scheduled runs to build a constantly updating library of audience questions Extend the workflow to analyze TikTok hashtags or trends alongside comments > This workflow turns TikTok keyword searches into structured audience insights, helping you quickly discover real questions your audience is asking—perfect for fueling content strategies, campaigns, and engagement. An n8n automation workflow template by Yang.

By Daniel Nkencho

Adaptive LLM Router for Optimized AI Chat Responses Elevate your AI chatbots with intelligent model selection: automatically route simple queries to cost-effective LLMs and complex ones to powerful ones, balancing performance and expenses seamlessly. What It Does This workflow listens for chat messages, uses a lightweight Gemini model to classify query complexity, then selects and routes to the optimal LLM (Gemini 2.5 Pro for complex, OpenAI GPT-4.1 Nano for simple) to generate responses—ensuring efficient resource use. Key Features Complexity Classifier** - Quick assessment using Gemini 2.0 Flash Dynamic Model Switching** - Routes to premium or budget models based on needs Chat Trigger** - Webhook-based for real-time conversations Current Date Awareness** - Injects $now into system prompt Modular Design** - Easy to add more models or adjust rules Cost Optimization** - Reserves heavy models for demanding tasks only Perfect For Chatbot Developers**: Build responsive, cost-aware AI assistants Customer Support**: Handle routine vs. technical queries efficiently Educational Tools**: Simple facts vs. in-depth explanations Content Creators**: Quick ideas vs. detailed writing assistance Researchers**: Basic lookups vs. complex analysis Business Apps**: Optimize API costs in production environments Technical Highlights Harnessing n8n's LangChain nodes, this workflow demonstrates: Webhook triggers for instant chat handling Agent-based classification with strict output rules Conditional model selection for AI chains Integration of multiple LLM providers (Google Gemini, OpenAI) Scalable architecture for expanding model options Ideal for minimizing AI costs while maximizing response quality. No coding required—import, configure credentials, and deploy!. An n8n automation workflow template by Daniel Nkencho.

By Yang

Who’s it for This template is perfect for SEO writers, niche bloggers, and content marketers who want to generate high-quality blog posts from a single keyword without spending hours on research and writing. If you often find yourself stuck at the research stage or manually drafting blog content, this workflow automates the entire process from topic discovery to publication. What it does The workflow takes a keyword, performs a Google search using Dumpling AI, analyzes the top-ranking pages and People Also Ask (PAA) questions, and then uses GPT-4 to generate a detailed blog post based on the most valuable question. The blog draft is sent for approval via email, and once approved, it’s automatically published to WordPress. Here’s what happens step by step: Receives a keyword through a simple form Uses Dumpling AI to perform a Google search and extract: Top 2 organic search results People Also Ask (PAA) questions and answers Top related searches Filters for insightful PAA questions Sends the data to GPT-4 to generate a blog post in JSON format Emails the draft blog post for manual review and approval If approved, publishes the post automatically to WordPress How it works Form Trigger: Captures the keyword input Dumpling AI: Searches Google and extracts SEO data including top results, PAA, and related searches Code Node: Processes the raw search data into a structured format for GPT-4 Filter Node: Checks if PAA questions are available GPT-4: Chooses a strong PAA question and writes the blog post Gmail: Sends the draft blog post to your inbox for review Approval Node: Waits for manual approval WordPress: Publishes the approved post automatically Requirements ✅ Dumpling AI API key stored securely as credentials ✅ OpenAI GPT-4 credentials ✅ Gmail account with OAuth2 connected to n8n ✅ WordPress account with API credentials configured How to customize Edit the GPT-4 prompt to control the blog structure, tone, or style Add extra filters to select specific types of PAA questions (e.g., how-to, guides) Change the review recipient email in the Gmail node Add additional formatting or SEO optimization steps before publishing Integrate with Notion, Airtable, or Slack to log or notify team members after publication > This workflow turns a single keyword into a fully researched, GPT-4 generated, and auto-published blog post — helping you scale content creation efficiently while maintaining quality. An n8n automation workflow template by Yang.

By panyanyany

Overview This n8n workflow automatically converts and enhances multiple photos into professional ID-style portraits using Gemini AI (Nano Banana). It processes images in batch from Google Drive, applies professional ID photo standards (proper framing, neutral background, professional attire), and outputs the enhanced photos back to Google Drive. Input: Google Drive folder with photos Output: Professional ID-style portraits in Google Drive output folder The workflow uses a simple form interface where users provide Google Drive folder URLs and an optional custom prompt. It automatically fetches all images from the input folder, processes each through the Defapi API with Google's nano-banana model, monitors generation status, and uploads finished photos to the output folder. Perfect for HR departments, recruitment agencies, or anyone needing professional ID photos in bulk. Prerequisites A Defapi account and API key (Bearer token configured in n8n credentials): Sign up at Defapi.org An active n8n instance with Google Drive integration Google Drive account with two public folders: Input folder: Contains photos to be processed (must be set to public/anyone with the link) Output folder: Where enhanced photos will be saved (must be set to public/anyone with the link) Photos with clear faces (headshots or upper body shots work best) Setup Instructions 1. Prepare Google Drive Folders Create two Google Drive folders: One for input photos (e.g., https://drive.google.com/drive/folders/xxxxxxx) One for output photos (e.g., https://drive.google.com/drive/folders/yyyyyy) Important: Make both folders **public (set sharing to "Anyone with the link can view") Right-click folder → Share → Change "Restricted" to "Anyone with the link" Upload photos to the input folder (supported formats: .jpg, .jpeg, .png, .webp) 2. Configure n8n Credentials Defapi API**: Add HTTP Bearer Auth credential with your Defapi API token (credential name: "Defapi account") Google Drive**: Connect your Google Drive OAuth2 account (credential name: "Google Drive account"). See https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/ 3. Run the Workflow Execute the workflow in n8n Access the form submission URL Fill in the form: Google Drive - Input Folder URL: Paste your input folder URL Google Drive - Output Folder URL: Paste your output folder URL Prompt (optional): Customize the AI generation prompt or leave blank to use the default 4. Monitor Progress The workflow will: Fetch all images from the input folder Process each image through the AI model Wait for generation to complete (checks every 10 seconds) Download and upload enhanced photos to the output folder Workflow Structure The workflow consists of the following nodes: On form submission (Form Trigger) - Collects Google Drive folder URLs and optional prompt Search files and folders (Google Drive) - Retrieves all files from the input folder Code in JavaScript (Code Node) - Prepares image data and prompt for API request Send Image Generation Request to Defapi.org API (HTTP Request) - Submits generation request for each image Wait for Image Processing Completion (Wait Node) - Waits 10 seconds before checking status Obtain the generated status (HTTP Request) - Polls API for completion status Check if Image Generation is Complete (IF Node) - Checks if status is not "pending" Format and Display Image Results (Set Node) - Formats result with markdown and image URL HTTP Request (HTTP Request) - Downloads the generated image file Upload file (Google Drive) - Uploads the enhanced photo to the output folder Default Prompt The workflow uses this professional ID photo generation prompt by default: Create a professional portrait suitable for ID documentation with proper spacing and composition. Framing: Include the full head, complete shoulder area, and upper torso. Maintain generous margins around the subject without excessive cropping. Outfit: Transform the existing attire into light business-casual clothing appropriate for the individual's demographics and modern style standards. Ensure the replacement garment appears natural, properly tailored, and complements the subject's overall presentation (such as professional shirt, refined blouse, contemporary blazer, or sophisticated layered separates). Pose & Gaze: Position shoulders square to the camera, maintaining perfect frontal alignment. Direct the gaze straight ahead into the lens at identical eye height, avoiding any angular deviation in vertical or horizontal planes. Expression: Display a professional neutral demeanor or subtle closed-lip smile that conveys confidence and authenticity. Background: Utilize a solid, consistent light gray photographic background (color code: #d9d9d9) without any pattern, texture, or tonal variation. Lighting & Quality: Apply balanced studio-quality illumination eliminating harsh contrast or reflective artifacts. Deliver maximum resolution imagery with precise focus and accurate natural skin color reproduction. Customization Tips for Different ID Photo Types Based on the default prompt structure, here are specific customization points for different use cases: 1. Passport & Visa Photos Key Requirements: Most countries require white or light-colored backgrounds, neutral expression, no smile. Prompt Modifications: Background**: Change to Plain white background (#ffffff) or Light cream background (#f5f5f5) Expression**: Change to Completely neutral expression, no smile, mouth closed, serious but not tense Framing**: Add Head size should be 70-80% of the frame height. Top of head to chin should be prominent Outfit**: Change to Replace with dark formal suit jacket and white collared shirt or Navy blue blazer with light shirt Additional**: Add No glasses glare, ears must be visible, no hair covering the face 2. Corporate Employee ID / Work Badge Key Requirements: Professional but approachable, company-appropriate attire. Prompt Modifications: Background**: Use company color or standard #e6f2ff (light blue), #f0f0f0 (light gray) Expression**: Keep Soft closed-mouth smile — confident and approachable Outfit**: Change to specific dress code: Corporate: Dark business suit with tie for men, blazer with blouse for women Tech/Startup: Smart casual polo shirt or button-down shirt without tie Creative: Clean, professional casual clothing that reflects company culture Framing**: Use default or add Upper chest visible with company badge area clear 3. University/School Student ID Key Requirements: Friendly, youthful, appropriate for educational setting. Prompt Modifications: Background**: Use school colors or Light blue (#e3f2fd), Soft gray (#f5f5f5) Expression**: Change to Friendly natural smile or pleasant neutral expression Outfit**: Change to Replace with clean casual clothing — collared shirt, polo, or neat sweater. No logos or graphics Framing**: Keep default Additional**: Add Youthful, fresh appearance suitable for educational environment 4. Driver's License / Government ID Key Requirements: Strict standards, neutral expression, specific background colors. Prompt Modifications: Background**: Check local requirements — often White (#ffffff), Light gray (#d9d9d9), or Light blue (#e6f2ff) Expression**: Change to Neutral expression, no smile, mouth closed, eyes fully open Outfit**: Use Replace with everyday casual or business casual clothing — collared shirt or neat top Framing**: Add Head centered, face taking up 70-80% of frame, ears visible Additional**: Add No glasses (or non-reflective lenses), no headwear except religious purposes, natural hair 5. Professional LinkedIn / Resume Photo Key Requirements: Polished, confident, approachable. Prompt Modifications: Background**: Use Soft gray (#d9d9d9) or Professional blue gradient (#e3f2fd to #bbdefb) Expression**: Keep Confident, warm smile — professional yet approachable Outfit**: Change to: Executive: Premium business suit, crisp white shirt, tie optional Professional: Tailored blazer over collared shirt or elegant blouse Creative: Smart business casual with modern, well-fitted clothing Framing**: Change to Show head, full shoulders, and upper chest. Slightly more relaxed framing than strict ID photo Lighting**: Add Soft professional lighting with slight catchlight in eyes to appear engaging 6. Medical/Healthcare Professional Badge Key Requirements: Clean, trustworthy, professional medical appearance. Prompt Modifications: Background**: Use Clinical white (#ffffff) or Soft medical blue (#e3f2fd) Expression**: Change to Calm, reassuring expression with gentle smile Outfit**: Change to Replace with clean white lab coat over professional attire or Medical scrubs in appropriate color (navy, ceil blue, or teal) Additional**: Add Hair neatly pulled back if long, clean professional appearance, no flashy jewelry 7. Gym/Fitness Membership Card Key Requirements: Casual, recognizable, suitable for athletic environment. Prompt Modifications: Background**: Use Bright white (#ffffff) or gym brand color Expression**: Change to Natural friendly smile or neutral athletic expression Outfit**: Change to Replace with athletic wear — sports polo, performance t-shirt, or athletic jacket in solid colors Framing**: Keep default Additional**: Add Casual athletic appearance, hair neat General Customization Parameters Background Color Options: White: #ffffff (passport, visa, formal government IDs) Light gray: #d9d9d9 (default, versatile for most purposes) Light blue: #e6f2ff (corporate, professional) Cream: #f5f5dc (warm professional) Soft blue-gray: #eceff1 (modern corporate) Expression Variations: Strict Neutral**: "Completely neutral expression, no smile, mouth closed, serious but relaxed" Soft Smile**: "Very soft closed-mouth smile — confident and natural" (default) Friendly Smile**: "Warm natural smile with slight teeth showing — approachable and professional" Calm Professional**: "Calm, composed expression with slight pleasant demeanor" Clothing Formality Levels: Formal**: "Dark suit, white dress shirt, tie for men / tailored suit or blazer with professional blouse for women" Business Casual** (default): "Light business-casual outfit — clean shirt/blouse, lightweight blazer, or smart layers" Smart Casual**: "Collared shirt, polo, or neat sweater in solid professional colors" Casual**: "Clean, neat casual top — solid color t-shirt, casual button-down, or simple blouse" Framing Adjustments: Tight Crop**: "Head and shoulders only, face fills 80% of frame" (passport style) Standard Crop** (default): "Entire head, full shoulders, and upper chest with balanced space" Relaxed Crop**: "Head, shoulders, and chest visible, with more background space for professional portraits". An n8n automation workflow template by panyanyany.

By Amirul Hakimi

Advanced AI Lead Enrichment & Cold Email Personalization with n8n, Airtable, Apify, and LLMs Automated B2B Lead Nurturing: Hyper-Personalization for High-Converting Cold Email Campaigns This powerful n8n automation workflow is designed to execute advanced B2B lead enrichment and hyper-personalization for cold email outreach. By orchestrating a complex chain of data scraping, AI analysis (via LLMs/GPT-4.1), and CRM synchronization (using Airtable), this workflow ensures every lead receives a highly tailored and relevant outreach message, maximizing conversion rates and minimizing manual effort. Workflow Execution & Key Features Airtable Trigger & Lead Qualification: The workflow is triggered by an Airtable webhook, pulling a new lead record (including name, email, and company URLs). Email Validation* is performed using *NeverBounce** to filter out invalid contacts. Initial Lead Filtering screens for key demographic criteria (e.g., US: Yes or No? and target Headcount: >5, <30?). Only qualified B2B leads proceed, ensuring optimal resource allocation. Deep Web & Social Scraping (Apify Integration): LinkedIn Company Scraper* and a *LinkedIn Profile Scraper* (via *Apify**) extract raw data from the lead's company and personal profiles. Company Homepage Scraper** pulls the main website content for analysis. Scrape Personal LinkedIn Posts** node retrieves recent activity for the ultimate personalization hook. AI-Powered Data Synthesis & Variable Determination: Multiple OpenAI (GPT-4.1-mini/4.1) nodes analyze and structure the raw, cleaned text (Remove HTML nodes ensure clean inputs). Determine Valuable URLs** uses an LLM to smartly categorize and select key company pages (e.g., ==/about==, ==/solutions==, ==/case-studies==) for deeper scraping. Analyze Company/Mission, Analyze Offerings & Positioning, Analyze Process & Differentiation, and **Analyze Proof of Success nodes create factual, structured business summaries for the ultimate ICP research. Determine Variables* nodes create *pre-written, personalized cold email variables** (==company_specialty==, ==ICPofLead==, ==PainPointLeadSolves==, etc.) for different outreach strategies. LinkedIn Post Personalization: An LLM (Craft Opening Line - Posts) analyzes recent LinkedIn activity to generate a hyper-specific, conversation-starting opener (e.g., "Saw your LinkedIn post about..."). Conditional logic (Posts Available?) determines whether to use the post-based opener or fall back to the standard, company-based personalization. CRM Update & Campaign Launch (Instantly.ai): Finalized, enriched lead data and the crafted personalization variables are synchronized back to the Airtable CRM for record-keeping and lead status updates (Update Lead W/ Enrichment). The lead is then seamlessly pushed to the Instantly.ai outbound platform, injecting the AI-generated custom variables directly into the cold email sequence for mass deployment. This blueprint automates the tedious, high-effort task of prospect research and personalization, providing a scalable lead generation solution that increases both outreach quality and sales velocity. Stop sending generic emails—start leveraging AI automation today. An n8n automation workflow template by Amirul Hakimi.

By Robin Geuens

Overview Every day, this workflow scrapes LinkedIn jobs based on your keywords, saves them in a Google Sheet, and sends them by email. How it works The workflow runs every day at noon. The Apify node sends a request to a LinkedIn scraper actor on Apify, which scrapes and returns the data. The code node formats the data we want and builds the HTML needed to make the emails look good. We use inline if statements for cases where the salary isn't listed or the job doesn’t say if it’s on-site, remote, or hybrid. At the same time, we add the LinkedIn jobs we scraped to a Google Sheet so we can check them later. We combine everything into one list. The Gmail node uses the map() function to list all the items we scraped and formatted. It customizes the subject line and heading of the email to include the current date. Setup steps Create a new Google Sheet and add the headers you want. Adjust the Google Sheets node to use your newly created Sheet. Customize the JSON in the Get LinkedIn jobs node. Note that this workflow currently uses the LinkedIn Jobs Scraper - No Cookies actor on Apify. Leave date_posted as is. Adjust keywords to change the job you want to scrape. You can use Boolean operators like AND or NOT in your search. Adjust limit to the number of jobs you want to scrape. Adjust location to match your location. Leave sort as is to get the most recent jobs first. (Optional) Edit the HTML in the code node to change how the listings will look in the email. Add your email to the Gmail node. Requirements Apify account Apify community node installed. If you don’t want to install the community node, you can use a regular HTTP node and call the HTTP directly. Check their API docs to see what endpoint to call. Google Sheets API enabled in Google Cloud Console and credentials added to n8n Gmail API enabled in Google Cloud Console credentials added to n8n Possible customizations Add full job descriptions to the Google Sheet and email Continue the flow to create a tailored CV for each job Use AI to read the job descriptions and pull out the key skills the job posting is asking for. An n8n automation workflow template by Robin Geuens.

By Rahul Joshi

Description Automatically identify clients who haven’t been contacted in 14+ days and re-engage them with personalized Gmail follow-up emails, Google Sheets tracking, and Slack notifications for account managers. Prevents churn by ensuring no client goes unnoticed. 💌📊💬 What This Template Does Triggers every Monday at 9:00 AM to check client activity. ⏰ Fetches all contacts from GoHighLevel CRM. 🔗 Filters clients with no updates in the last 14+ days. 🔍 Sends personalized Gmail re-engagement emails. 📧 Logs all inactive clients in Google Sheets for tracking. 📊 Sends Slack notifications summarizing inactive clients for account managers. 💬 Handles workflow errors and alerts the team via Slack. 🚨 Key Benefits ✅ Automated client re-engagement — no more missed follow-ups. ✅ Reduces churn by maintaining regular touchpoints. ✅ Centralized Google Sheets audit trail for visibility. ✅ Real-time Slack alerts keep teams informed. ✅ Fully customizable inactivity threshold (default: 14 days). ✅ Built-in error handling with instant Slack error alerts. Features Weekly cron trigger (default: Monday 9 AM). ⏰ GoHighLevel CRM integration to fetch contacts. 🔗 Dynamic filter for “inactive 14+ days” clients. 🕒 Personalized HTML re-engagement email via Gmail. 💌 Automatic Google Sheets logging with client metadata. 📊 Slack notification summarizing inactive clients. 💬 Error Trigger node for reliable monitoring. 🚨 Requirements n8n instance (cloud or self-hosted) Gmail OAuth2 credentials for sending emails Slack API credentials with chat:write and channels:read GoHighLevel OAuth2 credentials for CRM data access Google Sheets OAuth2 credentials for logging Target Audience Agencies and consultants managing multiple client relationships. 👩‍💼 Account managers preventing client churn. 🔄 Service businesses needing systematic client check-ins. 🏢 Remote teams requiring Slack alerts for client engagement. 🌐 Step-by-Step Setup Instructions Connect Gmail, Slack, Google Sheets, and HighLevel credentials in n8n. 🔑 Replace placeholder values (YOUR_GOOGLE_SHEET_ID, YOUR_SLACK_CHANNEL_ID) with environment variables. ⚙️ Customize inactivity threshold (default: 14 days). 🕒 Import the workflow JSON into n8n. 📦 Test manually with sample client records. ✅ Enable the workflow for weekly automated execution. 🚀. An n8n automation workflow template by Rahul Joshi.