Workflow Templates

What this workflow does This workflow monitors your Gmail inbox for new, unreplied emails and automatically generates a professional reply draft using AI. Instead of sending the email automatically, the draft is sent to Slack so a human can review and decide whether to send it. This makes it ideal for teams that want to save time on email replies while keeping full control over outgoing communication. How it works Checks Gmail on a schedule for new, unreplied emails Limits the number of emails processed per run to avoid overload Extracts the email body and sends it to an AI model Generates a polite, professional reply draft Sends the draft to a Slack channel for review Adds a Gmail label to prevent duplicate processing Setup time ~10–15 minutes Who this is for Customer support teams Freelancers and consultants Small businesses handling frequent email inquiries Anyone who wants AI-assisted email replies with human approval Requirements Gmail account Slack workspace OpenAI (or compatible AI) credentials

UPDATES: 2025-12-03 fix JS code in calculate hourly sum node E.ON W1000 → n8n → Home Assistant (Spook) “Integration” This workflow processes emails from the E.ON portal containing 15-minute +A -A (import/export) data and daily 1.8.0 2.8.0 meter readings. It extracts the required columns from the attached XLSX file, groups the 15-minute values by hour, then: updates the Spook/Recorder statistics under the IDs sensor.grid_energy_import and sensor.grid_energy_export, and sets the current meter readings for the entities input_number.grid_import_meter and input_number.grid_export_meter. > You may need to modify the workflow if there are changes in how E.ON sends scheduled exports. If the exported data format changes, please report it on Github! Requirements n8n (cloud or self-hosted) HACS addon available here: Rbillon59/home-assistant-addons Official n8n Docker Compose template Simplified n8n Docker Compose template available on Github (For Gmail) Gmail API authentication (OAuth2) read-only email access to the account receiving the messages Setup guide available here (For IMAP) IMAP provider credentials Home Assistant access via Long-Lived Access Token or API key Setup guide available here Spook integration Documentation and installation guide available here E.ON Portal Setup Create a scheduled export on the E.ON portal with the following parameters: Under the Remote Meter Reading menu, click on the + new scheduled export setting button. Specify POD identifier(s): choose one of the PODs you want to query. Specify meter variables: select the following: +A Active Power Consumption -A Active Power Feed-In DP_1-1:1.8.0*0 Active Power Consumption Daily Reading DP_1-1:2.8.0*0 Active Power Feed-In Daily Reading Export sending frequency: daily Days of historical data to include: recommended 7 days to backfill missed data. Email subject: by default, use [EON-W1000]. If processing multiple PODs with the workflow, give each a unique identifier. Home Assistant Preparation Create the following input_number entities in configuration.yaml or via Helpers: input_number: grid_import_meter: name: grid_import_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh grid_export_meter: name: grid_export_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh > If you name the entities differently, make sure to reflect these changes in the workflow. Create the following template_sensor entities in configuration.yaml or via Helpers: input_number: grid_import_meter: name: grid_import_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh grid_export_meter: name: grid_export_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh >If you name the entities differently, make sure to reflect these changes in the workflow. create the following template_sensor entities in config.yaml or via Helpers: template: sensor: name: "grid_energy_import" state: "{{ states('input_number.grid_import_meter') | float(0) }}" unit_of_measurement: "kWh" device_class: energy state_class: total_increasing name: "grid_energy_export" state: "{{ states('input_number.grid_export_meter') | float(0) }}" unit_of_measurement: "kWh" device_class: energy state_class: total_increasing > If you name the entities differently, make sure to reflect these changes in the workflow. n8n import and authentication importing the workflow In n8n → Workflows → Import from File/Clipboard → paste the JSON. Select the downloaded JSON and paste it into a new workflow using Ctrl+V. Set up n8n Credentials The credentials must be configured in the Home Assistant and Gmail nodes. The setup process is described in the Requirements section.

Title (suggested): Extract business card data from Telegram to Google Sheets Who’s it for Teams that receive business cards digitally (sales, marketing, back-office) and want a plug-and-play way to capture contacts into a sheet without manual typing. What it does / How it works This workflow ingests a business card sent to your Telegram bot, detects whether the message contains an image or text, extracts key fields with an AI Vision Agent (company, full name, department, job title, postal code, address, phone, mobile, fax, email, website), and appends or updates a contact row in Google Sheets automatically. How to set up Connect Telegram (bot token) and enable file download. Connect your AI provider (OpenRouter or equivalent) used by the AI Vision Agent. Connect Google Sheets and select your spreadsheet + sheet tab. Rename nodes clearly and keep sticky notes: one overview note (this description) + step notes. Test by sending a sample card image to your bot and verify the row is appended/updated. Requirements Telegram Bot API credential AI chat/vision credential Google Sheets OAuth credential and an accessible spreadsheet How to customize the workflow Map fields to your sheet headers (add/remove columns as needed). Adjust the system prompt to prefer your locale or specific field formats. Change the matching key for update logic (e.g., company name or email). Add downstream steps (CRM push, dedupe rules, notifications). Security note: Do not hardcode API keys or include real IDs/emails. Use credentials and environment configs only. JSON [ { "company_name": "Example Company Ltd.", "department": "Sales", "job_title": "Sales Manager", "full_name": "Taro Yamada", "postal_code": "100-0001", "address": "1-1-1 Marunouchi, Chiyoda-ku, Tokyo", "phone_number": "+81-3-0000-0000", "mobile_phone_number": "+81-90-0000-0000", "fax_number": "+81-3-1111-1111", "email": "example@company.com", "website_url": "https://example.com" } ] Troubleshooting Nothing appears in Google Sheets Solution: Verify that your Google Sheets credentials are correctly authorized. Confirm the Spreadsheet ID and Sheet Name in the node match your target file. Make sure the Google Sheets node is connected downstream of the AI Vision Agent. If the workflow runs successfully but nothing is added, check whether the matching column (company_name) already exists — in appendOrUpdate mode it will only update that row. AI returns incomplete or invalid data Solution: Review the system prompt in the AI Vision Agent to ensure it instructs the model to return a structured JSON object with all required fields (company name, full name, department, job title, address, etc.). If the result is partial, verify the image quality of the uploaded business card — low contrast or skewed images can reduce OCR accuracy. You can reduce temperature in the AI node to make output more deterministic. Workflow doesn’t start automatically Solution: Check that the workflow is activated (toggle is ON in the top right of n8n). Verify the Webhook URL is correctly registered in Telegram’s bot settings. Run manually once to ensure all credentials and nodes are configured correctly.

Overview This workflow automates weather forecast delivery by collecting city names, fetching 5-day forecasts from OpenWeatherMap, and generating professionally formatted HTML emails using GPT-4. The AI creates condition-based color-coded reports with safety precautions and sends them via Gmail. How It Works A form trigger collects up to three city names, which are geocoded via OpenWeatherMap API to retrieve coordinates and 5-day forecasts. JavaScript nodes process the raw weather data into daily summaries, calculating temperature ranges, precipitation levels, wind speeds, and dominant weather conditions. GPT-4 then generates professionally formatted HTML emails with condition-based color coding: The AI intelligently adds contextual safety warnings for heavy rain, extreme heat, high winds, and thunderstorms. A validation node ensures proper JSON formatting before Gmail sends the final briefing. Use Cases • Field ops & construction crew briefings • Travel planning and itinerary preparation • Outdoor event planning & coordination • Logistics and transportation route planning • Real estate property viewing scheduling • Sports and recreational activity planning Setup Requirements 1) OpenWeatherMap API credentials 2) OpenAI API key 3) Gmail OAuth2 authentication Need Help? Join the Discord or ask in the Forum! README file available at https://tinyurl.com/MulticityWeatherForecast

This n8n template demonstrates how to automate personalized cold email follow-ups using AI personalization and database tracking. Perfect for sales teams, recruiters, and agencies managing high-volume outreach. Use cases: Follow up with cold leads, re-engage trial users, nurture conference contacts, recruit candidates, or follow up with proposal recipients. PS: 1) This was created as a Follow Up workflow it was not meant for inital outreach. (However if you can customize it to include initial outreach then go ahead) 2)This workflow sends a maximum of 4 follow Ups How it works NocoDB fetches all leads and filters those needing follow-up today based on the "Next Follow up/Contact" date A switch node routes leads to the appropriate follow-up stage (1-4) based on which follow-ups have already been sent AI personalizes each email template by inserting the recipient's name while keeping the rest of the content intact Emails are sent via SMTP (or Gmail node), then the database updates to mark the follow-up as sent and schedule the next one The workflow runs daily at 10 AM to automatically process follow-ups without manual intervention Good to know Each AI personalization costs ~$0.001 with Groq (free tier available). See Groq pricing for details. Follow-up schedule: Day 3, 7, 12, 16 after initial contact (fully customizable) Leads marked "Not Interested" are automatically excluded from future follow-ups The workflow only processes leads with an "Initial Contact Date" set - this triggers the entire sequence (The initial Contact is done manually and updated manually) How to use The schedule trigger runs daily but can be replaced with manual trigger or webhook for immediate testing Customize the 4 email templates in the AI nodes to match your brand voice and offering Adjust follow-up intervals by modifying the "Update a row" nodes (currently +4 or +5 days between follow-ups) Import your lead list to NocoDB with minimum required fields: first_name, last_name, email, Initial Contact Date Requirements NocoDB account** - Free lead database (You can use any database-Google Sheets, Airtable etc. However ensure the essential details below are in the database) Groq API key** (or OpenAI/Ollama) - For AI personalization (Swap this for any LLM you like/have) SWITCH* the 'Send Email' nodes for the *Gmail** Node and set it up using OAuth

News Intelligence Workflow using NewsAPI, AI Model, Google Sheets & Error Alerts This workflow automatically fetches news articles from NewsAPI, processes them using an AI model to generate summaries and key regulatory changes and stores both raw and processed data into Google Sheets. It also includes centralized error handling with email alerts for monitoring failures. Quick Implementation Steps Signup / Login to your n8n account Add your NewsAPI key in the configuration node. Set your Google Sheet ID and ensure required columns exist. Update the search query (e.g., regulation, finance, etc.). Configure email recipient for error alerts (optional). Execute using the Manual Trigger node. Review results in Google Sheets. What It Does This workflow automates the process of collecting and analyzing news articles. It starts by fetching the latest news based on a defined keyword using NewsAPI. The fetched data is cleaned, sorted and filtered to ensure only relevant and valid articles are processed further. Each article is then processed individually in a controlled loop to avoid API rate limits. The workflow stores raw article data into Google Sheets for reference and backup. It then uses an AI model to generate a concise summary and extract key regulatory or policy changes from each article. Finally, the structured AI output is formatted and updated back into the same Google Sheet. The workflow also includes a high-level error handling mechanism that collects errors from multiple nodes, formats them and sends email alerts for easier monitoring and debugging. Who It's For Business analysts tracking regulatory updates Compliance and legal teams Data analysts and automation engineers News aggregation platforms Anyone looking to automate news monitoring and summarization Requirements To use this workflow, you need: n8n account NewsAPI account and API key Google Sheets account with OAuth credentials configured in n8n A Google Sheet with the following columns: Title Source Published_At Content Summary Key Changes (Optional) Gmail account connected for error alerts How It Works & Setup Instructions 1. Trigger the Workflow Uses Manual Trigger node for execution. Ideal for testing; can be extended later. 2. Configure Variables In Workflow Config & Variables node: Add newsApiKey Set searchQuery (default: regulation) Define maxArticlesToFetch Set loopWaitSeconds Add googleSheetId Configure API timeout and headers if needed 3. Fetch News Data HTTP Request Node** calls NewsAPI using: Query keyword Sorting (publishedAt) API key authentication 4. Preprocess Articles Code Node (Python)**: Sorts articles by date Filters invalid entries Extracts required fields (title, content, source, etc.) 5. Limit Articles Limit Node** restricts number of articles processed. 6. Store Raw Data SplitInBatches + Wait + Google Sheets (Append)**: Stores raw articles into the same sheet Adds delay to avoid rate limits 7. Validate & Loop IF Node** filters valid articles SplitInBatches** processes one article at a time 8. AI Processing AI Node**: Generates: Summary (max 60 words) Key regulatory changes Ensures strict structured output 9. Format Output Code Node (JavaScript)**: Extracts summary and key changes Cleans and structures AI output 10. Update Sheet Google Sheets (Update)**: Updates existing rows based on Title Adds Summary and Key Changes 11. Error Handling Errors from multiple nodes are: Collected via Merge Node Formatted using Set Node Delayed using Wait Node Sent via Email Node How To Customize Nodes Search Query** Change config.searchQuery to track different topics (e.g., AI, finance, crypto). Article Limit** Adjust config.maxArticlesToFetch to process more or fewer articles. Delay Timing** Modify config.loopWaitSeconds to control API rate limits. AI Prompt** Customize the prompt in AI node to extract different insights. Google Sheet Mapping** Add/remove columns based on your reporting needs. Add-ons (Enhancements) Replace Manual Trigger with: Cron (scheduled runs) Webhook (real-time trigger) Add Slack/Telegram alerts for summaries Store data in a database instead of Google Sheets Add sentiment analysis to articles Build a dashboard using BI tools Use Case Examples Regulatory monitoring for finance or legal industries Daily news digest automation for teams Competitive intelligence tracking Research support for analysts Content curation for blogs or newsletters There can be many more use cases depending on how you customize the workflow. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No articles fetched | Invalid API key | Verify NewsAPI key | | Empty AI output | Incorrect prompt format | Check AI node prompt | | Google Sheet not updating | Wrong Sheet ID or permissions | Verify Sheet ID and OAuth access | | Duplicate entries | Matching column misconfigured | Ensure Title is used as match key | | Workflow stops unexpectedly | API timeout or rate limits | Increase wait time or timeout settings | | No email alerts | Email not configured | Add recipient email in Gmail node | Need Help? If you need assistance setting up this workflow, customizing nodes or building advanced automation solutions, feel free to reach out to our n8n automation team at WeblineIndia. WeblineIndia specializes in building scalable automation workflows, AI integrations and business process solutions tailored to your needs. Whether you're looking to extend this workflow or create something entirely new, expert help is just a step away.

WordPress Weekly Newsletter Generator Overview: This automation automatically converts your latest WordPress posts into beautifully formatted email newsletters using AI, then sends them to your subscriber list every Friday. What it does: Fetches your latest WordPress posts from the past week every Friday at 10 AM Filters posts to ensure there's content to include AI creates an engaging newsletter with compelling subject line and HTML content Parses the AI response to extract subject and content Sends formatted HTML email newsletter to your subscriber list Setup Required: WordPress Connection Configure WordPress credentials in the "Fetch Recent Posts" node Enter your WordPress site URL, username, and password/app password Email SMTP Setup Set up SMTP credentials (Gmail, SendGrid, Mailgun, etc.) in the "Send Newsletter" node Replace newsletter@yoursite.com with your actual sender email Replace subscriber emails in "To Email" field with your actual subscriber list Configure reply-to address for professional appearance AI Configuration Set up Google Gemini API credentials Connect the Gemini model to the "AI Newsletter Creator" node Customization Options Newsletter Schedule: Modify schedule trigger (default: Friday 10 AM) Post Count: Adjust number of posts to include (default: 5 from past week) Content Style: Modify AI system message for different newsletter tones Email Design: Customize HTML template and styling in AI prompt Testing Run workflow manually to test all connections Send test newsletter to yourself first Verify HTML formatting appears correctly in email clients Features: Automatic weekly scheduling AI-generated compelling subject lines HTML email formatting with proper structure Post filtering to avoid empty newsletters Professional email headers and reply-to setup Batch processing of multiple recent posts Customization: Change newsletter frequency (daily, bi-weekly, monthly) Adjust AI prompts for different writing styles Modify email template design Add custom intro/outro messages Include featured images from posts Need Help? For n8n coaching or one-on-one consultation

Initial Outreach Email Workflow This n8n template demonstrates how to automate personalized cold email outreach using AI and a lead database. It’s designed to contact unengaged leads, personalize messages at scale, and schedule follow-ups automatically. Use cases are many: Reach out to new leads, qualify prospects, start conversations, and set up consistent follow-up routines. Great for sales teams, recruiters, and agencies running cold outreach campaigns. Good to know Each AI personalization costs about $0.001 with Groq (free tier available; pricing may vary by provider). The workflow limits emails to 15 per day by default to protect your email reputation and reduce spam risk. The email template is fully customizable to match your brand tone and offer. Outreach timing and follow-up intervals are easy to adjust within the workflow. How it works NocoDB** fetches leads who haven’t been contacted yet (no “Initial Contact Date”). The Limit node ensures no more than 15 emails per run. AI personalizes** your chosen email template with lead name and company. Emails are sent via SMTP or Gmail node. Each contacted lead is updated in the database with today’s Initial Contact Date and a Next Follow-up Date (default 3 days later). The workflow runs on a daily schedule at 10:30 AM (configurable). How to use Set up a NocoDB/any database table with: first_name email Initial Contact Date Next Follow up/Contact organization_name (optional) Customize the email template inside the AI node. Adjust the daily limit and schedule to match your outreach capacity. Import leads into NocoDB and configure credentials for NocoDB, AI provider, and SMTP. Run the workflow manually for testing before going live.

🏠 SignSnapHome.com Open House Lead Management System Automatically capture, qualify, and follow up with open house visitors in real-time This comprehensive n8n workflow transforms your SignSnap Home open house sign-ins into a complete lead management system with instant notifications, intelligent lead scoring, and automated multi-channel follow-ups. View full blog writeup and YouTube video here: Open House n8n + SignSnapHome Automation 🎯 What This Workflow Does Transform every open house visitor into a managed lead with automated processing, scoring, and outreach—all without lifting a finger. Core Features 📸 Visual Lead Capture Automatically processes guest photos from sign-in Converts base64 images to proper binary format Displays guest photos as thumbnails in Discord notifications Supports JPEG, PNG, and other image formats 🎨 Smart Lead Scoring System 🔴 HOT Leads**: No agent + high rating (4-5 stars) → Immediate follow-up priority 🟠 WARM Leads**: Has agent but no buyer agreement → Potential opportunity 🟡 MEDIUM Leads**: Standard engagement level 🔵 COLD Leads**: Has agent with signed agreement OR low rating (1-2 stars) Color-coded Discord embeds for instant visual prioritization 📊 Rich Discord Notifications Beautiful embed cards with all guest information Guest photo thumbnail displayed inline Conditional fields (rating only shows if you have it enabled) Custom field support - ANY extra form fields automatically included Timestamp, contact info, property details Lead priority badge and color coding 📱 Intelligent SMS Follow-up (via Twilio) Sends personalized text message if phone number provided Different messaging for leads with/without agents Professional, warm tone that encourages response Simple "thank you for visiting" approach 📧 Professional Email Follow-up Beautiful HTML email template with gradient header Conditionally shows rating if available Different call-to-action based on agent status Branded footer with SignSnap Home mention Only sends if no phone number (SMS takes priority) Fallback to email if SMS not available ⚙️ Flexible Custom Field Support Automatically detects and processes ANY custom fields No workflow modification needed for new form fields Formats field names nicely (snake_case → Title Case) Displays all custom fields in Discord notification Perfect for additional questions like buyer agreements, prequalification status, etc. 📋 Workflow Structure Node Breakdown Webhook Trigger - Receives POST data from SignSnap Home Parse & Enrich Data - Extracts and processes all form data Separates standard vs custom fields Calculates lead priority score Formats timestamps and names Detects optional fields (like rating) Convert Image to Binary - Transforms base64 photo to n8n binary format Discord Notification - Sends rich embed with photo thumbnail Has Phone Number? - Conditional routing based on contact preference Send SMS (Twilio) - Priority follow-up via text message Has Email? - Fallback check if no phone provided Send Welcome Email - Professional HTML email follow-up ✨ Key Highlights Dynamic & Flexible No hardcoded fields** - automatically adapts to YOUR SignSnap form Works with default fields AND any custom fields you add Rating field is completely optional Handles missing data gracefully Smart Routing SMS-first approach (higher engagement rates) Automatic fallback to email if no phone Only sends what makes sense for each lead Professional Presentation Discord: Visual dashboard for your team SMS: Quick, personal outreach Email: Professional, branded communication Lead Intelligence Automatic qualification based on agent status Rating consideration (when available) Buyer agreement detection Priority-based follow-up suggestions 🔧 Setup Requirements Services Needed SignSnap Home Account - For open house sign-in app Discord Webhook - For team notifications Twilio Account - For SMS (optional but recommended) SMTP Email - For email follow-ups (optional) Configuration Steps Import this workflow into your n8n instance Set up Discord webhook: Create a webhook in your Discord channel Replace YOUR_WEBHOOK_ID/YOUR_WEBHOOK_TOKEN in the HTTP Request node Configure Twilio (if using SMS): Add Twilio credentials in n8n Set your Twilio phone number Configure Email (if using email): Add SMTP credentials in n8n Update the "from" email address Activate your workflow Copy the webhook URL from n8n Configure SignSnap Home: Go to your open house settings Add the n8n webhook URL as your automation endpoint Enable "Send on each submission" (not batch) 📝 Optional Features You Can Add Rating Field Add a "What did you rate the house?" field (1-5 scale) Workflow automatically detects and displays it Affects lead scoring (high ratings = hotter leads) Buyer Agreement Field Add "Do you have a signed buyer agreement?" field Helps identify truly available leads Factors into WARM vs COLD lead classification Any Custom Fields Add ANY additional questions to your form They'll automatically appear in Discord notifications No workflow changes needed! 🎨 Customization Ideas Modify Lead Scoring Edit the JavaScript in the "Parse & Enrich Data" node to adjust: Lead priority thresholds Color coding Scoring criteria Change Message Templates SMS message in "Send SMS (Twilio)" node Email HTML in "Send Welcome Email" node Discord embed structure in "Discord Notification" node Add More Automation Save to Google Sheets/Airtable Create tasks in your CRM Send to Slack instead of/in addition to Discord Add to email marketing list Trigger other workflows 💡 Use Cases Real Estate Agents**: Instant lead capture and follow-up Property Managers**: Track open house attendance Real Estate Teams**: Centralized lead dashboard Brokerages**: Multi-agent lead distribution Home Builders**: Model home visitor tracking 🚀 Why This Workflow Rocks ✅ Zero Manual Work - Completely automated from sign-in to follow-up ✅ Intelligent - Smart lead scoring and routing ✅ Flexible - Adapts to YOUR form fields ✅ Professional - Polished notifications and outreach ✅ Multi-Channel - Discord, SMS, and Email coverage ✅ Visual - See guest photos instantly ✅ Scalable - Handle unlimited open houses ✅ Customizable - Easy to modify for your needs 📊 What You Get Instant Visibility**: See every visitor as they sign in Lead Intelligence**: Know who's hot and who's not Fast Follow-up**: Reach out while interest is hot Team Coordination**: Everyone sees the same data Professional Image**: Automated, timely communication Time Savings**: Hours of manual work eliminated 🔗 Integration Details Webhook Endpoint: /signsnaphome-sign-in-trigger Method: POST Content-Type: application/json Expected Format: SignSnap Home standard output 📞 Support & Customization This workflow is designed to work out-of-the-box with SignSnap Home, but can be adapted for: Other open house sign-in apps Different notification platforms Custom CRM integrations Additional automation steps ⚡ Quick Start Summary Import workflow Add Discord webhook URL (Optional) Configure Twilio for SMS (Optional) Configure SMTP for email Activate workflow Copy webhook URL Add to SignSnap Home settings Start collecting leads! 🎯 Perfect For Solo agents wanting to professionalize their follow-up Teams needing centralized lead management Brokerages tracking multiple open houses Anyone using SignSnap Home for open house sign-ins Transform your open house visitors into qualified, followed-up leads automatically. Never miss an opportunity again! Tags: real-estate, lead-management, automation, discord, twilio, sms, email, webhook, signsnap, open-house, crm Difficulty: Intermediate Nodes Used: 8 External Services: SignSnap Home, Discord, Twilio (optional), SMTP (optional)

AI Resume Screening Workflow using Gmail, OpenAI (GPT-4 Turbo) & Slack This workflow automatically fetches resumes from Gmail, extracts text from PDF attachments, analyzes candidate profiles using AI, and shortlists qualified candidates by sending their details to Slack. It significantly reduces manual effort in resume screening and speeds up hiring decisions. Quick Implementation Steps Connect your Gmail account in n8n Connect your OpenAI API (GPT-4 Turbo) Connect your Slack account Ensure resumes are received as PDF attachments in Gmail Update job requirements inside the AI Resume Analyzer node Run the workflow manually or activate it What It Does This workflow automates the resume screening process by integrating Gmail, AI, and Slack into a seamless pipeline. It starts by fetching emails containing resume attachments, then processes and validates these files to ensure only PDF resumes are analyzed. Once validated, the workflow extracts text from each resume and sends it to an AI model. The AI evaluates candidate details such as skills, experience, and contact information, and calculates a match score based on predefined job requirements. Finally, the workflow determines whether a candidate should be shortlisted or rejected. Shortlisted candidates are instantly shared on Slack with complete details, enabling faster hiring decisions and reducing manual screening effort. Who’s It For HR teams and recruiters Hiring managers Startups handling large volumes of applications Recruitment agencies Businesses looking to automate candidate screening Requirements to Use This Workflow n8n (self-hosted or cloud) Gmail account (OAuth connected) OpenAI API key (GPT-4 Turbo access) Slack account (with channel access) Resumes in PDF format Basic understanding of n8n workflows How It Works & Set Up Setup Instructions Manual Trigger Setup Use the Start Workflow Manually node to initiate the workflow. Gmail Configuration Connect your Gmail account in the Fetch Gmail node. Ensure emails contain resume attachments. Attachment Processing The workflow formats and checks attachments. Only emails with attachments proceed further. PDF Validation Ensure resumes are in PDF format. Non-PDF files are ignored automatically. Text Extraction The Extract Resume Text node converts PDF resumes into plain text. AI Configuration Add your OpenAI credentials in the OpenAI Chat Model node. Customize job requirements inside the AI Resume Analyzer node prompt. Evaluation Logic Candidates are scored based on: Skills (50%) Experience (30%) Location (20%) Output Handling If score ≥ 70 → Sent to Slack as shortlisted. Else → Marked as rejected Activate Workflow Run manually or activate for continuous use. How To Customize Nodes AI Resume Analyzer** - Modify job requirements (skills, experience, location). Adjust scoring logic or threshold Evaluate Candidate Score** - Change minimum score (default: 70) Slack Node** - Customize message format. Change Slack channel Gmail Node** - Add filters (labels, subjects, senders) Extract Resume Text** - Extend for other file formats if needed 1.8 Add-ons (Enhancements) Store shortlisted candidates in Google Sheets or database Send rejection emails automatically Add ATS (Applicant Tracking System) integration Include resume ranking system Add duplicate candidate detection Enable multi-role job matching 1.9 Use Case Examples Automating resume screening for tech hiring Filtering candidates for specific skill sets (e.g., React Native developers) Handling bulk job applications efficiently Shortlisting candidates for remote roles Pre-screening candidates before interviews There can be many more use cases depending on hiring workflows and business needs. 1.10 Troubleshooting Guide | Issue | Possible Cause | Solution | |---------------------------|-----------------------------------------------------|------------------------------------------------------------| | No emails fetched | Gmail not connected or incorrect filters | Reconnect Gmail and check filters | | Attachments not processed | Emails don’t contain attachments | Ensure resumes are attached | | PDF not detected | Incorrect file type | Ensure resumes are in PDF format | | AI response parsing error | Invalid JSON from AI | Check prompt and enforce strict JSON | | No Slack message | Slack credentials or channel issue | Verify Slack connection and channel ID | | Low-quality matches | Incorrect job requirements | Update AI prompt with accurate criteria | Need Help? If you need assistance setting up this workflow or customizing it for your business needs, we’re here to help. Whether you want to: Extend this workflow with advanced features Integrate it with your existing systems Build similar automation solutions Feel free to reach out to our n8n workflow development experts at WeblineIndia for expert support and tailored workflow development. 👉 Let us help you automate smarter and scale faster.

What this does Receives a URL via webhook, uses Firecrawl to scrape the page into clean markdown, and stores it as vector embeddings in Supabase pgvector. A visual, self-hosted ingestion pipeline for RAG knowledge bases. Adding a new source is as simple as sending a URL. The second part of the workflow exposes a chat interface where an AI Agent queries the stored knowledge base to answer questions, with Cohere reranking for better retrieval quality. How it works Part 1: Ingestion Pipeline Webhook receives a POST request with a url field Verify URL validates and normalizes the domain Supabase checks if the URL was already ingested (deduplication) If the URL already exists, ingestion is skipped; otherwise it continues Firecrawl fetches the page and converts it to clean markdown OpenAI generates vector embeddings from the scraped content Default Data Loader attaches the source URL as metadata Supabase Vector Store inserts the content and embeddings into pgvector Respond to Webhook confirms how many items were added Part 2: RAG Chat Agent Chat trigger receives a user question AI Agent (OpenRouter) queries the Supabase vector store filtered by URL Cohere Reranker improves retrieval quality before the agent responds Agent answers based solely on the ingested knowledge base Requirements Firecrawl API key OpenAI API key (for embeddings) OpenRouter API key (for the chat agent) Cohere API key (for reranking) Supabase project with pgvector enabled Setup Create a Supabase project and run the following SQL in the SQL editor: -- Enable the pgvector extension create extension vector with schema extensions; -- Create a table to store documents create table documents ( id bigserial primary key, content text, metadata jsonb, embedding extensions.vector(1536) ); -- Create a function to search for documents create function match_documents ( query_embedding extensions.vector(1536), match_count int default null, filter jsonb default '{}' ) returns table ( id bigint, content text, metadata jsonb, similarity float ) language plpgsql as $$ #variable_conflict use_column begin return query select id, content, metadata, 1 - (documents.embedding <=> query_embedding) as similarity from documents where metadata @> filter order by documents.embedding <=> query_embedding limit match_count; end; $$; Add your Firecrawl API key as a credential in n8n Add your OpenAI API key as a credential (for embeddings) Add your OpenRouter API key as a credential (for the chat agent) Add your Cohere API key as a credential (for reranking) Activate the workflow How to use Send a POST request to the webhook URL: curl -X POST https://your-n8n-instance/webhook/your-id \ -H "Content-Type: application/json" \ -d '{"url": "https://firecrawl.dev/docs"}' Then open the chat interface in n8n to ask questions about the ingested content.

📊 Description Most period tracking apps tell you when your period is coming. This workflow goes further — it tracks every phase of every subscriber's unique cycle, sends the right email at exactly the right time, and delivers GPT-4o powered wellness coaching every week tailored to where each woman is in her cycle. Built for women's health platforms, wellness coaches, femtech creators, and community builders who want to deliver genuinely useful cycle-aware health support at scale without building a custom app. What This Workflow Does 📝 Subscribers fill in a simple form — name, email, last period date, and cycle length 🧮 Instantly calculates all key cycle dates — next period, ovulation day, fertile window start and end, and PMS window start 📧 Sends a personalized welcome email with their complete cycle overview 🕐 Runs every morning at 8AM checking all active subscribers 🔍 Detects which phase event is happening today for each subscriber 📬 Sends the right phase-specific reminder email on the exact right day: - 3 days before period — preparation tips - Period start day — comfort and self-care tips - Ovulation day — fertility awareness and energy tips - PMS window start — mood, energy, and boundary tips 🔒 Duplicate send prevention ensures each email type is only sent once per cycle per subscriber 📝 Updates each subscriber's last email sent record after every send 📊 Logs every delivery to Send Log sheet with date, phase, cycle day, and email type 💜 Every Sunday generates a personalized weekly wellness digest for every subscriber using GPT-4o based on their current cycle phase — with energy, nutrition, movement, and mindset tips Key Benefits ✅ Fully automated — set up once and runs forever ✅ Every subscriber gets emails timed to their unique cycle not a generic schedule ✅ 4 different phase-specific reminder emails with tailored content and colors ✅ GPT-4o generates unique wellness tips per phase every week — never repetitive ✅ Duplicate send prevention — no subscriber ever gets the same email twice in one cycle ✅ Auto-recalculates cycle dates on period start for continuous tracking ✅ Full send log for tracking delivery history and engagement patterns How It Works SW1 — Subscriber Intake & Cycle Calculator Subscribers open the form and enter their name, email, last period start date, and average cycle length. The workflow immediately calculates all key dates using standard cycle science — next period is last period plus cycle length, ovulation is next period minus 14 days, fertile window opens 5 days before ovulation and closes 1 day after, and PMS window starts 5 days before the next period. All dates are saved to the Subscribers sheet and a branded welcome email is sent instantly showing the subscriber their complete cycle overview with all dates laid out clearly. SW2 — Daily Cycle Monitor & Smart Reminders Every morning at 8AM the workflow reads all active subscribers and calculates where each one is in their cycle today. It checks if today matches any of the 4 key trigger dates — 3 days before period, period start, ovulation day, or PMS start. If there is a match it builds the appropriate phase-specific HTML email with tailored tips, colors, and messaging and sends it via Gmail. Before sending it checks the last email sent field to prevent duplicate sends within the same cycle. After every send it updates the subscriber record and logs the delivery to the Send Log sheet. SW3 — Weekly Wellness Digest Every Sunday at 9AM the workflow reads all active subscribers and calculates each one's current cycle phase — Menstrual, Follicular, Fertile, Ovulation, or PMS. It builds a personalized prompt for each subscriber including their name, phase, cycle day, and days until next period and sends it to GPT-4o. The AI generates phase-specific tips across 5 categories — energy management, nutrition, movement, mindset, and what to expect this week — plus a weekly affirmation. The response is assembled into a branded HTML email where the header color and emoji adapt automatically to the current phase. Every send is logged to the Send Log sheet. Features n8n Form intake — no external form tool needed Automatic cycle date calculation from last period and cycle length 4 phase-specific trigger emails with unique content per phase Duplicate send prevention per cycle per subscriber Phase detection engine covering all 5 cycle phases GPT-4o weekly wellness coaching per phase Phase-adaptive email colors and emojis 5 wellness categories per digest — energy, nutrition, movement, mindset, what to expect Weekly affirmation generated per phase Full delivery logging to Send Log sheet Active subscriber filtering — easy to pause or deactivate users Requirements OpenAI API key (GPT-4o access) Google Sheets OAuth2 connection Gmail OAuth2 connection A configured Google Sheet with 2 sheets — Subscribers and Send Log Setup Steps Create a Google Sheet called "Period Health Tracker" with 2 sheets — Subscribers and Send Log Paste your Sheet ID into all Google Sheets nodes Connect your Google Sheets OAuth2 credentials Add your OpenAI API key to the GPT-4o node Connect your Gmail OAuth2 credentials Target Audience 🌸 Women's health and wellness platforms delivering cycle-aware content 💼 Femtech creators building automated health tracking without a custom app 🧘 Wellness coaches who want to deliver personalized cycle coaching at scale 🤖 Automation agencies building health and wellness products for women's communities