Inspiration
Email Transformer is the swiss-army-knife of email transformation.
If you are working in marketing or customer support you sometimes have to work with a csv file including a lot of email addresses. Transformations of email columns into something else is useful but a lot of manual work.
For example you might want to extract the domain of the emails to check for domains of competitors or internal databases, to check for privacy preserving proxies (also called relays) from Apple and Facebook or to group emails by country. While not perfect: transformations of emails can be a surprisingly effective heuristic.
Another use case is to turn an email address into an md5 checksum to look it up in vulnerability databases. If you want to address a person by its name but only have their email address sometimes it is sufficient to transform the username part of the address into a capitalized name.
Email Transformer gives you various columns for your tables in Coda documents to extract, transform and group tables with email columns. To save time and get more out of the email csv files you are already working with.
What it does
See Inspiration
How we built it
The pack is written in vanilla Javascript using regular expressions and various string functions.
Challenges we ran into
We only joined this hackathon in the last few hours and would have loved a bit more time to work on the Pack before submission.
Accomplishments that we're proud of
Learning about the power of Packs in Coda and how easy it is to add useful domain specific functionality (like in this case working with email csv files).
What we learned
Talking to a few people we learned that working with email csvs is way more common than we imagined and often involves a lot of manual work in spreadsheet apps like Excel or in text editors.
What's next for Email Transformer
- more options for checksums
- dynamic lookups in various CRM tools that the user is already using
- integration with marketing and customer support tools for features like mail merge
- a SaaS API for batch processing
- even better documentation and examples
Built With
- javascript
- md5
- regex
Log in or sign up for Devpost to join the conversation.