Hello!
Firstly, thank you for this useful tap. I've spent some time integrating it and it works well, however due to requiring OAuth authentication, I needed to switch to using singer-io/tap-google-sheets, since support for service accounts was implemented in PR 103. This tap is unfortunately much less capable than yours.
The issue with OAuth is that I don't see a way to use this integration without Meltano running with the permissions of a particular user account and therefore having access to all of those user's Google Drive files. A service account integration is more secure because it allows sharing individual files with the service account email address and that gives much more granular access control.
I'm just wondering whether you've ever considered adding support for this or whether there's something I missed and it actually is already possible. I did spend quite a lot of time trying to find a way though, so hopefully I didn't miss anything!
Hello!
Firstly, thank you for this useful tap. I've spent some time integrating it and it works well, however due to requiring OAuth authentication, I needed to switch to using
singer-io/tap-google-sheets, since support for service accounts was implemented in PR 103. This tap is unfortunately much less capable than yours.The issue with OAuth is that I don't see a way to use this integration without Meltano running with the permissions of a particular user account and therefore having access to all of those user's Google Drive files. A service account integration is more secure because it allows sharing individual files with the service account email address and that gives much more granular access control.
I'm just wondering whether you've ever considered adding support for this or whether there's something I missed and it actually is already possible. I did spend quite a lot of time trying to find a way though, so hopefully I didn't miss anything!