bchampp

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

bchampp

// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.

var FORMAT_ONELINE   = 'One-line';
var FORMAT_MULTILINE = 'Multi-line';
var FORMAT_PRETTY    = 'Pretty';

var LANGUAGE_JS      = 'JavaScript';
var LANGUAGE_PYTHON  = 'Python';