Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps [Video]

Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps [Video]

Laurence Svekis

Learn the power of Google Script and see how you can connect Google Spreadsheet as a data source for a post board
Packt Subscription
FREE
$9.99/m after trial
Video
$73.20
RRP $182.99
Save 59%
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$73.20
$9.99 p/m after trial
RRP $182.99
Subscription
Video
Start a FREE 10-day trial

Frequently bought together


Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps [Video] Book Cover
Google Apps Script - A Project-Based Exercise Using Spreadsheets and Web Apps [Video]
$ 182.99
$ 73.20
A Google Apps Script Exercise to Build a Consent Form [Video] Book Cover
A Google Apps Script Exercise to Build a Consent Form [Video]
$ 186.99
$ 74.80
Buy 2 for $148.00
Save $221.98
Add to Cart

Video Description

Group site project with Google Script - Google Site and Web apps - Spreadsheet
Do you want to connect Google Apps Together and make some really amazing things happen? Course will provide you the foundation to work with Google Script to build a Web App that can be embedded in Google Sites. Within the course we show you how to use Google Spreadsheet as a source for retrieving and storing data. Power up what you do online, bringing together built in functionality in your Google Suite. JavaScript developers extend your knowledge and learn how you can use your skills to develop apps script bringing together all the power of Google's Apps.
Course Covers

  • Basics of Google Script - how to use the online editor and overview of the functionality
  • How to create a bound script to your Google Sheet
  • Add new rows and get contents from Google Spreadsheet
  • Sort and update Google Sheet data
  • How to select sheet contents
  • How to use HTTP service to output an HTML file within Google Web apps
  • Use web apps to create interactive content
  • Use JavaScript within Google Apps and Google client-side pages
  • Setup a Google site and embed your Google script
  • Use session values and other powerful built-in script methods
  • Fine tune and tweak debug web apps

All this and more
Build a nice interactive project from scratch alongside the lessons within the course. Practice JavaScript and data handling, JSON, JavaScript objects, Array and more
Google Apps Script : is based on JavaScript 1.6 with some portions of 1.7 and 1.8 and provides subset of ECMAScript 5 API however instead of running on the client, it gets executed in the Google Cloud. According to Google, Apps Script "provides easy ways to automate tasks across Google products and third party services."Apps Script is also the tool that powers the add-ons for Google Docs, Sheets and Slides."
If you haven't tried it yet, I guarantee you will be BLOWN AWAY at how powerful Google Script can be, and at how easy it is to write. With just a few lines of code, you can DO A WHOLE LOT!!! Don't take my word for it try it and see.
Taught by an instructor with over 20 years of web development experience, ready to help you learn. What are you waiting for this course is perfect to start writing Google Script and to practice writing Google Script, you have nothing to lose.
All the code and supporting files for this course are available at: https://github.com/PacktPublishing/Google-Apps-Script---A-Project-Based-Exercise-Using-Spreadsheets-and-Web-Apps

Style and Approach

The course will provide you with the foundation to work with Google Script to build a Web App that can be embedded in Google Sites.

Video Preview

What You Will Learn

  • Create web apps with Google Script
  • Build your own post application
  • Add Google Scripts apps to Google Sites
  • Update and use Spreadsheet data within Google Sites

Authors

Video Details

ISBN 139781838556914
Course Length2 hours 35 minutes
Read More

Read More Reviews

Recommended for You

A Google Apps Script Exercise to Build a Consent Form [Video] Book Cover
A Google Apps Script Exercise to Build a Consent Form [Video]
$ 186.99
$ 74.80
An Apps Script Form Data Handler Exercise using Google Form and Spreadsheets [Video] Book Cover
An Apps Script Form Data Handler Exercise using Google Form and Spreadsheets [Video]
$ 91.99
$ 36.80
A Dynamic Quiz App using Google Apps Script with Google Sheets as the Data Source [Video] Book Cover
A Dynamic Quiz App using Google Apps Script with Google Sheets as the Data Source [Video]
$ 186.99
$ 74.80
Ionic 4 - Build iOS, Android and Web Apps with Ionic and Angular [Video] Book Cover
Ionic 4 - Build iOS, Android and Web Apps with Ionic and Angular [Video]
$ 167.99
$ 67.20
JavaScript Project - Create CSV file from Google Spreadsheets [Video] Book Cover
JavaScript Project - Create CSV file from Google Spreadsheets [Video]
$ 91.99
$ 36.80
A Google Script Project Using Website Spreadsheets and Data Storage [Video] Book Cover
A Google Script Project Using Website Spreadsheets and Data Storage [Video]
$ 181.99
$ 72.80