How do I use the API system to automate my SMS sending?

I have two separate databases where users input their contact numbers and another where their results are posted. I need the system to import these new contacts, find their result, and send it to them. I know it is possible. I don't know how to go about implementing this.