Peloton Analytics Tool for Workout Stats [+Template]
Share
Explore
Archive / Deprecated

icon picker
Scripts

Manually sync data using a Google Apps Script or Python script.
Support for below is deprecated in favor of the Peloton Pack (see for more on how to sync your data using the Peloton Pack).
Google Apps Script
/ One-way data sync from Peloton API to Coda in Google Apps Script
// Author: Al Chen (al@coda.io)
// Last Updated: December 11th, 2021
// Notes: Assumes you are using the V8 runtime (https://developers.google.com/apps-script/guides/v8-runtime)
// Coda's library for Google Apps Script: 15IQuWOk8MqT50FDWomh57UqWGH23gjsWVWYFms3ton6L-UHmefYHS9Vl
// See full writeup here:

//////////////// Setup and global variables ////////////////////////////////

CodaAPI.authenticate('YOUR_CODA_API_KEY')
CODA_DOC_ID = 'YOUR_CODA_DOC_ID'
PELOTON_USERNAME = 'YOUR_PELOTON_USERNAME'
PELOTON_PASSWORD = 'YOUR_PELOTON_PASSWORD'

////////////////////////////////////////////////////////////////////////////

var base_url = 'https://api.onepeloton.com'
var creds = auth()
var options = creds[0]
var userID = creds[1]
CODA_TABLE_NAME = 'Workouts'
var codaFriendsWorkoutTable = 'Friend Workouts'

function runPelotonSync() {
getPelotonWorkouts()
getPelotonInstructors()
getFriendWorkouts()
}

// Current workout IDs
function getWorkoutIds() {
var currentWorkoutIds = []
var currentRows = []
var pageToken
do {
var response = CodaAPI.listRows(CODA_DOC_ID, CODA_TABLE_NAME, {limit: 500, pageToken: pageToken});
var currentRows = currentRows.concat(response.items);
pageToken = response.nextPageToken;
} while (pageToken);
currentRows.map(function(row) {
currentWorkoutIds.push(row['name'])
})
return currentWorkoutIds
}

// Get workouts from Peloton API
function getPelotonWorkouts() {
var workoutData = {}
var page = 0
do {
var workouts = JSON.parse(UrlFetchApp.fetch(base_url + '/api/user/' + userID + '/workouts?limit=100&page=' + page, options), replacer)
workouts['data'].map(function(workout) {
var workoutId = workout['id']
workoutData[workoutId] = {}
var workoutSummary = JSON.parse(UrlFetchApp.fetch(base_url + '/api/workout/' + workoutId, options), replacer)
var workoutPerformance = JSON.parse(UrlFetchApp.fetch(base_url + '/api/workout/' + workoutId + '/performance_graph?every_n=1000', options), replacer)
workoutData[workoutId].summary = workoutSummary
workoutData[workoutId].performance = workoutPerformance
})
page++
} while (workouts['data'].length > 0)

// Remove workouts that already exist in Coda
var currentWorkoutIds = getWorkoutIds()
for (var i = 0; i < currentWorkoutIds.length; i++ ) {
if (Object.keys(workoutData).indexOf(currentWorkoutIds[i]) !== -1) {
delete workoutData[currentWorkoutIds[i]]
}
}

// Push new workouts to Coda
var rows = []
for (workout in workoutData) {
var cells = []
cells = [
{'column': 'Workout ID', 'value': workout},
{'column': 'Date', 'value': workoutData[workout]['summary']['created_at']},
{'column': 'Workout Type', 'value': workoutData[workout]['summary']['fitness_discipline']},
{'column': 'Difficulty', 'value': workoutData[workout]['summary']['ride']['difficulty_estimate']},
{'column': 'Duration', 'value': workoutData[workout]['summary']['ride']['duration']},
{'column': 'Class Thumbnail', 'value': workoutData[workout]['summary']['ride']['image_url']},
{'column': 'Instructor ID', 'value': workoutData[workout]['summary']['ride']['instructor_id']},
{'column': 'Total Ratings', 'value': workoutData[workout]['summary']['ride']['overall_rating_count']},
{'column': 'Workout Name', 'value': workoutData[workout]['summary']['ride']['title']},
{'column': 'Total Workouts', 'value': workoutData[workout]['summary']['ride']['total_workouts']},
{'column': 'Start Time', 'value': workoutData[workout]['summary']['start_time']},
{'column': 'Leaderboard Rank', 'value': workoutData[workout]['summary']['leaderboard_rank']},
{'column': 'Leaderboard Users', 'value': workoutData[workout]['summary']['total_leaderboard_users']},
{'column': 'Status', 'value': workoutData[workout]['summary']['status']},
{'column': 'Workout Description', 'value': workoutData[workout]['summary']['ride']['description']},
{'column': 'Avg Output (kj)', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['average_summaries'][0] === 'undefined' ? '' : workoutData[workout]['performance']['average_summaries'][0]['value'])},
{'column': 'Avg Cadence', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['average_summaries'][1] === 'undefined' ? '' : workoutData[workout]['performance']['average_summaries'][1]['value'])},
{'column': 'Avg Resistance', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['average_summaries'][2] === 'undefined' ? '' : workoutData[workout]['performance']['average_summaries'][2]['value'])},
{'column': 'Avg Speed (mph)', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['average_summaries'][3] === 'undefined' ? '' : workoutData[workout]['performance']['average_summaries'][3]['value'])},
{'column': 'Total Output (kj)', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['summaries'][0] === 'undefined' ? '' : workoutData[workout]['performance']['summaries'][0]['value'])},
{'column': 'Distance (mi)', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['summaries'][1] === 'undefined' ? '' : workoutData[workout]['performance']['summaries'][1]['value'])},
{'column': 'Calories (kcal)', 'value': (workoutData[workout]['performance']['average_summaries'].length < 1 || typeof workoutData[workout]['performance']['summaries'][2] === 'undefined' ? '' : workoutData[workout]['performance']['summaries'][2]['value'])}
]
rows.push({'cells': cells})
}
CodaAPI.upsertRows(CODA_DOC_ID, CODA_TABLE_NAME, {rows: rows});
Logger.log('Added ' + rows.length + ' workouts')
}

// Get instructors from Peloton API
function getPelotonInstructors() {
var codaInstructorsTable = 'Instructors'
var currentInstructorIds = []

// Get current instructors in Coda
var currentInstructors = CodaAPI.listRows(CODA_DOC_ID, codaInstructorsTable).items
currentInstructors.map(function(instructor) {
currentInstructorIds.push(instructor['name'])
})
var instructors = JSON.parse(UrlFetchApp.fetch(base_url + '/api/instructor?limit=100', options), replacer)['data']

// Remove instructors that already exist in Coda
var newInstructors = []
instructors.map(function(instructor) {
if(currentInstructorIds.indexOf(instructor['id']) == -1) {
newInstructors.push(instructor)
}
})

// Push new instructors to Coda
var rows = []
newInstructors.map(function(instructor) {
var cells = []
cells = [
{'column': 'Instructor ID', 'value': instructor['id']},
{'column': 'Image URL', 'value': instructor['image_url']},
{'column': 'Background', 'value': instructor['bio']},
{'column': 'Name', 'value': instructor['name']},
{'column': 'Instagram', 'value': instructor['instagram_profile']},
{'column': 'Twitter', 'value': instructor['twitter_profile']},
{'column': 'Quote', 'value': instructor['quote']},
{'column': 'Spotify Playlist', 'value': instructor['spotify_playlist_uri']},
{'column': 'Peloton Username', 'value': instructor['username']}
]
rows.push({'cells': cells})
})
CodaAPI.upsertRows(CODA_DOC_ID, codaInstructorsTable, {rows: rows});
Logger.log('Added ' + rows.length + ' instructors')
}

// Get friends you are following
function getFriendsData() {
var friends = JSON.parse(UrlFetchApp.fetch(base_url + '/api/user/' + userID + '/following', options), replacer)
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.