1. do i need to create a new custom table for it and load the data in there and create a delivery template like above. But if i do like that on delivery template i think we can only allow the recipients from recipient schema and adding any other schema we need to look over target mappings which needs some work to be done and it's not suggestable as far as i read in the documentation.
2. the second thing i am thinking is to map the columns given to recipient table for example
first name -> recipient tables firstname
last name -> last name
job description -> some column in recipient
category -> some column in recipient
this way i don't need to check for anything directly import the recipients and send the email.
There is also another simpler way by which you can send the survey email to the email addresses listed in the file.
You can simply read the file in a workflow using the data load activity, and send the email directly to those email addresses. Just make sure to change the delivery mapping to "external file".
This way you won't have to create any custom schema or add these records into your recipient schema, and you can still use the other fields from the file for personalization (firstname, category, etc.).