Download the Google sheet which has the complete set up on how to get google search results inside Google sheets. Once you download the CSV, open it with Google sheets and you are ready to go.
Get Google search results in Sheets – Download
Using this method, you can search google inside google sheets. Make sure you get your own google custom search API key. For any queries, please don’t hesitate to mail firstname.lastname@example.org.