Google Sheets + Strava + Delay by Zapier
Add new Strava activities as rows to Google Sheets, then update them over the next 24 hours (Multistep Zap)
Strava posts your activity to your feed right when it happens, but many times later you edit the activity, or want more details on the activity, or even want to see your kudos count! Zapier can automate this whole process over a 24 hour span. It will create a new row in your Google Sheet, including all of the activity details like pace/mileage/elevation/heart rate and time (in both metric and US/imperial). Then it will check for updates on this activity after 1 hour and then later after 24 hours, making sure your sheet stays updated with any changes that have gone on (including those many kudos!)
Strava posts your activity to your feed right when it happens, but many times later you edit the activity, or want more details on the activity, or even want to see your kudos count! Zapier can automate this whole process over a 24 hour span. It will create a new row in your Google Sheet, including all of the activity details like pace/mileage/elevation/heart rate and time (in both metric and US/imperial). Then it will check for updates on this activity after 1 hour and then later after 24 hours, making sure your sheet stays updated with any changes that have gone on (including those many kudos!)
- When this happens...New Athlete Activity
Triggers when you post a new activity.
- automatically do this...Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
- then do this...Delay For
Waits for a set amount of time before completing your Actions.
- then do this...Find Activity
Finds one of your activities based on the ID or Name. Useful for getting activity updates as well as kudos and segment information.
- then do this...Update Spreadsheet Row
Update a row in a specific spreadsheet.
- then do this...Delay For
Waits for a set amount of time before completing your Actions.
- then do this...Find Activity
Finds one of your activities based on the ID or Name. Useful for getting activity updates as well as kudos and segment information.
- then do this!Update Spreadsheet Row
Update a row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
Transfer Athlete Activities
This trigger is for use in Transfer. If not using Transfer, use the new "New Athlete Activity" instant trigger instead.
Try ItNew Athlete Activity
Triggers when you post a new activity.
Try ItCreate Totals and Stats Report
Creates report that includes recent (last 4 weeks), year to date and all time stats of your activities.
Help Text
Activity Id
Activity Name
ClubsRequired
Try ItActivity NameRequired
Activity TypeRequired
Activity Start Date/TimeRequired
Activity Elapsed Time (in seconds)Required
Activity Description
Activity Distance (in meters)
Trainer
Commute
Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
Drive
SpreadsheetRequired
WorksheetRequired
Try It
