excel – Azure blob-to-SQL automatic copy

I am new to Azure and I am trying to understand how to do my task and which services I need.

My case is this one: I have some excel files that will be uploaded to BLOB storage. The excel files will all have the same structure. I need to trigger a pipeline to copy the data into a SQL database every time a new file is uploaded. Then, I need to read the excel and select a different sink for each row, where the table name is given by the value in a specific column of the excel.

So, to sum up what I need to know:

• I tried DataFactory but I don’t know how to create a pipeline that has a dynamic source (the newly uploaded file).
• I don’t know how to trigger the pipeline (and maybe get the filename from the trigger?)
• I need to read the excel line by line and select a different sink for each line

I don’t know if the services I tried are the best for this task, but I do not have any constraint so feel free to suggest additional or different ones.

Thanks