~Appscript editor

AppScripts are developed by google that is just a javascript which uses the custom google APIs that can be used in different tools that google provides like Google Sheets, docs etc.

Using AppScripts you can access data on the google sheets or other services and can manipulate them based on your need.

For instance to get you an use case of it so that you can imagine how useful it is, consider you want to automate the task of gettting data from a weatherapp for previous history of all the weathers so that you can have data in your excell sheet and can work up on your ML model now. This could be a bit of tough and lengthy task as the weather data is increasing every day and you want your database also to be updated with it.

With the AppScripts you can create add all the weather data into your sheet. For this you will need to add some appScript code and an API that fetches the data from that weather site and you are good to go :)

<br />

Lets start

<br />

To start writing code you will have to open script editor from Tools>Script editor in mennu tabs.

Next, Copy this code into the Code.gz file that will be opened by default on start.

function onOpen() {
}

After copying it, save the file by ctrl+S . Now go back to the sheets and go to Tools > Macros and select onOpen from there.

Now you will see that this code has added a new Menu tab named : MySheetsTools.

This menu when clicked will display 2 tags in the dropdown named : Tools and Login.

You will get an error right now on clicking them as we have not defined the showTools and loginModels. Since the objective of this article was to give a start to the appScripts.

---

Thats it for this blog. We will discuss in more depth in the next articles. To keep updated view my blogs at this link : vansh kapoor

Thank you :)