by Avkash Kakdiya
How it works This workflow automatically monitors competitor product prices stored in Google Sheets. It scrapes product pages, extracts pricing and offer data using AI, and compares it with historical values. Based on changes, it updates records and generates a market intelligence report. The workflow then emails the report and resets data for the next execution cycle. Step-by-step Step 1: Database sync** Schedule Trigger – Runs the workflow at a scheduled time. Get row(s) in sheet – Fetches competitor data and product URLs. Step 2: Scraping** Loop Over Items – Processes each competitor entry. HTTP Request3 – Retrieves raw HTML using ScraperAPI. Clean Content – Cleans and prepares text for AI processing. Step 3: Price extraction** AI Agent1 – Extracts product name, price, and offers. Groq Chat Model1 – Provides AI extraction capability. current Price and offer – Converts AI output into structured data. If2 – Checks if it's the first recorded entry. First time price and offer added – Stores initial values. If1 – Compares current vs previous price and offers. Updated current price and offer in sheet – Updates if changes detected. If No changes then update – Updates sheet even when no change is found. Step 4: Analysis** Get row(s) in sheet1 – Retrieves updated dataset. Data Aggregator – Builds structured market comparison data. AI Agent – Generates strategic insights and recommendations. Groq Chat Model – Powers the analysis output. Update row in sheet – Saves AI-generated summary in sheet. Step 5: Reporting** Edit Fields1 – Formats the report into HTML email layout. Send a message – Sends the final report via Gmail. Step 6: Reset** Get row(s) in sheet2 – Retrieves final processed data. Update row in sheet1 – Moves current data to history and clears fields. Why use this? Ensures all price scenarios (change or no change) are handled properly Keeps your Google Sheets always updated with accurate data Provides AI-powered competitive intelligence automatically Sends clean, formatted reports without manual effort Maintains structured historical tracking for better decision-making
by AppStoneLab Technologies LLP
Weekly Google Analytics 4 Report - Full WoW Tracking & Auto-Generated with Gemini AI Stop manually building weekly analytics reports. This workflow automatically fetches your GA4 data every Monday morning, generates an AI-written executive summary using Gemini, builds a premium formatted HTML email with deep Week-over-Week (WoW) comparisons for every metric, and delivers it straight to your stakeholders' inboxes — fully hands-free. 👤 Who is this for? Marketing teams* and *agency owners** who report GA4 metrics weekly to clients Product managers* and *founders** who want a Monday morning performance digest Freelancers** managing analytics for multiple clients who want to automate reporting Anyone who spends 30–60 minutes every week manually pulling GA4 numbers and calculating WoW changes 🚩 What problem does this solve? Manual GA4 reporting is repetitive, error-prone, and time-consuming. This template eliminates that entirely — every Monday at 8:00 AM in your configured timezone, a fully formatted report lands in your inbox. With the new dual-node architecture, it automatically calculates accurate WoW trends for your overall metrics, specific pages, traffic sources, and more, all contextualized by a Gemini-generated executive summary. ⚙️ What this workflow does ⏰ Triggers every Monday at 8:00 AM via the Schedule Trigger node 📡 Fetches 14 GA4 reports in parallel - pulling both Current Week and Previous Week data simultaneously for speed: Overview metrics Top 5 Screens / Pages by views Top 5 Traffic Sources / Referrals Top 5 Events by count Top 5 Countries by sessions Device breakdown (mobile / desktop / tablet) New vs Returning users 🔀 Merges all 14 responses and passes the complete historical dataset forward 🤖 Gemini writes a 3-5 bullet point summary analyzing the full WoW dataset to highlight performance trends, audience behaviour, and actionable recommendations 🧮 Code node processes all data - aligns current vs. previous week data, calculates WoW % changes for every single category, handles new/dropped entries, and builds the full inline-CSS HTML email 📧 Sends the report via standard SMTP / Email node to your configured recipients 📧 What the email report includes Header** - dark luxury card with 4 KPI tiles (Users, Sessions, Bounce Rate, Avg Duration) and WoW arrows AI Executive Summary** - 3-5 bullet point Gemini-generated insight (hidden automatically if Gemini fails) Overview Table** - all 5 core metrics with This Week / Last Week / WoW % change pill badges Audience** - New vs Returning users with visual progress bars and WoW changes Top Screens** - ranked by views, including previous week values and WoW trend pills. (not set) and (empty) rows are preserved for transparency Traffic Sources** - top referral channels with WoW changes; direct traffic auto-labelled as Direct / App Open Top Events** - tracks interaction trends with WoW changes; system events (first_open, os_update, etc.) are filtered out automatically Geography** - top 5 countries by sessions with WoW comparisons Devices** - mobile / desktop / tablet with visual progress bars and WoW trend pills 🛠️ Setup Instructions Step 1 - Google Analytics 4 Credential Go to n8n Credentials → Add new → search Google Analytics OAuth2 Sign in with the Google account that has access to your GA4 property Assign this credential to all 14 GA4 nodes Step 2 - Set your GA4 Property ID Open each of the 14 GA4 nodes In the Property ID field, replace {YOUR_PROPERTY_ID} with your GA4 numeric property ID Find your Property ID at: GA4 Admin → Property Settings → Property ID (looks like 123456789) Step 3 - Gemini API Credential Get your free API key at aistudio.google.com Go to n8n Credentials → Add new → search Google Gemini Paste your API key and assign it to the Generate AI Summary node Step 4 - Email / SMTP Credential Go to n8n Credentials → Add new → search SMTP (or swap the node for Gmail OAuth2 if preferred) Enter your email host, port, and login credentials Assign to the Send Weekly Report node Step 5 - Set Recipients Open the Send Weekly Report node (or the Code node depending on your mapping preference) Update the To Email field with your recipient address(es): 'email@example.com, email2@example.com' Alternatively, update the recipients: line at the bottom of the Build Report & Email HTML Code node. Step 6 - Set Timezone Open the Weekly Monday Trigger node Update the workflow settings to match your local timezone so the 8:00 AM trigger fires correctly. 🔧 How to Customise Change the schedule** → Open the trigger node, adjust the day and time to any cadence you need (daily, bi-weekly, monthly) Change the client brand in the footer** → Search for AppStoneLab Technologies in the Code node and replace it with your client or company name Filter or change events** → In the Code node, find the EXCLUDE_EVENTS array and add/remove event names to control which events appear in the report Change the AI summary language or tone** → Edit the prompt inside the Generate AI Summary Gemini node to match your client's preferred reporting style 📦 Requirements | Service | Purpose | Free Tier Available | | --- | --- | --- | | Google Analytics 4 | Source of all report data | ✅ Yes | | Google Gemini API | AI executive summary generation | ✅ Yes (via AI Studio) | | SMTP / Email | Email delivery | ✅ Yes | ⚠️ Notes Mobile app properties** - If your GA4 property tracks a mobile app, the workflow uses unifiedScreenName instead of pagePath, which works correctly for both web and app properties WoW calculations** - Bounce rate change is intentionally inverted (a decrease is shown as positive/green). If a metric like a specific page or country is new this week, the workflow dynamically tags it as "New" instead of breaking the calculation. Gemini failure handling** - If the Gemini node fails for any reason, the AI summary section is automatically hidden and the rest of the report sends normally Execute Once** - All 14 GA4 nodes have Execute Once enabled to prevent duplicate rows from the merge operation
by Influencers Club
How it works: Get multi social platform data for SaaS clients with their email and send personalized comms to onboard them as organic creators, partners and ambassadors. Step by step workflow to enrich customer emails with multi social (Instagram, Tiktok, Youtube, Twitter, Onlyfans, Twitch and more) profiles, analytics and metrics using the influencers.club API and sending tailored outreach to activate them as creators. Set up: Hubspot (can be swapped for any CRM like Salesforce, Attio or DB) Influencers.club Gmail Sendgrid (can be swapped for any programmatic email sender like Mailgun)
by Milo Bravo
Email Sentiment Router for Event Sales Leads Who is this for? Event organizers, conference managers, and sales teams drowning in sponsor/exhibitor/partner emails who need zero-drop leads + real-time pipeline analytics. Key nodes: Gmail Trigger - Google Gemini (2x) - Data Table - Google Sheets - Send Email - Slack Category: Sales / AI / Event Management Level: Advanced Credits: Milo Bravo (BRaiA Labs) What problem is this workflow solving? Email overload kills event revenue: 200+ weekly sponsor/partner emails go unread No sentiment/intent analysis = missed hot leads Manual routing wastes 10+ hours/week Zero visibility into pipeline trends This workflow auto-classifies, routes, and analyzes every inbound lead. What this workflow does? Gmail Trigger monitors event inbox for new emails Gemini #1 scores sentiment (Positive/Neutral/Negative) Gemini #2 extracts topic, intent, urgency, org, budget signals Logs to email_analytics Data Table + Google Sheets Routes intelligently: Positive → Hot Lead email + Slack #hot-leads (2h SLA) Neutral → Nurture email + Slack #follow-ups (24-48h) Negative → Insights + Slack #insights Looker Studio dashboard auto-updates from Sheets Setup (5 minutes): Gmail OAuth2 (event inbox) Google Gemini API key Slack OAuth2 + channels (#hot-leads, #follow-ups, #insights) Create email_analytics Data Table → paste Table ID Update recipient emails (placeholders in Send Email nodes) Test with Evaluation Dataset before live How to customize: Add keywords for your niche (conferences, webinars, trade shows) Adjust sentiment thresholds or routing rules Swap Slack → Teams/CRM (HubSpot/Salesforce) Scale: Multi-inbox + team routing ROI: 100% lead capture (zero drops) 5x faster response (2h → 2min) 20% conversion lift from sentiment prioritization Pipeline dashboard = data-driven sales strategy Need help customizing?: Contact me for consulting and support: LinkedIn / Message Keywords: event sales leads, email sentiment analysis, Gmail AI routing, Google Gemini sales automation, conference sponsor leads, event pipeline analytics, sales lead qualification, sales dashboard
by AI Solutions
Who is this for This template is built for small business owners, content marketers, and agencies who publish regularly to a WordPress blog and want to automatically surface that content as a polished weekly email digest — without manual curation or copywriting. If you have a WordPress site, an OpenAI API key, and a Gmail account, you can have this running in under 30 minutes. What it does The workflow runs every Monday morning and fully automates your newsletter pipeline: it fetches your latest blog posts, uses GPT-4o to write professional summaries, renders everything into a responsive branded HTML email, then delivers it to every subscriber on your list. How it works A Schedule Trigger fires once a week (Monday at 10 AM by default) to kick off the pipeline. Fetch WP Posts calls the WordPress REST API to retrieve posts published in the last 7 days, requesting up to 20 results with embedded featured media in a single request — no separate media lookups needed. Process Posts is a Code node that normalizes the raw WordPress API response into clean article objects. It extracts titles, excerpts, URLs, featured image URLs, categories, and publish dates; strips HTML tags and decodes entities; de-duplicates by URL; and returns the top 12 articles sorted newest-first. AI — Generate Summaries is a LangChain AI Agent backed by GPT-4o. It receives the structured article list and returns a JSON payload containing a 3–5 sentence professional summary for each article plus a short weekly overview paragraph. Image and article URLs are passed through unchanged — the prompt explicitly instructs the model not to modify them. Format HTML Email renders the AI output into a fully responsive, table-based HTML email. The layout includes a branded header with logo, a weekly overview callout block, individual article cards with featured images, a CTA button, and a footer with unsubscribe link. All brand variables (site name, logo URL, colors, CTA link) are defined as named constants at the top of the Code node for easy customization. Get Subscribers retrieves your mailing list from a Google Sheets worksheet. This node can be swapped for any other list source — Excel, Airtable, a CRM — with no changes needed downstream. Check Valid Email filters out any subscriber records that are missing an email address before delivery. Records without a valid email exit silently on the FALSE branch. Send Newsletter loops through each valid subscriber and delivers the HTML email via Gmail, with the newsletter date dynamically inserted in the subject line. How to set up In Fetch WP Posts, replace YOUR-WORDPRESS-SITE.com with your WordPress domain. In LLM — GPT-4o, select your OpenAI API credential. In Format HTML Email, update the constants at the top of the Code node: SITE_NAME, SITE_URL, LOGO_URL, CTA_URL, and CTA_TEXT. In Get Subscribers, update the Worksheet and table name. Swap the node entirely if your subscriber list lives elsewhere. In Send Newsletter, select your Gmail OAuth2 credential and update the senderName option. Optionally adjust the send day and time in Weekly Schedule. Requirements WordPress site with the default REST API enabled (no plugin required for posts) Google Sheet or alternative source for your subscriber list OpenAI API key Gmail account with OAuth2 configured in n8n Self-hosted n8n** — this workflow uses @n8n/n8n-nodes-langchain (AI Agent + OpenAI Chat Model), which requires a self-hosted instance How to customize the workflow Post window* — Change days: 7 in the after query parameter of *Fetch WP Posts to cover a longer or shorter period. Article count* — Update articles.slice(0, 12) in *Process Posts and the matching slice in the AI prompt to show more or fewer articles per issue. AI model* — Swap GPT-4o for GPT-4o-mini or GPT-4.1 in the *LLM — GPT-4o sub-node to adjust quality vs. cost. Brand styling* — All colors, fonts, logo, and layout are controlled inside the *Format HTML Email Code node. The HTML uses table-based layout for broad email client compatibility including Outlook. Subscriber source* — Replace *Get Subscribers with our Wordpress API (paid version), Airtable, HubSpot, or any other n8n-supported node. Map the email field and the rest of the workflow requires no changes. Send frequency** — Change the Schedule Trigger to bi-weekly, monthly, or any custom cron expression. Email service** — Replace the Gmail node with Outlook, SendGrid, Mailgun, or any SMTP-compatible service supported by n8n. Visit automatedintelligentsolutions.com for more information and workflows.
by Cheng Siong Chin
How It Works This workflow automates patient risk assessment and clinical alerting for healthcare providers using NVIDIA AI models. Designed for hospitals, clinics, and healthcare organizations, it addresses the critical challenge of timely identification and response to high-risk patients requiring immediate intervention. The system monitors patient data webhooks, enriches records with external EHR data, and analyzes aggregated information through Claude AI for comprehensive risk stratification. Healthcare operations data is fetched and combined with patient metrics to provide contextual risk assessment. NVIDIA's structured generation capabilities ensure standardized clinical outputs, while parallel execution routes enable simultaneous processing: critical cases trigger immediate alerts via email and escalation flags, whereas routine cases follow standard documentation paths. The workflow maintains an audit trail, merges execution results, and generates detailed reports for compliance and quality improvement initiatives. Setup Steps Configure Patient Event Webhook with your EHR system endpoint URL and authentication headers Add NVIDIA API credentials (API key) in Fetch Patient Data and Structured Generation nodes Connect Claude Model node with Anthropic API key and configure healthcare risk assessment prompt Set up Gmail node with sender credentials and configure recipient email addresses for clinical alerts Enable Google Sheets integration for audit logging and specify spreadsheet ID for execution reports Prerequisites NVIDIA API access, Anthropic Claude API key, Google Workspace account (Gmail, Sheets) Use Cases Emergency department triage automation, post-operative monitoring for deterioration detection Customization Modify risk scoring algorithms, add disease-specific assessment criteria Benefits Reduces clinical response time through automated risk detection
by Paul Karrmann
HR Weekly Radar AI powered workflow that scans HR news via RSS, checks which of your policies or contract templates might need updates, and sends a weekly internal newsletter as HTML. What this template is for If you maintain an HR policy and template library, this helps you spot relevant changes faster and turn them into a small, actionable review list. Good to know This workflow fetches article pages and sends extracted text to LLMs Respect the publisher’s terms and avoid redistributing full article text outside your organization Cost and runtime depend on how many articles you process and how long the extracted text is How it works Weekly trigger starts the workflow RSS feed read pulls new HR articles Filter keeps only the last 7 days Limit node caps processing to maxArticles HTTP request fetches each article page HTML extract + cleanup converts the article body to plain text Google Drive node lists your policy and template file names Merge combines each article with the document list Reading agent evaluates relevance and suggests: which documents to review or update what change to consider missing document ideas Build report aggregates results across all articles Summary agent writes a short, scannable HTML email Gmail sends the newsletter to your chosen recipient How to use Add your RSS feed URL in the Workflow Configuration node (newsUrl) Set your recipient email (userEmail) Set your Google Drive folder id that contains policies and templates (templatesFolderId) Connect credentials for: Google Drive LLM provider nodes Gmail Run once manually and verify the email formatting, then activate the workflow Requirements RSS feed URL with HR or compliance updates Google Drive folder containing policy and template files LLM credentials for: per article analysis newsletter drafting Gmail account to send the email Customising this workflow Increase or decrease maxArticles to control cost and speed Adjust the last 7 days filter if you want a different reporting window Change the HTML extraction selector if your news source has a different page layout Swap the final Gmail node for Slack, Teams, Notion, or Google Docs Add a redaction step before the Reading Agent if you want to remove signatures or long quoted sections
by WeblineIndia
LeadFlow AI: n8n Webhook + OpenAI + Airtable + Slack Lead Automation This workflow captures leads via webhook, validates and deduplicates them, uses OpenAI to score and summarize intent and sends high-quality leads (score > 70) to Airtable and Slack for immediate sales action. Quick Setup (Start in Minutes) Login to your n8n account and import this workflow Connect your form/API to the webhook endpoint Add Airtable credentials and select base/table Add OpenAI API credentials Connect Slack and choose a channel Activate workflow and test with sample data What It Does This workflow automates your entire lead handling process from capture to qualification and notification. When a new lead is submitted through a webhook, the system extracts and standardizes the data, ensuring all required fields are present and usable. Next, it checks if the lead already exists in Airtable using the email address. If the lead is new, it is sent to an AI model that evaluates the message content and assigns a score, category (Hot/Warm/Cold) and a short summary. Finally, only high-intent leads (score greater than 70) are stored in Airtable and instantly sent to Slack. This ensures your sales team focuses only on the most valuable opportunities without manual filtering. Who It's For Sales teams who want instant high-quality lead alerts Marketing teams handling inbound leads from forms or ads Agencies managing multiple client lead pipelines Startups looking to automate lead qualification Anyone using Airtable as a lightweight CRM Requirements To use this workflow, you need: n8n account (self-hosted or cloud) OpenAI API key Airtable account with: Base created Table with required fields Slack workspace with bot access A form or system that can send webhook POST requests How It Works & Setup Guide Workflow Logic Webhook Trigger Receives lead data (name, email, company, message) Data Normalization Maps incoming fields into structured format Validation Ensures email exists and message length > 10 characters Deduplication Searches Airtable using email Only new leads move forward AI Scoring OpenAI analyzes message Returns: Score (0–100) Category (Hot/Warm/Cold) Summary Safety Parsing Ensures valid JSON output Applies fallback if AI response fails Filtering Only leads with score > 70 proceed Storage + Notification Saves lead in Airtable Sends Slack notification instantly Setup Steps Webhook Setup Copy webhook URL from n8n Connect it to your form/API Airtable Setup Create base and table Add fields: Name, Email, Company, Message Lead Score, Lead Category, AI Summary Connect Airtable credentials in n8n OpenAI Setup Add API key in credentials Ensure model (gpt-4o-mini) is selected Slack Setup Connect Slack account Select channel for notifications Test & Activate Send test webhook Verify Airtable + Slack outputs Activate workflow How To Customize Nodes Validation Node** Adjust message length or add more conditions (e.g., required company) AI Prompt** Modify scoring rules or summary format Add industry-specific logic Score Filter** Change threshold (e.g., 60 instead of 70) Slack Message** Add email, message or direct contact link Airtable Fields** Add tags, source, campaign tracking Add-ons (Enhancements) Send email alerts for hot leads Add CRM integrations (HubSpot, Salesforce) Store rejected leads separately Add lead source tracking (UTM parameters) Auto-assign leads to sales reps Add follow-up automation workflows Use Case Examples Website contact form lead qualification Facebook/Google Ads lead filtering SaaS demo request prioritization Agency client lead routing system Freelancer inquiry management And many more use cases depending on your business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|------|------| | No data in Airtable | Field mapping issue | Check field names and mappings | | Slack not sending messages | Wrong channel or credentials | Reconnect Slack and verify channel | | AI output parsing fails | Invalid JSON from AI | Check prompt and parser fallback | | Duplicate leads processed | Airtable filter issue | Verify email matching formula | | Workflow not triggering | Webhook not connected | Recheck webhook URL and method | Need Help? If you need help setting up, customizing or extending this workflow, our n8n workflow development team at WeblineIndia can assist you. We can help you: Customize AI scoring logic Integrate with advanced CRMs Build complete lead automation systems Add analytics and reporting Feel free to reach out to build powerful automation workflows tailored to your business.
by Cheng Siong Chin
How It Works This workflow automates platform trust and safety operations by deploying a multi-agent AI system that detects abuse signals, investigates behaviour, scores risk, checks policy compliance, and enforces actions automatically. Designed for platform safety teams, content moderation managers, and compliance officers, it eliminates manual triage delays and ensures high-severity violations are actioned immediately. An abuse signal webhook triggers behaviour analysis via OpenAI, classifying signals by severity. A routing node directs cases to a Governance Agent, which orchestrates Investigation, Risk Scoring, and Policy Compliance Checker sub-agents. Enforcement data is prepared, then routed by action type-logging to abuse records, alerting the security team via Slack, sending escalation emails, or triggering auto-enforcement actions based on threshold checks—before all outcomes are logged. Setup Steps Configure Abuse Signal Webhook URL and authenticate incoming POST requests. Add OpenAI API credentials to all OpenAI Model nodes. Connect Google Sheets for abuse records and enforcement action logging. Configure Slack credentials and set security team alert channel. Add Gmail/SMTP credentials to Send Escalation Email node. Prerequisites Slack workspace with bot token Gmail or SMTP credentials Google Sheets for abuse and enforcement logging Use Cases Real-time abuse detection and auto-suspension on social platforms Customization Replace OpenAI with Anthropic Claude or NVIDIA NIM models Benefits Eliminates manual abuse triage with real-time AI signal processing
by WeblineIndia
Failed Trade Root Cause Explainer This workflow automatically monitors a Google Sheet for failed trades, analyzes each failure using AI and updates the sheet with a probable root cause, confidence level and actionable next steps. It also sends alerts via Slack and email and creates a follow-up task to ensure the issue is reviewed. Quick Implementation Steps Connect Google Sheets (Failed Trade Log) Add Google Gemini API credentials Configure Slack, Gmail and Google Tasks Ensure sheet columns match workflow fields Test with one sample failed trade Activate the workflow What It Does This workflow automates the analysis of failed trades logged in a Google Sheet. Whenever a new trade is added, it validates whether the required failure details are present. If valid, the workflow sends the trade details to Gemini AI, which returns a structured explanation including probable cause, confidence, next steps and a short ops summary. The workflow updates the same row with this analysis. Once updated, alerts are sent to Slack and email and a follow-up Google Task is created for operational tracking. If required fields are missing, the workflow skips AI and marks the record as invalid. Who It's For Trade operations teams Brokerage and fintech platforms Back-office and support teams Teams handling trade exceptions and failures Requirements n8n account (cloud or self-hosted) Google Sheets (Failed Trade Log) Google Gemini API credentials Slack account Gmail account Google Tasks account How It Works & Setup Guide Step 1: Google Sheet Setup Ensure your sheet contains fields like: Trade ID, Client Name, Instrument, Trade Type Quantity, Price, Trade Date Counterparty, Venue Error Code, Error Message, Failure Stage Status, Priority, Analysis Status, Alert Sent Step 2: Trigger Setup Configure Google Sheets Trigger to fire on new row added Step 3: Validation Logic Workflow checks if Trade ID, Error Code and Error Message exist If missing → marked as Invalid Input Step 4: AI Analysis Gemini analyzes trade failure Returns structured JSON: probable_cause confidence next_steps ops_summary Step 5: Sheet Update Original row is updated with AI results Analysis Status set to Completed Step 6: Alerts & Actions Slack alert sent to ops channel Email alert sent with full summary Google Task created for follow-up Step 7: Final Update Alert Sent updated to Yes after email is sent How To Customize Nodes Modify AI prompt for different analysis depth Change Slack/email message formatting Add more validation rules in IF node Extend Google Sheet columns for more data Adjust task content for follow-up workflows Add-ons Add severity-based alert routing Integrate with Jira or ticketing systems Add duplicate detection logic Build dashboards for failed trade trends Add retry logic for failed API calls Use Case Examples Real-time failed trade analysis Faster ops team triage Standardizing root cause reporting Automated alerts and follow-ups Maintaining audit-ready trade logs There can be many more use cases depending on how the workflow is extended. Troubleshooting Guide | Issue | Possible Cause | Solution | | ----------------------- | -------------------------------- | ------------------------------------------------------ | | Workflow not triggering | Incorrect sheet or trigger setup | Verify sheet connection and activate workflow | | Record marked invalid | Missing required fields | Ensure Trade ID, Error Code, Error Message are present | | AI output missing | Invalid AI response | Ensure prompt enforces JSON format | | Sheet not updating | Matching issue | Verify Trade ID mapping | | Slack/email not sent | Credentials issue | Reconnect integrations | | Task not created | Google Tasks not configured | Verify credentials | Need Help? If you need help setting up or customizing this workflow, our n8n developers at WeblineIndia can assist with implementation, integrations and scaling automation solutions. Reach out to build tailored workflows for your business needs.
by Ayaka Sato
Who's it for Small teams, solo operators, and security-conscious individuals who receive email attachments from external senders. Useful for freelancers, agencies, HR teams, and anyone handling CVs, invoices, or documents from unknown sources. How it works Every minute, the workflow polls Gmail for new unread emails with attachments. For each attachment, it calculates the SHA256 hash and queries VirusTotal for known-malware matches. In parallel, an AI model analyzes the email subject and body for phishing patterns. A rule-based scorer combines both signals into three threat levels: Danger (VirusTotal malicious count >= 3 OR AI detects phishing) triggers a Gmail quarantine label plus a Slack alert. Suspicious (partial hits) logs to a human review queue in Google Sheets. Safe saves the attachment to Google Drive. AI is used only for text classification — the final quarantine decision is always rule-based. Set up steps Get a free VirusTotal API key at virustotal.com Create a Google Sheet named suspicious_queue with columns: timestamp, email_from, email_subject, attachment, malicious_count, ai_verdict Create a Gmail label called QUARANTINE and a Google Drive folder for safe attachments Open Set Configuration and fill in the Sheet ID, Drive folder ID, Slack channel, and label name Connect Gmail, Sheets, Drive, Slack, OpenAI, and VirusTotal (Header Auth with x-apikey) credentials Activate the workflow How to customize Adjust thresholds in the Code node, swap Slack for Discord or Teams, or add SPF and DKIM header checks before scanning.
by Victor Manuel Lagunas Franco
Turn any topic into a ready-to-study Anki deck. This workflow generates vocabulary flashcards with AI images and native pronunciation, then sends the .apkg file straight to your inbox. What it does You fill out a simple form (topic, languages, difficulty) GPT-4 creates vocabulary with translations, readings, and example sentences DALL-E 3 generates a unique image for each word ElevenLabs adds native pronunciation audio (word + example) Everything gets packaged into a real .apkg file The deck lands in your email, ready to import into Anki A backup copy saves to Google Sheets Why I built this I was spending hours making flashcards by hand for language learning. Finding images, recording audio, formatting everything for Anki... it took forever. This workflow does all of that in about 3 minutes. Setup (~15 min) Install npm packages: jszip and sql.js Add OpenAI credentials (for GPT-4 + DALL-E) Add ElevenLabs credentials Connect Gmail and Google Sheets via OAuth Update OPENAI_API_KEY in the DALL-E code node Update the Spreadsheet ID in the Sheets node Features 20 languages supported 7 image styles (minimal icons, kawaii, realistic, watercolor, pixel art...) 6 difficulty levels (A1 to C2) Optional reverse cards (target→native AND native→target) Works on Anki desktop and mobile