n8n Workflow: Log New LinkedIn Jobs to Google Sheets (RapidAPI JSearch)

Automatically log new LinkedIn-style job postings to Google Sheets—every 12 hours

This n8n workflow searches for LinkedIn-style jobs using RapidAPI JSearch, removes senior-level titles, deduplicates results against your Google Sheets log, and appends only truly new postings for manual tracking.

What this workflow does

• Runs on a schedule (every 12 hours) to keep your job pipeline fresh without manual searching.
• Builds a search query from configurable parameters including job title, location, a remote flag, and a date_posted window.
• Calls RapidAPI JSearch via the /search-v2 endpoint to retrieve job results and splits the returned data.jobs array into individual job items.
• Filters out Senior-level titles by matching titles against Senior, Lead, Staff, and Principal.
• Deduplicates against Google Sheets: reads existing rows from the Jobs tab and compares fetched jobs using job_id as the dedupe key.
• Appends only new jobs to the sheet with: title, company, location, url, job_id, and a formatted date_posted. The status field is left blank for you to update.

Use cases

• SaaS operators tracking new opportunities for specific roles (e.g., product, engineering, operations).
• Automation engineers wanting a reliable “job discovery → spreadsheet log” workflow with dedupe by job_id.
• Recruiters or job seekers who only want non-senior matches and need a clean, reviewable Google Sheets list.

Technical details

• RapidAPI JSearch: X-RapidAPI-Key header auth; uses /search-v2.
• Google Sheets: reads the Jobs tab and appends new rows to the same sheet.
• n8n nodes / building blocks: http request, set, filter, split out, no op, and supporting nodes like a sticky note.