¿Cómo localizo un ID de hoja de cálculo de Google?

3 minutos de lectura

Avatar de usuario de RamelHenderson
Ramel Henderson


Cuando se usa Google Execution Api para Java, la identificación de la hoja de cálculo no es muy fácil de entender. Aquí está el fragmento de código:

// Initialize parameters for that function.
List<Object> params = new ArrayList<Object>();

Cualquier idea sobre cómo localizar esto. Ejecuto la api de Sheets para devolver la identificación de una hoja de cálculo, pero devuelve un enlace, y cuando uso el https://hojas de cálculo.google.com/feeds/hojas de cálculo/CADENA o simplemente el CADENA en sí mismo todavía obtengo: “código”: 404, “errores”: [ {
“domain” : “global”,
“message” : “Requested entity was not found.”,
“reason” : “notFound”

Found this deep inside the Apps Script API reference.

A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is “abc1234567”.


states that:

Every API method requires a spreadsheetId parameter which is used to identify which spreadsheet is to be accessed or altered. This ID is the value between the “/d/” and the “/edit” in the URL of your spreadsheet. For example, consider the following URL that references a Google Sheets spreadsheet:


The ID of this spreadsheet is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.

So I just pulled up my spreadsheet and looked at the URL to find my ID.

Hope this helps!

  • So uh… how do you find this ID just using code? It’s pretty useless for automation if you have to manually open each spreadsheet and copy/paste an ID from the URL…

    – Michael

    Apr 3, 2022 at 15:46

  • @Michael did you make any progress? I’m having the same problem. I can retrieve an id for a sheet using currentSheet.getSheetId(); but it is a simple integer (0 for a one sheet App) but can’t find anything equivalent to get the id of the SpreadsheetApp.

    – Dave Pritlove

    Aug 25, 2022 at 13:08

  • Don’t know if it helps, but in my case I was creating a sheet, so the BatchUpdateSpreadsheetRequest returns a BatchUpdateSpreadsheetResponse object, in the properties was the sheetId. execute.getReplies().get(0).getAddSheet().getProperties().getSheetId()

    – CeePlusPlus

    Dec 5, 2022 at 18:01

I just created a hyperlink to the sheets and then copied that hyperlink to a text file and the link line shows the GID.


Then I created a pull down list in A52 and then made =IF() logic to go to the GIDs to go to those sheets.

=IF(A52=”47QTCK18D0001″,HYPERLINK(“#gid=0″,”47QTCK18D0001″),IF(A52=”47QTCK18D0002”,HYPERLINK(“#gid=1049871492″,”47QTCK18D0002”) ….

¿Ha sido útil esta solución?