See llms.txt for all machine-readable content.

Back to Templates

Find underpriced Canadian used car deals with Apify, OpenAI, Sheets and Telegram

Created by

Created by: youssef farhan || fayoussef
youssef farhan

Last update

Last update a day ago

Categories

Quick overview

This workflow runs daily to find underpriced used cars in Canada via Apify (AutoTrader.ca, Kijiji, and CarGurus.ca), calculates deal metrics, logs all results to Google Sheets, and uses OpenAI to draft a buyer-to-seller offer message that is delivered to you in Telegram.

How it works

  1. Runs every day at 7:00 and loads your search criteria (vehicles, location, price/mileage limits, and deal thresholds).
  2. Uses the Apify Canada Car Scraper actor to search AutoTrader.ca, Kijiji, and CarGurus.ca and return only newly found listings.
  3. De-duplicates cars across runs, computes a market reference (site market value or median of similar cars), and calculates below-market %, walk-away price, and an opening offer while flagging risky or implausibly cheap listings.
  4. Appends every car (kept and rejected, with the reason) to a Google Sheets tab and keeps only the listings marked worth chasing.
  5. Sends the top deals (up to your max offers per run) to OpenAI to generate a short seller message and four tailored questions using only the computed price facts.
  6. Formats the draft and safety checks, then sends the offer package to Telegram and logs the drafted offer to a Google Sheets Offers tab.

Setup

  1. Create an Apify account and add its credential, then add credentials for OpenAI, Google Sheets, and Telegram.
  2. Open the Canada Car Scraper Actor once so it is available to your account, then set your vehicle list, postal code and radius, price and mileage limits, max cars and max offers in the Set your search node.
  3. Create a Google Sheet with tabs matching your configured names (default: Cars and Offers) and paste the sheet URL into the workflow.
  4. Copy your Telegram chat ID into the workflow and start a chat with your bot so it can deliver messages.
  5. Review and customize the buyer name/note and the deal thresholds (min below market %, opening offer %, and risky listing filtering) before enabling the schedule.

Requirements

Customization

  • Run it hourly, since only new cars are fetched. Lower minBelowMarketPct to see more cars or raise it for only strong deals. Swap OpenAI for Anthropic or Gemini, or Telegram for Slack. Read every message before you send it to a seller.

Additional info

Need a custom version or another data source? See automationbyexperts.com.