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

If you haven’t connected API Connector to Strava before, you’ll first need to initiate the connection as follows:

1. Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
2. In the list of available connections, find Strava and click Connect.
   
   
3. 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.
   
   
4. 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.

https://www.strava.com/api/v3/athlete

PART 3: PULL STRAVA API DATA INTO SHEETS

We can now enter our values into API Connector and start importing Strava data into Google Sheets.

1. In API Connector, click Create, and paste in the Request URL we created above.
   
   
2. We don’t need any headers so just leave that section as is.
   
3. Under Authentication, choose Strava from the dropdown menu.
   
4. Create a new tab and click ‘Set current’ to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see some information about yourself populate your sheet.
   

PART 4: MORE EXAMPLE API URLS

To get more information about your Strava activites, try the following URLs (one at a time).

• Get your own starred segments

  https://www.strava.com/api/v3/segments/starred

• Get a public list of running races

  https://www.strava.com/api/v3/running_races

• Get your own activities

  https://www.strava.com/api/v3/athlete/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/.