Track Job Skill Trends: SerpApi, Claude & Google Sheets

Track Job Skill Trends Automatically with SerpApi, Claude, and Google Sheets

This n8n workflow pulls recent Google Jobs postings for a role and location, extracts the most relevant technical skills (via OpenRouter), and logs skill trend data into Google Sheets—so you can monitor how hiring requirements change over time.

What this workflow does

• Triggers on demand or on a schedule using either an n8n Form submission (role + location) or a daily Schedule trigger.
• Reuses the last saved role/location by reading the Google Sheets Config tab (key, role, location, last_run_date). If the form role is blank, it keeps the previous values.
• Fetches recent postings from SerpApi using SerpApi’s Google Jobs engine for the selected role/location (up to ~100 postings).
• Consolidates and prepares the dataset by flattening results, truncating descriptions, deduplicating by title and company, and capping the list at 100 postings.
• Extracts and ranks technical skills by sending the consolidated postings to OpenRouter (chat completions). The model returns JSON with top technical skills, their categories, and the percentage of postings mentioning each skill, plus a plain-text summary.
• Logs results to Google Sheets: appends one row per skill to the Skill Trends tab and appends the run summary to a Run Summaries tab. It also updates Config so scheduled runs keep the latest role/location.

Use cases

• Monitor skill demand changes for a specific job title (e.g., “Data Engineer”) in a chosen location.
• Validate training or hiring strategies by tracking which technical skills appear most often in current postings.
• Use daily trend tracking to spot emerging technologies before they become mainstream requirements.

Technical details

• Nodes/steps: Code, Sticky Note, Form Trigger, HTTP Request, Google Sheets, Schedule Trigger.
• Integrations: SerpApi (Google Jobs), OpenRouter (JSON skill extraction and ranking), Google Sheets (Config, Skill Trends, Run Summaries).

Get started: set up a Google Sheets file with the tabs Config and Skill Trends (and optionally Run Summaries) as described above.