[Vlasenko Fedor]

еще вариант

<script>
fetch("https://docs.google.com/spreadsheets/d/1iwGvYQZYe1oQU1809QG1qqJWUG84gxVLKyqWBWyvDqU/gviz/tq?sheet=goods&tq=where%20B%3D'A04'%20%20OR%20%20B%3D'A03'")
    .then(response => response.text())
    .then(text => JSON.parse(text.replace(/^.*\s.*?\((.*)\);/m, '$1')))
    .then(obj => {
        console.log(obj);
        alert(JSON.stringify(obj, null, "    "));
    })
    .catch(e => console.log(e.message));
</script>