A Python CLI that syncs Swimming Canada's REMS / SportLomo officials registry with Google Sheets. It pulls your club's members, their details and credentials out of REMS into a season's registration sheet, and records deck evaluations from a meet's roster sheet in REMS.
- Save a REMS login per club (or club and role) in the OS keychain; log in with REMS's emailed code, and reuse the session for an hour.
- Refresh members, member details and credentials, to CSV or a sheet tab; on Windows, refresh a season's whole registration sheet with one script.
- Record deck evaluations one at a time, or a whole meet's from its roster sheet, never twice; and check a meet or season's sheets against REMS.
You need Python 3.12+, the Google Cloud CLI, a
REMS login for your club's officials, and a sheet shared with the rems-sync-sa service
account.
git clone https://github.com/swimblocks/rems-sync.git
cd rems-sync
python -m venv .venv && .venv/Scripts/activate # PowerShell: .venv\Scripts\Activate.ps1
pip install -r requirements.txt
python -m src.main auth login --team row # save your REMS login under an aliasNew here? Follow Your first refresh.
docs/, sorted by what each page is for:
- Tutorial: your first refresh.
- How-to: refresh a season's registration sheet, manage saved logins, upload a meet's deck evaluations, record one deck evaluation, set up Google access.
- Reference: CLI, configuration, sheets and CSV files, REMS.
- Explanation: saved logins, logging in to REMS, how deck evaluations are recorded, Google access.
See CONTRIBUTING.md and AGENTS.md. One issue → one branch
({issue-number}-{slug}) → one PR.
MIT © 2026 Gavin Bee.