If you can find what you're looking for by using a Google API service, then the answer is yes.

If you must scrape Google search results, Google is smarter than you or any developer, so will eventually figure out you're scrapping their data + completely block your IP.

https://commoncrawl.org - provides an alternative, as they provide a massive corpus of crawled content from millions of sites... so... if there's no Google API which can provide you the data you're after, consider using the Common Crawl datasets.

Locate services? Google map.. there is also Google My Business... scraping would do.. but in generating spreadsheet.. you can do it manually or maybe using python..

Google Sheets can automatically import data from other websites, and it also includes a form tool, Google Forms, to gather data and save it directly to your spreadsheet. Now, let us try it out by setting up a form to collect lead information from prospective clients. When people click on your link, they can fill out your questions, and the data will be saved to your spreadsheet automatically. First, you will want to add a form to your spreadsheet as a simple way to gather data.
You can read more here: https://zapier.com/learn/google-sheets/spreadsheet-crm/
Besides if you do have any questions give me a call: https://clarity.fm/joy-brotonath