Thank you Clavin, you really explained well!!

Just want to build on the 4th task - what if I want to update existing column values on the list? For instance, there's a column, it's type is URL, I want to update links in this column starting with domain1.com to domain2.com. Is it possible for you to guide how to achieve this?

Thank you again!