Add all responses to a Google Sheet
Status: Closed · Asked by Magda on · 0 views
Hi,
I have an action that returns several responses that I am trying to add to a Google Sheet.
There are 14 values (columns) and there are 12 rows worth or values (for example 0 ID, 0 name, 1 ID, 1 name and so on to 11 ID and 11 name (if there were only 2 values). The attached images shows the last of the 0 values and the first of the 1 values.
I want to add all 12 rows worth of values to a spreadsheet but when I test the automation I only ever get only one row worth of values to show up (instance 0) .
How do I get all the responses into sheet instead of only 1 row?
This seems like a trivial thing that should have an obvious answer, but after doing a lot of research I have not found the answer.
Thank you
Hi,I have an action that returns several responses that I am trying to add to a Google Sheet.
There are 14 values (columns) and there are 12 rows worth or values (for example 0 ID, 0 name, 1 ID, 1 name and so on to 11 ID and 11 name (if there were only 2 values). The attached images shows the last of the 0 values and the first of the 1 values.
I want to add all 12 rows worth of values to a spreadsheet but when I test the automation I only ever get only one row worth of values to show up (instance 0) .How do I get all the responses into sheet instead of only 1 row?
This seems like a trivial thing that should have an obvious answer, but after doing a lot of research I have not found the answer.
Thank you
Hello @Magda , Turn off the simple response for whichever action you are using, you'll get an Array of object and after that pass that respone through iterator then add that data to your desire app. If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.
Use below video as a reference:
Hello @Magda,
Please follow Himesh's suggestion and let us know if it resolves your issue. If you continue to face any challenges, kindly share the workflow URL you are using to achieve this use case. This will help us provide more specific guidance.
Looking forward to your response.
Thank you Himesh and Preeti! Got it now.
Hello @Magda,
Thanks for the update!