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.
String sheetId = "<ENTER_ID_OF_SPREADSHEET_TO_EXAMINE_HERE>";
List<Object> params = new ArrayList<Object>();
params.add(sheetId);
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.
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.
