I have table in google sheet. I get API key, spreedsheetID. With javascript I set range as 'Sheet1!G6:G60'. I am able to fetch one range of table from google sheet and display it to html, as 'Sheet1!G6:M60'.

My goal is to get multiple ranges from table, like 'Sheet1!G6:G60' , 'Sheet1!M6:M60', ... My named ranges in google sheet are "Range1", "Range2".

I have tested answer by @tanaike , but I am unable to compose working url for fetch. const ranges = RANGE.map(e => ranges=${encodeURIComponent(e)}).join("&"); return: 'ranges=Range1&ranges=Range2'

composed url: https://sheets.googleapis.com/v4/spreadsheets/*spreadsheetID*/values:batchGet?key=*APIkey*&ranges=Range1&ranges=Range2 or https://sheets.googleapis.com/v4/spreadsheets/*spreadsheetID*/values:batchGet?key=*APIkey*&ranges=Sheet1!G6:G60&ranges=Sheet1!M6:M60 or https://sheets.googleapis.com/v4/spreadsheets/*spreadsheetID*/values:batchGet?key=*APIkey*&ranges=G6:G60&ranges=M6:M60

are not working.

My previous working url is: https://sheets.googleapis.com/v4/spreadsheets/***spreadsheetId***/values/Sheet1!g6:g66?key=*APIkey*

Problem is probably in this part: values:batchGet?key=${API_KEY}&${ranges}

Did something changed from 2022 and method 'values:batchGet' is not working in 2025? Thank you