python · sheets api
Tradeforce
A 165,000-row Google Sheet that had ground to a halt — moving fast again.
The problem
Tradeforce ran a single Google Sheet that had grown past 165,000 rows. Every edit triggered a wall of array formulas to recalculate, and the file would freeze for minutes at a time. The team had stopped trusting it.
What I built
- Pulled the raw data offline and rebuilt the heavy logic in Python with pandas, where 165k rows is trivial.
- Cleaned, deduplicated and recomputed everything off-sheet, then pushed results back through the Google Sheets API in chunked batches to stay under rate limits.
- Left the team a sheet that looks the same but recalculates instantly — the formulas they feared are gone, replaced by a pipeline they can re-run on demand.