Latest Courses
DigitalOcean Cloud Platform FundamentalsCheck course
Vue and Laravel AuthenticationCheck course
Fullstack Serverless Engineering (AWS, Node.js, React+Redux)Check course
Unreal Engine 4 : The Complete Guide (2020)Check course
The Complete Data Structures and Algorithms Course in PythonCheck course
Learn to create a 2D Idle Miner Tycoon Game in Unity 2020Check course
How to Create a WebApp using Google Apps Script webPagesCheck course
Docker for .Net and Angular DevelopersCheck course
Scala Programming From Scratch To DepthCheck course
ASP.NET Core MVC - Up and Running Part 1 (.NET 5)Check course
DigitalOcean Cloud Platform FundamentalsCheck course
Vue and Laravel AuthenticationCheck course
Fullstack Serverless Engineering (AWS, Node.js, React+Redux)Check course
Unreal Engine 4 : The Complete Guide (2020)Check course
The Complete Data Structures and Algorithms Course in PythonCheck course
- 86% Google Script How to Update Google Sheet data from a web App

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

$94.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.1/10 (Our Score)
Product is rated as #19 in category Google Apps Script

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

I'm here to help you learn, achieve 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!

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

Duration 1.5 hours
Year 2019
Level Beginner
Certificate Yes
Quizzes No

13 reviews for Google Script How to Update Google Sheet data from a web App

3.7 out of 5
3
5
4
0
1
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Sanjeev Chaudhary

    Good explaination with good practial example and explaination on working with Google sheet , Google script and web app.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Hicham Alaoui

    Will leave

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    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!

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    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

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Jeff Romero

    It s still early… But everything is clearly illustrated.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    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…

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Mak s

    Good!

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    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!

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    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!

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    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

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

    $94.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare