Build a simple script for Google Sheets

Hi there,

I want to build a easy script that we can use to automate working tasks in Google sheet:

1. Copy the domain name
2. Google the domain name + "linkedin" --> to find company linkedin page
3. Copy the linkedin URL
4. Copy the name of the first co-worker that pops up in Linkedin
5. Paste Link in Google Sheet
6. Paste Name in Google sheet

Here is a video of the function: https://www.loom.com/share/d02cc51588b14642bf250d271fe53112

have a great day!

/ Erik