Import data from MongoDB to Google sheets using Google apps script
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-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