wowprompt

Email list cleaning before importing an old contact list

Checks an old or merged contact file before it goes into an email platform: consent, duplicates, role and disposable addresses, typos in domains, stale contacts and missing fields, then splits it into import, re-permission and discard groups. Use it before uploading a spreadsheet from an old tool, an event or a sales team.

A table of list problems with counts and actions, three output groups with rules, a corrected column map for the import and a re-permission email
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Sample of the file: [paste 30 to 100 rows with headers; mask real names if you prefer]
  • Total rows: [e.g. 12,400]
  • Where the contacts came from: [e.g. old newsletter tool, trade fair scans, website orders]
  • Consent record available: [e.g. signup date and source column, or none]
  • Last time this list was emailed: [e.g. 18 months ago]
  • Fields the new platform needs: [e.g. email, first name, city, signup source, consent date]

Task

Prepare this list for a safe import.

Output format

  1. | Problem | Rows affected in sample | Example | Action |, covering: duplicates, invalid syntax, domain typos such as gmial.com, role addresses such as info@ or sales@, disposable domains, missing consent, no activity in two years.
  2. Three groups with the rule for each:
  • import now
  • send one re-permission email first
  • do not import
  1. Column map from the old headers to the new fields, with formats to fix such as dates and phone numbers.
  2. A short re-permission email: subject, three-line body, one confirm button text.
  3. Steps after import: suppress bounces from the first send and remove non-confirmers after 14 days.

Rules

  • Contacts with no consent evidence are never added straight to marketing sends.
  • Report counts only for the rows given and estimate the full file in a range.
  • Do not repeat personal data from the sample in the answer beyond masked examples.
email list cleaninglist hygienecontact importemail consent checkduplicate contactsemail bounce prevention

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity