How to send 3rd party api data with multiple rows to Google Sheets

[ddra90n]

Hi, using Pabbly, I'm able to grab 3rd party api data, which have multiple rows. How do I add these rows of data to Google Sheets? I tried "add a row" but that only adds the last row of api data. I tried "update values within a range" but it doesn't allow me to add data for 2nd or 3rd row either. Here's my video of my steps: https://www.loom.com/share/4e9ef42007bc40cca2511a303cfa59bf

And here's the Google Sheet: https://docs.google.com/spreadsheets/d/1UrC7ymPGQ1o5jnkbBmj3fRHuxKKVVqkTQsW3gS7SBI0/edit?usp=sharing

 

[Fagun Shah]

You need to capture the API call response with Simple Response toggle turned off.

Once you do that it will capture the response in array format. Then you can use iterator to add each row one by one in the google sheet.

Keep in mind that while setting up the iterator it will only go through the 1st data of the array(1st result/row) , but in real execution it will go through each row one by one and add them al the google sheet using Add New Row action.

Here is a video that might help you -

Also feel free to DM me on FB if you need any more help. We can do a quick zoom call.

 

[ddra90n]

You need to capture the API call response with Simple Response toggle turned off.

Once you do that it will capture the response in array format. Then you can use iterator to add each row one by one in the google sheet.

Keep in mind that while setting up the iterator it will only go through the 1st data of the array(1st result/row) , but in real execution it will go through each row one by one and add them al the google sheet using Add New Row action.

Here is a video that might help you -

Also feel free to DM me on FB if you need any more help. We can do a quick zoom call.

Thank you Fagun. I need a little more help. Just DM'ed you on FB. Thank you.