{"_id":"@colorix/localize-google-spreadsheet","_rev":"8-7628b7518b001506d771255d6c8f0f30","name":"@colorix/localize-google-spreadsheet","dist-tags":{"latest":"3.5.5"},"versions":{"3.5.0":{"name":"@colorix/localize-google-spreadsheet","version":"3.5.0","keywords":["google","spreadsheets","api","localization","android","ios"],"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"license":"ISC","_id":"@colorix/localize-google-spreadsheet@3.5.0","maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"dist":{"shasum":"c978a6247c5f215a91621a9ed52926513836899f","tarball":"https://registry.npmjs.org/@colorix/localize-google-spreadsheet/-/localize-google-spreadsheet-3.5.0.tgz","fileCount":8,"integrity":"sha512-ULiT1XZ8ZNHKdZ44/ONxADe+d/kMSxdRlzCpOIbqR1IAylJ6HNVIpvcw9WiJny69C20F7PdHmRPV2vIfudtDow==","signatures":[{"sig":"MEUCIQDG98AoFXKxIBwg/0UMlKZuy/f2BT56PIaR+Sdd6S4lWgIgX6Ol6IEuR9qbx4RSxLj3IxrgEfbMoo9YdILgw9zHnVw=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22930},"main":"index.js","gitHead":"079891d6067bf406af5536f60bb8fdc53f961baf","scripts":{"test":"./tests/all.js"},"_npmUser":{"name":"michaelcara","email":"michael.caraccio@colorix.com"},"repository":{"url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git","type":"git"},"_npmVersion":"6.14.15","description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","directories":{"doc":"doc","test":"tests"},"_nodeVersion":"12.22.7","dependencies":{"q":"0.9.2","mkpath":"0.1.0","google-spreadsheet":"3.1.15"},"_hasShrinkwrap":false,"devDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/localize-google-spreadsheet_3.5.0_1636577862506_0.46500777772998436","host":"s3://npm-registry-packages"}},"3.5.1":{"name":"@colorix/localize-google-spreadsheet","version":"3.5.1","keywords":["google","spreadsheets","api","localization","android","ios"],"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"license":"ISC","_id":"@colorix/localize-google-spreadsheet@3.5.1","maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"dist":{"shasum":"4a9191f516a8801ec1569d8900a4e2b5ce5e400b","tarball":"https://registry.npmjs.org/@colorix/localize-google-spreadsheet/-/localize-google-spreadsheet-3.5.1.tgz","fileCount":8,"integrity":"sha512-N6bZnnOCU+7CMdaPhhnl5D0NB5s3evAVO9rpCayoS1TIWqNIZG14pr1aCNAcwgZ25zCTcmf2y+OwCWZE2XfBqg==","signatures":[{"sig":"MEUCIESzAmXAF3IzjhzqtKMsMVX94opWJ9MClLrn1ifXYvVfAiEAhqK6uRljQBrBt2hzQXDeowmrtSoQcKEPh80Upe9EWJY=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22948,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhzdeUCRA9TVsSAnZWagAAqRgP/1DMH8enD0Qo11RSs38n\ny+/DxtjUDiovKgtk6gGMqrbLoR//oU4xRQE4Oek/1WgdnRddiYQlrq+vd0Nz\nWmxesFQW0QIkiJ9fEitbZ8z+br3mLFdyFJK1dwX8DQWfyn+TAExwxE3SJ/lX\nbLIkOvofACEvIblu+u2r+mCXIe5uL4QyDteS2XpBddDFh/+wN7GiIaiumdxZ\n0+eGt/lq6R3ungwz7GHifg+Y+daXkQH344Z3yZIrlQamB6XsE2OUMU5egsTx\nb8XLyZZZUqVZUPRBFvanXVGDK7VwNAn2xBz3akzeK3DPOqyy3+iniukCKg4O\n6cHKI2vSaNuarruBN2KFoEIPwzR+lDm/dDwxwTtoTmvj4J0J6v1t8lHx+aCf\nroXWmQV6kcDBEwYfXhXM9F7m58MS1C1ssCtzEOJBE7p32g3ZYqc1cJESP4at\nhU7fF99OPafXKzfrckYsPIWbB4exAETux8Mui9xs8TyscytMXiWvSMbfLKMI\n+DYR7ckkgtIUFfTdc5KwpbCudrKAGZAAodEqs1WxtrLluKmFFx2g+YH0dbWf\nbzu5GxL1Ly13hFcb6ynmIPCIbTc/Tj6rfXRqUn8H+pYUQC0mc1ZKy0E+wxqR\nN+C8Z7MZeBQkW/EW/bDs/lTw2BSJsFw9YdTJT7RiSsFM/GdiASUsG/6ye7ra\nB9ln\r\n=X/eI\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"3a8087e6e8e0b37b42113dd426dee2d1934ff41e","scripts":{"test":"./tests/all.js"},"_npmUser":{"name":"michaelcara","email":"michael.caraccio@colorix.com"},"repository":{"url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git","type":"git"},"_npmVersion":"6.14.15","description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","directories":{"doc":"doc","test":"tests"},"_nodeVersion":"12.22.7","dependencies":{"q":"0.9.2","mkpath":"0.1.0","google-spreadsheet":"3.1.15"},"_hasShrinkwrap":false,"devDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/localize-google-spreadsheet_3.5.1_1636578614728_0.598521875241601","host":"s3://npm-registry-packages"}},"3.5.2":{"name":"@colorix/localize-google-spreadsheet","version":"3.5.2","keywords":["google","spreadsheets","api","localization","android","ios"],"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"license":"ISC","_id":"@colorix/localize-google-spreadsheet@3.5.2","maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"dist":{"shasum":"8d015bca720c92c02ce51c3dfcc3da5f67ef0aad","tarball":"https://registry.npmjs.org/@colorix/localize-google-spreadsheet/-/localize-google-spreadsheet-3.5.2.tgz","fileCount":8,"integrity":"sha512-EQLUg3+VII5OmAiiTKXzJanoUCpaW10bBYFhP3wJiX5fxStkzMygVFqQd0r8QvZzEsMkq5SdAYCqqLEgZr/Wgw==","signatures":[{"sig":"MEUCIG7Mu2IikSHxJfy8d+qHT0J8Oxk7HECjxfVGkRoP2CDpAiEAyQhsCzMQREM+yPMrGCoCSZVZSAfW0gGymYE2Md7sfMY=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":22950},"main":"index.js","gitHead":"6aff7236ae01cb21088c124d2d8fec8ca4793ef0","scripts":{"test":"./tests/all.js"},"_npmUser":{"name":"michaelcara","email":"michael.caraccio@colorix.com"},"repository":{"url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git","type":"git"},"_npmVersion":"11.4.1","description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","directories":{"doc":"doc","test":"tests"},"_nodeVersion":"24.1.0","dependencies":{"q":"^2.0.3","mkpath":"^1.0.0","google-spreadsheet":"^4.1.4"},"_hasShrinkwrap":false,"devDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/localize-google-spreadsheet_3.5.2_1749523028858_0.3623845243147361","host":"s3://npm-registry-packages-npm-production"}},"3.5.3":{"name":"@colorix/localize-google-spreadsheet","version":"3.5.3","keywords":["google","spreadsheets","api","localization","android","ios"],"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"license":"ISC","_id":"@colorix/localize-google-spreadsheet@3.5.3","maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"dist":{"shasum":"1bd8122027d411104f9d5ffdb517dfcde04b75c1","tarball":"https://registry.npmjs.org/@colorix/localize-google-spreadsheet/-/localize-google-spreadsheet-3.5.3.tgz","fileCount":8,"integrity":"sha512-bCE5X5ynYTip2aKJROLLuNXykWWuJfgnrbJUqCJjhS3BJVHR/aU8BmHtwZJA3WuiN+PmFKaJuL4T26If8WMFuw==","signatures":[{"sig":"MEUCIHiV7zYDp9MjRdOAWOFH7j/iPixf9bnGjOcxmxJehFHaAiEAlziXKBb1dSpKACUu1cS268kgp6aCrda8zJ9HJtfWlUk=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":23007},"main":"index.js","gitHead":"6b978f56fa477313ed88b3ff25f777c2dcb5884a","scripts":{"test":"./tests/all.js"},"_npmUser":{"name":"michaelcara","email":"michael.caraccio@colorix.com"},"repository":{"url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git","type":"git"},"_npmVersion":"11.4.1","description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","directories":{"doc":"doc","test":"tests"},"_nodeVersion":"24.1.0","dependencies":{"q":"^2.0.3","mkpath":"^1.0.0","google-spreadsheet":"^4.1.4"},"_hasShrinkwrap":false,"devDependencies":{},"_npmOperationalInternal":{"tmp":"tmp/localize-google-spreadsheet_3.5.3_1749523677560_0.834685531043704","host":"s3://npm-registry-packages-npm-production"}},"3.5.4":{"name":"@colorix/localize-google-spreadsheet","version":"3.5.4","keywords":["google","spreadsheets","api","localization","android","ios"],"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"license":"ISC","_id":"@colorix/localize-google-spreadsheet@3.5.4","maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"dist":{"shasum":"366733cb73252a689498d77474a8465ce57383eb","tarball":"https://registry.npmjs.org/@colorix/localize-google-spreadsheet/-/localize-google-spreadsheet-3.5.4.tgz","fileCount":9,"integrity":"sha512-QEq1gq1W+Z0tUR9+kZYlOjex4N7fCAayB8r2nqK+p8GaALc5APEoH32IpMvWapaIVQGI69vvo21FLYrffzM12Q==","signatures":[{"sig":"MEQCIAK/m+ocg+JvrjLRJKqRCTBbDX797Li2MfhuJmWpgbdEAiB/QNwKB9izfbC9IxZ/F+dKkJHckR5eMZxh3sS9Yc1g9Q==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":24408},"main":"index.js","gitHead":"128c156f53de970c94862f2b8c91f3f1677fb608","scripts":{"test":"./tests/all.js"},"_npmUser":{"name":"michaelcara","email":"michael.caraccio@colorix.com"},"repository":{"url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git","type":"git"},"_npmVersion":"11.4.1","description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","directories":{"doc":"doc","test":"tests"},"_nodeVersion":"24.1.0","dependencies":{"q":"^2.0.3","mkpath":"^1.0.0","google-spreadsheet":"^4.1.4","google-auth-library":"^9.15.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/localize-google-spreadsheet_3.5.4_1749525224202_0.5153273492785375","host":"s3://npm-registry-packages-npm-production"}},"3.5.5":{"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"name":"@colorix/localize-google-spreadsheet","description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","version":"3.5.5","homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","repository":{"type":"git","url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git"},"main":"index.js","dependencies":{"google-auth-library":"^9.15.1","google-spreadsheet":"^4.1.4","mkpath":"^1.0.0","q":"^2.0.3"},"scripts":{"test":"./tests/all.js"},"bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"directories":{"doc":"doc","test":"tests"},"keywords":["google","spreadsheets","api","localization","android","ios"],"license":"ISC","_id":"@colorix/localize-google-spreadsheet@3.5.5","gitHead":"fa888510b8ba9d8db79c6cbfe7246ffe13b38c4f","_nodeVersion":"24.1.0","_npmVersion":"11.4.1","dist":{"integrity":"sha512-XxWVW1jjgQhkL/QLFAjyuhhH9gZrpGjRqedpQHRIlDs3IjOW1mgP0FEPE8TmOeIy6jmyNkD9ei9MVzScgiUXpg==","shasum":"df39628b6b955fd194608fcb61ccd3ccdf067a30","tarball":"https://registry.npmjs.org/@colorix/localize-google-spreadsheet/-/localize-google-spreadsheet-3.5.5.tgz","fileCount":9,"unpackedSize":28932,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIEFCXGH2Jljo7+ExehAGrPvppaJXPIXDHLFFeFJwXD7vAiARmSlqXvAZnAI1zxDzgzMiRL/NRvxqzw8nIqbnG+Kbkg=="}]},"_npmUser":{"name":"michaelcara","email":"michael.caraccio@colorix.com"},"maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/localize-google-spreadsheet_3.5.5_1749528632995_0.9223422932304348"},"_hasShrinkwrap":false}},"time":{"created":"2021-11-10T20:57:42.437Z","modified":"2025-06-10T04:10:33.341Z","3.5.0":"2021-11-10T20:57:42.630Z","3.5.1":"2021-11-10T21:10:14.891Z","3.5.2":"2025-06-10T02:37:09.042Z","3.5.3":"2025-06-10T02:47:57.733Z","3.5.4":"2025-06-10T03:13:44.374Z","3.5.5":"2025-06-10T04:10:33.161Z"},"bugs":{"url":"https://github.com/Colorix-ch/localize-google-spreadsheet/issues"},"author":{"name":"Michael Caraccio","email":"michael.caraccio@colorix.com"},"license":"ISC","homepage":"https://github.com/Colorix-ch/localize-google-spreadsheet","keywords":["google","spreadsheets","api","localization","android","ios"],"repository":{"type":"git","url":"git+ssh://git@github.com/Colorix-ch/localize-google-spreadsheet.git"},"description":"Create a localization file in Android or iOS format from a Google Spreadsheet. Fork from version 2 by Pavel Sorokin","maintainers":[{"name":"michaelcara","email":"michael.caraccio@colorix.com"}],"readme":"# Convert a Google Spreadsheet to a localization file\n\nFork : [NeverwinterMoon/localize-with-spreadsheet-2](https://github.com/NeverwinterMoon/localize-with-spreadsheet-2)\n\n## Installation\n\n`npm install @colorix/localize-google-spreadsheet`\n\n## Differences\n\n- Authentication with Service Account instead of API key\n\n## Example\n\nRequires:\n\n- Authentication with Service Account [How-to](https://theoephraim.github.io/node-google-spreadsheet/#/getting-started/authentication?id=service-account)\n- API key **not supported anymore** \n- Spreadsheet key\n- Sheet name filter\n\nCreate a file `update-localization.js`\n\n```javascript\nconst Localize = require('@colorix/localize-google-spreadsheet')\n\nLocalize.fromGoogleSpreadsheet(\"./config/myapp-1dd646d7c2af.json\", 'YOUR-DOC-ID', ['YOUR-TAB-NAME']) // tab name can be *\n\n  .then(localizer => {\n    localizer.setKeyCol('KEY') // name of the column containing the translation key\n\n    Array.from(['en', 'de']).forEach(language => localizer.save(\n      `project-name/resource/${language}.lproj/Localizable.strings`,\n      { valueCol: language, format: 'ios' } // format can also be 'android' or 'json'\n    ))\n  })\n```\n\nRun it with\n`node update-localization.js`\n\n## Advanced\n\nYou can filter the worksheets to include with the third parameter of 'fromGoogleSpreadsheet':\n\n```\nLocalize.fromGoogleSpreadsheet('your-json-file', 'YOUR-DOC-ID', '*')\nLocalize.fromGoogleSpreadsheet('your-json-file', 'YOUR-DOC-ID', '[mobile-app]')\n```\n","readmeFilename":"README.md"}