Company
From CSV Chaos to Real-Time Sync: Why We Built Google Sheets Integration
Every bulk-data feature we'd shipped before this one followed the same pattern: export, edit, re-import, and cross our fingers on formatting. Here's why that had to change.
Every bulk-data feature we'd shipped before this one followed the same pattern: export a CSV, let the merchant edit it, re-import, and cross our fingers on formatting. It worked, technically. It was also the single biggest source of support tickets — malformed columns, wrong encodings, a file edited in the wrong app, a merchant who didn't realize they'd overwritten a teammate's changes because there was no shared, live copy of the data anywhere.
The real problem wasn't the file format
CSV itself was never the issue. The issue was that a CSV is a snapshot, not a living document. Two people can't safely edit the same CSV at once. A CSV can't enforce that a field only accepts one of four valid choices. A CSV doesn't know what the data looked like five minutes ago if someone needs to undo a mistake. We didn't need a better import format — we needed an editing surface with state, validation and history. That's a spreadsheet, specifically Google Sheets, where almost every merchant's team already lives.
The design decisions that mattered
A few choices shaped what shipped:
- Match by handle, not by row position. Rows can be reordered, deleted, or added without corrupting the sync. The handle is the identity; the row is just where it currently sits.
- Format rules never touch values. Refreshing a sheet's dropdowns and validation after a definition change is a separate operation from writing data. A merchant can safely pull in new choices without any risk to what they've already entered.
- Every sync is revertible. Automation that can't be undone is automation most teams are right to be nervous about. Revert was part of the design from day one, not bolted on after an incident.
- Unchanged sheets don't trigger imports. Auto-sync hashes the sheet's contents before importing, so a sheet nobody touched doesn't eat into anyone's import limit or clutter job history.
Where this goes next
Google Sheets sync is the first integration of its kind in the app, and the pattern — a validated, two-way, revertible bridge between Shopify data and a tool merchants already trust — is one we intend to keep building on. The CSV round-trip got merchants most of the way there for years. It was always a workaround. This is the real thing.
