Jardine Studio
SERVICE / WEB DEVELOPMENT / INTERNAL TOOLS

A tool built for how the team actually works.

The team's 'system' is a tab in a Google Sheet. Three people maintain the same data in three places. Pulling a weekly report takes two hours of manual export and pivot. Internal tools turn the spreadsheet into a real workflow: custom Next.js admin when the work is specific, or Retool, Airtable Interfaces, or Refine when the team will own edits after launch.

A FEW BUSINESSES THE STUDIO HAS WORKED WITH
Palisades Lodge of Big Pine logo
The Black Salt Room logo
BLIZZARDFIRE PROTECTION
Bodie Foundation logo
Night Rose Deathcare logo
WHERE IT BREAKS

The team's tool is a tab in a Google Sheet.

Most internal-tool work starts the same way. The team has a workflow that worked at first as a spreadsheet, a Notion table, or a shared doc. The workflow has outgrown the shape, but no one has had time to build the right tool.

  • The team's "system" is a tab in a Google Sheet.

    Sales leads, content calendar, ops queue. Whatever it is, it lives in a sheet, and the team has memorized which column means what.

  • Three people maintain the same data in three different places.

    Sales tracks deals in HubSpot. Ops tracks deliveries in a sheet. Finance tracks invoices in Stripe. Nothing joins them, and the team is doing the joining by hand.

  • Pulling a weekly report takes two hours of manual work.

    Open three tools. Export three CSVs. Paste into a fourth sheet. Re-pivot. Repeat next week. The report is real work, on a clock.

  • The CRM is fine for sales, but ops needs a different view.

    Sales lives in the CRM. Ops needs a view of the same data shaped differently. The CRM does not offer the view, and ops works around it in a spreadsheet.

WHAT IT COSTS

A team that scales operations through spreadsheets pays in hours.

The cost of running operations on the wrong tool is paid every week: in time, in errors, in decisions made on stale data. The cost is invisible because nobody bills for it, but it absorbs a real share of the team's calendar.

  • Hours every week that should be a click.

    Pulling a report, updating a status, sending a notification. Each one is a tiny chore. Multiplied by the number of times the team does them, they become a recurring drain.

  • Decisions made on stale data.

    The sheet was updated Friday. It's Tuesday. The team is making decisions on numbers that were already old when the week started. The right tool would have the data current.

  • Workflows that depend on one person knowing where the sheet is.

    The ops manager goes on vacation. The team can't find the right tab, the right filter, or the right view. The workflow stops because the institutional knowledge walked out of the office.

  • A team that cannot scale operations without hiring around the spreadsheet.

    Growing the business means hiring someone to keep the sheet up to date. The sheet is the bottleneck, and hiring is the wrong fix.

HOW WE DO IT

Five moves that turn a spreadsheet into the right tool.

The studio picks the right shape for the team and the workflow. Sometimes that is a custom Next.js admin. Sometimes it is Retool or an Airtable Interface. The deciding factor is who will own edits after launch and how specific the workflow is.

  • Map the workflow the tool should support.

    Brief and audit: what does the team actually do every week, every day, every hour? The workflow drives the tool, not the other way around.

  • Pick the right shape.

    Custom Next.js admin when the workflow is specific, the data is sensitive, or the brand matters. Retool, Airtable Interfaces, or Refine when the team needs to own edits after launch and the workflow fits a generic platform.

  • Build views around what the team actually does.

    Dashboards, lists, detail pages, action buttons. Each view answers a question the team asks every week. Generic admin panels get cut; purpose-built views stay.

  • Permissions and access for the people who use it.

    Role-based access so admins, ops staff, contractors, and clients each see only what they should. Permissions live in code (custom build) or platform settings (Retool, Airtable).

  • Logging and audit trail.

    Who changed what, when. Especially important when multiple roles touch the same data. Trust in the tool comes from being able to see what happened.

Ops still living in a spreadsheet?

Send the spreadsheet the team uses. The first call decides whether the right answer is a custom build or a low-code platform.

WHAT YOU GET

Outcomes every internal-tool engagement ships with.

Specific deliverables that hold whether the engagement is a single dashboard or a multi-role ops platform.

  • A tool built for how the team actually works.

    Views, actions, and permissions matching the team's real workflow. Not a generic admin panel with the team's data inside.

  • Data in one place, with the right view for each role.

    Sales, ops, and finance each see the slice that matters to them. The same underlying data, surfaced differently per role.

  • A workflow the team can run without the studio in the loop.

    Adding a record, running a report, updating a status. The team owns the tool the day it ships.

THE ENGAGEMENT

How the work moves.

  1. Phase 1: Workflow audit

    Map the team's actual operations: what they do every week, where the data lives now, where the friction is, and who needs which view.

  2. Phase 2: Tool-shape selection

    Custom Next.js admin, Retool, Airtable Interfaces, or Refine picked by workflow specificity, edit ownership, and brand requirement.

  3. Phase 3: Build

    Views, actions, role-based permissions, and integrations to the team's existing data sources. Audit logging set up from the first commit.

  4. Phase 4: Roll out to the team

    Onboarding sessions, role-by-role. Documentation written for the team in the team's language. Admin handoff so the tool is owned the day it ships.

  5. Phase 5: Iterate based on real use

    The first weeks of real usage surface what the brief missed. The studio tunes views, actions, and access where reality differs from the spec.

QUESTIONS

Things worth knowing.

What kinds of internal tools are in scope?
Lead dashboards, content workflows, reporting tools, admin views, ops apps, status boards, approval queues, internal CRUD interfaces. Anything the team is currently doing in a spreadsheet, a shared doc, or by passing files around that would be better as a tool with the right view for each role.
Does the studio build from scratch or use a low-code tool?
Either, picked by how the team will use it. Custom Next.js admin when the workflow is specific, the data is sensitive, or the brand matters. Retool, Airtable Interfaces, or Refine when the team needs to own the edits after launch and the workflow is generic enough to fit a platform. The brief settles which before the build starts.
Who can the team grant access to?
Whoever the team chooses. The studio sets up role-based access so admins, ops staff, contractors, and clients each see only what they should. Permissions live in code (custom build) or in platform settings (Retool, Airtable). The brief settles the role list so access is set up correctly at launch instead of bolted on later.
Can the tool connect to existing systems?
Yes. Internal tools usually pull from the team's existing data: CRM contacts, booking records, payments, content, analytics. The studio wires the integrations so the tool stays current without manual sync. The same patterns used in the CRM-integrations engagement carry over here.
What about reporting and exports?
In scope. CSV exports, scheduled email reports, dashboards that refresh on an interval, alerts on threshold conditions. The tool surfaces the data the way the team actually needs to see it rather than the way the source system happens to expose it.
How much does an internal tool cost?
Scope drives the price. A single dashboard view is different work than a multi-role ops platform with permissions, audit logging, and integrations. The first call sizes the workflow, the data, the roles, and the tool shape before the studio quotes.
ALSO HERE

A tool built for how the team actually works.

Send the spreadsheet the team uses today. The first call settles whether the right answer is a custom build or a low-code platform.