Training Log

Logging Exercise with Strava

I started getting back into endurance sports in 2020 after a 6 year hiatus. In high school and university, road and track cycling were a big part of my life.

I thought it would be interesting to combine my passions of exercising and working with data.

How does it work?

1. I log all my activities with my Garmin smartwatch
2. The data is then synced with Garmin Connect/Strava
3. I set up a Strava developer app in order to call the Strava API
4. Someone else shared a useful Google Apps script which I run every 6 hours, dumping activity data into a Google Sheet.
5. Then I query the Google Sheet using SQL in BigQuery, using external table functionality.

Here you can see I've integrated my Strava/Garmin workouts into this website to analyze how my exercise patterns have changed over time. More is always better, right?

Have I been exercising more over time?

It turns out 2023 was my best year for exercise hours:

Top Sports

What are my recent top sports?

Trends By Sport

I seem to have seasonal obsessions with Cycling, Pickleball and in the fall/winter spend more time in the gym. You can see that below:

Calendar View

What if we wanted to look at exercise activity in a calendar view?