How to connect MongoDB to Google sheets with Google Apps Script

Checkout how to build Email Marketing Tool on google sheets 👉 https://youtu.be/gy7ypKE6rbg

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/b107b7d7c64d60a6951c5df5bbdc61af

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/5ed9f53ea9566e0f098e9dc6f9d5661d

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-tutorial-for-beginners
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: http://www.facebook.com/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/click?id=832arX/53N8&offerid=323058.81&type=3&subid=0

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

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

👉 Kite is a free AI-powered coding assistant that will help you code faster & smarter. It integrates seamlessly with all top editors and IDE. Kite gives you smart completions and documentation while you’re typing. I’ve been using Kite on VSCode for 6 months and I love it! Check out Kite 👉 http://bit.ly/get-kite