Find and analyze salvage car deals with Apify, Google Sheets and Gemini
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 18 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects Google Sheets, Google Gemini Chat Model and Slack.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Fetch Auction Vehicle Listings (HTTP Request): calls an HTTP API
- Limit: keeps the first few items
- Limit: keeps the first few items
- Process Auction Data (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Filter: keeps only the items that match a condition
- Repair Feasibility Agent (AI Agent): runs an AI agent, with model: Gemini Chat Model; output parser: Parse Structured Output
- Update Pure Sale Auction Results (Google Sheets): uses Google Sheets
- Update Curated Auction Results (Google Sheets): uses Google Sheets
- Update Feasibility Results (Google Sheets): uses Google Sheets
…plus 3 more steps. See the full node list below.
Services it uses
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 (14)
- Limit
n8n-nodes-base.limit - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview Video Explanation: https://youtu.be/TeYVU4NSgrE This workflow pulls UK Copart auction listings via Apify, saves selected lots to Google Sheets, then analyzes newly added rows with Google Gemini to estimate repairability and resale economics…