Shopify Multiple Orders to Google Sheet Problem

[botsloh]

Dear Pabbly Support,

I'm facing a problem here about syncing orders from my shopify store to google sheet, I set up everything

Screenshot

Captured with Lightshot

prnt.sc

Everything good for google sheet the data added perfect but when i got two orders or three with same customer it's not creating new rows, so my team have to check the shopify url and we wast time on it.

img1 : https://prnt.sc/CDBmY15X_5SF

img2: https://prnt.sc/x3HCL9sR-4mc

we're using cash on delivery method on our store so we need this option everything need to fetch on google sheet row by row (one order by one row not one row for one customer)

I talk to some developers and they told me i have to ask on this forum

my pabbly subscripction is $19.

THANK YOU

I hope you guys can help me with this problem as soon as possible

 

[Pabblymember11]

Hey @botsloh

Regarding your concern, you can use the Iterator action step which will process all the data to your Google Sheets one by one.

Please check out the following video tutorial for your better understanding on Iterator action step -

 

[botsloh]

hey, nothing can be selected here https://prnt.sc/Q-yn3b3Na1-Q
and i'm using shopify not wocommerce
thank you

 

[Pabblymember11]

Hey @botsloh

Yes, you need to capture the webhook response in advance response by toggling the Simple Response button and then re-capture the webhook response so in that way, you will get the data in JSON format then you can pass that JSON data in the Iterator action step which will further pass all your product/order on by one to your Google Sheets.

Kindly try the Iterator action step in your workflow with the help of the above-mentioned video and try again.

 

[botsloh]

Screenshot

Captured with Lightshot

prnt.sc

like this but still nothing to select

 

[botsloh]

1- https://prnt.sc/TATZzOVTXFVI

2- https://prnt.sc/7sLwUq3mOds0

3- https://prnt.sc/7CRx6mq-ZEZa

4- https://prnt.sc/Gwv6tvidAUOA

 

[Pabblymember11]

Hey @botsloh

It seems like you still haven't captured the webhook response in advance response by toggling the Simple Response button.

Please check out the following video tutorial once on how you can capture the webhook response in Advance Response to feed further in the Iterator action step.

 

[botsloh]

it worked buy turning off "simple response"
Thank you so much