Back to Templates

Track Upwork Jobs from Vollna RSS with Google Sheets Logging and Slack Alerts

Created by

Created by: Jeremiah Wright || jerrywright

Jeremiah Wright

Last update

Last update a day ago

Share


Who’s it for

Freelancers and agencies who track new Upwork leads via Vollna RSS and want clean logging to Google Sheets with instant Slack alerts.

What it does

Polls a Vollna RSS feed every few minutes, parses each job (title, budget, link, skills, categories), dedupes against your sheet, appends only new jobs, and notifies Slack with a compact alert.

How it works

1. Schedule Trigger fires on an interval.
2. RSS Read pulls new items from Vollna.
3. Filter (optional) skips non-ASCII titles.
4. Code node normalizes fields (title/budget split, clean Upwork link, “Posted x mins ago”, etc.).
5. Sheets Lookup + Compare prevents duplicates by job URL.
6. Sheets Append writes new rows; Slack posts a job alert.

Set up

1. In ⚙️ Config, set: VOLLNA_RSS_URL, GOOGLE_SHEETS_DOC_ID, GOOGLE_SHEET_NAME, SLACK_CHANNEL_ID, EMAIL_TO (optional).
2. Add OAuth credentials for Google Sheets, Slack, and Gmail (optional).
3. Create sheet columns: TITLE, BUDGET, UPWORK JOB LINK, CATEGORIES, SKILLS, DATE, JOB DESCRIPTION, POSTED.
4. (Optional) Adjust polling interval on the Schedule Trigger.

Requirements

• Vollna RSS feed URL (your tokenized link)
• n8n (cloud or self-hosted) with Google Sheets + Slack creds

Customize

• Remove the ASCII filter for broader coverage.
• Swap Gmail/Slack with your preferred notifier.
• Add keyword filters before appending to Sheets.