Hi,
CSVi Pro is not yet compatible with HikaShop but I know that they are working on such compatibility to be available soon.
So I would first recommend you to contact CSVi to see with them where they are with it.
HikaShop has a mass actions system which can export CSVs and be triggered at specific times, like after an order is confirmed. So technically, you could use that, and then you would need to handle the sending of the CSV with another script or write a small HikaShop mass action plugin to handle the sending of the email with the generated CSV.