Log Strava zone 2 and 5K test runs to Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs on a schedule (every day). Along the way it connects Google Sheets. It also calls strava.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- Fetch Runner Activities (HTTP Request): calls strava.com
- Loop Over Activities (Loop Over Items (Split in Batches)): loops over the items in batches
- Calculate Pace Min per Km (Code): runs custom JavaScript code
- Route by Custom Rules (Switch): routes items into 2 branches
- Clean and Classify Race Data (Code): runs custom JavaScript code
- Read Rows from Sheet (Google Sheets): uses Google Sheets
- Clean and Classify Race Test Data (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Dispatch Sheet Data (Code): runs custom JavaScript code
- Update Row in Sheet (Google Sheets): update
Services it uses
HTTP calls to: strava.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This scheduled workflow pulls your latest running activities from Strava, classifies them as Zone 2 runs or 5K tests based on pace and distance, and writes the formatted results into specific cells in a Google Sheets training log while tracking…