This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Resources exceeded during query execution: Google Sheets service overloaded for spreadsheet

Posted on 08-01-2024 08:30 AM
Hansenlim
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

So I have a gsheet with 1.5k row and a few simple formulas that is not heavy at all to run. Im consuming this gsheet as an external table in bigquery to use in a query.  The ghseet is running fine and i can query to the external table just fine. But today i encountered this issue that said: Resources exceeded during query execution: Google Sheets service overloaded for spreadsheet

What is the root cause of this problem? Cause i did not make any drastic changes to the ghseet and suddenly it just wont run on BQ.  Lots of users use the gsheet daily but it ran fine before. What should i do to fix this problem?

0 2 1,994
0 Likes
2 REPLIES 2