Track recurring job pain points with SerpApi, Gemini, and Google Sheets
Research & reporting workflow for n8n with 11 active steps. Starts with Schedule Trigger. Uses Google Gemini. Integrations include Google Sheets, Google Gemini.
What it does
11 active nodes · Starts with Schedule Trigger.
Steps in the template include:
- Weekly Trigger (Schedule Trigger)
- Set Search Config (Edit Fields (Set))
- Fetch Job Postings (SerpApi) (HTTP Request)
- Split Out Jobs (Split Out)
Nodes and integrations
- Schedule Trigger
- Edit Fields (Set)
- HTTP Request
- Split Out
- Code ×2
- Google Sheets ×3
- Aggregate
- Google Gemini
See the author’s step names
- Weekly Trigger (Schedule Trigger)
- Set Search Config (Edit Fields (Set))
- Fetch Job Postings (SerpApi) (HTTP Request)
- Split Out Jobs (Split Out)
- Parse AI Output (Code)
- Append to Google Sheet (Google Sheets) — append
- Read All Sheet Rows (Google Sheets)
- Aggregate Sheet Rows (Aggregate)
- Rank Pain Points by Frequency (Code)
- Write Summary Sheet (Google Sheets) — append
- AI Model (Google Gemini)
Accounts and credentials
- Google Sheets
- Google Gemini access
Credential types in the graph: googleSheetsOAuth2Api, googlePalmApi
Check the HTTP request steps for any additional service accounts or API keys.
AI models and swaps
Google Gemini · Model or API operation
models/gemini-3.1-flash-lite in AI Model. Provider-specific step. A different provider requires edits and testing.
Inputs and setup options
- Setup field: role
- Setup field: location
- Setup field: sheetTab
Resource information
- Credit basis
- Author listed by n8n
- Pricing
- Template access shown on n8n
- License
- Not specified
- Last record update
- Nov 5, 2026