Example of how to connect the Strava API with Google Sheets using Apps Script.
Full how-to tutorial: How to connect the Strava API with Google Sheets and Data Studio
- Create a new Google Sheet
- Add the Apps Script OAuth 2 library
- Create a second gs file, oauth.gs
- Add the code from code.gs and oauth.gs files in this repo
- Setup your application in Strava: Settings > My API Application
- Set the Authorization Callback Domain to
script.google.com
- Run the scripts and authenticate the connection
This basic implementation will paste 4 fields of activity data into your Google Sheet: ID, Name, Type and Distance
You can of course grab more!
Explore the data with Data Studio: