Is there any way to update google sheet without duplicate records?

[ravi111]

Hi,

I tried almost all conditions in filter, lookup, etc.

Requirement - I want to update the google sheet with API, if a row is present based on order id, I want to update it else create a new row.

Problem - If I add an action - lookup and update if order id exists - It only updates the existing, not add new records.

Please help

 

[Supreme]

Hey @ravi111

We looked into your workflow and made some changes as per your condition. So we have added a Google Sheets Lookup Value to search the row index in order to update the row. Further added the router conditions to add and to update the row as per your use case.

Please check the workflow "PC test- [InstaLinko Orders]" which we have created in your account so that you can easill understand the steps -

We have used a router that checks the conditions. Learn more here how router works -