Quick overview
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 Runs on a schedule (or manually) and calls an Apify actor to fetch up to 100 UK Copart lot search results. Limits the number of returned items and filters lots into two groups: PURE_SALE with NEVERBID status, and a curated set under 60,000 miles that are automobiles and not water/flood damaged. Appends or updates matching lots in a Google Sheets spreadsheet using the lot number as the unique key. 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. Sends the images and basic lot/price fields to Google Gemini (via a LangChain agent) to generate a structured reparability score, breakdown, financial analysis, and verdict. Writes the AI assessment fields back to Google Sheets and, if the reparability score is greater than 80, posts a formatted report to a Slack channel. Setup Create and connect an Apify HTTP Header Auth credential with your Apify token, and confirm the Copart search URL and actor endpoint match your desired market and filters. Add Google Sheets service account credentials, share the target spreadsheet with the service account email, and update the spreadsheet ID and sheet tab as needed. Add a Google Gemini (Google PaLM) API credential and keep the selected model (models/gemini-3.1-flash-lite) or replace it with your preferred Gemini model. Add Slack OAuth credentials and select the channel where deal alerts should be posted. Ensure the Google Sheet contains the expected columns (for example lotNumber and lotImages/thumbnail_image, plus output columns like reparability_score and verdict) so rows can be matched and updated correctly. Additional info automate salvage car deal sourcing n8n, scrape copart uk auction data google sheets, ai car damage assessment n8n workflow, gemini flash multimodal vehicle damage appraisal automation, automated salvage flipping flip car profit calculator, n8n copart apify integration slack alerts, ai car repair feasibility agent google sheets, n8n salvage car deal finder template, copart scraper n8n workflow json, n8n gemini structured output car inspection, automated auction bidding sniper sheet, car flipping lead tracker n8n template, apify copart actor to google sheets pipeline. An n8n automation workflow template by iamvaar.
iamvaar
web
paid
Others in the same category, ranked by how often they are opened.
