Not able to populate.... about wowspreadsheet HOT 4 OPEN

You can only do like 64-68 Results.
Your Guild size is 141 characters
About Half your Guild is level 70
which means your trying to display 69-72 players ( Soon to be more as they level up to 70 )

I would extremely suggest Change your Max Rank from a 10 to maybe a 9 or even an 8.
This would make it so the lowest Ranking Guildy's don't show up.
You can always Whitelist / Blacklist members if needed.

Alternative , you could ask 2 or 3 friends or make 2 or 3 extra google accounts, and make multiple spread sheets.
level 1-50 , 50-69, then like 70 Rank 10-5 , then 70 Rank 4-0 .

Another alternative there is some google premium options, i think the cheapest was like 5 or 8 bucks a month, and that would allow you like another 200 Character displays.

from wowspreadsheet.

Update , Since Dragon Flight & the way things are searched.
We can now only do about 63 Characters.

from wowspreadsheet.

Something else is going on and not just character count. I'll have this sheet closed for days, not published nor shared, manually killing integrations like WCL and Raider IO... and I'll open it up and be immediately greeted by a sheet full of service-invoked-too-many-times errors.

I've gone through the scripting a little, but not in-depth yet. Has anyone else run into that?

from wowspreadsheet.

This has been a huge issue since Blizz reworked the API a few years ago, and there is a lot of evidence that there is no way to prevent google from updating your sheets, even when they're closed. What this also means is.. if you have ANY old sheets on your account, they're also updating themselves. Make sure you entirely purge any old sheets from your docs account. I'd go as far as deleting any characters in those sheets as well before trashing them, just to make sure.

from wowspreadsheet.