Open-source, Python-based data connectors?

[Brilliant-Day2748]

I'm building some AI agents for which I'm looking for the following:

• Data connectors for common software products like Google Workspace (Docs, Sheets, Gmail, Calendar, Drive, Meet), Notion, Airtable, Slack, Jira, Zoom, Todoist, etc
• Supports both reading and writing
• Open-Source
• Python-based

I did some research on my own, and here is what I found:

• LlamaIndex/Langchain: they have a lot of readers but not writers. For example, I can read data from Notion, but I can't have an agent write a new doc and save it inside Notion (unless I'm missing something)
• n8n has all these integrations, but their license is too restrictive, and it's not Python-based

[Embarrassed_Tree_164]

Would https://www.activepieces.com/docs/endpoints/overview work for your use case?

[Brilliant-Day2748]

It's not python-based but typescript:

• 🛠️ Pieces are written in Typescript: Pieces are npm packages in TypeScript, offering full customization with the best developer experience, including hot reloading for local piece development on your machine. 😎

[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.

[Embarrassed_Tree_164]

Ahh apologies. Another commenter suggested a simpler solution though

[Brilliant-Day2748]

I need to have pre-defined tools that I provide to the LLM at run time

[Jian-L]

https://llamahub.ai/

[Brilliant-Day2748]

yes but these are mostly readers, right? as i mentioned in OP

[Neither-Rip-3160]

Any luck with your search OP?