My own 'VeloViewer' - part II (now called OrangeStats)

As mentioned earlier in my blog, I would like to create my own sheet with real-time Strava data for various reasons. I also made a list of what I would like to take out as overviews.

In the meantime, I've continued to research how I can do it:

- I ended up on Google Sheets. This Google Excel/Spreadhseet variant is in the cloud. Well accessible from your mobile. Free and the processing speed is high. The scripting code is also a Javascript variant, so you can learn quickly and/or there is also a lot to find / copy on the internet.

- Strava data can be accessed via an API. Strava has really nice possibilities to unlock your data externally. Go to Strava settings, there you will see your API menu at the bottom of the page.

Here you can finally see your usage and copy your settings to unlock this API for yourself.

In the meantime, I've started to unlock this API in Google Sheet, and don't worry, you don't have to code for it. At least you can copy it (from me), that's what I also did from the internet.

The first results, the raw data in the sheet, looks like this:

From here I'm going to work it out. In a next blog I will explain exactly what to do step by step. You can you copy the code and get it to work for yourself.