Back to Browse

Import data from MongoDB to Google sheets using Google apps script

8.7K views
Dec 14, 2019
13:48

In this video, you'll learn how to import data from MongoDB to Google sheets using Google apps script. You need to create a new stitch service and insert as function as a webhook that accepts payload and returns the collections data as a response. We need to copy the webhook URL and that acts as a REST API to get the data from the third party app. Now, I will go to the Google apps script and use the URLFetchApp method to get the data. Convert the MongoDB data to JSON and iterate through the values and populate it on Google sheets. Watch the video for step by step instructions.********** 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 Checkout my app 👉 https://www.myfreshtools.com

Download

0 formats

No download links available.

Import data from MongoDB to Google sheets using Google apps script | NatokHD