Hey
Darshika,
It's been a while since i last played with DataSink objects, but from what i remember your DataSink might be in the wrong position in your hierarchy.
If you move it immediately before the DatasourceLoop object and uncheck the 'Append' flag, "i think" that it would write each url to the same position each loop (overwriting each time) resulting in the final loops URL being saved to the spreadsheet.
Or....rather than bother with a DataSink, you could use Properties (TestCase or TestSuite properties) instead....i.e. write each loop to the same property and then it would only persist the final loops URL (cos each time the loop writes, the previous loop would be overwritten)
If what i suggested with the DataSink doesnt work (and no one else has any better ideas) and you only want to use DataSink rather than Properties, send a message back and i'll set it up on my machine and i'll work out how to do it, but you have a number of options how to do this.
Cheers,
Rich
