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.
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:
I love that you were able to get some mileage out of that simple zillow script, @kevinmclaughlin!
Thanks for sharing this new workflow. It is a great addition to Tiller Money.
If you run it from the Apps Script Editor does it run clean, or does it error out? Iâm thinking maybe the VIN you entered isnât a proper VIN or it canât find it.
Maybe itâs the formatting, hereâs what my âvinsâ line looks like in the script, with quotes around the VIN, and brackets around the quotes:
var vins = [âXXXXXXXXXXXXXXXXXâ];
For what itâs worth, I think the quotes they give are very high. They are significantly greater than what I get from KBB.com and a couple other sites I tried.
The empty parentheses is in the script. I tried removing an re-adding them in. I am not seeing the trim method populate as I type it in the location it is set to inside the bracket after the columnIndex. If I start to type it after the toLowerCase() it populates.
I had the same problem, started 17 days ago. I just added toString() as suggested, and that fixed it, but the value I get back for my car is far from realistic (almost $10k over valued, used to at least be similar to what other services suggested), and my wifeâs car isnât returning a value at all (it used to), so Iâm thinking itâs time to abandon this and manually look up the values myself every now and then, as I have to on Zillow for the house.