This automation workflow fetches new job listings from Upwork via Apify, structures the data, stores it in Google Sheets, and sends a natural language summary generated by OpenAI via Gmail. Designed for professionals who want to monitor freelance opportunities without manual effort.
## Who it´s for
- Freelancers tracking relevant Upwork jobs
- Recruiters sourcing suitable projects for their teams
- Agency owners automating freelance market monitoring
- Developers seeking tech-specific job alerts (e.g. Webflow, React)
## What the automation does
- Triggers daily via cron schedule
- Fetches Upwork job listings using Apify API
- Extracts and formats key fields: title, URL, budget, description
- Logs entries into a Google Sheet for long-term tracking
- Uses OpenAI (via LangChain agent) to generate a concise summary
- Sends digest email through Gmail
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic
- Integrations with Apify, Google Sheets, Gmail, OpenAI
- Basic text guide for deployment and adaptation
## Requirements for setup
- Apify account with API key
- Google Sheets access with write permissions
- Gmail account with send permissions
- n8n instance (cloud or self-hosted)
- OpenAI API key
## Benefits and outcomes
- Saves hours on manual job search
- Daily digest delivered to inbox
- Supports keyword filtering via Apify settings
- Builds historical dataset of freelance trends
- Enables analysis of tech demand and budget shifts
- Personalized, AI-curated summary without noise
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.
Upwork job listings
job aggregation
freelance opportunity tracking
Google Sheets automation
AI job summary
daily job digest
n8n workflow
Apify API integration
automated job monitoring
OpenAI summarization
Gmail notification
freelance project search
scrape Upwork jobs
job logging
cron schedule automation
No feedback yet