Google Script How to Update Google Sheet data from a web App (Udemy.com)

I'm also learning from the same instructor's different class, called "Google Apps Script Complete Course Beginner to Advanced." Compared to the class, this short class looks more thoughtfully organized.

Excelent! Good to Begin the studies of Google Apps script, Web apps and store data on Google sheets. And Lawrence in the classes show us how shearch documentation. Congratulations!

The instructor is very clear, and easy to understand. The recording production is very good, and the instructor shows us where he is getting the reference code from.

As way of background, I've done a fair bit of basic Google Apps Script (GAS) mainly within Google Sheets and with the Gmail API, no website/web app stuff. I haven't previously been involved in fancier stuff like is used here. The course introduced me to several new "technologies" (for me), namely: how to use HtmlService, how to connect Google Sheets data to a webapp, jQuery & how to handle Change events in jQuery, how to use google.script.run to run a GAS script within a web app, including how to code for a success handler callback. Other notables were my first use of JSON, first use of Bootstrap and learning how to construct a table in a for loop. :-) This is definitely not a beginner's course; there are plenty of places to get a bit stuck but I'm happy to say that I got through to the end, with a few bumps in the road, and with a slightly enhanced version of the project in the course. The half-star off is just due to further explanation being needed in parts, as Laurence goes through things with little "fluff", but well-directed fluff can add to the general understanding of why we're doing things a certain way or where things fit in in the slightly bigger picture. So in a nutshell, I've benefited significantly from the course and have a "system" which will allow me to build out a simple update form for our field teams (they currently update their sheets via their job Sheet directly which is cumbersome). I hope Laurence's course "Google Sheet Data API JSON AJAX" will cover the tech to allow it to be a live 2-way update. Next stop...

This is a great course and very great instructor The course will be more valuable if some more topics added like how to add drop-down-list, options, checkbox, dependent drop lists. Thank you

My main concern was to learn how to do Ajax gets and posts to a Google Sheet from stand-alone web pages. That concept is not covered in this course, but it is quite well illustrated by Laurence in a second course, "Google Sheet Data API JSON AJAX". I am very glad regardless that I completed this series because of its very helpful tips on the Toaster and use of Bootstrap. Nice job, Mr. Svekis! I also appreciate Laurence covering sheet.getDataRange(), which I had finally discovered on my own by trial and error after weeks of hard work. Wish I'd seen this first. Also I was frankly astonished to learn from Laurence that google.script.run actually does its magic just fine from within stand-alone pages generated by an Apps Script web service, even though sent to a strange browser. Incredible that the Google engineers managed that. I had used google.script.run previously in a custom sidebar for Sheets, but never thought it would work in web-server generated pages. I had naively assumed that these pages were empty except for my own code. My main concern was to learn how to do Ajax gets and posts to a Google Sheet from stand-alone web pages. That concept is not covered in this course, but it is quite well illustrated by Laurence in a second course, "Google Script How To Update Google Sheet Data From A Webpage". I am ver glad regardless that I completed this series first for its tips on Toaster and Bootstrap (as well as the revelation about google.script.run). Nice job, Mr. Svekis!

Excellent course!! The instructor is very knowledgeable about the Google Scripting Language and is able to present the concepts in a way that is easily understandable. I feel ready to implement the knowledge gained from the course.

Fast-paced, which is good and bad. If anyone wants a short training and is willing to compromise feeling that you have missed out on something, this is the course for you. I would love to see a "Part 2" to expand on this (e.g.--the user selects a worksheet to update from a selection drop-down box on a main page, only allow the user to update columns 2-5, etc.)

This course was perfect for what I was looking for. It has front-end and backend information about setting up interactions between sheets and Google Scripts. It included both pop up boxes and web app interaction. Loved the course, I did it in only ~1 day (8hrs). Thanks Lawrence!

Excellent course! Just what I was looking for to build a real-life data logging application without having to worry about using a back-end server and database. Before taking the course, I hadn't heard of Google Scripts, so well done to Laurence for the course-content and for all of the lessons that were presented in a very clear, concise manner.