Hi, I'm trying to connect to a google sheet that it's in a shared drive. They gave me administration access to the drive, I have edit access to the sheet, yet I can't see the spreadsheet when I'm trying to authenticate via Oauth with my account (I'm not interested in service account authentification). What's going on?

Hey There! 👋 Your message has been received by the RudderStack team. Our standard customer support hours are 9-6 PM EST, but we will forward this request to your Technical Account Manager, and they will get back to you shortly. Please use the thread for any additional comments.

Are you using Google Sheets as a source or destination? • Google sheet as a source is available for paid customers only (Growth and Enterprise) • Google Sheet as a destination needs service account permission for configuration https://www.rudderstack.com/docs/destinations/streaming-destinations/google-sheets/#service-account-permissions

hey @quiet-wolf-72320, I'm using it as a source

Yes, it will work with a sheet shared directly or shared in a drive. I just tried it and was able to create the source. I see your workspace is on the Free tier and you won’t be able to add a Cloud Extract source with this plan. Do you have another account that is on growth or enterprise?

I think you're looking at a personal account. The workspace is called wedoogift-product and it's not a free tier

For growth and enterprise customers, we have dedicated support channels. Can you DM me your workspace id or email associated with the account? when you sign in via Google, you should see all the sheets in the drop-down. Can you check what permissions do you have on the shared sheet and drive?

Idk, I asked for support and your chatbot sent me here. The email is product@wedoogift.com and the workspace id is wedoogift-product. I don't have access to that email though. So, I have edit access to the sheet and I have administrator access to the drive I don't understand what's going on, it should be detected by your system

@green-jordan-18696 I have shared this with our eng team and they are taking a look.

Both are shared @quiet-wolf-72320

Can you DM the source id write key of google sheet source ?

I just dm’ed you the link. Thank you for your help! @quiet-wolf-72320

Hey @green-jordan-18696 the team is working on this and we will get back on this shortly. There seems to be an issue when working with a shared google sheet.