Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 39 Minute(s)
Language
English
Taught by
Laurence Svekis
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
2 views
Course Overview
Explore how you can use Google Script to connect Google Apps and with web apps to update your Google Spreadsheet
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.
- Share data within your Google Sheet
- Provide a url to update data without providing access to the Google Sheet itself
- Select and show content from a specific sheet
- 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.
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!
Course Content
- 2 section(s)
- 24 lecture(s)
- Section 1 Introduction to connecting Google Script with Apps
- Section 2 Bonus Section
What You’ll Learn
- output google sheets content
- send api requests to google script
- connect front end html and jQuery with backend Google Script
Skills covered in this course
Reviews
-
TTshering
yes course was relavent
-
SSandra 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
-
SSanderson 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!
-
GGregory 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 "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...
