Add the Chrome Extension – Linkclump – https://chrome.google.com/webstore/detail/linkclump/lfpjkncokllnfokkgpkobnkbkmelfefj?hl=en
Go to the options in Linkclump – click “Edit” in the “Actions” section
Change to Copy links to Clipboard instead of open in new Tabs
Do your search
Zoom out to see more results
Change Google settings to see 100 results per page
Hold down Z and click and drag over results
Paste into a google sheet