Project2025Private/internal platform

Google Workspace Business Platform

A sophisticated internal operations platform built with Google Workspace, Apps Script, and third-party APIs, replacing multiple commercial systems with a tailored platform for operations, logistics, monitoring, official S.A.T. invoicing, reporting, and client-facing workflows.

Overview

A sophisticated internal operations platform built with Google Workspace, Apps Script, and third-party APIs, replacing multiple commercial systems with a tailored platform for operations, logistics, monitoring, official S.A.T. invoicing, reporting, and client-facing workflows.

Role

Systems architect, automation specialist, developer, and technical lead

Outcome / status

Private/internal platform

Client type

Security and transport services company

Year

2025

Problem

The company needed a private operational system that could organize service capture, assignments, status changes, billing, evidence, and GPS visibility without relying on scattered manual steps.

What I built

Build the system in Google Workspace first, using Apps Script and APIs for the core workflows, then evolve the approach toward Railway-style app infrastructure as the requirements grew.

Stack

Google Apps ScriptGoogle WorkspaceJavaScriptGoogle DocsGoogle DriveGoogle CalendarGPS APIsCFDI / SAT workflowsRailway-style app infrastructure

Services

Operations platform, Logistics & dispatch, GPS integrations, Official S.A.T. invoicing, Client-facing features, Workflow automation, Reporting & analytics

Outcome / status

A working internal system that reduced manual coordination, improved traceability, and supported operational reporting and billing.

Notes

Notes

The platform included Google Docs logbooks, Google Drive evidence organization, Google Calendar integration, third-party GPS API integration, automatic GPS location logs for front-facing clients, expense and profit tracking, and billing workflows tied to Facturación CFDI S.A.T.

Next step

Have a project, system, or website that needs a practical build?

If you want something useful rather than performative, that is the right kind of conversation.