Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Script How to Update Google Sheet data from a web App
Rating: 4.4 out of 5(291 ratings)
4,689 students

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
Created byLaurence Svekis
Last updated 11/2024
English
English [Auto],

What you'll learn

  • output google sheets content
  • send api requests to google script
  • connect front end html and jQuery with backend Google Script

Course content

2 sections • 24 lectures • 1h 39m total length

  • Introduction to Google App Script and Google Sheets3:22

    Build a web app with Google Script that connects to Google Sheets, updates sheet data in real time from the front end, and uses a pop up dialog for changes.

  • setup Google Script4:56

    Log into or create a Google account to access drive and create a Google Sheet, then learn how Google scripts connect Sheets with a web app to update data.

  • Write your first Google Script8:41

    Learn to write your first Google Script in a Google Sheet, create a separate updater project, and add a custom menu that shows a dialog and toast.

  • Create dialog and webapp of Google script output7:31

    Use Google Script to update Google Sheet data from a web app by building a dynamic dialog and an HTML template deployable via doGet and UI output.

  • Source Code0:09
  • html output append and update styling with Bootstrap4:50

    Append and update html output using Bootstrap styling to render dynamic content and set titles. Pass data with JavaScript and optional jQuery for Google Sheet web app outputs.

  • Coding exercise add UI item render HTML4:57

    Build a Google Apps Script to add a custom menu, show an HTML dialog, and render sheet data in a web app while adjusting the dialog height and width.

  • Source Code Exercise0:07
  • Output content from spreadsheet6:44

    Retrieve all data from a Google Sheet by ID or name, get the data range and values, loop through rows, and prepare output for HTML in a web app.

  • Project Source Code0:16
  • Output Sheet content as Data5:45

    Pass data from the backend into the sheet and console, render it via HTML template, and prep for updating specific sheet coordinates.

  • Source Code0:16
  • Loop data output array as HTML6:24

    Learn to loop through nested data from a Google Sheet and render it as HTML in a web app using jQuery, arrays, and length-based loops.

  • Sheet data in HTML table with inputs8:01

    Render Google Sheet data into an html table with bootstrap styling, convert cells to inputs with ids, and prepare on change updates to push edits back to the sheet.

  • data passing using jQuery from element6:43

    Detect changes in dynamically generated elements with jQuery using a containing element and change event, then map coordinates from data-roll and data-column to update the Google Sheet via Google Script.

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

    Use the client-side google.script.run API to update a Google Sheet cell from a web app, setting on success handlers, and pass row, column, and value to the sheet update function.

  • Update Google Spreadsheet from HTML7:29

    Update a Google spreadsheet from HTML by passing data from front end to Google Script, identify the spreadsheet and sheet, and set values with range objects and Bootstrap alerts.

  • Launch Webapp4:18

    Launch the web app, publish a new version, and render the Google Sheet data as HTML, using sandbox mode to evaluate content and sync updates.

  • Styling Tweaks2:53

    Learn how bootstrap styling tweaks enable updating Google Sheet data via a web app, delivering a more responsive table through viewport adjustments, font sizes, padding, and container layout.

  • Source Code review9:26

    Review the source code for a Google script that updates Google Sheet data from a web app, using html templates and jquery to exchange data and update cells.

  • Source Code GS0:22
  • Source Code Sheet.html0:30

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 this course is for:

  • 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

Report abuse