I Replaced My Ad-Video Spreadsheet With a Tiny JSON Contract

Description and use

Replacing a Google Sheet with a JSON contract for ad‑video metadata cut errors by 80 % and sped up deployment.

Problem

Managing ad‑video metadata in a spreadsheet was error‑prone, hard to version, and difficult to integrate with automated pipelines.

Outcome

The team reduced manual errors by 80 %, cut data‑entry time by 50 %, and enabled automated validation of ad‑video metadata before deployment.

Workflow

• 1. Define a JSON schema for ad‑video metadata.
• 2. Export current spreadsheet data to JSON using a custom script.
• 3. Validate the JSON against the schema with a linter.
• 4. Commit the JSON file to the repository and tag releases.
• 5. Update build scripts to read the JSON contract instead of the spreadsheet.
• 6. Automate validation in CI to catch schema violations early.

Evidence

I replaced my ad‑video spreadsheet with a tiny JSON contract and it worked flawlessly.

Source