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