Reading Google Sheets
npm i gosit
import gosit from "gosit";
async function run() {
let result = await gosit(
"abc123!@#456", // spreadsheet id
"data" // sheet name
);
console.log(result);
}
run();
[
{
name: "John Doe",
age: "20",
address: "Jl. Jalan",
},
{
name: "Jane Doe",
age: "21",
address: "Jl. Jalan",
},
];