Track role skill trends from Google Jobs with SerpApi, Claude and Sheets

by Fafa Modey ✓ · 5 views · created 2026-09-06 · Market Research, AI Summarization

What this workflow does

This workflow has 14 nodes and runs when someone submits an n8n form (“Run Role Skills Tracker”) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls serpapi.com and openrouter.ai over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Run Role Skills Tracker”) (plus 1 other trigger).

1. Read Config from Sheets (Google Sheets): uses Google Sheets
2. Process Input Data (Code): runs custom JavaScript code
3. Fetch Job Postings via SerpApi (HTTP Request): calls serpapi.com
4. Flatten Job Data (Code): runs custom JavaScript code
5. Deduplicate and Limit Results (Code): runs custom JavaScript code
6. Prepare AI Request Payload (Code): runs custom JavaScript code
7. Post to OpenAI for Analysis (HTTP Request): calls openrouter.ai (POST)
8. Parse OpenAI Response (Code): runs custom JavaScript code
9. Separate Skills into Rows (Code): runs custom JavaScript code
10. Append Run Summary to Sheets (Google Sheets): append

…plus 2 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: serpapi.com, openrouter.ai

Before you upgrade to n8n 3.0

Nodes used (5)

• n8n Form Triggern8n-nodes-base.formTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow runs on demand or daily, pulls recent Google Jobs postings via SerpApi for a chosen role and location, uses OpenRouter to extract and rank core technical skills, and logs skill trends plus a readable summary to Google Sheets for…

View the original on n8n.io → Check your own copy