{"product_id":"track-job-skill-trends-serpapi-claude-google-sheets","title":"Track Job Skill Trends: SerpApi, Claude \u0026 Google Sheets","description":"\u003ch3\u003eTrack Job Skill Trends Automatically with SerpApi, Claude, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers on demand or on a schedule\u003c\/b\u003e using either an n8n Form submission (role + location) or a daily Schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReuses the last saved role\/location\u003c\/b\u003e by reading the Google Sheets \u003cb\u003eConfig\u003c\/b\u003e tab (key, role, location, last_run_date). If the form role is blank, it keeps the previous values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches recent postings from SerpApi\u003c\/b\u003e using SerpApi’s \u003cb\u003eGoogle Jobs\u003c\/b\u003e engine for the selected role\/location (up to ~100 postings).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eConsolidates and prepares the dataset\u003c\/b\u003e by flattening results, truncating descriptions, deduplicating by \u003ci\u003etitle\u003c\/i\u003e and \u003ci\u003ecompany\u003c\/i\u003e, and capping the list at 100 postings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts and ranks technical skills\u003c\/b\u003e by sending the consolidated postings to \u003cb\u003eOpenRouter\u003c\/b\u003e (chat completions). The model returns JSON with top technical skills, their categories, and the \u003cb\u003epercentage of postings mentioning each skill\u003c\/b\u003e, plus a plain-text summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs results to Google Sheets\u003c\/b\u003e: appends one row per skill to the \u003cb\u003eSkill Trends\u003c\/b\u003e tab and appends the run summary to a \u003cb\u003eRun Summaries\u003c\/b\u003e tab. It also updates \u003cb\u003eConfig\u003c\/b\u003e so scheduled runs keep the latest role\/location.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor skill demand changes for a specific job title (e.g., “Data Engineer”) in a chosen location.\u003c\/li\u003e\n  \u003cli\u003eValidate training or hiring strategies by tracking which technical skills appear most often in current postings.\u003c\/li\u003e\n  \u003cli\u003eUse daily trend tracking to spot emerging technologies before they become mainstream requirements.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eNodes\/steps\u003c\/b\u003e: Code, Sticky Note, Form Trigger, HTTP Request, Google Sheets, Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\u003c\/b\u003e: \u003cb\u003eSerpApi\u003c\/b\u003e (Google Jobs), \u003cb\u003eOpenRouter\u003c\/b\u003e (JSON skill extraction and ranking), \u003cb\u003eGoogle Sheets\u003c\/b\u003e (Config, Skill Trends, Run Summaries).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eGet started:\u003c\/b\u003e set up a Google Sheets file with the tabs \u003cb\u003eConfig\u003c\/b\u003e and \u003cb\u003eSkill Trends\u003c\/b\u003e (and optionally \u003cb\u003eRun Summaries\u003c\/b\u003e) as described above.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974319169715,"sku":"N8N-19288","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tzn7n_4w1DTJfM7ZFDLvY_INkYyxie.png?v=1788772358","url":"https:\/\/buyflowscripts.com\/products\/track-job-skill-trends-serpapi-claude-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}