How to get single URLs from APify web scraper?

Hello, fellow makers!

And thanks in advance for any potential help <3.

I have this scenario, which try to do as follows:

  1. Take keyword from sheets
  2. Google the keyword using apify
  3. Save first two pages of search results
  4. Then save the different URLs in the another Google sheet


dfd

So if you Google: “best integration software” and the first three results are:

make .com
zappier .com
pabbly .com

I would like to get this three URLs in the sheet as well (one result one row).

Now, I use OrganicResults in iterator:

Which returns following thing:

I get three rows in sheet (so the iteration is working)

But on all three rows there is just the first URL.

Using example above its:

make .com
make .com
make .com

JSON in apify is structured like this:

and the URLs are basically what we need to get into the sheet.

Maybe using some block before Iterator to parse the JSON first?

PS. If I got multiple pages with results (like two) the number of page in sheets is right, but always its just the first URL from the page, and if there are 10URL on search page I get 10x the first URL.

Any advice much appreacited!

1 Like

I found the JSON module which solved that)
→ trasnfer apify to json → parse json

3 Likes