Use Google sheet as input for Google Map scrape

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.

No it can’t be used as a data source. You need to copy and paste what you need into SCM text box.

But it can write out the data into your sheet.

May I submit a feature request or is it too big an ask. :grinning_face_with_smiling_eyes:

Couple of things need to be worked out.

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).

Thank you for outlining the process and challenges so clearly, Tim.

I was hoping that there would be an easy solution but I do understand that this may be challenging and that it may be a niche use case.

Is there any limitation on the number of entries in the input field? I have just over 5k suburbs!