by Avkash Kakdiya
How it works This workflow runs on a daily schedule to analyze all active HubSpot deals and their latest engagement activity. It applies AI-driven behavioral scoring to predict conversion probability and deal health. High-risk or stalled deals automatically trigger Slack alerts. All insights are logged in Google Sheets for forecasting and performance tracking. Step-by-step Step 1 – Trigger and collect active deals** Schedule Trigger – Runs the workflow automatically at a fixed time each day. Get Active Deals from HubSpot – Retrieves all non-closed deals with key properties like value, stage, and activity dates. Formatting Data – Cleans and normalizes deal data while calculating metrics such as deal age and inactivity duration. Step 2 – Enrich deals with engagement data** If – Filters only active deals to ensure closed deals are excluded. Loop Over Items – Processes each deal individually to handle enrichment safely. HTTP Request – Fetches engagement associations linked to each deal. Get an engagement – Retrieves detailed engagement records from HubSpot. Extracts Data – Structures engagement content, timestamps, and internal notes for AI analysis. Step 3 – Analyze risk and notify the team** AI Agent – Analyzes behavioral signals and predicts conversion probability, risk level, and next actions. Format Data – Parses the AI output into structured fields and risk indicators. Filter Alerts Needed – Identifies deals that require immediate attention. Send Slack Alert – Sends a detailed alert with risks, signals, and recommended actions. Append or update row in sheet – Stores analysis results in Google Sheets for tracking and forecasting. Why use this? Detect deal risk early using consistent, AI-based analysis Reduce manual pipeline reviews for sales managers Provide clear, actionable next steps to sales reps Keep a historical log of deal health and forecasts Improve close rates through timely, data-driven intervention
by Rahul Joshi
📊 Description Monitor daily brand visibility and reputation with an automated AI-powered mention tracker. 🔍🤖 This workflow checks Hacker News every morning for new stories matching your brand keyword, classifies each mention’s sentiment and urgency using GPT-4o-mini, and delivers a clean daily summary to Slack. If no mentions are found, the workflow sends a simple “no mentions today” update instead—ensuring your team is always informed without manual monitoring. Perfect for reputation tracking, competitive intelligence, and early warning alerts. 📈💬 🔁 What This Template Does 1️⃣ Triggers every morning at 09:00 to begin the analysis. ⏰ 2️⃣ Loads brand name + keyword filters from configuration. 🏷️ 3️⃣ Fetches relevant mentions from Hacker News using the Algolia API. 🌐 4️⃣ Normalizes raw API data into clean fields (title, URL, snippet, author, points). 📄 5️⃣ Classifies each mention’s sentiment, stance, topic, and urgency using GPT-4o-mini. 🤖 6️⃣ Builds a ranked daily summary including top 10 mentions and sentiment totals. 📊 7️⃣ Sends the report to Slack, formatted cleanly and ready for team consumption. 💬 8️⃣ If no mentions exist, sends a simple “no new mentions today” message. 🚫 9️⃣ Includes an error handler that notifies Slack of any workflow failures. ⚠️ ⭐ Key Benefits ✅ Automatically tracks brand presence without manual searching ✅ AI-powered sentiment & urgency analysis for deeper insights ✅ Clean Slack summaries keep teams aligned and aware ✅ Early detection of negative or high-urgency mentions ✅ Zero manual monitoring — runs fully on schedule ✅ Suitable for brand monitoring, PR, marketing, and leadership teams 🧩 Features Daily schedule trigger Hacker News API (Algolia) integration Structured data normalization GPT-4o-mini classification (sentiment, stance, topic, urgency) Slack notifications (detailed report or no-mention message) Error-handling pipeline with Slack alerts Fully configurable brand keywords 🔐 Requirements Slack API credentials OpenAI API key (GPT-4o-mini) No authentication required for Hacker News API n8n with LangChain nodes enabled 🎯 Target Audience Brand monitoring & PR teams AI companies tracking public sentiment Founders monitoring mentions of their product Marketing teams watching trends & community feedback
by Rahul Joshi
📊 Description Simplify your social media publishing process by automating post scheduling from Google Sheets directly to Meta (Facebook Pages). 📅💬 This workflow detects pending posts, uploads images with captions to your Facebook Page, updates the sheet status, and sends real-time notifications via Slack and email — keeping your marketing team always in sync. 🚀 What This Template Does 1️⃣ Trigger – Monitors a Google Sheet for new or pending posts every minute. ⏰ 2️⃣ Filter – Identifies the latest “pending” entry for publishing. 🔍 3️⃣ Extract – Captures post details like caption, image URL, and ID. 🧾 4️⃣ Publish – Uploads the post to your Meta (Facebook) Page using the Graph API. 📤 5️⃣ Validate – Confirms success or failure of the post operation. ✅ 6️⃣ Notify – Sends instant Slack and email updates on publishing status. 💌 7️⃣ Update – Marks the published post as “Completed” in Google Sheets. 📊 Key Benefits ✅ Hands-free publishing from Google Sheets to Meta ✅ Instant Slack and email alerts for post outcomes ✅ Prevents duplicate or failed post uploads ✅ Centralized content tracking and status updates ✅ Improves consistency and speed in social media operations Features Google Sheets trigger for post scheduling Facebook Graph API integration for auto-posting Slack and Outlook notifications for success/error alerts Automatic sheet updates post-publication Error handling and reporting for failed posts Requirements Google Sheets OAuth2 credentials Facebook Page Access Token via Graph API Slack Bot token for notifications Outlook or SMTP credentials for email updates Target Audience Marketing teams managing Facebook content calendars 📆 Social media managers seeking automated posting 📣 Agencies coordinating client content delivery 📋 Teams tracking campaign publishing performance 📊
by Fahmi Fahreza
Create Airtable records from new ClickUp Doc pages This workflow automates the process of turning content from ClickUp Docs into structured data in Airtable. When a new task is created in ClickUp with a link to a ClickUp Doc in its name, this workflow triggers, fetches the entire content of that Doc, parses it into individual records, and then creates a new record for each item in a specified Airtable base and table. Who's it for This template is perfect for content creators, project managers, and operations teams who use ClickUp Docs for drafting or knowledge management and Airtable for tracking and organizing data. It helps bridge the gap between unstructured text and a structured database. How it works Trigger: The workflow starts when a new task is created in a specific ClickUp Team. Fetch & Parse URL: It gets the new task's details and extracts the ClickUp Doc URL from the task name. Get Doc Content: It uses the URL to fetch the main Doc and all its sub-pages from the ClickUp API. Process Content: A Code node parses the text from each page. It's designed to split content by * * * and separate notes by looking for the "notes:" keyword. Find Airtable Destination: The workflow finds the correct Airtable Base and Table IDs by matching the names you provide. Create Records: It loops through each parsed content piece and creates a new record in your specified Airtable table. How to set up Configure the Set Node: Open the "Configure Variables" node and set the following values: clickupTeamId: Your ClickUp Team ID. Find it in your ClickUp URL (e.g., app.clickup.com/9014329600/...). airtableBaseName: The exact name of your target Airtable Base. airtableTableName: The exact name of your target Airtable Table. airtableVerticalsTableName: The name of the table in your base that holds "Vertical" records, which are linked in the main table. Set Up Credentials: Add your ClickUp (OAuth2) and Airtable (Personal Access Token) credentials to the respective nodes. Airtable Fields: Ensure your Airtable table has fields corresponding to the ones in the Create New Record in Airtable node (e.g., Text, Status, Vertical, Notes). You can customize the mapping in this node. Activate Workflow: Save and activate the workflow. Test: Create a new task in your designated ClickUp team. In the task name, include the full URL of the ClickUp Doc you want to process. How to customize the workflow Parsing Logic:* You can change how the content is parsed by modifying the JavaScript in the Parse Content from Doc Pages Code node. For example, you could change the delimiter from * * to something else. Field Mapping:** Adjust the Create New Record in Airtable node to map data to different fields or add more fields from the source data. Trigger Events:** Modify the Trigger on New ClickUp Task node to respond to different events, such as taskUpdated or taskCommentPosted.
by Oneclick AI Squad
This automated n8n workflow monitors real-time cryptocurrency prices using CoinGecko API and sends smart alerts when price conditions are met. It supports multi-coin tracking, dynamic conditions, and instant notifications via Email, Telegram, and Discord. Good to Know Reads crypto watchlist data from Google Sheets. Monitors prices at defined intervals (24/7 monitoring). Handles upper and lower price limits with direction-based alerts (above, below, both). Implements cooldown logic to avoid duplicate alerts. Updates last alert price and timestamp in Google Sheets. Supports multiple alert channels: Email, Telegram, Discord. Uses CoinGecko API for price data (Free tier supported). How It Works 24/7 Crypto Trigger – Runs every minute (or custom interval) to check latest prices. Read Crypto Watchlist – Fetches symbols and conditions from Google Sheets. Parse Crypto Data – Converts Google Sheet data into structured JSON. Fetch Live Crypto Price – Uses CoinGecko API to get latest market price for each coin. Smart Crypto Alert Logic – Compares live price with upper/lower limits and evaluates conditions: Above – Trigger alert if price > upper\_limit. Below – Trigger alert if price < lower\_limit. Both – Trigger alert if either condition is met. Implements cooldown\_minutes to prevent repeated alerts. Check Crypto Alert Conditions – Validates alerts before sending notifications. Send Crypto Email Alert – Sends email alert if condition is true. Send Telegram Crypto Alert – Sends Telegram alert. Send Discord Crypto Alert – Sends Discord alert. Update Crypto Alert History – Updates last_alert_price and last_alert_time in Google Sheet. Crypto Alert Status Check – Ensures alert process completed successfully. Success Notification – Sends confirmation message on success. Error Notification – Sends an error alert if something fails. Google Sheet Columns (A-G) | Column | Description | | ------ | ---------------------------------- | | A | symbol (BTC, ETH, SOL, etc.) | | B | upper_limit (e.g., 45000) | | C | lower_limit (e.g., 40000) | | D | direction (both / above / below) | | E | cooldown_minutes (e.g., 10) | | F | last_alert_price (auto-updated) | | G | last_alert_time (auto-updated) | How to Use Import the workflow into n8n. Configure Google Sheets credentials and link your watchlist sheet. Add your CoinGecko API endpoint in the Fetch Price node (Free tier). Set up Email, Telegram, and Discord credentials for notifications. Test with sample data: Example: BTC, upper\_limit=45000, lower\_limit=40000, direction=both. Execute the workflow and monitor alerts. Requirements n8n environment with execution permissions. Google Sheets integration (with API credentials). CoinGecko API (Free tier supported). Notification channels: Email (SMTP settings in n8n). Telegram Bot Token. Discord Webhook URL. Customizing This Workflow Add more coins in Google Sheet. Modify alert conditions (e.g., percentage change, moving averages). Add SMS or WhatsApp notifications. Integrate with Slack or Microsoft Teams. Use AI-based price predictions for smarter alerts.
by n8n Automation Expert | Template Creator | 2+ Years Experience
🎯 Smart Job Hunter Pro - AI-Powered Multi-Platform Job Automation Transform your job search with this comprehensive n8n workflow that automatically searches, analyzes, and applies to relevant positions across multiple job platforms. Perfect for developers, engineers, and tech professionals looking to streamline their job hunting process. ✨ Key Features 🔄 Multi-Platform Job Search**: Simultaneously searches Jooble, JobStreet, Indeed, and WhatJobs APIs 🤖 AI-Powered Job Analysis**: Uses Google Gemini AI to analyze job compatibility and generate tailored cover letters 📊 Smart Scoring System**: Automatically scores job matches based on your skills and requirements 📝 Auto-Apply Threshold**: Only applies to jobs above your specified compatibility score 📋 Notion Integration**: Automatically tracks applications in organized Notion database 💬 Telegram Notifications**: Real-time alerts for high-match job opportunities ☁️ Google Drive Storage**: Saves personalized cover letters for each application ⚠️ Error Handling**: Comprehensive error tracking with Telegram notifications ⏰ Automated Scheduling**: Runs every 8 hours to find fresh opportunities 🛠 What This Workflow Does Scheduled Search: Automatically searches multiple job platforms every 8 hours Data Normalization: Standardizes job data from different API sources AI Analysis: Gemini AI evaluates each job posting against your skills profile Smart Filtering: Only processes jobs above your compatibility threshold (default: 75%) Application Tracking: Creates detailed records in Notion with match scores and status Instant Alerts: Sends Telegram notifications for promising opportunities Cover Letter Generation: AI creates personalized cover letters for each position Document Management: Automatically saves all cover letters to Google Drive 🔧 Required Integrations Job APIs**: Jooble API, WhatJobs API (JobStreet & Indeed use web scraping) AI Service**: Google Gemini API for job analysis Productivity**: Notion database for application tracking Communication**: Telegram bot for notifications Storage**: Google Drive for cover letter management 💡 Perfect For Software Developers** seeking JavaScript, React, Node.js positions Full-Stack Engineers** wanting automated job discovery Tech Professionals** needing organized application tracking Remote Workers** searching across multiple platforms Career Changers** looking for systematic job hunting 🎛 Customizable Variables Job Keywords**: Define your target roles and skills Location & Radius**: Set geographic search parameters Auto-Apply Threshold**: Control compatibility score requirements Results Limit**: Adjust number of jobs per platform Schedule Frequency**: Modify search intervals 📈 Benefits Save 10+ hours weekly** on manual job searching Never miss opportunities** with automated monitoring Professional application tracking** with detailed analytics Personalized cover letters** for every application Instant notifications** for high-match positions Complete audit trail** of all job search activities 🚀 Getting Started Import the workflow to your n8n instance Configure API credentials for all job platforms Set up Notion database with provided template structure Create Telegram bot and Google Drive folder Customize job search parameters for your profile Activate workflow and start receiving opportunities! 📝 Additional Notes Uses placeholder credentials for security ({{PLACEHOLDER_API_KEY}}) Comprehensive error handling prevents workflow failures Includes detailed setup instructions via sticky notes Optimized for Indonesian job market (JobStreet.co.id) Easily adaptable for other regions and job types Perfect for developers, engineers, and automation enthusiasts who want to leverage AI and n8n's power to dominate their job search process! 🚀
by Cheng Siong Chin
How It Works This workflow automates engineering governance by deploying a multi-agent AI system that validates designs, checks compliance, optimises safety, and predicts maintenance needs. Designed for engineering teams, quality assurance officers, and operations managers in regulated industries, it eliminates manual review bottlenecks and ensures systemic risk issues are escalated promptly. A schedule trigger fetches design specifications and operational data, merges them, then routes to three parallel agent tracks: Design Validation (with Compliance Verification, Resource Coordination, and Testing Validation sub-agents), Safety Optimisation, and Predictive Maintenance. All outputs consolidate into a risk score calculator, which routes by risk level—critical and high issues trigger Slack alerts immediately, while medium and low issues are logged for review. Setup Steps Set schedule trigger interval to match governance review frequency. Add Anthropic API credentials to all Anthropic Model nodes. Connect design specification and operational data sources to fetch nodes. Configure Slack credentials for critical and high-priority alert channels. Define risk scoring thresholds in the Calculate Risk Scores node. Prerequisites Slack workspace with bot token Design and operational data sources (API or database) Use Cases Automated design compliance auditing for aerospace or manufacturing Real-time safety risk detection in industrial operations Customization Add sub-agents for environmental, cost, or regulatory compliance Benefits Automates multi-dimensional engineering governance on a schedule
by Cahya
This workflow helps you monitor domain expiration dates and send automated reminders via Telegram when a domain is about to expire or has already expired, using WHOIS data and AI-powered information extracting. It helps prevent service downtime, lost traffic, and missed renewals for individuals and teams managing multiple domains. Common use cases: Track and remind on agency-managed client domains Monitor personal or business domain portfolios Send automated expiry alerts for IT and DevOps teams How it works Runs daily at 08:00 AM Reads domain data from Google Sheets Fetches WHOIS information from whois.com for each domain Extracts the data (expired date, domain owner, status domain) using AI Sends a Telegram reminder if the domain expires within 90 days Records the notification date to avoid duplicate alerts Setup steps Add your Google Sheets ID and ensure the required columns exist Connect your Google Sheets credentials Connect your Telegram credentials Configure your LLM provider (Ollama or other) Activate the workflow Need Help? Contact me on LinkedIn!
by Shashwat Singh
This workflow automatically detects duplicate files uploaded to a specific Google Drive folder by generating an MD5 hash of each file and comparing it against a Supabase database. If a duplicate is found, the file is moved to a dedicated Duplicates folder and a Slack notification is sent. All events, including unique uploads, duplicates, race conditions, and errors, are logged for audit purposes. It is designed for teams that handle high file volumes and need reliable, content based deduplication instead of simple filename checks. How it works Monitors a specific Google Drive folder for new files. Normalizes file metadata and downloads the binary content. Generates an MD5 hash from the file binary. Checks Supabase to see if the hash already exists. If duplicate, moves the file to a Duplicates folder and sends a Slack alert. If unique, stores the hash in Supabase. Logs every outcome, including errors and race conditions, in an audit table. Setup steps Connect your Google Drive account and select the folder to monitor. Connect your Supabase account and create the required tables: file_hashes dedup_audit_log Connect your Slack account and select a channel for duplicate alerts. Update the Duplicates folder ID in the Google Drive Move node. Setup typically takes 10 to 15 minutes if your Supabase project is ready.
by Rahul Joshi
Description: Automate your developer onboarding quality checks with this n8n workflow template. Whenever a new onboarding task is created in ClickUp, the workflow logs it to Google Sheets, evaluates its completeness using Azure OpenAI GPT-4o-mini, and alerts your team in Slack if critical details are missing. Perfect for engineering managers, DevOps leads, and HR tech teams who want to maintain consistent onboarding quality and ensure every developer gets the tools, credentials, and environment setup they need — without manual review. ✅ What This Template Does (Step-by-Step) ⚡ Step 1: Auto-Trigger on ClickUp Task Creation Listens for new task creation events (taskCreated) in your ClickUp workspace to initiate the audit automatically. 📊 Step 2: Log Task Details to Google Sheets Records essential task data — task name, assignee, and description — creating a central audit trail for all onboarding activities. 🧠 Step 3: AI Completeness Analysis (GPT-4o-mini) Uses Azure OpenAI GPT-4o-mini to evaluate each onboarding task for completeness across key areas: Tooling requirements Credential setup Environment configuration Instruction clarity Outputs: ✅ Score (0–100) ⚠️ List of Missing Items 💡 Suggestions for Improvement 🚦 Step 4: Apply Quality Gate Checks whether the AI-generated completeness score is below 80. Incomplete tasks automatically move to the alert stage for review. 📢 Step 5: Alert Team via Slack Sends a structured Slack message summarizing the issue, including: Task name & assignee Completeness score Missing checklist items Recommended next actions This ensures your team fixes incomplete onboarding items before they impact new hires. 🧠 Key Features 🤖 AI-driven task completeness scoring 📊 Automatic task logging for audit visibility ⚙️ Smart quality gate (score threshold < 80) 📢 Instant Slack alerts for incomplete tasks 🔄 End-to-end automation from ClickUp to Slack 💼 Use Cases 🎓 Audit onboarding checklists for new developers 🧩 Standardize environment setup and credential handover 🚨 Identify missing steps before onboarding deadlines 📈 Maintain onboarding consistency across teams 📦 Required Integrations ClickUp API – to detect new onboarding tasks Google Sheets API – to store audit logs and history Azure OpenAI (GPT-4o-mini) – to evaluate completeness Slack API – to alert the team on incomplete entries 🎯 Why Use This Template? ✅ Ensures every new developer receives a full, ready-to-start setup ✅ Eliminates manual checklist verification ✅ Improves onboarding quality and compliance tracking ✅ Creates a transparent audit trail for continuous improvement
by Rahul Joshi
📘 Description This workflow automates end-to-end AI-driven inventory intelligence, transforming Airtable stock data into optimized reorder recommendations, daily operational summaries, and instant Slack alerts. It fetches all inventory rows, validates structure, computes reorder and safety-stock metrics using strict formulas, merges multi-batch AI output into a unified dataset, and distributes actionable insights across Email and Slack. Invalid or corrupted Airtable rows are logged to Google Sheets for audit and cleanup. The workflow ensures deterministic inventory math (zero improvisation), strict JSON compliance, and reliable multi-channel reporting for operations teams. ⚙️ What This Workflow Does (Step-by-Step) ▶️ Manual Trigger – Start Inventory Optimization Runs the full optimization and reporting pipeline on demand. 📦 Fetch Inventory Records from Airtable Retrieves all SKU records (ID, ItemName, SKU, quantities, reorder levels) from the Airtable Inventory table. 🔍 Validate Inventory Record Structure (IF) Ensures each record contains a valid id. Valid → routed to AI optimization Invalid → saved to Google Sheets. 📄 Log Invalid Inventory Rows to Google Sheet Captures malformed or incomplete Airtable items for audit checks and data hygiene. 🧠 Configure GPT-4o — Inventory Optimization Model Defines the AI model for stock-level calculations using strict formulas: SuggestedReorderPoint = ReorderLevel × 1.2 SuggestedSafetyStock = ReorderLevel × 0.5 StockStatus logic: Critical if QuantityInStock ≤ SuggestedSafetyStock Needs Reorder if QuantityInStock ≤ SuggestedReorderPoint OK otherwise 🤖 Generate Inventory Optimization Output (AI) The AI engine analyzes each SKU and returns: Suggested reorder point Suggested safety stock Updated stock status Clean structured JSON for each item All without markdown, hallucination, or additional logic. 🧩 Merge AI Optimization Results (Code) Consolidates all partial AI responses into one complete JSON dataset containing all SKUs. 🧠 Configure GPT-4o – Email Summary Model Prepares the AI model used for generating a professional operations-team email. 📧 Generate Inventory Email Summary (AI) Creates a manager-ready email including: High-level inventory health Detailed SKU summaries Alerts for low, reorder-level, or critical stock Recommended actions for today’s operations 📨 Email Inventory Summary to Manager (Gmail) Sends the completed inventory summary to the operations manager. 🧠 Configure GPT-4o – Slack Summary Model Sets up GPT-4o to produce a compact, emoji-supported Slack summary. 💬 Generate Inventory Slack Summary (AI) Builds a Slack-optimized message containing: One-line inventory health Bullet list of SKUs with stock status Clear alerts for reorder-level or critical items One recommended action line 📡 Notify Operations Team on Slack Delivers the optimized Slack summary to the operations Slack user/channel for real-time visibility. 🧩 Prerequisites Airtable access token Azure OpenAI GPT-4o credentials Google Sheets OAuth Slack API credentials Gmail OAuth 💡 Key Benefits ✔ AI-powered stock calculations with strict formulas ✔ Reliable reorder and safety-stock predictions ✔ Instant multi-channel reporting (Email + Slack) ✔ Full audit logging for invalid data ✔ Zero hallucinations—pure structured JSON ✔ Faster decision-making for operations teams 👥 Perfect For Operations & supply-chain teams Inventory managers Retail & e-commerce units Businesses using Airtable for stock tracking
by Vivekanand M
Upwork Proposal Automation with AI, Airtable and Slack 📘 Description This workflow automates the complete Upwork job discovery and proposal generation process by continuously monitoring job listings, intelligently filtering opportunities based on your skill set, generating personalised AI-written proposals, and delivering instant notifications — all without any manual effort. The workflow is triggered automatically every minute via Vollna's RSS feed, which monitors Upwork job postings matching your configured search filters. Each new job listing is parsed and analysed to extract key details, including title, description, budget, required skills, and job ID. A skills matching engine scores each job against your defined skill set and filters out weak matches. Duplicate jobs are automatically detected and skipped using Airtable as a reference store, ensuring AI credits are never wasted on already-processed listings. For every qualified new job, GPT-4o-mini generates a tailored 150–250-word proposal that references specific details from the job post, aligns your experience to the client's exact requirements, and ends with a clear call to action. The proposal and all job metadata are saved to an Airtable base for review. A formatted Slack notification is sent instantly with the full job details and generated proposal, allowing you to review, edit, and apply directly from Upwork with a single click. ⚙️ What This Workflow Does (Step-by-Step) 📡 RSS Feed Monitoring — Polls Vollna's Upwork RSS feed every minute for new job listings matching your skill keywords. Vollna replaces Upwork's discontinued native RSS feed (removed August 2024) and supports 30+ filter parameters, including category, budget, and client history. 🔍 Parse & Extract — Extracts structured fields from each RSS item, including job title, full description, budget, required skills, posted date, job ID, and clean Upwork job URL (decoded from Vollna's redirect format). 🎯 Filter: Skills Match — Scores each job against your defined skill list. Jobs scoring fewer than 2 matched skills are dropped immediately, ensuring only relevant opportunities proceed. ⭐ Filter: Client Quality — Filters out clients with ratings below 4.5. New clients with no rating history are allowed through by default. 🔁 Duplicate Detection — Queries Airtable to check if the job ID has already been processed in a previous run. Duplicate jobs are silently skipped without generating a proposal. 🤖 AI Proposal Generation — Calls GPT-4o-mini with a structured prompt containing the job details and your freelancer profile. Generates a concise, personalised proposal that opens with a specific reference to the job post, highlights relevant experience with real numbers, proposes a concrete first step, and ends with a soft call to action. 💾 Save to Airtable — Creates a new record in your Airtable base with all job fields, matched skills, match score, generated proposal, and status set to "New" for review tracking. 💬 Slack Notification — Sends a formatted message to your Slack channel with the job title, budget, match score, matched skills, required skills, direct Upwork job link, and the full AI-generated proposal — ready to copy and submit. 🧩 Prerequisites Vollna account** — Free tier available at vollna.com. Create a job filter matching your skills and copy the RSS feed URL from the Filters section OpenAI API key** — Used for GPT-4o-mini proposal generation (~$0.007 per proposal) Airtable account** — Free tier supports up to 1,000 records. Create a base with the schema below Slack workspace** — Bot token with chat:write permission, invited to your target channel 🗄️ Airtable Base Schema Create a table called Upwork Proposals with these fields: | Field Name | Type | |---|---| | Job Title | Single line text | | Job URL | URL | | Upwork URL | URL | | Posted At | Date | | Budget | Single line text | | Skills Required | Long text | | Matched Skills | Long text | | Match Score | Number | | AI Proposal | Long text | | Status | Single select: New, Reviewed, Applied, Skipped | | Job ID | Single line text | | Notes | Long text | 💰 Cost Estimate | Item | Estimated Cost | |---|---| | Vollna (free tier) | $0/mo | | GPT-4o-mini (50 proposals/day) | $1–3/mo | | Airtable (free tier) | $0/mo | | n8n self-hosted (AWS t3.small) | ~$10–15/mo | | Total | ~$11–18/mo | ⚙️ Setup Instructions Vollna — Sign up at vollna.com, create a job filter with your target keywords and skill categories, then copy the RSS feed URL from the Filters section Airtable — Create a new base and table using the schema above. Copy your Base ID from the Airtable URL and connect your Personal Access Token in n8n credentials OpenAI — Add your OpenAI API key as an n8n credential (HTTP Header Auth with Authorisation: Bearer sk-...) Slack — Create a Slack app, add chat:write scope, install to your workspace, invite the bot to your channel with /invite @your-bot-name Customise the AI prompt — Open the Build OpenAI Payload node and update the MY PROFILE section with your actual name, skills, and experience details Update skill filters — In the Filter: Skills Match node, update the YOUR_SKILLS array to match your exact skill set Publish the workflow — Click Publish. The RSS trigger will begin polling Vollna every minute automatically 💡 Key Benefits ✔ Fully automated job discovery — no manual searching required ✔ Skills-based filtering ensures AI only runs on relevant jobs ✔ Personalised proposals referencing specific job details — not generic templates ✔ Airtable CRM for tracking proposal status and conversion rates ✔ Instant Slack alerts with one-click access to apply on Upwork ✔ Deduplication prevents reprocessing the same job across runs ✔ Modular design — swap OpenAI for Claude or AWS Bedrock with minimal changes ✔ Cost-optimised — GPT-4o-mini keeps proposal generation under $3/month at scale 👥 Perfect For Freelancers on Upwork wanting to automate proposal writing Agencies managing multiple freelancer profiles Developers and automation specialists looking to win more technical contracts Anyone spending more than 30 minutes per day manually browsing and applying to Upwork jobs