Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Unable to access existing Gsheet sourced tables or create new GSheet sourced tables

Getting this error across multiple projects and tables since around 9 AM AEST.

Failed to create table: Error while reading table: gs, error message: Failed to read the spreadsheet. Error message: API key not valid. Please pass a valid API key.
File: xxxxxxxxxxxxxxxxxxxxx

Also used a non enterprise google account to create a new gsheet linked table with the same error.

Additionally logged the same ticket here: https://issuetracker.google.com/issues/382316449

1 1 65
1 REPLY 1

Thank you for flagging. I had the same issue on 12/04/24 between 2-4 PM PST regarding BigQuery scheduled queries of Google Sheets external tables.

The issue appears to be resolved without my intervention: The scheduled queries successfully executed today.