August 2022
Intermediate to advanced
1h 17m
English
on-demand course
Learn how to Connect Data to Web Pages with JSON and JavaScript Fetch
with Laurence Svekis
Closed Captioning available in English
Overview
Improve and enhance your web site’s functionality by connecting your web pages directly to your data. User requests and queries will go to the data stored in your Google Sheets and get results returned in real time.
Learn how to connect to Google Sheets with JavaScript Fetch, and return queries in JSON. See how to use the data directly on your web pages and within your web applications. Making data requests using fetch provides a seamless experience to the user without page reload. The user interacts with the web page, triggering the events that call to the data source to return the results. Using Google Sheets provides a serverless way—without a database—to query a web data source.
Get practical experience building a sample dynamic web app. The example app creates a URL generator for your website that uses a simple input field to specify the appropriate Google Sheet, and then returns the results from interactive web input fields specific to each request.
Distributed by Manning Publications
This course was created independently by Laurence Svekis and is distributed by Manning through our exclusive liveVideo platform.
About the Technology
About the Video
What's Inside
- How to setup your Google Sheet to output data as a web endpoint
- Connect to a Google Sheet from JavaScript frontend code using Fetch
- Get Sheet data as JSON format so it can be used for JavaScript
- Output Sheet data into your webpages
- Create a URL generator website from scratch with HTML, CSS, and JavaScript
About the Reader
Experience with HTML, CSS, JSON, and JavaScript
About the Author
Laurence Svekis is an experienced Google developer who has worked on multiple enterprise level applications, hundreds of websites and business solutions, and many unique and innovative web applications. He created his first computer application in 1990 and first website in 1998. Laurence has been providing web development courses and digital marketing strategy courses since 2002, teaching countless learners how to bring amazing things to life online.
Quotes
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.