Gmail and WhatsApp Business Cloud integration

📌 Overview This n8n-powered workflow automates the entire lifecycle of real estate lead intake, qualification, routing, assignment, and reporting across multiple channels. It brings WhatsApp inquiries and website form submissions into a single intelligent system, where leads are processed conversationally using AI, deduplicated, normalized, assigned fairly to agents, logged into a centralized CRM, and reported on weekly. Designed specifically for real estate agencies, brokerages, and property teams, this system replaces manual follow-ups, spreadsheet chaos, and uneven agent assignments with a scalable, modular automation that can grow to include Facebook Lead Ads and Google Lead Forms without breaking downstream logic. 🧠 What It Does This workflow automates the full real estate lead pipeline. It: Collects inbound leads from WhatsApp and website forms. Uses AI to extract, validate, and structure lead information. Normalizes all leads into a consistent schema across sources. Detects and prevents duplicate leads (both within-run and CRM-level). Routes leads intelligently based on property interest. Assigns leads fairly using round-robin agent logic. Stores all leads and assignments in a centralized CRM. Sends automated notifications to agents and internal teams. Generates weekly lead, duplicate, and assignment reports. Is designed to be easily extended to Facebook Lead Ads and Google Lead Forms. 💡 Why This Workflow Real estate teams don’t struggle with demand — they struggle with lead management. This workflow was built to solve common real estate problems: Leads lost in WhatsApp chats Duplicate inquiries wasting agent time Uneven lead distribution across agents Manual CRM updates No visibility into weekly lead performance Instead of patching tools together, this workflow provides a single automated system that is reliable, extensible, and client-ready. 👤 Who It’s For This workflow is ideal for: Real estate agencies managing high WhatsApp and form lead inquiry volume Brokerages with multiple agents needing fair lead assignment Property developers handling inbound marketing leads Real estate lead generation teams Automation freelancers building reusable real estate systems ⚙️ How It Works 🧩 1. Lead Intake Workflow 🎯 Purpose Collect inbound leads from multiple channels and normalize them into a unified structure. 🛠 How It Works WhatsApp & Website Triggers Leads enter the system via: WhatsApp messages Website inquiry forms Lead Normalization Regardless of source, all leads are transformed into a common structure: First name, Last name, Phone number, Email, What is your budget range?, and others This ensures new channels (Facebook Lead Ads, Google Lead Forms) can be added later without changing core logic. 🧩 2. AI Lead Processing Workflow 🎯 Purpose Convert unstructured messages into clean, usable lead data. 🛠 How It Works AI Conversation Handling An AI agent processes inbound messages to: Extract missing details Validate lead intent Standardize property interest categories Data Validation Ensures required fields exist before moving forward. 🧩 3. Deduplication Workflow 🎯 Purpose Prevent duplicate leads from entering the system or being reassigned. 🛠 How It Works In-Execution Duplicate Check Prevents the same lead from being processed twice in a single run. CRM-Level Duplicate Detection Checks existing records using: Phone number Email Duplicate leads are flagged and excluded from reassignment while still logged for reporting. 🧩 4. Lead Routing & Agent Assignment Workflow 🎯 Purpose Assign leads fairly and intelligently to agents. 🛠 How It Works Property-Based Routing Leads are routed based on property type (e.g. Single-Family, Multi-Family, Condo). Round-Robin Assignment Agents are rotated automatically to ensure: Fair distribution No manual favoritism Predictable assignment logic 🧩 5. CRM Storage & Notifications Workflow 🎯 Purpose Keep all lead data centralized and notify the right people instantly. 🛠 How It Works CRM Logging (Airtable) Stores: Lead details** Assigned agent Source Deduplicates (Separate table) Timestamps Automated Notifications Sends alerts via: Email Slack So agents can respond immediately. 🧩 6. Weekly Reporting Workflow 🎯 Purpose Provide visibility into lead performance and system health. 🛠 How It Works Runs on a weekly schedule Generates summaries for: Total leads Duplicate leads Agent assignments Can be separated into its own workflow for scalability and reuse. 🛠 How to Set It Up Import the .json file into your n8n instance. Connect the required credentials: WhatsApp Trigger (Auth Connection) WhatsApp Business Cloud (Access Token) OpenAI API Key Airtable API Key (Access Token) Gmail Slack API Key (Access Token) Configure your data sources: Update the Airtable base and table names to match your CRM structure Real Estate Qualifier column names: First name | Last name | Phone number | Email | Location | Property Type | Timeframe | Payment Source | Pre Approved | Has Agent (Yes, No) | Lead (New, Contacted, Follow-up, Converted, Couldn't Convert) | Source | Assigned Agent | Assigned Time | Qualified (Yes, No) | Transcript | Summary Real Estate Qualifier Duplicate column names: First name | Last name | Phone number | Email | Location | Property Type | Timeframe | Payment Source | Pre Approved | Has Agent (Yes, No) | Source Customize business logic: Update agent pools and routing rules Adjust AI prompts if needed Review deduplication and reporting settings Activate the workflow: Click Publish to activate the workflow Send a test lead via WhatsApp or website form to confirm everything works 🎨 Customization Tips Add More Channels**: Plug in Facebook Lead Ads or Google Lead Forms — no restructuring needed. Routing Logic**: Customize routing by location, budget, or property category. CRM Expansion**: Add more fields (Notes, Follow-Up Status, Deal Stage). Reporting**: Extend weekly reports or connect to BI tools. Ads Integration**: Leads can optionally be passed into Facebook or Google Ads workflows after normalization. 📬 Contact For Enquiries: [email protected] Thank you for exploring this workflow!

This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement. Problem Statement & Target Audience Who is this for? This workflow is ideal for: SEO specialists monitoring keyword rankings. Website owners tracking performance. Agencies managing multiple client campaigns. It helps reduce manual effort by automatically checking rankings on a schedule and sending notifications only when there’s movement in position. Pre-conditions & API Requirements APIs & Services Used SerpAPI – Fetch Google search results Get API Key: https://serpapi.com/manage-api-key Docs for usage: SerpAPI Search API Note: Use Generic credential type in n8n for this to work with the preset configuration. Google Sheets API – To store and update keyword data Email API – To notify users of position changes WhatsApp API (e.g., Twilio, Ultramsg) – To send notifications > Setup help for Google Sheets, Email, and WhatsApp is available via the Docs tab in each respective node in n8n. Step-by-Step Workflow Explanation 🗓 1. Scheduled Trigger (Support Workflow) Marks all rows in the sheet as "notchecked" in the checkstatus column. This is the user-defined frequency trigger (e.g. weekly, daily). Triggers the main workflow. 🚀 2. Main Workflow Trigger Starts when a row with checkstatus = notchecked is found. 🔍 3. HTTP Node (SerpAPI Call) Sends a request to SerpAPI for each keyword. Fetches the current Google SERP for that keyword. 🧠 4. JavaScript Node (Parse Position) Loops through the SERP results and finds the position of the target URL. Extracts and returns the current rank. ✍️ 5. Google Sheets Node (Update Data) Writes the new ranking into the spreadsheet. Updates the currentposition and sets checkstatus to "checked". 🔀 6. Switch Node (Compare Rankings) Compares previousposition with currentposition: If rank has improved → send positive alert. If rank has dropped → send negative alert. If unchanged → no alert. 📩 7. Notification Nodes (WhatsApp / Email) Sends a message to chosen channels when a change is detected. Customization Guide ⏱️ Change Frequency Adjust the supporting schedule workflow to change how often the tracker runs. ✉️ Edit Notification Content Customize the WhatsApp and Email message content in their respective nodes. 🔗 Track Multiple URLs per Keyword (Advanced) Extend the JavaScript logic if you need to monitor several pages for the same keyword. 🌐 Expand Search Engine Targets SerpAPI also supports other search engines like Bing and Yahoo. Modify the request params to switch. How to Set Up This Workflow ✅ Step 1: Use This Google Sheets Template To get started quickly, make a copy of the template below: 👉 Google Sheets Template This template includes the required structure: keyword Website_url position timestamp checkstatus > ⚠️ Be sure to make your own copy to edit and connect via the Google Sheets node. 🔐 Step 2: Configure Your APIs SerpAPI:** Get API key from serpapi.com/manage-api-key Set credential type to Generic in n8n for compatibility. Google Sheets, Email & WhatsApp:* Use the instructions found in each node’s Docs tab* to connect your accounts. 📦 Step 3: Import the Workflow Both the main keyword tracking workflow and the supporting scheduler workflow are in one file ▶️ Step 4: The workflow will start Since the check status columns will be 'notChecked' schedule workflow. The update sheets node will update each processed row's checkstatus to 'checked' and the workflow will process the next row the schedule trigger workflow will update checkstatus = notchecked and triggers the keyword tracking automatically. 🎉 Done! From now on, your keyword positions will be monitored at the frequency you set. You’ll receive WhatsApp and/or email updates only when rankings change. in case you need customized workflows or wanna reach out here is my twitter and email.

Get notified when a customer completes a Stripe checkout — including all products they purchased in a single checkout session. Using the Stripe API can be tricky, especially when you're selling multiple products, order bumps, or recommended add-ons in one checkout. This workflow solves that for you. How it works The template listens for successful Stripe checkout events. When a payment is completed, it retrieves all items from the session, including main products, bumps, and extras — and sends a full breakdown straight to your chosen app. You can receive the notification on: Telegram** WhatsApp** Gmail** Or any other chat/notification service you prefer (Slack, Outlook etc. ) Who is this template for? Creators, marketers, and online sellers who: Use Stripe Checkout Want to track what customers are buying in real time Prefer to get notifications instantly instead of digging through Stripe logs How to set up Connect your Stripe account and choose where you want to receive notifications. Adjust the notification text for your preference, and you are done! Everything else is already configured in the template. Check out my other templates 👉 https://n8n.io/creators/solomon/

This workflow implements an AI-powered WhatsApp booking assistant for a hair salon. The system allows customers to book, reschedule, or cancel appointments automatically via text or voice messages on WhatsApp. The workflow supports both text and voice messages. An AI agent manages the conversation logic, determines the user's intent, and calls the appropriate tools to perform actions such as checking availability, creating appointments, rescheduling bookings, or canceling events. The system also includes guardrails to filter unsafe or irrelevant inputs and escalation mechanisms to notify the team when a request falls outside supported tasks. Key Advantages ✅ 24/7 Automated Appointment Booking Customers can book, reschedule, or cancel appointments at any time through WhatsApp without requiring manual staff intervention. ✅ Multi-Modal Communication (Text + Voice) The workflow supports both text messages and voice messages. Audio messages are automatically transcribed and processed by the AI assistant. ✅ Intelligent AI Assistant An AI agent manages the conversation, understands user intent, and automatically performs actions such as checking calendar availability or creating appointments. ✅ Real-Time Calendar Integration The assistant connects directly to Google Calendar to: check available time slots create new bookings update existing appointments cancel reservations This ensures real-time accuracy. ✅ Automatic Client Management Customer information such as phone number, name, and service type is stored and updated in Google Sheets, creating a lightweight CRM database. ✅ Conversation Memory The system stores chat history in PostgreSQL, allowing the AI assistant to maintain context during conversations and deliver a more natural experience. ✅ Smart Error Handling and Escalation If the AI cannot handle a request (for example, a question unrelated to appointments), the workflow automatically: notifies the team via email escalates the conversation for human assistance. ✅ Secure and Controlled AI Responses Guardrails are implemented to prevent irrelevant or unsafe responses, ensuring that the assistant follows defined policies and tasks. ✅ Omnichannel Architecture The workflow is designed to work with: WhatsApp messages chatbot interface (chat trigger) This allows the same logic to power multiple communication channels. ✅ Scalable Automation The system is fully automated and can handle multiple simultaneous conversations, reducing operational workload and improving customer service efficiency. How it works Input Handling (WhatsApp & Chat): It listens for incoming messages from either a WhatsApp Trigger or a Chat Trigger. WhatsApp: It processes both text messages and voice notes. If a voice note is received, it automatically downloads the audio, transcribes it using OpenAI (Whisper), and converts it into text for the AI to process. The user's phone number (for WhatsApp) or session ID (for Chat) is stored as a sessionId to maintain conversation context. Guardrails (Security & Policy): Before the message reaches the main AI agent, it passes through a Guardrails node (using Google Gemini). This acts as a safety filter to check for jailbreak attempts or inappropriate content, ensuring the conversation stays within company policies. AI Agent (The Virtual Assistant): The cleaned-up message is sent to the AI Agent ("Virtual Assistant"). The agent is prompted to act as "Emma" and follows strict instructions: Identify User: It first uses the New client tool to check a Google Sheet to see if the user is already registered. Manage Appointments: Based on the user's request (book, reschedule, cancel), it intelligently calls specific tools in the correct order. Date Logic: It is aware of the current date and time to calculate correct future dates (e.g., interpreting "this Thursday"). Tool Execution (Actions): The agent has access to several tools to perform actions: Google Sheets (New client, Add client): To check if a client exists and add new clients to a spreadsheet. Google Calendar (Get events, Create event, Update event, Delete event): To check availability and manage appointments. The Get events tool is configured to look for slots in the next 30 days. Gmail (Send Email): To notify the team if a user asks for something outside the scope (e.g., pricing, product questions). WhatsApp HITL / Chat HITL (Escalation): To hand over the conversation to a human agent for complex requests. Response Delivery: The AI agent's text response is routed back to the user. On WhatsApp: It intelligently handles the response format. If the original message was text, it sends a text reply. If the original message was a voice note, it uses OpenAI's TTS to convert the text reply into an audio message and sends that back. Setup steps To get this workflow running, you need to configure the following credentials and nodes: Configure Credentials: Google Calendar OAuth2: Connect your Google account (used in Calendar nodes). Google Sheets OAuth2: Connect your Google account to access the spreadsheet. Gmail OAuth2: Connect your Google account to send notification emails from [email protected]. WhatsApp API: Connect your WhatsApp Business API credentials (Phone Number ID). OpenAI API (OpenRouter): Provide your API key for audio transcription and text-to-speech. Google Gemini API: Provide your API keys for the main AI model (Google Gemini Chat Model) and the Guardrails model (Google Gemini Chat Model1). Postgres: Configure the connection to your Postgres database for chat memory. Configure Google Sheets: Create a Google Sheet. Update the Document ID in the New client and Add client nodes with your sheet's ID. Ensure the sheet has columns for Phone Number, Client, and Service. Configure Google Calendar: Verify that the calendar ID in the Calendar nodes is correct and accessible. Configure WhatsApp Triggers & Actions: The WhatsApp Trigger node needs to be connected to your WhatsApp Business App. The Send message and Send audio nodes must have the correct Phone Number ID for your WhatsApp Business number. Update Email Recipient: In the Send Email tool (for escalations), change the sendTo email address from [email protected] to the actual email of the team that should receive these notifications. Review AI Prompts: Open the "Virtual Assistant" (AI Agent) node and review the system message. Update the salon name ("Cuts & Styles"), stylist name ("Alex Carter"), and address to match your business. Check the "Guardrails" node to adjust the safety threshold if necessary. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

How It Works This workflow automates tax compliance monitoring and revenue analysis for accounting teams and finance managers handling multi-source income data. It solves the critical problem of manually tracking revenue streams, identifying tax anomalies, and ensuring regulatory compliance across multiple data sources. The system fetches revenue data from accounting software via MagicCSV, processes it through three specialized AI models for categorization, anomaly detection, and compliance verification, then automatically syncs validated results to accounting systems and sends tax summary reports via email and WhatsApp. This eliminates hours of manual review, reduces compliance errors, and provides real-time tax insights. Setup Steps Configure MagicCSV integration with your accounting software API credentials Add Anthropic API key for categorization, anomaly detection, and compliance models Connect accounting software webhook/API for bidirectional sync Set up Gmail authentication for automated report distribution Configure WhatsApp Business API credentials for instant alerts Prerequisites Anthropic API access, MagicCSV account, accounting software with API capabilities Use Cases Multi-entity corporations tracking cross-border revenue, e-commerce businesses with diverse income streams Customization Modify AI prompts for industry-specific tax rules, add custom anomaly thresholds Benefits Reduces manual tax review time by 80%, minimizes compliance errors through triple AI validation

How it works This workflow automatically detects completed orders in PostgreSQL and prepares them for AI-based post-purchase communication. It enriches each order with customer, product, and payment data, then generates a personalized message using an AI agent. The message is delivered via email and WhatsApp and finally logged in Google Sheets for tracking and auditing. Step-by-step Step 1: Fetch and prepare completed orders for AI processing** Postgres Trigger – Watches the orders table for updates and initiates the workflow. Postgres (Execute query) – Fetches only orders marked as completed. Split In Batches – Loops through completed orders safely and sequentially. Postgres (Execute query) – Retrieves full customer, product, and payment details using joins. AI Agent – Generates a personalized post-purchase message using order data. Groq Chat Model – Supplies the language model used by the AI agent. Merge – Combines AI-generated text with database results for downstream use. Step 2: Deliver messages and log post-purchase communication** Code – Formats AI output into clean email and WhatsApp message templates. Gmail – Sends the post-purchase email to the customer. WhatsApp – Sends the same message via WhatsApp. Set – Flags email and WhatsApp messages as successfully sent. Google Sheets – Appends customer, order, and communication details. Wait – Pauses before continuing to process the next completed order. Why use this? Automates post-purchase communication with zero manual effort. Ensures consistent, personalized messaging across email and WhatsApp. Adapts message tone automatically based on payment status. Creates a centralized audit log in Google Sheets. Scales easily as order volume grows.

The original LLM Council concept was introduced by Andrej Karpathy and published as an open-source repository demonstrating multi-model consensus and ranking. This workflow is my adaptation of that original idea, reimplemented and structured as a production-ready n8n template. Original repository - https://github.com/karpathy/llm-council This n8n template implements the LLM Council pattern: a single user question is processed in parallel by multiple large language models, independently evaluated by peer models, and then synthesized into one high-quality, consensus-driven final answer. It is designed for use cases where answer quality, balance, and reduced single-model bias are critical. 📌 Section 1: Trigger & Input ⚡ When Chat Message Received (Chat Trigger) Purpose: Receives a user’s message and initiates the entire workflow. How it works: A user sends a chat message The message is stored as the Original Question The same input is forwarded simultaneously to multiple LLM pipelines Why it matters: Provides a clean, unified entry point for all downstream multi-model logic. 📌 Section 2: Stage 1 — Parallel LLM Responses 🤖 Basic LLM Chains (x4) Models used: Anthropic Claude OpenAI GPT xAI Grok Google Gemini Purpose: Each model independently generates its own response to the same question. Key characteristics: Identical prompt structure for all models Independent reasoning paths No shared context between models Why it matters: Produces diverse perspectives, reasoning styles, and solution approaches. 📌 Section 3: Stage 2 — Response Anonymization 🧾 Set Nodes (Response A / B / C / D) Purpose: Stores model outputs in an anonymized format: Response A Response B Response C Response D Why it matters: Prevents evaluator models from knowing which LLM authored which response, reducing bias during evaluation. 📌 Section 4: Stage 3 — Peer Evaluation & Ranking 📊 Evaluation Chains (Claude / GPT / Grok / Gemini) Purpose: Each model acts as a reviewer and: Analyzes all four anonymized responses Describes strengths and weaknesses of each Produces a strict FINAL RANKING from best to worst Ranking format (strict): FINAL RANKING: Response B Response A Response D Response C Why it matters: Creates multiple independent quality assessments from different model perspectives. 📌 Section 5: Stage 4 — Ranking Aggregation 🧮 Code Node (JavaScript) Purpose: Aggregates all peer rankings by: Parsing ranking positions Calculating average position per response Counting evaluation occurrences Sorting responses by best average score Output includes: Aggregated rankings Best response label Best average score Why it matters: Transforms subjective rankings into a structured, quantitative consensus. 📌 Section 6: Stage 5 — Final Consensus Answer 🧠 Chairman LLM Chain Purpose: One model acts as the Council Chairman and: Reviews all original responses Considers peer rankings and aggregated scores Identifies consensus patterns and disagreements Produces a single, clear, high-quality final answer Why it matters: Delivers a refined response that reflects collective model intelligence rather than a simple average. 📊 Workflow Overview Stage Node / Logic Purpose 1 Chat Trigger Receive user question 2 LLM Chains Generate independent responses 3 Set Nodes Anonymize outputs 4 Evaluation Chains Peer review & ranking 5 Code Node Aggregate rankings 6 Chairman LLM Final synthesized answer 🎯 Key Benefits 🧠 Multi-model intelligence — avoids reliance on a single LLM ⚖️ Reduced bias — anonymized peer evaluation 📊 Quality-driven selection — ranking-based consensus 🔁 Modular architecture — easy to add or replace models 🌍 Language-flexible — input and output languages configurable 🧩 Production-ready logic — clear stages, deterministic ranking 🚀 Ideal Use Cases High-stakes decision support Complex technical or architectural questions Strategy and research synthesis AI assistants requiring higher trust and reliability Comparing and selecting the best LLM-generated answers

This automated n8n workflow transforms raw CSV data into qualified, enriched lead databases with verified emails and AI-generated personalization. It processes uploaded CSV files through multiple validation, enrichment, and sorting stages before delivering organized results via Google Drive, WhatsApp, or Google Sheets. How It Works Stage 1: Data Intake & Normalization Form Submission: User uploads a CSV/XLSX file and selects: Delivery method (Google Drive, WhatsApp, or Google Sheets with processing) Two personalization prompts for AI-generated messages Column Mapping: The workflow automatically recognizes and standardizes 100+ column name variations into consistent fields Deduplication: Removes duplicate entries by website URL and contact name Initial Filtering: Identifies and flags invalid websites (social media profiles, link shorteners) Stage 2: Data Quality Routing The workflow analyzes each record and routes it based on available data: Route A: Invalid Website → Sends directly to "x Website" sheet Route B: No Website → Verifies existing email and categorizes by validity Route C: Valid Website + Email → Proceeds to email verification and enrichment Route D: Valid Website - Email → Scrapes website to find email addresses. Stage 3: Email Discovery & Verification For records needing enrichment: Website Scraping: Fetches HTML content from company websites Email Extraction: Uses regex patterns to identify email addresses AI Selection: GPT-5-NANO chooses the most relevant email from multiple options Dual Verification: Primary check via Reoon API (deliverability, SMTP, safety) Backup verification if primary fails Personal Email Processing: Separately validates personal emails when present Stage 4: Website Intelligence Gathering Parallel to email processing: Extracts HTML title tags for company context Captures meta descriptions for business understanding Pulls H1 headings for content insight Handles scraping failures gracefully with empty placeholders Stage 5: Email Categorization Logic Records are sorted into buckets: +1 Email**: Has exactly one verified email (business OR personal OR newly found) +2 Email**: Has two or more verified emails Single Source Records**: Only business email OR only personal email Stage 6: AI Personalization For records with verified emails: Context Assembly: Combines name, company, job title, website metadata, industry, keywords AI Processing: Sends to GPT-5-NANO or Gemini with user's custom prompts Structured Output: Generates: Cleaned contact name Shortened company name Personalization message 1 (per user prompt) Personalization message 2 (per user prompt) Stage 7: Final Delivery Based on user's initial selection: Google Drive**: Uploads timestamped CSV, sends email with link WhatsApp**: Converts to XLSX and sends document Google Sheets**: Populates separate sheets by category with completion email How To Use Active n8n instance with required credentials: Google Drive API access Google Sheets API access Gmail API access (for notifications) WhatsApp Business API credentials Reoon Email Verifier API keys OpenAI API key (GPT-5-NANO) Optional: Google Gemini API key Setup Steps Configure Google Sheets Destinations Create or use existing Google Sheets for data categorization: +1 Email Sheet**: Update document ID in "+1 Email" node +2 Email Sheet**: Update document ID in "+2 Email" node x Website Sheet**: Update document ID in "x Website Data" node No Website Sheet**: Update document ID in "- Website +- Email +- Phone Number" node Ensure all sheets have matching column headers as defined in the workflow. Set Up Google Drive Folder Create a destination folder in Google Drive Update the folder ID in the "Upload file" node Ensure the service account has write permissions Configure WhatsApp Add your WhatsApp Business Phone Number ID in the "Send CSV" node Update the recipient phone number (format: +country code) Customize Email Notifications Update sender and recipient emails in "Send a message" and "Send a Success Message" nodes Modify email templates as needed Verify API Keys Check that all API credentials are active: Reoon Email Verifier keys (two instances for redundancy) OpenAI API key for GPT-5-NANO All Google API credentials

How it works This workflow acts as an instant SDR that replies to new inbound leads across multiple channels in real time. It first captures and normalizes all incoming lead data into a unified structure. The workflow then evaluates IST working days and hours, generates a context-aware AI response, and routes the reply to the correct channel. Finally, it logs the full interaction, response status, and timing into Google Sheets. Step-by-step Step 1: Lead intake & normalization** Incomming Lead whatsapp1 – Receives new WhatsApp lead messages via webhook. Incomming Lead facebook1 – Captures incoming Facebook lead messages. Incomming Lead instagram1 – Listens for Instagram lead messages. Incomming Lead linkdin1 – Captures LinkedIn lead messages. Incomming Lead Website1 – Receives website form submissions. Normalize Lead Data6 – Normalizes WhatsApp lead fields. Normalize Lead Data7 – Normalizes Facebook lead fields. Normalize Lead Data8 – Normalizes Instagram lead fields. Normalize Lead Data9 – Normalizes LinkedIn lead fields. Normalize Lead Data5 – Normalizes website lead data. Switch2 – Merges all normalized leads into a single processing path. Step 2: Working hours & AI response** Extract Day and Hours1 – Converts timestamps to IST and extracts day and time. Is Working Day and Working Hour?1 – Determines whether the lead arrived during business hours. Code in JavaScript3 – Builds the AI prompt using lead details and timing context. Get Ai Response1 – Generates a short, human-like response. Step 3: Send reply & log data** Code in JavaScript4 – Combines AI output with normalized lead data. Switch3 – Routes the response based on the source channel. Send message – Sends WhatsApp replies. Send Instagram Message1 – Sends Instagram responses. Send Facebook Messages1 – Sends Facebook replies. Send Linkdin Messages1 – Sends LinkedIn responses. Send a message1 – Sends email replies for website leads. Code in JavaScript5 – Finalizes response status and metadata. google-sheet-name – Appends or updates lead and response data in Google Sheets. Why use this? Replies instantly to leads across all major inbound channels Keeps all lead data standardized and easy to manage Automatically respects IST working days and hours Reduces manual SDR workload without losing response quality Maintains a complete response log for reporting and follow-up

How it works This workflow monitors Meta Ads and Google Ads campaigns on a daily schedule to detect performance drops. It fetches yesterday’s campaign data, standardizes metrics, and calculates CTR and ROAS against fixed benchmarks. Campaigns that fall below thresholds are flagged automatically. Alerts are then sent across multiple channels and all results are logged in Google Sheets for tracking. Step-by-step Step 1: Fetch ad performance data** Schedule Trigger (Daily Ad Check2) – Runs the Meta Ads performance check at the scheduled time. HTTP Request (Fetch Meta Ads Data) – Retrieves campaign metrics from the Meta Ads API. Set (Set Benchmarks) – Normalizes Meta Ads data and assigns platform details. Schedule Trigger (Daily Ad Check3) – Runs the Google Ads performance check at a separate scheduled time. Google Ads (Get many campaigns) – Fetches campaign performance data from Google Ads. Set (Set Benchmarks4) – Normalizes Google Ads data and assigns platform details. Step 2: Detect performance drops** Code (Detect Performance Drop) – Calculates CTR and ROAS, compares them with predefined benchmarks, and flags drops. If – Filters only campaigns where a performance drop is detected. Split In Batches (Loop Over Items) – Processes each affected campaign individually. Step 3: Alert and log results** WhatsApp (Send message1) – Sends instant WhatsApp alerts for critical visibility. Slack (Send a message) – Posts detailed alerts to a Slack channel. Gmail (Send a message4) – Sends email notifications with full campaign metrics. Code (Code in JavaScript) – Recombines campaign data after notifications. Wait (Wait1) – Ensures alert delivery before logging. Google Sheets (your-google-sheets-name) – Appends or updates campaign records for reporting and audit history. Why use this? Catch CTR and ROAS drops before ad spend is wasted. Monitor Meta Ads and Google Ads in a single automated flow. Notify teams instantly via WhatsApp, Slack, and Email. Keep a centralized performance log for analysis and reporting. Reduce manual checks with consistent daily monitoring.

How it works This workflow sends WhatsApp messages and emails in bulk using contact data stored in Google Sheets. Contacts are processed in small batches to control throughput and avoid API rate limits. WhatsApp and email are treated as independent channels and are sent only when their status is marked as pending. All success and failure results are written back to Google Sheets to enable tracking, retries, and safe re-runs. Step-by-step Step 1: Fetch contacts & batch processing** Manual Trigger – Starts the workflow manually. Get Contacts – Reads contact data from Google Sheets. Split In Batches – Processes contacts in controlled batch sizes. Step 2: Email preparation & sending** Has Email Address – Checks whether the contact has an email address. IF Mail Pending – Ensures the email is still marked as pending. PrepareEmail email – Loads the selected InboxPlus email template. Build HTML Email – Builds the final HTML email body. Fetch Email Image – Downloads images for inline or attachment usage. Send Gmail – Sends the email via Gmail. Delivered – Confirms successful email delivery. Step 3: WhatsApp message sending** Has Phone Number – Checks whether the contact has a phone number. IF WhatsApp Pending – Ensures the WhatsApp message is still pending. Send template – Sends the approved WhatsApp template message. Sent – Confirms message acceptance by WhatsApp. Step 4: Delivery status updates** Update Sheet – Writes successful delivery results back to Google Sheets. Mail Failure – Updates Google Sheets if email delivery fails. Whatsapp Failure – Updates Google Sheets if WhatsApp delivery fails. Why use this? Prevents duplicate messages with channel-level pending checks Handles WhatsApp and email independently in one workflow Supports safe retries without resending completed messages Keeps Google Sheets as the single source of truth Scales bulk outreach safely using batch-based execution

🧠 How it works This workflow turns your website form into a fully automated AI Lead Qualification system. Whenever a new lead submits your form, the workflow: Receives the submission through a Webhook Cleans and normalizes the input fields Uses the AI Agent node to score and qualify the lead Saves all details (including AI analysis) into an Airtable CRM Automatically routes high-quality leads (score ≥ 7) Sends an instant Gmail notification Sends an AI-generated personalized auto-reply back to the lead This gives you a hands-free, intelligent front-door to your business — ensuring you only spend time on high-value opportunities. ⚙️ Set-up steps These steps help users configure the workflow quickly: Create a Webhook trigger – Copy the webhook URL and add it to your form tool (Tally, Typeform, Webflow, etc.). Prepare your Airtable base – Create a "Leads" table with fields for name, email, website, message, lead score, priority, use case, timeline, budget, and AI notes. Add the AI Agent node – Insert the provided System + User prompts – Enable Structured Output – Paste the JSON Schema included in the sticky note inside the workflow. Connect Airtable – Map the original form fields + AI Agent “output” fields to Airtable columns. Set up the Gmail node – Connect your Gmail account – Configure the notification email and auto-reply templates. Configure the IF node – Score ≥ 7 routes to the “Hot Lead” branch – Everything else is captured but not routed. Run a test submission – Verify that the workflow writes to Airtable – Confirm the Gmail notification + auto-reply are delivered – Adjust prompting if needed. All detailed explanations and prompt configurations are included inside the workflow through sticky notes for easy reference.

Overview This workflow automates your entire sales outreach process across LinkedIn, Email, and WhatsApp using AI to create hyper-personalized messages for each prospect. Instead of spending hours crafting individual messages, the workflow analyzes your lead data and generates customized connection requests, emails, and WhatsApp messages that feel genuinely personal and researched. The workflow includes a built-in approval mechanism, so you can review all AI-generated messages before they're sent, ensuring quality control while still saving massive amounts of time. How It Works The workflow follows a seven-step process: Step 1: Data Collection The workflow starts by reading your lead data from a Google Sheet. Your sheet should contain information about each prospect including their name, title, company, industry, technologies they use, and any other relevant details that can be used for personalization. Step 2: Batch Processing To prevent overwhelming APIs and ensure smooth operation, the workflow processes leads in batches. Each lead's complete data is prepared and formatted for the AI agent to analyze. Step 3: AI Personalization This is where the magic happens. The AI agent receives all the prospect data and generates three distinct messages: A LinkedIn connection request (under 300 characters) that references their specific role, company, or industry A professional HTML email that demonstrates you've researched their business and explains how you can help A casual WhatsApp message that's friendly and approachable The AI is instructed to make these messages sound completely human, never generic or templated. Step 4: Data Cleanup and Storage The AI's output is parsed and cleaned up, then written back to your Google Sheet in separate columns. This creates a permanent record of all generated messages for your review. Step 5: Manual Approval Before anything gets sent, you receive an email asking for your approval. You can review all the generated messages in your Google Sheet, make any edits if needed, and then approve or reject the batch. This ensures you maintain full control over what goes out. Step 6: LinkedIn Automation Once approved, the workflow triggers your Phantombuster agent to send LinkedIn connection requests using the AI-generated messages. Phantombuster handles the actual LinkedIn interaction safely within their platform's limits. Step 7: Email and Notification Delivery Finally, the workflow sends out the personalized emails via Gmail and optionally notifies you via Telegram for each message sent. This happens sequentially to respect rate limits and maintain deliverability. Setup Requirements Before you can use this workflow, you'll need to set up several accounts and gather credentials: Essential Services: An n8n instance (cloud or self-hosted) A Google account with Google Sheets access A Gmail account for sending emails An OpenAI account with API access (for the AI agent) Phantombuster account (for LinkedIn automation) Optional Services: Telegram account and bot (for notifications) Credentials You'll Need: Google Sheets OAuth2 credentials Gmail OAuth2 credentials OpenAI API key Phantombuster API key and agent ID Telegram bot token and chat ID (if using notifications) How to Use This Workflow Initial Setup: Import this workflow into your n8n instance Add all required credentials in n8n's credential manager Create your Google Sheet with the following columns at minimum: First Name, Last Name, Title, Company Name, Personal Email, Industry, Website. Add three additional columns for output: Connection, AI Email, AI Whatsapp Message Copy your Google Sheet ID from the URL and update it in all Google Sheets nodes Open the AI Agent node and update the prompt with your personal information: your name, title, email, and LinkedIn URL Update the email addresses in the Gmail nodes to your actual email addresses Configure your Phantombuster agent for LinkedIn and add the API key and agent ID Running the Workflow: Add your lead data to the Google Sheet (you can start with just 2-3 leads for testing) Click "Execute Workflow" in n8n to start the process Wait for the AI to generate messages (this takes a few seconds per lead) Check your email for the approval request Review the AI-generated messages in your Google Sheet Reply to the approval email with your decision If approved, the workflow will automatically send LinkedIn requests, emails, and WhatsApp messages Best Practices: Start small. Process 5-10 leads at a time initially to test the quality of AI-generated messages and ensure everything works correctly. Once you're confident in the output, you can scale up to larger batches. Monitor your results. Keep track of response rates in your Google Sheet and adjust the AI prompt if certain types of messages aren't performing well. Respect rate limits. Gmail allows 100-500 emails per day depending on your account type, and LinkedIn has strict limits on connection requests (typically 100 per week through automation tools). Stay well within these limits to avoid account restrictions. Customizing This Workflow The workflow is designed to be highly customizable to fit your specific use case: Personalizing the AI Prompt: The most important customization is in the AI Agent node's prompt. You can modify it to: Emphasize different aspects of your value proposition Change the tone from formal to casual or vice versa Include specific pain points relevant to your target industry Add your company's unique selling points Adjust message length and structure Modifying the Output: You can change what the AI generates by editing the prompt. For example, you might want: Different message types (Twitter DMs instead of WhatsApp) Multiple email variations for A/B testing Follow-up message sequences Industry-specific templates Adding Features: The workflow can be extended with additional nodes: Add time delays between sends to appear more natural Include condition checks to segment leads by industry or company size Connect to your CRM to automatically log activities Add sentiment analysis to filter out negative-sounding messages Implement response tracking by monitoring your inbox Changing Tools: If you prefer different services, you can swap out nodes: Replace Phantombuster with other LinkedIn automation tools Use SendGrid or Mailgun instead of Gmail for higher volume Add Slack notifications instead of Telegram Connect to WhatsApp Business API for official messaging Data Source Alternatives: Instead of Google Sheets, you could: Connect directly to your CRM (HubSpot, Salesforce, Pipedrive) Use Airtable as your database Pull data from CSV files uploaded to cloud storage Integrate with lead generation tools like Apollo or Hunter Tips for Success The quality of your AI-generated messages depends heavily on the data you provide. The more information you have about each prospect (their role, company size, technologies used, recent news, pain points), the more personalized and effective the messages will be. Regularly review and refine your AI prompt based on the responses you're getting. If prospects aren't responding, your messages might be too sales-focused or not personal enough. Adjust the prompt to make messages feel more consultative and helpful. Don't send to your entire list at once. Even with approval gates, it's wise to test with small batches, measure results, iterate on your approach, and then scale up gradually. Always comply with email and LinkedIn best practices. Never spam, always provide value in your outreach, respect people's time and privacy, and make it easy for them to opt out if they're not interested. This workflow is a powerful tool that can save you hours of work while actually improving the quality of your outreach through AI-powered personalization. Use it responsibly and watch your response rates improve.

Error Handler: WhatsApp Alert & Gmail Report for Failed Workflows 🎯 What This Template Does / How it Works This template provides a robust, two-step system for handling critical errors in your n8n workflows. It ensures that no workflow failure goes unnoticed, immediately notifying your team via a fast, urgent channel and providing a detailed record via a formal channel. Instant Trigger & Data Capture: The Error Trigger automatically captures all necessary metadata when an assigned workflow fails, including the error message and ID. Contact Configuration: The Set node centralizes and prepares recipient contact information (email and phone number) from the error data. Rapid Response: An urgent notification is sent via WhatsApp for immediate team awareness. Traceability & Record-Keeping: A short Wait node introduces a delay to prevent notification spam. Following the pause, a comprehensive report is sent via Gmail, ensuring a detailed record of the incident is archived. This design guarantees high-priority alerts are handled rapidly, while still maintaining essential documentation. Who’s It For This template is ideal for Ops Teams, Developers, and Automation Engineers who rely on mission-critical n8n workflows (e.g., payment processing, lead capture, data synchronization). If a failure requires immediate human intervention, this system is essential. How to Set Up Setting up this robust error handler is quick and essential for workflow stability: Configure Credentials: Ensure you have the necessary credentials added to your n8n instance for: WhatsApp Business API (for the Send message node). Gmail (for the Send Email node). Define Recipients: In the set_recipient_EMAIL/NUMBER node, replace the placeholder values with the actual email address and phone number of your incident team. Activate the Listener: Open the settings of the primary workflow you wish to monitor.Go to settings ,navigate to the Error Workflow field and select the name of this template (the Error Handler). Save Changes: Save both this Error Handler workflow and the primary workflow. Done! Any failure in the primary workflow will now automatically trigger this alert system. Requirements Gmail Account (Configured as a resource). WhatsApp Business API Access (Configured as a resource and a pre-approved template available).

GitHub Bounty Issue Tracker & Alert System (Google Sheets + Email/WhatsApp) Overview Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google Sheets, and sends instant alerts via Email (HTML-styled) or WhatsApp. Perfect for developers, freelancers, and open-source contributors who want to discover and claim paid opportunities faster. What This Workflow Does 🔎 Automated Bounty Discovery Searches GitHub hourly for all open issues labeled with “💎 Bounty.” Filters duplicates to avoid re-tracking the same issue. 📢 Smart Notifications Sends styled HTML email alerts with GitHub-themed design. WhatsApp Business API integration (optional, disabled by default). Alerts only for bounties created within the last 5 days. 📊 Google Sheets Tracking Sheet1**: Complete bounty list (all tracked issues). Sheet2**: Recent notification log (for quick reference). 🔄 Status Updates Checks every 6 hours for issue changes (open/closed state, new comments). Includes bounty amount, issue details, and direct GitHub links. Use Cases 👩‍💻 Freelance developers hunting for paid open-source work. 🛠 Development teams tracking bounty opportunities for their stack. 🌍 Community managers monitoring open-source bounty program engagement. 🤝 Open-source contributors looking for compensated tasks. Requirements GitHub Personal Access Token (with repo access). Google Sheets (2 sheets required: Sheet1 = bounties, Sheet2 = notifications). Gmail account (OAuth2 for sending email alerts). WhatsApp Business API credentials (optional). Configuration Notes This workflow supports pagination for large result sets and includes filters to prevent duplicate notifications. You can customize the GitHub search query in the HTTP Request node to target: Specific repositories Custom labels Team/organization projects Frequently Asked Questions (FAQ) Q: How often will I get notifications? A: By default, new bounties trigger alerts once an hour. Updates on existing issues (status/comments) are checked every 6 hours. Q: Do I need WhatsApp integration? A: No, it’s optional. Email alerts work out-of-the-box. Q: Can I filter by bounty amount? A: Yes, the workflow extracts bounty details and you can add filters in your Google Sheets or notification logic. Why Use This GitHub Bounty Tracker? Unlike manual searches, this workflow ensures you never miss a paid GitHub issue. Whether you’re a freelancer looking for income, a team seeking funded tasks, or a contributor wanting recognition and rewards, this system keeps you updated automatically.

AI-Powered Customer Service Automation with Smart Routing How it works Core Intelligence Pipeline • Multi-Layer Message Analysis - Every customer interaction passes through three specialized AI classifiers: privacy detection (identifies sensitive data and security requirements), intent recognition (categorizes requests as purchases, inquiries, complaints, technical support, or order tracking), and sentiment analysis (monitors emotional tone from neutral to critical frustration levels) • Dynamic Knowledge Integration - The system maintains live connections to your company's knowledge base and order management systems, automatically querying relevant information before crafting responses. This ensures accuracy and eliminates outdated information while providing real-time order status updates • Conversational Memory & Context - Advanced chat memory preserves conversation history across sessions, enabling the AI to maintain context, avoid repetitive responses, and build on previous interactions for more natural, human-like conversations • Intelligent Response Generation - The AI agent synthesizes information from multiple sources (knowledge base, order systems, conversation history) while adapting its tone and approach based on detected customer sentiment and privacy requirements Smart Escalation System • Automated Triage Classification - A sophisticated routing engine categorizes each interaction into four escalation levels: Normal (AI-handled routine inquiries), Human Request (explicit agent requests), Critical Complaint (serious issues requiring immediate attention), and Owner Escalation (extreme situations with legal implications or persistent anger) • Context-Aware Handoffs - When escalation is required, the system automatically generates comprehensive situation summaries for human agents, including conversation history, customer sentiment analysis, and specific issue classification • Multi-Channel Notifications - Escalated cases trigger appropriate alerts via email to designated team members based on severity level, ensuring proper resource allocation and response times Data Intelligence & Analytics • Comprehensive Interaction Logging - Every conversation is captured with full context including customer sentiment, intent classification, AI responses, and escalation decisions, creating a rich dataset for performance analysis and system improvement • Conversation Context Generation - For escalated cases, the system automatically produces detailed conversation summaries and context reports to help human agents understand the full situation before taking over Set up steps Platform Integration (20-30 minutes) • Messaging Platform Connection - Configure your primary communication channel (supports multiple messaging platforms) with proper API credentials and webhook setup for real-time message processing • AI Service Configuration - Connect OpenAI API credentials for the language models powering the classification engines and response generation • Database Setup - Establish connections to your customer database and order management systems for personalized responses and order tracking capabilities Knowledge Base Preparation (45-60 minutes) • Company Information Import - Upload or connect your existing knowledge base, including product catalogs, policy documents, FAQ sections, and troubleshooting guides • Order Database Integration - Link your order management system to enable real-time order status queries, shipping tracking, and return processing • Response Templates - Configure standard response patterns and company voice guidelines to ensure consistent brand communication Escalation & Routing Setup (15-25 minutes) • Team Structure Configuration - Define escalation paths and assign notification recipients for different severity levels (standard support, critical complaints, owner-level issues) • Email Integration - Connect email service for automated escalation notifications with customizable templates for different situation types • Escalation Triggers - Fine-tune the classification thresholds that determine when conversations require human intervention Testing & Optimization (30-45 minutes) • Conversation Flow Testing - Run comprehensive test scenarios covering various customer intents, sentiment levels, and escalation triggers to validate system responses • Knowledge Base Validation - Verify that the AI can accurately retrieve and apply information from your knowledge base for common customer queries • Escalation Path Verification - Test all escalation routes to ensure proper notifications and handoff procedures are functioning correctly • Performance Monitoring Setup - Configure analytics tracking to monitor response accuracy, escalation rates, and customer satisfaction metrics Advanced Configuration (Optional - 30-60 minutes) • Multi-Language Support - Configure language detection and response capabilities for international customer base • Custom Classification Rules - Adjust intent and sentiment classification parameters based on your specific business context and customer communication patterns • Integration Extensions - Connect additional business systems (CRM, billing, inventory) for enhanced customer service capabilities Technical Specifications AI Models & Processing • Powered by GPT-4 family models for natural language understanding and generation • Real-time voice transcription capabilities for multi-modal customer interactions • Structured output parsing for consistent data classification and routing decisions • Context-aware memory management with configurable conversation history retention Data Security & Privacy • Automatic detection of sensitive information with privacy-first handling protocols • Configurable data retention policies and secure storage of conversation logs • Customer verification requirements for accessing sensitive account information • GDPR-compliant data processing and storage practices Scalability & Performance • Modular architecture supporting easy integration of additional messaging platforms • Database-agnostic design (supports PostgreSQL, Supabase, and other systems) • Horizontal scaling capabilities for high-volume customer service operations • Real-time processing with minimal latency for immediate customer responses Detailed technical implementation guides, API configuration examples, and troubleshooting documentation are embedded within the workflow nodes for development teams.

Supercharge Your HighLevel CRM with the Power of GPT-5 Unleash the full potential of your HighLevel CRM by adding an intelligent GPT-5 Agent that does more than just follow commands — it understands context, retrieves the right data, and executes actions instantly. This marketplace solution transforms how you work: Act Instantly** – Create, update, and manage contacts, opportunities, tasks, and calendars with natural language commands. Work Smarter, Not Harder** – The agent pulls context from your internal documents, spreadsheets, and even the web before acting, ensuring every move is informed and precise. Never Miss a Detail** – It searches your knowledge base, Google Drive, and Supabase vectors to fill in missing info so you don’t have to. Boost Team Productivity** – Automate repetitive CRM work, cut manual data entry, and free up hours every week. Close Deals Faster** – Instantly update opportunities, schedule meetings, and follow up on leads without switching tabs. Stay Organized Effortlessly** – One AI agent orchestrates it all — from booking appointments to updating deal stages — directly inside HighLevel. Why This Is a Game-Changer Other tools require constant babysitting. This agent thinks ahead, checks context, and ensures every action in your CRM is accurate, complete, and ready to move your business forward. ⚡ Stop clicking through endless menus. Let GPT-5 + HighLevel automation work for you. ✅ Boost conversions ✅ Automate admin work ✅ Keep your CRM data flawless Get it now and watch your CRM become your smartest sales assistant.

📄 n8n RAG Ingestion & Query Workflow Overview This workflow is your all-in-one pipeline to turn any document into a powerful searchable knowledge base using RAG (Retrieval-Augmented Generation). From the moment a file lands in your Google Drive, it’s automatically processed, understood, and made ready for instant AI-powered answers. If you’re looking to unlock hidden value in your files and get answers in seconds instead of hours, this workflow is the foundation you need. What It Does for You 📥 Automatic Ingestion** – New files in a designated Google Drive folder are instantly picked up. 🔍 OCR Extraction* – Extracts all* text, whether it’s plain or inside tables. 📚 Vector Database Storage* – Keeps your documents in Supabase* for lightning-fast semantic search. 🧩 Smart Chunking** – Each page becomes a single chunk for better understanding. 💡 AI-Powered Answers** – Ask questions in natural language and get precise, context-aware responses. 🧠 Persistent Memory** – Remembers previous chats for more coherent conversations. ⚡ GPT-5 Intelligence** – Uses OpenAI’s most advanced model for deep, accurate answers. How It Works Detect → Watches your Google Drive folder for new files. Extract → Uses Mistral AI to read all text, including tables. Chunk → Splits content so one page = one chunk for better context. Embed → Generates vector embeddings with OpenAI for semantic search. Store → Inserts processed content into Supabase. Retrieve & Answer → When you ask, the system searches the database and passes the results to GPT-5. Remember → Stores conversation history in Postgres for continuity. Why You Want This Stop wasting time digging through files. Get fast, AI-driven answers from your own documents. Keep your data organized and searchable at any scale. Designed for businesses, researchers, and teams who want instant access to the right information. You get the template + setup guide and description Key Highlights End-to-End Automation** – From upload to query, no manual steps needed. Flexible** – Works with any document type. High Accuracy** – Large chunk size preserves full page context. Scalable** – Add as many files as you want without slowing down. Future-Ready** – Built to grow with your needs. 🚀 Imagine having your own private ChatGPT trained on your files. This workflow makes it happen. Upload, search, and get answers — all automatically.

This n8n template uses AI to automatically classify incoming Gmail messages into five categories and route them to the right people or departments. It can also reply automatically and send WhatsApp alerts for urgent or relevant messages. This helps ensure high-priority emails never get missed, while other messages are handled efficiently. ##How It Works Trigger A new email in Gmail triggers the workflow. Classification (OpenAI GPT) The email is analyzed by an OpenAI GPT model and classified into one of: High Priority Customer Support Promotion Finance/Billing Random/Other Conditional Logic & Actions High Priority → Create draft reply + send WhatsApp alert. Customer Support → Auto-reply + send WhatsApp confirmation alert. Promotion → Summarize email + send WhatsApp promotional alert. Finance/Billing → Forward to finance team + send WhatsApp finance alert. Random/Other → Label and log only. Multi-Channel Output Responses are sent via Gmail. Alerts are sent via WhatsApp (or another compatible API). ##Setup Instructions Step 1: Gmail Authorization Add a Gmail node in n8n. Connect using OAuth2 and grant read/send permissions. Step 2: OpenAI API Key Get your API key from OpenAI. Add it to n8n credentials for the OpenAI node. Step 3: WhatsApp Integration Use your WhatsApp Business API or a provider like Twilio or 360Dialog. Replace placeholders with your details: [YOUR_WHATSAPP_NUMBER] [YOUR_FINANCE_TEAM_NUMBER] [YOUR_SUPPORT_TEAM_NUMBER] Step 4: Import & Run Import the workflow JSON into n8n. Adjust prompts, labels, and routing logic as needed. Execute and monitor results. ##Good to Know Fully customizable — add or remove categories, adjust responses, and change alert channels. Can be integrated with Slack, Discord, Trello, Notion, Jira, or CRM systems. Scales easily across teams and departments. ##Requirements Gmail account with OAuth2 credentials set up in n8n OpenAI API key for classification and content generation WhatsApp (or other messaging service) integration Optional: Slack, Notion, CRM, or accounting tool integrations ##Customization Ideas Create support tickets in Trello, Notion, or Jira from Customer Support emails. Sync Finance emails with QuickBooks, Stripe, or Google Sheets. Replace WhatsApp alerts with Slack or Discord messages. Use Zapier/Make for cross-platform automations.

This workflow automatically transforms your messy inbox into a neatly organized space while ensuring you never miss a critical message. It connects to your Gmail account and triggers for every new email. Using a powerful AI agent, the workflow first analyzes the email's content, sender, and metadata to classify it and apply the appropriate Gmail label (e.g., "Finance," "Marketing," "Dev Tools"). In parallel, a second AI agent determines if the email is urgent (like a security alert, OTP, or payment reminder) and generates a concise summary. If an email is marked as urgent, the workflow instantly sends a notification with the summary to your Telegram and WhatsApp, allowing you to take immediate action. This workflow is perfect for anyone looking to automate their email management, reduce inbox clutter, and stay on top of important, time-sensitive communications. Step-by-Step Explanation This workflow is designed to intelligently categorize incoming emails and notify you of urgent messages. Here is a breakdown of how it operates: Trigger: New Email Received Node: Gmail Trigger Action: The workflow initiates whenever a new email arrives in your connected Gmail inbox. Fetch Full Email Content Node: Get a message Action: It takes the ID of the new email from the trigger and fetches the complete message body, subject, sender, and headers. AI-Powered Categorization Node: AI Agent2 Action: This AI agent analyzes the full email content. Based on a detailed prompt that includes classification rules (e.g., if the sender is GitHub, classify as "Dev Tools"), it determines the most appropriate category and outputs the corresponding Label ID. Label Management and Application Node: Loop Over Items -> Create Label if Doesn't exist -> Get Existing Labels -> Filter -> Add label to thread Action: This sequence ensures the email gets the correct label. It first attempts to create the Gmail label suggested by the AI. The node is set to continue even if the label already exists. It then fetches a list of all your current Gmail labels. A Filter node finds the exact ID of the label that matches the AI's suggestion. Finally, it applies this label to the email thread, neatly organizing it in your inbox. Urgency Analysis and Summarization Node: AI Agent Action: Concurrently, a second AI agent analyzes the email to determine its urgency (classifying it as "urgent" or "normal") and generates a two-sentence summary. Parse AI Output Node: Code Action: A simple code node cleans up the JSON output from the urgency analysis to ensure it's correctly formatted for the next step. Conditional Notification Logic Node: If Action: This node checks the output from the previous step. It proceeds only if the email's urgency is marked as "urgent." Send Instant Alerts Nodes: Send a text message (Telegram) & Send message (WhatsApp) Action: If an email is deemed urgent, the workflow immediately sends an alert containing the email summary to your specified Telegram chat and WhatsApp number.

🚀 AI OPS Agent for n8n — Stop Doing Busy Work. Start Leading. Your AI workforce is ready. Are you? 💰 What You Get: Your ROI in 30 Days Replace 10-15 hours/week of manual work with intelligent automation that actually understands your business. While your competitors copy-paste data between tools, you'll be making strategic decisions. 🧠 The Powerhouse Stack That Does Everything | Module | Core Job | Your Competitive Edge | |------------|-------------|--------------------------| | MAIN AGENT (Grok 4) | Orchestrator & brain | • Reads your message → builds execution plan• Delegates to specialized agents• Delivers results through your preferred channel | | Knowledge Agent | Company-wide research assistant | • Vector-searches your Supabase docs instantly• Runs live SQL queries for real-time numbers• Hunts & parses Drive files automatically• Pulls fresh web intelligence via Perplexity | | Google Sheets MCP Toolkit | Spreadsheet automation | Natural-language control over read/append/update/clear/create/delete operations on any tab or range | | Google Drive MCP Toolkit | File intelligence pipeline | • Auto-detects file types & extracts text from PDFs/CSVs• Transcribes audio/video content• Describes images with GPT-4o Mini | | Vector Store Loader | Long-term memory system | • Auto-chunks new files• Creates OpenAI embeddings• Stores in Supabase for instant semantic search | | Postgres Chat Memory | Conversation context | Never repeat yourself—every follow-up question builds on previous context | | Report Agent | Executive briefing machine | • Converts raw outputs → clean Markdown → HTML• Auto-emails/Slacks/Telegrams polished reports | | LinkedIn Scraper | Talent & market intelligence | Scrapes full LinkedIn profiles via Apify, delivers structured JSON for analysis | | Multi-Channel Triggers | Meet users where they work | Slack • Gmail • Telegram • WhatsApp • HTTP Webhooks | | LLM Layer | Right model, right job | Grok 4 (reasoning) • Claude Sonnet 4 (analysis) • GPT-4o Mini (speed) • Perplexity (live web) | ⚡ How It Works (The Magic in 5 Steps) Message arrives (Slack mention, email, webhook) MAIN AGENT analyzes → selects optimal tool chain Specialized toolkits execute (Sheets, Drive, SQL, Scraper...) Knowledge Agent synthesizes everything using the perfect LLM Report Agent packages & delivers results to your chosen channel 🎯 Real Commands That Save Hours Daily > "Update the Marketing-Spend sheet with last week's totals, then email me a chart." > > "Find the product-launch PDF from Drive, summarize key risks, post to Slack." > > "Scrape this LinkedIn URL, rank the candidate's skills, add them to our CRM sheet." > > "Create a new Sprint 11 tab, copy headers from Sprint 10, and ping the team." One command. Multiple systems. Zero manual work. Why Choose This Over Other Products: ✅ All Your Data, One Brain No more jumping between 12 different tools. Your AI agent connects everything. You can go further If you want to increase the Agent capabilities or make the more powerfull you can reach the dev. ✅ Vector Search Built-In Upload a 100-page document once. Search it forever with natural language. ✅ Executive-Ready Reports Your C-suite gets clean HTML briefs, not raw data dumps that waste their time. ✅ Deploy in Minutes Plug into your existing n8n setup, add credentials, watch routine ops handle themselves.

AI Blog Automation System Description This comprehensive N8N automation template revolutionizes content creation by delivering a complete end-to-end solution for AI-powered blog generation. Transform simple ideas into fully SEO-optimized, WordPress-ready articles that rank higher and drive organic traffic to your website. The system accepts blog requests from multiple communication channels (Telegram, WhatsApp, Slack, Gmail) and automatically processes them through an intelligent pipeline that includes advanced keyword research, competitor analysis, and market insights. Using cutting-edge AI models like GPT-4 and OpenRouter, the workflow generates detailed content outlines, conducts comprehensive research, and produces high-quality, engaging blog posts that are automatically formatted and published directly to your WordPress website. What sets this template apart is its focus on SEO excellence - every piece of content is optimized for search engines with proper keyword density, meta descriptions, internal linking strategies, and content structure that search engines love. The integrated content tracking system maintains a database of all published articles, enabling smart internal linking recommendations and content performance monitoring. Key Features 🤖 Advanced AI Content Generation GPT-4 & OpenRouter Integration** - Leverage the most powerful AI models for superior content quality Multi-stage content refinement** - From outline to final polish, ensuring professional-grade articles Topic research and fact-checking** - AI conducts deep research to create authoritative, well-sourced content 🎯 SEO Optimization at Every Step Intelligent keyword research** - Automatic discovery of high-volume, low-competition keywords Competitor analysis** - Analyze top-ranking content to identify content gaps and opportunities On-page SEO optimization** - Perfect keyword density, meta descriptions, and heading structure Internal linking strategy** - Smart recommendations for linking to existing content SEO-friendly URL generation** - Automatically create search-engine optimized permalinks 🔌 Seamless WordPress Integration Direct publishing** - Articles go live on your WordPress site without manual intervention Custom post formatting** - Proper heading tags, featured images, and category assignment Draft and scheduling options** - Choose immediate publishing or schedule for optimal timing Media handling** - Automatic image optimization and alt-text generation 📱 Multi-Platform Input System Telegram, WhatsApp, Slack, Gmail support** - Accept blog ideas from your preferred communication channels Voice message transcription** - Convert audio ideas into written blog requests Email parsing** - Extract blog topics from client emails or team communications Priority queue management** - Handle multiple requests efficiently with smart prioritization 📊 Content Management & Analytics Comprehensive content database** - Track all published articles, keywords, and performance metrics Internal linking opportunities** - Automatic suggestions for connecting related content Publishing schedule optimization** - AI-recommended posting times for maximum engagement Performance tracking** - Monitor which topics and keywords drive the most traffic 📋 Complete Setup Guide Included This template comes with a comprehensive step-by-step setup guide that walks you through: N8N workflow installation and configuration** API key setup** for all integrated services (OpenAI, WordPress, communication platforms) WordPress plugin installation** and permissions configuration Database setup** for content tracking and analytics Custom field configuration** for SEO optimization Webhook configuration** for multi-platform input Testing procedures** to ensure everything works perfectly Troubleshooting guide** for common issues Best practices** for content optimization and workflow management Perfect for content creators, digital marketers, SEO specialists, and enterprises looking to scale their content production while maintaining high quality and search engine visibility. Whether you're managing a single blog or multiple WordPress sites, this automation system transforms your content workflow from manual labor to intelligent automation.

This automated n8n workflow securely backs up Gmail attachments to Google Drive by triggering on new emails, retrieving the attachments, and uploading them to a designated Drive folder. The process includes a delay to ensure reliable execution and notifies the user via WhatsApp upon completion. Good to Know The workflow triggers on new Gmail messages A short wait ensures proper processing Attachments are uploaded to Google Drive A WhatsApp message confirms the backup How It Works New Email Received** - Initiates the workflow on new Gmail messages Fetch Email Details** - Retrieves the new email message Wait for Processing** - Adds a short delay for reliable processing Process Attachment Data** - Processes the attachment data Upload to Google Drive** - Uploads the attachment to Google Drive Notify via WhatsApp** - Sends a WhatsApp message to confirm the backup How to Use Import the workflow into n8n Configure Gmail API credentials Set up Google Drive API credentials Configure WhatsApp API or integration credentials Test with a sample email containing an attachment Adjust the wait duration if needed Requirements Gmail API credentials Google Drive API credentials WhatsApp API or integration credentials Customizing This Workflow Modify the wait duration in the Wait node to optimize processing time Adjust the Code node to handle specific attachment types or folder destinations in Google Drive

This automated n8n workflow generates social media briefs for sales meetings by integrating with Google Calendar, enriching attendee data, and leveraging AI to summarize social media activity. The system delivers formatted summaries via email and WhatsApp to support sales preparation. Good to Know The workflow triggers daily at 5 AM Attendee data enrichment enhances meeting context AI-driven insights improve sales readiness Summaries are sent via email and WhatsApp How It Works Schedule Trigger - 5 AM** - Initiates the workflow daily at 5 AM Initialize Workflow** - Sets up the workflow manually Fetch Today's Meetings from Google Calendar** - Retrieves scheduled meetings for the day Extract Attendees Email Domains** - Identifies email domains of meeting attendees Loop Through Attendees** - Iterates through each attendee for processing Split Attendee Details** - Separates individual attendee details Enrich Attendee Company Enrichment** - Enhances data with company information Wait for Company Enrichment** - Pauses to ensure company data is processed Check Enrichment Status** - Verifies the status of enriched data Fetch Latest LinkedIn Posts** - GET request to fetch LinkedIn posts Extract Key Post Insights** - Extracts key insights from social media posts Summarize Social Activity with AI** - Summarizes social media activity using AI Merge Summary with (Decide)** - Combines summary with other data Format Email Summary for Complete Chat** - Formats the summary for email Wait Before Sending** - Adds a delay before sending Generate HTML Email Template** - Creates an HTML email template Send via Gmail** - Sends the email summary Send WhatsApp Message** - Sends the summary via WhatsApp How to Use Import the workflow into n8n Configure Google Calendar API credentials Set up LinkedIn API or scraping credentials Configure email and WhatsApp credentials Test the workflow with a sample meeting to verify data flow Adjust the trigger time or delay as needed Requirements Google Calendar API credentials LinkedIn API or scraping access Email service credentials (Gmail, SMTP, etc.) WhatsApp API or integration credentials Customizing This Workflow Modify the trigger time in the Schedule Trigger node to suit your schedule Adjust the Wait nodes to optimize data processing Customize the AI summarization logic in the Summarize Social Activity node for specific insights

Who is this for? This workflow is designed for developers, DevOps engineers, and automation specialists who manage multiple n8n workflows and need a reliable way to monitor for failures and receive alerts in real time. What problem is this workflow solving? Monitoring multiple workflows can be challenging, especially when silent failures occur. This workflow helps ensure you're immediately informed whenever another workflow fails, reducing downtime and improving system reliability. What this workflow does The solution consists of two parts: ERROR NOTIFIER: A centralized workflow that sends alerts through your chosen communication channel (e.g., Telegram, WhatsApp, Gmail). ERROR ALERTER: A node snippet to be added to any workflow you want to monitor. It captures errors and triggers the ERROR NOTIFIER workflow. Once set up, this system provides real-time error alerts for all integrated workflows. Setup Import both workflows: ERROR NOTIFIER (centralized alert handler) ERROR ALERTER (to be added to your monitored workflows) Add credentials for your preferred alert channel: WhatsApp (OAuth or API) Telegram Gmail Discord Slack Activate the workflows: Ensure ERROR NOTIFIER is active and ready to receive triggers. Paste ERROR ALERTER at the end of each workflow you want to monitor, connecting it to the error branch. Sign up for a free consultation and find out how n8n can help you.

Who is this for? This workflow is intended for WhatsApp admins, customer service, individual users or teams in businesses who want to automate their small business or medium to large businesses on WhatsApp practically by automatically replying about your business products or services using Open AI capabilities on AI Agent. Based on an automated system there is a task to answer many customers or clients on WhatsApp, in reality answering one by one is very time consuming and tiring, especially if we have to compose sentences first or click on the template and send them. This is also a form of devotion to the community at n8n and the n8n company, as well as devotion to small businesses so that the reality is no longer tiring and able to answer the problems of reality that exist. How does it work? Easy explanation: Whatsapp trigger here the "Input submissions" node is responsible for inputting chats from customers in the form of data. Then, it is sent to the next node, namely the if node, here there are two if nodes, namely "Signpost" and "Is text message?" responsible for forwarding customer chat input data and selecting if correct then it will be forwarded to the AI ​​Agent and if wrong then there is a "Fallback Text" node. Once correct, the AI ​​Agent will analyze with the OpenAI model capability and store it in Simple Memory. The AI ​​Agent here has been given directions and commands on what it should be like, in the parameters section, the prompt contains a special task, the knowledge base of your business, and several points and rules that must be there. After that, it will be sent via the WhatsApp reply node which is addressed to the customer. After that, the Gmail Set will process it again to be addressed to the Send Gmail Notifications Node, which contains email address parameters and also the contents of the email as a notification of success or failure. Then, there are no operations after that after the Gmail node. And enjoy this workflow that works for you. Setup instructions Complete what is in the node as stated in the notes column. You need a "Credential Account" on each WhatsApp node, then the OpenAI node and the Gmail Node. If you already have an account, just connect it, and if not, create it first, you can register it by following the guide from n8n, it makes it very easy. Because here it has been set up neatly and cleanly like in the if node. Next, you need to add your business to the AI ​​Agent node, there are parameters and a prompt section, I have made a sample here to make it easier for you. You can immediately adjust it to your business or service or product, later what communication or sentence you want to convey to customers on WhatsApp. After that, don't forget to add an email address to the Gmail node for notification of success or failure of each customer from the running of this system. Save and run, test the workflow and activate the workflow. This workflow is ready to use. Requirements As a reminder: Must be set in nodes such as your business description, also according to the conditions of your business, services, products, so that the AI ​​Agent matches your business knowledge base Must have (if not, make sure you have registered) in each "Credential Account" by following the guide on how to create it n8n the guide is very complete Don't forget to save, and make sure the workflow is active. How to customize this workflow to your needs
 You can immediately set up your business knowledge base in the nodes, so that the accuracy is also high when carrying out tasks and answering them.