What email app would let me send a discount code from a CSV after variant purchase?

[RoarLittleLions]

I have a very specific use-case for the app I need.

I have a product with two variants, A and B. If the customer purchases variant A, we would like them to receive an email with a discount code that is taken from a .CSV file with discount codes in it. There needs to be an iterator attached so that we are always sending a unique discount code.

I am working with another business and the discount codes are for a product for their business. So far the only solution we have found to give customers of my store a discount code for their store would be to create a .CSV file of various discount codes. They are not on Shopify, they do their own hosting.

I've looked through Klaviyo but it does not seem granular enough to fit my use case. Are there any other ways that we could achieve our use case?

Thank you.

[Kalen_Jordan]

I should be able to build out an automation workflow for this using our app mesa if you're interested. 

[OneMobile · Accepted solution]

Hi @RoarLittleLions 

You can consider integrating your Shopify store and email platform with automation platforms like Zapier.

You could set up a scenario that triggers when Variant A is purchased, reads a code from your .CSV file (stored in a service like Google Sheets), and then sends an email through your email platform.

I hope that this helps!