Googlesheets not functioning in RStudio Cloud

Posit Professional & Hosted Products Posit Cloud
,
1

Does the googlesheets package work with Cloud yet?

When I attempt to authenticate, I get to the external Google Auth page okay, but when I complete that page the connection is refused:

This site can’t be reached

localhost refused to connect.

ERR_CONNECTION_REFUSED

2

Hi,

I think the issue with googlesheets, specifically the OAuth2 calls, is that they require an INBOUND connection from google servers to the RStudio Cloud servers, which is not currently allowed for security reasons.

I'm not sure if there are alternative methods that do not require this incoming connection (i.e. oauth_listener()). Perhaps @jennybryan has some insight?

-Andy