How to fetch data daily and enter it into Google Sheet?
Status: Closed · Asked by auguk on · 0 views
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?
[IMG width="540px"]https://i.imgur.com/e3uan7R.png[/IMG]
Note, there is no possibility to send data about each sale via Webhook, unfortunately.
Any advice would be appreciated.
Thank you,
Augustas
When number of results are unknow in action response, use iterator in next step to through each response one by one -
You can also try this option -
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!