Duplicate Records on google sheet

Status: Closed · Asked by satyajiiit on · 0 views

satyajiiit — Question ·

we have a google sheet that we want to update using pabbly
Flow that we want is
1. push data to google sheet using webhook
2. Lookup by sheet
3. Add or Update according to the result of the lookup
Problem
It either updating the record or adding new, which makes duplicate records.
You can see records are repeating, our requirement is to keep the rows unique by Order Id
Here is the workflow: Here is the workflow link
https://connect.pabbly.com/workflow/mapping/IjExMTgwOSI_3D

Attachments

231539589_3006793582887731_7842448163664971042_n.jpg
231609859_3006793806221042_4907415042213593924_n.jpg
Pabblymember11 — Reply ·

Hey @satyajiiit

We have updated your workflow and added a filter step.

Using the filter step, it will not duplicate the entries by checking if the order ID already exists in your Google Sheets or not. Further, we have executed few tests and it seems to be working fine now.

Please check at your end now -

Back to all forum threads · Log in to reply