Posts

Showing posts from March, 2023

Google sheets environment

Google Sheets has a built-in script editor that allows users to create and customize their own functions using the Google Apps Script (GAS) language. GAS is a JavaScript-based language that is used to automate tasks across Google products and create custom applications. The script editor can be accessed by going to "Tools" and selecting "Script editor" within Google Sheets. From here, users can create new scripts or edit existing ones. In addition to GAS, the script editor also supports the following languages: HTML CSS JSON AJAX Add-ons are third-party extensions that can be added to Google Sheets to provide additional functionality. While they can be useful, we will focus on using the built-in script editor and GAS in this tutorial.