Google Sheets as a Backend + HTML5 Fetch Example

fetch('https://spreadsheets.google.com/feeds/list/<spreadsheet-key>/1/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!

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.