Your first script

Creating your first Google API script for spreadsheets

So you have decided that you want to add some automation

Here is a link to an youtube video, view this to get an overview.

A few brief steps.

  1. Open the spreadsheet you want to work with.
  2. On the menu bar, click on the Tools
  3. Click on Script Editor
  4. When presented with options, select “Blank Project”

This should open an editor with code.gs as the file name.

A function called myFunction is pre created for you.

The code should look like this

function myFunction() {

}

You should be able to write code in this.

Happy coding…..

Standard