Google Apps Script is a fairly simple scripting language that helps to develop useful applications on the Google Workspace platform. It allows you to program in the JavaScript language, and also supports many of the features provided by the JavaScript V8 engine built into Google Chrome. This service works in the Google cloud, meaning that the code commands are not executed on your device, but rather on Google servers. According to Google Script applications, it provides easy ways to complete tasks in the Google platform and provides easier ways to serve third parties. Google Script Apps is also a powerful tool that enables add-ons to Google Docs, Sheets, and Slides, and to work with files on Google Drive.

1-How to start with google app script

From google home page click on the 9 dots

Scroll until found google app script icon and click on it

You will be redirected to the script page, where you will find a simple two-part user interface

The navigation bar on the left is responsible for managing files and project settings The right side is the code page of the file that was opened.

We'll start from the files There are 3 file types in each project:

• appsscript.json An Apps Script project manifest is a special JSON file that specifies a basic project information that Apps Script needs to run the script successfully.

Apps Script automatically creates and updates the project manifest as you create your script project and make changes in the Apps Script editor. In most cases you never need to view or edit the manifest directly; however, in certain situations it may be beneficial or required. For more info check the documentation There should only be one file of this type.

• file.html This file allows you to add HTML, CSS, and JavaScript to it, This file can also be a file that "include" an embedded file. You can create an unlimited number of files of this type.
• file.gs It is an abbreviation for GoogleScript In it, the logic that runs the entire script is added You can create an unlimited number of files of this type.

Now you can view the documentation from Google and start programming