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
3.2k Jan 04, 2023
16 Nov 26, 2022
145 Dec 20, 2022
78 Aug 23, 2022
1 Nov 20, 2021
22 Dec 21, 2022
2 Jul 30, 2022
1 Nov 17, 2021
820 Jan 06, 2023
27 Dec 03, 2022
4 Jun 12, 2022
11 Dec 05, 2022
3 Jun 18, 2022
185 Dec 31, 2022
5 Sep 26, 2022
14 Oct 08, 2022
654 Jan 09, 2023
3 Jan 03, 2023
27 Nov 06, 2022
169 Dec 21, 2022