Strava and Google Sheets integration

Automatically analyze your full sports performance evolution using your Strava activities, enriched with AI insights and delivered directly to your email — all powered by your own n8n instance. ✨ Why this workflow? Stop manually reviewing your training history. This workflow automates the entire analysis: collecting activities, filtering by date range, comparing progress, generating a structured AI report, storing it, and emailing it to you. Battle-tested:** refined across multiple Strava accounts to ensure strong error handling and stable performance. Fully documented:** each block is cleanly structured; logic is easy to follow. Safe & robust:** handles missing fields, invalid dates, empty ranges, and malformed inputs. Flexible:** change the analysis period (week/month/year/total), language, and recipient in one single node (OPTIONS). Zero manual work:** reports arrive automatically. 🧠 What does the workflow do? Reads your entire Strava activity dataset from Google Sheets. Filters activities by your chosen range (last week, last month, last year, or all time). Formats each activity as “Activity 1, Activity 2, …” (from newest to oldest). Sends the full historical dataset + the previous AI report (if available) to GPT-5-nano. Generates a complete performance report with six sections: Evolution Best improvements Setbacks Performance patterns Current state Recommendations Saves the new report in a separate Google Sheet for long-term tracking. Converts the AI output into clean, professional Markdown → HTML. Sends you a styled email with the final report. 🛠️ Technologies & APIs Used n8n** (cloud or self-hosted) OpenAI** (GPT-5-nano for analysis) Google Sheets API** (activity log + report archive) Gmail/SMTP** (email delivery) Strava data imported into Sheets** (activity database) ⚡ Who is this for? Athletes who want automated tracking of their evolution. Coaches who need structured, periodic reports. Data-driven users who love learning from their training history. Anyone who wants AI-powered insights without subscriptions or external dashboards. n8n fans exploring advanced automations. 🎯 Problems Solved No more manual comparison of activities. Automatic detection of improvements and regressions. A complete evolution report is always stored and searchable. Every analysis is emailed in clean, easy-to-read formatting. Eliminates the need for external reporting tools. 📝 Quick Setup Import the .json workflow into your n8n. Add your credentials: OpenAI API key Google Sheets Email (SMTP or Gmail) Make sure your Strava activities are synced into the main Sheet. Adjust name, email, language, and range in OPTIONS. Run manually or let the scheduler handle it automatically. Also keep in mind that each generated report has an approximate cost of $0.01 in OpenAI API usage. 📦 What’s included? n8n workflow file (.json) Internal documentation inside the flow Automatic report archiving Basic support by email Professional AI-generated performance reports sent directly to you Please note that the price of this workflow may increase in future updates, although all updates will remain free for existing users.

What does this template help with? Save the data of activities recorded and stored in Strava to a Google Sheets document. How it works: We have a Google Sheets spreadsheet where each row represents a Strava activity with the date, reference, distance, time, and elevation. Periodically, the workflow checks the latest activities in our Strava account to see if any are missing from the spreadsheet and adds them to the list. All fields must be properly formatted according to how they are stored in the Google Sheets spreadsheet. Set up instructions Complete the Set up credentials step when you first open the workflow. You'll need a Google Sheets and Strava account. In the 'activities' node, you must enter the name of the file and the sheet where you want to save the imported data. In the 'Strava' node, you must select the corresponding credential. You can adjust the format of dates, times, and distances according to your needs in the 'strava_last' node. The rest of the information is available at sherblog.es Template was created in n8n v1.72.1