I am new to google scripts and I was wondering if it was possible to take a column in a google sheet, google the string in the specified column and then copy the first URL that appears in google in the next column of the spreadsheet.
Then something like:
It would become: (Where / denotes the following column)
- ebay / www.ebay.com
- amazon / www.amazon.com
- etc …
Where the web address is what appears first when you search Google for that chain. If anyone knows a quick way to do this or could point out some resources that would be incredible.