addin custom table

Hi Team, 

i have a requirement where i have give some data in excel like - empid, firstname, lastname, job description, category. 

for example 

These respondents i need to load into adobe and i need to send emails for them with the survey link like below : 

Email body : 

Hi <firstname>

some bla bla bla ....

survey link : https://dfdjfdjf.com?category = <insert category>

So ideally i am thinking of ideas- 

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. 

Let me know which is the best way to do this.