Skip to content

Instantly share code, notes, and snippets.

@erajanraja24

erajanraja24/Connect MongDB and Google Sheets

Created December 13, 2019 18:03
Show Gist options
  • Save erajanraja24/5ed9f53ea9566e0f098e9dc6f9d5661d to your computer and use it in GitHub Desktop.
Save erajanraja24/5ed9f53ea9566e0f098e9dc6f9d5661d to your computer and use it in GitHub Desktop.
Download ZIP
Connect MongDB and Google Sheets
Raw
Connect MongDB and Google Sheets
function connectToMongDB(){
var sh1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1")
var rng = sh1.getDataRange().getValues();
for(var i=1;i<rng.length; i++){
var formData = {
'name': rng[i][0],
'designation':rng[i][1]
}
var params = {
'method' : 'post',
'payload': formData
}
var getId = UrlFetchApp.fetch('<YOUR_WEBHOOK_URL>', params);
sh1.getRange(i+1, 3).setValue(getId);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment