Sign in Get the app
← All skills

Log my Strava runs to a training sheet

by codedroid Official · Data export & personal analytics

Copies your recent Strava runs to a Google Sheets training log, marking easy zone 2 runs and 5K tests.

Rating
Not rated yet
Runs
0
Works in
Strava, Sheets

Running it can do something that can't be undone, so CodeDroid asks you first.

Get CodeDroid to run it

What it tells your phone

Open Strava and go to your own activities (You > Activities), then pull the list down to refresh it. Read your runs from the last {{days}} days: date, distance, moving time, pace and average heart rate if shown. Call a run a 5K test if it's between 4.8 and 5.3 km at a hard pace, zone 2 if its pace is slower than {{zone2_pace}} per km, otherwise other. Then If a spreadsheet named "CodeDroid training log" isn't in Google Sheets yet, create it; otherwise open it. Only write to that spreadsheet; don't edit or delete any other file. Add a row for each run that isn't in it yet, with those fields and the type. Tell me here what you added. If there are no runs in that time, say so and add nothing. Don't edit, delete, give kudos or comment on any activity.