Extract Jobs from Career Pages to Google Sheets (n8n)

Automatically extract job postings from career pages and save them to Google Sheets

This n8n workflow visits your company’s careers pages, captures the fully rendered content, extracts structured job offers with an OpenAI chat model, and keeps a Google Sheet up to date—while logging any extraction issues to an error tab.

What this workflow does

• Runs daily at 9:00 AM on a schedule.
• Reads career-page URLs from the “Job Sources” tab in your Google Sheets and processes them one by one.
• Fetches fully rendered HTML using Snapshot Site, routing any Snapshot Site API errors to an error-handling path.
• Cleans the captured HTML by removing scripts/styles and trimming content before sending it to the extractor.
• Extracts job offers with an OpenAI chat model into a structured array (e.g., title, company, location, salary, application URL, and more).
• Writes results to Google Sheets by splitting extracted jobs into individual items and appending or updating rows in the “Job Offers” tab.
• Deduplicates by applicationUrl to avoid repeated entries.
• Logs extraction errors (URL, message, timestamp) to the “Extraction Errors” tab and continues processing remaining sources.

Use cases

• Building a job tracking dashboard by monitoring multiple career pages and keeping job offers current automatically.
• Creating a recruiting CRM input where each posting is normalized into consistent fields.
• Maintaining a lead pipeline of application URLs by ingesting new roles daily without manual scraping.

Technical details

• n8n scheduled workflow (daily at 9:00 AM)
• Snapshot Site via community node n8n-nodes-snapshot-site
• OpenAI (or compatible) chat model for information extraction
• Google Sheets read/write for Job Sources, Job Offers, and Extraction Errors tabs
• Workflow logic using nodes such as if, set, code, no op, and split out (plus sticky note documentation)

Ideal if you’re looking for an n8n career page to Google Sheets automation that combines Snapshot Site rendering, OpenAI extraction, and deduped job-offer storage.