Cannot read property 'getSheetByName' of null

user_14850241 0
Viewed 8150
function sortResponses() {
  var Sheets = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Fall 01")
  sheet.sort(3, false);
}

I have a Sheet called Fall 01 in my google Sheets, where I explicítly had to give the script access to, but it won't open, what am I missing?

google-apps-script google-sheets
1 Answers

Explanation/Issue:

The issue is that you have a standalone script which therefore is not bound to a google spreadsheet and as a result SpreadsheetApp.getActiveSpreadsheet() returns null.

Solutions:

There are two ways you can follow:

Solution 1:

Use SpreadsheetApp.openById(id) or SpreadsheetApp.openByUrl(url):

var Sheets = SpreadsheetApp.openById("Put your Spreadsheet ID").getSheetByName("Fall 01");

or

var Sheets = SpreadsheetApp.openByUrl("Put your Spreadsheet URL").getSheetByName("Fall 01");

Solution 2:

Go to the spreadsheet file that you want to work with and click on Tools => Script editor on the top menu of the spreadsheet file and put your current code there.

Please Note

If this is your only code, sheet is not defined, therefore you will get another error down the road. You most likely want to replace sheet with Sheets or the other way around. Be careful with this.

user_112252910
Related