Case study · Gemstone manufacturing (B2C)
House Of Sylas: from a backlog of Google Sheets to apps for the team and its partners
House Of Sylas makes gemstones and sells them direct to consumers. The business ran on a growing pile of Google Sheets. We turned those sheets into a properly structured PostgreSQL database, then built on top of it: Retool apps for the internal team, a web app for its partners, and integrations with Shopify, Xero and AI. We have worked with them since August 2024.
The challenge
What wasn’t working
Day-to-day data lived in a backlog of Google Sheets that had grown without a plan, so the same information sat in several places and in several shapes.
The team needed tools for its own work, hiring included, and its partners needed a way in that didn’t mean sharing spreadsheets.
Sales ran through Shopify and the books through Xero, and neither talked to the sheets the business actually worked from.
The solution
What we built
Sheets to PostgreSQL
We normalized the backlog of Google Sheets into a well-structured PostgreSQL database that everything else now runs on.
Internal Retool apps
Retool apps for the internal team, including custom apps that streamline hiring.
Partner web app
An external web app where House Of Sylas’s partners work with the business directly, on the same data as the team.
Shopify integration
Shopify connected to the database, so store data sits alongside everything else instead of in a separate export.
Xero integration
Xero connected too, so accounting lines up with operations without copying figures between systems.
AI integrations
AI steps built into the apps and workflows where they save the team manual work.
How it works
How the pieces fit together
- 1
One database
PostgreSQL holds the data that used to be spread across Google Sheets.
- 2
Team apps
The internal team works in Retool apps on that database.
- 3
Partner app
Partners use their own web app on the same records.
- 4
Connected systems
Shopify, Xero and AI services are integrated through their APIs.
The result
What changed
- A backlog of Google Sheets replaced by one structured PostgreSQL database
- The team and its partners each have apps built for their work
- Shopify and Xero connected to the same data as the apps
- In the client’s words, the business can now automate and scale
“Surani and his team played a pivotal role in digitally transforming our company, positioning us for scalable growth.”
More work
More case studies
Have a project like this?
Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.
Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day