by Rahul Joshi
Description Keep your CRM and task system perfectly in sync โ automatically. This workflow monitors a Google Sheet for lead reply updates, instantly updates the corresponding contact in GoHighLevel (GHL), and creates a ClickUp follow-up task when a response is detected. It ensures your sales team never misses a warm lead and every reply is logged, tracked, and acted upon. โก What This Template Does Watches a Google Sheet for reply status changes (โYesโ in the Replied column). ๐ Filters only rows where a lead has replied. ๐ Updates the corresponding contact record in GoHighLevel (GHL). ๐ Automatically creates a follow-up task in ClickUp with lead details. ๐๏ธ Merges updates from both GHL and ClickUp into a single result. ๐ Logs sync status and timestamps in a tracking sheet (Sheet2) for auditing. ๐ Key Benefits Instant sync: Update GHL and ClickUp the moment a lead replies. โ๏ธ Zero manual work: Automated updates and follow-up task creation. ๐ซ Full traceability: Audit trail stored in a second Google Sheet. โ Increased sales responsiveness: Teams act immediately on new replies. ๐ฌ Multi-app harmony: Connects Google Sheets, GHL, and ClickUp seamlessly. ๐ Features Google Sheets trigger runs every minute to check for changes. โฑ๏ธ Conditional logic (If node) processes only โReplied = Yesโ leads. โ GHL contact update node for CRM synchronization. ๐ผ ClickUp task creation node with customizable priority and naming. ๐ Merge node to unify both paths before final sheet update. ๐ Timestamp and action tracking for audit clarity. ๐ Visual sticky notes explaining each stage. ๐งฉ Requirements n8n instance (cloud or self-hosted). ๐งฐ Google Sheet with headers: Name, GHL_ID, Replied, Email. ๐ Connected credentials for: Google Sheets API (Trigger + Update access) GoHighLevel OAuth2 API ClickUp API Separate โlogโ sheet (Sheet2) for sync tracking. ๐ Target Audience Sales teams using GoHighLevel for CRM and ClickUp for task management. ๐ฏ Agencies managing multiple client pipelines. ๐ค Business development reps who track lead replies manually. ๐ Founders automating lead follow-up and CRM hygiene. ๐ Step-by-Step Setup Instructions (Concise) Prepare a Google Sheet with columns: Name, GHL_ID, Email, Replied. ๐ Add a second sheet (โSheet2โ) for tracking updates. ๐ Connect credentials for Google Sheets, GoHighLevel, and ClickUp in n8n. ๐ Import and open this workflow. Update GHL contact field mappings if your CRM structure differs. โ๏ธ Adjust ClickUp team, space, and list IDs to match your setup. ๐ Execute manually once for testing, then enable it to run every minute. โถ๏ธ Security Best Practices Share your Google Sheet only with the n8n Google account (Editor). ๐ Keep API credentials securely stored in n8nโs credential manager. ๐ก๏ธ Log timestamps for traceability and rollback. โณ Periodically archive older sync logs to keep the sheet lightweight. ๐งน
by Yaron Been
CHRO Agent with HR Team Description Complete AI-powered HR department with a Chief Human Resources Officer (CHRO) agent orchestrating specialized HR team members for comprehensive people operations. Overview This n8n workflow creates a comprehensive human resources department using AI agents. The CHRO agent analyzes HR requests and delegates tasks to specialized agents for recruitment, policy development, training, performance management, employee engagement, and compensation analysis. Features Strategic CHRO agent using OpenAI O3 for complex HR decision-making Six specialized HR agents powered by GPT-4.1-mini for efficient execution Complete HR lifecycle coverage from hiring to retention Automated policy creation and compliance documentation Performance review and goal-setting systems Employee engagement and culture initiatives Compensation analysis and benchmarking Team Structure CHRO Agent**: Strategic HR oversight and task delegation (O3 model) Recruiter Agent**: Job descriptions, candidate screening, interview questions HR Policy Writer**: Employee handbooks, policies, compliance documentation Training & Development Specialist**: Onboarding programs, learning materials Performance Review Specialist**: Reviews, feedback templates, goal setting Employee Engagement Specialist**: Culture initiatives, team building, communications Compensation & Benefits Analyst**: Salary benchmarking, benefits packages How to Use Import the workflow into your n8n instance Configure OpenAI API credentials for all chat models Deploy the webhook for chat interactions Send HR requests via chat (e.g., "Create a complete onboarding program for software engineers") The CHRO will analyze and delegate to appropriate specialists Receive comprehensive HR deliverables Use Cases Complete Hiring Process**: Job postings โ Screening โ Interviews โ Offers Policy Development**: Employee handbooks, compliance documentation Onboarding Programs**: 30-60-90 day plans with training materials Performance Management**: Review cycles, feedback systems, development plans Culture & Engagement**: Surveys, team building activities, recognition programs Compensation Strategy**: Market analysis, pay equity reviews, benefits design Requirements n8n instance with LangChain nodes OpenAI API access (O3 for CHRO, GPT-4.1-mini for specialists) Webhook capability for chat interactions Optional: Integration with HRIS systems Cost Optimization O3 model used only for strategic CHRO decisions GPT-4.1-mini provides 90% cost reduction for specialist tasks Parallel processing enables simultaneous agent execution Template library reduces redundant content generation Integration Options Connect to HRIS systems (Workday, BambooHR, etc.) Integrate with applicant tracking systems Link to performance management platforms Export to document management systems Contact & Resources Website**: nofluff.online YouTube**: @YaronBeen LinkedIn**: Yaron Been Tags #HRTech #PeopleOperations #TalentAcquisition #EmployeeExperience #HRAutomation #AIRecruitment #PerformanceManagement #CompensationBenefits #OnboardingAutomation #CultureTech #n8n #OpenAI #MultiAgentSystem #FutureOfWork #HRTransformation
by Miha
This n8n template gives you a chat-style assistant that can search your HubSpot CRM on demand. Ask natural-language questions like โshow me leads in Germanyโ or โwhat deals close next month,โ and the agent translates your request into precise HubSpot searchesโthen answers in plain English. Great for founders, AEs, and ops folks who want quick answers without clicking through the CRM. How it works Chat trigger** starts a session from your n8n chat UI or embed. AI Agent (Gemini 2.5 Pro)** interprets the message and: Chooses the right HubSpot search (contacts or deals). Fills filter property, operator (EQ, NEQ, GT, GTE, LT, LTE, BETWEEN, IN, NOT\_IN), and value(s). Requests specific properties (email, name, lifecycle stage, owner, activity timestamps, etc.). HubSpot tools** execute live queries: Contacts: flexible property filter + free-text query. Deals: filters by owner and core deal fields (stage, amount, pipeline, close date). Memory buffer** keeps the last turns so you can say โnow only show closed won over 10kโ and the agent understands context. How to use Connect credentials HubSpot OAuth on both HubSpot Tool nodes. Google Gemini API key on the Gemini Chat Model. Open the chat (the โWhen chat message receivedโ node). Ask questions like: โFind contacts named Hans created after Sept 1.โ โDeals owned by me in Proposal with amount > 10,000.โ โContacts with lead status = New and no email reply in the last 14 days.โ Refine with follow-ups: โSort by most recently contacted.โ โOnly Germany.โ โShow top 5 with emails.โ Requirements HubSpot** (OAuth2) Google Gemini** (API key) Notes & customization Property/operator control:** The contact search node lets the agent set both the property (e.g., email, lifecyclestage, hs_lead_status) and the operator (EQ, IN, BETWEEN in epoch ms for dates, etc.). Owner filtering for deals:** Uses hs_all_owner_ids; swap or extend to filter by pipeline/stage ranges. Guardrails:** Add allowlists for searchable properties or cap result counts to avoid noisy answers. Display format:** Have the agent return concise tables (name, email, stage, last activity, CTA). Handoffs:** Add Slack/Email actionsโe.g., โpost this list to #salesโ or โexport to CSV.โ Telemetry:** Log queries for later dashboards (common searches, coverage gaps). Troubleshooting No results?** Loosen operators (use IN lists, broaden dates) or include a free-text query. Date filters:** Provide epoch ms for GT/GTE/LT/LTE/BETWEEN on time fields (the agent handles this; keep system time in UTC). Too chatty?** Reduce memory window or ask the agent to summarize to bullet points.
by Ghulam Ahmad
Search LinkedIn Companies, Score Them with AI, and Add to Google Sheets CRM Who is this for? This template is designed for sales teams, business development reps, and marketers who need a reliable, automated way to build targeted prospect lists. Itโs especially useful for agencies, consultants, and B2B companies that want to identify, qualify, and prioritize high-value leads. What problem does this workflow solve? Researching companies on LinkedIn, evaluating whether they fit your ideal customer profile, and manually updating your CRM can be slow, inconsistent, and labor-intensive. This workflow replaces that entire process with a fully automated system that finds, qualifies, and organizes leads for you. What this workflow does The workflow searches LinkedIn for companies based on your chosen filters, gathers in-depth company details, applies qualification rules, uses AI to score how well each company matches your ICP, and then adds them to your Google Sheets CRM while automatically preventing duplicates. Setup Create a Ghost Genius API account and generate your API key Add your API credentials to the HTTP Request nodes Make a copy of the included Google Sheets template Set up Google Sheets and OpenAI credentials as described in the n8n documentation Customize the Set Variables node to define your audience and AI scoring parameters How to customize this workflow Update your search filters to target specific industries, regions, or company sizes Change the follower count threshold to match your qualification rules Modify the AI scoring prompt to better reflect your product or service Add notifications (email, Slack, etc.) to alert you when high-scoring leads are found
by Yves Junqueira
Who's it for Digital marketing agencies and Meta Ads managers who need to generate comprehensive performance reports across multiple client accounts automatically. Perfect for agencies handling 5+ Meta Ads accounts who want to save hours on manual reporting while delivering AI-powered insights to their teams. What it does Pulls performance data from multiple Meta Ads accounts for a specified time period (last 7, 14, or 30 days) Uses Claude AI with Pipeboard's Meta Ads MCP to analyze campaign performance, identify trends, and generate actionable insights Generates professional reports with AI-driven recommendations for optimization Automatically delivers formatted reports to your Slack channels Runs on a schedule (weekly/daily) or triggered manually How to set up Set up Claude AI integration (requires Anthropic API key) Configure Pipeboard's Meta Ads MCP connection Connect Slack to n8n via OAuth2 Create a list of client account IDs in the workflow configuration Customize your reporting template and Slack delivery settings Requirements n8n version 1.109.2 or newer. Claude AI API access (Anthropic) Pipeboard account Slack workspace access How to customize the workflow Adjust the date range and metrics to track Modify the AI prompts for different types of insights Configure multiple Slack channels for different clients Set up custom scheduling intervals Add email delivery as an additional output channel
by Rahul Joshi
Description: Stay on top of your support pipeline with this Ticket Status Digest automation for Zendesk. Built in n8n, this workflow automatically fetches tickets from Zendesk, filters only open ones, enriches them with requester details, and saves them into Google Sheets. ๐ Instead of manually checking Zendesk, you get a real-time digest of pending tickets with full customer detailsโperfect for support leads who need a quick snapshot of unresolved cases. Whether youโre tracking team workload, prioritizing open issues, or preparing daily status reports, this automation ensures your support data is always structured, centralized, and up to date. ๐ What This Template Does (Step-by-Step) ๐ Trigger โ Manual Start (or Schedule) Begin workflow with a manual trigger (ideal for testing). Can be switched to scheduled runs (daily, hourly) for automated digests. ๐ซ Fetch All Tickets (Zendesk) Pulls all tickets from Zendesk API. Captures ticket ID, subject, description, status, priority, tags, and timestamps. ๐ Filter Open Tickets Only Includes only tickets where status = open. Skips closed, solved, or pending tickets. ๐ค User Information Enrichment Looks up requester details (name, email, organization). Converts raw IDs into human-readable contact info. ๐ Save to Google Sheets Appends/updates ticket rows in โTicket status dummy โ Sheet1โ. Columns: Ticket No. | Description | Status | Owner | Email | Tag. Required Integrations: Zendesk API (OAuth or API Key) Google Sheets (OAuth2 credentials) Best For: ๐งโ๐ผ Support leads monitoring unresolved tickets ๐ Managers building daily ticket status dashboards ๐ค Teams that need centralized visibility of customer issues โฑ๏ธ Anyone tired of manual Zendesk data exports Key Benefits: โ Automated ticket sync to Google Sheets โ Real-time visibility of open issues โ Centralized view with enriched requester details โ Reduces manual tracking and reporting โ Scalable for daily, weekly, or custom digest runs
by InfyOm Technologies
โ What problem does this workflow solve? Accounting teams spend hours manually entering purchase bills into accounting systemsโcopying vendor details, creating items, checking duplicates, and reconciling totals. This workflow removes that manual effort entirely. With OCR + AI + QuickBooks integration, this automation converts uploaded purchase bills into fully reconciled QuickBooks billsโaccurately, consistently, and without human intervention. โ๏ธ What does this workflow do? Accepts multiple purchase bills in a single upload Extracts structured invoice data using OCR + AI Automatically syncs vendors and items with :contentReference[oaicite:0]{index=0} Creates missing vendors or items when needed Generates clean, validated bills inside QuickBooks Prevents duplicate vendors or line items ๐ง How It Works โ Step-by-Step 1. ๐ค Upload Purchase Bills Users upload one or multiple PDF bills using an n8n form Each bill is automatically split and processed individually 2. ๐ OCR & Invoice Data Extraction The workflow extracts text from each PDF An AI extraction engine powered by :contentReference[oaicite:2]{index=2} identifies: Invoice number & dates Vendor details Line items (name, quantity, price, amount) Subtotal, tax, and total 3. ๐ Item & Vendor Reconciliation (QuickBooks) Fetches existing items from QuickBooks If an item does not exist: Automatically creates it Checks if the vendor exists: Creates a new vendor if missing Ensures zero duplicates in QuickBooks 4. ๐งพ Bill Payload Creation Builds a clean QuickBooks-compatible bill payload Maps: Items Vendor Dates Taxes Totals Handles edge cases like missing quantities or unit prices 5. ๐ฐ Bill Creation in QuickBooks Creates a finalized bill inside QuickBooks Each bill is immediately ready for reconciliation and reporting ๐ Tools & Integrations Used n8n Form Trigger** โ Bill upload PDF Extractor** โ Text extraction AI Invoice Parser** โ Structured data extraction QuickBooks API** โ Vendor, item, and bill creation OpenAI / OpenRouter** โ Intelligent field mapping ๐ก Key Benefits โฑ Eliminates hours of manual bill entry ๐ง Intelligent OCR with structured extraction ๐ซ No duplicate vendors or items โก Instant QuickBooks synchronization ๐ Accurate accounting data every time ๐ค Who can use this? Perfect for: ๐งพ Accounting teams ๐ข Finance departments ๐ SMBs using QuickBooks ๐ SaaS platforms automating bookkeeping If you're processing large volumes of purchase bills, this workflow turns documents into structured accounting dataโautomatically.
by Daniel Turgeman
How it works A daily schedule pulls your existing contacts from HubSpot All contacts are bulk-enriched with Lusha in a single API call for efficiency A code node compares current Lusha data against CRM records to detect job title or company changes Changed contacts trigger a CRM update and a Slack alert to the assigned rep Set up steps Install the Lusha community node Add your Lusha API, HubSpot, and Slack credentials Adjust the CRM fetch limit based on your contact volume Activate the workflow to run daily
by Daniel Turgeman
How it works A daily schedule pulls your target accounts from HubSpot All companies are bulk-enriched with Lusha in a single API call A code node detects growth signals: headcount increase, revenue growth, and funding activity For accounts showing signals, Lusha searches for key contacts and alerts your sales team via Slack Set up steps Install the Lusha community node Add your Lusha API, HubSpot, and Slack credentials Define your target account list or ICP filters in HubSpot Set the Slack channel for signal alerts and activate
by James Carter
This n8n template generates a dynamic weekly sales report from Airtable and sends it to Slack. It calculates key sales metrics like total pipeline value, weighted pipeline (based on deal stage), top deal, closed revenue, and win rate.. all formatted in a clean Slack message. How it works A schedule trigger starts the workflow (e.g., every Monday). It fetches deal data from Airtable, splits open vs closed deals, calculates all metrics with JavaScript, and formats the output. The message is then sent to Slack using Markdown for readability. How to use Update the Airtable credentials and select your base and table with fields: Deal Name, Value, Status, etc. Set the Slack channel in the final node to your preferred sales or ops channel. Requirements Airtable base with relevant deal data (see field structure) Slack webhook or token for sending messages Customising this workflow You can adapt the logic to other CRMs like Salesforce or HubSpot, add charts, or tweak stage weights. You can also change the schedule or add filters (e.g., by rep or region).
by Jitesh Dugar
Maximize your conversion rates with this end-to-end automated outreach and lead nurturing system. This workflow manages the entire sales lifecycleโfrom instant contact enrollment via WhatsApp to AI-personalized follow-ups and comprehensive A/B performance trackingโall integrated through WATI, Airtable, and OpenAI. ๐ฏ What This Workflow Does This template operates across four specialized pipelines to ensure no lead is left behind: ๐ฅ Pipeline A: Instant Enrollment Sales reps can enroll a new lead directly from WhatsApp by typing a simple command (e.g., enroll <phone> <name> <company> <campaignId>). The system automatically assigns an A/B testing variant and saves the record to Airtable. โฐ Pipeline B: Intelligent Follow-up Scheduler Every morning at 9 AM, the bot identifies leads due for a touchpoint. OpenAI generates a unique, personalized message based on the lead's profile and assigned tone (Formal vs. Casual), which is then delivered via WATI. ๐ฌ Pipeline C: Engagement & Intent Tracker Every inbound reply is analyzed by AI to detect the lead's intent (e.g., "Interested", "Question", or "Unsubscribe"). The system automatically updates the CRM status and, if a lead unsubscribes or converts, instantly pauses future automated follow-ups. ๐ Pipeline D: Real-time Analytics By sending the command report, you receive an instant performance dashboard showing conversion rates, total engagement, and a clear comparison of which A/B variant is winning. โจ Key Features Command-Based Control:** Manage your entire CRM database using simple WhatsApp keywords like enroll, report, and pause. Dynamic Personalization:** OpenAI crafts context-aware messages that mention the leadโs specific company and name, avoiding the "bot feel" of standard templates. Built-in A/B Testing:** Automatically splits leads into two groups to test different messaging strategies and find what converts best. Reputation Protection:** Immediate status updates for "Unsubscribe" or "Not Interested" intents ensure you remain compliant and professional. Rich CRM Integration:** Uses Airtable to store detailed logs of every sent message and received reply for a complete audit trail. ๐ผ Perfect For SDR & Sales Teams:** Automating the first 5โ7 touchpoints so reps can focus only on "Interested" leads. Event Organizers:** Following up with attendees post-webinar or conference. Recruiters:** Managing candidate outreach and tracking initial screening responses. Agencies:** Running outreach campaigns for multiple clients from a single dashboard. ๐ง What You'll Need Required Integrations WATI:** For WhatsApp triggering and message dispatch. Airtable:** To act as your central campaign database. OpenAI API:** For intelligent message generation and intent detection. Configuration Steps Airtable: Create a base with four tables: Contacts Campaigns FollowUps Engagement Airtable IDs: Replace the placeholder Base and Table IDs in all Airtable nodes. WATI: Set up your WATI API credentials. Ready to scale your outreach? Import this template and connect your Airtable to start automating your follow-up campaigns today!
by Rahul Joshi
Description: Reignite cold leads automatically with this intelligent n8n automation template that integrates Zoho CRM, Azure OpenAI (GPT-4o-mini), and Email. This workflow identifies leads that havenโt been contacted in the last 30 days, generates personalized AI-written emails based on lead data, sends them directly, and updates the CRMโall without manual follow-up. Perfect for sales teams, marketing managers, and business development professionals who want to recover lost opportunities, boost engagement rates, and maintain an active sales pipeline with minimal effort. โ What This Template Does (Step-by-Step) โฐ Daily Trigger Automatically runs on a set schedule (daily or weekly) to check for inactive leads. ๐ Calculate 30 Days Ago Computes the exact date threshold (today โ 30 days) to filter stale leads from Zoho CRM. ๐ Fetch Cold Leads from Zoho Searches Zoho CRM for leads whose Last Activity occurred before the calculated dateโreturning only those needing re-engagement. ๐ค AI Email Generation Uses Azure OpenAI (GPT-4o-mini) to analyze each leadโs data and craft a personalized re-engagement email that reflects their previous interactions, interests, or stage in the funnel. ๐ง Send Personalized Email Delivers the custom AI-generated email directly to each lead. Subject: โLetโs Reconnect!โ Body: Tailored, human-like message written by AI. โ Update CRM Record After each email is sent, the workflow updates the lead in Zoho CRMโmarking them as contacted, refreshing the Last Activity timestamp, and maintaining accurate engagement history. ๐ง Key Features โ๏ธ Smart lead filtering based on inactivity window โ๏ธ AI-crafted, context-aware personalized emails โ๏ธ Seamless Zoho CRM integration for tracking and updates โ๏ธ Fully automated daily execution โ๏ธ Customizable for different CRMs or intervals ๐ผ Use Cases ๐ก Re-engage leads whoโve gone silent for 30+ days ๐ Improve conversion and response rates automatically ๐ค Maintain continuous pipeline nurturing ๐ Save hours of manual email follow-up ๐ฆ Required Integrations โข Zoho CRM API โ for fetching and updating lead data โข Azure OpenAI API (GPT-4o-mini) โ for email personalization โข SMTP / Email API โ for sending re-engagement emails ๐ฏ Why Use This Template? โ Automates your entire cold-lead revival process โ Saves manual outreach time for sales reps โ Increases lead conversion through personalized AI communication โ Keeps CRM data fresh and accurate