README.md

strava_club_challenge

Automate the data collection and processing to get user activity data from Strava and import it into Google Sheets.

How to use?

Google spreadsheet

• Each month:
• Duplicate your Google spreadsheet sheet's original_template.
• Rename the sheet original_template to template.
• Set the start day, in the column D2 with format yyyy-mm-dd should be a monday.
• You should have all your users token created beforehand.
• If you have a monthly context, rename your spreadsheet's sheet to yyyy-mm.

Runtime

• Clone repo.
• Double check environment vars on .env
• Build docker image
  • sudo docker build -t container_name:0.0.1 .
• Run
  • docker run --rm --env-file .env -v /Users/full_path/strava_club_challenge_private:/strava_app --entrypoint python container_name:0.0.1 run_strava_club_challenge_in_google_sheets.py

Development Environment

Option 1: Docker and PyCharm pro (Recommended)

• Configure PyCharm: https://www.jetbrains.com/help/pycharm/using-docker-as-a-remote-interpreter.html#summary
• Configure docker vars in PyCharm run configuration: --env-file /Users/absolute/path/strava_club_challenge_public/.env --entrypoint -v /Users/absolute/path/strava_club_challenge_public:/strava_app --rm
• Debug the file that you want.

Option 2: Local

• Create a virtual environment. (conda, venv, etc)
• In Unix-like os export environment vars per session export $(cat .env | xargs)

Configuration from scratch for new project.

• Configure Strava API account
  • The user should be an administrator in the Club.
  • Get Client ID
  • Get Client Secret
• Configure google Spreadsheet
  • Create a project in Google Cloud Platform
  • Enabled Google Sheets API and Google Drive API
  • Create a service Account
  • Generate new key
  • Ensure you have the right spreadsheet template, for example for
    • Google Key: 12bZWyGzkf81sXCXmiWQNQk-OaanoVIXByz3QbsY7Mpo
    • Share the spreadsheet with the service account
• Configure the file .env with your credentials

Permissions

• Each team member should authorize the App and return the authorization code.
  • Open your Strava account:
  • Return your strava_id
  • Authorize the app (It is necessary to authorize both optional rights: private activities, and strava profile):
    • https://www.strava.com/oauth/authorize?client_id=[YOUR_CLIENT_ID]&response_type=code&redirect_uri=http://localhost/exchange_token&approval_prompt=force&scope=profile:read_all,activity:read_all
  • Return the url generated
  • Execute python auth_for_strava_user.py strava_id strava_code to generate the token.

How to contribute?

• Give me love, welcome any improvement.
• Create new github issue for each contributions. e.g.
  • Improve documentation
  • Add requirement file.
  • Deploy in a cloud environment (Azure, AWS or GCP).
  • Implement CI/CD
  • Call/push from/to slack.
  • Improve code quality. PEPs
  • Add features:
    • Cloudword with trips.

Restrictions

• "gspread.exceptions.APIError: {'code': 429, 'message': "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:592854038195'.", 'status': 'RESOURCE_EXHAUSTED', 'details': [{'@type': 'type.googleapis.com/google.rpc.ErrorInfo', 'reason': 'RATE_LIMIT_EXCEEDED', 'domain': 'googleapis.com', 'metadata': {'quota_limit': 'ReadRequestsPerMinutePerUser', 'service': 'sheets.googleapis.com', 'consumer': 'projects/592854038195', 'quota_metric': 'sheets.googleapis.com/read_requests'}}]}"

Base project:

• https://python.plainenglish.io/how-to-automate-a-club-challenge-with-strava-and-google-sheets-for-dummies-3c9ebc018781