old cars data

No-Code Integrations

Access Old Cars Data auction information without writing code. Use our integrations to fetch auction data directly in your favorite tools.

Overview

No-code integrations allow you to access auction data without writing API code or managing authentication. Simply install the integration and start using custom functions to retrieve data.

Currently, we offer a Google Sheets add-on that provides direct access to auction data through custom spreadsheet functions.

Google Sheets Add-on

The Old Cars Data Google Sheets add-on lets you fetch auction listings and statistics directly in your spreadsheets. Use custom formulas to query data, build reports, and analyze auction trends—all without leaving Google Sheets.

Features

  • Custom spreadsheet functions for auction data
  • Query builder sidebar for non-technical users
  • Manual refresh functionality
  • Secure API key storage
  • No coding required
Install Add-on
1

Installation

Install the add-on from the Google Workspace Marketplace or use the installation link above.

  1. Click the Install Add-on button above or visit the Google Workspace Marketplace
  2. Click "Install" and authorize the add-on when prompted
  3. Open any Google Sheet
  4. You'll see the "OCD API" menu in the menu bar
2

Configure API Key

Before using the formulas, you need to configure your API key.

  1. Get your API key from your profile settings
  2. In Google Sheets, click OCD API > Settings
  3. Enter your API key
  4. Click Save

Available Formulas

The add-on provides two custom functions for accessing auction data and statistics.

OCD_AUCTIONS

Fetches auction listings matching your criteria. Returns a table with detailed auction information.

Syntax

=OCD_AUCTIONS(make, [model], [year_min], [year_max], [price_min], [price_max], [status], [source], [keyword], [sort], [direction], [limit])

Parameters

make(required) The make name
model(optional) The model name
year_min(optional) Minimum year
year_max(optional) Maximum year
price_min(optional) Minimum price
price_max(optional) Maximum price
status(optional) Auction status: "sold", "bid to", "reserve not met", "canceled", "unknown"
source(optional) Source platform filter
keyword(optional) Search keyword to match in title and description
sort(optional) Sort field: "date", "price", "year", "bids" (default: "date")
direction(optional) Sort direction: "asc", "desc" (default: "desc")
limit(optional) Maximum number of results, range 1-100 (default: fetch all)

Returns

A table with the following columns:

ID, Source, URL, Title, Price, Mileage, VIN, City, State, ZIP, Year, Engine, Drivetrain, Transmission, Description, Auction Status, Auction End Date, Title Status, Seller Username, Has Reserve, Listing Make, Listing Model, Body Style, Exterior Color, Interior Color, Standard Exterior Color, Standard Interior Color, Seller Type, OCD Make Name, OCD Model Name, Ownership History, Modifications, Known Flaws, Recent Service History, Listing Details, Created At, Views, Watches, Likes, Bids

Examples

Get all Porsche 911 auctions:

=OCD_AUCTIONS("Porsche", "911")

Get sold Ferrari 308s from 1975-1985, limited to 50 results:

=OCD_AUCTIONS("Ferrari", "308", 1975, 1985, , , "sold", , , , , 50)

Get auctions sorted by price (ascending):

=OCD_AUCTIONS("Toyota", "Land Cruiser", , , , , , , , , "price", "asc")

OCD_STATS

Fetches price statistics for matching auctions, including average price, median price, and price trends.

Syntax

=OCD_STATS(make, [model], [year_min], [year_max])

Parameters

make(required) The make name
model(optional) The model name
year_min(optional) Minimum year
year_max(optional) Maximum year

Returns

A table with statistics and price trend data:

Metric, Value

Includes: Total Sales, Average Price, Median Price, Lowest Price, Highest Price, Sell Through Rate

Plus price trend data (last 12 months) with Date, Average Price, and Volume columns

Examples

Get statistics for all Ferrari 308s:

=OCD_STATS("Ferrari", "308")

Get statistics for Porsche 911s from 1970-1975:

=OCD_STATS("Porsche", "911", 1970, 1975)
3

Using Formulas

Once you've installed the add-on and configured your API key, you can start using the formulas in your spreadsheet.

Google Sheets add-on in action

Basic Usage

  1. Click on any cell in your spreadsheet
  2. Type =OCD_AUCTIONS( to start the formula
  3. Enter your parameters, for example: "Porsche", "911"
  4. Press Enter
  5. The formula will fetch data and populate multiple rows and columns with auction information

Tips

  • Leave optional parameters empty by using commas (e.g., =OCD_AUCTIONS("Porsche", , 1970))
  • Use the limit parameter to control how many results are returned
  • Formulas automatically refresh when you recalculate the sheet
  • Large queries may take a few seconds to complete
4

Refreshing Data

To update your data, you can manually refresh all formulas in your spreadsheet.

  1. Click OCD API > Refresh All Data
  2. The add-on will re-evaluate all cells containing OCD functions
  3. A notification will show how many cells were refreshed

Formulas also automatically refresh when you recalculate the sheet (e.g., when you edit a cell or press Ctrl+R / Cmd+R).

Use Cases

Price Tracking

Track auction prices for specific makes and models over time. Use OCD_STATS to get average and median prices, then create charts to visualize trends.

Inventory Analysis

Build a comprehensive inventory of available auctions. Filter by location, price range, or condition to find vehicles matching your criteria.

Market Research

Analyze market trends by comparing sold vs. unsold auctions, tracking sell-through rates, and identifying popular configurations.

Limitations

  • Results are limited to 2,000 rows per formula call
  • Execution time limit of 25 seconds per formula (may result in incomplete data for very large queries)
  • Limit parameter accepts values between 1 and 100
  • Rate limits apply based on your subscription plan

Need Help?

If you encounter issues or have questions about using the add-on:

API DocumentationAPI Overview