{"_id":"@danse4mobility/google-sheets-downloader","_rev":"7-bad2482506179e9736a33f5c78950ec6","name":"@danse4mobility/google-sheets-downloader","dist-tags":{"latest":"1.1.4"},"versions":{"0.0.1":{"name":"@danse4mobility/google-sheets-downloader","version":"0.0.1","description":"Google sheets downloader","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","_id":"@danse4mobility/google-sheets-downloader@0.0.1","_nodeVersion":"12.16.1","_npmVersion":"6.13.4","dist":{"integrity":"sha512-3HCxyrONjN/2SmhYknwZ6BJnaY5d8U9ZYWYXmBWxKut48vD4TpI5AojM6J7IaE/1yj0e9nM8ISsJpNIAYr7SHA==","shasum":"6a5af64c97cbfb1392ab629d6993af39449c477f","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-0.0.1.tgz","fileCount":3,"unpackedSize":395,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJemO1iCRA9TVsSAnZWagAAJ4UP/2GJ21JIuNAVLRMBmyAQ\nw/+8h6Bwtv8PL0Bq6esF3lSPuBv86yW0sXPZr5MbgMYHCD3HmM5CMBx7Nuiu\niSQOzAowuaZp2OVguhgampeGjYC3WZ+chM+LXSGBeGv7VJtiieDSj2BIC+up\nwE3K3IuhfKR5TOw8N6HcDB0WlYK1jKq2mUJo1ztTuvd8KU0jksD9xTnu2LJI\nCT7hih+jKte2E6xDZalvRE1IIUl0lauM2v5yYSMKc3dkkP4HFQI87udemaQd\n6g+K8Uo+6KLfuduI+fPzysse4bJcThJaw4sJ+KvPRR/3MleSm7SL1pzIokDc\n9D3nK/91VJTYXc/lt3GSTCozsFH7dw+BStM9VBPRtTo3sRx1RHj/FdbCeBM9\n308u0GywjBgsDjP6M6angTZQdCRb2Y+22YJlz3K/JIESE95l+csZd3UWKl87\nPWzpz+0bxNt1xXcfC36xxhNzo9wwyTA6LI770HeD5VL9GGlgLjqj4C2a/NaQ\ncjXjgHUkI/vkcP+7F0HgYI2AdaY8cnTXQiVVO7f50BlPD0sROEj3yiw1lOYT\n7tMYZkji1VjcnEFzWZZQa0WmieeWZOCLGZGFkJjF3QT7ciYTb1Yf+8vtb3QW\nOR3f2S8xvnKu1J88ZwrZ2yZuZa/JHu1+tfHa1i5Nl/TApxG68CIH1e83R9PK\npbdA\r\n=2SRW\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDC9hOBCX+Sr3NYt1WhrOOpg4TSm3tdqbSB4m7Z+8R0BgIhANBD4Lj8vSWjiVGq3QHI/KOPmxDZm2iOfgMF+O67uUqY"}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_0.0.1_1587080546437_0.8373934828420408"},"_hasShrinkwrap":false},"0.0.2":{"name":"@danse4mobility/google-sheets-downloader","version":"0.0.2","description":"Google sheets downloader","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","dependencies":{"googleapis":"^49.0.0"},"_id":"@danse4mobility/google-sheets-downloader@0.0.2","_nodeVersion":"12.16.1","_npmVersion":"6.13.4","dist":{"integrity":"sha512-eZs/qDpDsA0FNa2c/neRPRcNOL6MbLI4QJW0p9TNUcHOYWTxAi9LyyJx7aoFTA2k648+tuVr5/ekULopuBQGpg==","shasum":"3bb37f55f65e1408bc87e50b02b8d023c1e44b29","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-0.0.2.tgz","fileCount":3,"unpackedSize":491,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJemO7vCRA9TVsSAnZWagAAEB0P+wR908dGEq3g6mZ4bNUM\n4isv0Rlk/m27d23abadhfGqPKUIXw1qFK0YInqn/oOaSc7G5xYSS+YZ5YmDm\nO3voRBsExzsasYVyOi6LGZmR4VFO75VSTWwUZweUhPOHULV0dkcEKjnmUZ2b\nNVgZ4CijaNVaUt470nxnN55HpJYnKLX+/qBvSHkB8ZQWbNH5qyBmWM4F4SeL\nuYcD7jl0nXo8UI3aMau7I9lSJqZ8oI3mXu3yRHkzX8dntAiHKNYkwmR1mLfB\nOolFWy/iIw7DxVeAdJ8u1u7/c/oNVC60cs/p5+5T/k2Hqkk7Gj/8ZkJ3bh7b\niaYkoM7mUjpjFITkSkIgKUIusCSFAqUkgGWgZZGLdiLdCCA5xInlt9YmbzBg\noHb0EArgCkhhJyPPXlcMq2ckR61kU5Gxb+268Gw4vA9H7W4uolBWha3Zo1pF\npugE9mOIRRQXcoreoM5kGh7PW2EraQUkeMv37Wn+HPWdpbQBoNJKTpCICK+b\nGPZTKPzCS2tfQntzSJLP7qPObEt1kJ1ZDmmErE2wmlULO2wu0qiH+t+0yEtu\nZLG0hq7hIycyPUL/ToVQ5TvIs+a/tpyANA+DgtLEnb7eBQaYg0xYcegKDp48\n9cVEgQnv35Hmo6GtwMcnmUbu46AkRr9tvlTBOzx4PrPozv/Vpb9CNl8D+1bU\ngLIw\r\n=79K+\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDWilNGoIIXq0CYyt9MOXOUj+RcDfMIckIU39Qu78ld0QIhAPQIS7NbGaKXAQ4YMs/2yBjAgj/NlKXwPjWRRB1SLRDk"}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_0.0.2_1587080943405_0.7554454958557484"},"_hasShrinkwrap":false},"0.1.0":{"name":"@danse4mobility/google-sheets-downloader","version":"0.1.0","description":"Google sheets downloader","main":"index.js","types":"index.d.ts","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","dependencies":{"googleapis":"^49.0.0","aws-sdk":"^2.663.0"},"_id":"@danse4mobility/google-sheets-downloader@0.1.0","_nodeVersion":"12.16.1","_npmVersion":"6.13.4","dist":{"integrity":"sha512-ayjNHyZ8A7njlmkduIXmbPy5y4Pw4KXXVyvKT+NAPmxlLVVyHmGz7vqRecws1Ad0WdEzE8Q1atfjhlUSM2NEOQ==","shasum":"20eb8e8c3122d99b9c86045fe068deec873e2836","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-0.1.0.tgz","fileCount":4,"unpackedSize":10351,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJepvx8CRA9TVsSAnZWagAAy8kQAJXNq3Pg3iHhorRa/pmm\nncZ4qGoYYPrBxkUrU9f6HJlR6P8uQVwwxYJq5euiKshIwipStNcWfVUPGOCX\nNmi3YMvdHjQcyfQy/hm3vC6fsL3Nur01YshvzMPPZ4PxETQXP8CMf91eB3QY\nDj6zONxFcHebRbstML5XW+J4S1m1SXynJTe5tTtG9tags68XAPi8mv81eHbe\nu8vlc/x0fOw5CE8ym7y2oIKuO8/01w8SIHsspVF7eh5ie1LCfIf1Stnnc9uA\n2z7VlxeunuS4R7epTXlM9vw69Dap+s4aHJs4eZAmeY7TuYcc0KP7kFkO3Uq/\nbb9Vj0SWYNBKkZSFX6W8AdQU1bPSc/Q9NMalfLXk5ANMhFTZ6XTBqmgqdHzu\ndTJHaiUH60OH0BtqXA7N+8xN0nK1IxkR/0wF2kelRog5UFmv2biXodS8UUFY\nIz1VEMLDGXL0gC4b+5aJcmg6dEjCQ6fmo4rJRa2A2bqiQ2fjpR7Ujwo1eJyy\ntIe+Ti3upBdcS9EV6iT19brJGbXLqi7aK1gxyF6LUpzznrRAoNaGiAG34vf2\nPHSfHoPdCrxb1hC1ByeT7J0PiKxn9lpSvb8WMQl0O1Nd/KBQEnnL7N0fieZl\nicT+qLnGcSCeE9pvnGlew76QoimZ4QNLxBGYfXwvMRJrLTBrzfqtYC7qR7kV\nqmAh\r\n=+PED\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDUMjryDUJIN05+ep3eM7Kw8ZA+UpdpXhc3bAHZ9WcI2AiEAtT3h3ySrS1gxkZQoY0L79ClTplh/J4e4Edy7VOXRGgU="}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_0.1.0_1588001916224_0.7076710822440377"},"_hasShrinkwrap":false},"0.1.1":{"name":"@danse4mobility/google-sheets-downloader","version":"0.1.1","description":"Google sheets downloader","main":"index.js","types":"index.d.ts","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","dependencies":{"googleapis":"^49.0.0","aws-sdk":"^2.663.0","readline":"^1.3.0"},"_id":"@danse4mobility/google-sheets-downloader@0.1.1","_nodeVersion":"12.16.1","_npmVersion":"6.13.4","dist":{"integrity":"sha512-adAgSyJpeNn/gK7BeTdRJsaf4bbTtp0HRhX/vFELjzEQqbL2esuBNKEKpFGS9YzZojOWxE1QdtBy1HkPiZrPXQ==","shasum":"a7c9179bdf2c9ae5d76c21013dcce38f13d80be8","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-0.1.1.tgz","fileCount":4,"unpackedSize":10377,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJepv26CRA9TVsSAnZWagAA9rUP/A86igbICFOkjLNExP+G\n5VldsTnAzxhJxoixW6QZSZoKH7682QE+vLU/pa5HxsweWtpgdZdICXo3+dPz\nMNgrB88/FJuB2F4VftOrx4zwEOPNQh/HutfMCkFBndaoAMN5u9FZtkVZPcO3\ndxp5CamrIifHq5yMFY0oc8eTDewRbdiYP6+sO3D/Lqil63B9bpk1BnKchzhM\nXwI0htbbTEf0c499bIKZtddCrdVtlZ4VU3tReop9mWl5BYxZuv6qPlwgHYBj\n58XL3gvh3arE/B4gg24Ex1fZcaAzONB3Dypfj5fGQJAUsVQES7SU17zB22Zo\nYZShzxlU8gA35YNH2axdNre/55JuUE6S8AwJ/uPkHXJnbvOoEDSXzXcemqc6\nnUFp7HYhwEjruOMEwEeB4NT96ba16d1DwQTnJIlAwqxEPwssJ9HVigk80MkG\nOMWbVgmM6YLc8oNPvTJzZQC6TokhI2swRYJPfEtIiHxDic+Xsy3Wa/7NGgUZ\nKmWJd9usxw5EtM7rkBxKOtA7D1MsSyojfKJ5XVidnZycXi0ChwiYrSoWlAvJ\nwfRDPjPYZ6EyNrErXpMZL75r0bFOtzjs+4kXThEaYKn7ngoCMD8gvfnXYzQe\n8n3LTPuN9fLsed4zzLH35l/Bm3M+UMCl6Fib1p3BfA1RF7RpGlLy02RWqUS2\nRrOx\r\n=GnXX\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFJs5Bvx2GyFMvehvsdBAGBh9glU60CbFLErFB/Pue4hAiBRiLzVbK82ZSll1t+W1gq00VmM4TKWasTF7eNllV/lAA=="}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_0.1.1_1588002234121_0.43974012607112734"},"_hasShrinkwrap":false},"0.1.2":{"name":"@danse4mobility/google-sheets-downloader","version":"0.1.2","description":"Google sheets downloader","main":"index.js","types":"index.d.ts","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","dependencies":{"googleapis":"^49.0.0","aws-sdk":"^2.663.0","readline":"^1.3.0"},"_id":"@danse4mobility/google-sheets-downloader@0.1.2","_nodeVersion":"12.16.3","_npmVersion":"6.14.5","dist":{"integrity":"sha512-dv+/wNN98avxjyZoSuThk4jooc7+nI2yJmuS+lhDJ9ShKfVRl5YgFdXo0m1GPSQbM6VpvuKlL2uknZgQl4J6Bg==","shasum":"7cf0a4280aeb47519965bc70c38615ffa0731421","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-0.1.2.tgz","fileCount":4,"unpackedSize":11689,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJe85kcCRA9TVsSAnZWagAAbaAP/i9btxyFOTZFSVk0pxR+\nd9HEmD6N5ZB6zPlF6UwEFII3bEb+4/Vtdw/FoAZ5v8W46Fd6rHYxI82i3TRI\nAb8kWPTGrHnzkwSg7ZjwZ8aFqonyFihjYAD+y61hPO9J49ygbi9MW0HCL8Ji\nc08YQnEfzw5rjQs1lZfGXOCElKfk9c2IwRKm+p/YoOL/0YxXWo6Tp8I4EsoM\nB33h9jZAfP1RiRJ2wU6QiwytKSnm7TaZy36wdLlJYolkpHHRL8BmVDBlBvNK\nZ7PwCixq+YfXYUoVfGHYmYaf468+abTtTzXxwEL6OCqyHLttlJiZoECJR9Qt\noiQTF+xYyw75fzKZGsZT6fQFdcCpRsIh9IwKH6m7Anhbg7qBWj6D/rRuQt98\n6XoaBkWodcciZbSkwjTofFAQrsj34e/E9QoK+1F3lQYw9exPjjIyvGiYg4Qe\nTjlMTmJXvAgwMNR/fjXWeZkYngjumDv6yAWNG6c7KbNUfma/GEPM7tNFL6ON\nhEECFtNgRI0dNgnKyGS7cEUrcgQ4fOT0rKxm2vLIpS+3LlCLF/vrdBcWJ6gM\nXM9qi7Ug2wEXmNiW03AdycaUqvzj/0KX+2GEKveppzwyyU07lIQOL5Lk8Zx0\nBBA2JEP2o9pe/OG9teIf+gAFqJz4rDbQnCr3jBg6dETcVClAw36ypOy1JCqR\nBuUE\r\n=isws\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD1tulB5xFZ2hBo+q5Scz7cKSLljThd8v6cQirfDSYx6QIhANeZ6J4PbuTmOW0ZjJlIHTJayDZ/exJpEx9rAITcUTgA"}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_0.1.2_1593022748481_0.3735924904585717"},"_hasShrinkwrap":false},"1.1.3":{"name":"@danse4mobility/google-sheets-downloader","version":"1.1.3","description":"Google sheets downloader","main":"index.js","types":"index.d.ts","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","dependencies":{"googleapis":"^49.0.0","aws-sdk":"^2.663.0","readline":"^1.3.0"},"_id":"@danse4mobility/google-sheets-downloader@1.1.3","_nodeVersion":"12.16.3","_npmVersion":"6.14.5","dist":{"integrity":"sha512-y0e+O8XQX9kD3lISBJgmRL97WYwGLEJbLkBh0wP2mwV8IeKd1nr0SgiA6UZGc6V5wKyC1mFsyjmLIDooJChJMA==","shasum":"7a5624214209b7833351a680a4c7d938187db763","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-1.1.3.tgz","fileCount":4,"unpackedSize":11689,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJe85lTCRA9TVsSAnZWagAAix4QAJmVgMaRyfQlwCLBiDsO\nZElpOMetI55KA6jB4o8sKbKmgNhcOpA/9rTBXGuJJjJDHqFhZl2456TWJyif\nzBsoJACjDVadfGSEQQJQ5kptAXD4NWp4BHO7uP9bIL5ym4170a/FHftLOl1a\noTqeztPm/cgEsR3nntf8ndJ2cZ26/3FKAX/e4DsAH3E19n4+wL7IAJzaFjpA\nMNy2gg7jX6821y4vmCOyaxAjZWwF19bATlFftpvkygjMl4v/VeBdNb8RXcQ4\nONdd8J9IHgKBbHK1YOjtnbMdvYoFvXN91bKZlRxbUFR8BjtB+TREQBgH1q6o\n9kxFsjhX0XI/y7yEEg3e3YSw8WlFJDzYN9o7SL7PSMtiaH/mx62AeJdZ2IZ/\nYaG2JIxz7tberOFJX9hzgBg+2cWzGygcuIieBcSej6+M7Qe9IZbKGQ9pTz5c\n6/3fN7Ai2HHRuj7KVIp0SWmTkkPmwAj2iOKljdPK+fsnMNCns1WSW97gayT3\nQii20QdHTTthzIzywIMa91ta1a8vYEluyyITNZh+XMoiN+9M5os5rziNpJie\nvjxmSqBod7lxTG6OWejxFkcd6qBRwdmDN/UqeXKW4t+nLTMsm5JYEFQSe7Ha\n8gtG1IXEqgqgPO7e3QhYs5BC4Pd0Nyo3cDlMF0Zuoq8WTjS3SHYtjJqXVjTw\n9PQH\r\n=5iCx\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD04Ck9ZFv9YUIEIyxmBWOCLJdPlj04+wx5qVKS+JPcNQIhAIokc9UYa08zzt348SkCgaNk2tNHLD72kSg6A91LVwl6"}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_1.1.3_1593022802643_0.002373674230676359"},"_hasShrinkwrap":false},"1.1.4":{"name":"@danse4mobility/google-sheets-downloader","version":"1.1.4","description":"Google sheets downloader","main":"index.js","types":"index.d.ts","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"author":{"name":"Lukáš Orčík"},"license":"MIT","dependencies":{"googleapis":"^49.0.0","aws-sdk":"^2.663.0","readline":"^1.3.0"},"_id":"@danse4mobility/google-sheets-downloader@1.1.4","_nodeVersion":"12.16.3","_npmVersion":"6.14.5","dist":{"integrity":"sha512-SX8TSMGksa6YW+F0NNoV/m1xDpAt7OPjrsWZC7LZJ7cmo7VW4oK7WPLGJ86Plzb/ME93SrkbOBMgsmqTrhEFNw==","shasum":"10c98f4770c21af18960a9e091e724f78b0ff4b6","tarball":"https://registry.npmjs.org/@danse4mobility/google-sheets-downloader/-/google-sheets-downloader-1.1.4.tgz","fileCount":4,"unpackedSize":11689,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJe9Is8CRA9TVsSAnZWagAAkJ0QAJDQbEHCuxiQOJOMbvn1\nvh8M340PRiwvjnRrEc//6JMA44cHf53W3WLiVJLXZtI4V9uZPp0g02uymiRM\nXEG59aD3FohL1vYBahv1vUK2kAn0z0YF/NgeMpkNWFtEALB65/bnEUhXBYZ2\nDGZTFF6KNufsfRKOXjQyBTjude+/Ya9ov+k53j+T45paVrdTiTy0VFZ/ZRQ4\nc+eg70il/46Z/aXW3ajSnb+yeZ78trc0OY/3IfxIzWVj5UzSCUQ54Er81lLc\nTA1D2v8aFDtG0tn7O8OtvJ7FEtZQRSACynsRZWnPho8MAGkcrYnkzmXTDS95\ncs/xcbJREe+twKWRIRDoYhmI1jrIPQ7rb1N2mTHxjrPsPmYy82aEZRiVLXyM\nJz1wLuVcDDBnKaH3cByJdH3zfKK9Ihizdwm/0ugbjQpuwYAgqHHt6aIcsn+x\nIN/o9uPrcjdKFFG2532vmuQfTjuXwm0/hpIeMzvjpFRDXLV9p4CScNAWH4bm\nOt9OzA3bwgoaSDIcdDe3TXCxV/zlpy9ScEku8owmluh/w/XTdIKXYr9GtwFU\nyYcEKdPGbh2s+csT5EHjmYmYKlRTu89B9CdAe91nM7dIUBo0CnjW8o5ITO2f\nOLUxaUokp66s1kbidbRNiAQXMpwfq3uGUhqOhJdBcQsSoCgBeSl3OkME4NzD\n1Fjl\r\n=gaG3\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCixfnU9p/xevV0zdYTqG+h1YjYUyYuM0aEZhK6pvZdxgIge1NixHrrXXDkpVUwHkNGjOzJ5lgj8SWQxnuqJ9vEgi0="}]},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"_npmUser":{"name":"lukasorcik","email":"info@d4m.tech"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/google-sheets-downloader_1.1.4_1593084732069_0.9446373054959902"},"_hasShrinkwrap":false}},"time":{"created":"2020-04-16T23:42:26.158Z","0.0.1":"2020-04-16T23:42:26.640Z","modified":"2022-04-05T02:42:33.113Z","0.0.2":"2020-04-16T23:49:03.544Z","0.1.0":"2020-04-27T15:38:36.316Z","0.1.1":"2020-04-27T15:43:54.231Z","0.1.2":"2020-06-24T18:19:08.579Z","1.1.3":"2020-06-24T18:20:02.888Z","1.1.4":"2020-06-25T11:32:12.207Z"},"maintainers":[{"name":"lukasorcik","email":"info@d4m.tech"}],"description":"Google sheets downloader","author":{"name":"Lukáš Orčík"},"license":"MIT","readme":"# google-sheets-downloader\r\n\r\nAn unofficial client intended to download the content of a Google Sheets spreadsheet and subsequently upload its content as an AWS S3 object.\r\n\r\n**Table of contents**\r\n\r\n<!-- MarkdownTOC depth=3 autolink=true bracket=round -->\r\n\r\n- [Getting Started](#getting-started)\r\n- [Functions](#functions)\r\n    - [authorizeGoogle(secretsPath, tokenPath)](#authorizegooglesecretspath-tokenpath)\r\n    - [getSpreadsheetData(version, auth, id)](#downloadgooglesheetversion-auth-id)\r\n    - [downloadGoogleSheet(version, auth, id, range)](#downloadgooglesheetversion-auth-id-range)\r\n    - [processGoogleSheetData(downloadedData, headerArrayLength)](#processgooglesheetdatadownloadeddata-headerarraylength)\r\n    - [uploadDataToS3(bucketName, objectKey, processedData)](#uploaddatatos3bucketname-objectkey-processeddata)\r\n- [Usage](#usage)\r\n- [Changelog](#changelog)\r\n- [License](#license)\r\n\r\n<!-- /MarkdownTOC -->\r\n\r\n## Getting Started\r\n\r\n1.  Install module\r\n\r\n    ```shell\r\n    npm install @danse4mobility/google-sheets-downloader\r\n    ```\r\n\r\n2.  Create a project in [Google Developer Console](https://console.developers.google.com/project), for example: \"Google Sheets App\"\r\n4.  Enable the Google Sheets API\r\n5.  Create credentials for the Google Sheets API and save the file credentials.json to your working directory\r\n6.  Share the Sheets document to *service email address* using the *Share* button \r\n7.  Pick up the Sheets document id from URL or Share dialog. Example:\r\n\r\n    ```shell\r\n    # Sheets document browser URL\r\n    https://docs.google.com/spreadsheets/d/17Ea_eD4e63OKPFrRtjtwPMh7seIqc6JUF1HsHrCpul/edit#gid=0\r\n    # Sheets document id\r\n    17Ea_eD4e63OKPFrRtjtwPMh7seIqc6JUF1HsHrCpul\r\n    ```\r\n10. Let's start the work!\r\n\r\n\r\n## Functions\r\n\r\n\r\n### authorizeGoogle(secretsPath, tokenPath)\r\n\r\nIf the tokenPath contains the JSON file with token, reads the stored token and returns the authorized OAuth2 client.\r\nOtherwise, gets and creates new token in the destination determined by tokenPath after prompting for user authorization, and then returns authorized OAuth2 client.\r\n\r\n * @param {String} secretsPath Path to the JSON formatted file containing the client ID, client secret, and other OAuth 2.0 parameters\r\n * @param {String} tokenPath Path to the JSON formatted file containing a token or path to create it.\r\n * @returns {google.auth.OAuth2} The authorized OAuth2 client\r\n\r\n### getSpreadsheetData(version, auth, id)\r\n\r\nGets information about a specific Google Spreadsheet\r\n \r\n * @param {String} version Version of the google sheets API\r\n * @param {oAuth2Client} auth The authorized OAuth2 client\r\n * @param {String} id The ID of the spreadsheet to update\r\n * @returns {any} Properties of the spreadsheet sheets\r\n\r\n### downloadGoogleSheet(version, auth, id, range)\r\n\r\nDownloads specific spreadsheet \r\n\r\n * @param {String} version Version of the google sheets API\r\n * @param {oAuth2Client} auth The authorized OAuth2 client\r\n * @param {String} id The ID of the spreadsheet to update\r\n * @param {String} range The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table\r\n * @returns {any} Downloaded data from the spreadsheet\r\n\r\n### processGoogleSheetData(downloadedData, headerArrayLength)\r\n\r\nProcesses downloaded data for proper representation in S3 storage\r\n\r\n * @param {any} downloadedData The data that was read. This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension. Each item in the inner array corresponds with one cell.\r\n * @param {number} headerArrayLength Length of the array header\r\n * @returns {any} Processed data that are prepared to be written to S3 storage\r\n\r\n\r\n### uploadDataToS3(bucketName, objectKey, processedData)\r\n\r\n Uploads processed data to the specified S3 object\r\n\r\n * @param {String} bucketName Name of the S3 bucket\r\n * @param {String} objectKey Object key (or key name) that identifies the object in the bucket\r\n * @param {String} processedData Processed data that are prepared to be written to S3 storage\r\n * @returns {String} The location that identifies the newly created object\r\n\r\n## Usage\r\n\r\n    ```javascript\r\n    const {sheetsDownloader} = require('@danse4mobility/google-sheets-downloader');\r\n\r\n    const secretsPath = 'client_secret.json';\r\n    const tokenPath = 'token.json';\r\n    const version = \"v4\";\r\n    const id = \"17Ea_eD4e63OKPFrRtjtwPMh7seIqc6JUF1HsHrCpul\";\r\n    const range = \"A1:K\";\r\n    const headerArrayLength = 7;\r\n    const bucketName = \"sheetstack-mybucket123a-1123\";\r\n    const objectKey = \"data.csv\";\r\n    \r\n\r\n    var oAuth2Client = await sheetsDownloader.authorizeGoogle(secretsPath, tokenPath);\r\n    var downloadedData = await sheetsDownloader.downloadGoogleSheet(version, oAuth2Client, id, range);\r\n    var processedData = await sheetsDownloader.processGoogleSheetData(downloadedData, headerArrayLength);\r\n    var location = await sheetsDownloader.uploadDataToS3(bucketName, objectKey, processedData);\r\n    console.log(location);\r\n    ```\r\n\r\n## Changelog\r\n\r\n- 1.1.0: getSpreadsheetData method added\r\n- 1.0.0: First version release\r\n- 0.1.0: Initial release\r\n\r\n## License\r\n\r\nModule is MIT -licensed\r\n","readmeFilename":"README.md"}