Hi Mehreen Ikram ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
As per my understanding of your question, it seems that you want to connect to the smartsheet as the source and import the data using ADF pipeline. Please let me know if that is not the ask.
Smartsheet connector is under preview and can only be utilized as inline dataset in Mapping data flow.
Go to the source option tab, and select the entity- sheet/report and provide the sheetname in the entityname section.
Hope it helps. Kindly accept the answer by clicking on Accept answer
button or reach out in case you have any additional query. Thankyou.