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…..

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s