Import Strava Data to Google Sheets
In this guide, we’ll walk through how to pull Strava data data directly into Google Sheets, using the API Connector add-on for Sheets. Strava is, of course, a well-known fitness tracker website and app. The Strava API only supports authentication via OAuth2, so we’ll be connecting using API Connector’s built-in OAuth2 integration for Strava.
- Part 1: Connect to the Strava API
- Part 2: Create your Strava API Request URL
- Part 3: Pull Strava API Data into Sheets
- Part 4: More Example API URLs
PART 1: CONNECT TO THE STRAVA API
- Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
- In the list of available connections, find Strava and click Connect.
- You will be directed to strava.com and asked to sign in, if you haven’t already. You’ll also be asked to authorize the connection.
- You’ll then be returned to your Google Sheet, and can verify that your Strava connection is active in the Connections screen.
PART 2: CREATE YOUR STRAVA API REQUEST URL
For our first request, we’ll get some basic information about your Strava account.
- API root: https://www.strava.com/api
- Endpoint: /v3/athlete
Putting it all together, we get the full API Request URL.
We can now enter our values into API Connector and start importing Strava data into Google Sheets.
- In API Connector, click Create, and paste in the Request URL we created above.
- We don’t need any headers so just leave that section as is.
- Under Authentication, choose Strava from the dropdown menu.
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see some information about yourself populate your sheet.
To get more information about your Strava activites, try the following URLs (one at a time).
- Get your own starred segments
- Get a public list of running races
- Get your own activities
To see more API endpoints and example responses, I suggest checking out out the Strava API playground located at https://developers.strava.com/playground/.