Schedule Trigger Automate

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.

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.

1. 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.