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 itWhat 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.