Automate job discovery & AI proposals across Upwork, Freelancer, Guru & PPH with OpenRouter

169 views

2/3/2026

Slack Merge Request GitLab Notifications Webhooks

Upwork/Freelancer/Guru/PPH Job Automation + AI Proposal Generator

Overview

This comprehensive n8n workflow automates freelance job discovery and application processes across four major platforms: Upwork.com, Freelancer.com, PeoplePerHour.com, and Guru.com. The system monitors RSS feeds, extracts job details, generates personalized AI proposals, and tracks everything in Google Sheets with email notifications.

Supported Platforms

Complete Market Coverage

Upwork.com

World's largest freelance marketplace
High-value projects and enterprise clients
Competitive bidding environment requiring fast responses

Freelancer.com

Global platform with diverse project types
International client base across all industries
Contest and fixed-price project opportunities

PeoplePerHour.com

UK-focused professional services platform
Hourly and project-based work
Business and creative services emphasis

Guru.com

Premium freelance marketplace for skilled professionals
Work room collaboration features
Recurring client relationship focus

Use Cases

Primary Use Cases

Multi-Platform Lead Generation

Monitor Upwork, Freelancer, PeoplePerHour, and Guru simultaneously
Receive instant notifications for relevant opportunities across all platforms
Never miss time-sensitive job postings from any major marketplace

Cross-Platform Proposal Automation

Generate platform-specific, personalized proposals using AI
Adapt proposal style to each platform's requirements and culture
Maintain consistent quality across all applications and platforms

Comprehensive Opportunity Tracking

Automatically log jobs from all four platforms in Google Sheets
Track application status and platform performance

Competitive Market Advantage

Respond to jobs within minutes across multiple platforms
Maintain 24/7 monitoring without manual intervention
Access broader market opportunities while competitors focus on single platforms

Industry Applications

Digital Marketing Agencies

Monitor automation projects across Upwork and Freelancer
Track competitor applications on multiple platforms
Access European clients through PeoplePerHour and international through Guru

Software Development Teams

Find API integration projects on Upwork and technical contests on Freelancer
Monitor PeoplePerHour for UK-based development work
Track long-term client relationships on Guru

Virtual Assistant Services

Discover automation opportunities across all four platforms
Monitor recurring service requests and business support roles
Scale operations by accessing different market segments

Consulting Practices

Track business automation requests on premium platforms like Guru
Monitor transformation projects across international markets
Access diverse client bases from startup (Freelancer) to enterprise (Upwork)

Technical Features

Multi-Platform RSS Monitoring

Configurable polling intervals (default: 5 minutes)
Processes Vollna API feeds for Upwork, Freelancer, PeoplePerHour, and Guru
Handles various platform-specific job feed formats automatically

Intelligent Data Extraction

Parses job titles to extract budget information across different platform formats
Supports multiple pricing formats (fixed, hourly, ranges) from all platforms
Cleans and structures job data with platform-specific considerations

Advanced URL Processing

Decodes nested URLs from feed redirects
Automatically identifies source platforms (Upwork, Freelancer, PeoplePerHour, Guru)
Validates and formats final job URLs for direct platform access

AI Integration with Platform Awareness

Uses OpenRouter for AI model access with platform-specific contexts
Implements advanced prompt engineering for different platform cultures
Generates contextual, personalized proposals adapted to each platform

Multi-Platform Support

Gmail integration for notifications
Google Sheets for data storage
HTML email formatting
Automated database updates

⚙️ Configuration Options

Filtering System

ASCII text filtering for English content
Custom budget range filtering
Platform-specific filtering rules
Keyword-based job matching

AI Customization

Customizable proposal templates
Variable experience levels
Industry-specific positioning
Personal branding integration

Notification Preferences

HTML-formatted email alerts
Mobile-friendly email templates
Batch processing options
Error handling and retry logic

Benefits

🚀 Operational Efficiency

Time Savings

Eliminates manual job checking (save 2-3 hours daily)
Automates proposal writing process
Reduces administrative overhead

Response Speed

5-minute job discovery cycle
Instant proposal generation
Competitive response timing

Quality Consistency

Standardized proposal quality
Professional email formatting
Consistent brand presentation

📊 Business Intelligence

Market Analysis

Budget trend tracking
Platform performance comparison
Job volume analytics
Competitive landscape insights

Performance Tracking

Application success rates
Response time analysis
Platform-specific metrics
ROI measurement capabilities

🔄 Scalability Features

Multi-User Support

Team-based implementations
Role-specific customizations
Shared resource management

Integration Ready

CRM system compatibility
Project management tool integration
Calendar synchronization options
API extension capabilities

Requirements

🛠️ Technical Prerequisites

n8n Setup

n8n Cloud or self-hosted instance
Webhook capabilities enabled
Cron trigger support

External Services

Gmail account with API access
Google Sheets API credentials
OpenRouter API key
Vollna account for RSS feeds

Optional Enhancements

Custom domain for webhooks
SSL certificates for secure connections
Database storage for advanced analytics

Installation & Setup

Need Help?

Reach me: https://www.linkedin.com/in/gerald-akhidenor-1ab1a45/

Work with me: https://dominixai.com/

My website: https://jobmonkey.dev

My email: denorgerald@gmail.com

📘 Beginner Setup Guide

Workflow: Upwork Job Application Automation with Vollna API

This workflow automates the process of:

Reading new jobs from a Vollna RSS feed,
Extracting job title, budget, and source,
Using AI to generate a tailored proposal,
Sending the proposal to your email, and
Saving job details into a Google Sheet.

1. 📥 Import the Workflow

Open your n8n dashboard.
Click Import in the top-right.
Upload the file: Upwork Job Application Automation with Vollna API Updated.json.

2. 🔑 Set Up Required Credentials

Before the workflow can run, connect your accounts.

Gmail Credentials
- Go to Credentials in n8n.
- Create a new credential: Gmail OAuth2 API.
- Follow the login prompt and grant access.
- Save it, then select it in the Send a Message node.
Google Sheets Credentials
- Create a credential for Google Sheets OAuth2 API.
- Connect it to your Google account.
- Save it, then select it in the Update Database node.
OpenRouter / AI API Key
- Sign up at openrouter.ai.
- Copy your API key.
- In n8n, create a credential for OpenRouter API.
- Select it in the OpenRouter Chat Model node.

3. ⚙️ Configure the RSS Feed

Open the RSS Feed Trigger node.
Replace https://www.vollna.com/rss/insertyourlinkhere with your personal Vollna RSS feed URL.
- You can get this from your Vollna account (filtering for Upwork jobs).

4. 🌀 Understand the Loop

This workflow uses Loop Over Items to process multiple jobs one by one.

Loop branch (Output 1) → Processes each job (Extract, Decode, AI Proposal, Save to DB).
Done branch (Output 2) → Would normally run once all jobs are processed. (Here, it’s not used — instead, the loop cycles back until no jobs are left.)

So the workflow ensures every job from RSS is handled.

5. 📧 Email Setup

The Send a Message node will send proposals to your email.

Default recipient: denorgerald@gmail.com.
Change this in the Send a Message → Send To field to your own email.

6. 📊 Google Sheets Setup

[Get Your Google Sheets Copy](Get your Google Sheets copy)

The Update Database node writes job data to your Google Sheet.

It’s already linked to this sheet: Upwork Jobs Automation → upwork_jobs
Replace with your own Google Sheet ID if you want.
- Copy your sheet’s URL, e.g.:
```
https://docs.google.com/spreadsheets/d/&lt;YOUR_SHEET_ID&gt;/edit#gid=0
```
- Paste <YOUR_SHEET_ID> into the Document ID.
- Update Sheet Name if needed (default is upwork_jobs).

7. ▶️ Test the Workflow

Click Execute Workflow.
The RSS Trigger will fetch jobs.
You should see each job processed step by step:
- Title & Budget extracted
- URL decoded
- Proposal generated by AI
- Email sent
- Row added to Google Sheet

8. 🔄 Activate Automation

When satisfied, toggle the workflow to Active.
It will check the RSS feed every 5 minutes (you can adjust this in the RSS Trigger).

Your Upwork Job Application Automation is now ready to help you discover and apply to more opportunities automatically. Remember to monitor the system regularly and adjust settings based on your results.

Happy freelancing! 🚀🚀

n8n Workflow: Automated Job Discovery & AI Proposal Generation

This n8n workflow automates the process of discovering new job postings from various freelancing platforms (Upwork, Freelancer, Guru, PPH) and generating tailored AI-powered proposals using OpenRouter. It aims to streamline the job application process for freelancers by providing a continuous stream of relevant opportunities and pre-drafted, intelligent responses.

What it does

This workflow performs the following key steps:

Monitors RSS Feeds: It continuously checks multiple RSS feeds for new job postings from specified freelancing platforms.
Filters New Jobs: It processes the incoming job data, potentially removing duplicates or irrelevant entries.
Extracts Job Details: For each new job, it extracts essential information such as title, description, and other relevant details from the HTML content.
Generates AI Proposal: It uses an AI Agent powered by OpenRouter to generate a customized proposal based on the job description.
Stores Job & Proposal Data: The original job details and the generated AI proposal are appended to a Google Sheet for tracking and review.
Sends Email Notification: An email containing the job details and the AI-generated proposal is sent via Gmail, likely to the freelancer for review and submission.
Manages Rate Limiting: Includes a Wait node to prevent overwhelming APIs and ensure smooth operation.

Prerequisites/Requirements

To use this workflow, you will need:

n8n Instance: A running n8n instance.
Google Sheets Account: Configured credentials for Google Sheets to store job data.
Gmail Account: Configured credentials for Gmail to send email notifications.
OpenRouter API Key: An API key for the OpenRouter service to power the AI Agent.
RSS Feed URLs: The specific RSS feed URLs for the freelancing platforms you wish to monitor.

Setup/Usage

Import the Workflow: Import the provided JSON into your n8n instance.
Configure Credentials:
- Set up your Google Sheets credentials.
- Set up your Gmail credentials.
- Configure your OpenRouter Chat Model node with your OpenRouter API key.
Update RSS Feeds: In the "RSS Feed Trigger" node, replace the placeholder URLs with the actual RSS feed URLs for the job boards you want to monitor.
Customize AI Agent: Adjust the prompt and configuration of the "AI Agent" node to tailor the proposal generation to your specific skills and preferences.
Review Google Sheet: Ensure your Google Sheet is set up with appropriate columns to receive the job data and AI proposals.
Activate the Workflow: Once all configurations are complete, activate the workflow.

The workflow will now automatically monitor for new job postings, generate proposals, and notify you via email.

Related Templates

Document RAG & chat agent: Google Drive to Qdrant with Mistral OCR

Knowledge RAG & AI Chat Agent: Google Drive to Qdrant Description This workflow transforms a Google Drive folder into an intelligent, searchable knowledge base and provides a chat agent to query it. It’s composed of two distinct flows: An ingestion pipeline to process documents. A live chat agent that uses RAG (Retrieval-Augmented Generation) and optional web search to answer user questions. This system fully automates the creation of a “Chat with your docs” solution and enhances it with external web-searching capabilities. --- Quick Implementation Steps Import the workflow JSON into your n8n instance. Set up credentials for Google Drive, Mistral AI, OpenAI, and Qdrant. Open the Web Search node and add your Tavily AI API key to the Authorization header. In the Google Drive (List Files) node, set the Folder ID you want to ingest. Run the workflow manually once to populate your Qdrant database (Flow 1). Activate the workflow to enable the chat trigger (Flow 2). Copy the public webhook URL from the When chat message received node and open it in a new tab to start chatting. --- What It Does The workflow is divided into two primary functions: Knowledge Base Ingestion (Manual Trigger) This flow populates your vector database. Scans Google Drive: Lists all files from a specified folder. Processes Files Individually: Downloads each file. Extracts Text via OCR: Uses Mistral AI OCR API for text extraction from PDFs, images, etc. Generates Smart Metadata: A Mistral LLM assigns metadata like documenttype, project, and assignedto. Chunks & Embeds: Text is cleaned, chunked, and embedded via OpenAI’s text-embedding-3-small model. Stores in Qdrant: Text chunks, embeddings, and metadata are stored in a Qdrant collection (docaiauto). AI Chat Agent (Chat Trigger) This flow powers the conversational interface. Handles User Queries: Triggered when a user sends a chat message. Internal RAG Retrieval: Searches Qdrant Vector Store first for answers. Web Search Fallback: If unavailable internally, the agent offers to perform a Tavily AI web search. Contextual Responses: Combines internal and external info for comprehensive answers. --- Who's It For Ideal for: Teams building internal AI knowledge bases from Google Drive. Developers creating AI-powered support, research, or onboarding bots. Organizations implementing RAG pipelines. Anyone making unstructured Google Drive documents searchable via chat. --- Requirements n8n instance (self-hosted or cloud). Google Drive Credentials (to list and download files). Mistral AI API Key (for OCR & metadata extraction). OpenAI API Key (for embeddings and chat LLM). Qdrant instance (cloud or self-hosted). Tavily AI API Key (for web search). --- How It Works The workflow runs two independent flows in parallel: Flow 1: Ingestion Pipeline (Manual Trigger) List Files: Fetch files from Google Drive using the Folder ID. Loop & Download: Each file is processed one by one. OCR Processing: Upload file to Mistral Retrieve signed URL Extract text using Mistral DOC OCR Metadata Extraction: Analyze text using a Mistral LLM. Text Cleaning & Chunking: Split into 1000-character chunks. Embeddings Creation: Use OpenAI embeddings. Vector Insertion: Push chunks + metadata into Qdrant. Flow 2: AI Chat Agent (Chat Trigger) Chat Trigger: Starts when a chat message is received. AI Agent: Uses OpenAI + Simple Memory to process context. RAG Retrieval: Queries Qdrant for related data. Decision Logic: Found → Form answer. Not found → Ask if user wants web search. Web Search: Performs Tavily web lookup. Final Response: Synthesizes internal + external info. --- How To Set Up Import the Workflow Upload the provided JSON into your n8n instance. Configure Credentials Create and assign: Google Drive → Google Drive nodes Mistral AI → Upload, Signed URL, DOC OCR, Cloud Chat Model OpenAI → Embeddings + Chat Model nodes Qdrant → Vector Store nodes Add Tavily API Key Open Web Search node → Parameters → Headers Add your key under Authorization (e.g., tvly-xxxx). Node Configuration Google Drive (List Files): Set Folder ID. Qdrant Nodes: Ensure same collection name (docaiauto). Run Ingestion (Flow 1) Click Test workflow to populate Qdrant with your Drive documents. Activate Chat (Flow 2) Toggle the workflow ON to enable real-time chat. Test Open the webhook URL and start chatting! --- How To Customize Change LLMs: Swap models in OpenAI or Mistral nodes (e.g., GPT-4o, Claude 3). Modify Prompts: Edit the system message in ai chat agent to alter tone or logic. Chunking Strategy: Adjust chunkSize and chunkOverlap in the Code node. Different Sources: Replace Google Drive with AWS S3, Local Folder, etc. Automate Updates: Add a Cron node for scheduled ingestion. Validation: Add post-processing steps after metadata extraction. Expand Tools: Add more functional nodes like Google Calendar or Calculator. --- Use Case Examples Internal HR Bot: Answer HR-related queries from stored policy docs. Tech Support Assistant: Retrieve troubleshooting steps for products. Research Assistant: Summarize and compare market reports. Project Management Bot: Query document ownership or project status. --- Troubleshooting Guide | Issue | Possible Solution | |------------|------------------------| | Chat agent doesn’t respond | Check OpenAI API key and model availability (e.g., gpt-4.1-mini). | | Known documents not found | Ensure ingestion flow ran and both Qdrant nodes use same collection name. | | OCR node fails | Verify Mistral API key and input file integrity. | | Web search not triggered | Re-check Tavily API key in Web Search node headers. | | Incorrect metadata | Tune Information Extractor prompt or use a stronger Mistral model. | --- Need Help or More Workflows? Want to customize this workflow for your business or integrate it with your existing tools? Our team at Digital Biz Tech can tailor it precisely to your use case from automation logic to AI-powered enhancements. We can help you set it up for free — from connecting credentials to deploying it live. Contact: shilpa.raju@digitalbiz.tech Website: https://www.digitalbiz.tech LinkedIn: https://www.linkedin.com/company/digital-biz-tech/ You can also DM us on LinkedIn for any help. ---

By DIGITAL BIZ TECH

1409

Newsletter signup flow with Email Verification API, Gmail & Google Sheets tracking

Newsletter Sign-up with Email Verification & Welcome Email Automation 📋 Description A complete, production-ready newsletter automation workflow that validates email addresses, sends personalized welcome emails, and maintains comprehensive logs in Google Sheets. Perfect for marketing teams, content creators, and businesses looking to build high-quality email lists with minimal manual effort. ✨ Key Features Email Verification Real-time validation using Verifi Email API Checks email format (RFC compliance) Verifies domain existence and MX records Detects disposable/temporary email addresses Identifies potential spoofed emails Automated Welcome Emails Personalized HTML emails with subscriber's first name Beautiful, mobile-responsive design with gradient headers Branded confirmation and unsubscribe links Sent via Gmail (or SMTP) automatically to valid subscribers Smart Data Handling Comprehensive logging to Google Sheets with three separate tabs Handles incomplete submissions gracefully Preserves original user data throughout verification process Tracks source attribution for multi-channel campaigns Error Management Automatic retry logic on API failures Separate logging for different error types Detailed technical reasons for invalid emails No data loss with direct webhook referencing 🎯 Use Cases Newsletter sign-ups on websites and landing pages Lead generation forms with quality control Marketing campaigns requiring verified email lists Community building with automated onboarding SaaS product launches with email collection Content creator audience building E-commerce customer list management 📊 What Gets Logged Master Log (All Subscribers) Timestamp, name, email, verification result Verification score and email sent status Source tracking, disposable status, domain info Invalid Emails Log Detailed rejection reasons Technical diagnostic information MX record status, RFC compliance Provider information for troubleshooting Invalid Submissions Log Incomplete form data Missing required fields Timestamp for follow-up 🔧 Technical Stack Trigger: Webhook (POST endpoint) Email Verification: Verifi Email API Email Sending: Gmail OAuth2 (or SMTP) Data Storage: Google Sheets (3 tabs) Processing: JavaScript code nodes for data formatting 🚀 Setup Requirements Google Account - For Sheets and Gmail integration Verifi Email API Key - (https://verifi.email) Google Sheets - Pre-configured with 3 tabs (template provided) 5-10 minutes - Quick setup with step-by-step instructions included 📈 Benefits ✅ Improve Email Deliverability - Remove invalid emails before sending campaigns ✅ Reduce Bounce Rates - Only send to verified, active email addresses ✅ Save Money - Don't waste email credits on invalid addresses ✅ Better Analytics - Track conversion rates by source ✅ Professional Onboarding - Personalized welcome experience ✅ Scalable Solution - Handles high-volume sign-ups automatically ✅ Data Quality - Build a clean, high-quality subscriber list 🎨 Customization Options Email Template - Fully customizable HTML design Verification Threshold - Adjust score requirements Brand Colors - Match your company branding Confirmation Flow - Add double opt-in if desired Multiple Sources - Track different signup forms Language - Easily translate email content 📦 What's Included ✅ Complete n8n workflow JSON (ready to import) ✅ Google Sheets template structure ✅ Responsive HTML email template ✅ Setup documentation with screenshots ✅ Troubleshooting guide ✅ Customization examples 🔒 Privacy & Compliance GDPR-compliant with unsubscribe links Secure data handling via OAuth2 No data shared with third parties Audit trail in Google Sheets Easy data deletion/export 💡 Quick Stats 12 Nodes - Fully automated workflow 3 Data Paths - Valid, invalid, and incomplete submissions 100% Uptime - When properly configured Instant Processing - Real-time email verification Unlimited Scale - Based on your API limits 🏆 Perfect For Marketing Agencies SaaS Companies Content Creators E-commerce Stores Community Platforms Educational Institutions Membership Sites Newsletter Publishers 🌟 Why Use This Workflow? Instead of manually verifying emails or dealing with bounce complaints, this workflow automates the entire process from sign-up to welcome email. Save hours of manual work, improve your email deliverability, and create a professional first impression with every new subscriber. Start building a high-quality email list today! ---

By Jitesh Dugar

245

Add Project Tasks to Google Sheets with GPT-4.1-mini Chat Assistant

Let your team create, track, and manage project tasks through natural conversation. This workflow uses an AI Project Manager Agent that chats with users, gathers the task details it needs, and automatically adds them to a Google Sheet. --- ✅ What this template does Lets you chat naturally with an AI to add new project tasks Automatically detects if the user wants to create or update an item (updates coming soon) Collects Task, Description, and Status fields — allows “don’t know” responses Appends new entries directly into your connected Google Sheets Provides real-time confirmation when the task is added > Trigger: n8n Chat Trigger > Integrations: OpenAI GPT-4.1-mini + Google Sheets (OAuth2) --- 🧠 How it works The Chat Trigger starts a chat with the user. The AI Project Manager Agent asks guiding questions to gather the task name, description, and status. When all fields are complete (all Info = Yes), the data is passed to the Google Sheets node. The task is automatically added to your project tracker sheet. The AI confirms completion in chat. --- ⚙️ Setup instructions Connect OpenAI Go to OpenAI Platform → copy your API key. In n8n, create New Credentials → OpenAI API and paste your key. Ensure your account has active billing under OpenAI Billing. Connect Google Sheets (OAuth2) In n8n → Credentials → New → Google Sheets (OAuth2) Sign in with your Google account and grant access. Select your spreadsheet and tab (e.g., “Tasks”) when prompted. Example sheet: https://docs.google.com/spreadsheets/d/1pbK-B-Q9p8fVjxJIsjEVrAfRgqEPCeYw8rZojZPAb84/edit Test your chat Click Execute Workflow, then start chatting: > “Add a task for reviewing the project report tomorrow.” The agent will ask questions if needed, then add the record to your sheet. --- 🧩 Customization ideas Add a Date Added or Assigned To column to the Google Sheet Integrate with Slack or Outlook to message assigned users Extend the agent to support task updates and deletes Replace Google Sheets with Airtable or Notion if preferred --- 🪄 Requirements n8n version ≥ 1.100 OpenAI API key Google Sheets account --- 📬 Contact Need help customizing this (e.g., adding deadlines, linking to Notion, or Slack notifications)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com

By Robert Breen

10823