Automating Personalized Emails from CSV Data: Seeking Workflow Tips

Hi Team! I am in sales here. Hoping for a easy workflow where I can upload a CSV from Apollo.io, and have a bunch of columns that scrape data that lends itself to deeply personalized emails. The end column will craft the e-mail itself using the data from the other columns. Has anyone done this, or something better?