Hey all, I am having a hard time to setup Google Search Console. I am on Airbyte 0.40.16 with connector version 0.1.18. I am using an existing service account that I have setup for Google Ads. I grant it “_Domain-wide Delegation_” via the Workspace Admin Console. Then I create a new key and use the service account’s email address together with the new JSON key in the Auth. However I do get the following error message:

The connection tests failed.

"Unable to connect to Google Search Console API with the provided credentials - KeyError('siteEntry')"

I found this thread: Google Search Console - Service Account Key Authentication Failure However it is with regards to version 0.1.16, so hopefully this error was fixed. Anyone who has experience here, who is willing to aid me?

Hey @Sebastian Brickel! Thanks for bringing this to our attention. Since this is a GA level connector, I'll bring it to the attention of the on call engineers. For now it looks like the workaround is to revert back to

0.1.14

. I know this is inconvenient, but hopefully you're able to use the connector even if it lacks some recent updates! I'll ping you here when I hear back from the engineering team. I don't see an issue on GitHub for this right now, but if you find one, let me know!

Hey @Nataly Merezhuk (Airbyte), thank you for you response. I will revert back and give it a try. Until then here the info: OS Version / Instance: Debian GNU/Linux 10 VM instance Memory / Disk: 7.50 / 35 GB Deployment: Docker Airbyte Version: 0.40.16 Source name/version: Google Search Console 0.1.18 Destination name/version: BigQuery 1.2.5

I would recommend resolving the misleading (key) error before investigating further otherwise meaningful debugging might be a futile attempt

Reverting back to

0.1.14

does work

Great to hear it!