n8n Workflow: Track Competitor Hiring to Google Sheets & Slack

Track competitor hiring automatically—daily updates to Google Sheets & Slack

This n8n workflow pulls fresh job postings from the Job Opportunities API (JOA), deduplicates them by job id, and keeps a structured list in Google Sheets while notifying you in Slack.

What this workflow does

• Runs daily at 08:00 on a scheduled schedule.
• Sets job search filters (e.g., title, country, remote preference, how many days back to look, and maximum results).
• Calls the Job Opportunities API /v1/jobs endpoint using the filters and a posted_after value derived from your “days back” setting.
• Transforms the response into one structured item per job, including fields such as location, remote status, remote source, salary details, posted date, and apply URL.
• Appends or updates rows in Google Sheets by matching on the job id to prevent duplicate openings.

Use cases

• SaaS ops / founders monitoring competitors’ hiring momentum and emerging roles (remote + location changes).
• Automation engineers using an API-to-Spreadsheet pattern with deduplication and structured fields.
• Recruiting teams tracking targeted job titles from employers’ own career sites—without job board noise.

Technical details

• Job Opportunities API (HTTP request to /v1/jobs) using a Bearer token: Authorization: Bearer YOUR_KEY.
• Google Sheets integration: writes a de-duplicated job list to a sheet with matching headers (e.g., id, title, company, location, remote, remote_source, employment_type, seniority, salary_min, salary_max, salary_currency, posted_at, apply_url).
• Slack notifications (via Slack node).
• Nodes include: if, code, no op, filter, and sticky note.

Setup in minutes

• Create a free JOA API key: https://jobopportunitiesapi.org/login?ref=n8n-template
• Configure the HTTP Header Auth credential (Authorization: Bearer YOUR_KEY).
• Connect Google Sheets and select the target spreadsheet and sheet.
• Update the job search value/filters to match your competitor targets.