Infeasible
Status Update
Comments
va...@google.com <va...@google.com>
ku...@google.com <ku...@google.com> #2
I don't think this is related to Gradle itself. This is how Android handles resources.
Adam, do you have an idea of what's going on here?
Adam, do you have an idea of what's going on here?
Description
Problem encountered:
The `SpreadsheetApp.openById()` method is throwing an "Unexpected error" exception, preventing me from accessing a spreadsheet. This occurs even in minimal test cases with brand new spreadsheets and scripts, suggesting a broader issue with the Apps Script environment or my account's interaction with it. The specific error message is: "Exception: Unexpected error while getting the method or property openById on object SpreadsheetApp."
What I expected to happen:
I expected `SpreadsheetApp.openById()` to successfully open the spreadsheet and return a Spreadsheet object, allowing me to access its properties and methods (like `getName()`, `canEdit()`, etc.).
Steps to reproduce:
1. Create a new Google Sheet.
2. Open the Script editor (Tools > Script editor).
3. Create a new, empty Apps Script project.
4. Paste the following code into the script editor:
```javascript
function testOpenById() {
try {
const spreadsheet = SpreadsheetApp.openById('1Ux02RKEgBwHxGM1OZawWxPBrnHULjUwE98KPY2MOfZM'); // Replace with the ID of your spreadsheet
Logger.log("Spreadsheet name: " + spreadsheet.getName());
} catch (error) {
Logger.log("Error: " + error);
}
}
I have tried this with multiple spreadsheets, including brand new spreadsheets created specifically for testing.
I have created new Apps Script projects to rule out project-specific issues.
I have verified that the spreadsheet IDs are correct.
I have ensured that the script is running under a Google account that has edit access to the spreadsheet.
I have tested in different browsers (Chrome, Firefox) and in incognito mode.
I have cleared my browser's cache and cookies.
I have confirmed that the Apps Script project is using the V8 runtime.
I have checked the Google Workspace Status Dashboard for any reported outages.
I have tried using Utilities.sleep() after openById() to rule out potential timing issues.
I have consulted the Apps Script documentation on SpreadsheetApp and permissions:
None of these workarounds have resolved the issue. The error persists even in minimal test cases, suggesting a deeper problem with the Apps Script environment or my account's interaction with it.