Is there any way to use data from a Google sheet as the input for a Google Map scrape?
Use case: I have a Google sheet with a list of suburbs for which I want to run a query on e.g. guest house in [suburb]. I’d like the scraper to run a query for each suburb listed in the Google sheet and return all the Google Map results it finds.
You would need to select a worksheet, then a sheet, then tell scm the data range.
To select worksheet it would open a browser window.
Then you can select a drop down for sheets.
For data range, might require you type it in. There wouldn’t be any ui based selector for it since scm doesn’t have a spreadsheet ui.
Not sure if Google provides a range selector window, will need to research it.
Then SCM can download that data and prefill the textbox for you.
Also scm has start/resume feature.
So if you edit the sheet while it’s loaded into a task, the data would no longer be in sync with resume data so you would need to manually restart a task.
The question is if Google gives you a simple range selection to pick the right rows as query for Google maps task.
I need to research it. I have a feeling there isn’t one, so you need to type in the data range yourself (not ideal).