Jeremiah Wright
Workflows by Jeremiah Wright
Track Upwork jobs from Vollna RSS with Google Sheets logging and Slack alerts
## 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.
Job brief analysis with OpenAI to find relevant templates and log in Google Sheets
## Who’s it for Recruiters, freelancers, and ops teams who scan job briefs and want quick, relevant n8n template suggestions, saved in a Google Sheet for tracking. ## What it does Parses any job text, extracts exactly 5 search keywords, queries the n8n template library, and appends the matched templates (ID, name, description, author) to Google Sheets, including the canonical template URL. ## How it works 1. Trigger receives a message or paste-in job brief. 2. LLM agent returns 5 concise search terms (JSON). 3. For each keyword, an HTTP request searches the n8n templates API. 4. Results are split and written to Google Sheets; the workflow builds the public URL from ID+slug. ## Set up 1. Add credentials for OpenAI (or swap the LLM node to your provider). 2. Create a Google Sheet with columns: Template ID, Name, User, Description, URL. 3. In the ⚙️ Config node, set: GOOGLE_SHEETS_DOC_ID, GOOGLE_SHEET_NAME, N8N_TEMPLATES_API_URL. ## Requirements • n8n (cloud or self-hosted) • OpenAI (or alternative LLM) credentials • Google Sheets OAuth credentials ## Customize • Change the model/system prompt to tailor keyword extraction. • Swap Google Sheets for Airtable/Notion. • Extend filters (e.g., only AI/CRM templates) before writing rows.