How to handle duplicates

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

In this article

Dealing with duplicate records makes working with data harder. For example, duplicates take up extra rows in your contact lists, causing confusion between the data you need and redundant records. Duplicates would also make you spend extra transactions when sending out emails, not to mention spamming your customers.

Manually controlling duplicates is impossible, so Albato offers a tool to facilitate this. The tool does extra checks to ensure only unique data enters your automations.

This article walks you through the four scenarios of managing duplicates for your automations.

ISpring Learn.png

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

In this scenario, Albato does not perform additional checks and always sends a request to add a new record. Sometimes errors may occur if the required data uniqueness is not ensured.

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

Albato checks if sending data already exist in a receiving system. If such record is found (Duplicate), further processing of the current step will be stopped. And new record will not be created. The fields of the found record are available for the further steps of this automation.

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

In this scenario, Albato also searches for an existing record and updates its fields when found. If no duplicate is found, then new record is created.

For example, when submitting Facebook lead form, the system creates a customer record in CRM. It has standard fields: name, phone number and email. Next time the customer will communicate with you (e.g., a call after clicking the ad), additional data from ad system will be automatically loaded to his card.

You can delete the current value and enter your own data or select from the drop-down list. The field will be updated.

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

This is the last option for working with duplicates. It searches for duplicate, and stops if duplicates are not found. The scenario is similar to the previous one and performs the same functions except for creating a new record. Thus, it serves only to update records.


Tools

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
Zapier vs. Make vs Albato: Full Comparison
6 min. read

Zapier vs. Make vs Albato: Full Comparison

In this article, you will learn how Zapier, Make, and Albato compare to each other to see which SaaS automation platform suits your needs. Explore capabilities, pricing, features, and use cases.

Our Automation Builder Has Just Leveled Up
3 min. read

Our Automation Builder Has Just Leveled Up

Explore what’s new in Albato: features, apps, and improvements

Best Accounting Apps to Manage Your Business Finances
7 min. read

Best Accounting Apps to Manage Your Business Finances

In this article, you will learn about the top accounting apps like Sage, QuickBooks, Zoho Books, and more to simplify bookkeeping, automate workflows, and grow your business.

Grok AI Use Cases: Gmail, WhatsApp, CRM & More
5 min. read

Grok AI Use Cases: Gmail, WhatsApp, CRM & More

In this article, you will learn some practical Grok AI automation use cases, from Gmail and WhatsApp to CRM queries and Google Home integration.

HubSpot vs. Pipedrive: Which CRM to Use
7 min. read

HubSpot vs. Pipedrive: Which CRM to Use

In this article, you will find a comparison between HubSpot and Pipedrive CRM tools in features, pricing, and usability for sales and marketing teams.

Best AI Automations with Albato: ChatGPT, Claude, Gemini
10 min. read

Best AI Automations with Albato: ChatGPT, Claude, Gemini

In this article, you will find some examples of powerful AI automations with ChatGPT, Claude, and other LLMs you can set up with Albato to boost productivity and streamline your business processes effortlessly.

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates
13 min. read

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates

In this article, you will find an in-depth comparison of Grok, ChatGPT, Gemini, and Claude. Discover their strengths, weaknesses, and which AI chatbot fits your business needs best.

Testing Steps Tool
5 min. read

Testing Steps Tool

Testing Steps tool allows you to run a test on each individual step and view Samples of incoming data

Branching Tool
5 min. read

Branching Tool

A new tool in Albato allows you to run different scenarios within a single automation depending on specific conditions.

How to Connect Help Scout to Albato
4 min. read

How to Connect Help Scout to Albato

Connect Help Scout with Albato to integrate it with over 1,000+ apps, including AI tools like Grok and Claude.

How to Connect PipeRun to Albato
4 min. read

How to Connect PipeRun to Albato

Connect PipeRun with Albato to integrate it with over 1,000+ apps, including AI tools like Grok and Claude.

How to Connect ClientJoy to Albato
3 min. read

How to Connect ClientJoy to Albato

Connect ClientJoy with Albato to integrate it with over 1,000+ apps, including AI tools like ChatGPT and Gemini.