How to Create a Lead Scoring Table Using UTM Data and Actions

Hi everyone, I have a complex query. I'm wanting to create a lead scoring table for leads who we’ve attached a UTM to (clicked a link in an email). We now want to pull that UTM from a google sheet into clay and score them for actions they take like visiting our website (analytics) or engaging on LinkedIn (trigify or similar). What’s the best way to do this? How would we pull that data and then score it in a table to then trigger an action once they reach a certain score?