Automate Your Strava Activity Logging to Google Sheets
detail.loadingPreview
Effortlessly sync your Strava activities to a Google Sheet with this automated workflow. Track your kilometers, track links, and personal bests automatically, ensuring your data is always up-to-date and organized.
About This Workflow
This n8n workflow automates the process of fetching your latest Strava activities and logging them into a designated Google Sheet. It runs on a schedule, ensuring your activity data is continuously updated. The workflow retrieves your recent activities from Strava, processes them to extract key information like distance, date, duration, and elevation gain, and then appends this data to your Google Sheet. Crucially, it includes a duplicate check to prevent redundant entries, and the code node transforms the raw Strava data into a user-friendly format for your spreadsheet. This setup is perfect for athletes who want a reliable, hands-off way to maintain a detailed log of their training and adventures.
Key Features
- Automated Data Sync: Fetches your latest Strava activities periodically.
- Duplicate Prevention: Intelligently identifies and skips activities already logged.
- Customizable Data Fields: Logs key metrics like distance, time, elevation, and provides a direct track link.
- Flexible Scheduling: Easily set the frequency of data synchronization to suit your needs.
- Seamless Google Sheets Integration: Appends data directly to your chosen Google Sheet.
How To Use
- Configure Schedule Trigger: Set the
Schedule Triggernode to your desired interval (e.g., every 2 hours). - Connect Strava: Authenticate the
Stravanode with your Strava account to fetch your activities. - Set Up Data Processing: Use the
strava_lastnode to transform raw Strava data into desired fields (distance, date, time, elevation, ID). - Remove Duplicates: Employ the
Remove Duplicatesnode to ensure each activity is logged only once, using the activity ID as the comparison field. - Filter New Activities: Utilize the
Codenode to compare fetched Strava activities against previously saved ones (this assumes a previous run has saved data) and only pass through new activities. - Log to Google Sheets: Configure the
Google Sheetsnode by providing your Google Sheet'sdocumentIdandsheetName. Map the processed Strava data to your desired column headers (Kms, Ref, Fecha, Track, Tiempo, Desnivel). - Save Previous Activity IDs: Connect the
strava_lastnode's output to a node that saves the 'id' field for the next iteration. This snippet implies a 'saved_last' node is used previously for this purpose, which is crucial for the duplicate filtering logic.
Apps Used
Workflow JSON
{
"id": "f0e1df00-c21c-4717-bd92-ccfc8848b982",
"name": "Automate Your Strava Activity Logging to Google Sheets",
"nodes": 26,
"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: f0e1df00-c21c...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Automate Your Daily Briefing: News, Emails, and Tasks
Streamline your day by automatically fetching the latest news from Times of India, important emails from your Gmail, and your upcoming Todoist tasks. Get a consolidated, beautifully formatted daily digest delivered straight to your inbox.
AI Music Generator with Suno V3.5 (KIE.ai)
This n8n workflow automates AI music generation using the KIE.ai API, powered by the Suno V3.5 model. Users simply submit music prompts, styles, and titles via a web form, and the system handles real-time generation and delivery of the final audio output. It's perfect for quickly creating custom music for various needs.
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.