fetch('https://spreadsheets.google.com/feeds/list/<spreadsheet-key>/<sheet-number>/public/basic?alt=json')
.then(response => response.json())
.then(response => response.feed.entry)
.then((body) => {
document.body.innerHTML = body;
});
1. Create a Google Sheets, Modify the content, Publish it (in the File menu)
2. Grab the Key of your URL spreadsheet and place it here: https://spreadsheets.google.com/feeds/list/<Key>/1/public/basic?alt=json
3. Fetch it to the Page
4. You are awesome!
2. Grab the Key of your URL spreadsheet and place it here: https://spreadsheets.google.com/feeds/list/<Key>/1/public/basic?alt=json
3. Fetch it to the Page
4. You are awesome!
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.