Google Drive Web ←→ Google Drive Desktop ←→ Local Folder ←→ Dashboard
                         (D:\)              (Python)      (JSON)

📁 D:\Reyes Contractor (Google Drive Synced)
├── 📁 Financial Statements/
│   └── Audited FS 2020-2024
├── 📁 WoH/
│   └── Work on Hand reports
├── 📁 Planillas/
│   └── Payroll and tax forms
├── 📁 Consultoria de CPA Aguirre/
│   └── Strategic documents
├── 📊 Reyes Contractor FS Rev157_14 .xlsm ⭐
├── 📊 Work on Hand Template 54.xlsm
├── 📄 dynamic_ratios.json
├── 📄 Chart of Accounts.xlsx
└── 📄 8692_reglamento_de_contratos_a_largo_plazo.pdf

import os
import glob

def find_latest_file(pattern: str) -> str:
    """Find the most recently modified file matching pattern."""
    files = glob.glob(pattern)
    if not files:
        raise FileNotFoundError(f"No files match {pattern}")
    return max(files, key=os.path.getmtime)

# Example: Find latest FS file
source_file = find_latest_file("D:\\Reyes Contractor\\Reyes Contractor FS Rev*.xlsm")

import openpyxl

wb = openpyxl.load_workbook(source_file, data_only=True)

# Access specific sheets
balance_sheet = wb['BS']
income_statement = wb['IS']
cash_flow = wb['CF']
ratios_sheet = wb['Ratios']

import json

output = {
    "company": "Reyes Contractor Group",
    "extractedAt": datetime.now().isoformat(),
    "liquidityRatios": [...],
    "profitabilityRatios": [...],
    # etc.
}

with open("public/data/financial_ratios.json", "w") as f:
    json.dump(output, f, indent=2)

https://drive.google.com/drive/folders/{folder-id}

@echo off
echo Syncing from Google Drive...

cd /d "D:\Antigravity Workspace\reyes-construccion-dashboard"

echo Extracting ratios...
python scripts\extract_ratios_from_sheet.py

echo Building dashboard...
npm run build

echo Done!

# Sync and update dashboard
$projectPath = "D:\Antigravity Workspace\reyes-construccion-dashboard"

Set-Location $projectPath

# Extract data
python scripts\extract_ratios_from_sheet.py

# Build
npm run build

Write-Host "Sync complete!" -ForegroundColor Green

import os
from datetime import datetime

file_path = "D:\\Reyes Contractor\\Reyes Contractor FS Rev157_14 .xlsm"
mod_time = os.path.getmtime(file_path)
last_modified = datetime.fromtimestamp(mod_time)

print(f"Last modified: {last_modified}")

def check_for_updates(known_version: str) -> bool:
    """Check if a new version exists."""
    pattern = "D:\\Reyes Contractor\\Reyes Contractor FS Rev*.xlsm"
    latest = find_latest_file(pattern)
    return latest != known_version

GET /api/sync-status

Response:
{
  "success": true,
  "lastSync": "2026-02-06T08:00:00",
  "dataSource": "Reyes Contractor FS Rev157_14 .xlsm",
  "ratiosCount": 46,
  "leadingIndicatorsCount": 10
}