A Google Script Project Using Website Spreadsheets and Data Storage [Video]

A Google Script Project Using Website Spreadsheets and Data Storage [Video]

Laurence Svekis

Explore how you can use Google Sheets to store data submitted directly from your own website using an HTML form
Packt Subscription
FREE
$9.99/m after trial
Video
$154.70
RRP $181.99
Save 14%
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
$154.70
$9.99 p/m after trial
RRP $181.99
Subscription
Video
Start a FREE 10-day trial

Frequently bought together


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
$ 154.70
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
$ 155.55
Buy 2 for $310.25
Save $54.73
Add to Cart

Video Description

Google apps script has so many possibilities to really power up your web pages. Please note this course requires fundamental JavaScript knowledge and is designed to cover building a project that allows web users to submit a form, using AJAX send the data to a Google Script Web app and using Google Script to deposit the submission data into a Google Spreadsheet.

  • Learn the basics of writing Google Script
  • Explore how to add content and append content to spreadsheets
  • See how you can create web apps with web URLs
  • Submit data to your web app using AJAX - we use jQuery in the course using Get
  • Retrieve parameters in the request using Google Script and create an array to submit and add content to your spreadsheet
  • Return a callback response in JSON format back to your web page

All the source code is included to get you started quickly. 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. Google Apps Script is based on JavaScript 1.6 with some portions of 1.7 and 1.8 and provides a 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/A-Google-Script-Project-Using-Website-Spreadsheets-and-Data-Storage

Style and Approach

This course will help you explore opportunities for using Google Apps Script. Connect your website by using Google Spreadsheets to store data submitted from your website.

Video Preview

What You Will Learn

  • Connect website input form to Google Spreadsheet
  • Add data from an input form to Google Spreadsheet

Authors

Video Details

ISBN 139781838558307
Course Length58 minutes
Read More

Read More Reviews

Recommended for You

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
$ 155.55
A Complete CSS Flexbox Course and a Real World Website Project [Video] Book Cover
A Complete CSS Flexbox Course and a Real World Website Project [Video]
$ 90.99
$ 77.35
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
$ 78.20
Hands-On Machine Learning using JavaScript [Video] Book Cover
Hands-On Machine Learning using JavaScript [Video]
$ 124.99
$ 106.25
Data Visualization Recipes with Python and Matplotlib 3 [Video] Book Cover
Data Visualization Recipes with Python and Matplotlib 3 [Video]
$ 124.99
$ 106.25
Hands-On Microservices with TypeScript 3 [Video] Book Cover
Hands-On Microservices with TypeScript 3 [Video]
$ 124.99
$ 106.25