Get Google Sheets as JSON data for web applications
4.0 (108 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,609 students enrolled

Get Google Sheets as JSON data for web applications

Learn how to do more with Google Sheets integrate it the data into your own Applications get web app urls for the data
4.0 (108 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,609 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto]
Current price: $129.99 Original price: $199.99 Discount: 35% off
8 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 3 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Output Google Sheets data in a JSON format
  • Create web URL for Google Sheet data
  • Import Google sheets data into web applications
Course content
Expand all 13 lectures 58:11
+ Introduction to Google Sheets Data as JSON
12 lectures 56:57
Easy output of JSON feed containing Sheet Data
09:20
Example
00:04
Web application connecting via AJAX to Google Sheet
05:18
Sheet name output to HTML element
03:05
Loop data output to HTML
07:17
CSS styling Sheet output data in HTML
07:05
Add data to any web application
03:19
Course Review Overview
06:51
Source Code Examples and Links
00:22
Requirements
  • Google account
  • Some basic knowledge of HTML and AJAX
  • Desire to Learn
Description

Google provides a powerful set of tools with Google Apps.   Google sheets is a great place to store data within a spreadsheet.  Did you know you can use that data on the web?

Great introduction to Google Sheets and Google Script

  • Publish your Google Sheet data to the web.
  • Use Google Sheets data on your own webpages
  • Output Google Sheet data as JSON and add it anywhere
  • You will be amazed at how easy it is to work with Google Sheets

This course provides ways to use the data for web development and more.  Course covers outputting the data as a web app.  This will give you access to the data using a URL which you can then share online.   Select either one sheet or all its up to you no programming is needed.

Web application use case, this part of the course covers more advanced ways of using the data.  We show you how the data can be output as JSON data, select any sheet get it as JSON data.   JSON, or JavaScript Object Notation, is a minimal, readable format for structuring data.  Its perfect for use within web applications.  Adding jQuery for easy AJAX calls. With Ajax, Web applications can send data to and retrieve from a server asynchronously (in the background) without interfering with the display and behavior of the existing page.   Source code is included as well as how to update it to get the content from your own Google Sheet.  

Minimal programming is required for this course, but a basic understanding is needed for the more advanced web application functionality.

Google sheets provides a great way to collaborate and use data online within a nicely packaged spreadsheet.  Now you too can use that data.

I'm here to help you learn more about web applications and ready to answer any questions you may have.

Join now and start doing some amazing things online!




Who this course is for:
  • Anyone who wants to use Google Sheets data outside of Google Sheets
  • Perfect for web developers
  • Anyone who wants to see the power of Google Sheets