by Madame AI
Monitor Clutch categories for new agencies to Slack With BrowserAct and Gemini Introduction This workflow automates the discovery of new B2B service providers entering the market. It scrapes a specific category on Clutch.co weekly, standardizes the data using AI, and compares it against a historical database to identify only the fresh "new entrants." These leads are then sent to Slack as a "Hot Alert." Target Audience Sales Development Representatives (SDRs), partnership managers, and lead generation agencies looking for new agencies or service providers before their competitors find them. How it works Scheduling: A Weekly Trigger initiates the scan to ensure regular monitoring of the market. Targeting: A Set node defines the specific Clutch category URL to monitor (e.g., https://clutch.co/developers). Data Extraction: The BrowserAct node runs the "The New Entrant Asset Finder" template. It navigates to the target category and scrapes the current list of companies. Data Cleaning: An AI Agent (using OpenRouter/Gemini) processes the raw scraped data. It fixes formatting issues, such as converting "$10,000+" to integers and splitting "City, Country" strings into separate fields. Staging: The cleaned data is written to a temporary "Second Extraction" sheet in Google Sheets. Change Detection: The workflow retrieves the previous week's data ("Database") and the current week's data. A second AI Agent compares the two lists to identify companies that exist in the new scan but not the old one. Notification: If new companies are found, a Slack node posts a formatted alert with details like "Company Name," "Rate," and "Website." Database Update: The workflow clears the old database and replaces it with the latest scan, establishing a new baseline for the next week's comparison. How to set up Configure Credentials: Connect your BrowserAct, OpenRouter, Google Sheets, and Slack accounts in n8n. Prepare BrowserAct: Ensure the The New Entrant Asset Finder template is active in your BrowserAct library. Prepare Google Sheet: Create a Google Sheet with two tabs: Database (First Extarction) Second Extraction Define Target: Open the Clutch Category Link node and paste the URL of the Clutch category you want to track. Configure IDs: Update the Google Sheets nodes to point to your specific spreadsheet file and the respective tabs mentioned above. Google Sheet Headers To use this workflow, ensure your Google Sheet tabs use the following headers: company_name website_url min_project_value_usd hourly_rate_low hourly_rate_high employees_range city country short_description Requirements BrowserAct Account:* Required for scraping. Template: *The New Entrant Asset Finder**. OpenRouter Account:** Required for cleaning data and detecting changes. Google Sheets:** Acts as the historical database. Slack Account:** Used for receiving lead alerts. How to customize the workflow Change the Source: Modify the Clutch Category Link and the BrowserAct template to scrape a different directory, such as G2, Capterra, or Upwork. Filter Logic: Update the system prompt in the Detect data changes AI node to only alert on companies with a specific hourly rate (e.g., >$100/hr) or employee count. Enrichment: Add a Clearbit or Apollo node after the change detection step to find email addresses for the new companies before sending them to Slack. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video AI-Powered Lead Finder: Target New & Growing Companies (n8n + AI Tutorial)
by Sona Labs
Automatically analyzes your Google Ads performance every Monday and sends a comprehensive report to your inbox with AI-powered insights, week-over-week comparisons, and prioritized recommendations to optimize your campaigns. How it works Step 1: Schedule Weekly Analysis Triggers automatically every Monday at midnight Can be customized to your preferred schedule Initiates the entire data collection and analysis process Step 2: Collect Performance Data Fetches last 7 days of Google Ads data via API Retrieves previous 7 days of data (days 8-14) for comparison Extracts key metrics including impressions, clicks, cost, conversions, CTR, and CPA Calculates and summarizes performance for each week Identifies top performers, problem campaigns, and efficiency trends Merges data to create comprehensive week-over-week comparison Step 3: AI-Powered Analysis Aggregates all performance data into a single view Sends data to AI Analyst powered by GPT-5.1 AI analyzes trends, identifies insights, and spots anomalies Diagnoses root causes of performance changes Generates actionable, prioritized recommendations based on business impact Calculates efficiency metrics and budget optimization opportunities Step 4: Deliver Insights Report Formats analysis into a professional HTML report Emails comprehensive insights directly to your inbox Includes executive summary, week-over-week comparison tables, and color-coded metrics Provides high/medium/low priority action items Ready for immediate action and strategy adjustments What you'll get The workflow delivers a comprehensive weekly analysis with: Performance Metrics**: Impressions, clicks, CTR, conversions, cost, CPA, and efficiency trends Week-over-Week Comparison**: Side-by-side analysis with percentage changes and visual indicators Top Performers Analysis**: Detailed breakdown of your best-performing campaigns Issues & Performance Risks**: Identification of campaigns with high spend but zero conversions, declining CTR, or rising CPA AI-Generated Insights**: Intelligent pattern recognition and trend analysis with root cause diagnosis Actionable Recommendations**: Prioritized action items (high/medium/low) with expected impact and risk levels Budget Efficiency Analysis**: Spend allocation recommendations and wasted spend identification Campaign Intelligence**: Clear understanding of what's working and what needs attention Data Confidence Assessment**: Commentary on sample size adequacy and metric reliability Automated Delivery**: Weekly HTML report sent directly to your email without manual effort Why use this Save time on reporting**: Eliminate 2-3 hours of manual weekly analysis and report creation Never miss insights**: AI catches trends and patterns humans might overlook Consistent monitoring**: Automated weekly reviews ensure you stay on top of performance Data-driven decisions**: Make strategic adjustments based on comprehensive analysis with clear priorities Early problem detection**: Spot performance issues and wasted spend before they impact your budget Optimize continuously**: Regular insights enable ongoing campaign refinement Focus on strategy**: Spend less time analyzing data, more time implementing improvements Scalable intelligence**: Works whether you manage 1 campaign or 100 Executive-ready reports**: Professional HTML format suitable for sharing with stakeholders Setup instructions Before you start, you'll need: Google Ads Account & API Access Go to your Google Ads account at https://ads.google.com Find your Customer ID (XXX-XXX-XXXX format in top-right corner) Get a Developer Token from Google Ads API Center Enable API access for your account OpenAI API Key (for GPT-5.1 AI analysis) Sign up at https://platform.openai.com Navigate to API keys section and create a new key Ensure you have access to GPT-5.1 model Gmail Account (for receiving reports) OAuth2 authentication will be used No app password needed Configuration steps: Replace Google Ads Customer ID: Open both "Get Last Week Data" and "Get Previous Week Data" HTTP Request nodes In the URL field, replace [Customer ID] with your actual Customer ID (format: XXX-XXX-XXXX) Add Developer Token: In both HTTP Request nodes, add your Google Ads Developer Token to the header parameters Connect Google Ads OAuth2: In both HTTP Request nodes, authenticate with your Google Ads credentials Select your ad account Connect OpenAI credentials: In the "OpenAI Chat Model" node, add your OpenAI API key Verify GPT-5.1 model is selected Configure email delivery: In the "Email Report to User" node, connect your Gmail OAuth2 credentials Update the recipient email address (default: lee@sonalabs.com) Customize subject line if desired Set your schedule (optional): In the "Weekly Trigger" node, configure your preferred day and time Default is Monday at midnight Test the workflow: Click "Execute Workflow" to run manually Verify data pulls correctly from Google Ads Check that AI analysis provides meaningful insights Confirm email report arrives formatted correctly Customize analysis focus (optional): Open the "AI Analyst" node Adjust the prompt to prioritize specific metrics or goals for your business Modify thresholds for "problem campaigns" in the calculation nodes Activate automation: Enable the workflow to run automatically every Monday Monitor the first few reports to ensure accuracy Note: The workflow analyzes the last 7 days vs. the previous 7 days, giving you rolling two-week comparisons every Monday. Adjust the date ranges in the HTTP Request nodes if you need different time periods.
by Tony Adijah
Who is this for? This workflow is built for founders, sales teams, solopreneurs, and agencies who want to automate outbound sales without expensive tools. Perfect for anyone doing cold email outreach who wants AI-powered personalization at scale. What it does The workflow runs three automated flows: Flow 1 — New Lead Processing (8 AM weekdays): Reads new leads from Google Sheets Scrapes the lead's website to build a research dossier AI scores each lead (0–100) on company fit, role fit, timing signals, and engagement potential For leads scoring 40+, AI generates 3 personalized cold emails with different angles Sends Email 1 immediately and saves all 3 emails to the sheet Low-fit leads are marked as skipped Flow 2 — Follow-up Engine (every 2 hours weekdays): Checks for leads that need follow-ups Sends Email 2 after 3 days, Email 3 after 7 days Automatically marks sequence as complete after Email 3 Skips leads that have already replied Flow 3 — Reply Detection (every 2 hours weekdays): Searches Gmail for replies from active leads Filters out your own sent emails to avoid false positives When a reply is found, marks the lead as "replied" and stops the sequence Sends a Telegram alert with the reply preview Setup steps Google Sheets — Create a spreadsheet with columns: Lead Name, Email, Company, Website, Role/Title, Status, Reply Date, Reply Subject, Reply Snippet, and email tracking columns (see sticky notes in the workflow for full list) Gmail OAuth2 — Connect your Gmail account for sending emails and searching replies Ollama — Install locally and pull your preferred model (e.g., ollama pull mistral). You can also swap for OpenAI or Anthropic Telegram Bot — Create via @BotFather, get your bot token and chat ID AI Lead Scorer prompt — Edit the system prompt with your product, ICP, and scoring criteria AI Email Writer prompt — Edit with your name, company, value prop, and one specific result Sender name — Update the sender name in the Extract Emails code node (line 12) and Find Follow-ups code node (line 9) Gmail address — Set your sending Gmail address in the Filter Active Leads code node (line 10) and Check Reply Results code node (line 10) Test — Add a test lead with status "new", run the research flow manually, verify emails generate correctly, then enable all schedules Requirements Self-hosted n8n (uses Ollama nodes) Ollama running locally with at least one model installed Google Sheets OAuth2 credentials Gmail OAuth2 credentials Telegram Bot credentials How to customize Adjust the scoring threshold (default 40) in the Extract Score node to be more or less selective Change follow-up timing (default 3 and 7 days) in the Find Follow-ups code node Modify cron schedules on any trigger to match your timezone and preferences Swap Ollama for OpenAI or Anthropic by replacing the LLM nodes Add a LinkedIn enrichment step before the dossier builder for richer research Customize email tone and sign-off in the AI Email Writer system prompt
by Cheng Siong Chin
How It Works This workflow automates end-to-end audio translation with quality assurance for content creators, educators, and international teams managing multilingual content. It solves the challenge of translating audio into multiple languages while ensuring accuracy and maintaining organized delivery. The system receives audio files via webhook, splits them into target languages (Arabic, French, Spanish, Chinese, Hindi), and processes each through NVIDIA's Parakeet TDT translation model. OpenAI validates translation quality, and results are enhanced with comprehensive metadata. Successfully translated files are uploaded to Google Drive with organized naming, combined into a summary spreadsheet, and delivered via email notification. Failed translations trigger quality alerts, ensuring reliable output while minimizing manual oversight and reducing translation turnaround time from hours to minutes. Setup Steps Configure NVIDIA API credentials in the "Generate Audio with ElevenLabs" Add OpenAI API key for quality evaluation in the "OpenAI Chat Model" node Set up Google Drive OAuth connection and specify target folder ID for uploads Configure Gmail SMTP credentials for notification delivery Update webhook URL in source applications to trigger workflow Customize target languages in "Split Languages" node if needed Prerequisites Active accounts: NVIDIA (build.nvidia.com), OpenAI, Google Drive, Gmail. API credentials for all services. Use Cases International podcast distribution, e-learning course localization Customization Modify target languages in Split node, adjust quality thresholds in OpenAI evaluation Benefits Reduces translation time by 90%, eliminates manual quality checks through automated validation Here are clear, professional subheadings for each What / Why pair. They’re concise, action-oriented, and fit well in technical workflow documentation.
by Cheng Siong Chin
How It Works Scheduled processes retrieve customer feedback from multiple channels. The system performs sentiment analysis to classify tone, then uses OpenAI models to extract themes, topics, and urgency indicators. All processed results are stored in a centralized database for trend tracking. Automated rules identify high-risk or negative sentiment items and trigger alerts to the relevant teams. Dashboards and workflow automation then visualize insights and support follow-up actions. Setup Instructions Data Sources: Connect social media APIs, survey tools, and customer support platforms. AI Analysis: Configure the OpenAI API with sentiment and theme-extraction prompts. Database: Set up a feedback storage schema in your utility database. Alerts: Configure email notifications and CRM triggers for priority issues. Dashboards: Link your analytics and reporting tools for real-time insights. Prerequisites Social media/survey API credentials; OpenAI API key; database access; CRM system credentials; email notification setup Use Cases Customer sentiment tracking; product feedback aggregation; support ticket prioritization; brand monitoring; trend identification Customization Adjust sentiment thresholds; add new feedback sources; modify categorization rules Benefits Reduces analysis time 85%; captures actionable insights; enables rapid response to issues
by WeblineIndia
Quick Overview This workflow scans an RSS blog feed on a schedule, logs newly found posts to Google Sheets, uses OpenAI to generate role-based LinkedIn drafts, and emails approval links via Gmail; approved drafts are then published to LinkedIn and tracked in Google Sheets, with Slack alerts on failures. How it works Runs on a schedule and reads the latest item from your blog’s RSS feed. Checks Google Sheets to see if the blog URL has already been processed and continues only for new posts. Formats the blog details, saves the blog as processed in Google Sheets, and passes the content into a linked “AI Content Personalization Engine” workflow. Receives the blog content from the sub-workflow, defines employee personas (CEO, HR, Developer, Marketing), and uses OpenAI to generate a LinkedIn draft per role. Stores each generated draft in a Google Sheets “generated_posts” tab with a Pending status and emails approval/rejection links via Gmail. Receives an approve/reject webhook click, updates the post’s status in Google Sheets, and returns a confirmation response to the browser. Fetches approved posts from Google Sheets, posts unpublished items to LinkedIn via the LinkedIn API, marks them as published in Google Sheets when creation succeeds, and sends a Slack alert if the LinkedIn API response is not successful. Setup Add credentials for Google Sheets, OpenAI, Gmail, LinkedIn, and Slack. Set your RSS feed URL in the RSS reader and configure the schedule interval for how often you want to scan for new posts. Create a Google Sheets spreadsheet with two tabs matching the workflow: “processed_blogs” (url, title, processed_at) and “generated_posts” (role, tone, postId, status, blog_title, created_at, generated_post, published). Replace YOUR_N8N_URL_HERE in the approval link templates and configure the webhook path (approve-post) to be reachable from your email recipients. Update the Gmail recipient address used for approvals and ensure your LinkedIn app/connection has permission to create posts via the LinkedIn REST API.
by DIGITAL BIZ TECH
AI-Powered Timesheet → Invoice Automation (Gmail + OCR + AI + Google Sheets + QuickBooks) > Note: This workflow uses sticky notes extensively to document each logical section of the automation. Sticky notes are mandatory and already included to explain OCR, AI parsing, folder logic, duplicate handling, and QuickBooks steps. This workflow automates the full lifecycle of timesheet-based invoicing — from emailed timesheets to structured Google Sheets records and finalized invoices in QuickBooks Online. It is designed for real-world billing scenarios, including split weeks across months, zero-hour months, duplicate prevention, and first-week-of-year edge cases. What This Workflow Does Listens to Gmail for timesheet emails with attachments Splits and processes each attachment independently Extracts text using OCR (no hardcoded API keys) Uses AI to parse month-wise billable hours Correctly splits weeks spanning multiple months Looks up Customer and PO details from Google Sheets Organizes files in Client → Employee → Year folders in Google Drive Reuses existing invoice sheets or creates new ones Prevents duplicate invoice rows Automatically finds or creates customers in QuickBooks Creates invoices in QuickBooks using validated data High-Level Workflow Stages Gmail Intake and Attachment Loop OCR Text Extraction AI-Based Timesheet Parsing Month Normalization and Validation Customer & PO Lookup Drive Folder Discovery and Creation Invoice Sheet Reuse or Creation Duplicate and Edge-Case Handling Append Invoice Rows to Google Sheets Create / Update Customers in QuickBooks Create Invoices in QuickBooks Each of these stages is clearly documented with sticky notes inside the workflow canvas. Quick Setup Instructions Import the workflow JSON into your n8n instance Configure credentials for: Gmail Google Drive Google Sheets OpenAI or Google Gemini QuickBooks Online Verify the OCR HTTP node: Default URL: https://universal-file-to-text-extractor.vercel.app/extract No hardcoded API keys are used Configure Get Customer Info From PO Sheet: Spreadsheet ID Sheet name and column mappings Ensure the Client Invoices root folder exists in Google Drive Send a test timesheet email Execute the workflow once manually Activate the workflow Who This Workflow Is For Agencies and consultancies billing from emailed timesheets Finance and operations teams using Google Workspace + QuickBooks Staffing firms with monthly or bi-weekly contractor billing Teams that want a fully auditable, zero-manual invoice process Requirements n8n instance Gmail account receiving timesheet emails Google Drive and Google Sheets OpenAI or Google Gemini API OCR API endpoint (configurable) QuickBooks Online account Customer PO Google Sheet containing: Email Customer Name Company Name Customer Account Number PO Number Item Folder Name Invoice range Due Date Calculation How It Works (Detailed) 1. Email Intake and Attachment Loop Gmail Trigger polls for timesheet emails Attachments are split so each file is processed independently Sticky notes explain the intake and loop logic 2. OCR Extraction Each attachment is sent to the OCR API PDFs and images are converted to plain text OCR logic is documented via sticky notes 3. AI Timesheet Parsing (Month-Wise) AI extracts data only from BILLABLE HOURS sections Outputs strict JSON: Employee Name Client Name Month Year Week Start Date Week End Date Total Billable Hours Special handling included: Split weeks across months Zero-hour months still included No guessed or inferred dates 4. Month Normalization and Validation AI output is normalized into a month array Each month is processed independently Invalid or zero-hour entries are skipped 5. Customer and PO Lookup Sender email is matched in the PO sheet Retrieved values drive: Folder structure Invoice logic Due date calculation 6. Google Drive Folder Structure The workflow enforces a strict hierarchy: Client Invoices └── Client └── Employee └── Year Missing folders are created automatically. 7. Invoice Sheet Naming and Search Sheet names are generated using: Employee Name Month Year Existing sheets are reused when found Supports monthly and 15-day billing cycles 8. Duplicate Prevention and Edge Cases Duplicate invoice rows are detected and skipped January first-week edge case is handled explicitly Safe re-runs are supported 9. Google Sheets Invoice Rows Each appended row includes: Customer Account Number Invoice Date Due Date PO Number Item Name Quantity (Total Hours) Period description 10. QuickBooks Integration Searches for existing customers in QuickBooks Creates customers automatically if missing Creates invoices using: Customer reference Item Quantity Invoice date Due date All QuickBooks logic is documented with sticky notes. How To Customize Swap AI model (OpenAI ↔ Gemini) Extend prompts to extract: Project Cost center Approval status Add tax codes, currency, or unit pricing Modify folder naming rules Insert approval steps before invoice creation Common Use Cases Monthly contractor invoicing Agency billing across multiple clients Finance automation with audit-ready records Eliminating manual timesheet-to-invoice work Troubleshooting | Issue | Likely Cause | |------|-------------| | No invoices created | Gmail filter mismatch or email already read | | OCR output empty | Unsupported file or OCR endpoint issue | | Wrong month split | Review AI prompt and month logic | | Duplicate rows | Duplicate detection conditions | | Invoice missing in QuickBooks | Customer or item configuration issue | Notes on Community Guidelines Sticky notes are used throughout the workflow No hardcoded API keys are present Markdown is used (no HTML tags) This workflow is original and not copied Need Help or Customization? Digital Biz Tech can help tailor this workflow to your business. We offer free setup support, including credential configuration and deployment. Contact: rajeet.nair@digitalbiz.tech Website: https://www.digitalbiz.tech LinkedIn: https://www.linkedin.com/company/digital-biz-tech/ You can also DM us on LinkedIn for any help. You can also DM us on LinkedIn.
by Milos Vranes
Quick Overview This workflow hosts an n8n lead-capture form, uses Anthropic Claude to score and classify real estate inquiries, then routes ready leads to Gmail and Google Sheets while logging early-stage leads to a separate Google Sheets tab. How it works Receives a new submission from an n8n Form trigger with contact details, intent, area, budget, timeline, financing status, and notes. Normalizes the submitted fields (for example trimming strings, lowercasing email, and adding a timestamp) for consistent downstream processing. Sends the normalized lead details to the Anthropic Messages API (Claude) to return a strict JSON classification, summary, timeline band, financing readiness, recommended agent role, and score. Parses the Claude JSON response, clamps the score to a 1–10 range, and calculates whether the lead is “ready” (score 7). If the lead is ready, sends a formatted Gmail alert to the agent and appends the lead to the “Active Leads” tab in Google Sheets. If the lead is not ready, appends the lead to the “Nurture Leads” tab in Google Sheets. Returns a confirmation message to the form submitter after the lead is routed. Setup Create an Anthropic HTTP Header Auth credential (x-api-key) and attach it to the HTTP request to the Anthropic Messages API. Add a Gmail credential and replace the placeholder recipient address (you@example.com) with your agent inbox. Add a Google Sheets credential, create a spreadsheet with “Active Leads” and “Nurture Leads” tabs, and replace REPLACE_WITH_YOUR_SHEET_ID in both Google Sheets append steps. Review and adjust the n8n form fields and the Claude prompt rubric (scoring, readiness threshold, and schema) to match your lead intake process.
by Oneclick AI Squad
This workflow continuously monitors CVE databases, threat intelligence feeds, and public security advisories to surface emerging zero-day threats, correlates them against your registered infrastructure assets and software inventory, and uses Claude AI to score exploitability, assess business impact, and generate actionable remediation playbooks — all before attackers can operationalise the vulnerability. How it works Trigger — Hourly schedule or on-demand webhook for immediate threat scans Load Asset Inventory — Fetches registered infrastructure (IPs, hostnames, software, versions) from Airtable Scrape CVE Sources — Queries NVD API, CISA KEV, and GitHub Security Advisories in parallel Fetch Threat Feeds — Pulls OSINT feeds (AlienVault OTX, abuse.ch, Shodan) for active exploitation signals Normalise & Deduplicate — Merges all findings, deduplicates by CVE ID, enriches with CVSS scores Correlate with Assets — Matches CVEs to your specific software/version inventory AI Threat Assessment — Claude AI scores exploitability, blast radius, and urgency per matched threat Filter Critical Findings — Keeps only threats scoring above configurable risk threshold Route by Severity — Branches CRITICAL / HIGH / MEDIUM for different response paths Alert SOC via Slack — Immediate notification with threat summary and patch status Create Incident Tickets — Auto-opens Jira/ServiceNow issues for CRITICAL and HIGH threats Email Security Team — Detailed HTML threat brief with CVE details and remediation steps Update Threat Register — Appends findings to Google Sheets threat intelligence log Trigger Patch Workflow — Webhooks downstream patch management system for auto-remediation Return API Response — Structured JSON result for SIEM/SOAR integration Setup Steps Import workflow into n8n Configure credentials: Anthropic API — Claude AI for threat assessment NVD API Key — NIST National Vulnerability Database CISA KEV — Known Exploited Vulnerabilities catalogue (public) AlienVault OTX API — Open Threat Exchange pulses Shodan API — Internet exposure checks Airtable — Asset/software inventory Google Sheets OAuth — Threat intelligence log Slack OAuth — SOC alerts Jira API — Incident ticket creation SendGrid / SMTP — Security team email digests Register your asset inventory in Airtable (hostnames, IPs, software, versions) Set your risk score threshold (default: 65) in the filter node Set your Slack SOC channel IDs Configure downstream patch webhook URL Activate the workflow Sample Webhook Payload (On-Demand Scan) { "scanType": "targeted", "software": "Apache HTTP Server", "version": "2.4.51", "urgency": "high", "requestedBy": "soc-analyst@company.com" } Threat Sources Monitored NVD (NIST)** — Full CVE database with CVSS v3.1 scores CISA KEV** — Actively exploited vulnerabilities catalogue GitHub Security Advisories** — Open source dependency vulnerabilities AlienVault OTX** — Community threat intelligence pulses abuse.ch URLhaus** — Malware distribution and C2 URLs Shodan** — Internet-exposed asset enumeration EPSS** — Exploit Prediction Scoring System probabilities AI Assessment Dimensions CVSS Score** — Base, temporal, and environmental scoring EPSS Probability** — Likelihood of exploitation in the wild Asset Exposure** — Internal vs external facing, attack surface Patch Availability** — Vendor patch, workaround, or no fix status Active Exploitation** — CISA KEV / OTX confirmation Business Impact** — Confidentiality, integrity, availability impact Blast Radius** — Number of affected assets and systems Urgency Score** — Composite prioritisation score (0–100) Features Multi-source CVE aggregation with deduplication Asset correlation against software/version inventory EPSS-weighted AI exploitability scoring Automated CRITICAL/HIGH/MEDIUM severity routing Jira ticket creation with full CVE context Patch management webhook integration Full threat intelligence audit log SIEM/SOAR-ready JSON output Explore More Automation: Contact us to design AI-powered lead nurturing, content engagement, and multi-platform reply workflows tailored to your growth strategy.
by Oneclick AI Squad
Automatically converts your daily WhatsApp messages and photos from travels into beautifully structured travel stories, saved as documents in Google Drive. How it works Receive WhatsApp Updates - Webhook captures messages, photos, and locations from your travel day Validate & Aggregate Content - JavaScript organizes messages by day, extracts metadata, validates media Fetch Previous Entries - Retrieves existing journal from Google Drive for context and continuity Prepare AI Context - JavaScript builds comprehensive prompt with photos, messages, locations, and timeline Claude AI Story Generation - Transforms raw messages into narrative travel journal with insights Parse & Format Story - JavaScript structures the output into readable document format Wait for Finalization - Brief pause to ensure all processing completes Save to Google Drive - Creates or updates your travel journal document Send Confirmation - WhatsApp notification with preview of generated story Respond to Webhook - Returns success confirmation Setup Steps Import workflow into n8n Configure credentials: Anthropic API - Claude AI for story generation Google Drive - Document storage and retrieval WhatsApp Business API or Twilio WhatsApp - Message integration Create a Google Drive folder for your travel journals Set up WhatsApp webhook integration: Point WhatsApp webhook to: https://your-n8n-instance.com/webhook/travel-journal Configure to send: messages, media, locations Update the "Fetch Previous Journal" node with your Drive folder ID Activate the workflow Sample WhatsApp Input Messages throughout the day: 09:30 AM: "Just arrived in Kyoto! The train station architecture is stunning 🚄" 11:45 AM: "Fushimi Inari shrine - thousands of orange torii gates going up the mountain" 📸 Photo: Torii gates pathway 02:15 PM: "Tried okonomiyaki for lunch. Amazing! The chef made it right in front of us" 📸 Photo: Okonomiyaki cooking 05:30 PM: "Gion district at sunset. Spotted two geishas!" 📍 Location: Gion, Kyoto, Japan 08:45 PM: "Dinner at an izakaya. Made friends with locals who taught us drinking games 😄" Generated Journal Output Day 3: Kyoto - Ancient Temples and Modern Connections The day began with anticipation as the shinkansen pulled into Kyoto Station at 9:30 AM. The station itself was an architectural marvel—a blend of traditional Japanese aesthetics and contemporary design that set the tone for what would be an unforgettable day. By mid-morning, I found myself at Fushimi Inari Taisha, one of Kyoto's most iconic sites. The seemingly endless tunnel of vermillion torii gates created a mesmerizing pathway up Mount Inari. Each gate, donated by individuals and businesses, bore inscriptions in black kanji. The experience was both spiritual and surreal—the way light filtered through the gates, creating dancing shadows on the stone path... [Full narrative continues with integrated photos, locations, and emotional insights] Features Smart Aggregation** - Groups messages by day, even across time zones Photo Integration** - Embeds images inline with contextual descriptions Location Awareness** - Maps locations and adds geographical context Narrative Style** - Converts casual messages into polished travel prose Emotional Intelligence** - Captures mood and significance beyond literal text Timeline Coherence** - Maintains chronological flow and story arc Automatic Continuity** - Links to previous days for multi-day trip journals Format Flexibility** - Outputs as Google Docs with proper formatting Privacy & Data Messages are processed in real-time and not stored long-term Photos are referenced but can be embedded or linked based on preference Journal documents are private in your Google Drive No message content is retained after journal generation
by Avkash Kakdiya
How it works This workflow automatically generates and sends personalized sales proposals when a new row is added to Google Sheets. It uses AI to create proposal content, updates contact details in HubSpot, and generates a formatted document. The document is converted into a PDF and emailed to the client. This eliminates manual proposal writing and ensures fast, consistent delivery. Step-by-step Capture lead and generate AI content** Google Sheets Trigger – Detects new form submissions in your sheet. Loop Over Items – Processes each new entry individually. Message a model – Uses Gemini AI to generate the proposal content. Code in JavaScript – Cleans and splits AI output into structured fields. Create contact and generate document** Create or update a contact – Stores or updates client data in HubSpot. Copy file – Duplicates a proposal template from Google Drive. Update a document – Replaces placeholders with real client and AI data. Download file – Converts the final document into a PDF file. Send proposal to client** Send a message – Emails the generated PDF proposal to the client. Why use this? Automatically generates professional proposals without manual writing Ensures consistent formatting using templates and placeholders Saves time by combining CRM, AI, and document creation Improves response speed for leads and increases conversion chances Scales easily for handling multiple client requests simultaneously
by Databox
Stop spending hours manually pulling paid ads data. This workflow connects to Databox via MCP, auto-discovers every connected paid platform, fetches 6 key metrics, and delivers a consolidated weekly report to Slack and email - every Monday at 9 AM, completely hands-free. Who's it for Performance marketers** managing campaigns across multiple platforms Marketing managers** who need a weekly cross-platform overview Agencies** automating paid ads reporting for clients How it works Schedule Trigger fires every Monday at 9 AM AI Agent connects to Databox via MCP and discovers all connected paid platforms (Google Ads, Facebook Ads, LinkedIn Ads, TikTok Ads, and 6 more) Fetches Spend, Clicks, CPC, CTR, Impressions, and Conversions for this week and last week Calculates week-over-week changes and formats two outputs - a Slack summary and a color-coded HTML email Delivers both simultaneously Requirements Databox account** with at least one paid ads platform connected (free plan works) OpenAI API key (or Anthropic) Slack account Gmail account How to set up Click Databox MCP Tool - set Authentication to OAuth2 and authorize Add your OpenAI API key to the Chat Model node Connect Slack and update the channel ID in the Send to Slack node Connect Gmail and set the recipient address in the Send Email node Activate - your first report arrives next Monday