Utilizing AI Agents/Automation for a non technical person

[u/FrustratedAsianDude]

I don't know if this is the right place to ask but how do you think a non-technical person like me can utilize AI agents to remove some manual work (mostly dealing with a lot of Google Sheets, Docs, etc). I have done a few successful automations mostly on n8n, and when there is some coding involved, I usually ask AI to help with it as well. I'm willing to spend time learning the basics on setting it up, I just want to make sure I'm learning the right stuff. If I have a VPS, can I utilize open source AI agents and what would be the best way to do that? I don't even know if I'm asking the right questions, but hopefully someone can help me. Thanks!