Laurence Svekis
Use Google Script to connect your Google Sheet data to a web app so users can update content within your sheet. Connect a sheet without having to share the entire sheet with them. Google Scripts provides an amazing opportunity to extend what you can do with Google Sheets. Source Code is included!!!!
Did you know you can publish web apps that have web urls directly from Google, no hosting and only using your Google Account.
Google Script is JavaScript with some added custom classes and methods….. Using Google script allows you full control over what your Google Apps can do connecting them together and making them work smarter.
Learn how to output and update your Google Sheet content using Google Script to publish it as a web URL.
JavaScript, HTML are prerequisites to this course. jQuery and Bootstrap are used within the application so experience using these technologies is essential to learning the content of this course.
Google provides a powerful set of tools with Google Apps. Google sheets is a great place to store data within a spreadsheet and then make use of that data in a number of ways. This course demonstrate how to connect and google sheet content and output it to a web app, and then update the Google Sheet content directly from the web app without having to open Google sheets.
Instructor Details
Courses : 111
Specification: Google Script How to Update Google Sheet data from a web App
|
13 reviews for Google Script How to Update Google Sheet data from a web App
Add a review
| Price | $14.99 |
|---|---|
| Provider | |
| Duration | 1.5 hours |
| Year | 2019 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$14.99
Sanjeev Chaudhary –
Good explaination with good practial example and explaination on working with Google sheet , Google script and web app.
Hicham Alaoui –
Will leave
Mozart Garc a de Haro –
I would love the instructor to make a real world app. I would take it! The instructor knows a lot. But some times the instructions are short.
Jeff Creamer –
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!
MAHMOUD MOHAMED ELGENDI –
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
Jeff Romero –
It s still early… But everything is clearly illustrated.
Jay McLCure –
Content jumps around a lot. Sometimes mouse cursor of instructor blocks vital source code. I was thinking this would give more insight into writing the code, rather than just explaining how to code a specific function.
Gregory Cleland –
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 echnologies (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…
Mak s –
Good!
Scott Wolz –
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.
Krzysztof Gaw da –
It might be a bit too fast paced for a beginner, though that’s why we have pause and rewind loved it!
Sanderson Oliveira –
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!
Sandra Leslie –
I found it informative, but Laurence speaks way too quickly for you to follow. He needs to slow it down so people can watch what he is doing instead of straining to keep up