Schedule Trigger Automate

Schedule Trigger Automate runs every 2 hours to seamlessly integrate data from Strava into Google Sheets, filtering out duplicates and ensuring only the latest activities are recorded. This workflow streamlines your data management, saving time and enhancing accuracy for tracking fitness activities.

7/8/2025
13 nodes
Medium
schedulemediumschedule triggerstravagooglesheetsremoveduplicatesautomationadvancedcron
Categories:
Schedule TriggeredData Processing & AnalysisBusiness Process AutomationMedium Workflow
Integrations:
Schedule TriggerStravaGoogleSheetsRemoveDuplicates

Target Audience

This workflow is ideal for athletes, fitness enthusiasts, and coaches who want to automate the tracking and analysis of their Strava activities. It is particularly beneficial for:

- Cyclists and Runners: Those who regularly log their workouts on Strava and want to keep a detailed record of their performance.
- Coaches: Professionals who need to monitor their athletes' activities and performance metrics efficiently.
- Data Analysts: Individuals looking to analyze workout data for trends and improvements over time.
- Fitness Enthusiasts: Anyone interested in maintaining a structured log of their physical activities without manual entry.

Problem Solved

This workflow addresses the challenge of manually tracking and recording Strava activities into Google Sheets. It automates the process of:

- Data Retrieval: Automatically fetching the latest workout data from Strava every 2 hours.
- Duplicate Management: Filtering out duplicate entries to ensure a clean and accurate dataset.
- Data Logging: Seamlessly appending new activity data into a Google Sheets document, allowing for easy access and analysis.

By automating these tasks, users save time and reduce the risk of errors in data entry, allowing them to focus more on their training and performance.

Workflow Steps

  • Schedule Trigger: The workflow begins with a scheduled trigger that runs every 2 hours to initiate the process.
    2. Fetch Strava Activities: It retrieves the latest 10 activities from Strava, ensuring the user has the most recent data.
    3. Sort and Filter Data: The activities are sorted by ID, and duplicates are removed to ensure that only unique entries are processed.
    4. Prepare Data for Google Sheets: The relevant fields such as distance, date, elevation gain, and time are extracted and formatted for Google Sheets.
    5. Fetch Previous Entries: The workflow retrieves the last saved entries from Google Sheets to compare against the new data.
    6. Filter New Entries: A custom code node filters out any new Strava activities that have already been logged, ensuring no duplicates are added.
    7. Append Data to Google Sheets: Finally, the new, unique activity data is appended to the specified Google Sheets document, providing a comprehensive and up-to-date record of workouts.

    • Customization Guide

    Users can easily customize this workflow to better suit their needs by:

    - Adjusting Schedule: Modify the schedule interval in the Schedule Trigger node to change how frequently the workflow runs (e.g., every 1 hour instead of 2 hours).
    - Changing Data Retrieval Limits: In the Strava node, adjust the limit parameter to fetch more or fewer activities (e.g., increase to 20 for more data).
    - Modifying Google Sheets Fields: Update the Google Sheets node to include additional fields or change how data is formatted before being logged (e.g., adding a column for workout type).
    - Customizing Filtering Logic: Adjust the code in the Code node for different filtering criteria, such as including activities based on specific types or durations.
    - Changing Document and Sheet IDs: Update the documentId and sheetName parameters in the Google Sheets nodes to log data into a different spreadsheet.

    These adjustments allow users to tailor the workflow to their specific requirements and preferences.