How do I schedule cache updates

Is there a way to have the cache clear/update around midnight. Our Marketing team was used to making site updates on the fly and then seeing them immediately on the site, now it can take up to 24 hours which is fine because now they make the changes in the test site and then post them once a day to see them on the live site sometime the next day. Today they updated between 11:30am-noon. We are just trying to figure out when new updates will post to the site and how we get them to consistently post overnight around midnight instead of mid-day the following day.

Any suggestions/help is appreciated.

A cron job to call the Purge API would do it.

https://developers.cloudflare.com/api/operations/zone-purge

If you don’t have command line access on your hosting, you could use a Worker:

https://developers.cloudflare.com/workers/configuration/cron-triggers/