Laurence Svekis
Google Sheet Data as JSON JavaScript AJAX Google Apps Script
Are you looking to use your Google Sheet as a Data source for your web applications?
Create a web app with Google Apps Script to output your Sheet data as JSON
Web app can be used as an API endpoint to get JSON data from your Sheet content
Use AJAX to connect to your Google Sheet Data and output it in your web pages.
Connect Google Sheets to your web applications.
No Database needed for your content as JSON – you can use Google Apps Script to output the sheet data as JSON in a web app.
No Server needed use frontend code to get the JSON data and use it in your web applications.
Coding project – Create a dynamic quiz that uses Google Sheet data for questions.
Connect to the quiz data from JavaScript with a fetch request to the web app URL
Get the quiz data in JavaScript
How to build a dynamic data driven quiz with no backend code needed.
Please note that this is a coding course and previous coding experience is a prerequisite to the course.
Have you ever want to get data from your Google Spreadsheet and use it in a web application?
Instructor Details
Courses : 111
Specification: Google Sheet Data as JSON JavaScript AJAX Google Apps Script
|
13 reviews for Google Sheet Data as JSON JavaScript AJAX Google Apps Script
Add a review
| Price | $9.99 |
|---|---|
| Provider | |
| Duration | 6 hours |
| Year | 2021 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$9.99
Kevin Casault –
I got everything I wanted out of the course. I liked the instructors teaching style and the pace of the course
Isaiah –
Exactly what I asked for. A simple and straight forward course that brings value
Daniel Zamir –
Best delivery so far of this and related topics. Most highly specific, advanced courses on Udemy and elsewhere tend to either be boring or lacking in content, many times both. Not here.
Jaroslaw Ciszak –
It is giving simple solutions for very useful staff. I’m happy I took this course.
Jeff Creamer –
What I wanted to know was how to use Ajax to Get and Post data to a server from a stand alone web page. This course does go a way towards that, giving a sturdy example of how to do it in a page generated by HtmlService if no server problem arises. However A couple of questions left unanswered are bothering me. 1) What happens when a GET or POST fails, for example if the internet service goes down just before or after the request? And 2) Can this be done from a non HTMLService web page, possibly using CORS or JSONP, and if so, how? Do you treat these issues in another course? Thank you again for continuing to present other interesting and helpful tools , such as Postman and randomuser.me in the current course.
Johnathan Diaz Koester –
O curso exige que se tenha um conhecimento pr vio de linguagens javascripts, Jquery, HTML e conhecimento em programa o no Google Apps Script (GAS). Atendeu muito bem minha expectativa! Enquanto assistia a aula, era poss vel desenvolver minha aplica o conforme as instru es.
Thomas Lauzon –
clear
zoe lu –
For beginners, it is very practical easy to understand
Oli Jo –
Easy to understand. Gets to the point. I am very happy I found this course. Thank you.
John Klungers –
Omdat erom gevraagd werd.
Chase Grainger –
good info, very helpful!
Anthony J Robison –
Easily walked me through an issue I was having already.
Julio Bell Soublet –
I learned a lot about this matter. I really appreciate getting these useful skills to get the best out of working with Google Sheets. Thanks!!!