If my site is set up on cloudflare DNS

How do I point it to my cloudways? What records do I need to create?

Here is a KB article that will help you out. You need to set an A record equal to your server’s IP address.

There are 2 steps.

Firstly you need to ensure that your application is set to respond to yourdomain.com.

Secondly, you have to add your server IP address as an A record in your DNS table.

Here’s another link that will be useful in addition to the info linked by @russell https://support.cloudways.com/how-do-i-take-my-website-live-from-cloudways/