Workflow Templates

Who this workflow is for Consulting firms in strategy, management, or IT who want to automate client onboarding and internal task assignment. What this workflow does Automatically creates onboarding tasks and checklists using AI, routes them to the right consultant, logs client info in Google Sheets, and sends client welcome emails. Internal teams get Slack notifications, and kickoff meetings can be scheduled automatically. How the workflow works New client intake triggers workflow AI generates onboarding checklist Tasks routed based on project type Client info logged in Google Sheets Slack notifications sent to consultants Optional PDF of onboarding sent to client Email confirmation delivered to client Optional CRM integration Setup Instructions Connect Webhook/Form for intake Connect Google Sheets Connect OpenAI Connect Slack and email Configure optional CRM integration Author: Hyrum Hurst, AI Automation Engineer Company: QuarterSmart Contact: hyrum@quartersmart.com

Inbox2Ledger is an end-to-end n8n template that turns a noisy finance inbox into a clean, structured ledger. It fetches emails, uses AI guardrails to keep only finance-relevant messages, extracts invoice/receipt fields via an OCR-style agent, validates and auto-categorizes each expense, generates a unique case ID, and appends the result to a Google Sheet for accounting or downstream automations. Key Features Trigger*: Form submission or scheduled fetch (sample *On form submission node included) AI Filter**: Guardrail node determines whether an email is finance-related (payments, invoices, receipts) Keyword Filter**: Filters common invoice/bill/payment subject keywords Extraction**: Language-model agent returns normalized JSON: vendor_name invoice_date (YYYY-MM-DD) invoice_id total_amount tax_amount currency items_summary vendor_tax_id Validation**: Code node checks required fields and amount formats; flags extraction errors Categorization**: Rule-based expense categorizer (software & hosting, subscriptions, travel, payroll, etc.) with MCC/vendor fallbacks Output**: Appends structured rows to a Google Sheet with mapped columns: invoice_id, vendor_name, invoice_date, total_amount, currency, tax_amount, gl_category, approval_status, timestamp, case_id, items_summary, vendor_tax_id, processed_at High Accuracy**: Low false-positive rate using combined AI guardrails + subject filtering Quick Setup**: Example nodes and credentials pre-configured in the template Included Nodes & Flow Highlights On form submission (date picker trigger) → Get Email Content (Gmail) → Guardrail: Is Finance? (LangChain Guardrails) → IF (Guardrail Passed) → Filter Finance Keywords → AI Agent (Email OCR) → Validate Extraction → Check for Errors → Apply Finance Rules → Log to Invoices Sheet (Google Sheets) (Full node list and configuration included in the template.) Requirements & Credentials Gmail OAuth2 (read access)** — for fetching emails OpenAI API key (or compatible LLM)** — for guardrails & extraction Google Sheets OAuth2** — to append rows to the invoice sheet Recommended: Use the Google Sheet ID included in the template, or replace it with your own Sheet ID and gid. Quick Setup Guide 👉 Demo & Setup Video Import the template into n8n Connect and authorize credentials: Gmail, Google Sheets, OpenAI (or preferred LLM) Update the Google Sheet ID / sheet gid if using your own sheet (Optional) Adjust the Guardrail topicalAlignment threshold or filter keywords Test using the form trigger or a single email, then enable the workflow Configuration Tips The extraction agent outputs a strict JSON schema — keep it for reliable downstream mapping Use a low LLM temperature (0.2) for deterministic extraction For non-USD currencies, ensure your accounting system supports the currency field or add a conversion step For high-volume inboxes, enable batching or rate-limit the Gmail node to avoid API quota issues Privacy & Security This template processes real email content and financial data — store credentials securely Restrict access to the n8n instance to authorized users only Review data-retention policies if using a hosted LLM service Example Use Cases Auto-log vendor invoices from email into an accounting Google Sheet Build an audit trail with case IDs for finance teams Preprocess incoming receipts before forwarding to AP tools or ERPs Tags (Recommended) finance, invoices, email, ai, ocr, google-sheets, automation, accounting, n8n-template

Facebook Page Comment Moderation Scoreboard → Team Report This workflow automatically monitors Facebook Page comments, analyzes them using AI for intent, toxicity & spam, stores moderation results in a database and sends a clear summary report to Slack and Telegram. This workflow runs every few hours to fetch Facebook Page comments and analyze them using OpenAI. Each comment is classified as positive, neutral or negative, checked for toxicity, spam & abusive language and then stored in Supabase. A simple moderation summary is sent to Slack and Telegram. You receive: Automated Facebook comment moderation AI-based intent, toxicity, and spam detection Database logging of all moderated comments Clean Slack & Telegram summary reports Ideal for teams that want visibility into comment quality without manually reviewing every message. Quick Start – Implementation Steps Import the workflow JSON into n8n. Add your Facebook Page access token to the HTTP Request node. Connect your OpenAI API key for comment analysis. Configure your Supabase table for storing moderation data. Connect Slack and Telegram credentials and choose target channels. Activate the workflow — moderation runs automatically. What It Does This workflow automates Facebook comment moderation by: Running on a scheduled interval (every 6 hours). Fetching recent comments from a Facebook Page. Preparing each comment for AI processing. Sending comments to OpenAI for moderation analysis. Extracting structured moderation data: Comment intent Toxicity score Spam detection Abusive language detection Flagging risky comments based on defined rules. Storing moderation results in Supabase. Generating a summary report. Sending the report to Slack and Telegram. This ensures consistent, repeatable moderation with no manual effort. Who’s It For This workflow is ideal for: Social media teams Community managers Marketing teams Customer support teams Moderation and trust & safety teams Businesses managing high-volume Facebook Pages Anyone wanting AI-assisted comment moderation Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Facebook Page access token** OpenAI API key** Supabase project and table** Slack workspace** with API access Telegram bot** and chat ID Basic understanding of APIs and JSON (helpful but not required) How It Works Scheduled Trigger – Workflow starts automatically every 6 hours. Fetch Comments – Facebook Page comments are retrieved. Prepare Data – Comments are formatted for processing. AI Moderation – OpenAI analyzes each comment. Normalize Results – AI output is cleaned and standardized. Store Data – Moderation results are saved in Supabase. Aggregate Stats – Summary statistics are calculated. Send Alerts – Reports are sent to Slack and Telegram. Setup Steps Import the workflow JSON into n8n. Open the Fetch Facebook Page Comments node and add: Page ID Access token Connect your OpenAI account in the AI moderation node. Create a Supabase table and map fields correctly. Connect Slack and select a reporting channel. Connect Telegram and set the chat ID. Activate the workflow. How To Customize Nodes Customize Flagging Rules Update the normalization logic to: Change toxicity thresholds Flag only spam or abusive comments Add custom moderation rules Customize Storage You can extend Supabase fields to include: Language AI confidence score Reviewer notes Resolution status Customize Notifications Slack and Telegram messages can include: Emojis Mentions (@channel) Links to Facebook comments Severity labels Add-Ons (Optional Enhancements) You can extend this workflow to: Auto-hide or delete toxic comments Reply automatically to positive comments Detect language and region Generate daily or weekly moderation reports Build dashboards using Supabase or BI tools Add escalation alerts for high-risk comments Track trends over time Use Case Examples 1. Community Moderation Automatically identify harmful or spam comments. 2. Brand Reputation Monitoring Spot negative sentiment early and respond faster. 3. Support Oversight Detect complaints or frustration in comments. 4. Marketing Insights Measure positive vs negative engagement. 5. Compliance & Auditing Keep historical moderation logs in a database. Troubleshooting Guide | Issue | Possible Cause | Solution | |-----|---------------|----------| | No comments fetched | Invalid Facebook token | Refresh token & permissions | | AI output invalid | Prompt formatting issue | Use strict JSON prompt | | Data not saved | Supabase mapping mismatch | Verify table fields | | Slack message missing | Channel or credential error | Recheck Slack config | | Telegram alert fails | Wrong chat ID | Confirm bot permissions | | Workflow not running | Trigger disabled | Enable Cron node | Need Help? If you need help customizing, scaling or extending this workflow — such as advanced moderation logic, dashboards, auto-actions or production hardening, then our n8n workflow development team at WeblineIndia can assist with expert automation solutions.

How It Works This workflow automates end-to-end marketing campaign management for digital marketing teams and agencies executing multi-channel strategies. It solves the complex challenge of coordinating personalized content across email, social media, and advertising platforms while maintaining brand consistency and optimizing engagement. The system processes scheduled campaign triggers through AI-powered content generation and personalization engines, then intelligently distributes tailored messages across six parallel channels: email campaigns, social media posts, paid advertising, influencer outreach, content marketing, and performance analytics. Each channel receives audience-specific messaging optimized for platform requirements, engagement patterns, and conversion objectives. This eliminates manual content adaptation, ensures consistent campaign timing, and delivers data-driven personalization at scale. Setup Steps Configure campaign schedule trigger or webhook integration with marketing automation platform Add AI model API credentials for content generation, personalization, and A/B testing optimization Connect email service provider with segmented audience lists and template configurations Set up social media management platform APIs for Facebook, Instagram, LinkedIn Integrate advertising platforms (Google Ads, Meta Ads) with campaign tracking parameters Prerequisites Marketing automation platform access, AI service API keys, email service provider account Use Cases Product launch campaigns coordinating announcements across channels Customization Adjust AI prompts for brand voice consistency, modify channel priorities based on audience preferences Benefits Reduces campaign setup time by 80%, ensures consistent messaging across all channels

Description This n8n template generates high-quality, platform-ready hashtags for beauty and skincare brands by combining AI, live website analysis, and current social media trends. It is designed for marketers, agencies, and founders who want smarter hashtag strategies without manual research. Use cases Beauty & skincare brands building social media reach Agencies managing multiple client accounts Content teams creating Instagram, LinkedIn, or Facebook posts Founders validating brand positioning through hashtags What this template demonstrates Form-based user input in n8n Website scraping with HTTP Request AI-driven brand analysis using Gemini Structured AI outputs with output parsers Live trend research using search tools Automated storage in Google Sheets How it works Users submit brand details through a form. The workflow scrapes the brand’s website, analyzes it with AI, generates tailored hashtags, enriches them with platform-specific trends, and stores the final result in Google Sheets. How to use Activate the workflow Open the form URL Enter brand details and website URL Submit the form View generated hashtags in Google Sheets Requirements Google Gemini API credentials Google Sheets account SerpAPI account for trend research Good to know Website scraping is best suited for public, text-rich sites Hashtags are generated dynamically based on brand tone and audience You can reuse the Google Sheet as a hashtag library Customising this workflow Change the number of hashtags generated Modify the AI prompt for different industries Add filters for banned or restricted hashtags Extend the workflow to auto-post to social platforms

Who’s it for This template is perfect for content creators, marketers, solopreneurs, agencies, and social media strategists who want to understand what audiences are talking about online. It helps teams quickly turn broad topics into structured insights, trend opportunities, and actionable content ideas. What it does / How it works This workflow begins with a form where the user enters a single topic. An AI agent expands the topic into subtopics and generates multiple relevant keywords. For each keyword, the workflow automatically gathers content from Reddit and X (formerly Twitter), extracting posts, titles, text, engagement metrics, and links. Each collected post is then analyzed by an AI model to determine: Trend potential Audience relevance Platform suitability Recommended content formats Categories and keywords Once all posts are processed, a final AI agent synthesizes the results, identifies the strongest emerging trends, groups similar insights, and generates strategic content recommendations. Requirements Google Gemini (PaLM) API credentials X / Twitter OAuth2 credentials Access to the n8n Form Trigger (publicly accessible URL) How to set up Connect your Gemini API and Twitter API credentials. Make sure the Form Trigger node is accessible. Review and adjust the AI prompts if you want different output formats. Run the form, enter a topic, and execute the workflow. How to customize the workflow Add more platforms (YouTube, TikTok, Instagram, Hacker News) Add sentiment scoring or engagement ranking Export insights to Google Sheets or Notion Generate ready-to-post content from the trends

This n8n template acts as your automated social media data analyst. Instead of manually checking your analytics across different dashboards every week, this workflow scrapes your latest stats, calculates your week-over-week growth, and uses AI to write a strategic performance report delivered straight to your inbox. Use cases are many: Perfect for content creators tracking growth, agencies managing client reporting, or community managers monitoring Skool engagement alongside social channels. Good to know First Run Setup:* Since this workflow calculates *growth (Current vs. Last Week), it needs a baseline to start. You will need to manually add one row to the linked Airtable template with your current stats before the first scheduled run. Cost:** This uses the Apify API for scraping TikTok and OpenRouter for the LLM analysis. Costs are generally very low (pennies per run), but you will need active accounts for both. How it works Data Collection: Every Sunday, the workflow triggers and pulls your live follower counts from YouTube, TikTok, and Skool. It also grabs the transcripts and stats for every video you posted in the last 7 days. Growth Calculation: It searches your Airtable database for the previous week's record and compares it against the live numbers to calculate exactly how many subscribers and followers you gained. AI Analysis: The data and video transcripts are fed into an LLM (via OpenRouter). The AI analyzes why certain videos performed well based on the content, identifying trends and engagement patterns. Reporting: The LLM generates a clean, formatted HTML report. Delivery & Archiving: The workflow emails the report to you and saves the new raw data into Airtable to serve as the baseline for next week. How to use The workflow is set to run weekly (Sundays), but you can change the Schedule Trigger to whatever day you prefer to receive reports. You will need to configure the CONFIG node at the start with your specific profile URLs and Channel IDs so the scrapers know where to look. Link to the required Airtable template is included in the workflow sticky notes. Requirements n8n** (Self-hosted recommended) Apify** account (for TikTok and Skool scraping) Google Cloud** project (for YouTube Data API) OpenRouter** or OpenAI API key Airtable** account Gmail** account Customising this workflow You can easily swap out the LLM model in the OpenRouter node if you prefer a specific model (like Claude 3.5 Sonnet or GPT-4o) for the analysis. You could also add more platforms like LinkedIn or Instagram if you have the appropriate Apify actors or API credentials.

Never let an event go unpromoted. This workflow monitors your Google Calendar, generates branded promotional graphics, and schedules a staggered social media countdown across LinkedIn, Twitter/X, and Facebook. 🎯 What This Workflow Does This template automates the full lifecycle of event promotion—from creation to multi-platform publishing. 📅 Step 1 — Calendar Trigger & Intelligence Instant Trigger:** Fires when a new event is created in Google Calendar Data Enrichment:** Extracts title, location, and formatted date/time Safety Gate:** Skips events starting in less than 2 hours 🖼️ Step 2 — Programmatic Design & CDN Hosting Dynamic Graphic Creation:** Uses Edit Image node to overlay event details on a banner CDN Hosting:** Uploads the image via UploadToURL to generate a public URL Schedule Calculation:** Sets post timings at 48h, 24h, and 1h before the event 🔁 Step 3 — Staggered Countdown & AI Copy Loop Execution:** Iterates through each scheduled post time Smart Wait:** Delays execution until the exact posting time AI Captions:** Generates time-based captions using OpenAI 📊 Step 4 — Audit Logging & Admin Alerts Google Sheets Log:** Stores platform status and image URLs for each post Telegram Alerts:** Sends a final campaign summary to the admin ✨ Key Features Automated Graphic Design:** Creates visuals for every event Persistent Wait Logic:** Handles long delays within a single workflow Multi-Platform Posting:** Publishes to LinkedIn, Twitter/X, and Facebook CDN Media Bridge:** UploadToURL ensures valid public image URLs 🔧 Setup Requirements Required Integrations Google Calendar:** OAuth2 credentials Social Platforms:** LinkedIn, Twitter/X, Facebook Page credentials OpenAI:** API key for captions Google Sheets:** Sheet for logging UploadToURL:** API key Telegram:** Bot token and chat ID Required Assets Public URL of your base banner template image Automate your event marketing. Import this template and connect your Google Calendar to start promoting events effortlessly!

Transcript → AI Analysis → Formatted Doc This workflow automatically converts Fathom meeting transcripts into beautifully formatted Google Docs with AI-generated summaries, key points, decisions, and action items. Good to know Works fully with Fathom free account Webhook responds immediately to prevent Fathom timeout and duplicate triggers Validates transcript quality (3+ conversation turns) before AI processing to save costs Uses Google Gemini API (generous free tier and rate limits, typically enough to avoid paying for API requests, but check latest pricing at Google AI Pricing) Creates temporary HTML file that's auto-deleted after conversion Who's it for Individuals or teams using Fathom for meetings who want more control and flexibility with their AI meeting analysis and storage independently of Fathom, as well as automatic, formatted documentation without manual note-taking. Perfect for recurring syncs, client meetings, or interview debriefs. How it works Fathom webhook triggers when meeting ends and sends transcript data Validates transcript has meaningful conversation (3+ turns) Google Gemini AI analyzes transcript and generates structured summary (key points, decisions, actions, next steps) Creates formatted HTML with proper styling Uploads to Google Drive and converts to native Google Doc Reduces page margins for readability and deletes temporary HTML file Requirements Fathom account with API webhook access (available on free tier) Google Drive account (OAuth2) Google Docs account (OAuth2) Google Gemini API key (Get free key here) How to set up Add credentials: Google Drive OAuth2, Google Docs OAuth2, Google Gemini API Copy the webhook URL from the Get Fathom Meeting webhook node (Test URL first, change to Production URL when ready) In Fathom: Settings → API Access → Add → Add webhook URL and select all events including "Transcript" Test with a short meeting, verify Google Doc appears in Drive Activate workflow Customizing this workflow Change save location: Edit "Upload File as HTML" node → update "Parent Folder" Modify AI output: Edit "AI Meeting Analysis" node → customize the prompt to add/remove sections (e.g., risks, follow-ups, sentiment, etc) Adjust document margins: Edit "Reduce Page Margins" node → change margin pixel values Add notifications: E.g. add Slack/Email node after "Convert to Google Doc" to notify team when summary is ready Quick Troubleshooting "Transcript Present?" fails: Fathom must send transcript_merged with 3+ conversation turns (i.e. only send to Gemini for analysis if there's a genuine transcript) HTML as plain text: Check "Convert to Google Doc" uses POST to /copy endpoint 401/403 errors: Re-authorize Google credentials Inadequate meeting notes: Edit prompts in "AI Meeting Analysis" node Sample File and Storage Output Google Doc meeting notes - sample Google Drive sample folder output:

Handle WhatsApp customer inquiries with AI and intent routing (Whatsapp Chatbot) An intelligent, fully customizable WhatsApp customer support chatbot template that works for ANY business - whether you sell fashion, electronics, food, furniture, cosmetics, or anything else. This workflow combines pre-built responses for common queries with AI for complex questions, creating a cost-effective 24/7 customer support solution that adapts to your specific products and services. Who it's for This universal template works for ANY business type: E-commerce stores** (fashion, electronics, home goods, beauty, etc.) Local retail shops** (boutiques, grocery stores, bookshops, etc.) Service businesses** (salons, repair services, consultancies, etc.) Restaurants & cafes** (food delivery, reservations, menu inquiries) Any business** using WhatsApp Business API for customer communication What it does This is a UNIVERSAL template - it works for ANY business by simply updating the product categories, company information, and response templates. No coding knowledge required for basic customization! The workflow automates WhatsApp customer support through intelligent routing and AI assistance: Receives WhatsApp messages via WhatsApp Business API webhook trigger Parses message data extracting user info, chat ID, and message text Classifies intent using pattern matching to determine what the customer wants (product inquiry, contact info, support, greeting, etc.) Routes intelligently to the most appropriate response handler: Product inquiries → Pre-built catalog responses with pricing and links Contact information → Static company details (address, phone, hours) Complex queries → AI agent with full company context Maintains conversation context using memory to remember previous messages Sends formatted responses back to the customer via WhatsApp with markdown formatting The hybrid approach (pre-built responses + AI) balances speed, cost, and intelligence - common questions get instant answers while complex queries receive personalized AI assistance. How to set up Requirements You'll need: WhatsApp Business API** access (via Twilio, 360Dialog, Meta Cloud API, or other providers) Google Gemini API key** (for AI responses) - Get API key Google Docs** (optional - for product catalog reference) n8n instance** with WhatsApp nodes installed Setup Steps Configure WhatsApp Business API Sign up with a WhatsApp Business API provider (Twilio, 360Dialog, or Meta) Get your API credentials (phone number ID, access token, webhook verify token) Add credentials to n8n's WhatsApp node Copy the webhook URL from n8n and configure it in your provider's dashboard Customize Company Information Open the "Build AI System Prompt" node Replace all placeholder text with your actual company details: Company name Address and phone numbers Email and website Product categories and brands Policies (COD, warranty, returns, delivery) Store hours Configure Product Responses Edit the "Generate Product Response" node Replace the sample products with your actual catalog: Product names and specifications Prices (update currency if not using INR) Product URLs from your website Add/remove product categories as needed Update Contact Details Edit the "Generate Contact Info Response" node Add your complete contact information Update store hours and addresses Set Up AI Credentials Add your Google Gemini API key to the credential manager (Optional) Connect Google Docs if you want to use a product catalog document Activate and Test Activate the workflow in n8n Send test messages to your WhatsApp Business number Test different intents: greetings, product questions, contact requests Verify responses are accurate and timely WhatsApp Business API Providers Option 1: Meta Cloud API (Official, free for moderate usage) Sign up at: https://developers.facebook.com/ Requires Facebook Business account Best for: Small to medium businesses Option 2: Twilio (Reliable, paid service) Sign up at: https://www.twilio.com/whatsapp Pay-per-message pricing Best for: Businesses needing high reliability Option 3: 360Dialog (WhatsApp-focused) Sign up at: https://www.360dialog.com/ Competitive pricing Best for: WhatsApp-heavy businesses Option 4: MessageBird, Vonage, others Various pricing and features Research and compare based on your needs How it works Intent Classification System The workflow uses keyword pattern matching to classify user intent into these categories: Priority 1: Contact Information (highest priority) Triggers: "where is store", "address", "contact", "phone number" Response: Static contact details Why first: Users asking for contact info need immediate, accurate answers Priority 2: Greetings Triggers: "hi", "hello", "hey", "good morning" Response: Friendly welcome with menu options Helps: Sets a positive tone for the conversation Priority 3: Product Inquiries Triggers: Category keywords (monitor, processor, GPU, RAM, etc.) Response: Pre-built catalog with products, prices, and links Categories: Customizable based on your products Priority 4: AI Fallback Triggers: Everything else (comparisons, complex questions, multi-step queries) Response: Google Gemini AI with company knowledge Features: Conversation memory, personalized recommendations Response Architecture Pre-Built Responses (Fast & Cost-Effective) Instant answers (no API calls) Handles 70-80% of queries Consistent, accurate information No ongoing costs Used for: Product lists, contact info, FAQs AI Agent (Intelligent & Flexible) Handles complex questions Maintains conversation context Provides personalized recommendations Adapts to different query styles Used for: Comparisons, custom builds, technical questions Conversation Memory The workflow uses buffer window memory to remember recent conversation: Stores last 10 messages per user Enables multi-turn conversations AI can reference previous questions Creates more natural interactions Memory is user-specific (isolated by user ID) Message Flow Example User: "Hi" → Intent: greeting → Response: Welcome message with menu User: "Show me monitors" → Intent: product_inquiry (monitors) → Response: Pre-built list of monitors with prices User: "Which one is best for gaming?" → Intent: general_inquiry (complex) → Response: AI analyzes previous context (monitors) and recommends gaming-focused option User: "What's your address?" → Intent: contact_info → Response: Complete contact details How to customize the workflow STEP 1: Customize Product Categories The workflow comes with example categories for multiple business types. Replace them with YOUR categories: For a Fashion Store: const categories = [ { pattern: /(shirt|tshirt|top)/i, category: 'tops' }, { pattern: /(jeans|pants|trousers)/i, category: 'bottoms' }, { pattern: /(dress|gown|kurti)/i, category: 'dresses' }, { pattern: /(shoe|footwear|heels)/i, category: 'shoes' }, ]; For a Grocery Store: const categories = [ { pattern: /(vegetable|veggies)/i, category: 'vegetables' }, { pattern: /(fruit|fruits)/i, category: 'fruits' }, { pattern: /(dairy|milk|cheese)/i, category: 'dairy' }, { pattern: /(snack|chips|biscuit)/i, category: 'snacks' }, ]; For a Beauty/Cosmetics Store: const categories = [ { pattern: /(skincare|cream|serum)/i, category: 'skincare' }, { pattern: /(makeup|lipstick|foundation)/i, category: 'makeup' }, { pattern: /(perfume|fragrance)/i, category: 'perfumes' }, { pattern: /(hair|shampoo|conditioner)/i, category: 'haircare' }, ]; For a Home Furniture Store: const categories = [ { pattern: /(sofa|couch)/i, category: 'sofas' }, { pattern: /(bed|mattress)/i, category: 'bedroom' }, { pattern: /(table|desk|dining)/i, category: 'tables' }, { pattern: /(chair|seating)/i, category: 'chairs' }, ]; For a Restaurant: const categories = [ { pattern: /(pizza|italian)/i, category: 'italian' }, { pattern: /(burger|sandwich)/i, category: 'fast_food' }, { pattern: /(biryani|curry|indian)/i, category: 'indian' }, { pattern: /(dessert|sweet|ice cream)/i, category: 'desserts' }, ]; STEP 2: Customize Product Responses Update the "Generate Product Response" node with YOUR actual products: Example for Fashion Store: if (category === 'tops') { response = Hi ${userName}! Check out our TOPS collection:\\n\\n; response += 👕 Cotton Casual T-Shirt\\n 💰 ₹499\\n 🎨 5 colors available\\n 🔗 yourstore.com/tshirts\\n\\n; response += 👚 Formal Shirt\\n 💰 ₹899\\n 🎉 Buy 2 Get 20% OFF\\n 🔗 yourstore.com/shirts\\n\\n; } Example for Grocery Store: if (category === 'vegetables') { response = Fresh VEGETABLES available, ${userName}:\\n\\n; response += 🥕 Fresh Carrots (1kg)\\n 💰 ₹40\\n 🌱 Organic\\n\\n; response += 🍅 Tomatoes (1kg)\\n 💰 ₹30\\n ✅ Farm Fresh\\n\\n; } Example for Restaurant: if (category === 'italian') { response = Delicious ITALIAN dishes, ${userName}:\\n\\n; response += 🍕 Margherita Pizza\\n 💰 ₹299\\n 👨‍🍳 Chef's Special\\n\\n; response += 🍝 Creamy Alfredo Pasta\\n 💰 ₹349\\n 🔥 Bestseller\\n\\n; } STEP 3: Update Company Information Edit the "Build AI System Prompt" node: For a Boutique: const systemPrompt = `You are a customer service assistant for Elegant Threads Boutique. COMPANY INFORMATION: Business: Women's Designer Clothing Boutique Products: Ethnic wear, western wear, accessories Price Range: ₹1,500 - ₹15,000 Speciality: Custom tailoring available Store Address: Shop 12, Fashion Street, Mumbai Phone: +91 98XXXXXXXX Delivery: Pan-Mumbai, 2-3 days Returns: 7-day no-questions-asked return policy `; For a Tech Store: const systemPrompt = `You are customer support for TechHub Electronics. COMPANY INFORMATION: Business: Consumer Electronics Retailer Products: Smartphones, laptops, accessories, home appliances Price Range: ₹500 - ₹2,00,000 Speciality: Same-day delivery in Delhi NCR Warranty: Extended warranty on all electronics Store: Connaught Place, New Delhi Phone: +91 11-XXXXXXXX `; For a Bakery: const systemPrompt = `You are the assistant for Sweet Delights Bakery. COMPANY INFORMATION: Business: Fresh Baked Goods & Custom Cakes Products: Cakes, pastries, cookies, bread Price Range: ₹50 - ₹3,000 Speciality: Custom cakes for all occasions (24hrs notice) Store: Baker Street, Bangalore Phone: +91 80-XXXXXXXX Delivery: Free above ₹500 within 5km `; Additional Customization Options Change AI Model Replace Google Gemini with other LLM providers: OpenAI GPT-4**: Best for nuanced understanding Anthropic Claude**: Strong at following instructions Llama** (self-hosted): Cost-effective for high volume Simply swap the "Google Gemini Chat Model" node with your preferred model. Add More Intents Extend the intent classification in the "Classify User Intent" node: // Add order tracking if (/track.order|order.status|where.*order/i.test(text)) { intent = 'order_tracking'; } // Add complaint handling if (/complaint|unhappy|problem|issue|refund/i.test(text)) { intent = 'complaint'; } // Add shipping questions if (/shipping|delivery|courier|when.*arrive/i.test(text)) { intent = 'shipping_inquiry'; } Then add corresponding response nodes in the routing switch. Integrate with CRM Connect to HubSpot: Add HubSpot node after intent classification Log every conversation as a ticket Create contacts automatically Track customer journey Connect to Salesforce: Use Salesforce node to create leads Update opportunity stages based on intent Log interactions in Activity History Connect to Airtable: Store conversations in Airtable database Analyze common questions Build knowledge base from real conversations Add Multi-Language Support Method 1: Google Translate API Detect message language Translate to English for processing Translate response back to user's language Method 2: Multilingual AI Add language preference to AI prompt Train AI on multilingual responses Support major languages natively Rich Media Responses Send images: return [{ chatId: chatId, image: 'https://yoursite.com/product.jpg', caption: 'Check out this product!' }]; Send documents: Product catalogs (PDF) Warranty cards Invoice copies Installation guides Send location pins: Store locations Delivery tracking Service centers Human Handoff Logic Add escalation for complex issues: // Check if AI can't help if (complexityScore > 8 || sentiment === 'angry') { // Notify human agent // Transfer conversation // Set status: 'awaiting_agent' } Integrate with: Intercom for live chat handoff Slack for agent notifications Zendesk for ticket creation Connect to Inventory Real-time stock checking: Query your database for availability Show "In Stock" / "Out of Stock" status Suggest alternatives for unavailable products Notify customers when items are restocked Dynamic pricing: Pull current prices from database Apply promotional discounts automatically Show time-sensitive offers Add Analytics Track metrics: Messages per day/week/month Most common intents AI usage vs. pre-built responses Average response time Customer satisfaction scores Integration options: Google Analytics for website tracking Mixpanel for event tracking Custom dashboard in Grafana Google Sheets for simple logging Business Hours Management Add business hours logic: const now = new Date(); const hour = now.getHours(); const isBusinessHours = (hour >= 10 && hour < 20); // 10 AM - 8 PM if (!isBusinessHours) { return [{ response: "We're currently closed. Our hours are 10 AM - 8 PM. We'll respond when we open!" }]; } A/B Testing Responses Test different response styles: Formal vs. casual tone With/without emojis Short vs. detailed answers Different CTAs Track which versions lead to more sales/conversions. Tips for best results 1. Start Simple Begin with 3-5 main intents Add more as you see common patterns Don't over-complicate the initial setup 2. Monitor and Iterate Review conversations weekly Identify missed intents Refine pattern matching Update product information regularly 3. Balance Pre-Built vs. AI Use pre-built for: FAQs, product lists, contact info (fast, cheap) Use AI for: Comparisons, complex queries, personalization (slower, costs money) Aim for 70-80% pre-built, 20-30% AI 4. Optimize Response Times Pre-built responses are instant AI responses take 2-5 seconds Set user expectations ("Let me check that for you...") 5. Test Different Scenarios Happy path (normal inquiries) Edge cases (misspellings, slang) Multi-turn conversations Multiple topics in one message 6. Keep Responses Concise WhatsApp users prefer short messages Use formatting (bold, bullets) for readability Break long responses into multiple messages 7. Maintain Brand Voice Customize AI system prompt with your brand personality Use consistent tone across all responses Include brand-appropriate emojis 8. Handle Failures Gracefully Add error handling for API failures Have fallback responses ready Always offer human contact option 9. Respect Privacy Don't store sensitive information Comply with GDPR/local privacy laws Allow users to delete their data 10. Monitor Costs Track Gemini API usage Set spending alerts Optimize prompt length to reduce token usage Common use cases across industries Fashion & Apparel Store Answer size and fit questions Share new collection arrivals Check stock availability by size/color Process exchange requests Share styling tips Electronics & Tech Store Provide product specifications Compare different models Check warranty information Share installation guides Handle technical support queries Grocery & Food Store Check product availability Share daily fresh stock updates Take bulk orders Provide recipe suggestions Handle delivery slot bookings Beauty & Cosmetics Recommend products for skin types Share ingredient information Explain usage instructions Handle shade/color queries Process return for wrong products Home Furniture Store Share dimensions and specifications Check delivery timelines Provide assembly instructions Schedule store visits Custom furniture inquiries Restaurant & Cafe Share menu and prices Take table reservations Handle takeaway orders Answer dietary restriction questions Share daily specials Jewelry Store Share designs and prices Book appointments for trials Check customization options Verify metal purity/certifications Handle repair inquiries Bookstore Check book availability Take pre-orders for new releases Recommend books by genre Share reading lists Handle exchange requests Important Notes: This workflow requires WhatsApp Business API (not regular WhatsApp Business app) WhatsApp Business API typically requires business verification Message rates and limits vary by provider Test thoroughly before deploying to customers Always provide a way to reach human support Getting Started Tip: Start with just contact info and product inquiries. Once that works smoothly, add AI responses for complex queries. Gradually expand based on actual customer needs you observe in conversations.

Heygen Viral UGC Generation Stop manually creating short-form video content. This n8n workflow automatically generates AI talking-head UGC videos using HeyGen and publishes them to Instagram and Facebook every single day — fully on autopilot. Real reel posted to @pinkmatchaprints — generated and published entirely by this workflow. See It In Action: Real Results from Pink Matcha Watch a live reel generated by this workflow See all published reels on @pinkmatchaprints Every single one of these videos was generated and posted automatically — no recording, no editing, no manual uploading. How It Works The workflow runs every day on a schedule. Here's the full pipeline: Picks today's content from a Google Sheet using a day-of-year rotation across all rows marked Idea Randomly selects a HeyGen talking-photo avatar from a pool of 14 for visual variation across posts Generates a 30-second script using GPT-4.1-mini with a warm, spiritual persona called "The Shepherd" Submits to HeyGen API to render a 720x1280 portrait talking-head video Polls HeyGen every 50 seconds (up to 20 times, ~16 min max) until the video is ready Publishes to Instagram and Facebook via upload-post.com with an auto-generated caption Logs every step to a Production Logs Google Sheet — script, video ID, video URL, and status What You're Getting AI-Generated Scripts with a Defined Persona The workflow uses GPT-4.1-mini with a custom system prompt called "The Shepherd" — a calm, wise, spiritual guide. Every script is: 75 to 90 words (~30 seconds when spoken naturally) Written in warm, grounded, accessible language Tailored to the specific content section from your workbook Always ending with: "Visit the link in bio to learn more." A Content Rotation System That Never Repeats Your content pool lives in a Google Sheet. The workflow selects today's section using day-of-year modulo total rows — so it automatically cycles through your content library without manual scheduling. Add more rows to expand the rotation. Full Production Logging Every execution is tracked row by row in a Production Logs sheet. You can see exactly what ran, what script was used, what the HeyGen video ID is, and what the final status is. Async Video Generation with Smart Polling HeyGen renders videos asynchronously. The workflow handles this gracefully — it submits the job, waits, polls the status API, and routes automatically based on the result: Still processing** → waits and retries Completed** → extracts video URL and posts Failed or timed out** → logs the failure reason to the sheet Dual Platform Publishing Videos are published to both Instagram and Facebook in one execution using upload-post.com. The caption is auto-built from the section title and first 100 characters of the script. Google Sheets Structure The workflow uses a single Google Sheets workbook with two tabs: Tab 1: Workbook Content Your content pool. The workflow reads from this every day. | Column | Description | |---|---| | section_title | Title used in the video caption and script prompt | | workbook_content | Full context for the AI to generate the script from | | key_message | The core takeaway — passed to the AI as emphasis | | Status | Set to Idea to include in rotation. Any other value skips the row. | Tab 2: Production Logs Auto-populated. Do not edit manually. | Column | Description | |---|---| | Date | Date the video was generated | | Section Title | Which content section was used | | Script Text | The generated script | | HeyGen Video ID | Used to poll render status | | Raw Video URL | Direct HeyGen video URL | | Final Video URL | Final URL passed to the publishing step | | Status | Lifecycle status or failure reason | Setup Guide Step 1: Credentials | Service | Credential Type | Where Used | |---|---|---| | HeyGen | HTTP Header Auth (X-Api-Key) | Generate and poll videos | | upload-post.com | HTTP Header Auth | Post to Instagram / Facebook | | Google Sheets | OAuth2 | Read content, write logs | | OpenAI | API Key | Generate scripts (GPT-4.1-mini) | Step 2: Google Sheets Duplicate the workbook structure described above Replace the documentId in all Google Sheets nodes with your spreadsheet ID Populate the Workbook Content tab and set Status = Idea on each row Step 3: HeyGen Avatars The workflow ships with 14 hardcoded talking-photo avatar IDs in the Code: Select Random Avatar & Combine Data node. Replace these with your own HeyGen avatar IDs from your HeyGen account. Step 4: upload-post.com Account Update the user field in both the facebook and instagram nodes from pink-matcha to your upload-post.com username. Step 5: Enable Facebook (When Ready) The facebook node is disabled by default. Once you confirm Instagram is posting correctly, enable it in n8n. Step 6: Adjust the Schedule The trigger is set to fire daily at 12pm noon. The node name says "9am" — rename or adjust the time in the Schedule node to match your target posting time. Technical Specs Script AI**: OpenAI GPT-4.1-mini Video Generation**: HeyGen v2 API (talking-photo avatars) Video Format**: 720x1280 portrait (Reels / Shorts) Polling**: 50-second intervals, max 20 attempts (~16 min timeout) Publishing**: upload-post.com multipart API Logging**: Google Sheets (OAuth2) Error Workflow**: Separate n8n error workflow for unexpected crashes Platform**: n8n (self-hosted or cloud) Frequently Asked Questions Q: Do I need a HeyGen subscription? A: Yes. You need a HeyGen account with API access and at least one talking-photo avatar created in your account. Q: What is upload-post.com? A: A third-party service that handles posting video content to Instagram and Facebook on your behalf. You need an account connected to your social profiles. Q: Can I change the AI persona? A: Yes. Edit the system prompt in the Generate Script node to use any persona, tone, or style you want. Q: Can I post to TikTok or YouTube Shorts? A: upload-post.com supports other platforms. You can add additional HTTP request nodes following the same pattern as the instagram node and change the platform[] parameter. Q: How do I add more content? A: Add rows to the Workbook Content tab in Google Sheets and set Status = Idea. The rotation automatically picks them up. Q: What happens if HeyGen fails? A: The workflow detects failure or timeout and writes the reason to the Production Logs sheet. A separate n8n error workflow handles unexpected crashes. Q: How long does one execution take? A: Typically 5 to 15 minutes end-to-end, depending on HeyGen render time. Join the Community Other free n8n workflows GitHub repository Join AI + Automation Discord Official website Live example account Powered by n8n • OpenAI • HeyGen • Google Sheets • upload-post.com

Never guess your SEO strategy again. This advanced workflow automates the most time-consuming part of SEO: auditing competitor articles and identifying exactly where your brand can outshine them. It extracts deep content from top-ranking URLs, compares it against your specific brand identity, and generates a ready-to-use "Action Plan" for your content team. The workflow uses Decodo for high-fidelity scraping, Gemini 2.5 Flash for strategic gap analysis, and Google Sheets as a dynamic "Brand Brain" and reporting dashboard. ✨ Key Features Brand-Centric Auditing:* Unlike generic SEO tools, this engine uses a live Google Sheet containing your *Brand Identity** to find "Content Gaps" specific to your unique value proposition. Automated SERP Itemization:** Converts a simple list of keywords into a filtered list of top-performing competitor URLs. Deep Markdown Extraction:** Uses Decodo Universal to bypass bot-blockers and extract clean Markdown content, preserving headers and structure for high-fidelity AI analysis. Structured Action Plans:** Outputs machine-readable JSON containing the competitor's H1, their "Winning Factor," and a 1-sentence "Checkmate" instruction for your writers. ⚙️ How it Works Data Foundation: The workflow triggers (Manual or Scheduled) and pulls your Global Config (e.g., result limits) and Brand Identity from a dedicated Google Sheet. Market Discovery: It retrieves your target keywords and uses the Decodo Google Search node to identify the top competitors. A Code Node then "itemizes" these results into individual URLs. Intelligence Harvesting: Decodo Universal scrapes each URL, and an HTML 5 node extracts the body content into Markdown format to minimize token noise for the AI. Strategic Audit: The AI Content Auditor (powered by Gemini) receives the competitor’s text and your Brand Identity. It identifies what the competitor missed that your brand excels at. Reporting Deck: The final Strategy Master Writer node appends the analysis—including the "Content Gap" and "Action Plan"—into a master Google Sheet for your marketing team. 📥 Component Installation This workflow relies on the Decodo node for search and scraping precision. Install Node: Click the + button in n8n, search for "Decodo," and add it to your canvas. Credentials: Use your Decodo API key. (Tip: Use a residential proxy setting for difficult sites like Reddit or Stripe). Gemini: Ensure you have the Google Gemini Chat Model node connected to the AI Agent. 🎁 Get a free Web Scraping API subscription here 👉🏻 https://visit.decodo.com/X4YBmy 🛠️ Setup Instructions 1. Google Sheets Configuration Create a spreadsheet with the following three tabs: Target Keywords**: One column named Target Keyword. Brand Identity**: One cell containing your brand mission, USPs, and target audience. Competitor Audit Feed**: Headers for Keyword, URL, Rank, Winning Factor, Content Gap, and Action Plan. Clone the spreadsheet here. 2. Global Configuration In the Config (Set) node, define your serp_results_amount (e.g., 10). This controls how many competitors are analyzed per keyword. ➕ How to Adapt the Template Competitor Exclusion:* Add a *Filter** node after "Market Discovery" to automatically skip domains like amazon.com or reddit.com if they aren't relevant to your niche. Slack Alerts:* Connect a *Slack** node after the AI analysis to notify your content manager immediately when a high-impact "Action Plan" is generated for a priority keyword. Multi-Model Verification:* Swap Gemini with *Claude 3.5 Sonnet* or *GPT-4o** in the Strategic Audit section to compare different AI perspectives on the same competitor content.