What it does
Cleans a contact list (needs an email column): trims and lower-cases each address, drops rows with no address, an invalid format, a test/placeholder/throwaway address, or a duplicate of an earlier row (and, if you choose, role addresses like info@). The results sheet is the clean list; every dropped row is in dropped.csv with the reason. It checks the format only and sends nothing.
How it works
- Decides what to do next
All 14 steps (as they appear in the app)
- email = {{email:trim}}
- email = {{email:lower}}
- If email empty
- Drop row: no email address
- If email matches {{valid_pattern}}
- Drop row: not a valid email address
- If email matches {{junk_pattern}}
- Drop row: test, placeholder or throwaway address
- If drop_role_addresses equals yes
- If email matches ^(info|sales|admin|support|contact|office|hello|enquiries|inquiries|team|marketing|billing|webmaster)@
- Drop row: role address (info@, sales@…)
- If email seen before
- Drop row: duplicate of an earlier row
- email_check = valid format
Sample data included
The template comes with sample rows like these, so you can see it work before using your own list.
| name | |
|---|---|
| Ada | [email protected] |
| Grace | [email protected] |
| Grace again | [email protected] |
| Typo | alan@@work |
| Placeholder | [email protected] |
Get this template
1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.
Download Develofly Autopilot2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).
Open in AutopilotWhat you need
- A spreadsheet (CSV or Excel) — a sample is included
You fill in: Also drop role addresses (info@, sales@…), Valid address pattern (advanced), Drop addresses matching (advanced).
Make it yours
Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.