Syncing iOS localization gaps with Google Sheets and GitHub PR placeholders

Fill iOS localization gaps from .strings → Google Sheets and PR with placeholders (GitHub)

This n8n workflow automatically identifies missing translations in .strings files across iOS localizations (e.g., Base.lproj vs fr.lproj) and generates a report in Google Sheets. Optionally, it creates a GitHub PR to insert placeholder strings ("TODOTRANSLATE") so builds don't fail. Supports DRY\RUN mode.

Who’s it for

iOS teams who want fast feedback on missing translations. Localization managers who want a shared sheet to assign work to translators.

How it works

1. A GitHub Webhook triggers on push or pull request. 2. The iOS repo is scanned for .strings files under Base.lproj or en.lproj and their target-language counterparts. 3. It compares keys and identifies what’s missing. 4. A new or existing Google Sheet tab (e.g., fr) is updated with missing entries. 5. If enabled, it creates a GitHub PR with placeholder keys (e.g., "TODOTRANSLATE").

How to set up 1. Import the Workflow JSON into your n8n instance. 2. Set Config Node values like:

json { "GITHUBOWNER": "your-github-user-name", "GITHUBREPO": "your-iOS-repo-name", "BASEBRANCH": "develop", "SHEETID": "<YOURGOOGLESHEETID>", "ENABLEPR": "true", "IOSSOURCEGLOB": "/Base.lproj/.strings,/en.lproj/.strings", "IOSTARGETGLOB": "/.lproj/.strings", "PLACEHOLDERVALUE": "TODOTRANSLATE", "BRANCHTEMPLATE": "chore/l10n-gap-{{YYYYMMDD}}", }