gosit

Reading Google Sheets

Installation

npm i gosit

Usage

import gosit from "gosit";

async function run() {
  let result = await gosit(
    "abc123!@#456", // spreadsheet id
    "data" // sheet name
  );
  console.log(result);
}
run();

Result

[
  {
    name: "John Doe",
    age: "20",
    address: "Jl. Jalan",
  },
  {
    name: "Jane Doe",
    age: "21",
    address: "Jl. Jalan",
  },
];