Unstructured Text
Email Extractor
Pull every email address out of a block of text and get a clean list with duplicates removed.
When to use it
Typical uses: Collecting the contacts from a long email thread; Pulling addresses out of a CSV or CRM export; Building a list of attendees from a sign-up document.
In a pipeline
Text InputEmail ExtractorText Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Text column | select | — | Text |
| Results | select | — | lines |
| Generate New Column | checkbox | — | false |
| New Column Name | text | — | Default: <column> Result |
| Insert After | select | — | After the column |
Example
Email Extractor: an example
| Text |
|---|
| Contact Sales@Example.com or support@example.co.uk. CC: jane.doe+news@mail.example.org, sales@example.com |
| Text |
|---|
| sales@example.com support@example.co.uk jane.doe+news@mail.example.org |
Worth knowing
- Does it verify that the addresses work? No. It finds text that looks like an email address. It does not send email or check mail servers.
- Why are the addresses in lowercase? Email addresses are treated as case-insensitive in practice, so lowercasing makes it possible to remove duplicates reliably.
- Can I use the list for marketing emails? Only email people who have agreed to hear from you. Sending unsolicited bulk email breaks anti-spam laws in many countries, including Canada’s CASL and the US CAN-SPAM Act.
- Works on any text column, not only Text Input's: pick it under Text column. Tick Generate New Column to keep the original next to the result.