Flink And The Magic Of Google Sheets
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...