Google Sheets as a Backend + HTML5 Fetch Example

const SPREADSHEET_KEY = '<key here>'; const CONTACT_FORM = 1; fetch(`${SPREADSHEET_KEY}/${CONTACT_FORM}/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:<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.