Based on the [Track the value of your home via a Zillow script example I created a Google script that will track the value of a car using the VIN number
and vinAudit.
vinAudit (Simple) Automation
The tiller-vinaudit-simple script is a simple Google Apps Script to scrape vinAudit estimates of a car values and insert them into the Balance History sheet of Tiller-enabled spreadsheets. This workflow is especially useful for tracking net worth.
Visit Tiller HQ to learn more about Tiller.
Adivsory
This simple script is designed for intermediate users and includes only lightweight error checking. We hope it meets your needs out of the box, but further tweaks may be required to get it working in your environment. We offer no warranties or support for this solution.
Setting Up Your Project
To configure your project, implement the following steps in Google Sheets:
- Find your vehicleâs VIN #.
- Open the Tiller Google-Sheets spreadsheet youâd like to add your vehicleâs value to.
- Click on Tools -> Script editor to open the spreadsheetâs bound scripts.
- Copy the contents of vinaudit.js from this repo into the Google Sheets script editor.
- Set the
vins
variable (at the start of the code) equal to your vins. - Save the script file and name it
carEstimator
. - Click on the
Select Function
dropdown in the control bar and select thevinAuditInsert
function. - Click the run/play button.
- Select
Review Permissions
and select the google accounts associated with your Tiller Account. - Youâll get a warning saying âThis app isnât verifiedâ. Select
Advanced
andGo to carEstimator (unsafe)
. - Select Allow.
If youâve completed all the steps successfully, you should have a new entry in your Balance History reflecting the viAudit estimate of the vehicle.
Run Monthly
- In the script editor select
Edit > Current Project's Triggers
. - Select event source = Time-driven.
- Select your desired options.
Taking This Solution FurtherâŚ
Consider adding: