Wie finde ich eine Google SpreadSheet-ID?

Lesezeit: 2 Minuten

Benutzeravatar von RamelHenderson


Bei Verwendung der Google Execution Api for Java ist die ID der Tabelle nicht ganz einfach zu verstehen. Hier ist das Code-Snippet:

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

Irgendwelche Ideen, wie man das findet. Ich führe die Sheets-API aus, um die ID eines SpreadSheets zurückzugeben, aber es gibt einen Link zurück, und wenn ich die https://spreadsheets.google.com/feeds/spreadsheets/STRING oder einfach nur die STRING selbst bekomme ich noch: “code” : 404, “errors” : [ {
“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”) ….

1449920cookie-checkWie finde ich eine Google SpreadSheet-ID?

This website is using cookies to improve the user-friendliness. You agree by using the website further.

Privacy policy