Track recurring job pain points with SerpApi, Gemini, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs on a schedule (every week). Along the way it connects Google Sheets and Google Gemini. It also calls serpapi.com over HTTP.
How it runs
Trigger: On a schedule (every week).
- Set Search Config (Edit Fields (Set)): sets 3 fields: role, location, sheetTab
- Fetch Job Postings (SerpApi) (HTTP Request): calls serpapi.com
- Split Out: splits a list into separate items
- AI Model (Google Gemini): uses Google Gemini
- Parse AI Output (Code): runs custom JavaScript code
- Append to Google Sheet (Google Sheets): append
- Read All Sheet Rows (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Rank Pain Points by Frequency (Code): runs custom JavaScript code
- Write Summary Sheet (Google Sheets): append
Services it uses
HTTP calls to: serpapi.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
Quick Overview This workflow runs weekly to pull Google Jobs results via SerpApi, uses Google Gemini to extract operational pain points and an automation opportunity from each posting, logs them to Google Sheets, and writes a frequency-ranked pain-point…