Workflow Templates

This workflow is designed to automate the initial screening process for your User-Generated Content (UGC) campaigns. It instantly calculates a performance score for every candidate using AI, filters out low-scoring applicants, and immediately initiates outreach to the qualified talent. 🧩 What Problem Does It Solve? Hiring managers waste valuable time manually reviewing hundreds of applications against a complex, weighted rubric, which leads to delays in contacting the best candidates. This workflow solves these by: Instant, Unbiased Scoring:** It uses an AI Agent (Google Gemini) to instantly assign a score (0–10) based on specific criteria. Automatic Qualification:** It filters out unqualified candidates and automatically processes those who meet your minimum score requirement. Immediate Outreach:** It instantly sends acceptance emails to qualified candidates and notifies your internal HR team to follow up. Centralized Tracking:** It logs the candidate's data and their final AI score into a central Google Sheet for easy long-term tracking. 🛠️ How to Configure It 1.Jotform Setup: Connect your Jotform API credentials in n8n. Specify the ID of your candidate application form in the Jotform Trigger node. 2.AI Setup: Connect your Google Gemini API key. Review the scoring prompt in the AI Agent node and confirm that the point system matches your current campaign requirements. 3.Google Sheets Setup: Connect your Google Sheets API credentials. Replace the placeholder TEMPLATE_GOOGLE_SHEETS_DOCUMENT_ID with the actual ID of your candidate tracking spreadsheet. 4.Email Setup: Connect your Gmail API credentials. Replace the placeholder TEMPLATE_HR_EMAIL@yourcompany.com in the "Send Internal Notification (HR)" node with your team's correct contact email. ⚙️ How It Works 1.Application Received: The Jotform Trigger instantly fires when a candidate submits their form. 2.AI Scores Candidate: The AI Agent uses the criteria prompt to calculate a definitive numerical score for the applicant. 3.Qualification Check: The If node checks if the score is 6 or higher. 4.If True (qualified): The candidate proceeds to the next steps. 5.If False (unqualified): The workflow stops for this candidate (or can be configured to send a rejection). 6.Record & Notify: The workflow saves the data to the Google Sheet and then simultaneously sends two emails: an acceptance email to the candidate and an internal notification to HR. 🎯 Perfect For UGC Campaigns:** Instantly qualify content creators for product reviews, endorsements, and social media ads based on objective, pre-defined rules. Influencer Marketing:** Automatically filter and prioritize micro- and nano-influencers who match all your specific demographic and product criteria. Mass Screening:** Use the AI to quickly narrow down a large pool of applicants, saving your recruiting team hours of manual data review and scoring. If you need any help Get in Touch

Overview This n8n template automates finding real estate agents in any city using Google Maps. It deep-scrapes listings via ScrapeOps Proxy, deduplicates results against Google Sheets, saves fresh leads, and sends alerts via Gmail and Slack — all triggered from a simple web form. Who is this for? Real estate marketing agencies building targeted agent lead lists PropTech companies prospecting realtors in new cities or regions Sales teams running outreach campaigns targeting real estate agencies Anyone who needs structured local real estate agent data from Google Maps What problem does it solve? Manually searching Google Maps for real estate agents, copying contact details, and checking for duplicates is slow and inconsistent. This workflow automates the entire process — from search to deduplication to saved leads — so you get fresh, structured agent data with zero manual effort. How it works A web form captures the target city. ScrapeOps Proxy scrapes Google Maps for real estate agents in that city. Each listing is deep-scraped for full details: phone, website, rating, reviews, and address. Results are compared against existing Google Sheet entries to remove duplicates. Only new leads are saved to the sheet. Gmail and Slack alerts notify you of new leads instantly. Set up steps (~10–15 minutes) Register for a free ScrapeOps API key: https://scrapeops.io/app/register/n8n Add ScrapeOps credentials in n8n. Docs: https://scrapeops.io/docs/n8n/overview/ Duplicate the Google Sheet template and connect it to the Read Previous Entries and Save New Leads nodes. Configure Gmail credentials in the Send Gmail Alert node and set your recipient. Configure Slack credentials in the Send Slack Alert node and set your channel. Open the form URL, enter a city, and run. Pre-conditions Active ScrapeOps account (free tier available): https://scrapeops.io/app/register/n8n ScrapeOps community node installed in n8n: https://scrapeops.io/docs/n8n/overview/ Google Sheets credentials configured in n8n Duplicated Google Sheet template with correct column headers Gmail credentials for alert emails Slack credentials for channel notifications Disclaimer This template uses ScrapeOps as a community node. You are responsible for complying with Google's Terms of Use, robots.txt directives, and applicable laws in your jurisdiction. Scraping targets may change at any time; adjust render, scroll, and wait settings and parsers as needed. Use responsibly and only for legitimate business purposes.

Who’s it for Teams that capture leads with Typeform and want a plug-and-play flow to validate emails, enrich profiles in Vero, send a Gmail welcome, and log activity to Google Sheets with a Slack heads-up. Ideal for growth, sales, and marketing ops. What it does / How it works When a Typeform response arrives, the workflow: Validates the email format. Maps answers into a clean contact object. Upserts the contact in Vero (email as ID). Checks a qualification score; if qualified, sends a personalized Gmail welcome. Logs the outcome (timestamp, contact, score, status, action) to Google Sheets. Notifies Slack with a concise summary. Optional branches log and/or notify on invalid email or low score. How to set up In Configuration (Set), fill placeholders: typeformFormId, qualificationScore, slackChannel, sheetId, sheetName, gmailFrom, gmailSubject, sourceTag. Connect credentials for Typeform, Vero, Gmail, Google Sheets, Slack. Map your Typeform fields (email, name, company, score, consent) if labels differ. Requirements Active accounts: Typeform, Vero, Gmail, Google Sheets, Slack. Do not hardcode secrets in HTTP or Code nodes; use n8n credentials. Replace any sample IDs/emails/channels with your own. Customize the workflow Tune qualificationScore. Edit the Gmail template (subject/body variables). Add more attributes to the Vero upsert. Expand logging columns in Sheets. Split Slack notifications (e.g., triage channel for invalid/low-score leads).

What this template does Transforms provider documentation (URLs) into an auditable, enforceable multicloud security control baseline. It: Fetches and sanitizes HTML Uses AI to extract security requirements (strict 3-line TXT blocks) Composes enforceable controls** (strict 7-line TXT blocks with true-equivalence consolidation) Builds the final baseline* (TXT or JSON, see *Outputs) with a Technology: header Returns a downloadable artifact via webhook and can append/create the file in Google Drive Why it’s useful Eliminates manual copy-paste and produces a consistent, portable baseline ready for review, audit, or enforcement tooling—ideal for rapidly generating or refreshing baselines across cloud providers and services. Multicloud support The workflow is multicloud by design. Provide the target cloud in the request and run the same pipeline for: AWS, **Azure, GCP (out of the box) Extensible to other providers/services by adjusting prompts and routing logic How it works (high level) POST /create (Basic Auth) with { cloudProvider, technology, urls[] } Input validation → generate uuid → resolve Google Drive folder (search-or-create) Download & sanitize each URL AI pipeline: Extractor → Composer → Baseline Builder → (optional) Baseline Auditor Append/create file in Drive and return a downloadable artifact (TXT/JSON) via webhook Request (webhook) Method: POST URL: https://<your-n8n>/webhook/create Auth: Basic Auth Headers: Content-Type: application/json Example input (Postman/CLI) { "cloudProvider": "aws", "technology": "Amazon S3", "urls": [ "https://docs.aws.amazon.com/AmazonS3/latest/userguide/security-best-practices.html", "https://www.trendmicro.com/cloudoneconformity/knowledge-base/aws/S3/", "https://repost.aws/knowledge-center/secure-s3-resources" ] } Field reference cloudProvider (string, required) — case-insensitive. Supported: aws, azure, gcp. technology (string, required) — e.g., "Amazon S3", "Azure Storage", "Google Cloud Storage". urls (string\[], required) — 1–20 http(s) URLs (official/reputable docs). Optional (Google Drive destination): gdriveTargetId (string) — Google Drive folderId used for append/create. gdrivePath (string) — Path like "DefySec/Baselines" (folders are created if missing). gdriveTargetName (string) — Folder name to find/create under root. Optional (Assistant overrides): assistantExtractorId, assistantComposerId, assistantBaselineId, assistantAuditorId (strings) Resolution precedence Drive: gdriveTargetId → gdrivePath → gdriveTargetName → default folder. Assistants: explicit IDs above → dynamic resolution by name (expects 1_DefySec_Extractor, 2_DefySec_Control_Composer, 3_DefySec Baseline Builder, 4_DefySec_Baseline_Auditor). Validation Rejects empty urls or non-http(s) schemes; normalizes cloudProvider to aws|azure|gcp. Sanitizes fetched HTML (removes scripts/styles/headers) before AI steps. Outputs Primary:* downloadable *TXT** file controls_<technology>_<timestamp>.txt (via webhook). Composer outcomes:** if no groups to consolidate → NO_CONTROLS_TO_BE_CONSOLIDATED; if nothing valid remains → NO_CONTROLS_FOUND.  JSON path:* when the Builder stage is configured for *JSON-only** output (strict schema), the workflow returns a .json artifact and the Auditor validates it (see next section).  Techniques used (from the built-in assistants) Provider-aware extraction with strict TXT contract (3 lines):* Extractor limits itself to the declared provider/technology, outputs only Description/Reference/SecurityObjective, and applies a *reflexive quality check** before emitting.  Normalization & strict header parsing:** Composer normalizes whitespace/fences, requires the CloudProvider/Technology header, and ignores anything outside the exact 3-line block shape.  True-equivalence grouping & consolidation:* Composer groups *only** when intent, enforcement locus/mechanism, scope, and mode/setting all match—otherwise items remain distinct.  7-line enforceable control format:* Composer renders each (consolidated or unique) control in *exactly seven labeled lines** to keep results auditable and automatable.  Builder with JSON-only schema & technology inference:* Builder parses 7-line blocks, infers technology, consolidates true equivalents again if needed, and returns *pure JSON** matching a canonical schema (with counters in meta).  Self-evaluation loop (Auditor):* Auditor *unwraps transport, validates **schema & content, checks provider terminology/scope/automation, and returns either GOOD_ENOUGH or a JSON instruction set for the Builder to fix and re-emit—enabling reflective improvement.  Reference prioritization:** Across stages, official provider documentation is preferred in References (AWS/Azure/GCP).  Customization & extensions Prompt-reflective techniques:** keep (or extend) the Auditor loop to add more review passes and quality gates.  Compliance assistants:* add assistants to analyze/label controls for *HIPAA, PCI DSS, SOX** (and others), emitting mappings, gaps, and remediation notes. Implementation context:* feed internal implementation docs, runbooks, or *Architecture Decision Records (ADRs); use these as **grounding to generate or refine controls (works with local/self-hosted LLMs, too). Local/self-hosted LLMs:** swap OpenAI nodes for your on-prem LLM endpoint while keeping the pipeline. Provider-specific outputs:** extend the final stage to export Policy-as-Code or IaC snippets (Rego/Sentinel, CloudFormation Guard, Bicep/ARM, Terraform validations). Assistant configuration & prompts Full assistant configurations and prompts (Extractor, Composer, Baseline Builder, Baseline Auditor) are available here: https://github.com/followdrabbit/n8nlabs/tree/main/Lab03%20-%20Multicloud%20AI%20Security%20Control%20Baseline%20Builder/Assistants Security & privacy No hardcoded secrets in HTTP nodes; use n8n’s Credential Manager. Drive operations are optional and folder-scoped. For sensitive environments, switch to a local LLM and provide only sanitized/approved inputs. Quick test (curl) curl -X POST "https://<your-n8n>/webhook/create" \ -u "<user>:<pass>" \ -H "Content-Type: application/json" \ -d '{ "cloudProvider":"aws", "technology":"Amazon S3", "urls":[ "https://docs.aws.amazon.com/AmazonS3/latest/userguide/security-best-practices.html" ] }' \ -OJ

This workflow allows users to extract potential leads from their inboxes. The idea of a reverse outreach is based on the notion that the next big client/customer/partner might be sitting in your inbox waiting to be mined. This automation has two workflows, one that extracts from the historical emails, and the other is a scheduled event, default set to run everyday morning. The workflow intelligently filters out emails from personal domains, system addresses (no-reply, updates), and generic company inboxes (info@, support@). The remaining emails are parsed to extract key information—company name, email address, domain, and subject—which is then stored in a Google Sheets spreadsheet. The Google Sheets node is configured to append or update based on the email address, ensuring that you never store duplicate entries. Finally, you will get a slack message with key information about the lead. 🚀 How it works Manual Trigger: A manual click initiate will fetch all historical emails. the limit set to 500, which you can increase up to 5000 Periodic Trigger: The workflow is triggered by time, default is set to daily fetch. Code nodes: Three Code nodes filter the emails based on custom rules - personal domains, system addresses, generic inboxes. Google Sheets: The processed data is sent to a Google Sheets spreadsheet. The append or update operation automatically handles whether to create a new row or update an existing one based on the email address, preventing duplicates. 🔑 Required Credentials Google (Gmail): To access your Gmail account and retrieve email messages. Google Sheets: To connect to your spreadsheet. Slack Bot: To Send message in a designated slack channel 🛠️ Setup Instructions Configure Gmail Trigger: Connect your Google cloud account credential in Gmail and Google sheet nodes. Choose the schedule to run the Email fetch node that periodically watch for new emails. Configure Code Node: This node is pre-configured with the filtering logic. You can customize the lists of personal, blocked, or generic email parts to fit your needs. Configure Google Sheets Node: Connect your Google Sheets credentials. Create a Spreadsheet with the following columns company_name, email, domain, subject, date_received Enter the Spreadsheet ID of your target spreadsheet in the Google sheet node along with the Sheet Name (e.g., Leads). And that should do it! Now run the manual trigger workflow and see the lead information showing up in your selected Slack Channel and also in the populated google sheet.

Transform your Gmail inbox from chaos to clarity with this revolutionary email organization system that uses Google Sheets as your command center for automated email management. This powerful n8n workflow automatically processes, categorizes, and organizes your Gmail inbox using customizable rules stored in Google Sheets. Say goodbye to manual email sorting and hello to a perfectly organized inbox that adapts to your needs through simple spreadsheet management. Key Innovation: Unlike traditional email filters that require complex Gmail setup, this system uses Google Sheets for intuitive rule management, allowing anyone to update email organization rules through a simple spreadsheet interface - no technical knowledge required! What Makes This Different: Google Sheets Integration** - Manage email rules through an easy-to-use spreadsheet interface Smart Pattern Matching** - Automatically detects sender patterns and applies appropriate actions Flexible Rule System** - Support for DELETE, PROMO, and LABEL actions with custom label names Intelligent Email Parsing** - Extracts clean email addresses from various sender formats Automatic Inbox Management** - Removes processed emails from inbox and marks as read Real-time Notifications** - Slack integration for monitoring and completion alerts Key Benefits of Sheet-Based Organization: Easy Rule Management** - Update email rules without touching the workflow code Visual Rule Interface** - See all your email organization rules in one place Scalable Organization** - Add unlimited rules without workflow modifications Team Collaboration** - Share and manage rules with team members through Google Sheets Flexible Actions** - Choose between deleting, promoting, or labeling emails Custom Label Support** - Create and apply custom Gmail labels automatically Who's it for This template is designed for busy professionals, entrepreneurs, small business owners, and anyone overwhelmed by email management. It's perfect for individuals and teams who receive high volumes of emails and need an intelligent, automated system to organize their Gmail inbox without manual intervention. Ideal for users who want to maintain a clean, organized inbox while ensuring important emails are properly categorized and promotional emails are handled appropriately. How it works / What it does This workflow creates an intelligent email organization system that automatically processes and categorizes your Gmail inbox using customizable rules stored in Google Sheets. The system: Triggers automatically on a schedule (configurable interval) to check for new emails Retrieves all unread emails from your Gmail inbox Parses sender email addresses to extract clean email addresses from various formats Loads organization rules from a Google Sheets document with customizable patterns Applies intelligent pattern matching to categorize emails based on sender patterns Executes appropriate actions (DELETE, PROMO, or LABEL) based on matched rules Manages Gmail labels automatically, creating new labels if needed Removes processed emails from inbox and marks them as read Sends completion notifications via Slack for monitoring Key Innovation: Sheet-Based Rule Management - Unlike traditional email filters that require complex setup in Gmail, this system uses Google Sheets for easy rule management, allowing non-technical users to update email organization rules through a simple spreadsheet interface. How to set up 1. Configure Gmail API Credentials Set up Gmail OAuth2 API credentials in n8n Ensure the account has permissions to read, modify, and manage Gmail messages Grant access to Gmail labels and message operations 2. Set up Google Sheets Integration Create a Google Sheets document for email organization rules Set up Google Sheets OAuth2 API credentials in n8n Configure the sheet with the required columns: Pattern, Action, LabelName, RemoveFromInbox 3. Configure Email Organization Rules Add your email organization rules to the Google Sheets document Use the Pattern column to specify sender patterns (e.g., "@company.com", "newsletter@") Set Action to DELETE, PROMO, or LABEL based on desired behavior Specify LabelName for custom labels when Action is LABEL Set RemoveFromInbox to TRUE/FALSE to control inbox removal 4. Set up Slack Notifications (Optional) Configure Slack API credentials for the notification channel Update the channel ID where completion notifications will be sent Customize notification messages as needed 5. Configure Schedule Adjust the Schedule Trigger node for your preferred interval Consider running every few minutes for real-time organization Test with manual execution first to verify setup 6. Test the Integration Run a manual execution to verify all components work correctly Check your Gmail inbox and labels to see organized emails Verify Slack notifications are received (if configured) Requirements n8n instance** (self-hosted or cloud) with API access Gmail account** with API access and sufficient email volume Google Sheets account** for rule management Slack workspace** for notifications (optional but recommended) Gmail labels** that need to be created and managed automatically How to customize the workflow Modify Email Processing Frequency Adjust the Schedule Trigger node for different intervals (every few minutes, hourly, daily) Add multiple schedule triggers for different email types Implement conditional scheduling based on email volume Enhance Rule Management Add more complex pattern matching (regex support, multiple conditions) Implement rule priorities and conflict resolution Add rule validation and error handling Expand Notification System Add email notifications for organization events Integrate with monitoring systems (PagerDuty, OpsGenie) Add detailed reporting on email organization statistics Advanced Email Processing Add support for email content analysis and categorization Implement sentiment analysis for email prioritization Add support for attachment handling and organization Security and Privacy Enhancements Implement email content encryption for sensitive information Add audit logging for email organization actions Set up access controls for rule management Performance Optimizations Add batch processing for high-volume email accounts Implement intelligent caching for frequently accessed rules Add email processing metrics and performance monitoring Key Features Google Sheets Integration** - Manage email rules through an intuitive spreadsheet interface Smart Pattern Matching** - Automatically detects sender patterns and applies appropriate actions Flexible Action System** - Support for DELETE, PROMO, and LABEL actions with custom configurations Intelligent Email Parsing** - Extracts clean email addresses from various sender formats Automatic Gmail Management** - Creates labels, removes from inbox, and marks as read automatically Real-time Notifications** - Slack integration for monitoring and completion alerts Scalable Rule System** - Add unlimited rules without workflow modifications Error Handling** - Graceful failure handling with detailed error reporting Technical Architecture Highlights Google Sheets Integration Dynamic Rule Loading** - Rules are loaded from Google Sheets on each execution Real-time Rule Updates** - Changes to the sheet are immediately reflected in email processing Flexible Rule Format** - Support for Pattern, Action, LabelName, and RemoveFromInbox columns Error Handling** - Graceful handling of missing or invalid rule configurations Email Processing Optimization Intelligent Email Parsing** - Extracts clean email addresses from various sender formats Pattern Matching** - Efficient substring matching for sender identification Batch Processing** - Processes multiple emails in a single execution cycle Gmail API Integration** - Direct integration with Gmail for label management and inbox operations Workflow Efficiency Parallel Data Loading** - Gmail messages and labels are loaded simultaneously Smart Rule Application** - Efficient pattern matching and action execution Automatic Label Management** - Creates and manages Gmail labels automatically Streamlined Notifications** - Single completion notification per execution cycle Use Cases Busy professionals** with high email volumes needing automated organization Small business owners** managing multiple email streams and client communications Entrepreneurs** handling various business emails requiring different priority levels Teams** needing consistent email organization across multiple team members Customer service** departments requiring automated email categorization Sales teams** needing lead and prospect email organization Business Value Time Savings** - Eliminates manual email sorting and organization tasks Improved Productivity** - Focus on important emails without inbox clutter Consistent Organization** - Automated email categorization ensures nothing is missed Reduced Stress** - Clean, organized inbox reduces email overwhelm Team Efficiency** - Standardized email organization across team members Scalable Solution** - Handles increasing email volume without performance degradation Google Sheets Rule Configuration Required Columns: Pattern** - Substring to match in sender email (e.g., "@company.com", "newsletter@") Action** - Action to take: DELETE, PROMO, or LABEL LabelName** - Custom label name (only required when Action = LABEL) RemoveFromInbox** - TRUE/FALSE to control inbox removal (optional) Example Rules: Pattern: @newsletter.com Action: PROMO LabelName: RemoveFromInbox: TRUE Pattern: @client.com Action: LABEL LabelName: Clients RemoveFromInbox: FALSE Pattern: spam@ Action: DELETE LabelName: RemoveFromInbox: TRUE This template revolutionizes email management by providing an intuitive, spreadsheet-based approach to email organization that grows with your needs while maintaining the highest levels of automation and reliability.

APK Upload Monitoring and Automated MobSF Analysis with Slack Reporting This workflow monitors a Google Drive folder for newly uploaded APK files, automatically downloads them, triggers a MobSF static analysis scan, processes the output to detect unused or risky libraries and sends a developer-friendly summary directly to Slack. It is ideal for teams who want fast, automated insights into Android app dependencies. ⚡ Quick Start: Rapid Implementation Steps Connect Google Drive and select the APK upload folder. Add your MobSF server URL in both HTTP Request nodes. Add your OpenAI API credentials. Connect Slack and choose your preferred channel. Activate the workflow — you're ready to automate APK analysis. What It Does This workflow automates the complete static analysis process for Android APK files. When an APK is uploaded to a specific Google Drive folder, n8n immediately retrieves the file and sends it to MobSF for scanning. MobSF returns detailed JSON-based findings, including code, library usage and component insights. The workflow then uses a series of JavaScript code nodes to extract relevant package information, compare used vs. detected packages, identify unused dependencies and classify them by risk. These results are transformed into a concise summary using an AI model. Finally, the summary is posted automatically to a Slack channel for fast team visibility. This enables developers to take quick action on dependency cleanup, performance optimizations or security risks without manually reading the full MobSF report. Who’s It For Android developers wanting automated dependency insights QA/security teams needing MobSF scans on every APK upload DevOps engineers maintaining CI/CD pipelines Mobile teams who frequently share build artifacts Organizations wanting fast Slack-based reporting Requirements to Use This Workflow A Google Drive account with access to an APK upload folder A running MobSF instance (Docker supported) OpenAI API credentials Slack workspace with API access n8n installed (self-hosted or cloud) How It Works & How To Set Up 1. Google Drive Trigger Setup Connect your Google Drive credentials. Choose the folder dedicated to APK uploads. Event type: fileCreated (fires whenever a new APK is added). 2. Downloading the APK The workflow uses the Google Drive node to download the uploaded file. No manual configuration required beyond credential setup. 3. Configure MobSF Upload Replace the provided local URL with your MobSF instance URL. Ensure MobSF is reachable (via Docker or local network). Use multipart/form-data to upload the binary file. 4. Trigger MobSF Static Scan The next HTTP Request node triggers a static scan using the returned hash. No further configuration needed. 5. Code Nodes (Package Processing) These three nodes: extract used/detected packages, identify unused libraries, classify them as safe, maybe-required or risky. You can customize logic if needed. 6. AI-Based Summary Generation Connect OpenAI credentials. The node generates a clean, non-markdown summary for Slack. 7. Slack Notification Connect your Slack account. Select any desired channel. Summary is pushed instantly on every APK upload. 8. Activate the Workflow Once all credentials are added, enable the workflow and test by uploading an APK. How To Customize Nodes Google Drive Trigger Modify polling interval (e.g., every 5 minutes). Change folder for different build pipelines. MobSF Request Nodes Replace URL to support remote servers or Kubernetes deployments. Add additional headers if needed. Code Nodes Adjust package detection rules. Add tagging, filtering or extra metadata extraction. OpenAI Summary Node Customize the prompt for different reporting styles (e.g., shorter, more technical). Slack Node Add formatting, mentions or route to multiple channels. Add-Ons (Optional Extensions) Email Notifications** – Send the same report to email via Gmail or SMTP. Jira Ticket Auto-Creation** – Open issues when risky dependencies are detected. Save Reports to Database** – Store unused package data for long-term trends. CI/CD Integration** – Trigger analysis via GitHub Actions or Jenkins. VirusTotal Scan** – Add an extra malware check layer. Use Case Examples Automated Dependency Cleanup Quickly identify unused libraries after each build upload. Security Monitoring for Android Releases Ensure risky system packages aren’t unintentionally included. Team Collaboration Enhancement Send automated insights to Slack for faster decision-making. QA Validation Before Deployment Confirm that declared dependencies match actual usage. Build Optimization Remove unnecessary packages to reduce APK size and performance overhead. > There are many more possible uses depending on team needs and environment. Troubleshooting Guide | Issue | Possible Cause | Solution | | ------------------------------ | --------------------------------------- | ------------------------------------------------------ | | Workflow not triggering | Wrong Google Drive folder | Re-select the correct APK folder in the trigger node | | MobSF upload failing | Wrong URL or server not running | Check MobSF Docker container and update the URL | | MobSF scan shows empty results | APK not parsed successfully | Verify the APK is valid and not corrupted | | Slack message not delivered | Channel permissions or wrong channel ID | Reconnect Slack credentials and select a valid channel | | AI summary node fails | Missing OpenAI credentials | Add OpenAI API key in the credentials section | Need Help? If you need assistance setting up, extending or customizing this workflow, our n8n automation experts at WeblineIndia are available to help. Whether you want to add new features, integrate more systems or build similar automation workflows, feel free to reach out to us for professional support.

Description Automate daily KPI tracking and reporting by integrating ClickUp tasks and Google Sheets lead data into a unified dashboard. This workflow computes performance metrics, analyzes sentiment, and delivers visualized reports to Slack and Gmail for instant team insights. 📊💬📧 What This Template Does Triggers automatically every day using a cron scheduler. ⏰ Fetches project task data from ClickUp, including status, priority, and assignee metrics. Retrieves lead generation data and responses from Google Sheets. Merges both data sources to create a unified performance dataset. Computes detailed KPI metrics (task completion, overdue %, sentiment analysis, response trends). Formats data for reporting and visualization. Posts a concise KPI summary snapshot to a designated Slack channel. Sends a professionally formatted HTML report via Gmail. Notifies your Slack channel instantly in case of any workflow errors. Key Benefits ✅ Eliminates manual KPI tracking and reporting. ✅ Combines ClickUp and Google Sheets data into one view. ✅ Provides real-time insights for decision-making. ✅ Automates daily updates for consistent visibility. ✅ Delivers both quick Slack summaries and detailed email reports. ✅ Built-in error alerting ensures uninterrupted automation. Features Scheduled daily cron trigger for automated execution. OAuth2-secured integrations with ClickUp, Google Sheets, Slack, and Gmail. Parallel data fetching for faster performance. Smart KPI calculations with sentiment and trend analysis. Custom HTML email template with visual charts and highlights. Slack snapshot notifications for instant updates. Error-handling mechanism with Slack alerts. Requirements ClickUp account with OAuth2 credentials. Google Sheets access with OAuth2 credentials. Slack API credentials with chat:write permission. Gmail OAuth2 credentials for report delivery. Target Audience Project managers tracking performance KPIs. Operations teams needing daily performance visibility. Marketing and sales teams monitoring task and lead metrics. Automation and analytics engineers building executive dashboards. Step-by-Step Setup Instructions Connect your ClickUp, Google Sheets, Slack, and Gmail accounts. 🔑 Replace placeholder IDs (Sheet ID, Channel ID, Email) with your actual values. Adjust the cron trigger time as per your timezone. Test with sample data to confirm correct KPI calculations. Enable workflow to start daily automated execution. 🚀

Transform invoice creation from 30 minutes to 30 seconds - automatically generate professional PDF invoices with tax calculations, payment tracking, and instant delivery via email while archiving to Google Drive and notifying your team based on payment status. What This Workflow Does Revolutionizes invoice management with automated generation, intelligent payment tracking, and multi-channel delivery: Webhook-Triggered Generation** - Instantly creates invoices from payment gateways, CRM updates, or manual triggers Smart Data Validation** - Verifies required fields, validates email formats, and prevents incomplete invoices Automatic Invoice Numbering** - Generates unique sequential invoice numbers with year-month-random format (INV-202411-5847) Dynamic Tax Calculations** - Automatically computes taxes at configurable rates (GST, VAT, Sales Tax) with support for multiple tax jurisdictions Multi-Currency Support** - Handles USD, EUR, INR, GBP with proper currency symbols and formatting Due Date Management** - Auto-calculates payment due dates based on configurable terms (net-30, net-60, or custom) Payment Status Tracking** - Routes workflows differently for paid, unpaid, or partially paid invoices Professional HTML Design** - Creates beautifully branded invoices with modern typography and responsive layouts PDF Conversion** - Transforms HTML into print-ready, professional-quality PDF documents Automated Email Delivery** - Sends branded emails to customers with PDF attachments and payment instructions Google Drive Archival** - Automatically saves invoices to organized folders with searchable filenames Smart Team Notifications** - Different Slack alerts for paid vs unpaid invoices with embedded payment details Bank Details Integration** - Includes account numbers, routing numbers, SWIFT codes for easy payment Payment Link Support** - Embeds online payment links (Stripe, PayPal, Razorpay) for one-click payment Discount Handling** - Applies promotional or volume discounts with automatic recalculation Custom Notes & Terms** - Includes personalized thank-you messages and payment terms on every invoice Key Features Comprehensive Data Validation**: Prevents invoice errors by checking customer information, line item details, payment status validity, and email format before generation Intelligent Line Item Calculations**: Automatically multiplies quantity by rate for each item, sums subtotals, applies discounts, calculates taxes, and computes final totals Payment Status Color Coding**: Visual indicators show PAID (green), UNPAID (red), or PARTIALLY PAID (orange) status badges on invoices for instant recognition Flexible Tax Configuration**: Default 18% tax rate with easy customization for GST, VAT, or sales tax across different regions and tax jurisdictions Automatic Date Management**: Sets invoice date to today and calculates due dates based on configurable payment terms (default 30 days) Customer Information Cards**: Organized presentation of billing information including company name, address, contact details in professional card layout Itemized Pricing Tables**: Clean, professional tables showing description, quantity, rate, and amount for each line item with alternating row colors Payment Information Section**: Highlighted section with bank details, tax IDs, GST numbers, and online payment links for easy customer reference Conditional Workflow Routing**: Different automation paths for paid invoices (celebration notifications) vs unpaid invoices (payment reminders and follow-ups) Professional Email Templates**: Pre-written customer emails with invoice summary, payment instructions, and company contact information Searchable File Names**: Generates descriptive PDF names like "Invoice_INV-202411-5847_John_Doe.pdf" for easy retrieval and organization Print-Optimized PDFs**: A4 format with proper margins and preserved colors for professional printing and digital viewing Perfect For Freelancers & Consultants** - Bill clients immediately after project milestones, consultations, or deliverables completion SaaS Companies** - Generate monthly or annual subscription invoices automatically when billing cycles complete E-commerce Stores** - Create invoices for B2B orders, wholesale purchases, or custom enterprise deals Service Providers** - Bill hourly work weekly or bi-weekly with itemized time tracking and rate calculations Marketing Agencies** - Invoice retainer clients on the 1st of each month with recurring service breakdowns Accounting Firms** - Issue invoices for tax preparation, bookkeeping, and financial consulting services Web Development Agencies** - Bill clients for development sprints, hosting fees, and maintenance contracts Coaching & Training Businesses** - Invoice for coaching sessions, workshop fees, and training programs Healthcare Practices** - Generate patient invoices for services rendered with insurance and payment tracking Legal Firms** - Bill clients for legal consultations, document preparation, and case management Creative Studios** - Invoice for design work, photography sessions, video production, and creative services Construction Contractors** - Bill for completed project phases with material and labor itemization IT Support Companies** - Generate invoices for managed services, support tickets, and equipment sales Event Management** - Invoice clients for event planning, coordination, and vendor management fees What You Will Need Required Integrations HTML to PDF API - PDF conversion service (API key required) - supports HTML/CSS to PDF API, PDFShift, or similar providers (approximately 1-5 cents per invoice) Gmail or SMTP - Email delivery service for sending invoices to customers (OAuth2 or SMTP credentials) Google Drive - Cloud storage for invoice archival and sharing (OAuth2 credentials required) Optional Integrations Slack Webhook** - Team notifications for paid and unpaid invoices (free incoming webhook) Payment Gateway Integration** - Stripe, PayPal, Razorpay webhooks for automatic invoice generation on payment received Accounting Software** - QuickBooks, Xero, FreshBooks integration for automatic invoice sync and bookkeeping CRM Integration** - HubSpot, Pipedrive, Zoho CRM for customer data enrichment and invoice tracking Calendar Integration** - Schedule payment reminders and follow-ups for overdue invoices SMS Notifications** - Twilio integration for payment due date reminders via text message Quick Start Import Template - Copy JSON workflow and import into your n8n instance Configure PDF Service - Add HTML to PDF API credentials in the "HTML to PDF" node Setup Gmail - Connect Gmail OAuth2 credentials in "Send a message" node and update sender email address Connect Google Drive - Add Google Drive OAuth2 credentials and set your preferred folder ID for invoice storage Customize Company Info - Edit "Enrich with Company Data" node to add your company name, address, email, phone, website, logo URL, bank details, and tax registration numbers Update Email Template - Modify email message in Gmail node with your company branding and messaging Configure Slack - (Optional) Add your Slack incoming webhook URLs in both "Notify Team" nodes Test Webhook - Use the production or test webhook URL to submit sample invoice data Verify Output - Check that PDF generates correctly, email sends successfully, and file saves to Google Drive Integrate Payment Gateway - Connect Stripe, PayPal, or other payment webhooks to trigger invoice generation automatically Customization Options Multiple Tax Rates** - Configure different tax rates for different products, services, or customer locations Early Payment Discounts** - Add automatic discount calculation for payments received before due date Late Payment Fees** - Calculate and add penalty fees for overdue invoices Recurring Invoice Automation** - Schedule monthly or annual invoice generation for subscription customers Multi-Language Support** - Translate invoice templates for international clients (Spanish, French, German, Hindi, Chinese) Custom Branding Themes** - Create different invoice designs for different business units or service lines Partial Payment Tracking** - Track multiple partial payments against single invoice with running balance Credit Note Generation** - Create credit notes for refunds or overpayments Purchase Order Matching** - Link invoices to customer PO numbers for enterprise clients Client Portal Integration** - Generate unique links for clients to view and pay invoices online Automated Payment Reminders** - Send reminder emails 7 days before due date, on due date, and for overdue invoices Batch Invoice Generation** - Create multiple invoices simultaneously for monthly billing cycles Invoice Templates by Service Type** - Different layouts for product sales, consulting services, retainer agreements Payment Plan Support** - Split large invoices into installment payments with separate due dates Multi-Signature Authorization** - Add approval workflow for invoices above certain threshold Expected Results 95% time savings** - Reduce invoice creation from 30 minutes to 30 seconds per invoice 100% accuracy** - Eliminate calculation errors and missing information through validation Zero filing time** - Automatic Google Drive organization with searchable filenames 50% faster payment collection** - Professional invoices with payment links increase on-time payments Instant team alignment** - Real-time Slack notifications keep accounting and sales synchronized Better cash flow** - Faster invoice delivery means faster payment receipt Reduced administrative costs** - Save 20+ hours monthly on invoice preparation and filing Professional brand image** - Consistent, beautifully designed invoices elevate business credibility Improved customer experience** - Customers receive clear, detailed invoices with easy payment options Scalable process** - Handle 10x invoice volume without hiring additional staff Use Cases Freelance Designer Example Designer completes client project on Friday afternoon. Manually creating invoice in Word takes 25 minutes including calculation checks, formatting fixes, and finding bank details. Client expects invoice same day to process Monday payment. Solution: Designer clicks "Invoice Now" button in project management tool which triggers webhook. Workflow validates project details, generates branded invoice with itemized design services, converts to PDF, emails to client, and saves to Drive. Designer receives Slack notification confirming invoice sent. Result: Invoice delivered in 45 seconds instead of 25 minutes. Client receives professional invoice within 2 minutes of project completion. Designer saves 24 minutes and impresses client with speed. Payment received Monday morning. Over 50 projects annually, saves 20+ hours and increases cash flow by receiving payments 2-3 days faster. Annual impact: $3,500 in saved time plus faster payment collection. SaaS Startup Example SaaS company with 250 subscription customers needs monthly invoices. Finance manager manually creates invoices in spreadsheet, exports to PDF, and emails individually. Process takes 2 full days monthly causing invoice delivery delays. Solution: Connects workflow to Stripe subscription billing. When subscription renews, Stripe webhook triggers invoice generation. Customer name, email, subscription tier, and amount flow automatically. Invoice generates with payment link back to Stripe customer portal. Result: All 250 invoices delivered automatically on billing date. Zero manual work required. Customers receive invoices instantly with one-click payment links. Subscription payment collection improves from 85% to 96% in first week. Finance manager reallocates 2 days monthly to strategic analysis. Annual impact: saves 192 hours ($9,600 value) plus $18,000 additional revenue from improved collection rates. Marketing Agency Example Agency invoices 35 retainer clients on 1st of month. Account managers manually compile billable hours, adjust for change orders, calculate totals, and send invoices. Inconsistent formatting causes client confusion and payment delays. Solution: Time tracking system triggers webhook on last day of month with billable hours per client. Workflow generates consistent invoices with itemized service breakdown (social media hours, content creation, ad spend, strategy consulting). Each client receives branded invoice with their specific services. Result: All 35 invoices generated and delivered by 8 AM on 1st of month. 100% brand consistency across all invoices. Client questions reduce by 70% due to clear itemization. Payment speed increases - average collection time drops from 38 days to 24 days. Annual impact: saves 30 hours monthly ($18,000 annually) plus $85,000 improved cash flow from faster collections. Web Development Studio Example Studio completes 12-15 client projects monthly. Invoicing delayed until projects 100% complete causes cash flow gaps. Manually creating milestone invoices for larger projects creates accounting burden. Solution: Project management system triggers invoice on milestone completion (50% deposit, 75% progress payment, final 25%). Workflow automatically generates invoice for milestone amount with reference to project scope and completion percentage. Result: Cash flow improves dramatically with milestone billing. Studio receives payments throughout project instead of only at end. Clients appreciate transparency of milestone invoicing. Payment disputes reduce by 85% since expectations clear. Annual impact: improved cash flow worth $145,000 in working capital plus 40 hours monthly saved (20,000 dollar annual value). Healthcare Clinic Example Medical practice sends 200+ patient invoices monthly for services not covered by insurance. Billing staff manually creates invoices in practice management system, exports to PDF, and mails or emails. Process error-prone and time-consuming. Solution: Integrates workflow with electronic health records (EHR). When service marked as patient-pay, webhook triggers invoice generation with CPT codes, service descriptions, and amounts. Invoice includes payment plan options and online payment link. Result: Invoices sent same day as service instead of 5-7 days later. Patients receive clear, itemized invoices with multiple payment options. Online payment adoption increases from 15% to 62%. Collection rate improves from 73% to 89%. Billing staff reallocates time to insurance follow-up and patient support. Annual impact: saves 25 hours monthly ($15,000 annually) plus $78,000 additional collections. Pro Tips Trigger from Payment Gateways** - Connect Stripe, PayPal webhooks to auto-generate invoices when payments received Use Descriptive Line Items** - Detailed descriptions reduce customer questions and payment delays Include Payment Links** - Online payment links increase payment speed by 40-60% Customize Tax Rates by Location** - Configure different tax rates for different customer jurisdictions Set Payment Terms by Customer** - VIP clients get net-45, standard clients net-30, new clients payment due on receipt Add Company Logo** - Branded invoices with logos increase trust and reduce payment friction Schedule Batch Generation** - Run workflow on 1st of month at midnight for all recurring clients Create Invoice Templates** - Different templates for products vs services vs subscription billing Enable Read Receipts** - Track when customers open invoice emails to time follow-ups Automate Payment Reminders** - Send automated reminder 7 days before due date and on due date Archive by Client** - Create separate Google Drive folders per client for easy retrieval Include Project References** - Link invoices to project names, PO numbers, contracts for customer clarity Add Payment Instructions** - Crystal clear instructions reduce "how do I pay?" emails Use Professional Email Copy** - Friendly but professional email tone encourages prompt payment Track Unpaid Invoices** - Use conditional workflow to escalate overdue invoices to collections process Business Impact Metrics Track these key metrics to measure workflow success: Invoice Generation Time** - Measure average seconds from trigger to sent (target: under 60 seconds) Invoice Volume Capacity** - Count monthly invoices generated through automation (expect 5-10x increase in capacity) Calculation Error Rate** - Track invoices with math or tax errors (target: 0%) Time to Delivery** - Monitor minutes from invoice creation to customer inbox (target: under 5 minutes) Team Hours Saved** - Calculate monthly hours reclaimed from invoice automation (typical: 15-40 hours for small teams) Payment Collection Speed** - Compare days to payment before and after automation (expect 20-35% reduction) Payment Collection Rate** - Track percentage of invoices paid within terms (expect 10-15% improvement) Customer Payment Inquiries** - Monitor support tickets about invoice questions (expect 40-60% reduction) Late Payment Rate** - Track invoices paid after due date (expect 25-40% improvement) Cash Flow Impact** - Measure working capital improvement from faster invoicing and collection (typical: 15-25% improvement) Template Compatibility Compatible with n8n version 1.0 and above Works with n8n Cloud and Self-Hosted instances Requires HTML to PDF API service subscription (1-5 cents per invoice) No coding required for basic setup Fully customizable for industry-specific requirements Mobile-friendly PDF output Multi-currency and multi-language ready Supports batch processing and individual triggers Ready to eliminate invoice headaches? Import this template and start sending professional, accurate invoices in seconds instead of minutes - improving your cash flow, delighting customers, and freeing your team to focus on growing the business!

Who's it for Social media managers, content creators, brand managers, and marketing teams who need to track keyword performance and trending content across TikTok, Instagram, and Reddit for competitive analysis and content inspiration. What it does This workflow automatically monitors trending content across three major social media platforms using specified keywords. It scrapes posts from TikTok, Instagram, and Reddit, calculates engagement scores using platform-specific metrics, ranks content by performance, and generates a comprehensive HTML email report with the top-performing posts across all platforms. How it works The workflow follows a sequential multi-platform scraping process: Reddit Scraping: Searches for keyword-based posts and comments with engagement metrics Instagram Monitoring: Analyzes hashtag-based content with likes and comments data TikTok Analysis: Tracks hashtag performance including views, likes, shares, and comments Score Calculation: Applies platform-specific scoring algorithms based on engagement metrics Unified Ranking: Combines and ranks all content across platforms by engagement score Report Generation: Creates a detailed HTML email report with top performers and analytics Requirements Apify account with API access Gmail account for report delivery Platform-specific scrapers: Reddit Scraper Lite, Instagram Scraper, TikTok Scraper How to set up Step 1: Configure Apify credentials Set up Apify HTTP header authentication in n8n Ensure access to the required scrapers: Reddit: trudax~reddit-scraper-lite Instagram: apify~instagram-scraper TikTok: clockworks~tiktok-scraper Step 2: Customize search parameters Reddit configuration: Search terms: Modify "searches" array with your keywords Content type: Posts and comments (searchComments can be enabled) Sort method: "top" (alternatives: hot, new, relevance) Time period: "month" (alternatives: hour, day, week, year, all) Result limits: maxItems: 50, maxPostCount: 25 Instagram configuration: Hashtag URLs: Update directUrls with target hashtags Results type: "posts" (alternatives: stories, reels) Time filter: "onlyPostsNewerThan": "7 days" Result limit: resultsLimit: 15 TikTok configuration: Hashtags: Update hashtags array with target keywords Results per page: resultsPerPage: 20 Time filter: "oldestPostDateUnified": "7 days" Step 3: Set up email reporting Configure Gmail OAuth2 credentials Update recipient email address in "Send a message" node Customize email subject and styling as needed Step 4: Adjust scoring algorithms Current scoring formulas: Reddit: (upvotes × 1) + (comments × 2) Instagram: (likes × 1) + (comments × 2) TikTok: (likes × 1) + (comments × 2) + (shares × 3) + (views ÷ 1000) Modify the code nodes to adjust scoring based on your priorities. How to customize the workflow Keyword and hashtag targeting Multiple keywords: Add arrays of search terms for broader monitoring Brand-specific terms: Include brand names, product names, competitor analysis Seasonal tracking: Adjust keywords based on campaigns or seasonal trends Negative filtering: Exclude irrelevant content with filtering logic Platform-specific customization Reddit enhancements: Subreddit targeting: Focus on specific communities Comment analysis: Enable comment scraping for deeper insights User profiling: Track specific user activity and influence Instagram modifications: Story monitoring: Track story mentions and hashtag usage Influencer tracking: Monitor specific account performance Location-based: Add geo-targeted hashtag monitoring TikTok optimizations: Trend detection: Identify viral sounds and effects Creator analysis: Track trending creators in your niche Challenge monitoring: Follow hashtag challenge performance Scoring and ranking customization Weighted metrics: Adjust multipliers based on platform importance Recency factors: Give bonus points to newer content Quality filters: Exclude low-engagement or spam content Sentiment analysis: Integrate sentiment scoring for brand monitoring Reporting enhancements Multiple recipients: Send reports to different team members Scheduled execution: Add scheduling triggers for automated monitoring Data export: Save results to spreadsheets or databases Alert thresholds: Set up notifications for high-performing content Engagement scoring methodology Platform-specific algorithms Reddit scoring logic: Emphasizes community engagement through upvotes and discussion Comments weighted higher (×2) as they indicate deeper engagement Filters out low-quality posts and spam content Instagram scoring approach: Balances visual appeal (likes) with engagement depth (comments) Focuses on recent content to capture trending moments Excludes carousel sub-items to avoid duplicate counting TikTok scoring system: Multi-factor algorithm considering all engagement types Views normalized (÷1000) to balance with other metrics Shares heavily weighted (×3) as they indicate viral potential Level classification Content automatically categorized into performance tiers: High: Score ≥ 10,000 (viral or highly engaging content) Medium: Score ≥ 1,000 (good engagement, worth monitoring) Low: Score < 1,000 (baseline engagement) Results interpretation Comprehensive analytics dashboard The email report includes: Cross-platform leaderboard: Top 15 posts ranked by engagement score Platform breakdown: Performance summary by social network Engagement metrics: Detailed scoring and classification Direct links: Clickable access to original content Author tracking: Creator identification for influencer outreach Actionable insights Content inspiration: Identify high-performing content formats and topics Competitor analysis: Monitor competitor content performance Trend identification: Spot emerging topics before they peak Influencer discovery: Find creators driving engagement in your niche Use cases Brand monitoring and competitive analysis Brand mention tracking: Monitor how your brand performs across platforms Competitor surveillance: Track competitor content and engagement rates Crisis management: Early detection of negative sentiment or issues Market positioning: Understand your brand's social media presence Content strategy optimization Content format analysis: Identify which content types perform best Hashtag research: Discover effective hashtags for your niche Posting timing: Analyze when high-engagement content is published Trend forecasting: Spot emerging trends for proactive content creation Influencer and partnership identification Creator discovery: Find influential voices in your industry Partnership evaluation: Assess potential collaborator engagement rates Campaign performance: Track sponsored content and brand partnerships Community building: Identify active community members and advocates Workflow limitations API rate limiting: Subject to Apify scraper limitations and quotas Platform restrictions: Some content may be private or restricted Real-time delays: 30-second waits between platform scraping prevent rate limiting Manual execution: Currently triggered manually (easily schedulable) Single keyword focus: Current setup optimized for one keyword at a time Platform availability: Dependent on third-party scrapers and their maintenance

AI Email Assistant: Get Actionable Gmail Alerts on Telegram Who is this for? This template is designed for busy professionals, founders, freelancers, and support teams who want to stay on top of important emails without constantly checking Gmail. It’s ideal for anyone who needs instant, actionable notifications directly on Telegram. What problem is this workflow solving? / Use case Important emails often get buried under newsletters, promotions, and low-priority messages. Constantly refreshing Gmail wastes time and breaks focus. This workflow acts as an AI-powered email filter and alert system. It monitors your inbox, analyzes incoming messages, and sends only relevant, actionable summaries to Telegram — so you can react quickly without inbox overload. What this workflow does Monitors your Gmail inbox for new emails. Uses AI (OpenAI) to analyze and classify each email. Extracts key information such as: Urgency level Required action Summary of the message Sends a structured, concise alert to Telegram. Optionally highlights emails that require: Immediate reply Payment confirmation Meeting scheduling Client follow-up The result: you receive smart, decision-ready notifications instead of raw email forwards. Setup Import the workflow into your n8n instance. Connect Gmail credentials Add your Google account in n8n. Grant permission to read your inbox. Select the mailbox/folder you want to monitor. Set up OpenAI credentials Add your OpenAI API key in n8n. Ensure billing is active. Connect Telegram Create a Telegram bot via @BotFather. Copy the bot token into n8n. Add your Chat ID (or group ID) where alerts should be sent. Test the workflow Send a test email to your Gmail. Confirm that a summarized, actionable message appears in Telegram. How to customize this workflow to your needs Filter specific senders** Modify the Gmail trigger to monitor only emails from clients, payment platforms, or specific domains. Adjust AI instructions** Edit the system prompt to: Classify emails by priority (High / Medium / Low) Detect invoices, contracts, or support requests Automatically draft suggested replies Change alert format** Customize the Telegram message structure (add emojis, urgency labels, or action buttons). Add automation branches** Extend the workflow to: Create tasks in Notion or Trello Add calendar events automatically Label emails in Gmail based on AI classification With this template, your inbox becomes an AI-powered assistant that filters noise and delivers only what truly matters — directly to Telegram in real time. 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n

Streamline your hiring process with intelligent AI-powered candidate screening and automated interview scheduling. This workflow receives applications via webhook, evaluates candidates using OpenAI's GPT model, scores them against job requirements, stores data in Google Sheets, and automatically schedules interviews for high-scoring candidates — all while sending personalized email notifications and updating statuses in real time. Reduce manual screening time and ensure only top candidates move forward. 🤖📧 What This Template Does Step 1: Triggers on new application submission via Webhook (e.g., from job portal or form). Step 2: Stores applicant data (resume, contact, role) into Google Sheets for centralized tracking. Step 3: Uses OpenAI GPT to evaluate candidate fit based on resume, skills, and job requirements. Step 4: Applies Scoring Logic:   • Score ≥ 70 → Qualified for interview   • Score < 70 → Not a fit Step 5: Branches based on score:   → High Score Path:    • Sends Interview Invitation Email    • Creates Google Calendar Event    • Updates Sheet: Status → “Interview Scheduled”   → Low Score Path:    • Sends Polite Rejection Email    • Updates Sheet: Status → “Rejected” Step 6: Final metrics logged and webhook response confirms completion. Key Benefits ✅ Eliminates manual resume screening ✅ AI evaluates candidates consistently and objectively ✅ Automates interview scheduling with calendar integration ✅ Real-time status updates in Google Sheets ✅ Personalized email communication at every stage ✅ Full audit trail of decisions and actions Features Webhook-triggered application intake Google Sheets as applicant tracking system (ATS) OpenAI GPT-powered candidate evaluation Dynamic scoring threshold (customizable) Conditional branching (High/Low Score) Gmail integration for email notifications Google Calendar auto-event creation Real-time status updates via sheet write-back Final webhook response for system confirmation Requirements GOOGLE_SHEET_ID**: Your Google Sheet ID Credentials Needed:** Google Sheets OAuth2 Gmail API Key OpenAI API Key Google Calendar OAuth2 Customize:** • Job requirements & AI prompt • Score threshold (currently 70) • Email templates • Interview scheduling time slots Target Audience HR teams managing high-volume applications 👥 Recruiters seeking faster shortlisting ⏱️ Startups automating early-stage hiring 🚀 Tech companies with technical screening needs 💻 Remote-first organizations using digital workflows 🌍 Step-by-Step Setup Instructions Set up Google Sheet  → Create a sheet with columns: Name, Email, Resume Link, Role, Status, Score, Timestamp  → Replace YOUR_SHEET_ID in the workflow with your actual Sheet ID. Configure Webhook  → Connect your job application form (e.g., Typeform, LinkedIn, custom portal) to trigger this workflow. Add OpenAI API Key  → Insert your OpenAI key and customize the evaluation prompt under “AI Evaluation” node. Set Scoring Threshold  → Adjust the “IF – Check Score Threshold” node (default: ≥70 = pass). Connect Gmail & Calendar  → Enable Gmail OAuth2 and Google Calendar OAuth2.  → Define interviewer email and default interview duration. Customize Emails  → Edit “Interview Invitation” and “Rejection Notice” templates with your branding. Test the Flow  → Submit a test application via webhook.  → Verify: Sheet update → AI score → Email → Calendar event → Status change. Go Live  → Enable automation. Monitor first few runs in Google Sheets. Workflow Complete! Now sit back as AI screens, scores, schedules, and communicates — all without lifting a finger. Metrics to Track: Applications received Average AI score Interview rate Time to process