IssueTracker

Before opening a new issue, please search for other related issues, click the ★ to subscribe to updates, and click +1 to vote.

Description

TLDR: Timeout on openById() for specific sheet & clones since 8:30am on March 23rd. Other 2 work fine.

I’ve been using a Google Sheets file with an Apps Script function on a 10-minute trigger for years without issues. However, around 8:30am PST on March 23rd, this function suddenly stopped working and hasn't been completed a single time since, even though 2 other similar spreadsheets continue to run flawlessly with exact same function.

The problem appears to occur during a call to SpreadsheetApp.openById() which seems to be timing out. Even copies of the affected spreadsheet inherit the issue, suggesting that it and its duplicates might be hosted in the same datacenter.

If any member of the Google team is reading this, I’d greatly appreciate your help investigating the matter, as this spreadsheet is critical to my workflow.

Affected Sheet ID: 1g1tb6DreV2yzhWSqZBiHn28MCZjxcvPv8o-b_au8QTk

Code

function testSpreadsheetConnection() {
  Logger.log('testSpreadsheetConnection()');
  const id = "1g1tb6DreV2yzhWSqZBiHn28MCZjxcvPv8o-b_au8QTk";
  try {
    const ss = SpreadsheetApp.openById(id);
    Logger.log(`Connected successfully! Spreadsheet name: ${ss.getName()}`);
  } catch (e) {
    Logger.log(`Connection failed: ${e}`);
  }
}

Output

In the full code version, I get:

Exception: Service Spreadsheets timed out while accessing document with id 1g1tb6DreV2yzhWSqZBiHn28MCZjxcvPv8o-b_au8QTk

In the simplified version, as per the code above, I get:

Mar 24, 2025, 12:58:00 PM	Info	testSpreadsheetConnection()
Mar 24, 2025, 12:59:48 PM	Info	Connected successfully! Spreadsheet name: *redacted*

Steps

• I'm not sure since my other 2 practically identical sheets work fine... My best guess is that it depends on the data center