Google Script How to Update Google Sheet data from a web App

Explore how you can use Google Script to connect Google Apps and with web apps to update your Google Spreadsheet

4.40 (247 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
4,243
students
1.5 hours
content
Nov 2019
last update
$49.99
regular price

What you will learn

output google sheets content

send api requests to google script

connect front end html and jQuery with backend Google Script

Description

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!

Content

Introduction to connecting Google Script with Apps

Introduction to Google App Script and Google Sheets
setup Google Script
Write your first Google Script
Create dialog and webapp of Google script output
Source Code
html output append and update styling with Bootstrap
Coding exercise add UI item render HTML
Source Code Exercise
Output content from spreadsheet
Project Source Code
Output Sheet content as Data
Source Code
Loop data output array as HTML
Sheet data in HTML table with inputs
data passing using jQuery from element
Class google.script.run (Client-side API)
Update Google Spreadsheet from HTML
Launch Webapp
Styling Tweaks
Source Code review
Source Code GS
Source Code Sheet.html

Bonus Section

Bonus Lecture

Screenshots

Google Script How to Update Google Sheet data from a web App - Screenshot_01Google Script How to Update Google Sheet data from a web App - Screenshot_02Google Script How to Update Google Sheet data from a web App - Screenshot_03Google Script How to Update Google Sheet data from a web App - Screenshot_04

Reviews

Mark
December 14, 2022
It's good, however the product being used is now out of date, and it could do with a refresh on later versions of google sheets.
Jinung
October 27, 2021
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.
Sandra
July 21, 2020
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
Sanderson
July 9, 2020
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!
Jeff
August 18, 2018
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!
Mozart
August 7, 2018
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.
Sanjeev
June 4, 2018
Good explaination with good practial example and explaination on working with Google sheet , Google script and web app.
Daniel
April 27, 2018
Direct to the point, and every line of code is explained. Could be done more slowly, and it would be great if the code was added after each lecture.
Joseph
April 20, 2018
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.
Wichard
April 11, 2018
Amazing course to get an complete introduction on Google Apps Script. Sometimes the lectures are going to fast, but they are always to the point.
Martin
April 7, 2018
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.)
Rob
March 26, 2018
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!
Matt
March 3, 2018
I have been trying to accomplish this very thing for weeks. I am going to try to implement it now. If this works, it was well worth the cost of the course.
Peter
November 26, 2017
A good basic course which has gotten me over the initial hurdle of creating dialog boxes à la Excel VBA in Google Sheets. The course very clearly shows how the html script is formed. However there were some disjoints due to a tendency to gloss over some points; a number of changes to the demonstration script were made without explanation, and sometimes without noting them. Whilst this could be handled it took me quite some time to work out what was changed, why, and what effect it had. But a quite good course with an urbane presenter who spoke clearly and to the point.
Anthony
August 25, 2017
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.

Charts

Price

Google Script How to Update Google Sheet data from a web App - Price chart

Rating

Google Script How to Update Google Sheet data from a web App - Ratings chart

Enrollment distribution

Google Script How to Update Google Sheet data from a web App - Distribution chart
1319830
udemy ID
8/12/2017
course created date
5/13/2020
course indexed date
Bot
course submited by