Google sheet connection

[j0aquinin]

Hi everyone,

I’ve connected Foundry to Google Sheets using a service account (via the Google Drive JDBC connector). The connection works, and I can see a table listing all my sheets — each row corresponds to a spreadsheet I’ve shared with the service account.

However, when I try to explore or import data, I only see that metadata table (the list of sheet names). I don’t get access to the actual contents of any of those sheets — even though they’re shared with the service account’s email.

It looks like the connection is authenticated, but it’s not reaching the sheet data itself. Is there an additional permission, OAuth scope, or property (e.g. OAuthJWTSubject, OAuthClientId, etc.) I need to configure for the service account to read the actual spreadsheet contents?

Thanks in advance for any guidance — I feel like I’m one setting away from it working.

[anaritarc]

Hi,

The sheets content appears outside as a dataset to sync. (I don’t know if is 100% well configured, but at least it is how it shows to me):

What I did is I get the information that I need from the Sheets and Spreadsheets table (like ids and all that) and then I use code repo to download all the content that I need.

In my case is not scalable to create a data sync per sheet.

Hope it helps,

Rita