Google sheet to JSON link and accessing that data with JavaScript

sheet2json.js

const spreadsheetId = '1bPt3cGhnfvqASOmcpvBQglPqg_fnU6aZktlYA8gqEdw'
fetch(`https://docs.google.com/spreadsheets/d/${spreadsheetId}/gviz/tq?tqx=out:json`)
    .then(res => res.text())
    .then(text => {
        const json = JSON.parse(text.substr(47).slice(0, -2));
        console.log(json);
    })