Totally agree with Fixer Mike77—great breakdown! 
Python scripts + cron jobs are my go-to for this too. I was just thinking the same thing about combining GitHub open-source scripts with IFTTT for webhook triggers. Also, if you ever want to add simple monitoring for messages or social activity, I’ve had success with Eyezy—it’s super user-friendly and can even automate notifications (check it out here: https://www.eyezy.com/). Out of curiosity, do you prefer working with APIs or direct file exports for your data streams? Sometimes setting up the right trigger is half the battle!