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