Normalize and Deduplicate List (Utility)
Texau → Normalize and Deduplicate List (Utility)
Removes duplicate entries from a list of strings and returns unique items.
Input
What it needs.
Map each field to a column in your table. Optional fields can stay empty.
inputThe list of strings to normalize and deduplicate.text
When to use this.
The "Normalize & Deduplicate List" action is designed to streamline data management by removing duplicate entries from a provided list of strings, ensuring that only unique items are returned. Users input a list of strings through the 'input' parameter, which is essential for the deduplication process. The action outputs a deduplicated list as an array ('deduped_list'), a comma-separated string ('deduped_string'), and counts of both the original and deduplicated entries ('original_count' and 'deduplicated_count'). This action falls under the enrichment category and is particularly useful in scenarios such as data cleaning, preparing datasets for analysis, or enhancing user-generated content by eliminating redundancy. With its focus on text and count data types, this action is ideal for developers and data analysts looking to optimize data integrity and usability.
Output
What it returns.
Every field this action writes back to the row. Click a line to expand nested objects.
deduped_listDeduped Listnullablearraydeduped_stringDeduped Stringnullabletextdeduplicated_countDeduplicated Countnumberoriginal_countOriginal Countnumber
Compose
How this fits a workflow.
The next 2 actions most operators chain after this one.
enrichment
Remove Extra Whitespace (Utility)
Cleans up text by removing extra spaces, tabs, and newlines while preserving single spaces.
Identify Email Type (Utility)
Classifies an email address as personal, business, educational, or freemail and extracts the provider domain.
Find URL Redirect Destination (Utility)
Resolves a URL to its final destination and returns the full redirect chain with HTTP status codes.
Workflow
A real example.
Trigger → normalize and deduplicate list (utility) → enrich → push to your CRM. You set it up once; after that it runs without you.
Built for
Who runs this.
Reliability
Throughput & reliability.
How fast it drains a table, and what happens when the upstream provider has a bad day.
- Per-minute limit300 / min
- Per-day limit10,000 / day
- RetriesAutomatic w/ backoff
- Failed lookupsZero credits
Related
More Texau actions.
Remove Extra Whitespace (Utility)
Cleans up text by removing extra spaces, tabs, and newlines while preserving single spaces.
Identify Email Type (Utility)
Classifies an email address as personal, business, educational, or freemail and extracts the provider domain.
Find URL Redirect Destination (Utility)
Resolves a URL to its final destination and returns the full redirect chain with HTTP status codes.
Format Date and Time (Utility)
Converts a date-time string to UTC timezone and extracts individual date and time components.
FAQ.
Is this real-time?
Mostly. Fast actions fill the cell in a few seconds. Long-running ones run in the background and write back to the row when they finish, so you can close the tab.
Do I get charged on failure?
No. A failed lookup costs zero credits. When a provider misses or times out, the waterfall moves to the next one and you only pay for the match you actually got.
Do I have to run it row by row?
No. Run it on one cell, on a selection, on the whole table, or on a schedule. Same action either way.
What CRMs can I push results to?
HubSpot, Salesforce, Pipedrive, Zoho, and GoHighLevel are bidirectional. Smartlead, Instantly, Lemlist, HeyReach, Apollo Sequences, and Reply.io for outbound.
Run Normalize and Deduplicate List (Utility) in 60 seconds.
Connect the account, drop the action on a column, run it on your rows.