Scrape US auto transport leads with SerpAPI, OpenAI, 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 25 nodes and runs on a schedule (cron 0 7 * * *) (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI. It also calls serpapi.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 7 * * *) (plus 1 other trigger).
- Set Configuration Values (Edit Fields (Set)): sets 5 fields: serpapi_api_key, input_sheet_id, output_sheet_id…
- Log Workflow Errors (Google Sheets): append
- Read States from Sheets (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Expand State Keywords (Code): runs custom JavaScript code
- Build Search Query (Edit Fields (Set)): sets 3 fields: state, keyword, query
- Loop Over Search Queries (Loop Over Items (Split in Batches)): loops over the items in batches
- FETCH SerpAPI Search Results (HTTP Request): calls serpapi.com
- Split Local Results (Split Out): splits a list into separate items
- Log Errors in Sheets (Google Sheets): append
…plus 13 more steps. See the full node list below.
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Remove Duplicates
n8n-nodes-base.removeDuplicates - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - Error Trigger
n8n-nodes-base.errorTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow runs daily and uses SerpAPI Google Maps results to scrape US business leads by state and keyword from Google Sheets, enriches them with contact emails from websites, generates an outreach email with OpenAI, and appends the leads…