It is better to wait for Darren’s version i believe it will be clear, powerful, and easy to understand.
All i can say is just repeat: you just need some joint lists combined to template column and to send result (raw csv data) to Make which can convert it to file.
May be this How To: CSV Export and send as email
Another trick Export Glide Table/ Google Sheet Data to CSV using Joined List & Apps Script
1 Like