Jeremiah Wright
Templates 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 Schedule Trigger fires on an interval. RSS Read pulls new items from Vollna. Filter (optional) skips non-ASCII titles. Code node normalizes fields (title/budget split, clean Upwork link, “Posted x mins ago”, etc.). Sheets Lookup + Compare prevents duplicates by job URL. Sheets Append writes new rows; Slack posts a job alert. Set up In ⚙️ Config, set: VOLLNARSSURL, GOOGLESHEETSDOCID, GOOGLESHEETNAME, SLACKCHANNELID, EMAILTO (optional). Add OAuth credentials for Google Sheets, Slack, and Gmail (optional). Create sheet columns: TITLE, BUDGET, UPWORK JOB LINK, CATEGORIES, SKILLS, DATE, JOB DESCRIPTION, POSTED. (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.
By Jeremiah WrightJob 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 Trigger receives a message or paste-in job brief. LLM agent returns 5 concise search terms (JSON). For each keyword, an HTTP request searches the n8n templates API. Results are split and written to Google Sheets; the workflow builds the public URL from ID+slug. Set up Add credentials for OpenAI (or swap the LLM node to your provider). Create a Google Sheet with columns: Template ID, Name, User, Description, URL. In the ⚙️ Config node, set: GOOGLESHEETSDOCID, GOOGLESHEETNAME, N8NTEMPLATESAPIURL. 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.
By Jeremiah Wright