Convertir Google Sheet a JSON

main.js

const axios = require('axios').default;
const { read, utils } = require('xlsx');

require('dotenv').config();

const getSpreadsheet = async({ id, gid = 0, index = 0 }) => {
  const { data } = await axios({
    method: 'get',
    url: `https://docs.google.com/spreadsheets/d/${id}/export`,
    responseType: 'arraybuffer',
    params: { format: 'xlsx', id, gid },
  });
  const workbook = read(data);

  return utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[index]], { raw: false })
}

getSpreadsheet({ id: process.env.GROUPS_SHEETS_ID }).then(console.log);

package.json

{
  "dependencies": {
    "axios": "^0.27.2",
    "dotenv": "^16.0.1",
    "xlsx": "^0.18.5"
  }
}