Skip to content

Retrieves data from Strava and uploads it into a Google spreadsheet

Notifications You must be signed in to change notification settings

anacltd/gears-testing

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Gears testing

This repo contains a codebase that extracts activities from Strava and uploads data into a Google Spreadsheets that looks like this:


+-----------+---------------+-------------------+--------------------+---------------------+----------------------+------------+---------------+-----------------+
|   Name    | Distance (km) | Moving time (min) | Elapsed time (min) | Total elevation (m) |      Start date      |     ID     | Average speed | Average cadence |
+-----------+---------------+-------------------+--------------------+---------------------+----------------------+------------+---------------+-----------------+
| Lunch Run |         13,67 |             74,18 |              77,23 |               132,9 | 2023-03-26T11:12:18Z | 8779455702 |         11,06 |           166,4 |
+-----------+---------------+-------------------+--------------------+---------------------+----------------------+------------+---------------+-----------------+

Here's how to get the needed credentials.

Google spreadsheet

To use the code, you need to create a project in Google Cloud. You'll then need to generate an OAuth 2.0 client ID for a desktop application.
Download the json file containing the credentials and put it into the sheet directory.
You'll also need to create a spreadsheet and to put the ID (that can be found in the URL) in retrieve_data.py.

Strava

Create a Strava app and create a credentials.json file in the strava directory containing the following data:

{
    "client_id": CLIENT_ID,
    "auth_uri": "https://www.strava.com/oauth/authorize/",
    "token_uri": "https://www.strava.com/oauth/token",
    "client_secret": CLIENT_SECRET,
    "redirect_uris":
    [
        "http://localhost"
    ]
}

The first you run the code, this will open a prompt asking you to accept some stuff. Your refresh token will be saved until it expires, at which point the prompt will open again and so on.

About

Retrieves data from Strava and uploads it into a Google spreadsheet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages