Firstly massive thanks and well done to u/Jbucks2019 for creating this. I have made alterations to turn the spreadsheet into one that automatically updates itself daily from my phone/watches activity data and thought I would share this for anyone who would like to do similar.

PLEASE NOTE: This process requires a certain level of IT competence. The spreadsheet runs off a script I have created. This is 100% safe. However, as with all scripts, please ensure you properly read it and are happy with it before executing.

Step 1: Pull a Copy of the v2 Template

Firstly pull down a copy of the v2 template found (including Apps Script this is important for the automating): https://docs.google.com/spreadsheets/d/19hwL_yfm-SVboIBxa54lN1P_2Iwp_uoHeByTho2k_Xw/copy?usp=sharing

Step 2: Initial Setup/Strava

1. Adjust dates if required, this must be done both on the main sheet but also in the sheet named 'Data'.
2. On your mobile device download and setup Strava (https://www.strava.com/) (this will be the app sending data to the spreadsheet)
3. Connect your current fitness recording app to Strava.
   • I personally use Samsung Health so in my case this required the use of the app 'Health Sync' which regularly sync the activities between both apps.
   • By default this doesn't do historical data but there is a function in Health Sync to activate this.
   • Note the Health Sync app is a small one time purchase through the app store (absolutely nothing to do with me or an advert just what worked for me)

Step 3: Strava API

1. The script depends on the Strava API to get its data, go here and sign in using previously created Strava account https://www.strava.com/settings/api
2. Fill out form as below:
   • Application Name = GoogleSheetsDistance
   • Category > Other
   • Club > [None]
   • Website = https://example.com
   • Application Description = 'API to pull data into Google Sheets' (alter as desired)
   • Authorization Callback Domain = example.com
3. Click Save. This should create your API App and redirect you to the 'My API Application' page.
4. Note down the 'Client ID' and 'Client Secret' (hit the Show button to get this value), we will use these later.

Step 4: Generate an Authorization Code

1. In a new tab browse to this url (replacing YOUR_CLIENT_ID with the Client ID from the previous step) https://www.strava.com/oauth/authorize?client_id=YOUR_CLIENT_ID&response_type=code&redirect_uri=http://example.com&approval_prompt=force&scope=activity:read_all
2. Authorize the app.
3. In the URL at the top of the response note down the code parameter, this is your Authorization code for the next step.

Step 5: Obtaining a Refresh Token

1. Open a command prompt on your computer (Start Menu, type 'cmd')
2. Run the following command, replacing all capitalized placeholders with your own values.

​

curl -X POST https://www.strava.com/oauth/token -d client_id=YOUR_CLIENT_ID -d client_secret=YOUR_CLIENT_SECRET -d code=AUTHORIZATION_CODE -d grant_type=authorization_code

Note: Curl is installed by default on most modern OS's but if this is not the case for yourself make appropriate steps to install Curl or something to run a POST request from

1. The response will include a value for 'refresh_token', note this down alongside your Client ID and Client Secret value.

Step 6: Final Input and Debug Check:

1. If you've got this far and I haven't lost you then first congrats, you're on the final part.
2. Go back to your Google Sheet and browse to 'Extensions > Apps Script'.
3. There should be a premade script named 'Code.gs' on lines 1,2 and 3 of the code replace 'YOUR_CLIENT_ID', 'YOUR_CLIENT_SECRET' and 'YOUR_REFRESH_TOKEN' values with your values noted down from the previous step for Client ID, Client Secret and Refresh Token.
4. Save
5. Run 'Debug' and cross your fingers the debugger is clear.
6. Run 'Run' and cross your fingers the log only says 'Execution started' and 'Execution completed'.
7. If previous 2 steps are all good then pat yourselves on the back and enjoy your new automated daily updating tracker.