Google Sheets API v4: batchGet not working
How about this modified script? In order to use this, please enable Sheet API v4 on API console and enable Sheet API v4 at Advanced Google Services.
Modified script :
function readRange(spreadsheetId) {
var response = Sheets.Spreadsheets.Values.batchGet(
"someSpreadSheetID",
{ranges: ["Sheet1!D7:F7", "Sheet1!J7:L7"]}
);
Logger.log(response.valueRanges);
}