Peloton Stats to Google Sheets with Data Visualization through Seaborn and Plotly
Problem: 2 peloton users were looking for a way to track their metrics in a way that was readable and available
Solution: this script. I personally run this at set intervals on a raspberry pi, so access to their data is usable at virtually all hours.
Here's how it works. The code relies on first having built a csv file which contains the headings of 'name', 'username', 'email', and 'password' (for Peloton). The script pulls data from this file and then logs into peloton. From there, it downloads the users CSV data with all of their workout data. For my specific needs, we only cared about cycling data (which you will notice in the code). Several calculations are performed and some clean up is completed on the dataframes. That data is then passed into the user's assigned Google Sheet (which also includes their interactive 'goal' cell used for pace calculations [this resets on the first of each year]. Since I am running on a raspberry pi, I use SMTP to send an email to each user at the end of the day with a daily wrap email.
The script utilizes several dependencies (noted in the code itself). One of the dependencies is based on the google sheets API. Information can be found here: https://developers.google.com/sheets/api
2.1k Feb 18, 2021
239 Jan 8, 2023
1 Dec 11, 2021
4 Oct 12, 2022
1.6k Jan 8, 2023
5 Aug 28, 2022
7 Apr 5, 2022
5 Jun 2, 2022
14 Aug 14, 2022
2 Jun 15, 2021
2 Jun 7, 2022
6.7k Jan 9, 2023
21 Aug 26, 2022
3 Jul 9, 2022
1.7k Dec 26, 2022
12.7k Jan 5, 2023
2.7k Dec 30, 2022