Step 2: Connect Google Sheets

Load previously saved activities from a Google Sheet and later append new activities to the same sheet.

1. Open Load Saved Activities and set Document to [YOUR_ID] and Sheet to [YOUR_ID].
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Load Saved Activities.
3. Open Append to Sheets and confirm Operation is append.
4. Set the column mappings in Append to Sheets to use expressions like ={{ $json.distancia }}, ={{ $json.id }}, and ={{ $json.fecha }}, and set Track to =http://www.strava.com/activities/{{ $json.id }}.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append to Sheets.

Step 3: Set Up Activity Reference Processing

Sort and limit the saved activity references to build a compact list of known IDs for comparison.

1. In Sort Saved Refs, set the Sort Field to Ref.
2. In Limit Saved Records, set Keep to lastItems and Max Items to 10.
3. In Map Saved IDs, add an assignment with Name id, Type string, and Value ={{ $json.Ref }}.

Step 4: Configure Strava Fetch and Deduplication

Pull recent Strava activities, sort and deduplicate them, then limit the results for efficient processing.

1. Open Fetch Strava Activities and set Operation to getAll and Limit to 10.
2. Credential Required: Connect your Strava credentials in Fetch Strava Activities (this node needs credentials but none are configured).
3. In Sort Strava IDs, set the Sort Field to id.
4. In Deduplicate Records, set Compare to selectedFields and Fields to Compare to id.
5. In Limit Strava Records, set Keep to lastItems and Max Items to 10.

Step 5: Set Up Mapping and Filtering Logic

Transform Strava data into your sheet schema and filter out activities already saved.

1. In Map Latest Strava, map fields using expressions: id ={{ $json.id }}, fecha ={{ DateTime.fromISO($json.start_date_local).toFormat('d/M/yyyy') }}, distancia ={{ Math.round($json.distance / 100) / 10 }}, elevacion ={{ Math.round($json.total_elevation_gain) }}, and tiempo ={{ `${Math.floor($json.moving_time / 3600)}:${Math.floor(($json.moving_time % 3600) / 60).toString().padStart(2, '0')}:${($json.moving_time % 60).toString().padStart(2, '0')}` }}.
2. In Filter New Activities, keep the JavaScript logic that compares Map Latest Strava results with Map Saved IDs to filter out duplicates.
3. In Sort Filtered Results, set the Sort Field to id.

Step 6: Configure Output to Google Sheets

Append new activities into your Google Sheet with the correct column mapping.

1. In Append to Sheets, confirm the Columns mapping uses: Kms ={{ $json.distancia }}, Ref ={{ $json.id }}, Fecha ={{ $json.fecha }}, Track =http://www.strava.com/activities/{{ $json.id }}, Tiempo ={{ $json.tiempo }}, and Desnivel ={{ $json.elevacion }}.
2. Verify Append to Sheets connects from Sort Filtered Results so only new items are appended.

Step 7: Test and Activate Your Workflow

Run a manual execution to validate that new Strava activities are detected and appended correctly.

1. Click Execute Workflow to run from Scheduled Run Trigger or test nodes sequentially.
2. Confirm that Filter New Activities returns only new items and Append to Sheets adds rows to the spreadsheet.
3. When satisfied, toggle the workflow to Active to enable the scheduled sync.