I know this was a while back but just checking if you got a resolution to this? Are you seeing the same problem with 2019.4?
This issue has been resolved. You should have no problem connecting to Google Sheets, publishing workbooks to Public, and those sheets updating daily.
Are you still having any issues with this?