Working with Google Docs
Expert-defined terms from the Professional Certificate in Google Apps Script Fundamentals course at London School of International Business. Free to read, free to share, paired with a globally recognised certification pathway.
**Apps Script Dashboard** #
**Apps Script Dashboard**
The Apps Script Dashboard is a web #
based interface for managing, deploying, and monitoring Google Apps Script projects. It provides an overview of project versions, triggers, and execution logs.
**Apps Script project** #
**Apps Script project**
An Apps Script project is a container for Google Apps Script code, assets, and c… #
It can be bound to a Google Sheet, Doc, Slides, or Form, or it can be a standalone script.
**Application Programming Interface (API)** #
**Application Programming Interface (API)**
An API is a set of rules and protocols that enables different software applicati… #
Google provides various APIs for accessing and manipulating its services, such as Gmail, Drive, and Sheets.
**Autocomplete** #
**Autocomplete**
Autocomplete is a feature in the Apps Script editor that suggests completions fo… #
It helps you write code faster and reduces typos and errors.
**Binding** #
**Binding**
Binding is the process of associating a Google Apps Script project with a specif… #
A bound script has access to the container's data and UI, and it can modify them programmatically.
**Bound script** #
**Bound script**
A bound script is a Google Apps Script project that is associated with a specifi… #
It has access to the container's data and UI, and it can modify them programmatically.
**Class** #
**Class**
A class is a blueprint for creating objects in Google Apps Script #
It defines the properties and methods that the objects of that class can have.
**Code completion** #
**Code completion**
Code completion is a feature in the Apps Script editor that suggests completions… #
It helps you write code faster and reduces typos and errors.
**Code editor** #
**Code editor**
The Code editor is a web #
based interface for writing, editing, and debugging Google Apps Script code. It provides syntax highlighting, autocomplete, and error checking.
**Conditional statement** #
**Conditional statement**
A conditional statement is a programming construct that allows you to execute di… #
The most common conditional statements are if, else if, and else.
**Container #
bound script**
A container #
bound script is a Google Apps Script project that is associated with a specific Google Sheet, Doc, Slides, or Form. It has access to the container's data and UI, and it can modify them programmatically.
**Debugging** #
**Debugging**
Debugging is the process of finding and fixing errors or bugs in your Google App… #
The Code editor provides tools for debugging, such as breakpoints, step-by-step execution, and variable watches.
**Deployment** #
**Deployment**
Deployment is the process of publishing a Google Apps Script project as a web ap… #
It makes the project accessible to other users or applications, and it allows you to control the access level and version.
**Document Object Model (DOM)** #
**Document Object Model (DOM)**
The Document Object Model (DOM) is a programming interface for HTML and XML docu… #
It represents the document as a tree of nodes, where each node corresponds to an element, attribute, or text fragment.
**Document service** #
**Document service**
The Document service is a Google Apps Script service for reading and writing Goo… #
It provides methods for creating, deleting, copying, and formatting documents, as well as for inserting and manipulating text, tables, and images.
**Event object** #
**Event object**
An event object is a data structure that contains information about an event, su… #
Google Apps Script triggers pass an event object to the attached function, which can use it to react to the event.
**Event trigger** #
**Event trigger**
An event trigger is a Google Apps Script feature that allows you to run a functi… #
Examples of event triggers are time-driven triggers, form submit triggers, and spreadsheet edit triggers.
**Executable line** #
**Executable line**
An executable line is a line of Google Apps Script code that can be executed by… #
It can be a function definition, a function call, a variable declaration, or a statement.
**Execution log** #
**Execution log**
The execution log is a record of the execution history of a Google Apps Script p… #
It shows the start and end time, the status, the duration, and the error message of each execution, as well as the name of the function and the event that triggered it.
**Expression** #
**Expression**
An expression is a combination of values, variables, operators, and functions th… #
In Google Apps Script, expressions can be used as operands in statements or as arguments in function calls.
**Function** #
**Function**
A function is a self #
contained block of code that performs a specific task or operation. It can take input in the form of arguments, and it can return output in the form of a value or a result. Functions help you organize and reuse your code, and they make it easier to test and maintain.
**Function call** #
**Function call**
A function call is the act of invoking a function and passing the required argum… #
In Google Apps Script, you can call a function by using its name followed by parentheses and a comma-separated list of arguments.
**Function definition** #
**Function definition**
A function definition is the act of declaring a function and specifying its name… #
In Google Apps Script, you can define a function by using the function keyword followed by the name, the parameter list in parentheses, and the code block in curly braces.
**Google Apps Script** #
**Google Apps Script**
Google Apps Script is a JavaScript #
based scripting language for automating and extending Google Workspace applications, such as Gmail, Drive, Sheets, Docs, and Forms. It provides a set of services, classes, and methods for accessing and manipulating Google Workspace data and UI.
**Google Apps Script Dashboard** #
**Google Apps Script Dashboard**
The Google Apps Script Dashboard is a web #
based interface for managing, deploying, and monitoring Google Apps Script projects. It provides an overview of project versions, triggers, and execution logs.
**Google Sheets API** #
**Google Sheets API**
The Google Sheets API is a RESTful web service #
The Google Sheets API is a RESTful web service