[Publish Google Sheet to the Web] easily turn your google sheets into a JSON data source #gaspowered

readme.md

Publish Google Sheets to the Web

1. Publish your sheet to the web
2. Use the url: https://spreadsheets.google.com/feeds/cells/<<SS_ID>>/1/public/full?alt=json
3. Fetch the data in Codepen
4. Render the cells to the page

index.html

<ul></ul>

main.js

const ul = document.querySelector('ul');

async function getCells() {
  const response = await fetch('https://spreadsheets.google.com/feeds/cells/1KF03q656HEwFfrOjgLAsYUA1eAHfbVSXoFWegYzJZJ8/1/public/full?alt=json');
  const json = await response.json();
  return json.feed.entry;
}

async function onLoad() {
  const data = await getCells();
  const cells = data
    .filter(each => +each.gs$cell.col >= 3 && +each.gs$cell.row >= 2)
    .map(entry => `<li>${entry.gs$cell.inputValue}</li>`);
  
  ul.innerHTML = cells.join('');
}

onLoad();

This API doesn't work any more