Why a Custom Strava Wrapped Beats the Default
The official Wrapped is short-lived, hard to export, and misses the stats endurance athletes actually care about. Your own version lets you keep the data, rerun it any time, and add cycling- or running-specific views.
Repeatable
Run it monthly or quarterly—not just when Strava ships an update.
Custom metrics
Bike CTL, run volume by shoe, power PRs by duration—add what matters to you.
Shareable cards
Export charts or hero stats to share with your coach or training group.
Own the archive
Keep a year-over-year record so your 2026 Wrapped is ready without hunting screenshots.
Connect Strava to Sheets Automatically (No Scripts)
StrideSync handles the live Strava → Sheets pipeline so you do not fight APIs or Apps Script. Setup takes a few clicks:
Connect Strava + Google Sheets
OAuth once; StrideSync pulls historical activities and keeps them fresh automatically.
Verify the data tab
You get all key fields: distance, time, elevation, heart rate, power, pace, gear, and weather (if available).
Enable refresh cadence
Choose near-real-time webhooks or daily syncs. Retires failed attempts automatically.
Core Metrics & Formulas for a Wrapped Dashboard
Copy these quick formulas into your Wrapped tab (assumes your synced data lives in a sheet named Data with headers).
Total distance (km)
=SUMIF(Data!A:A, ">=2026-01-01", Data!C:C)
Biggest week (km)
=MAX(QUERY(Data!A:C, "select sum(C) group by weeknum(A) label sum(C) ''"))
Fastest 5K (mm:ss)
=MIN(FILTER(Data!H:H, Data!D:D="Run", Data!G:G>=5))
Top climb (elevation gain)
=MAX(Data!E:E)
Most-used shoe/bike
=INDEX(QUERY(Data!J:J, "select J, count(J) group by J order by count(J) desc limit 1", 0),2,1)
Design Ideas: Charts, Highlights, and Shareable Cards
Bring the Wrapped vibes without fighting design tools. Start with these layouts:
Distance, time, elevation, and training days as bold KPI tiles. Add PR badges with tiny stars.
A 12-month column chart of distance and time. Layer pace or power as a trendline.
Create a printable/exportable card for best week, biggest climb, fastest 5K/20-min power.
A compact table of top 10 workouts with distance, time, TSS/effort, and notes.
Build Your Wrapped Dashboard & Make It Yours
Connect StrideSync, duplicate the dashboard tab, and keep your Wrapped view live all year—not just in December.