Sheets API Not Working
-
I have changed to hte sheets api for my chat rooms project, and it seems that I am unable to read or write to the sheet, I have verified the user and sheet names and it seems it was working but has stopped working for reading at all, it just immediately skips (though now that I Think about it it may be the cloud blocks because the create random world i have to fix a minor bug, is just immediately skipped)
After further testing i have found that intially they work, but after they reach it seems that it reaches this and freeezes, then it goes on and after this block runs then the above bug (null returning) happens, but before it runs it will return the proper output for the referenced cell
TLDR: It seems that either just reading, attempting to read a lot of data, or reading a lot of data (the actual table currently has 3 columns by 16 rows so I very much hope it isnโt reading too much data) cuauses cloud blocks to lock out
-
Reading range A1:Z999999 is definitely too large. How about trying to read a few rows at a time?