This n8n workflow automates the process of fetching recent cycling or running activities from Strava, filtering out already recorded activities, and updating a Google Sheet with new data. The workflow is scheduled to run every two hours, ensuring your activity logs stay current without manual intervention.
Here’s how it works step-by-step:
1. The Schedule Trigger node initiates the process every 2 hours.
2. The Strava node retrieves the latest 10 activities from your account.
3. The data is processed through a Code node that filters out activities already logged previously, ensuring only new activities are processed.
4. Parallel to this, activities already stored in Google Sheets are fetched and sorted.
5. The workflow compares and removes duplicates based on activity IDs.
6. The new, unique activities from Strava are then formatted and appended to the Google Sheets document.
7. The system maintains a record of the latest processed activity IDs to prevent redundant entries in future runs.
This automation is particularly useful for athletes and fitness enthusiasts who want to maintain an up-to-date log of their activities in Google Sheets without manual effort. It also helps in tracking progress over time and sharing activity data easily.
Ideal use cases include personalized fitness dashboards, automated log updates, and data analysis for sports training or health monitoring.
Reviews
There are no reviews yet.