# Find and analyze salvage car deals with Apify, Google Sheets and Gemini

> 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 from listing images, logging results back to Sheets and posting high-scoring deals to Slack. How it works 1. Runs on a schedule (or manually) and calls an Apify actor to fetch up to 100 UK Copart lot search results. 2. Limits the number of returned items and filters lots into two groups: PURESALE with NEVERBID status, and a curated set under 60,000 miles that are automobiles and not water/flood damaged. 3. Appends or updates matching lots in a Google Sheets spreadsheet using the lot number as the unique key. 4. Triggers every hour when a new row is added to the Google Sheet and prepares a small set of inspection image URLs from the lot’s images. 5. Sends the images and basic lot/price fields to Google Gemini (via a LangChain agent) to

- **Domain**: `n8n-workflow-19659.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/19659
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19659.n8n.io
- Documentation: https://n8n.io/workflows/19659