@el-j/google-sheet-translations is an open source NPM package and GitHub Action for bidirectional translation synchronization between Google Sheets and local JSON/TypeScript files with automated translation capabilities.
Managing translations across static site generation (SSG) projects often creates friction between non-technical contributors and developers. This tool bridges the gap by linking collaborative Google Sheets directly to Git repositories and CI/CD pipelines.
Supports single-sheet and Google Drive folder modes, automated machine translation formula injection, bidirectional key push, strict locale validation, manifest generation, and end-to-end TypeScript types.
Node.js, TypeScript, Google Sheets API, GitHub Actions, Vitest, NPM