{"_id":"apostrophe-google-spreadsheet","_rev":"41-1fe6124d32bf389105ccf1d78a474118","name":"apostrophe-google-spreadsheet","dist-tags":{"latest":"0.1.2"},"versions":{"0.0.1":{"name":"apostrophe-google-spreadsheet","version":"0.0.1","keywords":["google","spreadsheets"],"author":{"url":"http://punkave.com/","name":"Kerry Gilbert","email":"kerry@punkave.com"},"license":"ISC","_id":"apostrophe-google-spreadsheet@0.0.1","maintainers":[{"name":"colpanik","email":"kerry@punkave.com"}],"homepage":"https://github.com/punkave/apostrophe-google-spreadsheet","bugs":{"url":"https://github.com/punkave/apostrophe-google-spreadsheet/issues"},"dist":{"shasum":"1bd04680897d6612a3beaeaccde0f012545c3cbe","tarball":"https://registry.npmjs.org/apostrophe-google-spreadsheet/-/apostrophe-google-spreadsheet-0.0.1.tgz","integrity":"sha512-bUWCK3Vxhy1OoCWXfaYTheLQI+7xVZ3DJzr2qhit2zmcWejspv3S0YmVCMIIchQHvuKVMWgZ8bsTjiBOpWgvwQ==","signatures":[{"sig":"MEQCIHagwiHF7DNcu6HeSieE+Fz70sPUTJMDEgLQmUUT7TsXAiA4gbVmtzEiFIzQcwrf5yDk24hUeWl34v84rt5AZZv1kA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"colpanik","email":"kerry@punkave.com"},"repository":{"url":"git://github.com/punkave/apostrophe-google-spreadsheet.git","type":"git"},"_npmVersion":"1.4.3","description":"Link your apostrophe project with a spreadsheet in google drive. Sync the data as JSON and store it in its own mongo collection. Takes simple, apostrophe-site configuration in app js. Exposes a command line task and apostrophe UI for initiating a sync.","directories":{},"dependencies":{"edit-google-spreadsheet":"*"},"devDependencies":{}},"0.1.0":{"name":"apostrophe-google-spreadsheet","version":"0.1.0","keywords":["google","spreadsheets"],"author":{"url":"http://punkave.com/","name":"Kerry Gilbert","email":"kerry@punkave.com"},"license":"ISC","_id":"apostrophe-google-spreadsheet@0.1.0","maintainers":[{"name":"colpanik","email":"kerry@punkave.com"}],"homepage":"https://github.com/punkave/apostrophe-google-spreadsheet","bugs":{"url":"https://github.com/punkave/apostrophe-google-spreadsheet/issues"},"dist":{"shasum":"b18a855dc812517c86ffc32e8a2e7085bbbbe211","tarball":"https://registry.npmjs.org/apostrophe-google-spreadsheet/-/apostrophe-google-spreadsheet-0.1.0.tgz","integrity":"sha512-7BoUrBsNK1Hm0BfvZUhOauoAIDX9HJSXmHYRqXj887ZVbRUr3Mn4F0gm2P3Qxb94N+egMO2Cf5GRVDL/77eevg==","signatures":[{"sig":"MEUCIGWNpjAFhRyt/b+JU+qX5xMOujPHWy4Yhz2NPtKCkbkOAiEA2Lhmb5ItBApM9yZani91uLZLbgyWhV+drO4O2yokp3c=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"colpanik","email":"kerry@punkave.com"},"repository":{"url":"git://github.com/punkave/apostrophe-google-spreadsheet.git","type":"git"},"_npmVersion":"1.4.3","description":"Link your apostrophe project with a spreadsheet in google drive. Sync the data as JSON and store it in its own mongo collection. Takes simple, apostrophe-site configuration in app js. Exposes a command line task and apostrophe UI for initiating a sync.","directories":{},"dependencies":{"edit-google-spreadsheet":"*"},"devDependencies":{}},"0.1.1":{"name":"apostrophe-google-spreadsheet","version":"0.1.1","keywords":["google","spreadsheets"],"author":{"url":"http://punkave.com/","name":"Kerry Gilbert","email":"kerry@punkave.com"},"license":"ISC","_id":"apostrophe-google-spreadsheet@0.1.1","maintainers":[{"name":"colpanik","email":"kerry@punkave.com"}],"homepage":"https://github.com/punkave/apostrophe-google-spreadsheet","bugs":{"url":"https://github.com/punkave/apostrophe-google-spreadsheet/issues"},"dist":{"shasum":"8ae34ae62ea7210cab99290f7f133865c8da0dfb","tarball":"https://registry.npmjs.org/apostrophe-google-spreadsheet/-/apostrophe-google-spreadsheet-0.1.1.tgz","integrity":"sha512-76BROWGN7put6PhV/nuOwDsh1pQ4gBvM+j212qR1kq6e3xg46BJbfB9K9yLEAQznW8JRYa/bPqC3NJ/6LbaWNg==","signatures":[{"sig":"MEQCIEbW0usfNzO5WX6F7l+c2bVNGi+lLwnZ6wb009GP0CEOAiB9tccAu69sNMuITWL+QS1TVqlqvsLDp4gy3Ht2ZXGQcw==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"colpanik","email":"kerry@punkave.com"},"repository":{"url":"git://github.com/punkave/apostrophe-google-spreadsheet.git","type":"git"},"_npmVersion":"1.4.3","description":"Link your apostrophe project with a spreadsheet in google drive. Sync the data as JSON and store it in its own mongo collection. Takes simple, apostrophe-site configuration in app js. Exposes a command line task and apostrophe UI for initiating a sync.","directories":{},"dependencies":{"edit-google-spreadsheet":"*"},"devDependencies":{}},"0.1.2":{"name":"apostrophe-google-spreadsheet","version":"0.1.2","keywords":["google","spreadsheets"],"author":{"url":"http://punkave.com/","name":"Kerry Gilbert","email":"kerry@punkave.com"},"license":"ISC","_id":"apostrophe-google-spreadsheet@0.1.2","maintainers":[{"name":"colpanik","email":"kerry@punkave.com"}],"homepage":"https://github.com/punkave/apostrophe-google-spreadsheet","bugs":{"url":"https://github.com/punkave/apostrophe-google-spreadsheet/issues"},"dist":{"shasum":"283996c9b4f88309e20483460c35bbb124b62fa3","tarball":"https://registry.npmjs.org/apostrophe-google-spreadsheet/-/apostrophe-google-spreadsheet-0.1.2.tgz","integrity":"sha512-MmvF7viXeR/hBkzIuu/RDeeZ8ICFjE/XYxFgOrlT5pWCfpgtaen/h23DL2gKMx0MnVPIAP8d4KkuK957fPtZiQ==","signatures":[{"sig":"MEUCIQDZjKSH3K3i9SFH/Jg7Rw1KEjHZU2rpoF6P602tC+aL5gIgZsPVxEw3xUa2IIiJPMRMx2Fbw3/AOJCEmOlCdAFR9yc=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"colpanik","email":"kerry@punkave.com"},"repository":{"url":"git://github.com/punkave/apostrophe-google-spreadsheet.git","type":"git"},"_npmVersion":"1.4.3","description":"Link your apostrophe project with a spreadsheet in google drive. Sync the data as JSON and store it in its own mongo collection. Takes simple, apostrophe-site configuration in app js. Exposes a command line task and apostrophe UI for initiating a sync.","directories":{},"dependencies":{"ent":"*","edit-google-spreadsheet":"*"},"devDependencies":{}}},"time":{"created":"2014-09-12T19:49:37.942Z","modified":"2026-01-26T19:09:37.664Z","0.0.1":"2014-09-12T19:49:37.942Z","0.1.0":"2014-10-01T18:24:57.675Z","0.1.1":"2014-10-01T18:26:28.603Z","0.1.2":"2014-10-03T14:49:38.619Z"},"bugs":{"url":"https://github.com/punkave/apostrophe-google-spreadsheet/issues"},"author":{"url":"http://punkave.com/","name":"Kerry Gilbert","email":"kerry@punkave.com"},"license":"ISC","homepage":"https://github.com/punkave/apostrophe-google-spreadsheet","keywords":["google","spreadsheets"],"repository":{"url":"git://github.com/punkave/apostrophe-google-spreadsheet.git","type":"git"},"description":"Link your apostrophe project with a spreadsheet in google drive. Sync the data as JSON and store it in its own mongo collection. Takes simple, apostrophe-site configuration in app js. Exposes a command line task and apostrophe UI for initiating a sync.","maintainers":[{"email":"alex@apostrophecms.com","name":"alexgilbert"},{"email":"tom@apostrophecms.com","name":"boutell"},{"email":"stuart+npm@apostrophecms.com","name":"romanek"},{"email":"robert.means1969+apostrophecms@gmail.com","name":"bodonkey"},{"email":"kerry@punkave.com","name":"colpanik"},{"email":"stuart@punkave.com","name":"stuartromanek"},{"email":"mcoppola832@gmail.com","name":"mcoppola"},{"email":"jimmy@punkave.com","name":"jimmyh"},{"email":"austin.starin@gmail.com","name":"austinstarin"},{"email":"ajchappelle@gmail.com","name":"arti5m"},{"email":"grdunn@gmail.com","name":"grdunn"},{"email":"bgantick@gmail.com","name":"bgantick"},{"email":"abea@mailbox.org","name":"alexbea"},{"email":"matthew.mance@gmail.com","name":"mtthwmnc"}],"readme":"# Apostrophe Google Spreadsheet\n\nApostrophe Google Spreadsheet allows you to connect a spreadsheet in Google Drive with your MongoDB, convert/sync the data at your whim and query the collection later on.\n\n### Configuration\n\nIn your app js. Just initialize it in apostrophe-site as you would any other module\n\n```javascript\nmodules: {\n  'apostrophe-ui-2': {},\n  'apostrophe-people': {},\n  'apostrophe-groups': {},\n  'apostrophe-editor-2': {},\n  'apostrophe-redirects': {},\n  'apostrophe-google-spreadsheet': {\n    spreadsheetID: 'xxxxxxxxxxxxx',\n    authEmail: 'xxxxxxxxxxxx',\n    keyPath: __dirname + '/auth/spreadsheet.pem'\n  },\n  'apostrophe-pie-charts': {}\n}\n```\n\n#### Required options\nYou absolutely need to specify a spreadsheetID, authEmail and keyPath in order for this module to work. Not sure how to get those? This article is incredibly helpful: http://www.nczonline.net/blog/2014/03/04/accessing-google-spreadsheets-from-node-js/\n\n\n## Usage\n\n#### 1. Use it as a command line task\n```\n$ node app apostrophe:sync-google-spreadsheet\n```\n\n####  2. Hit the /sync route with an ajax call or in browser\nlocalhost:3000/apos-google-spreadsheet/sync\n\nBy default, the data is stored in a mongo collection called \"aposSheets\". If you'd like this to be something different, just specify a collectionName in your options when initializing the module.\n\nBe aware that each time you run a sync, the collection is dropped and then populated by your new spreadsheet data. There is no updating. Only total destruction and then repopulation (for now).\n\n#### Accessing the data from other modules\n\nYou can query your aposSheets collection in the same way you would with apostrophe-snippets based modules (events, maps, etc.).\n\n```javascript\nvar sheet = self.site.modules['apostrophe-google-spreadsheet'];\n\nself.app.get('/sheet-json', function(req, res) {\n  return sheet.get({}, {}, function(err, docs){\n    // do something with your json or whatever!\n    return res.send(docs);\n  });\n});\n```\n\n#### To - Do\nCreate aposLocal \"aposSpreadsheetsMenu\" and necessary templates to include sync button the admin bar\n\n","readmeFilename":"README.md","users":{"vghhkjh":true}}