For that I would want to run everything through local JSON. Then tie into the WP create_category hook. Each time a new category is created, parse the json from the local file and update it. ACF will then pull the data from that json file instead of from the DB.
