"No datasets found." google sheets

Scott Buelter shared this question 1 year ago
Answered

Hello, I am trying to connect to Google Sheets and I am getting this error (also see image)

Connection Failed


close_small_greyError Message:java.lang.Exception: Connection failed. No datasets found.

I do have hundreds of google spreadsheets in my account so I am not sure why I am getting this error.

Comments (4)

photo
1

Hi Scott,

Thanks for reaching out with your question. I've done some testing and found that I encountered some issues with the Google Sheets Connector as well. I also found a related Defect regarding the connector that shows the same behavior you're seeing.

I'd recommend installing the Google Sheets V4 Beta Connector from the Marketplace and giving it a go. This seemed to resolve my issues. Let me know your results!

Thanks,

Ryan

photo
1

Hi Scott,

I wanted to check in and see if you had better luck with our Google Sheets V4 Beta Connector.

Thanks,

Ryan

photo
1

Hi Scott,

I wanted to quickly check in and verify whether the V4 connector resolved your issue. If I don't hear back, I'll go ahead and close this out.

Thanks,

Ryan

photo
1

Hi Scott,

I haven't heard back on this for some time. I'm going to mark this as Answered. Please don't hesitate to reach out with further questions or issues.

Thanks,

Ryan