Skip to main content
Steigern Tech - Technologies Inspire Us
All Case Studies
SPORTS & EDUCATION TRANSFORMATIONOdoo PodEducation

DUFC Case Study: Saving 10 Volunteer Hours Weekly with Odoo & Google Sheets Sync

We took Dublin University Football Club (Trinity Rugby) from Figma to a live Odoo website with Google Sheets fixtures and league tables, AI-built match tables, a club shop and event booking.

Dublin University Football Club: Odoo website with Google Sheets fixtures and AI match tables Project Thumbnail
Client
Dublin University Football Club (DUFC)
Location
Dublin, Ireland / Steigern Client
Industry
Sports & Education
Timeline
8–16 Weeks
Engineering Pod
3 Verified Engineers
Status
Live in Prod
01
100%
Milestone Delivery
On schedule
02
Real-Time
Google Sheets Fixture Sync
Automated
03
AI-Powered
Match Table Creation
Direct in Odoo
Operational Challenges

The Moment That Started It

Dublin University Football Club is the oldest club in the world in continuous existence, founded in 1854. Its website is run by volunteers: students, alumni and committee members who have a match on Saturday and exams on Monday. Every week someone had to update fixtures, results and the league table across seven teams by hand. When that person was busy, the website fell behind and supporters turned up for kick-offs that had moved.

Identified Bottlenecks:
Volunteers found website editing slow and technical
Building each round of fixtures by hand took hours
Club income came through many separate channels
Events were announced but hard to book
The new design existed only as Figma files
Steigern Architectural Solution

Engineering Solution & Architecture

We took Dublin University Football Club (Trinity Rugby) from Figma to a live Odoo website with Google Sheets fixtures and league tables, AI-built match tables, a club shop and event booking.

Architectural Highlights:
Fixtures, results and league tables are kept in a Google Sheet they already know; the Odoo website reads it automatically
Staff describe the round in plain words; AI drafts the match rows in Odoo and flags venue clashes before publishing
One Odoo shop sells merchandise, wine, yearbook ads, memberships and match sponsorships
Events can be filtered by team, type and date, and booked or RSVP'd online
The Figma design was built pixel-close on the Odoo website builder so volunteers can edit pages without code
SYSTEM ARCHITECTURE WORKFLOW

Execution Architecture & System Flow

The end-to-end technical and operational workflow engineered for Dublin University Football Club (DUFC).

STEP 01

Design to build

The club's Figma designs became editable Odoo website pages: home, events, news, fixtures, results, game day, shop and join.

STEP 02

Google Sheets sync

Each team has a tab in one spreadsheet. The website pulls fixtures, results and the AIL league table from it.

STEP 03

AI match tables

An admin types something like "add the November rounds for the 1st XV". The AI drafts the rows, checks College Park bookings and suggests time changes where games clash.

STEP 04

Publish

One click publishes the approved fixtures to the website.

STEP 05

Game day

Supporters buy a €10 match ticket, see the team sheet, donate and join the club from one page.

Dublin University Football Club: Odoo website with Google Sheets fixtures and AI match tables — Flagship System Architecture
Dublin University Football Club (DUFC): Odoo Website Redesign & AI-Powered Fixtures Management
Dublin University Football Club (DUFC) — Overview
DUFC — Overview
Dublin University Football Club (DUFC) — Odoo Website
DUFC — Odoo Website
Dublin University Football Club (DUFC) — Google Sheets Fixtures Tables
DUFC — Google Sheets Fixtures Tables
Dublin University Football Club (DUFC) — AI Match Tables Odoo
DUFC — AI Match Tables Odoo
Dublin University Football Club (DUFC) — Club Shop
DUFC — Club Shop
Dublin University Football Club (DUFC) — Events
DUFC — Events
THE DELIVERY BLUEPRINT

How Steigern Architected & Shipped This Solution

A battle-tested 4-phase agile delivery model combining architectural discovery, rapid prototyping, production hardening, and zero-downtime transition.

01

Architecture & Discovery

Deep-dive technical workshops, system schema profiling, API audit, and non-functional requirements (NFRs) specification.

02

Agile Pod Sprint Delivery

Bi-weekly deliverables with working builds, automated unit/widget testing, CI/CD testflight builds, and daily asynchronous standups.

03

Hardening & Benchmarks

Chaos engineering, concurrency load tests (JMeter/k6), memory profiling, vulnerability scans, and offline resiliency validation.

04

Zero-Downtime Rollout

Canary deployment, multi-region database migration, telemetry alerting setup, staff runbooks, and 24/7 post-launch SLA support.

PROBLEM → SOLUTION TRANSFORMATION

The Real Problem vs What The System Does

A direct 1-to-1 comparison between operational bottlenecks and custom software capabilities engineered for Dublin University Football Club (DUFC).

The Real Problem

Volunteers found website editing slow and technical

What The System Does

Fixtures, results and league tables are kept in a Google Sheet they already know; the Odoo website reads it automatically

The Real Problem

Building each round of fixtures by hand took hours

What The System Does

Staff describe the round in plain words; AI drafts the match rows in Odoo and flags venue clashes before publishing

The Real Problem

Club income came through many separate channels

What The System Does

One Odoo shop sells merchandise, wine, yearbook ads, memberships and match sponsorships

The Real Problem

Events were announced but hard to book

What The System Does

Events can be filtered by team, type and date, and booked or RSVP'd online

The Real Problem

The new design existed only as Figma files

What The System Does

The Figma design was built pixel-close on the Odoo website builder so volunteers can edit pages without code

ENTERPRISE TECH SPECIFICATION

Production Technology Stack

Every library, database engine, and infrastructure provider was audited for latency, stability, and zero vendor lock-in.

Core Technologies

Odoo WebsiteOdoo eCommerceOdoo EventsGoogle Sheets APIAI assistant for fixture generationFigma design handoff
PRODUCTION RESULTS & ROI

Quantified Business Outcomes & Impact

Volunteers update fixtures in a spreadsheet and the website follows, saving volunteers 8–10 hours of manual data entry every match week. • New fixture rounds are drafted in minutes rather than built row by row. • Shop, memberships, sponsorships and event bookings run through one system, processing over €45,000 in unified digital payments and tickets during the first season.

Volunteers update fixtures in a spreadsheet and the website follows, saving volunteers 8–10 hours of manual data entry every match week.
New fixture rounds are drafted in minutes rather than built row by row.
Shop, memberships, sponsorships and event bookings run through one system, processing over €45,000 in unified digital payments and tickets during the first season.

Shipped Project Deliverables & Handover

Odoo Website Design & Development
Google Sheets Integration
AI Implementation
Workflow Automation
FREQUENTLY ASKED QUESTIONS

Frequently Asked Questions

Essential operational and architectural answers regarding the system engineered for Dublin University Football Club (DUFC).

Yes. Here the Odoo website reads each team's fixtures, results and the league table from a shared Google Sheet, so volunteers never edit web pages for scores.
An admin describes the round in plain language. The AI creates the fixture rows, checks venue availability and flags clashes for review before anything goes live.
Yes. The club's Odoo shop sells player memberships, match and lunch sponsorships, position patrons and merchandise with pick-up or shipping options.
PORTFOLIO EXPLORATION

Related Case Studies

View All Stories
EcommerceSwissHardware

SwissHardware: Shopify PC configurator with Odoo inventory sync

SwissHardware customers build a custom PC part by part on Shopify, with compatibility checks and live pricing, while stock is synced both ways with Odoo through an API integration.

100% Milestone DeliverySwissHardware
EducationVed mata gayatri School Fees Management

Ved Mata Gayatri Education Trust: multi-school fee management ERP

One web ERP for eight schools of Ved Mata Gayatri Education Trust, Mansa: fee collection, admissions, staff salaries, expenses and Excel-ready reports across every school and standard.

100% Milestone DeliveryVed mata gayatri School Fees Management
Construction ERP: inventory & stock, purchase, unit/block booking, CRM, document management, WhatsApp automation, AI insights, possession & handoverSargam Group, real estate developer, Gujarat (Sargam Sarita & Sargam Sarita 2.0)

Sargam Group – Construction ERP Case Study

Sargam Group builds residential and commercial projects in Gujarat. Like most developers, its work runs on three tracks at the same time: the site, where material arrives and is used every day; the sales office, where enquiries turn into bookings; and the back office, where approvals, agreements, payments and handovers are managed. Before this project, each track had its own spreadsheets, registers and WhatsApp groups. Steigern Tech built one construction ERP that connects all three, so the site, sales and office work from the same information, from a customer’s first enquiry to the day they receive their keys.

100% One Source of TruthSargam Group

Ready to achieve similar results for your product? Let's engineer your solution.

Connect directly with our senior software architects. We will analyze your architecture, estimate velocity, and formulate a delivery blueprint within 24 business hours.

Request Architectural ScopingExplore Our Full Bench
24-Hour Scoping SLA · Ahmedabad · Melbourne