Google Sheets Integration - The OAuth client was deleted

Trying to setup the google sheets integration.

Have followed all the steps here Google Sheets - Home Assistant

When adding the integration and clicking on the ‘Open Website’ link i get redirected to an error page

Access blocked: authorisation error

The OAuth client was deleted.

If you are a developer of this app, see error details.

Error 401: deleted_client

Have tested this on both Firefox and Edge, same issue

I get a similar error

Error 400: redirect_uri_mismatch

You can't sign in to this app because it doesn't comply with Google's OAuth 2.0 policy.

If you're the app developer, register the redirect URI in the Google Cloud Console.
Request details: redirect_uri=
[Related developer documentation]

Link to uri redirect error details