# 01: The Client

**SIBECO**

SIBECO is a French company specializing in residential sanitation compliance works. They assess non-conforming sanitation systems and upgrade them into certified, legally compliant installations — often coordinating regional subsidies and financial aid programs on behalf of their clients.

With multiple active field teams and hundreds of properties managed across project stages, SIBECO needed a structured, shared system to handle the full project lifecycle — from initial client intake and formal quoting through on-site expense tracking and final invoicing.

**Operations Partner**  
  
- **Company**: SIBECO  
- **Website**: sibeco.fr  
- **Sector**: Sanitation Compliance (Assainissement)  
- **Operations**: Multi-site field teams + administrative office  
- **Key Contact**: Sofiane Belfar (CEO)  
- **Previous Tools**: Standard spreadsheets, manual data entry  
- **Focus Area**: State subsidy & grant management  
- **500+** Properties brought to compliance  
- **3** Interconnected Google Sheets  
- **14 Days** Delivery timeline from kickoff

# 02: The Challenge

## Fragmented data across disconnected spreadsheets.

SIBECO's workflow spans several distinct steps: lead capture, detailed quoting, field execution, daily expense tracking, and invoicing. When each of these stages lived in separate files, the team faced repetitive data entry, inconsistent document formatting, and difficulty calculating per-job profitability in real time.

The team preferred to stay within Google Sheets — the tools they already knew — rather than adopt a generic enterprise ERP system.

### Challenges:

- **No Central Project Ledger**: Projects lacked a single master record connecting client details, quotes, execution stages, and payment receipts.
- **Manual Document Assembly**: Quotes and invoices were built line by line without standardized catalogue selection or consistent formatting.
- **Delayed Margin Visibility**: Labour, material, and equipment costs were logged separately, making per-job profitability difficult to evaluate in real time.
- **Repetitive Data Entry**: Client details and project reference numbers had to be re-entered manually at each project milestone across multiple files.
- **No Defined Status Pipeline**: There was no formal progression tracking from quote creation through final settlement.
- **Generic Tools Didn't Fit**: Off-the-shelf ERP solutions were overly complex for their workflow.

# 03: The Solution

## A Google Sheets ERP Built Around Their Workflow

Flowbetta built a custom ERP system directly inside Google Sheets using Google Apps Script. The system consists of three interconnected files — each handling a distinct function — that communicate dynamically so data entered once is automatically reflected across all three.

### Files Overview:
1. **ERP Master File**: The central project ledger consolidates client details, stage status, and financial summaries automatically.
   - Structured project ID sequencing
   - Consolidated client and address records
   - Quote amounts and status tracking
2. **BPU Quoting & Invoice Engine**: Allows for dynamic creation of quotes and invoices by selecting project IDs and items from a standardized price catalogue.
3. **Expenses & Cost Tracking**: Records daily expenses and logs them by project, syncing to the master ledger.

### Cross-Sheet Data Flow:
- Data entered in the quoting or expense sheets synchronizes with the corresponding project row in the ERP master.

**Tech Stack**:  
- Google Sheets  
- Google Apps Script  
- Google Drive

# 04: The Process

## From discovery to delivery in 14 days.

The project ran from initial discovery through to system handoff within two weeks.

### Timeline:
- **Day 1**: Workflow discovery & scoping call  
- **Days 2-3**: Technical Alignment and initial architecture setup within Google Drive  
- **Days 3-13**: System development including scripts and synchronization  
- **Day 14**: Handoff and video walkthrough of the finalized system.

# 05: The Impact

## An ERP that replaced scattered files with one connected system.

SIBECO replaced their disconnected spreadsheets with a Google Sheets ERP that connects quoting, project management, and field expense tracking.

### Benefits:
- **Single Project Entry**: Each project is entered once and referenced automatically.
- **Real-Time Cost Visibility**: Costs roll up to the ERP master as expenses are logged.
- **Consistent PDF Documents**: Quotes and invoices are generated from a standardized template.
- **Defined Stage Pipeline**: Each project follows a structured status progression.

## Automating business operations in Google Workspace

We build custom Google Sheets automations, connected project trackers, and document generation workflows tailored to your operational processes.