Google spreadsheet API, 400 error bad request : unable to parse range
If you look at the sheet itself you will notice that the Worksheet is titled "Class Data". So just put the name of your sheet where is says "Class Data". Example: String range = "SheetName!A1:C";
String range = "Class Data!A2:A4";
The Class Data
is your worksheet's name, FYI: the name on the tab at the bottom, the default one is "Sheet1". Replace Class Data
with the one you want to work with.
Try replacing Class Data!A2:A4
with A2:A4