How to add scrapped data from Browse.ai to Google Sheets

[limitcracker]

Your Task History ID

IjU3NjYwNTZiMDYzZTA0MzM1MjZjNTUzNzUxMzEi_pc

Hi,

I have a simple page that made possible to scrap using Browse.ai.
I want to add the scrapped data from Browse.ai to Google Sheets.

So I used those steps:

1. Browse.ai
2. Iterator
3. Google Sheets

but Iterator does not find an array.

Then I tried

1. Browse.ai
2. Array Function (Pabbly)
3. Iterator
4. Google Sheets

but I don't understand the template that referring to.

 

[Preeti Paryani]

Hello @limitcracker,

Please try capturing the response from the trigger in advanced format by turning off the Simple Response toggle under your trigger step. After that, click on "Recapture Webhook Response."

If the response is received in an array format, you'll then be able to use that data with the Iterator to process it further and send it to Google Sheets.

 

[limitcracker]

It's been showing as list

Hello @limitcracker,

Please try capturing the response from the trigger in advanced format by turning off the Simple Response toggle under your trigger step. After that, click on "Recapture Webhook Response."

If the response is received in an array format, you'll then be able to use that data with the Iterator to process it further and send it to Google Sheets.

Hi thanks a lot switching Simple Response off did the job.
Then I send them to Add Row or Multiple Rows? Cause I used the Iterator Array on Google Sheets Add Row but only one got into GSheet.

see attached:

 

[Preeti Paryani]

Hello @limitcracker,

In the workflow builder, when using the Iterator, it returns only the first object as a sample response, which you might have mapped further and added to Google Sheets. However, when the workflow runs in automation, the Iterator processes each object in the array individually—meaning it will execute all subsequent actions for every object in the array, as intended.

Let us know if you need further clarification.