search

Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
236 stars 46 forks source link

JSON format for MongoDB import #13

Open simonengelke opened 7 years ago

simonengelke commented 7 years ago

It would be great to get a JSON file which can easily be imported into MongoDB (at the moment I get only one document with "mongoimport" for an entire spreadsheets with multiple rows). Here is an example for a working JSON file from MongoDB: https://raw.githubusercontent.com/mongodb/docs-assets/primer-dataset/primer-dataset.json

Synthoid commented 7 years ago

Should be possible. In this case, each sheet row would be exported as a JSON blob confined to a single line of the exported file? Meaning that each line could be read in as a standalone JSON blob, correct?

simonengelke commented 7 years ago

Yes, exactly.

flutter-painter commented 4 years ago

Hi, Sacha found a way to push from spreadsheet to mongo through Stitch. There should be a way to broaden the code / scheme outside of our specific case

flutter-painter commented 4 years ago

Here is a google sheet script template :

Here is a stitch webhook template :

Doc from mongo on how to create the 3rd party service in mongo : https://docs.mongodb.com/stitch/getting-started/integrate-third-party-services/

@Synthoid please let me know if this works on your side