Programmatic Google Sheets Formatting for Financial Reports
An SMB accounting/fintech platform
Overview
A reusable Google Sheets API request payload that programmatically applies a branded visual style to generated financial spreadsheets, fonts, header colours, text wrapping and column sizing, as part of an automated cash-flow / “ezcash” report flow.
Why It Exists
The platform generates financial reports into Google Sheets automatically. Hand-formatting each one is unscalable and inconsistent, so styling had to be expressed once as data and applied on every run.
What We Built
A main.json batchUpdate payload composed of repeatCell requests that set a Roboto font across the sheet, apply a dark-navy brand colour to the header row, enable text wrapping, and size columns. The payload uses Make/Integromat-style templating tokens ({{1.sheetId}}, {{var.input.column_length}}) so the same styling definition adapts to any sheet and dynamic column count at runtime.
Technologies & Approach
The Google Sheets API spreadsheets.batchUpdate request model expresses formatting declaratively as JSON, embedded in a low-code automation scenario that injects the live sheet ID and dimensions. This keeps presentation logic out of code and trivially reusable across report types.
Outcome / Impact
Gave the report-generation pipeline a single, consistent, brand-aligned styling step that runs automatically. A small but practical building block showing how presentation can be templated and driven by data in a no-code/low-code stack.
Capabilities Demonstrated
- Declarative, API-driven document and spreadsheet styling
- Parameterised templates that adapt to dynamic data shapes
- Integrating presentation logic into low-code automation pipelines