Why do I see
HTTP 429 Too Many Requests error when creating Google sheets connector.
Google Sheets Setup Form
This issue is unique to Google Sheets connectors, and usually resolves itself after a few minutes. You can try setting up the connector again in sometime.
An HTTP 429 Error can be caused when Google's API receives too many requests in a given period of time as specified here