Woocommerce->GoogleSheet: How can I update an existing row by order_id?

[shenkwen]

I am trying to sync my order data from woocommerce to google sheet

+

When the order is changed from woocommerce's side, it should be synced to the google sheet. It looks like the "Row Index" field is expecting a fixed number, because when I put order id in there as the screenshot above shows, it returns an error saying something like A26093 is out of range.

So how should I make the app? Do I have to add a "Google Sheet look up row" step?
By the way, if there are multiple rows to be added, how should I fill in the "Row Index" field?
Also, how do I make the pabbly app create a new row in my google sheet if no order is found?

 

[shenkwen]

I am still setting up an App to capture new/update orders from woocommerce and update them to a Google Sheet.
Meanwhile, I'd like to know how can transfer my existing orders from woocommerce to the google sheet?

 

[Supreme]

Hey @shenkwen

In the Row Index field, you need to pass the index of the row in which want to update the data.

So, kindly use the "Google Sheets: Lookup Spreadsheet Rows" action step once to get the row index number which you can pass it further in the "Update Row" action step.

 

[shenkwen]

Thanks. But you didn't answer my other questions:
1) How do I transfer existing data? Currently there are around 220 orders on my site.
2) How do I make the Pabbly app to create a new row if the look up doesn't return any match?

 

[Supreme]

2) How do I make the Pabbly app to create a new row if the look up doesn't return any match?

You can use the Router action step if the desired data is unavailable in your Google Sheet and returned data not found in the Lookup action step.

 

[Supreme]

1) How do I transfer existing data? Currently there are around 220 orders on my site.

Regarding your use case to pass the data from WooCommerce to Google Sheets, you can refer to the following screenshot where can use the action step to do the same.