Automate Strava Zone 2 Run Logs to Google Sheets Effortlessly

Automate Strava Zone 2 Run Logs to Google Sheets Effortlessly

Transform your training routine by automating the tedious task of manually logging running activities from Strava to Google Sheets. This n8n workflow seamlessly pulls your latest running activities, categorizes them into Zone 2 or 5K test runs, and updates your Google Sheets training log with precision, leaving you more time to focus on your performance.

What This Workflow Does

• Operates on a daily schedule to keep your training logs fresh and up-to-date.
• Utilizes the Strava API to fetch recent activities of the authenticated athlete.
• Processes each activity to calculate pace (min/km) and categorizes them as “Zone 2” or “Test Run” based on sports type, duration, pace, and distance.
• Formats these activities into sheet-compatible fields including date, pace string, moving time, and distance with appropriate labels - ZONA 2 or TEST 5KM.
• Utilizes Google Sheets to identify the upcoming available slots and prevents reprocessing activities by checking an “IDs Registrados” list.
• Ensures efficient record-keeping by appending new Strava activity IDs to the “IDs Registrados” cell.

Use Cases

• Athletes: Automatically log and categorize runs based on their training goals, keeping track of Zone 2 endurance sessions and 5K tests effortlessly.
• Coaches: Simplify client activity tracking and ensure data consistency across multiple athlete logs.
• Data Analysts: Streamline the process of gathering regular running data for performance analysis and insights directly in Google Sheets.

Technical Details

• Integrations: Strava API, Google Sheets API
• n8n Nodes Utilized: Code, Merge, Switch, Sticky Note, HTTP Request, Google Sheets
• Setup Requirements: Strava OAuth2 and Google Sheets OAuth2 credentials for seamless connectivity, and a compatible Google Sheets layout.