mongosheet is a Google Spreadsheet Addon that use can use to run all CRUD operation on mongoDB database. You can think this a spreadsheet interface for mongoDB.
Clone this project.
Change the connection string in the .env file.
Deploy the project on your server.
Go to Google Spreadsheet and click on Extentions > Add-ons > Get add-ons > Search for MongoSheet > Install.
Or click on the link below to install the addon.
https://gsuite.google.com/u/0/marketplace/app/mongosheet/373297131098
Open the addon in the sidebar and it will be asking to provide the connection setup.
In the project name field you can give any name, its an identifier for you.
In the App URL field provide the URL of the project that you deployed in the earlier step.
In the Collection field provide the name of collection that you want to connect to.
BANG! you are done. Now can run queries, and run update command on the collection. This is fast, safe and easiet method to bring your mongoDB data to a spreadsheet.
For testing the addon you can use following properties.
Project: Sample
App URL: https://mongosheet-api.appspot.com
Collection: family
In the spreadsheet create a new sheet called "Main". Sheet "Main" is the entry for the addon.
In the first row give the following column names.
A1: _id
B1: father
C1: mother
D1: kids:array
For bugs and feature request feel free to open a issue.
Send me an email at hello@mongosheet.com