When this error appears it basically means that you've been using your connector a lot during a certain time window (usually at least a couple hours of non-stop adding, filtering and refreshing).
At some point, Google starts to throttle your usage so their application doesn't crash:
The error: Community Connector Error. There was an error caused by this connector. There are too many scripts running simultaneously for this Google user account.
How to fix it
First, make sure your using a paid Google Workspace account. Such accounts have a much higher limits and therefore won't be throttled as often.
If you already have one, simply give it.a few minutes to start again.
You can also "Pause Updates" while building your dashboard to consume less resources.