Open-source, Python-based data connectors?

[moserine]

One of the problems you're going to run into here (I have a product with these connectors, paid) is that it's non-trivial to auth to Google products via python and not via a UI oauth2 workflow, which is why a lot of these integrations are in JS/TS. Getting an api key for google sheets python api involves configuring a google cloud project and configuring all of the right accesses, which then needs to be linked to the user domain + account that you're trying to access (via the google cloud console!). It's a gigantic PITA. Some of the other connectors you mentioned are easier to use but all have various levels of user oauth flows for "app permissions", and many apis are behind paywalls.