I didn’t use automation, but I didn’t have to do it one by one.
I just highlighted multiple and just copy and pasted. The links were pasted over too. Only thing I really had to do was edit the formatting. Idk how it works, but it copied over the black background of your website in sheets. I just had to change that.
The reason it took me a bit of time was that I’ve been trying to use https://www.libreoffice.org/ Calc (their spreadsheet). I didn’t want to pay for microsoft and thought it would be neat to have a more “permanent”/off-line program, but its been a bit annoying to use. I decided the other day to use sheets (I really like the syncing feature, can jump between my PC and mac) and just download backups of my sheets as a “permanent” solution. Its not like I’m trying to make complicated sheets anyways. I’m just keeping track of various things like what shows I watched, books I want to read, etc.
I made the spreadsheet in sheets in like 10 minutes. If that?