Dumb Question, Can't Figure Out How to Have a collection of tasks apply to every incoming row

[Nico Mee]

Hi, hoping somebody could reach out and help me with this. I've got a collection of columns and defined some tasks to be done and it works on the absolute value of a cell, populating the blank/empty columns its supposed to (it gathers company data like employee email, linkedin profile link, etc) but can't seem to get the thing to run on new rows (i.e. apply the formula/BLOCKSTRING= to the whole column)

I'm sure there's something very basic I'm missing here, let me know if anyone has any ideas! If helpful I'd love for someone to take a quick glance at the spreadsheet, very simple, and just see what I am doing wrong.