1

I want to send data from google sheets to mongodb I am having a problem in sending my data mainly the array field in google sheets.I am new to this Thanks in advance. Following is my code

THIS IS code.gs FILE in spreadsheet I have tried Array(word), [word] ,String(word) and many more

function myFunction() {
  var sh1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Input");
  var rng = sh1.getDataRange().getValues();
  for(var i=1;i<3;i++){
    var sort =rng[i][9];
// basically sort is a string like "a, b, c, d, e, f" i have split the term based on ', '

    let word = sort.split(', '); 
   //word is an array which i want to import to my database
    var formData ={
    'Email':rng[i][1],
    'Timestamp':rng[i][0],
    'Attended':rng[i][2],
    'First Name':rng[i][3],
    'Phone Number':String(rng[i][4]),
    'Mob numbers':String(rng[i][5]),
    'Graduation Degree':rng[i][6],
    'Year of Study':rng[i][7],
    'College Name':rng[i][8],
    'Area of Interest':JSON.stringify(word),
    'referral code':rng[i][10],
    'Questions to the speaker':rng[i][11],
    'Current City':rng[i][12],
    'Interest Ratings':rng[i][13],
    'Filled form':rng[i][14],
    'Questions Asked':rng[i][15],                                   
  }
  Logger.log(formData);
    var params = {
   'method':'post',
  'payload':formData
  }
       var getId = UrlFetchApp.fetch('my url goes here',params); 
}
}

This is the Code in webhook0 editor(POST REQUEST) ( By default all the fields are String ,I generated a Schema in Realm but that didn't work either)

exports = async function(payload) {
    const mongodb = context.services.get("mongodb-atlas");
    const eventsdb = mongodb.db("mydb");
    const eventscoll = eventsdb.collection("analysis");
    const result= await eventscoll.insertOne(payload.query);
    var id = result.insertedId.toString();
    if(result) {
        return JSON.stringify(id,false,false);  
     }
      return { text: `Error saving` };

Input Data From google sheet Google sheet data Data is Stored this wayCollection

0 Answers0