Google Search Results to Google Sheets Automation

I’m seeking an expert who can automate the extraction of Google search results into Google Sheets. Next to each url column should be the date column. This is NOT the date of publication but the date of the extraction. So all urls pulled on a certain day will have the same date. Key Details: I need to create a scenario where a google search result will populate a googlesheet page with urls from the search results. This scenario will be run weekly based upon a predefined google search, The search will be divided into 10 pages with 10 search results per page. Each page will need to be run sequentially to capture all urls. However, there many be less than 100 results so your scenario will need to identify when to stop based the results of the google search. You will need to use a Text parser module to clean the links. The results page should note include any of the internal google links and should only include the search results. The coding for Google will require cleaning since the href results in a format with other text in the url. This is a straight forward web scrape so it should not take long. Your finished scenario will need to be saved in your account and then exported so I can import it into my account.

1 Like

Hi Terry,

If you still looking for help, you can reach out to me.

None of the requirements you listed are a problem. They can be done with a database and integration with a SERP API.

I would love to help.

Thanks,

I have read the requirements, I’m here to help you out. Please check out my portfolio on My Profile to see my previous work. Let’s arrange a time through Schedule call to discuss further.

Hi Terry, this appears to be a promising project. We can utilize existing tools like this Google Search scraper built in Apify.,
Apify Console.

Then it would be just bout connecting is with make.com

If you are interested we would love to help you, you can schedule a call in here: Calendly - Felipe Saucedo