Normalize and Deduplicate List (Utility)
Removes duplicate entries from a list of strings and returns unique items.
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.
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
How this fits a workflow.
Trigger → Normalize and Deduplicate List (Utility) → enrich → push to your CRM. You set it up once; after that it runs without you.
- Step 1TriggerNew row, form submit, or schedule.
- Step 2Normalize and Deduplicate List (Utility)The TexAu action runs.
- Step 3EnrichWaterfall fills missing fields.
- Step 4Push to CRMHubSpot / Pipedrive / Zoho CRM / GoHighLevel.
Two actions you can chain after this one:
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
More TexAu actions.
enrichment
Remove Extra Whitespace (Utility)
Cleans up text by removing extra spaces, tabs, and newlines while preserving single spaces.
enrichment
Identify Email Type (Utility)
Classifies an email address as personal, business, educational, or freemail and extracts the provider domain.
enrichment
Find URL Redirect Destination (Utility)
Resolves a URL to its final destination and returns the full redirect chain with HTTP status codes.
enrichment
Format Date and Time (Utility)
Converts a date-time string to UTC timezone and extracts individual date and time components.
FAQ.
Run Normalize and Deduplicate List (Utility) in 60 seconds.
Connect the account, drop the action on a column, run it on your rows.