Automated ingestion
Synced event CSV files from a Drive folder and game-type subfolders, normalized multiple column names, validated inputs, and recorded import diagnostics.
Shopify integration · Data automation
Tournament Leaderboard
A Liquid leaderboard integrated into an existing Shopify storefront, backed by an automated results pipeline serving 375 players as of a late-August 2026 snapshot.
View live leaderboard ↗
375players · late Aug 2026 snapshot
60+events processed in August 2026
2–3 daysdevelopment and handoff
Product walkthrough
Situation
The problem behind the product
A tournament organizer received a CSV after every event but could not afford the manual effort required to maintain public player history across a busy tournament schedule. As a result, useful historical standings were not offered at all.
Task
What success required
Turn the organizer's existing Drive-and-Sheets workflow into an automated, maintainable service, then place the public experience inside the Shopify site they already managed.
Action
How I built it
Built a configurable scoring pipeline
Stored raw results and season points, supported editable rank rules and date-range views, and recalculated when dates or scoring rules changed.
Integrated the public experience into Shopify
Built the responsive leaderboard and event-history interface in Liquid and inserted it into the client's existing Shopify theme, while retaining a Sheet-based admin workspace, repair tools, hourly sync, tests, and handoff documentation.
Decisions
Trade-offs and judgment
Client-owned Google assets
The Sheet, Drive folder, and Apps Script deployment remain in the client's account. This avoids ownership-transfer problems and keeps long-term administration familiar.
Diagnose bad data instead of silently skipping it
CSV naming differences, missing dates, and failed imports produce visible diagnostics so a nontechnical operator can correct the source rather than inspect code.
Use the storefront already in production
Liquid placed the leaderboard directly inside the existing Shopify theme. Apps Script continued to match the client's data workflow, avoiding a separate website or a larger hosted stack to operate.
Result
What changed
The system served 375 players in a late-August 2026 snapshot and processed more than 60 events in August 2026. The public leaderboard now lives inside the client's existing Shopify site, while automated imports, configurable scoring, and scheduled updates remain in a workflow the client owns.
Tools & platforms
ShopifyLiquidGoogle Apps ScriptJavaScriptGoogle SheetsGoogle Drive APIHTML/CSSCSV ETLScheduled triggersInput validation