n8n Salvage Car Deals: Apify Copart → Sheets + Gemini + Slack

Find high-potential UK Copart salvage deals automatically—then get instant AI repairability reports in Slack

This n8n workflow pulls up to 100 UK Copart auction listings via Apify, tracks them in Google Sheets, uses Google Gemini to estimate reparability and resale economics from listing images, and posts only the best opportunities (reparability score > 80) to Slack.

What this workflow does

• Fetches UK Copart lots on a schedule (or manually): Calls an Apify actor to retrieve lot search results (up to 100).
• Filters to relevant salvage candidates: Splits results into groups including PURE_SALE with NEVERBID status, plus a curated set under 60,000 miles that are automobiles and not water/flood damaged.
• Stores and de-duplicates in Google Sheets: Appends or updates rows using the lot number as the unique key.
• Runs hourly on new rows: Every hour, when a new row is added to the Sheet, it prepares a small set of inspection image URLs from the lot’s images.
• Analyzes images with Google Gemini: Sends the images plus basic listing/price fields to Google Gemini (via a LangChain agent) to generate structured outputs: reparability score, breakdown, financial analysis, and a final verdict.
• Logs results back to Sheets + alerts in Slack: Writes AI assessment fields back into Google Sheets, and posts a formatted deal report to a Slack channel when the reparability score > 80.

Use cases

• Salvage resellers and dealers monitoring UK Copart auctions without manual spreadsheet work.
• SaaS operators or automation engineers validating a “listings → AI scoring → alerting” pipeline.
• Teams researching repair economics using structured AI outputs and centralized tracking in Google Sheets.

Technical details

• Integrations: Apify (Copart listing fetch), Google Sheets (row storage + updates), Google Gemini (image-based analysis), Slack (high-score notifications).
• Workflow logic/nodes: if, set, code, limit, filter, slack.
• Core behavior: Scheduled + hourly trigger for newly added Sheet rows; lot number used as the unique key.