by Puspak
Workflow Overview This workflow automatically fetches the latest "Ask HN: Who is hiring?" posts from Hacker News, extracts individual job listings, cleans the raw text, converts them into structured job listings using Google Gemini AI, and saves them into Airtable. Components Itβs a full end-to-end automation system combining: Algolia API** for HN data Text cleaning** Gemini AI (via LangChain)** for parsing job descriptions Structured JSON extraction** Airtable integration** to store the final data π― Use Cases Automatically build a job board from HN posts Track startup hiring trends Feed remote job alerts into a CRM or Slack Enrich a hiring intelligence database π§ Nodes & Services Used HTTP Request (Algolia + Firebase API) SplitOut, Set, Filter, Function, Limit Google Gemini (via LangChain integration) Output Parser Structured Airtable (API token required) π Credentials Required Google Gemini (PaLM/Gemini API) Airtable Personal Access Token Algolia Application ID & API Key (via Header Auth) π¦ Tags hacker-news, jobs, airtable, ai, gemini, automation, hn, langchain, workflow Screenshots
by Hassan
Overview Transform your customer support operations with an intelligent WhatsApp automation system that handles text, voice, and image messages across multiple languages. This comprehensive solution uses advanced AI to provide instant, accurate responses by accessing your company's knowledge base, while maintaining conversation context and supporting both English and Roman Urdu communications. Perfect for businesses serving diverse markets who need 24/7 customer support without the overhead costs. Key Benefits π€ Multi-Modal AI Processing Handle text messages, voice notes, and images seamlessly. The system automatically transcribes audio, analyzes images, and processes all content types through a single intelligent pipeline. π True Multilingual Support Native support for English and Roman Urdu with intelligent language detection and matching responses. The AI automatically detects the customer's language and responds accordingly, making it perfect for South Asian markets. π Dynamic Knowledge Base Integration Real-time access to your Google Docs knowledge base ensures customers always receive current, accurate information about your products and services. No more outdated responses or manual updates needed. π Conversation Memory & Context Advanced memory system maintains conversation history for natural, contextual interactions. Customers can have flowing conversations without repeating information, improving satisfaction rates. β‘ Instant Response Times Automated responses within seconds of receiving messages, dramatically improving customer satisfaction and reducing response time from hours to seconds. π Zero Manual Intervention Fully automated system that works 24/7 without human oversight. Handles inquiries, provides information, and maintains professional communication standards automatically. π Scalable Architecture Built on enterprise-grade n8n platform with robust error handling and retry mechanisms. Can handle thousands of concurrent conversations without performance degradation. π° Cost-Effective Operations Replace expensive customer support teams with intelligent automation. Reduce operational costs by up to 80% while improving response quality and availability. How It Works Phase 1: Message Reception & Classification The system begins with a WhatsApp webhook trigger that captures all incoming messages in real-time. An intelligent switch node immediately analyzes each message to determine its content type - whether it's a text message, voice note, or image with optional caption. This classification is crucial as each media type requires different processing approaches to extract meaningful information. Phase 2: Advanced Media Processing For voice messages, the system retrieves the audio file URL, downloads the content using authenticated requests, and processes it through OpenAI's Whisper transcription service to convert speech to text. Image messages follow a similar pattern - the system downloads the image and uses GPT-4 Vision to analyze and describe the visual content in detail. Text messages are processed directly, while all media types are ultimately converted to standardized text format for consistent AI processing. Phase 3: Intelligent Response Generation The processed content is fed into a sophisticated AI agent powered by Claude Sonnet 4 via OpenRouter. This agent operates with a comprehensive system prompt that defines its role as a professional customer support representative with specific instructions for tone, language handling, and response protocols. The agent has access to a Google Docs tool that allows it to retrieve real-time information from your company's knowledge base. Phase 4: Contextual Memory Management A memory buffer system maintains conversation history for each unique phone number, allowing for natural, flowing conversations where the AI remembers previous interactions and can reference earlier parts of the conversation. This creates a more human-like experience and reduces customer frustration from having to repeat information. Phase 5: Response Delivery Generated responses are automatically sent back to the customer's WhatsApp number using the WhatsApp Business API, completing the conversation loop. The system maintains proper formatting and ensures message delivery confirmation. Required Setup & Database Requirements API Credentials Needed: WhatsApp Business API**: For receiving and sending messages OpenAI API**: For audio transcription and image analysis OpenRouter API**: For Claude Sonnet 4 language model access Google Docs API**: For knowledge base integration n8n Cloud/Self-hosted instance**: For workflow execution Knowledge Base Setup: Google Docs Document**: Structured company information document Document Permissions**: Shared with the Google service account Content Organization**: FAQ format with clear sections for products, services, pricing, and contact information WhatsApp Configuration: Business Phone Number**: Verified WhatsApp Business account Webhook URL**: Configured to point to n8n webhook endpoint Message Templates**: Pre-approved for business communications Business Use Cases E-commerce Support: Handle product inquiries, order status checks, and return policies across multiple languages, perfect for businesses serving diverse customer bases. Service Business Automation: Appointment scheduling, service explanations, and pricing inquiries for consultancies, agencies, and professional services. Restaurant & Food Industry: Menu inquiries, order modifications, and delivery status updates with support for local language preferences. Real Estate: Property inquiries, showing appointments, and market information with ability to process property images sent by clients. Healthcare & Wellness: Appointment booking, service explanations, and general inquiries while maintaining professional communication standards. Education & Training: Course information, enrollment processes, and student support with multilingual capabilities for international programs. Revenue Potential Direct Cost Savings: $3,000-8,000/month in customer support staff salaries Increased Conversion: 25-40% improvement in lead response rates due to instant replies Extended Availability: 24/7 operation captures international and after-hours inquiries worth $2,000-5,000/month additional revenue Scalability: Handle 10x more inquiries without proportional cost increases Customer Satisfaction: Improved response times lead to 15-30% increase in customer retention ROI Timeline: Typical payback period of 2-3 months with ongoing monthly savings of $4,000-12,000 depending on business size. Difficulty Level & Build Time Complexity: Intermediate to Advanced (7/10) Estimated Build Time: 4-6 hours for experienced n8n users Setup Time: 2-3 hours for API configurations and testing Maintenance: Minimal - primarily updating knowledge base content Skills Required: n8n workflow building experience API credential management WhatsApp Business API familiarity Basic understanding of AI language models Detailed Setup Steps 1. API Account Setup (60 minutes) Create and configure accounts for WhatsApp Business, OpenAI, OpenRouter, and Google Cloud Platform. Obtain all necessary API keys and configure proper permissions for each service. 2. n8n Credential Configuration (30 minutes) Add all API credentials to your n8n instance using the credential manager. Test each connection to ensure proper authentication and access permissions. 3. WhatsApp Business Integration (45 minutes) Configure your WhatsApp Business account with webhook URLs pointing to your n8n instance. Set up phone number verification and message template approvals. 4. Knowledge Base Creation (90 minutes) Structure your Google Docs knowledge base with comprehensive information about your business. Include FAQs, product details, pricing, and contact information in an organized format. 5. Workflow Import & Testing (60 minutes) Import the n8n workflow, configure all node parameters with your specific credentials and settings, then conduct thorough testing with different message types and languages. 6. Production Deployment (30 minutes) Deploy the workflow to production, monitor initial performance, and fine-tune system prompts based on real customer interactions. Advanced Customization Options Custom Language Support: Extend beyond English and Roman Urdu by modifying the system prompt and adding language detection for additional languages like Arabic, Hindi, or French. Integration Expansions: Connect additional data sources like CRM systems, databases, or e-commerce platforms to provide more comprehensive customer information. Advanced Analytics: Add logging nodes to track conversation metrics, response times, and customer satisfaction scores for continuous improvement. Multi-Channel Support: Extend the system to handle Telegram, Facebook Messenger, or other messaging platforms using similar processing logic. Escalation Protocols: Implement human handoff triggers for complex queries that require personal attention, with automatic notification systems for support teams. Custom AI Models: Swap Claude Sonnet 4 for other models like GPT-4, Gemini, or open-source alternatives based on your specific needs and budget requirements. This automation system represents the future of customer support - intelligent, scalable, and incredibly cost-effective while maintaining the personal touch that customers expect from quality businesses.
by Grigory Frolov
WordPress Blog to Google Sheets Sync Posts β’ Categories β’ Tags β’ Media 𧩠Overview This n8n workflow automatically syncs your WordPress website content β including posts, categories, tags, and media β into Google Sheets. It helps automate content reporting, SEO analysis, and data backups. The workflow can run on schedule or on demand via a webhook. π‘ Use cases Maintain a live database of blog posts in Google Sheets. Create dashboards in Google Data Studio or Looker Studio. Track new articles for newsletters or social media scheduling. Backup all WordPress content and media outside of your CMS. βοΈ Prerequisites Before importing the workflow, ensure you have: A WordPress website with the REST API enabled (default in WP 4.7+). Authentication: either Application Passwords or Basic Auth credentials. A Google Sheet with the following tabs: Posts Categories Tags Media The following credentials configured in n8n: HTTP Basic Auth (for WordPress) Google Sheets OAuth2 π Setup instructions Import the workflow into your n8n instance. Replace all example WordPress API URLs with your domain, for example: https://yourdomain.com/wp-json/wp/v2/ Connect your HTTP Basic Auth credentials (WordPress username + Application Password). Connect your Google Sheets OAuth2 account. Update the spreadsheet ID in each Google Sheets node with your own. Adjust the Schedule Trigger (e.g. run daily at 2:00 AM). Run once manually to verify data sync. π§ Workflow structure | Section | Description | |----------|--------------| | Schedule / Webhook Trigger | Starts the workflow manually or automatically | | Variables & Loop Vars | Initialize pagination for REST API requests | | Get Posts β Split Out β Update Posts | Fetch and update all WordPress posts | | Get Categories β Update Categories | Sync WordPress categories | | Get Tags β Update Tags | Sync WordPress tags | | Get Media β Split Out β Update Media | Sync media library (images, videos, etc.) | | IF Loops | Handles pagination logic until all items are retrieved | β οΈ Notes & Limitations Works with standard WordPress REST API endpoints only. Custom post types require editing endpoint URLs. The per_page value defaults to 10; increase for faster syncs. For large sites, consider increasing n8n memory or adding execution logs. Avoid running the workflow too frequently to prevent API rate limits. π₯ Video Tutorial A step-by-step setup guide is available here: π https://www.youtube.com/watch?v=czSMWyD6f-0 Please subscribe to my YouTube channel to support me: π https://www.youtube.com/@gregfrolovpersonal π¨βπ» Author Created by: Grigory Frolov SEO & Automation Specialist β helping businesses integrate WordPress, AI, and data tools with n8n. π§Ύ License This workflow is provided under the MIT License. Feel free to use, modify, and share improvements with the community.
by Shrey
This workflow can be used to save all of your workflows in: a raw state (as a json file in Dropbox) an Airtable base, in a pre-designed format. It runs periodically (currently, every 30 minutes) and either updates (if already existing in Airtable) or creates a new record in Airtable for each workflow. Here's the Airtable base to give you an idea: View Airtable base Note: This workflows uses the "http://localhost:5678/rest" API which the UI editor uses but is still not officially supported. Hence, it may suffer breaking changes at some point in the future and the workflow might become dysfunctional then.
by Oneclick AI Squad
AI-Driven Tax Compliance & Deadline Management System Description Automate tax deadline monitoring with AI-powered insights. This workflow checks your tax calendar daily at 8 AM, uses GPT-4 to analyze upcoming deadlines across multiple jurisdictions, detects overdue and critical items, and sends intelligent alerts via email and Slack only when immediate action is required. Perfect for finance teams and accounting firms who need proactive compliance management without manual tracking. ποΈπ€π Good to Know AI-Powered**: GPT-4 provides risk assessment and strategic recommendations Multi-Jurisdiction**: Handles Federal, State, and Local tax requirements automatically Smart Alerts**: Only notifies executives when deadlines are overdue or critical (β€3 days) Priority Classification**: Categorizes deadlines as Overdue, Critical, High, or Medium priority Dual Notifications**: Critical alerts to leadership + daily summaries to team channel Complete Audit Trail**: Logs all checks and deadlines to Google Sheets for compliance records How It Works Daily Trigger - Runs at 8:00 AM every morning Fetch Data - Pulls tax calendar and company configuration from Google Sheets Analyze Deadlines - Calculates days remaining, filters by jurisdiction/entity type, categorizes by priority AI Analysis - GPT-4 provides strategic insights and risk assessment on upcoming deadlines Smart Routing - Only sends alerts if overdue or critical deadlines exist Critical Alerts - HTML email to executives + Slack alert for urgent items Team Updates - Slack summary to finance channel with all upcoming deadlines Logging - Records compliance check results to Google Sheets for audit trail Requirements Google Sheets Structure Sheet 1: TaxCalendar DeadlineID | DeadlineName | DeadlineDate | Jurisdiction | Category | AssignedTo | IsActive FED-Q1 | Form 1120 Q1 | 2025-04-15 | Federal | Income | John Doe | TRUE Sheet 2: CompanyConfig (single row) Jurisdictions | EntityType | FiscalYearEnd Federal, California | Corporation | 12-31 Sheet 3: ComplianceLog (auto-populated) Date | AlertLevel | TotalUpcoming | CriticalCount | OverdueCount 2025-01-15 | HIGH | 12 | 3 | 1 Credentials Needed Google Sheets - Service Account OAuth2 OpenAI - API Key (GPT-4 access required) SMTP - Email account for sending alerts Slack - Bot Token with chat:write permission Setup Steps Import workflow JSON into n8n Add all 4 credentials Replace these placeholders: YOUR_TAX_CALENDAR_ID - Tax calendar sheet ID YOUR_CONFIG_ID - Company config sheet ID YOUR_LOG_ID - Compliance log sheet ID C12345678 - Slack channel ID tax@company.com - Sender email cfo@company.com - Recipient email Share all sheets with Google service account email Invite Slack bot to channels Test workflow manually Activate the trigger Customizing This Workflow Change Alert Thresholds: Edit "Analyze Deadlines" node: Critical: Change <= 3 to <= 5 for 5-day warning High: Change <= 7 to <= 14 for 2-week notice Medium: Change <= 30 to <= 60 for 2-month lookout Adjust Schedule: Edit "Daily Tax Check" trigger: Change hour/minute for different run time Add multiple trigger times for tax season (8 AM, 2 PM, 6 PM) Add More Recipients: Edit "Send Email" node: To: cfo@company.com, director@company.com CC: accounting@company.com BCC: archive@company.com Customize Email Design: Edit "Format Email" node to change colors, add logo, or modify layout Add SMS Alerts: Insert Twilio node after "Is Critical" for emergency notifications Integrate Task Management: Add HTTP Request node to create tasks in Asana/Jira for critical deadlines Troubleshooting | Issue | Solution | |-------|----------| | No deadlines found | Check date format (YYYY-MM-DD) and IsActive = TRUE | | AI analysis failed | Verify OpenAI API key and account credits | | Email not sending | Test SMTP credentials and check if critical condition met | | Slack not posting | Invite bot to channel and verify channel ID format | | Permission denied | Share Google Sheets with service account email | π Professional Services Need help with implementation or customization? Our team offers: π― Custom workflow development π’ Enterprise deployment support π Team training sessions π§ Ongoing maintenance π Custom reporting & dashboards π Additional API integrations Discover more workflows β Get in touch with us
by Matthew
AI-Powered Viral Video Factory π This workflow automates the entire process of creating short, cinematic, fact-based videos ready for social media. It takes a single concept, generates a script and visuals, creates video clips, adds a voiceover, and assembles a final video, which is then uploaded directly to your Google Drive. It's perfect for content creators and marketing agencies looking to scale video production with minimal manual effort. How It Works π¬ Generate a Viral Idea π‘: The workflow begins with the Create New Idea1 (OpenAI) node, which generates a viral-ready video concept, including a punchy title, hashtags, and a brief description based on a core theme (e.g., space, black holes). This idea is then logged in a Google Sheet. Create a Cinematic Script & Voiceover π: An OpenAI node (Generating scenes1) creates a detailed 12-scene script, outlining the visuals for a 60-second video. The script text for all scenes is combined and prepared for voiceover generation by another OpenAI node (Generate Voiceover). Generate Scene-by-Scene Visuals β¨: The workflow loops through each of the 12 scenes to create an animated clip: Image Generation: An HTTP Request node sends the scene's prompt to the fal-ai/flux model to create a photorealistic still image. Animation Prompting: The Video Prompts1 (OpenAI Vision) node analyzes the generated image and creates a new, specific prompt to animate it cinematically. Image-to-Video: Another HTTP Request node uses the fal-ai/kling-video model to turn the still image into a 5-second animated video clip based on the new animation prompt. Assemble the Final Video ποΈ: Stitch Clips: Once all 12 clips are generated, the Merge Clips node uses the fal-ai/ffmpeg-api to concatenate them into a single, seamless 60-second video. Add Audio: The Combine Voice and Video node then layers the AI-generated voiceover onto the stitched video. Deliver to Google Drive π: Finally, the completed video is converted from a URL to a file and automatically uploaded to your specified Google Drive folder for easy access and publishing. Key Technologies Used n8n**: For orchestrating the entire automated workflow. OpenAI (GPT-4.1 & GPT-4o)**: For idea generation, scriptwriting, voiceover, and vision analysis. Fal.ai**: For high-performance, API-based image generation (Flux), video animation (Kling), and video processing (FFMPEG API). Google Drive & Sheets**: For logging ideas and storing the final video output. Setup Instructions Add Credentials: In n8n, add your OpenAI API key. Connect your Google account for Google Sheets and Google Drive access. You will need a Fal.ai API Key. Configure Fal.ai API Key: Crucially, you must replace the placeholder API key in all HTTP Request nodes that call the fal.run URL. Find the Authorization header in each of these nodes and replace the existing key with your own Key YOUR_FAL_AI_KEY_HERE. Nodes to update: Create Images1, Get Images1, Create Video1, Get Video1, Merge Clips, Get Final video, Combine Voice and Video. Configure OpenAI Nodes: Select each OpenAI node (e.g., Create New Idea1, Generating scenes1) and choose your OpenAI credential. You can customize the main prompt in the Create New Idea1 node to change the theme of the videos you want to generate. Configure Google Sheets & Drive: In the Organise idea, caption etc1 node, select your Google Sheets credential and specify the Spreadsheet and Sheet ID you want to use for logging ideas. In the Upload file to drive node, select your Google Drive credential and choose the destination folder for your final videos.
by Bhautik Trambadia
This workflow automatically monitors and reports data quality for any SQL table using configurable checks and thresholds. It evaluates key metricsβincluding null values, duplicate records, row count anomalies, and outliersβand assigns a clear PASS, WARN, or FAIL status. Designed for efficiency, the workflow dynamically injects table and column names from a central Config node, so you donβt need to edit SQL queries manually. All checks run in parallel, and results are consolidated into a structured HTML report with clear status indicators. The report is automatically sent via email and logged into Google Sheets for historical tracking, auditing, and trend analysis. βοΈ Setup Update the Config node with your table name, column names, thresholds, and email recipient. Connect your database credentials (Postgres/MySQL) in all query nodes. Set up Gmail or SMTP credentials in the email node. Connect your Google Sheets account and ensure required columns exist. Activate the workflow (runs daily by default, can be customized). This workflow is ideal for data analysts and analytics engineers who want a lightweight, automated solution to proactively monitor data quality without exporting large datasets or building complex pipelines.
by nXsi
This n8n template monitors your self-hosted apps for new releases across GitHub and container registries, uses Claude AI to analyze changelogs, and delivers color-coded update digests to Discord, Telegram, Slack, and ntfy. Stop finding out about updates after something breaks. Claude reads every changelog and tells you exactly what changed, what might break, and how urgent the update is β with a ready-to-run Docker update command for each release. Good to know Estimated cost is $0.01β0.03 per daily run using Claude Haiku. See Anthropic pricing for current rates. PostgreSQL logging is included but optional β the core workflow runs without a database using n8n's built-in static data for version tracking. Test mode is ON by default. Your first run pushes a sample release through the full pipeline (AI analysis, formatting, delivery) so you can verify everything works before going live. How it works Schedule trigger runs daily at 8 AM and builds a watchlist from your manually configured repos plus optional docker-compose auto-detection Checks GitHub Releases API for repos and Docker Hub/GHCR tag APIs for container images. Pre-releases and RC/beta tags are automatically filtered out Compares each release against the last known version stored in workflow static data to detect what's genuinely new Claude Haiku reads each changelog and returns a structured summary with breaking change detection, CVE/security scanning, migration steps, and urgency classification (critical/recommended/optional) Alert rules route critical and security updates to instant alerts, while everything else batches into a single daily digest sorted by urgency Formatted messages are delivered to your enabled channels with color-coded embeds, Docker update commands, and links to full release notes Release history is optionally logged to PostgreSQL for tracking update timelines How to use Add your Anthropic API key as an n8n credential, open the Configure Watcher node to set your channel URLs, and edit the Build Repo Watchlist node to add your repos β that's the minimum to get running Click "Test workflow" to push a sample release through the full pipeline and verify delivery Set test_mode to false and toggle Active β the workflow checks daily and only alerts when new releases are found Requirements Anthropic API key (setup guide) At least one delivery channel: Discord webhook (setup guide), Telegram bot, Slack app, or ntfy topic Optional: GitHub Personal Access Token for higher API rate limits (setup guide) Optional: PostgreSQL for release history logging Customizing this workflow Add or remove repos and container registries in the Build Repo Watchlist code node β pre-loaded with 10 popular self-hosted apps Enable docker-compose auto-detection to automatically build your watchlist from a compose file URL or pasted content Set per-repo alert rules including urgency overrides, instant alert flags, and channel routing Adjust the schedule, swap delivery channels, or add additional registries
by Oneclick AI Squad
This workflow provides real-time detection of ransomware encryption patterns using Claude AI, with automated system isolation and incident response. How it works File System Monitoring - Continuously monitors file operations (create, modify, rename, delete) across critical directories Behavior Pattern Collection - Aggregates file operation metrics in 30-second windows (entropy changes, extension changes, I/O velocity) AI Threat Analysis - Claude AI analyzes patterns against known ransomware behaviors (mass encryption, shadow copy deletion, etc.) Threat Scoring & Classification - Assigns threat scores (0-100) and classifies attack types (crypto-locker, wiper, etc.) Auto-Isolation Decision - Determines if immediate network isolation is required based on confidence thresholds System Quarantine - Executes automated isolation: disable network adapters, block shares, kill suspicious processes Forensic Snapshot - Captures system state, process tree, network connections, and file operation logs Incident Response Alert - Notifies SOC team with detailed threat intelligence and recommended actions Evidence Preservation - Stores forensic data and AI analysis in SIEM for investigation Detection Capabilities Entropy Analysis**: Detects high-entropy file creation (encrypted data signature) Extension Scanning**: Identifies suspicious extension changes (.docx β .locked, .encrypted, .crypted) I/O Velocity**: Flags abnormal file modification rates (>100 files/min) Shadow Copy Deletion**: Detects vssadmin.exe / wmic.exe shadow copy deletion attempts Ransom Note Detection**: Identifies README.txt, HOW_TO_DECRYPT.html creation patterns Lateral Movement**: Monitors SMB/RDP connection spikes from infected hosts Process Behavior**: Analyzes suspicious parent-child process relationships Setup Steps Import workflow into n8n Configure credentials: Anthropic API - Claude AI for threat analysis Windows Event Collector / Sysmon - File system event source EDR API (CrowdStrike/Defender/SentinelOne) - For isolation commands SIEM API (Splunk/Elastic) - For log forwarding Slack/PagerDuty - For SOC alerts Install file system watcher on monitored endpoints (sysmon, osquery, or auditd) Configure isolation thresholds (default: threat_score >= 75) Test isolation procedure in sandbox environment Activate workflow Sample Detection Event { "hostname": "DESKTOP-WKS-042", "username": "jdoe", "timestamp": "2025-02-25T14:23:17Z", "detection_window_seconds": 30, "file_operations": { "files_modified": 247, "files_renamed": 189, "files_created": 58, "files_deleted": 31, "avg_entropy_increase": 7.89, "suspicious_extensions": [".locked", ".crypted", ".encrypted"], "ransom_notes_created": ["README_DECRYPT.txt", "HOW_TO_RECOVER.html"] }, "process_activity": { "high_io_processes": [ {"name": "explorer.exe", "pid": 4782, "io_rate": "523 ops/sec"}, {"name": "svchost.exe", "pid": 2194, "io_rate": "412 ops/sec"} ], "suspicious_commands": [ "vssadmin.exe delete shadows /all /quiet", "wmic shadowcopy delete", "bcdedit /set {default} recoveryenabled no" ] }, "network_activity": { "c2_connections": [ {"ip": "185.220.101.32", "port": 443, "country": "RU"}, {"ip": "194.165.16.85", "port": 8443, "country": "NL"} ], "lateral_movement": [ {"target": "FILE-SERVER-01", "protocol": "SMB", "status": "success"}, {"target": "DB-SERVER-03", "protocol": "RDP", "status": "failed"} ] } } Threat Intelligence Sources MITRE ATT&CK Framework (T1486 - Data Encrypted for Impact, T1490 - Inhibit System Recovery) Known ransomware families: LockBit, BlackCat/ALPHV, Royal, Play, Cl0p File extension IOCs from ransomware tracking feeds Behavioral signatures from recent campaigns Compliance & Forensics Chain of Custody**: All isolation actions logged with timestamps and justifications NIST CSF Alignment**: DE.CM-7 (Monitoring for unauthorized activity), RS.MI-3 (Incident containment) Evidence Integrity**: Forensic snapshots include cryptographic hashes for court admissibility Post-Incident Review**: AI analysis archived for threat hunting and pattern improvement
by Nour
Automatically identifies overdue sales leads and generates personalized follow-up emails using AI. How it works Runs every weekday Reads leads from Google Sheets Filters leads with no contact for 5+ days Downloads last meeting transcript from Google Drive Uses Google Gemini to write a personalized email Saves the email as a Gmail Draft for review Updates lead status in the Sheet Setup Google Sheets with columns: Current Status, Last Contact, Name, Company, Email, Meeting Transcript, Sales Rep Google Drive access for transcript files Google Gemini API key (free from Google AI Studio) Gmail account Slack workspace Supported file types PDF TXT Notes Emails are saved as drafts only β not sent automatically Supported lead statuses: New Skips leads with status: Draft Created, Sent, Closed Inspiration This workflow was built to solve a real problem at an educational institute. The sales team needed someone to remind them about follow-ups and draft personalized emails β but hiring a personal assistant wasn't financially feasible. Based on that, this system acts as that assistant: it tracks overdue leads, reads meeting transcripts, and writes personalized follow-up emails automatically. I kept this stack free where possible β using Google Gemini's free tier for AI. For small sales teams, I believe the daily token limits are more than sufficient, making this a zero-cost automation.
by Cheng Siong Chin
How It Works This workflow automates enterprise risk management by intelligently routing risks across three severity tiers. Built for compliance teams and risk managers, it eliminates manual evaluation bottlenecks and inconsistent escalation. The system retrieves risk data from spreadsheets, calculates severity indicators, then routes items through specialized AI agentsβcritical risks trigger coordinated multi-agent assessment with Gmail and Slack alerts, medium risks undergo standard AI evaluation, while low risks receive automated acknowledgment. Each severity level follows distinct processing paths ensuring appropriate review depth, stakeholder notification, and audit documentation. Setup Steps Connect Google Sheets with risk data Configure Anthropic API credentials for Claude Model nodes Set up Gmail authentication for notification delivery Connect Slack workspace and specify channel IDs for critical/low risk alerts Customize risk thresholds Update parser regex patterns in Code nodes matching assessment output format Prerequisites Active accounts: Google Sheets, Anthropic Claude API, Gmail, Slack. Use Cases Enterprise compliance monitoring, operational risk management Customization Modify scoring formulas, adjust severity thresholds, add custom AI criteria Benefits Eliminates manual triage, ensures consistent standards, accelerates critical response
by Dinakar Selvakumar
HR Client Acquisition (Part 1) β Job Lead Discovery & AI Qualification System This n8n template helps recruitment agencies discover active job openings, filter them based on hiring relevance, and qualify them using AI β specifically designed for semi-skilled manpower hiring use cases. What this template demonstrates Job lead discovery using Apify scraping Hash-based deduplication to avoid duplicate entries Batch processing using Split In Batches Google Sheets as a structured lead database AI-based lead qualification with strict JSON outputs Separation between scraping, processing, and scoring Use cases Recruitment agencies sourcing overseas job demand HR consultancies targeting bulk hiring companies Manpower supply businesses (semi-skilled labor focus) Job demand validation before outreach Building job-based lead pipelines How it works User submits job roles and locations via form Inputs are expanded into multiple search combinations Apify scrapes job listings based on these inputs Jobs are normalized and assigned unique identifiers Existing jobs in Google Sheets are checked for duplicates Only new jobs are stored and processed Missing company data is enriched if required AI scores each job based on hiring relevance Jobs are marked as qualified or not qualified Final results are saved back into Google Sheets How to use Submit job roles and locations using the form trigger Connect your Apify API credentials Connect your Google Sheets account Add your OpenAI API key Run the workflow in test mode Check results inside Google Sheets Adjust scoring logic if needed Requirements n8n (Cloud or Self-hosted) Apify account for job scraping Google Sheets for storage OpenAI or compatible LLM API Customising this workflow Modify job roles to match your niche (e.g., drivers, welders, helpers) Adjust AI scoring logic for your hiring criteria Replace Google Sheets with a database if needed Add filters like salary, visa type, or urgency Extend workflow for enruching & outreach automation (Part 2) Good to know This template focuses only on job discovery and qualification It is designed for semi-skilled manpower hiring workflows AI scoring can be customized for any industry or role No outreach is performed in this workflow Works best with consistent job data sources Who this is for Recruitment agencies working with overseas clients HR consultants sourcing bulk hiring opportunities Founders building recruitment automation systems Anyone building a job-based lead generation pipeline