Connecting to Google Sheets Connector

Ask the Community
1

Hi,

I am attempting to connect to Google Sheets through Data Connections. It’s not listed in the documentation as a direct source, but I assume the network egress is the same as Google Drive?

I’m unable to connect after ensuring my JSON key from Google is in one line, and that the data connection has those two policies created. The JSON key formatting is:

{"type": "my_service_account", "project_id": "myid-123"…}

Even after that I get the following error:

The explorer command failed to run:
java.lang.Throwable:RemoteException: INVALID_ARGUMENT (MagritteExplorer:SqlError) with instance ID db11dd85-9b43-4b4f-93f6-29948938c199: {reason=Invalid HTTP response from www.googleapis.com:443! System error: UnknownHostException - www.googleapis.com: Name or service not known., originalErrorInstanceId=30018be7-c09b-435e-b053-7839e457a7b1, stacktrace=com.palantir.magritte.explorer.jdbc.MagritteExplorerErrors.sqlError(MagritteExplorerErrors.java:25)

Anyone have any guidance? My service account has access to the Drive & Sheets API. I’m not sure what else the issue could be here.

2

googleapis.com (which is what I see in the documentation that you linked) and www.googleapis.com (which is what it looks like this connector is trying to access) are technically different domains. Can you try with an egress policy for www.googleapis.com ?

I’m not sure if this is a documentation issue or an actual difference between the domain accessed by the source types, but in any event, the meaning of the error message that you’re seeing is clear.

3

Doing an egress policy on www.googleapis.com did the trick. Thank you so much!