Workflow Templates

Overview Stop spending 20 minutes writing each Upwork proposal from scratch. This workflow reads your Vollna job alert emails, scores every job against your skills and budget preferences, and uses Claude to write a personalised 55-75 word cover letter for every match and saved as a Gmail draft ready to review and send in one click. How it works Polls Gmail every 30 minutes for new Vollna job alert emails Parses every individual job title, budget, and URL from the Vollna email HTML Scores each job 1-10 against your skills, rate, and budget filters set in the Settings node Jobs below your threshold are logged as skipped — no proposal wasted Claude Haiku writes a 55-75 word cover letter for each match using the Nick Saraev formula The proposal is saved as a Gmail draft with the job title as the subject, ready for one-click review Every job is either matched or skipped and then is logged to Google Sheets for pipeline tracking Setup steps Vollna — Make sure you have a Vollna account with at least one active filter sending alerts to your Gmail Gmail — Connect your Gmail account in Check for Vollna Alerts and Save Proposal as Draft Settings node — Open Configure Profile and Settings and fill in your name, skills, bio, hourly rate, minimum budget, and score threshold. This is the only node you need to personalise Claude AI — Add your Anthropic API key to the Claude Haiku sub-node from console.anthropic.com Slack — Connect Slack in Notify New Draft and set your channel. Right-click and Disable if unused Google Sheets — Create a sheet called Upwork Jobs with columns: Timestamp, Job Title, Budget, Score, Status, Draft Saved, Job URL Activate — processes every new Vollna alert automatically

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)

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.

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

Quick overview This workflow collects a meeting transcript via an n8n Form, uses OpenAI (ChatGPT) to extract structured meeting intelligence, logs the results to Google Sheets, creates one ClickUp task per action item, and emails an HTML meeting brief via Gmail. How it works Receives a submission from an n8n Form containing the meeting title, date, participants, duration, and full transcript. Validates the transcript length, calculates word and participant counts, and assigns a unique meeting ID. Sends the meeting context to OpenAI (ChatGPT) to extract a strict JSON object with the summary, key topics, decisions, action items, risks, follow-up date, and sentiment. Parses and normalizes the AI JSON output, then prepares formatted strings for reporting and downstream systems. Appends the meeting record to a Google Sheets “Meetings” worksheet. Splits the extracted action items into individual entries and creates a ClickUp task for each valid action item. Sends the formatted HTML meeting brief to the configured team email address using Gmail. Setup Add an OpenAI API credential in the OpenAI Chat Model node and select the model to use. Connect Google Sheets OAuth credentials, set the target spreadsheet ID, and ensure a “Meetings” sheet exists with columns matching the fields being appended. Provide a ClickUp API token and replace the ClickUp List ID in the HTTP request URL so tasks are created in the correct list. Connect Gmail OAuth credentials and set the recipient email address for the meeting brief. Activate the workflow and use the generated Form URL to submit meeting transcripts from your team.

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.

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.

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.

Quick overview This workflow triggers on a published GitHub Release, uses OpenAI to turn the release notes into a short spoken script and MP3, stores the audio on Google Drive, pulls subscribers from Google Sheets, and sends an HTML “listen” newsletter to them via Gmail. How it works Triggers when a GitHub Release is published for the configured repository. Parses and cleans the release changelog, extracting key items into features, fixes, improvements, and other notes. Uses an OpenAI chat model to rewrite the release details into a 60–90 second spoken script. Calls the OpenAI text-to-speech API to generate an MP3 audio file from the script. Uploads the MP3 to Google Drive and sets the file permissions to “anyone with the link can view.” Loads subscriber email addresses from Google Sheets, builds an HTML newsletter with the public audio link and release highlights, and sends it via Gmail using BCC. Setup Connect a GitHub credential with access to the target repo and replace YOUR_GITHUB_USERNAME and YOUR_REPO_NAME in the GitHub trigger. Add an OpenAI API credential for both the chat model step and the OpenAI TTS HTTP request. Connect Google Drive OAuth2 and replace YOUR_AUDIO_FOLDER_ID with the folder where the MP3 files should be saved. Connect Google Sheets OAuth2, replace YOUR_SUBSCRIBERS_SHEET_ID, and ensure your sheet includes subscriber rows with an Email (or email) column. Connect Gmail OAuth2 and replace YOUR_SENDER_EMAIL with the address that sends the newsletter.

Daily Cyber News Digest to Telegram Workflow Created By: Abdullah Dilshad 📧 iamabdullahdishad@gmail.com Stay informed with automated daily summaries. This workflow aggregates cyber news from multiple trusted sources, uses AI to intelligently select and summarize the top 5 most relevant articles, and delivers a clean, concise digest directly to your Telegram chat every morning at 10:00 AM. What This Workflow Does Collects Data: Fetches cybersecurity news from multiple global APIs. Filters Noise: Uses AI to discard irrelevant updates. Summarizes: Generates short, professional summaries (1–2 sentences). Delivers: Automatically sends a formatted digest to Telegram within message length limits. How It Works Schedule Trigger Runs automatically every day at 10:00 AM (customizable). News Collection Fetches articles using the keyword "cyber" from: GNews NewsAPI Data Processing Merges articles from both sources into a single, unified dataset. AI-Powered Selection OpenAI analyzes all fetched articles. Intelligently selects the Top 5 most relevant cybersecurity stories. Smart Summarization Each article is condensed into 1–2 clear sentences. Includes: Publication date, Source name, and Article link. Telegram Delivery Sends a clean, formatted digest to your specified Telegram chat. Ensures the total message length stays under Telegram’s 4096-character limit. Setup Instructions Get API Keys Sign up for free API keys from GNews.io and NewsAPI.org. Connect Accounts Add your Telegram and OpenAI credentials in n8n. Configure Telegram Enter your Telegram Chat ID in the "Send a Text Message" node. Customize the Schedule Change the trigger time if you prefer delivery at a different hour. Customization & Use Cases This workflow is fully reusable and scalable. You can replace the keyword "cyber" to track any topic relevant to your needs. Example Topics: 🤖 Artificial Intelligence (AI) 💰 Cryptocurrency & Blockchain 🚀 Startups & Venture Capital 📱 Consumer Technology 🏭 Industry-specific updates Note: This workflow is designed to be adapted for individual tracking, team updates, or competitor analysis.

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.

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