{"_id":"@404invalid-user/googlesheetsdb","_rev":"7-3aa063c3f14fdeb9718f4d3935120a8c","name":"@404invalid-user/googlesheetsdb","dist-tags":{"latest":"3.0.0"},"versions":{"1.0.0":{"name":"@404invalid-user/googlesheetsdb","version":"1.0.0","keywords":["googleapis","mongoose","googlesheets"],"author":{"name":"404invalid-user"},"license":"MIT","_id":"@404invalid-user/googlesheetsdb@1.0.0","maintainers":[{"name":"404invalid-user","email":"user@invalidlag.com"}],"homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"dist":{"shasum":"5cd20ecc9861d96c14a8b8cc4e868411cba3dba9","tarball":"https://registry.npmjs.org/@404invalid-user/googlesheetsdb/-/googlesheetsdb-1.0.0.tgz","fileCount":3,"integrity":"sha512-UPDIk9Wv/bm1H6Mpo42MkX/IWAGeoWfvapFTgcCgh4oNNFJrEcWpzNNMSVWwd9TzZFyyhacULPVpW53hmBRPEQ==","signatures":[{"sig":"MEUCIQCvAXNm9Lkms85qnlwFZW/0ghn3u0S15m3BREpuvdztGgIgLeTBoxnQJctmxirz7IcGtRiknGVYoj9WQrpOD8/k6Kg=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":14833,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiOvzEACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqagQ//SlNVRs61zt/B5l+k4gfRL3i4ZfSmN02SMR0imlwN980bP4Cx\r\nEf3zOdLhHZXYps9l3J/CJXOzlQeqFedsxyABfYd3J8hGiWltVzFSNSEjItQF\r\nqCEBlv9CJ8iC4DHurrGuUp76tf+LlZ915WF+h2aZudjXcCXJ4MkVb737P84Q\r\nsMQ6LG2u2lITugihxwMeOmEWPqpXHjFEZlu/1GQfetqDRk7Rg5/N3uOMh5Bx\r\nrzaspc2rCgNRHWWSD3R9K6oodDHe7VHMNwFrnyqrunkddcY2bgrRd+RlFuJV\r\nlEiK5TvLQdXSUVt1v4khi0TUOZuGahm9hBaxUHkAriCsTgZ77rwJd7AS8Tw+\r\n7GbJbb/Z/sGr28s7PoAXKXYSheW2aRq9SxTdT87pnfP/ZMKbZgijsrdHar2d\r\nE4HFET/hKAh79i9IpCfG8lova20WBPuFJ7lKHHR+KHzVW9ZPawIQjjkFq8dy\r\nTJaS3n4tnJF4CUts7dRKxsTJCRExaUcTG0pnATLqP820v2IHAhTDzFwAFTsX\r\nlvdY1L7xa9LrNgQrBP9LHcWmt9E6swlccynnu6uo7z3Ri4xHeKVN4YMbQIBw\r\nfozOfLbeHJOy1uwBWITk17eB9PaC6GyKhJke1LOoU5Hvl95e2ZSK962IUgn0\r\n8rIBMKvWgkWDVmmu8J7vmIy4GmGOApwXa18=\r\n=dku1\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"4390131650f010ee4c3d9c5915f70e426b91e379","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"404invalid-user","email":"user@invalidlag.com"},"repository":{"url":"git+https://github.com/404invalid-user/googlesheetsdb.git","type":"git"},"_npmVersion":"8.3.1","description":"get and add data to google sheets easily using objects ","directories":{},"_nodeVersion":"16.14.0","dependencies":{"googleapis":"^97.0.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/googlesheetsdb_1.0.0_1648032964298_0.9563051176788733","host":"s3://npm-registry-packages"}},"1.2.8":{"name":"@404invalid-user/googlesheetsdb","version":"1.2.8","keywords":["googleapis","mongoose","googlesheets"],"author":{"name":"404invalid-user"},"license":"MIT","_id":"@404invalid-user/googlesheetsdb@1.2.8","maintainers":[{"name":"404invalid-user","email":"user@invalidlag.com"}],"homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"dist":{"shasum":"ae6fb58fbbb28a77a5745bf41d21949fd220820f","tarball":"https://registry.npmjs.org/@404invalid-user/googlesheetsdb/-/googlesheetsdb-1.2.8.tgz","fileCount":3,"integrity":"sha512-Cajrz21fALsB0+gakUhjU3h7Rc9Ayh1bgtdRV90O+sCtuE+iBcD7U1h5yWM2R3n72yIPYzcWmmHSGNbQRtAd7g==","signatures":[{"sig":"MEUCIQCYGY4H6AzTKi/cVjaOICw1QFuufNYBN2JPopk9jNRXnAIgHHa13qFeausOVQhZ4L8GVYFCQxh87QiAKi9JUHcAnAI=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":14162,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJifpDZACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoohRAAl8i1Pp8Pag/Yz1o4stK98sgWDCnGD3cOW/DJoaWCMDBa+lBo\r\ndsHz+EHuKHzGj+x/35Scl7K9GAXW19uPEQMxeYeuMJ7DSvlNkT0RqWxtbW6R\r\nAx99l5F+ZSmB4wEc4Dz/hRR7/iEgW/d25bA+mDjkBJY0Vfpt3s8IU6EJ1+Lt\r\nvv7hOk2vncaxeRUuUe36jFeOjsVwckyC9J3+4rjqeaisnCR7Qyyz/e9NeU8m\r\nSJO+mHUNVS/UYAzXbIArd43J3MAhHeT2X9CGyWBBYxMQXrkJmfnLwJ8SKXer\r\n/5H9rypsmZW7oVzIdGfz7QzSFKsQnSZX0GQp8mQmedCY03dojYQYA773uQ4P\r\nxquCgEQ/A8tuHw3uEkd5lnKu5jiycMNXV5IzoJyXF9SPOcjaTisy1023Ionf\r\nRGGZ4FWaLc12DD5C/pbqB+bOXaJrqkewiX5VaswByUw7kdiDBb39p+vR7ZKv\r\ncLDJWoJd0bIwHMND8f6cBlH04hzHHZU103PZP+y7sn0GQobpjjd5kmROQQtx\r\nVR6MzZPKs9zf3jsMA+kQlPAzTJp10PD2wcI2n8OHUTtkuMMhFEIP/wDF+o8m\r\nF3YnjVy8a6scYnulX+deuW/5Cwzyx/oGb2Le16hL9u8HbBzza0xq4zHQ5hmy\r\nl61fXfu5qTV/nndSzTOISLo4/oKfJRfg1Hs=\r\n=eDyj\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"4390131650f010ee4c3d9c5915f70e426b91e379","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"404invalid-user","email":"user@invalidlag.com"},"repository":{"url":"git+https://github.com/404invalid-user/googlesheetsdb.git","type":"git"},"_npmVersion":"8.3.1","description":"get and add data to google sheets easily using objects ","directories":{},"_nodeVersion":"16.14.0","dependencies":{"googleapis":"^97.0.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/googlesheetsdb_1.2.8_1652461785176_0.7408845263694974","host":"s3://npm-registry-packages"}},"1.2.9":{"name":"@404invalid-user/googlesheetsdb","version":"1.2.9","keywords":["googleapis","mongoose","googlesheets"],"author":{"name":"404invalid-user"},"license":"MIT","_id":"@404invalid-user/googlesheetsdb@1.2.9","maintainers":[{"name":"404invalid-user","email":"user@invalidlag.com"}],"homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"dist":{"shasum":"fd70c6b7f4972ecfc58e6b442b5cf9058cbbec39","tarball":"https://registry.npmjs.org/@404invalid-user/googlesheetsdb/-/googlesheetsdb-1.2.9.tgz","fileCount":3,"integrity":"sha512-EiwbdtN2XwkQJPTuGoMVMxgyoZPSPKtXekhnJuO3T6qmsgDY26ppH2PaMsx0kL7djY07DDDLzD7+0PMc9fWqYA==","signatures":[{"sig":"MEQCICJY97LUfjajNFsU/xRb6E7nciuM1wsyPdnTYDZbXFl0AiBNGBlAw6taoN9bQXLMNzFO4G3cl3uAf438ravStMbjIA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":14162,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJifp8GACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmryMA//ZY0eRJqgi94ByMUu8hg6iSgeNrth5SeYqJW9HQhuvykimlsV\r\nY6inw2lFUossFeK7HO1VYULB15iceXDD+aW1EhRvsLKD/gDZqSrF8Tn36lvp\r\nMJPh4NThfhC+GGUBQLlkd1LGYhUjA6ku4dpXRf8MYshI6TDWx6m7+Id9s7ge\r\nHsR0msuXKPX/5FEVa9SU8PXp527/OMqQxKLZBgryzC0amTUNMbAYKPvW7ZGo\r\nCjBLjNIXYcbgOo9hsVvxGjQU4mHPlOH90hxf9O6S+9gvcsG36fNHJ1zUe8S+\r\nUeGaPKIxm+E0+3nj7bXqcDrShgaraNaq4DiVBGxoLNU3haq9/gMxHJdShAyE\r\nRrtBpHXIaIqQMyI8830+zz7ed6hdWDRC3cUuRlyS9yIolqFsOvl2DJB99M/O\r\nouFQy4T/ZQLkTh/OFOG/Yxv+pcZDyLt1PHH9GoWw/thnpKUDjxwBddNwivV1\r\n9HjzOR0rjhUKrCLFgXbwwjTgq2vl9G8KUCbyCcBiub7LmGY0HXEhY4negoBn\r\nQ+PLLy3KqBQAGzClO35ToGiQg3xtZWflgkfmoFWlcmJQ35DIzMJxRmdS/hbi\r\npGCGMWGbqqOz+mPZsl5ECwWZW21khZVgDHgAIcxesDacCvETaJFGeMyVEUdi\r\nqkpkHTl8yvcentf+aj0BteMhy8+FFOc5wsw=\r\n=jzrT\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"4390131650f010ee4c3d9c5915f70e426b91e379","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"404invalid-user","email":"user@invalidlag.com"},"repository":{"url":"git+https://github.com/404invalid-user/googlesheetsdb.git","type":"git"},"_npmVersion":"8.3.1","description":"get and add data to google sheets easily using objects ","directories":{},"_nodeVersion":"16.14.0","dependencies":{"googleapis":"^97.0.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/googlesheetsdb_1.2.9_1652465414499_0.035125480818116284","host":"s3://npm-registry-packages"}},"1.0.1":{"name":"@404invalid-user/googlesheetsdb","version":"1.0.1","keywords":["googleapis","mongoose","googlesheets"],"author":{"url":"https://invaliduser.xyz","name":"404invalid-user"},"license":"MIT","_id":"@404invalid-user/googlesheetsdb@1.0.1","maintainers":[{"name":"404invalid-user","email":"invaliduser@bruvland.com"}],"homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"dist":{"shasum":"cb08daab45c16cb31d80a6e2308d3281689bac65","tarball":"https://registry.npmjs.org/@404invalid-user/googlesheetsdb/-/googlesheetsdb-1.0.1.tgz","fileCount":3,"integrity":"sha512-uiYeOKC0EmKsy+Sw+v2nE3Q5dwMEeNOZdVo3GTweH6Yu8PhjsQWIDPVm+pVMZ1Wknm/3VPSKLvqnZZ+oTmmGvg==","signatures":[{"sig":"MEQCIFbaDJXUs8MmAxVEYa8nd8Ty16x0cqLwRuojYbEtt87gAiAQm3OoqIWcG2RXvx5Hh71liP6+zLdj3rmWMwhdq4ILdA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":14813,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJjW/AJACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqsOg//futMGSDI0XBXqVmxAPMUCi7ti9lIItETqp/fmNe6f2ci2zZG\r\ngbcH5TAxbdtCqgscoFwVTtEQDr7eSlksfWUMDrMu2H415cDLEAT61p9bfXYw\r\nBy90fEOfNZVYdBHJNrzzouxHehxkQPD9v3BkUKLVqW6Ap86hF5JlCoTKHbvU\r\nfMNvZ7ZXffd9WVCTLwjMIxwt8VxD73uwNCu0ukmv8gRjrfkNh5k/NmWzDKEa\r\nuNOCk3UBUNZDfpfprp4KkaAcsOKAwUo4FevRTOBCK2vIvO+tmabED1LlET89\r\n8K8QVFToA/NllQ8VvlrP0nmVFbTZ2azaKbtoinLBm0dWDWTz1YZxv1fxPc47\r\nmVug21uhea3mM61bhdAvjQIdKD1o+kykDH7nu9n4soBXKQO6APT6iMCRSEeA\r\nbKc6Tvu/8XcBq1guK2Mn2ZYX9nKC0Pnbor+v5o2K40XyOu1+DzU7mfH0cKHF\r\njBqKhy0GK2NEp9b5clowE7K8SGfUiVOdKi760r/zSqUB+0uT/uuqvq0JbSlL\r\nSUEznFm89CZ/yJhiMrAsKtjANmmF8bWQc4MbmQ/knW9ate0KQCJHl9k/wF6g\r\ncSCRU3twkJoK7b1TYWUiRgjtintxAkNgYzvwi/Xj3IsCqAZXjYAwUYGC/hHa\r\nDeWFgUu5z7LVIrVblM2X3trR11fv5hgYa2I=\r\n=x0Ny\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"404invalid-user","email":"invaliduser@bruvland.com"},"repository":{"url":"git+https://github.com/404invalid-user/googlesheetsdb.git","type":"git"},"_npmVersion":"8.11.0","description":"get and add data to google sheets easily using objects ","directories":{},"_nodeVersion":"16.16.0","dependencies":{"googleapis":"^97.0.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/googlesheetsdb_1.0.1_1666969609142_0.5403524290474035","host":"s3://npm-registry-packages"}},"1.3.0":{"name":"@404invalid-user/googlesheetsdb","version":"1.3.0","keywords":["googleapis","mongoose","googlesheets"],"author":{"url":"https://invaliduser.xyz","name":"404invalid-user"},"license":"MIT","_id":"@404invalid-user/googlesheetsdb@1.3.0","maintainers":[{"name":"404invalid-user","email":"invaliduser@bruvland.com"}],"homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"dist":{"shasum":"4276fc9c16cca9bb463ad1995502e9b357f10abc","tarball":"https://registry.npmjs.org/@404invalid-user/googlesheetsdb/-/googlesheetsdb-1.3.0.tgz","fileCount":3,"integrity":"sha512-XRqSl378BUaeK0aaRSghi4JJn+QkTWwTFeJR4HDr08gLPgx8mDkuk/3JYNSvxpmN6lEw6H4/GThBN97ecmRFgA==","signatures":[{"sig":"MEUCIQDpmr02VwyM0+X/Txu8t6jBNqo52k4PBK/UU618seiOBAIgHMnLTanHk/6on5kOv9DzOUTyHDhjKAORqQnrFk8ANVo=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":8563},"main":"index.js","gitHead":"29098acbe2538730e0c62e2830d1fc7987502e2b","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"404invalid-user","email":"invaliduser@bruvland.com"},"repository":{"url":"git+https://github.com/404invalid-user/googlesheetsdb.git","type":"git"},"_npmVersion":"11.11.0","description":"get and add data to google sheets easily using objects ","directories":{},"_nodeVersion":"25.8.1","dependencies":{"@404invalid-user/googlesheetsdb":"^1.0.1"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/googlesheetsdb_1.3.0_1780181473792_0.6132276814288029","host":"s3://npm-registry-packages-npm-production"}},"3.0.0":{"name":"@404invalid-user/googlesheetsdb","version":"3.0.0","description":"get and add data to google sheets easily using objects","main":"dist/index.js","type":"module","scripts":{"build":"npx tsc"},"repository":{"type":"git","url":"git+https://github.com/404invalid-user/googlesheetsdb.git"},"author":{"name":"404invalid-user","url":"https://invaliduser.xyz"},"license":"MIT","bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","keywords":["googleapis","mongoose","googlesheets"],"dependencies":{"googleapis":"^171.4.0"},"devDependencies":{"@types/node":"^25.0.0","ts-node":"^10.9.2","typescript":"^5.9.3"},"gitHead":"36334ff119fb85e1d8e9bb47678d8a25d9f71655","_id":"@404invalid-user/googlesheetsdb@3.0.0","_nodeVersion":"25.8.1","_npmVersion":"11.11.0","dist":{"integrity":"sha512-xtP0Cd56aDWI/0bWuUKF4V/UnMze7glCYudiClA/k78daFD/l9sZvWACNI+nFiEiNkI8Z+BP52Wc3CaU5bIRGw==","shasum":"27316c7df527f4cbe2e2938dda8d60d0f44f14b2","tarball":"https://registry.npmjs.org/@404invalid-user/googlesheetsdb/-/googlesheetsdb-3.0.0.tgz","fileCount":5,"unpackedSize":11289,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQCeKmZV0sPNa9OXr+8hY2KQj9ggYaSVpeueZ+FIe7jp+AIgHip1h8sVGdvVSZ4z0TGn9elMBbqIem0om+fPTsESaus="}]},"_npmUser":{"name":"404invalid-user","email":"invaliduser@bruvland.com"},"directories":{},"maintainers":[{"name":"404invalid-user","email":"invaliduser@bruvland.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/googlesheetsdb_3.0.0_1780223445576_0.641365040446163"},"_hasShrinkwrap":false}},"time":{"created":"2022-03-23T10:56:04.233Z","modified":"2026-05-31T10:30:45.807Z","1.0.0":"2022-03-23T10:56:04.437Z","1.2.8":"2022-05-13T17:09:45.525Z","1.2.9":"2022-05-13T18:10:14.802Z","1.0.1":"2022-10-28T15:06:49.273Z","1.3.0":"2026-05-30T22:51:13.943Z","3.0.0":"2026-05-31T10:30:45.709Z"},"bugs":{"url":"https://github.com/404invalid-user/googlesheetsdb/issues"},"author":{"name":"404invalid-user","url":"https://invaliduser.xyz"},"license":"MIT","homepage":"https://github.com/404invalid-user/googlesheetsdb#readme","keywords":["googleapis","mongoose","googlesheets"],"repository":{"type":"git","url":"git+https://github.com/404invalid-user/googlesheetsdb.git"},"description":"get and add data to google sheets easily using objects","maintainers":[{"name":"404invalid-user","email":"invaliduser@bruvland.com"}],"readme":"# google sheetsdatabase\n## get and add data to google sheets easily using objects \n ![version](https://img.shields.io/badge/version-3.0.0-green) \n googlesheetsdb is a package for the [googleapis](https://www.npmjs.com/package/googleapis) package that makes it more like the [mongoose](https://www.npmjs.com/package/mongoose) package when getting and adding data.\n\nto be clear this should not be used as your main production database as you can only store 1000 or so documents\n\n## setup\nassuming you have already gone to https://docs.google.com/spreadsheets and made a sheet that looks some what like this ![sheets image](http://bisot.xyz/!invalid-user/qIndDtJSv.png)\n\nfirst setup and login\n```js\nimport SheetDB from '@404invalid-user/googlesheetsdb';\n\nconst sheetid = '1aFHYCF_2QyzSRQDyICWy--CWOXbbvDr7SwY4uJWcMoM' //this will be your sheet id you can find this in the url\nconst page = 'Sheet1' //the page in your sheet, you can find and edit these at the bottom of your sheets\nconst idname = 'id' //the name of your id cell (defaults to id)\n\n//make a new instance and pass the details though\nconst sheet = new SheetDB(sheetid, page, idname);\n\n//path to the json file you got from the google api console\n//this takes an absolute path so we will use path to get it\nconst serviceAccountKeyPath = path.join(import.meta.dirname, '..', 'service-account-key.json');\n//now you authenticate with google sheets\ngoogleSheet.setup(serviceAccountKeyPath).catch(error => {\n   console.log(\"something has gone wrong: \" + error.stack || error)\n});\n```\n\n\n## docs\n\n### .findById(<id>) - get a row by the id cell name and returns an object\nexample assuming you have setup your sheet as sheet\n```js\nasync function GetPerson() {\n  const person = await sheet.findById('1');\n  console.log(\"name: \" + person.name);\n  console.log(\"age: \" + person.age);\n}\n\nGetPerson();\n```\n\n### ( await .findById(<id>)).save() - saves the changes you make to that object\nexample\n```js\nasync function UpdateAge() {\n  const person = await sheet.findById('1');\n  console.log(\"name: \" + person.name);\n  console.log(\"age: \" + person.age);\n  //return is a string so number operations wont work\n  person.age  = (parseInt(person.age)++).toString();\n  person.save().catch(error => {\n    console.log(\"error saving person likely no edit permission: \" + error.stack || error);\n  });\n  //see your google sheet it should have updated unless your application doesn't have edit permission\n}\n\nUpdateAge();\n```\n\n### .getAll() - gets all columns and returns an array of objects\nexample\n```js\nasync function GetPeople() {\n  const people = await sheet.getAll();\n  console.log(\"people: \" + JSON.stringify(people));\n  \n  //get first person in array\n  const person = people[0];\n  console.log(\"name: \" + person.name);\n  console.log(\"age: \" + person.age);\n}\n\nGetPeople();\n```\n### .create(<object>) - inserts new object to google sheets\nexample\n```js\nasync function NewPerson() {\n  const jon = {id: '4', name: 'jon', age: 23};\n  sheet.create(jon).catch(error => {\n    console.log(\"error creating person likely no edit permission: \" + error.stack || error);\n  });;\n}\n\nNewPerson();\n```\n\n## todo\n- [x] find by id\n- [x] .save()\n- [x] .create()\n- [ ] .find()\n- [x] .findById()\n- [x] .getAll()\n\n## help and support\nyou can join my discord server [https://discord.gg/RYQbmj7](https://discord.gg/RYQbmj7) or [open an issue](https://github.com/404invalid-user/googlesheetsdb/issues)\n \n","readmeFilename":"readme.md"}