How to fetch data daily and enter it into Google Sheet?

[auguk]

Hello,
can you explain what functions in Pabbly Connect I can use to achieve this:
1. once per day using API I fetch the information about the sales in the last 24 hours.
2. I would like to import these rows into Google Sheet.
3. The number of daily sales is unknown. It can be 3 sales, it can be 15 sales.

How can I achieve that?

I already setup a scheduler and then call to my API using "API by Pabbly".
But what I should do next in order to iterate all the data when number of received rows changes every day?

Note, there is no possibility to send data about each sale via Webhook, unfortunately.

Any advice would be appreciated.

Thank you,
Augustas

 

[Fagun Shah]

When number of results are unknow in action response, use iterator in next step to through each response one by one -

 

[Fagun Shah]

You can also try this option -

 

[auguk]

Thank you Fagun! Your second video explaining how to import bulk CSV data into a Spreadsheet using "Line Itemizer" is what I need.
This is great help, thank you!