Google Sheet Data API JSON AJAX
4.5 (88 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.
3,037 students enrolled

Google Sheet Data API JSON AJAX

Use data from your Google Sheet in your website, GET and POST content to Google Sheets using AJAX and Google Script
4.5 (88 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.
3,037 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
13 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 8 articles
  • 10 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
  • Connect a web application to Google Sheets data
  • Use AJAX to request and receive responses
Course content
Expand all 20 lectures 01:31:10
+ Introduction to using Google Sheets data with AJAX
19 lectures 01:29:56
Source Code Google Script
00:02
Output Sheet Data
06:38
Source Lesson 3 GS data
00:14
App Script Google Scripting
08:36
Use Google Script to Create Output
15:36
Google Script Source 5
00:10
JSON feed from Google Sheets
06:07
Source Code Lesson 6
00:13
Google Script POST data
12:02
Google Script Lesson 7
00:22
Form Setup to Post
04:22
Post data to Google Sheets
05:58
Random User Data API
06:30
Project Overview and Review
08:25
Final Application Source Code
00:39
Section resources
00:02
Requirements
  • JavaScript HTML and CSS
  • Web development skills
  • Desire to Learn
Description

Have you ever want to get data from your Google Spreadsheet and use it in a web application?

If yes then this course is perfect for you :)

Step by step instruction on how to setup Google Sheets with a web app outputting data as JSON.  Use AJAX from your web application to get that data into your JavaScript code.  Extend this even further using Google Apps Script.  GET and POST to the Google Script web app adding and retrieving data in JSON format.

Apps Script is a scripting language for light-weight application development in the G Suite platform. ... According to Google, Apps Script "provides easy ways to automate tasks across Google products and third party services." Apps Script is also the tool that powers the add-ons for Google Docs, Sheets and Slides.   Power up your application with spreadsheet data no database required!!!!

Fast and friendly support in the Q&A section to help you learn

Source Code is included!!!

Taught by an instructor with over 18 years development experience ready to help you learn.

Exercise based course demonstrates building a fully functional web application from start to finish.   Reviewing the code and providing useful tips and resources along the way.  What are you waiting for join now and start exploring the amazing things YOU CAN DO with Google App Script and AJAX!!!

Who this course is for:
  • Web developers
  • Anyone who wants to learn more about AJAX JSON and Google Sheets
  • Anyone who wants to learn about Google Script
  • JavaScript developers