Hello,
Are you using a Google Workspace connection or connecting to a free Google account?
If you are using a free Google account, then yes, that is the limitation.
You can use the custom app auth method described in detail by Samliew in the thread you posted: Google - 429: RESOURCE_EXHAUSTED - #8 by samliew
But quite quickly you will run into another limitation: constant re-authentication.
Both problems come from Google’s policy. They want to “force” high-usage clients to use paid accounts.
If you are using a Google Workspace connection, this limitation should not apply.
And if you are a free Google user and you are not happy with these limitations, I would suggest creating one Google Workspace account and sharing files with the other free accounts you are using.