GCALIMPORTER

'GCAL IMPORT' reads Strava activities and imports them as events into Google Calendar.

When you click "GCAL IMPORT"...

• GCALIMPORTER asks for authorization to access your strava activities. This is done via an access token which is deauthorized when the page is closed or refreshed. This step requires a pop-up window from Strava (the authentication provider). Passwords are never visible to this app.

• Once authenticated, your strava activities will be read. If you have a lot of activities, this may take a few minutes.

• The activities are then converted to calendar events.

• After the Strava download starts, in parallel, GCALIMPORTER asks for authorization to access your Google Calendar account -- again via token. As before, passwords are never visible to this app.

• A secondary 'strava.import' calendar is created and your activities uploaded to it. Your primary calendar is never accessed or modified in any way. The secondary calendar can be deleted at any time if you don't like it.

• If the 'strava.import' calendar already exists (e.g., running this app multiple times), the existing calendar will be read, new activities added, and existing activities updated with any edits made in Strava since the prior upload.

• If the import process is interrupted or times out, simply refresh the page and restart GCAL IMPORT. The app will figure out which activities have not yet been imported and upload them.

Special effort was made to ensure privacy and security during the development of this app. All authorizations, access tokens, and data are deleted when the web page is closed or refreshed; no data are retained or saved on any permanent storage medium. The site enforces SSL for secure communications.

If you experience any bugs or issues, please send an email to: gcalimporter@outlook.com

The training log contains the following by default:

Log sheet with all Strava activities

Graphs of all activities by year, both distance and time

Graphs of cumulative ride and run mileage over the months of the year, to see how your mileage trend compares with prior years

Graph of max distance to see distribution of ride lengths over the years

Graphs of average speed (ride) and average pace (run) over the years. If you've titled you're activities similarly for similar activities (e.g., a route name), you can set a filter in the pivot table to look at average speed/pace for just that route

Table of gear mileage as recorded in Strava

After download and population of the spreadsheet is complete, copy the spreadsheet url in the black status window to a new browser window, and download or save the displayed sheet to your Google Drive. From there you can edit it as desired.

All charts are based on the accompanying pivot tables. To see a different activity type (e.g., trail run instead of run), edit the pivot table and change the filter to the desired activity type. (helps if you already understand a bit about pivot tables...)

Contact me if you're interested to see other charts preconfigured by default or have any other suggestions: gcalimporter@outlook.com