Property Solutions Team Scoreboard

Using Google Sheets and Chart.js

Posted on July 23, 2016 in webdev

Property Solutions Team

I've been away from code for a few months because I've been focusing on my real estate business. Once I get a system in place for investing, I'll be jumping back into Laracasts and making some cool apps to innovate in the real estate industry. Meanwhile, I couldn't help but make a simple tool to keep track of how my team is doing.

A while back I read something on yCombinator about using google sheets as a backend for a simple website. My wholesaling team and I have been using google sheets to keep track of our leads. I thought it would be cool to have a scoreboard to see who has the most leads of the week.

So here's what the spreadsheet looks like:

The lead source column shows who found the property and the column to the right of that shows whether the property is vacant or merely distressed.

Getting Data from Google Sheets

All I did was follow this guy's tutorial and tweak it as I went along. You can access your google sheet's data as JSON by pointing your browser to a specific URL. This fiddle shows you how. After getting the JSON formatted, I used Chart.js to display a bar chart of our team's weekly progress. I also used a pie chart to show which percentage of our leads were vacant houses and which percentage were distressed houses.

This will update whenever someone makes a change to the google sheet. You can use google forms to input data straight into the sheet, which is pretty awesome.

There's a lot of cool stuff you could do with this setup and it only takes a little bit of time to get it going.

comments powered by Disqus