Workflow Templates

📊 Description Automate daily founder intelligence from Hacker News without manual monitoring. This workflow scans Hacker News discussions (Show HN, launches, AI, startups, SaaS), filters out noise and non-discussion pages, and extracts only high-signal threads. AI then converts these discussions into a concise, founder-ready daily digest highlighting key trends, why they matter, and practical actions. The digest is delivered via email, while structured insights are logged to Google Sheets for long-term tracking and analysis. ⚠️ Deployment Disclaimer This template is designed for self-hosted n8n installations only. It relies on external MCP tools and custom AI orchestration that are not supported on n8n Cloud. 🔄 What This Template Does 1️⃣ Runs automatically on a daily schedule ⏰ 2️⃣ Searches Hacker News discussions via Google using SerpAPI 🔍 3️⃣ Extracts titles, summaries, links, and metadata from results 📄 4️⃣ Filters out guidelines, index pages, and non-discussion links 🚫 5️⃣ Aggregates valid discussion threads into a single dataset 📦 6️⃣ Uses AI to identify key trends, problems, and founder-relevant signals 🧠 7️⃣ Generates a concise daily founder digest (trend, why it matters, actions) ✍️ 8️⃣ Sends the digest automatically via email 📧 9️⃣ Cleans and normalizes insights for storage 🧹 🔟 Appends structured founder intelligence to Google Sheets for tracking 📊 ✅ Key Benefits ✅ Eliminates manual Hacker News scanning ✅ Surfaces only high-signal, founder-relevant discussions ✅ Converts raw discussions into clear, actionable insights ✅ Delivers a daily, skimmable founder digest automatically ✅ Builds a historical intelligence log in Google Sheets ✅ Creates a repeatable founder research workflow ⚙️ Features Daily scheduled execution Hacker News discovery via Google Search (SerpAPI) Noise filtering with custom JavaScript logic AI-powered trend and insight extraction Founder-focused digest generation Email delivery via Gmail Insight archiving in Google Sheets 🔑 Requirements SerpAPI account Azure OpenAI credentials Gmail account connected to n8n Google Sheets account Self-hosted n8n instance 🎯 Target Audience Startup founders tracking early signals Product and growth leaders monitoring trends VCs and analysts scouting emerging tools Teams needing automated market and founder intelligence

Who is this for E-commerce store owners and sales managers who want AI-powered insights from their Shopify data without manually crunching numbers every week. What it does This workflow automatically analyzes your Shopify sales performance every Monday morning and delivers intelligent insights via Slack and email. It pulls the last 7 days of orders, calculates key metrics (revenue, order count, average order value), and sends the data to Gemini AI for trend analysis and actionable recommendations. The AI identifies patterns in your sales data and provides specific suggestions for improving performance. All metrics are logged to Google Sheets for historical tracking, and the team receives instant alerts when revenue drops more than 20% compared to the previous week. How to set up Connect your Shopify store with order read permissions Add your Gemini API key for AI analysis Set up Slack integration and choose your target channels (#sales and #alerts) Configure Gmail credentials for stakeholder email reports Create a Google Sheets document with a "Weekly Metrics" tab for data tracking Update the email recipients and spreadsheet ID in the respective nodes Requirements Shopify store with API access Google Gemini API key Slack workspace Gmail account Google Sheets access How to customize Adjust the revenue drop threshold in the IF node (default: 20%), modify the schedule frequency, customize Gemini prompts for different analysis types, or add additional Slack channels for department-specific reports.

This workflow serves as a complete "AI Receptionist" for mortgage brokers or high-ticket service providers. It automates the messy process of qualifying leads, getting internal approval, and collecting sensitive client documents securely. The workflow is fully annotated with Sticky Notes to help you understand every step of the logic. Key Features Smart Qualification:** automatically filters leads based on income thresholds (e.g., >$80k) before they reach your inbox. Human-in-the-Loop:** Uses Telegram buttons to ask the broker for "Approve/Decline" confirmation before generating client emails. Generative AI:* Uses *Google Gemini (2.5-flash-lite)** to write personalized, warm welcome emails based on the lead's specific loan type. Google Workspace Automation:** Automatically creates a unique Google Drive folder for the client and drafts the email in Gmail (with the upload link pre-inserted). Document Collection Portal:** Includes a validation loop that checks if the client uploaded all required files (ID, Payslip, Bank Statements) and notifies the broker of success or failure. Database Logging:** Keeps a "Source of Truth" log in Supabase for every lead action. Prerequisites To use this template, you will need credentials for: Google Cloud Console: Enable APIs for Drive, Gmail, and Gemini (PaLM). Telegram: A Bot Token and Chat ID for notifications. Supabase: A project URL and API Key (Database schema provided in the Sticky Notes). How to Configure Credentials: Set up your Google, Telegram, and Supabase credentials in n8n. Supabase Table: Create a table named leads_consolidated (schema details are in the workflow notes). Triggers: Ensure your n8n instance is publicly accessible so the Webhook and Form triggers function correctly. Telegram ID: Update the Chat ID fields in the Telegram nodes to your own ID. This template is designed to be modular—you can easily swap Supabase for Airtable or Gemini for OpenAI if preferred.

What this workflow does This workflow automates the discovery, evaluation, and notification of job opportunities based on a candidate’s professional profile. It fetches remote job listings, compares each role against a structured candidate profile stored in Google Sheets, and uses AI to evaluate real alignment in terms of skills, seniority, salary, industry, and role complexity. Only the most relevant opportunities are kept, stored in Google Sheets, and delivered via email as a Top 5 shortlist. Decodo – Web Scraper for n8n How to configure (quick setup) Define the candidate profile in Google Sheets (skills, salary expectations, preferences). Configure credentials (Google Sheets, Gmail, decodo, AI provider). Set the matching threshold (e.g. skill match ≥ 90%). Run the workflow manually or on a schedule. Output Structured job match results in Google Sheets Automated email with the Top 5 best-matched job opportunities

Scrape physician profiles from BrowserAct to Google Sheets This workflow automates the process of building a targeted database of healthcare providers by scraping physician details for a specific location and syncing them to your records. It leverages BrowserAct to extract data from healthcare directories and ensures your database stays clean by preventing duplicate entries. Target Audience Medical recruiters, pharmaceutical sales representatives, lead generation specialists, and healthcare data analysts. How it works Define Location: The workflow starts by setting the target Location and State in a Set node. Scrape Data: A BrowserAct node executes a task (using the "Physician Profile Enricher" template) to search a healthcare directory (e.g., Healow) for doctors matching the criteria. Parse JSON: A Code node takes the raw string output from the scraper and parses it into individual JSON objects. Update Database: The workflow uses a Google Sheets node to append new records or update existing ones based on the physician's name, preventing duplicates. Notify Team: A Slack node sends a message to a specific channel to confirm the batch job has finished successfully. How to set up Configure Credentials: Connect your BrowserAct, Google Sheets, and Slack accounts in n8n. Prepare BrowserAct: Ensure the Physician Profile Enricher template is saved in your BrowserAct account. Setup Google Sheet: Create a new Google Sheet with the required headers (listed below). Select Spreadsheet: Open the Google Sheets node and select your newly created file and sheet. Set Variables: Open the Define Location node and input your target Location (City) and State. Configure Notification: Open the Slack node and select the channel where you want to receive alerts. Google Sheet Headers To use this workflow, create a Google Sheet with the following headers: Name Specialty Address Requirements BrowserAct* account with the *Physician Profile Enricher** template. Google Sheets** account. Slack** account. How to customize the workflow Change the Data Source: Modify the BrowserAct template to scrape a different directory (e.g., Zocdoc or WebMD) and update the Google Sheet columns accordingly. Switch Notifications: Replace the Slack node with a Microsoft Teams, Discord, or Email node to suit your team's communication preferences. Enrich Data: Add an AI Agent node after the Code node to format addresses or research the specific clinics listed. 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 Automate Medical Lead Gen: Scrape Healow to Google Sheets & Slack

#Analyse YouTube Comments via AI Agent and Create Video Topics Description Identifying what your audience wants can be a manual and time-consuming process. This workflow automates your content research by analyzing comments from your latest YouTube videos using an AI Agent. Every week, it fetches feedback, stores it in Google Sheets for backup, and uses OpenAI to suggest the TOP 5 SEO-optimized video topics based on real viewer requests. The final content strategy is delivered directly to your Gmail inbox, allowing you to focus on creating rather than researching. What it Does Weekly Trigger:* The workflow starts automatically every Friday (customizable) via the *Schedule Trigger**. Fetches Video Data:** It pulls the latest 5 videos from your specified YouTube playlist. Retrieves Comments:* Uses the *YouTube API (HTTP Request)** to fetch up to 100 comment threads per video. Data Archiving:* All retrieved comments are saved into a *Google Sheet**, ensuring you have a permanent backup of audience feedback. AI Analysis:* A *JavaScript node* formats the comments and passes them to an *AI Agent. Powered by **OpenAI (GPT-4o-mini), the agent identifies recurring themes and requests. Structured Output:* The *Output Parser** ensures the AI provides exactly 5 video titles in a clean, professional format. Email Delivery:* The *Gmail node** sends a summary of the suggested content plan directly to your inbox. Use Cases YouTube Creators:** Automatically find out what tutorials or "How-to" videos your audience is asking for. Social Media Managers:** Generate weekly reports on audience sentiment and demand for clients. Educational Channels:** Identify specific pain points or questions students are mentioning in the comments. Customization YouTube Node:** Replace the Playlist ID with the ID of the playlist you want to monitor. Google Sheets:* Select your own Spreadsheet and Sheet Name in the *Append row in sheet** node. AI Agent Prompt:** You can modify the prompt to change the tone of the titles (e.g., "Make them clickbaity" or "Make them educational"). Gmail Node:** Update the "To" email address to your own email. Requirements An n8n instance (Cloud or Self-hosted). Google Cloud Credentials** (With YouTube Data API v3, Google Sheets API, and Gmail API enabled). OpenAI API Key** (For the AI Agent analysis). How to Set Up Connect Credentials: Link your YouTube, Google Sheets, Gmail, and OpenAI accounts to their respective nodes. Configure Playlist: In the "Get many playlist items" node, enter your YouTube Playlist ID. Select Sheet: In the "Append row in sheet" node, pick your target Google Sheet. Update Gmail: In the "Send a message" node, set your recipient email address. Activate: Save the workflow and toggle it to Active.

Intelligent Multi-Source Document Orchestrator: AI Triage & Multi-Tier Routing 🎯 Description This is an enterprise-grade Intelligent Document Processing (IDP) hub designed to handle high-volume document ingestion, classification, and departmental routing. It transforms monolithic bulk scans into actionable data streams by leveraging a "Split-Extract-Route" architecture. ✨ The Orchestration Lifecycle Intake Layer - Aggregates document triggers from Google Drive, Webhooks, and Scheduled Tasks. It implements a strict file integrity check to ensure only healthy binaries enter the pipeline. Document Atomization - Utilizes the HTML to PDF (Split) node to explode multi-page bulk scans into individual, manageable pages. This ensures that a single PDF containing an invoice, a contract, and a payroll slip is correctly decomposed for separate processing. AI Extraction & Intelligence - A sophisticated Code Node acts as the "Brain," using regex and keyword logic to classify documents (Invoices, Payroll, Legal, POs) and extract structured metadata (Amounts, Vendors, Due Dates) with confidence scoring. Smart Routing Matrix - Documents are contextually routed based on department and value: Invoices & POs: High-value items (>$5,000) trigger a priority escalation track. Legal & Payroll: Grouped and logged for standard departmental audit. High-Value Escalation - For critical financial items, the system creates an approval task in Notion and sends an urgent escalation email via Gmail to the CFO/Manager. Quality Assurance & Alerts - Low-confidence extractions (<85%) are automatically quarantined, triggering a Slack alert for immediate manual team review. Forensic Audit Logging - Every action, confidence score, and routing decision is appended to a Google Sheets master audit log for total transparency and compliance. 💡 Key Technical Features Conditional Gating:** Multi-tier IF nodes ensure that documents only proceed once they meet specific quality and value thresholds. Binary Integrity Guard:** Prevents workflow crashes by validating file data before intensive AI processing. Bi-Directional Governance:** Simultaneously updates Notion for task management and Google Sheets for historical reporting. 🚀 Benefits ✅ Zero Manual Sorting - Automates the transition from "Bulk Scan" to "Departmental Action." ✅ Risk Mitigation - High-value items and low-confidence data are surfaced immediately for human oversight. ✅ Regulatory Compliance - Every document lifecycle is tracked with a permanent, immutable audit trail. Tags: #IDP #AI #document-intelligence #notion #slack #automation #fintech Category: Finance & Operations | Difficulty: Advanced

Get notified when the International Space Station passes over your location - but only when you can actually see it! This workflow combines real-time ISS tracking with weather condition checks to send you alerts at the perfect moment for observation. Who is this for Space enthusiasts and astronomy hobbyists who want to spot the ISS Parents looking to share exciting science moments with their kids Remote workers who want a unique break reminder Educators creating engaging science experiences What this workflow does Tracks ISS position every 10 minutes using the Open Notify API Calculates distance and direction from your location using the Haversine formula Checks weather conditions via OpenWeatherMap to determine if ISS will be visible Provides observation guidance including compass direction, elevation angle, and viewing tips Includes crew information showing who is currently aboard the ISS Sends multi-channel alerts to Discord, Telegram, and Gmail simultaneously How to set up Configure your location in the Calculate Distance and Direction node Add OpenWeatherMap credentials (free tier available) Set up at least one notification channel (Discord, Telegram, or Gmail) Activate the workflow Requirements OpenWeatherMap API key (free) At least one notification channel configured

Medical Sovereign: Atomic Patient Portal Generator & HIPAA Triage Hub 🎯 Description This is an elite-tier HealthTech solution designed for the secure processing of high-volume medical records. Monolithic EMR exports (often 200+ pages) are atomized into individual pages, allowing for granular, clinical-grade redaction and AI-driven summarization before being re-assembled into a secure patient portal summary. ✨ The Sovereign Lifecycle Phase 1: Intake & Atomic Splitting - Ingests monolithic EMR PDFs and utilizes the Split PDF node to explode the chart into isolated "Atomic Pages." This prevents "PII leakage"—a common failure in batch processing where data from one section accidentally remains visible in another. Phase 2: Clinical Classification & Triage - A sophisticated Code Node analyzes the text DNA of each page to identify its type: Labs, Prescriptions, Imaging, or Clinical Notes. Phase 3: HIPAA-Compliant Redaction - Applies a heavy-duty regex engine across the atomized stream to scrub sensitive PII, including SSNs, technician names, and provider-to-provider notes that should not be in a patient-facing portal. Phase 4: AI Intelligence & Anomaly Detection - An AI Agent (GPT-4) translates complex medical terminology into patient-friendly language. Simultaneously, an Anomaly Detector flags critical lab values (e.g., critical glucose levels) for immediate provider intervention. Phase 5: Secure Re-Assembly & Archival - Sanitized pages are re-assembled using the Merge PDF node. The final document is vaulted in Google Drive, while a forensic audit trail (including SHA-256 hashes of every action) is logged to PostgreSQL. Phase 6: Multi-Channel Alerts - High-severity findings trigger urgent Email Alerts to providers, while patients receive a secure Twilio SMS notification once their record is ready for viewing. 💡 Key Technical Features Fail-Safe Validation:* A compliance validator ensures that every page has undergone PII scrubbing before the final merge. Any failure triggers a *Stop & Error** to prevent data breaches. Perceptual Integrity:** Every redaction and clinical finding is assigned a severity score to prioritize provider review. Forensic Auditing:** Every processed record creates an immutable paper trail for HIPAA/GDPR oversight. 🚀 Benefits ✅ 99.9% Redaction Precision - Page-level atomization ensures maximum data security. ✅ Enhanced Patient Engagement - Translates overwhelming clinical data into clear, actionable summaries. ✅ Regulatory Readiness - Built-in audit logs satisfy strict "Right to Access" and data privacy laws. Tags: #healthtech #hipaa #medical-records #pdf-split #automation #ai #compliance Category: Healthcare & Security | Difficulty: Advanced

Automated Employee Performance Review Summary (AI-Powered) Description Simplify employee performance reviews with AI-powered automation. This workflow transforms raw feedback and evaluation inputs into clear, structured, and professional performance review summaries — saving hours of manual writing while ensuring consistency and fairness. What This Workflow Does Turns scattered performance inputs into a single, AI-generated review summary: 📝 Capture Review Inputs – Collects employee details, role information, and performance feedback. 🧠 AI Review Analysis – AI analyzes strengths, areas of improvement, and overall performance trends. 📄 Generate Review Summary – Automatically creates a concise, professional performance review. 📊 Structured Output – Formats feedback into clear sections for easy understanding. 💾 Store or Share – Saves the summary or prepares it for HR systems, emails, or records. Key Features 🤖 AI-Powered Review Writing – Eliminates manual drafting of performance summaries. ⚙️ Consistent Evaluation – Ensures structured and unbiased review language. 📄 Professional Formatting – Ready-to-use summaries for HR documentation. ⏱️ Time-Saving Automation – Reduces review preparation from hours to minutes. 🔁 Reusable Template – Works for multiple employees and review cycles. Perfect For 🏢 HR Teams – Automate performance review summaries at scale. 📈 Managers & Team Leads – Quickly generate clear and actionable reviews. 🏭 Growing Organizations – Maintain consistency across evaluations. 💼 Enterprises – Standardize review documentation effortlessly. What You’ll Need Required Integrations OpenAI** – Generates clear and professional performance review summaries using AI Gmail** – Sends the performance review summary to managers or employees Google Sheets** – Stores performance inputs and AI-generated summaries for record-keeping Slack** – Notifies managers or HR teams when a review is generated HTMLCSS to Image** – Converts the performance review summary into a shareable visual format Optional Enhancements Google Drive** – Save generated review images for long-term storage PDF Conversion** – Convert review visuals into downloadable PDFs Approval Steps** – Add manager approval before sending results Quick Start 1️⃣ Import the workflow into your n8n workspace 2️⃣ Connect your OpenAI credentials 3️⃣ Configure employee and feedback inputs 4️⃣ Test with sample review data 5️⃣ Activate and start generating reviews automatically Expected Results ⚡ Faster Reviews – Generate summaries in minutes 🤖 High-Quality Feedback – Clear, balanced, and professional wording 📄 Standardized Output – Consistent structure across all reviews 🗂️ Easy Documentation – Ready for storage or sharing Workflow Structure 📝 Review Input ↓ 🧠 AI Performance Analysis ↓ 📄 Review Summary Generation ↓ 💾 Save / Share Output Upgrade your performance review process with AI. Import this template and let automation handle the writing — so managers can focus on people, not paperwork ✨

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automates the distribution and scheduling of video content across multiple social platforms (TikTok, YouTube, Facebook, Instagram, Threads) through Postiz. Videos are collected from Google Drive, approved manually, and scheduled via the Postiz community node. 🧾 Requirements Google Drive** account with access to the folder that will watch for new items uploaded. videos in mp4 format ready to be shared or, alternatively you can connect a community node from Cloud Convert to convert the format before uploading into Postiz. Postiz account with integrations for TikTok, YouTube, Facebook, Instagram, and Threads 🔗 Useful Links Postiz Docs Postiz Community Node 🔄 Workflow Steps Trigger: Google Drive File Added Watches your selected Google Drive folder for new file uploads. Download File Downloads the detected video from Drive. Upload to Postiz Video is uploaded to Postiz to prepare for social scheduling. Set Fields Manual setting of social options Extract Datetime (AI) Uses OpenAI to find/predict intended publish date & time, as the datetime format is required to schedule on Postiz Get Social Integrations Fetches a list of user’s connected platforms from Postiz. Split and Filter Integrations Splits the process per platform (TikTok, YouTube, Facebook, Instagram, Threads). Schedule Post For each enabled platform, schedules the video with chosen options. 🙋‍♂️ Need Help? Connect with 1 Node

Description Wake up gently. This elegant workflow runs every morning at 7 AM, picks one uplifting affirmation from a curated list, and delivers it to your inbox (with optional Telegram). Zero code, zero secrets—just drop in your SMTP and Telegram credentials, edit the affirmations, and activate. Perfect for creators, homemakers, and entrepreneurs who crave intention and beauty before the day begins. How it works (high-level steps) Cron wakes the flow daily at 7 AM. Set: Configuration stores your email, Telegram chat ID, and affirmations. Code node randomly selects one affirmation. Email node sends the message via SMTP. IF node decides whether to forward it to Telegram as well. Set-up time 2 – 3 minutes 30 s: add SMTP credential 30 s: add Telegram Bot credential (optional) 1 min: edit affirmations & email addresses 30 s: activate Detailed instructions All deep-dive steps live inside the yellow and white sticky notes on the canvas—no extra docs needed. Requirements SMTP account (SendGrid, Gmail, etc.) Telegram Bot account (optional) Customisation tips Change Cron time or frequency Swap affirmation list for quotes, verses, or mantras Add Notion logger branch for journaling