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

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

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.