API Response to google sheet - adds only 1 row

Hi,

Trying to deal with an issue regarding sending API responses to google sheet (Add a Row) .
In general, querying the API and sending to google sheet works, but it always adds only 1 row in google sheet with the first product when there are more than 50 of them in the API response.
I will be very grateful for your help

Hi. Use an iterator module after the this step and map the “data” array. So every record will be a new line in the spreadsheet.

If you need additional support, please don’t hesitate to reach out.

Cheers

1 Like

just a word of caution - watch your Operations usage. You can chew through a lot of operations if you are running this regularly.

1 Like

@Rafael7 @IainM
This can be done in 2 to 3 operations max using bulk update:

MSquare Support
Visit us here
Youtube Channel