While all of the answers are valid, another option that I don't see here is n8n. I used it for something very similar to your requirement and was able to run it

While all of the answers are valid, another option that I don't see here is n8n. I used it for something very similar to your requirement and was able to run it for years without intervention.