strava_club_challenge

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

Configuration Steps

• Clone repo.
  • Install libraries gspread, pendulum
• Configure Strava API account
  • Get authorization code
• Configure google Spreadsheet
  • Get Google Key: 12bZWyGzkf81sXCXmiWQNQk-OaanoVIXByz3QbsY7Mpo
  • Ensure you have the right spreadsheet template.
  • Configure Google authentication, choose between Service Account and OAuth Client

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 auth_for_strava_user.py to generate the token.

Next Steps

• Give me love, welcome any improvement.
• Deploy in a cloud environment (Azure, AWS or GCP).
• Call from slack.
• Improve code quality.
• 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