Upwork Job Listing Scraper to Google Sheets Tracker - n8n Workflow

• Freelancers, consultants, and agencies who need to continuously monitor the competitive Upwork job market.


• Business analysts and market researchers tracking trending skills and client demands.


• Users searching for practical n8n templates focusing on web scraping and data logging.


• Anyone who wants to set up a hands-free, scheduled data extraction process using an n8n trigger.

This robust n8n workflow solves the challenge of manually tracking job opportunities on platforms like Upwork. Since Upwork lacks a public API for granular job listing retrieval, this n8n automation cleverly integrates with Apify—a specialized web scraping platform—to reliably extract data. The core value of this n8n workflow is its ability to transform raw HTML data into structured, actionable market intelligence, which is then stored in an easily manageable Google Sheet. This is one of the most useful n8n templates for professionals who require automated, real-time insights into the freelance economy. The recurring schedule n8n trigger ensures your data is always up-to-date.

This automation follows a scheduled process to ensure continuous market monitoring:

1. Scheduled Start (n8n Trigger): The n8n workflow initiates automatically using a Schedule Trigger (configured to run every hour) via the Check Upwork Jobs - Trigger n8n node.


2. Data Fetching: The workflow immediately proceeds to the Fetch Upwork Jobs using Apify n8n node. This n8n node sends a POST request to your dedicated Apify task ID, instructing the Apify service to scrape the latest Upwork jobs and return the dataset synchronously.


3. Data Structuring: The raw JSON output from Apify is processed by the Format scrape Data n8n node. This Set n8n node extracts only the essential fields—title, description, postedDate, skills, and link—to prepare a clean, uniform payload.


4. Logging to Google Sheets: The final step uses the Log Jobs to Google Sheets n8n node. This node connects to the specified Google Sheet document and appends the fully formatted job data as a new row, providing a centralized and filterable list of current Upwork opportunities. This efficient n8n workflow ensures data integrity and consistency.

To deploy this powerful n8n workflow template, follow these steps:

1. Import: Copy the provided n8n workflow JSON and import it into your n8n instance.


2. Apify Setup: You must have an Apify account and a running Upwork Scraper Actor/Task configured. In the Fetch Upwork Jobs using Apify n8n node, replace ID> and API_TOKEN> in the URL with your actual Apify credentials and task identifier.


3. Google Sheets Credentials: Click on the Log Jobs to Google Sheets n8n node and set up or select existing Google Sheets OAuth2 API credentials.


4. Google Sheets Configuration: Configure the target Google Sheet document ID and sheet name (e.g., Sheet1) within the Google Sheets n8n node where the job data should be logged.


5. Activation: Ensure the Check Upwork Jobs - Trigger n8n trigger is correctly configured for your desired running interval (e.g., hourly). Activate the entire n8n workflow to start monitoring.

Check Upwork Jobs - Trigger (Schedule Trigger n8n node):
Function: Serves as the primary n8n trigger, initiating the entire data extraction process at regular, defined intervals.
Key Configuration: Configured to run every one hour, ensuring fresh data retrieval.

Fetch Upwork Jobs using Apify (HTTP Request n8n node):
Function: Executes the web scraping operation by making a synchronous POST request to the Apify API, targeting the pre-configured Upwork scraping task.
Key Configuration: Uses a placeholder URL that requires replacement with the specific Apify task ID and API token. Method is set to POST.

Format scrape Data (Set n8n node):
Function: Cleans the data payload by mapping and extracting only the necessary fields (title, description, postedDate, skills, link) before logging.
Key Configuration: Assignments define how the incoming data structure is simplified and standardized.

Log Jobs to Google Sheets (Google Sheets n8n node):
Function: Takes the formatted job listings and appends them as new rows into the designated Google Sheet for persistent storage and analysis.
Key Configuration: Operation set to Append. Columns are explicitly mapped to the output of the Set n8n node (title, description, postedDate, skills, link). Requires Google Sheets OAuth2 credentials.