{"_id":"@appsparkler/spreadsheet-editor","name":"@appsparkler/spreadsheet-editor","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"name":"@appsparkler/spreadsheet-editor","version":"1.0.0","main":"src/index.js","typings":"src/index.d.ts","author":{"name":"Aakash Shah"},"license":"MIT","scripts":{"build":"export NODE_ENV=production && heft build --clean","build:dev":"export NODE_ENV=development && heft build --clean","start:dev":"export NODE_ENV=development && node src/index.js","start:editor":"export NODE_ENV=development && nodemon -w src --exec ","start":"export NODE_ENV=development && heft test --watch"},"devDependencies":{"@rushstack/eslint-config":"^2.6.2","@rushstack/heft-node-rig":"^1.9.22","@rushstack/rig-package":"^0.3.13","@types/heft-jest":"^1.0.3","@types/lodash":"~4.14.182","@types/node":"~17.0.45","typescript":"~4.6.4"},"dependencies":{"googleapis":"^105.0.0","lodash":"~4.17.21","dotenv":"~16.0.1"},"description":"- Visit [Google Cloud Console][google-cloud-console] - Create a new project or select an existing project to enable the Google Sheets API. - Create a `Service Account` with `Owner` access. - Create a `KEY` for the newly added `Service Account`. This key w","_id":"@appsparkler/spreadsheet-editor@1.0.0","dist":{"shasum":"f970aae7e37c3929bb7db0d67a8113f4e557b555","integrity":"sha512-DUnqxae1iimVsMM3ew3LhKe7Ejh9t+a8ajrI2x3BF6BHzT4Cn13GkFgbWfZZl3qpnR7ZmXRtSi3QFdOQo6Oguw==","tarball":"https://registry.npmjs.org/@appsparkler/spreadsheet-editor/-/spreadsheet-editor-1.0.0.tgz","fileCount":20,"unpackedSize":8624,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEeHunGPUplUX3Xf3B2FLa2d3SeCBI6Qv8ZSB6zEX0CCAiEA+m3Cejl3wfmq6J373LGtKw5uXuYVNt/ea1lARsDcQ5M="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJi5b1ZACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmr1EQ/9EyoX/By723hufqxR9mw3oY0OuGjDzM5mU8KzWsZc6k+UOdSh\r\nEG9SIBtr+kdv38zVczZln9vUTqdpUjWUa8owB8KUa81RED6H5HNolfG+goFJ\r\ncVIfdAVAfdXo8Kj8XlzyeeRApG/fMskQF8gngsEDkPltP+XUYuWSoyeBYUle\r\nQXAtaZO7kMQALs8DiYJBhNffhHaz8faOrVmHbl+aS5hL2Dd2MRKcxdWa61i7\r\ndQuk6KFjbyUFXgkKbKXvN/dsrkxu3ong3ty6jpaZH9TjnF5e7sFnXlHs36nj\r\n67IbdLLJwJXUW886G1x8K7H4OeAvMDPcqQmehR2IC0c1NJYSdaK/AB7OcZem\r\nqVsUdIGTJD3Gpdwz5jdTXyf9Tz+spe3RPwim9BNcBqDnkwYenofL+Ezohk7r\r\nGaf2V9T95yoQzoriXwLE7zHnrOjt7x6XUsgoeoG4gwjFeIdh+QaqqMBOMuHF\r\nO3zSI81HaErsBIurGndw9vknEWadntFXSN/0xxjEp9a/4i7/LkZjeKtn+kX3\r\nKosth/WNI5au5s00cvnXrm6as9MRWkGtG2W2sGMsAP5aCDemdOLnQFIZTQX0\r\nbeWu44JB6opyYXDW9ck+/HGILj5J8IeJzJSXQc+mD0Lhjpy/7kWCVCGX4KOW\r\nO5SSuhj2Cex8FJ2djSlg2g2fImqXIgtvtKw=\r\n=hlOP\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"appsparkler","email":"subs@appsparkler.com"},"directories":{},"maintainers":[{"name":"appsparkler","email":"subs@appsparkler.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/spreadsheet-editor_1.0.0_1659223385159_0.6138346854929517"},"_hasShrinkwrap":false}},"time":{"created":"2022-07-30T23:23:05.064Z","1.0.0":"2022-07-30T23:23:05.351Z","modified":"2022-07-30T23:23:05.461Z"},"maintainers":[{"name":"appsparkler","email":"subs@appsparkler.com"}],"description":"- Visit [Google Cloud Console][google-cloud-console] - Create a new project or select an existing project to enable the Google Sheets API. - Create a `Service Account` with `Owner` access. - Create a `KEY` for the newly added `Service Account`. This key w","author":{"name":"Aakash Shah"},"license":"MIT","readme":"# Editing Google Sheet With Service Account\n\n- Visit [Google Cloud Console][google-cloud-console]\n- Create a new project or select an existing project to enable the Google Sheets API.\n- Create a `Service Account` with `Owner` access.\n- Create a `KEY` for the newly added `Service Account`. This key would be automatically downloaded which we'll use to authenticate the `Robot User`.\n- Visit `APIs and Services > Library` and _ENABLE_ the `Google Sheets API` to interact with a `Google Sheet`.\n- Create a `Google Sheet` in your user account and click on `Share`. Share it with the `Robot User` - the email would be something like `service-accountu3928492@appsparkler-sheet-editor.iam.gserviceaccount.com` with `Editor` access.\n\n> Service Account is a fancy name for a `Robot User`.\n\n[google-cloud-console]: https://console.cloud.google.com\n\nNow you can read, write, append cell values for any spreadsheet to which the Robot User has access to.\n","readmeFilename":"README.md"}