Bot, can I make one? Without technical know-how...

So, plainly, my questions are what know-how do I need to make one and if I ultimately can make one, how do I integrate it into a platform? E.g how did the pipedbot link I got to see, get integrated into lemmy in the comments section?

So, I just discovered something called piped because a lemmy bot linked a YouTube video to it. My familiarity with privacy and FOSS is a bit naïve, but I’d like to build more on it. I’ve seen similar bots when I was on reddit, ones that would give links to a mentioned song, or the moderator ones (I’m assuming the AutoMod thing is a bot too).

Could someone possibly walk me through how to make one? This might be irrelevant/relevant info: I’m familiar with knowledge graphs, SPARQL, a tiny tiny tiny bit of SQL, python and R (mostly because of school).

Also, apart from links, moderation, and chats on customer service websites, where would a non-techy apply it? Even if it’s just for personal use.

I know I could duckgogo this, but I prefer dynamic walkthroughs/explanations I can get here.