Use google sheet to store KEY->VALUE for translations.
![]()
Under the hood, this uses Google sheet API. So you’ll need to set it up.
Follow these instructions: Google Sheet API setup
Your sheet must be formatted like this sample sheet: https://docs.google.com/spreadsheets/d/1VwYU7nTSlwhi2iBSFvYBnuhxPUJdIYwE9qbKuVwDk04
Include the following columns:
Other lang can be used.
Note: Don’t share the spreadsheetID, keep in hidden and authorize your Google Cloud Api to access it.
const translator = await getTranslator({ sheetId: SHEET_ID, sheetName: "test" });
expect(translator.translate("TEST_TAG")).toBe("This is a test");