Check and remove the last duplicate row

Questions
1

Describe the issue/error/question

I want to check for duplicates in n8n with 3 conditions. If the duplicate has same email,phone and name.

This is an example of how the data looks
qssZpe

I need to remove the last Kevin.

Is there a way for this, especially if I have a large dataset? I’m planning to set a cron job for like every 30 minutes to check for duplicate values

What is the error message (if any)?

Please share the workflow

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: latest version
  • Database you’re using (default: SQLite): Yes
  • Running n8n with the execution process [own(default), main]: main
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker
2

Any help on this, Kindly

3

Thé Item Lists node has a de duplicate option you could use for this

4

I tried it, but after that is it possible to remove the duplicates in the Google spreadsheet?

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.