Apify Y Combinator Jobs to Google Sheets (n8n Workflow)

Automatically sync Y Combinator job listings into Google Sheets using Apify + n8n

This n8n workflow pulls the latest Y Combinator job postings via Apify’s nomad-agent/ycombinator-was-scraper Actor and upserts them into Google Sheets, deduplicating by a stable jobKey so you don’t get repeated rows.

What this workflow does

• Runs manually or daily (default schedule: 08:00 UTC).
• Validates configuration, including the Apify Actor build/version, charge cap (maxTotalChargeUsd), polling deadline, Actor input JSON, and the Google Sheets destination (spreadsheet ID + sheet/tab name).
• Starts an Apify run for nomad-agent/ycombinator-was-scraper with your Y Combinator search parameters and charge limit.
• Polls the Apify run until it reaches a terminal status or the polling deadline is exceeded.
• Confirms the run succeeded on the expected build and retrieves up to 5 items from the run’s Apify dataset.
• Validates, deduplicates, and standardizes each job into a consistent row schema (including jobKey, title, company, URL, location, and salary fields).
• Upserts into Google Sheets: appends new rows or updates existing ones using jobKey as the unique key.

Use cases

• SaaS teams tracking Y Combinator job leads in a shared Google Sheets pipeline.
• Automation engineers maintaining a clean, deduplicated job database without manual copy/paste.
• Ops or recruiting workflows that need consistent job fields (title, company, URL, location, salary) for further processing.

Technical details

• Uses Apify API with an n8n HTTP Request sending your Apify token as Bearer Authorization.
• Integrates Google Sheets via OAuth2 to update the configured sheet/tab.
• Workflow nodes include: if, set, code, sticky note, http request, and google sheets.