Deep Scraper > Google Sheet help

I thought there was a post about this. I canā€™t find it. So here it goes:

Google Sheet has a few columns. One of them is called Search. Itā€™s a URL (itā€™s already populated). There is another column thatā€™s called Website (I want Bardeen to populate this)

. I want my playbook to Open a link from the URL column, use the scraper to grab the link of the first listing. And then paste that in the field called Website.

As it is now, I am getting the website from the last link in the list, pasted in every row. Instead of it pasting the scraped website from the search url.

Itā€™s like I not telling Bardeen how to match correctly.

Help?

Hi @koch.bradleyj , would you mind sharing your automation and publicly sharing with edit rights your GSheet?

Iā€™ll take a look to see whatā€™s happening for you. As a friendly reminder going forward, itā€™s always best to provide the automation link in the community to help troubleshoot.

Thank you,
Jess

Thank you!

1 Like

@koch.bradleyj :slight_smile:

:slight_smile: Sorry Jess.

1 Like

Thank you @koch.bradleyj!

Am I understanding correctly?

You want Bardeen to scrape the URLs that are already populated in the ā€œSearchā€ Column and then have it scrape Google for the URL of first search result and then have it populate that in the corresponding row for the ā€œWebsiteā€ Column.

Yes.

Iā€™ve already scraped to get the list of URLā€™s. I want bardeen to use a scraper and open each link, copy a link from the page, update the row with the new URL.

1 Like

okay yep, gotcha.

I think the issue is in your scraper template. Which link are you trying to copy from the Google Search? Just the first result, right?

yes. Just the first one. I also tried grabbing the link from the card that shows when you search. Ultimately what I am trying to do is to get a companyā€™s website address.