Automate Your Strava Activity Tracking to Google Sheets
detail.loadingPreview
Effortlessly log every new Strava activity directly into a Google Sheet. This powerful workflow automatically fetches your latest workouts, filters out duplicates, and formats key metrics for a clean, organized spreadsheet without any manual effort.
About This Workflow
Never miss a beat in your fitness journey with this automated n8n workflow. Designed for athletes and enthusiasts, it provides a seamless connection between your Strava activities and a personalized Google Sheet. Running every two hours, the workflow intelligently retrieves your most recent activities, compares them against previously saved data in your sheet, and only appends new, unique entries. Key information like distance, time, elevation, and a direct link to your Strava activity are meticulously extracted and formatted, creating a centralized and always up-to-date log of your performance. Streamline your data tracking and focus on your next adventure!
Key Features
- Scheduled Automation: Automatically syncs new activities every two hours, ensuring your sheet is always current.
- Duplicate Prevention: Intelligently identifies and skips activities already logged in your Google Sheet, keeping your data clean.
- Rich Data Capture: Extracts and formats crucial metrics like activity ID, date, distance, moving time, and elevation gain.
- Direct Activity Links: Generates a clickable URL to each Strava activity directly within your spreadsheet.
- Customizable Output: Easily adjust the data fields to match your specific tracking needs in Google Sheets.
How To Use
- Set Up Google Sheets Credentials: Ensure you have an active Google Sheets credential configured in n8n. This will be used by both Google Sheets nodes.
- Configure 'activities' Google Sheets Node: This node reads existing data. In the 'activities' node, select your Google Sheet document and the specific sheet ('n8n' by default) where your Strava data is stored. Ensure it's configured to read relevant columns, particularly the 'Ref' column for activity IDs.
- Set Up Strava Credentials: Create a Strava OAuth2 API credential in n8n and select it for the 'Strava' node.
- Configure 'Strava' Node: The 'Strava' node is set to
getAllactivities with alimitof 10. You can adjust the limit if you want to fetch more recent activities per run. - Review 'strava_last' Set Node: This node formats the raw Strava data. Verify the expressions for 'fecha', 'distancia', 'elevacion', and 'tiempo' match your desired output format (e.g., distance in km, time in HH:MM:SS).
- Verify 'Code' Node Logic: The 'Code' node is crucial for de-duplication. It compares new Strava IDs with those already in your Google Sheet. No changes are usually needed here unless your Sheet's ID column name changes.
- Configure 'Google Sheets' Node (Append): In the second 'Google Sheets' node (named 'Google Sheets' which appends data), confirm the 'documentId' and 'sheetName' match where you want to save your new activities. Map the columns ('Fecha', 'Kms', 'Tiempo', 'Ref', 'Track', 'Desnivel') to the corresponding data fields from the previous 'Code' node's output.
- Activate Workflow: Once configured, activate the workflow. It will run automatically every 2 hours as set by the 'Schedule Trigger'.
Apps Used
Workflow JSON
{
"id": "cac4e7f9-1951-4f93-81b6-b4fe94fa4238",
"name": "Automate Your Strava Activity Tracking to Google Sheets",
"nodes": 19,
"category": "Personal",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: cac4e7f9-1951...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Smart Expense Tracking with Telegram & AI
Automate your personal finance management by turning your Telegram chat into an intelligent expense tracker. Simply send a photo of a receipt or a text message, and this workflow uses AI to categorize your spending, extract crucial details, and provide instant summaries.
Send Obsidian Notes as Emails with Dynamic Attachments
This workflow empowers you to transform your Obsidian notes into dynamic emails, complete with custom metadata from YAML frontmatter and automated attachment handling. Seamlessly share your thoughts and files directly from your preferred note-taking environment.
Voice Task to Notion: AI-Powered Processing
This n8n workflow automates the intelligent processing of voice-activated tasks intended for Notion or similar tools. It leverages advanced AI to understand inputs, builds a dynamic knowledge base from them, and logs processing outcomes to Google Sheets. Instantly get alerted via Slack for any errors, ensuring reliable task management.