gs file: cannot find method getRange(number,number,number,number)

[EladB]

When I run an ads-script to call the `app-script::spreadsheet` API, I get the following error:

    var sheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);

    var rangeValues = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues();

    

    ==> Cannot find method getRange(number,number,number,number)

How can it be? Only a subset of the app-script sheet api is available from ads-script?

[EladB]

I used an instance of the `spreadsheet` class. However, `getRange()` is a method of the `sheet` object.

[Google Ads Scripts Forum Advisor]

Hi there,

Thank you for reaching out to us.

You were right. The getRange method is under the Sheet class. You encountered the error (Cannot find method getRange(number,number,number,number)) because sheet variable is not a sheet object rather a Spreadsheet object which is returned from the openByUrl method.

You can try the following sample below:

var ws = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
var sheet = ws.getActiveSheet();
var rangeValues = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues();

Regards,

Mark Kevin Albios Google Ads Scripts Team

ref:_00D1U1174p._5004Q26A7pg:ref