Checkout how to build Email Marketing Tool on google sheets 👉 [ Ссылка ]
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 ➜ [ Ссылка ]
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 ➜ [ Ссылка ]
That's it! You are successfully connected to your Google sheets and Mongo DB.
********** Tutorial Playlists **********
Google apps script tutorial for beginners- [ Ссылка ]
Automate internet explorer with VBA- [ Ссылка ]
Autoit tutorials for beginners- [ Ссылка ]
Selenium Webdriver tutorials for beginners -[ Ссылка ]
****** Contact me ********
Blog: [ Ссылка ]
FB page: [ Ссылка ]
******* Books written by me ********
Autoit tutorials for beginners: [ Ссылка ]
Excel VBA for beginners: [ Ссылка ]
******* Productivity tool *********
My Favorite YouTube Tools ➜ [ Ссылка ] and ➜[ Ссылка ]
******* Gear Used To Shoot This Video ******
_Audio & Microphone
[ Ссылка ]
********Learning partner********
Video courses ➜[ Ссылка ]
Don't forget to subscribe! [ Ссылка ]
💼 To Hire Me 👉 [ Ссылка ]
Checkout my app 👉 [ Ссылка ]
How to connect MongoDB to Google sheets with Google Apps Script
Теги
mongodb atlas apiHow to Connect Google Sheets and MongoDBConnect your Google Sheets to MongoDB integrationConnect MongoDB to Google SheetsHow to connect MongoDB to Google SheetsMongoDB Stitch To Create An API For Data In Google SheetsHow to connect Google Sheets to MongoDBIntegrate Google Sheets with MongoDB for AnalyticsConnect to MongoDB Data in Google Apps ScriptImport MongoDB Data into Google Sheetsapps script execute queryapps script connect to database