public_sheet_to_javascript_object.js

const fetchSheet = async (sheetId) => {
    try {
      var records = []
      const response = await fetch(
        `https://spreadsheets.google.com/feeds/list/${sheetId}/od6/public/values?alt=json`,
      );
      const responseJson = await response.json();
      const { entry } = responseJson.feed;
      records = entry.map(row => ({
        column1: row.gsx$column1.$t,
        column2: row.gsx$column2.$t,
        column3: row.gsx$column3.$t,
        column4: row.gsx$column4.$t,
      }));
    } catch (error) {
      console.error(error)
    } finally {
      console.table(records)
    }
}