Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Apps Script Web App and Client Side Data
Rating: 4.3 out of 5(63 ratings)
4,353 students

Google Apps Script Web App and Client Side Data

Create a WebApp Send Data to your Spreadsheet Use Request Parameters to track users Generate new user sheets
Created byLaurence Svekis
Last updated 11/2024
English

What you'll learn

  • Perfect for anyone who wants to learn more about Google Apps Script
  • Create Client side connection to web app
  • Add input content to spreadsheets
  • Generate web urls for web apps
  • Send data to client side from Google Apps Script

Course content

2 sections • 20 lectures • 1h 14m total length

  • Introduction to creating an Interactive Sheet WebApp5:09
  • Web App Setup Google Apps Script5:32
  • Source Code - create Web App Google Apps Script0:02
  • How to Get Parameters and Pass Data Google Apps Script7:57
  • Get data from Server side to Client Side JavaScript Web App0:12
  • Google Apps Script - Pass Data to the client side6:26
  • Google Script Run send data to server side Code Example0:18
  • How to Log Data to Spreadsheet using Google Apps Script5:41
  • Sheet Data from client side0:22
  • How to Update Client Side Input Google Apps Script Web App Code4:58
  • Source Code Google Apps Script Update Sheet with Client Side Data0:26
  • How to Send data to client side from Sheet5:30

    Fetch data from a Google spreadsheet with Apps Script, build a return data object, and send the sheet's values to the client side as an array for display.

  • Return Data from spreadsheet by sheetname as id code example0:32
  • How to create a Modal popup in Sheets Sheet UI Modal Popup8:24
  • Show modal popup in Spreadsheet Source Code0:26
  • How to Generate Web URLs Web App URL Google Apps Script12:54

    Generate web app URLs with a user id in Google Apps Script using client-side JavaScript, input fields, and a button to output and copy the URL with feedback.

  • Code Example WebApp Modal updates and URL generator1:04
  • Google Apps Script Web App Code Final App Code Review6:58
  • Final WebAPP Source Code1:09

Requirements

  • Prior Coding Experience
  • JavaScript Coding understanding
  • Google Account

Description

One of the most commonly asked questions is HOW to Create a Webapp that connects to Spreadsheets, and that you can send and receive sheet data from .

This course is perfect to learn more about the power of Google Apps Script and how you can use it to create amazing interactive applications.

Flexible content is designed to let you learn and then build upon that knowledge to create your own version of the app.

Use this app to track user info - each user gets their own app url with id that tracks into one spreadsheet on separate sheets.

Send input data to sheet - track and access.  Generate new user URLS within the Sheet UI.

Explore how you can create a custom Google Sheet option within your Google Sheets UI menu.

Explore Google Apps Script and how it can be used to run code using data from your Spreadsheet

Discover the amazing things you can do with Google Apps Script

Course covers some of the commonly asked for functionality using Google Apps Script and Google Spreadsheets

  • Create a Web App

  • Send data from a sheet to Web app client side

  • JavaScript to manipulate elements and create interactive pages

  • Modal popup interface to generate web urls for users.

  • Source code is included

  • Send input field data back to Google Apps Script to add to the spreadsheet sheet

JavaScript and prior coding experience is REQUIRED DO NOT TAKE THIS COURSE WITHOUT JavaScript Experience

Source code is included - Best way to learn is to try the code and create your own version of this project

Taught by an instructor with over 20 years of web development experience ready to help you learn

Google Developer Expert - Laurence Svekis walks you through how to do some amazing functionality to save time and get the most out of Google Apps Script G Suite content

Fast friendly support is always available in the Q&A section

What are you waiting for - this could change everything - at least change the way you use Google Apps and G Suite Google Sheets

Who this course is for:

  • Google Apps Script Coders
  • Anyone who wants to do more with Google Apps Script and G Suite Apps
  • JavaScript Developers - Applications developers and web coders
  • Anyone who wants to power up web applications with the power of Google G Suite Apps using CODE

Report abuse