Exception in getSheetByName function: Service Spreadsheets failed while accessing document with id

[구희정]

  Since June 1st, when using getSheetByName or openById functions on a spreadsheet connected to a BigQuery project, I get the error: Exception: Service Spreadsheets failed while accessing document with id. However, the spreadsheet opens fine when accessed directly via the link. Because these functions fail to execute, I am currently unable to retrieve the data. What could be causing this issue?  

[George Ghanem]

It may be the permissions. Try re-authorizing it or check manifest file to confirm correct authorizations.

On Wed, Jun 4, 2025, 1:53 a.m. 구희정 <prisci...@gmail.com> wrote:

  Since June 1st, when using getSheetByName or openById functions on a spreadsheet connected to a BigQuery project, I get the error: Exception: Service Spreadsheets failed while accessing document with id. However, the spreadsheet opens fine when accessed directly via the link. Because these functions fail to execute, I am currently unable to retrieve the data. What could be causing this issue?  

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/a28122e2-85b0-4274-ab33-bba2b8c1eeb2n%40googlegroups.com.