Fundamentals of Web Developement -> Google AppScript with Google Sheets
What is Apps Script?
Apps Script is a rapid application development platform that gives you the ability to automate, customize, and extend your Google Workspace experience. With Apps Script, you can save time and effort by streamlining onerous or complex work within Google Workspace.
Apps Script features include the following:
- Apps Script's built-in services let you read, update, and manipulate your Google Workspace application data with scripts.
- You can create scripts using Apps Script's in-browser code editor—there's no need to install or run code development software.
- You can design user interfaces for Google Workspace editors that let you activate scripts directly from those editors using menu items, dialogs, and sidebars.
This Fundamentals of Apps Script with Google Sheets Codes Academy playlist teaches the basics of Apps Script and how to use it to improve your Google Sheets experience. This Codes Academy focuses on teaching Apps Script basics.
The Spreadsheet service
You can use Apps Script to extend Google Sheets to save time and effort. Apps Script provides the Spreadsheet service which allows scripts to interact with your Google Sheet files and the data they contain. You can use this service to automate the following common spreadsheet tasks:
- What is Frontend and Backend?.
- Create or modify a spreadsheet.
- Input, Read and Update cell data using Google AppScript.
- Get source code for the project.
- Share and control access to spreadsheets.
