How to connect MongoDB to Google sheets with Google Apps Script

Checkout how to build Email Marketing Tool on google sheets 👉    • Build Your Own email marketing tool |Send ...  


In this video, you'll learn how to connect Google sheet with Mongo DB using the Stich service provided by MongoDB.

You need a (free) MongoDB account. Create a cluster on that account.

In MongoDB, under the services section, you can find "Stitch" option. Just select the option and click on "Create an app", just give a name and create a new app.


Go to the app and create a new service. In the function editor, paste the script from the below URL

Webhook URL ➜ https://gist.github.com/erajanraja24/...

Click on save and deploy the service.

After the service is successfully deployed, take the webhook URL and save it in your notepad.

Now create a new Google sheet and launch the script editor.

Paste the below script with your webhook URL
Google Apps Script ➜ https://gist.github.com/erajanraja24/...

That's it! You are successfully connected to your Google sheets and Mongo DB.


********* Tutorial Playlists *********
Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tut...
Automate internet explorer with VBA- https://goo.gl/Xmy8Af
Autoit tutorials for beginners- https://goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -https://goo.gl/QqxTrF

***** Contact me *******
Blog: http://www.amarindaz.com/contact/
FB page:   / amarindaz  

****** Books written by me *******
Autoit tutorials for beginners: http://amzn.to/2GjaDbD
Excel VBA for beginners: http://amzn.to/2nhI067

****** Productivity tool ********
My Favorite YouTube Tools ➜ https://goo.gl/MX9Z4p and ➜https://goo.gl/UW1uRX

****** Gear Used To Shoot This Video *****
_Audio & Microphone
http://amzn.to/2GibdGu

*******Learning partner*******
Video courses ➜https://click.linksynergy.com/fs-bin/...

Don't forget to subscribe! https://goo.gl/J2453w

💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK

Checkout my app 👉 https://www.myfreshtools.com