Google Script How to Update Google Sheet data from a web App
4.6 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,744 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Script How to Update Google Sheet data from a web App to your Wishlist.

Add to Wishlist

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.6 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,744 students enrolled
Created by Laurence Svekis
Last updated 8/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 6 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • output google sheets content
  • send api requests to google script
  • connect front end html and jQuery with backend Google Script
View Curriculum
Requirements
  • Google account
  • Some basic knowledge of HTML JavaScript jQuery
  • Programming experience
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!

Who is the target audience?
  • Anyone who wants to learn how to create apps with Google Script
  • Perfect for web developers
  • Anyone who wants to update Google Sheets within a web app
  • JavaScript Developers
  • Web developers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
22 Lectures
01:38:38
+
Introduction to connecting Google Script with Apps
22 Lectures 01:40:39

setup Google Script
04:56


Create dialog and webapp of Google script output
07:31

Source Code
00:12

html output append and update styling with Bootstrap
04:50

Coding exercise add UI item render HTML
04:57

Source Code Exercise
00:09

Output content from spreadsheet
06:44

Project Source Code
00:24

Output Sheet content as Data
05:45

Source Code
00:22

Loop data output array as HTML
06:24

Sheet data in HTML table with inputs
08:01

data passing using jQuery from element
06:43

Class google.script.run (Client-side API)
04:55

Update Google Spreadsheet from HTML
07:29

Launch Webapp
04:18

Styling Tweaks
02:53

Source Code review
09:26

Source Code GS
00:38

Source Code Sheet.html
01:56
About the Instructor
Laurence Svekis
4.2 Average rating
14,197 Reviews
312,861 Students
188 Courses
Instructor, 18+yrs Web Experience

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today

Providing Web development courses and digital marketing strategy courses since 2002.

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"