const { GoogleSheet } = require("node-googlesheet");

// update below variables value with your credential details...
const client_id = "";
const client_secret = "";
const refresh_token = "";
const redirect_uri = "";

const gs = new GoogleSheet("client_id_client_secret", {
    client_id, client_secret, refresh_token, redirect_uri
});

gs.setSpreadSheetToWorkWith(""); // For Ex: "1yFKedpLbKZ5MCHJaoXIz_9oc2_qoXZkUEyxTQQEfXtE"

(
    async () => {
        try {

            const data = await gs.read();

            console.log("Data : ", data);

        } catch (err) {
            console.log("err: ", err);
        }
    }
)();

const res = await gs.append([2, "MK", 20]); 
// append method takes two parameter having an array (array of values repesenting each cell) and second is string (range where you want to append the data)

console.log("res : ", res);

const res = await gs.update([2, "MK", 20], "Sheet!A1"); 
// update method takes two parameter having an array (array of values repesenting each cell) and second is string (range where you want to append the data)

console.log("res : ", res);

const res = await gs.deleteRowsOrColumn({
    sheetName: "Sheet1",
    indexesToBeDelete: {
        startIndex: 1, endIndex: 2
    }
});

console.log("res : ", res);