Les Gorges Du Pichoux on August 11, 2018.
Les Gorges Du Pichoux on August 11, 2018.

cycling (41)

Patrick

Flink And The Magic Of Google Sheets

Bike statistics in a Data Studio report.

I've been using the flink.run app to add my Strava data to a Google sheet with a bunch of additional tables that crunch the numbers. Each time I add an activity to Strava, flink.run adds a new row to the data table in my Google sheet. The stats in all the other calculated tables are therefore always up to date.

I sent my FortyFour Big Boy fat bike into retirement and wanted to look up my first ride on it. On Strava there's no easy way to find the first activity with a specific gear. In my Google sheet, it's a simple formula to look for the first occurrence of a specific gear within the activity table. Since I was at it, I added a first ride and last ride column to my gear table.

Continue reading...