How to handle duplicates

How to handle duplicates
Tools
·
03/16/2022
·
3 min. read

In this article

Dealing with duplicate records makes data management difficult. Duplicate entries clutter your contact lists, create confusion, and increase the number of transactions when sending emails — which may even lead to spamming your customers. Manually controlling duplicates is not realistic, so Albato provides a built-in tool to ensure only unique data enters your automations.

This article explains the four duplicate-handling scenarios available in Albato.

 

The Duplicate Handling Tool

The Duplicate Handling tool is available inside certain action steps. If you do not see the icon, the app does not support duplicate processing.

updating2.png

Before configuring duplicate search, you must first fill in the fields in the action step. Duplicate detection can only be configured for fields that are already populated in the step settings.

updating3.png

 

Scenarios

Before configuring how your automation should handle duplicates, choose one of the available scenarios. Each scenario defines what Albato will do when it detects (or does not detect) an existing record in the receiving system.

ISpring Learn.png

 

Scenario 1. Do not check for duplicates, always create a new record

Albato sends a request to create a new record without performing any additional checks. Errors may occur if the receiving system requires unique data.

 

Scenario 2. Do not create a record if a duplicate is found

Albato checks whether the incoming data matches an existing record in the receiving system. If a duplicate is found, no new record is created, and the data from the existing record becomes available for the next steps of the automation. If no duplicate is found, Albato proceeds with creating a new record as usual.

 

Scenario 3. Update an existing record if a duplicate is found, otherwise create a new record

Albato searches for an existing record. If a duplicate is found, Albato updates the record with the incoming data. If no duplicate is found, a new record is created.

Example

When a Facebook lead form is submitted, a new CRM record is created with standard fields such as name, phone number, and email. If the same customer interacts with you again, additional data from the ad system can be automatically added to their CRM card — updating existing fields where necessary.

 

Scenario 4. Only update an existing record if a duplicate is found

Albato updates the record only when a duplicate exists. If no duplicate is found, Albato takes no action in this step and continues running the automation.

This scenario is similar to Scenario 3 but does not create new records.

 

Search Parameters

After selecting a scenario, you can choose the fields Albato will use to search for duplicates. These fields should be unique identifiers, such as deal ID, client ID, phone number, or email.

updating4.png

If multiple fields are selected, Albato uses a logical AND, all values must match for a duplicate to be detected.

If you need an OR condition (at least one match), use the Router tool instead.

 

Field Update Logic

Configure how fields should be updated when a duplicate is found:

  • Keep the Current value if you want to preserve the data already stored in the receiving system.
  • Remove the Current value tag and insert a new value from a previous step to update the field.
  • Add a new value alongside Current value to append information.
  • Remove the Current value and leave the field empty to clear it in the receiving system.

Click Save to apply the update rules.


Tools

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
How SaaS Businesses Improve Retention Using AI-Powered Email Marketing
5 min. read

How SaaS Businesses Improve Retention Using AI-Powered Email Marketing

Learn how SaaS brands can use AI-powered email automation to increase retention, reduce churn, and drive engagement with experts from Albato and UniOne.

Paragon Vs. Prismatic Vs. Albato Embedded: Which to Choose
5 min. read

Paragon Vs. Prismatic Vs. Albato Embedded: Which to Choose

Compare Paragon, Prismatic, and Albato Embedded—three leading embedded iPaaS platforms for SaaS. See how they differ in features, UX, pricing, and scalability.

AI for Customer Service Automation with Albato
5 min. read

AI for Customer Service Automation with Albato

Learn how AI agents and Albato automate customer service workflows—from ticket triage to WhatsApp replies and CRM updates.

Prismatic Vs. n8n Vs. Albato Embedded: Full Comparison
4 min. read

Prismatic Vs. n8n Vs. Albato Embedded: Full Comparison

Compare Prismatic vs n8n Embedded vs Albato Embedded—three leading embedded iPaaS solutions—for features, pricing, UX, developer experience, and scalability.

How to Use Python Code in Albato
4 min. read

How to Use Python Code in Albato

A new Python code tool allows you to run your own custom code.

How AI-Driven Copilots Transform Sales: Insights from Albato & Amplemarket
5 min. read

How AI-Driven Copilots Transform Sales: Insights from Albato & Amplemarket

Learn about how AI-driven sales copilots boost productivity, automate workflows, and drive revenue growth based on webinar insights.

How TimelinesAI Supercharged Their Automation Platform with Albato Embedded
2 min. read

How TimelinesAI Supercharged Their Automation Platform with Albato Embedded

TimelinesAI Partners with Albato Embedded to Bring Scalable Automation to WhatsApp and CRM Workflows.

Boost Your Team's Productivity: Less Busywork, More Impactful Decisions
3 min. read

Boost Your Team's Productivity: Less Busywork, More Impactful Decisions

Tools, tips, and tricks to help your team do less busywork and make every decision count.

n8n vs Zapier vs Albato: Best Automation Tool in 2025
8 min. read

n8n vs Zapier vs Albato: Best Automation Tool in 2025

Compare n8n, Zapier, and Albato — top no-code automation tools for freelancers, marketers & sales pros. See features, pricing, and key differences.

Merge Vs. Paragon Vs. Albato Embedded: Best Embedded iPaaS 2025
8 min. read

Merge Vs. Paragon Vs. Albato Embedded: Best Embedded iPaaS 2025

Compare Merge, Paragon, and Albato Embedded — leading embedded iPaaS platforms for SaaS founders. See features, pricing, and best use cases.

How to Connect SerpAPI to Albato
4 min. read

How to Connect SerpAPI to Albato

Connect SerpAPI with Albato to integrate it with over 1000+ apps, including AI tools like Grok and Claude.

How to Connect Nimble to Albato
3 min. read

How to Connect Nimble to Albato

Connect Nimble with Albato with 1000+ other apps, including AI tools like ChatGPT and Grok.