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. 1

    One database

    PostgreSQL holds the data that used to be spread across Google Sheets.

  2. 2

    Team apps

    The internal team works in Retool apps on that database.

  3. 3

    Partner app

    Partners use their own web app on the same records.

  4. 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.”
Executive, House Of Sylas LLC · 5.0 review on Clutch

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