{"product_id":"n8n-salvage-car-deals-apify-copart-sheets-gemini-slack","title":"n8n Salvage Car Deals: Apify Copart → Sheets + Gemini + Slack","description":"\u003ch3\u003eFind high-potential UK Copart salvage deals automatically—then get instant AI repairability reports in Slack\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u0026gt; 80) to Slack.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches UK Copart lots on a schedule (or manually):\u003c\/strong\u003e Calls an Apify actor to retrieve lot search results (up to 100).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to relevant salvage candidates:\u003c\/strong\u003e Splits results into groups including \u003cem\u003ePURE_SALE\u003c\/em\u003e with \u003cem\u003eNEVERBID\u003c\/em\u003e status, plus a curated set under \u003cem\u003e60,000 miles\u003c\/em\u003e that are \u003cem\u003eautomobiles\u003c\/em\u003e and \u003cem\u003enot water\/flood damaged\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores and de-duplicates in Google Sheets:\u003c\/strong\u003e Appends or updates rows using the \u003cstrong\u003elot number\u003c\/strong\u003e as the unique key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly on new rows:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes images with Google Gemini:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results back to Sheets + alerts in Slack:\u003c\/strong\u003e Writes AI assessment fields back into Google Sheets, and posts a formatted deal report to a Slack channel when the \u003cstrong\u003ereparability score \u0026gt; 80\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSalvage resellers and dealers monitoring UK Copart auctions without manual spreadsheet work.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or automation engineers validating a “listings → AI scoring → alerting” pipeline.\u003c\/li\u003e\n  \u003cli\u003eTeams researching repair economics using structured AI outputs and centralized tracking in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (Copart listing fetch), Google Sheets (row storage + updates), Google Gemini (image-based analysis), Slack (high-score notifications).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\/nodes:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003elimit\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore behavior:\u003c\/strong\u003e Scheduled + hourly trigger for newly added Sheet rows; lot number used as the unique key.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46047336956083,"sku":"N8N-19659","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NIQL6i2S-SUyuCTwVYQHt_IHC5fgOr.png?v=1789636298","url":"https:\/\/buyflowscripts.com\/products\/n8n-salvage-car-deals-apify-copart-sheets-gemini-slack","provider":"N8N Commerce","version":"1.0","type":"link"}