Google Apps Script map tutorial error

Question

I am trying to do the first tutorial, make a map from a list of addresses.

I have created the spreadsheet and script, but I get this error when I run the script.

"Cannot find method getRange(number,number,number,number). (line 7)"

Any tips/solutions?

Do you have a sheet called 'restaurants' ? Also, it is populated with data ? — Srik
– Srik, Commented Dec 18, 2012 at 12:46

Marcello Scacchetti · Accepted Answer · 2012-12-18 16:38:13Z

0

If you look at the second line it should be something like:

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('restaurants');

Basically the script expects to have a sheet inside the spreadsheet file called "restaurants" so try to rename the sheet and it should not fail.

answered Dec 18, 2012 at 16:38

1455 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1