Enterprise RevOps System Prompt: Automating CRM Data Hygiene and ICP Scoring

When sales reps import lead lists from tools like Apollo or Seamless.ai, the data is rarely clean. Company names come with legal tags like “LLC” or “GmbH”, job titles are wildly inconsistent, and first names have emojis or weird capitalization.

When that messy data goes straight into cold email sequences in Instantly or Lemlist, your emails read like spam: “Hi John, hope all is well at Acme Solutions, Inc.!” Prospects immediately know you used automated scrapers.

Here is the exact prompt we use to clean and standardize lead lists in ChatGPT or Claude before uploading them to your CRM.

The Data Cleaning and ICP Scoring Prompt

Open ChatGPT or Claude, copy the prompt below, and paste your raw lead list directly beneath it:

You are a B2B sales operations assistant. I will paste a list of leads with raw names, company names, and job titles.

Clean and format each record following these rules:
1. First Name: Capitalize properly. Strip titles (Mr., Dr.) and emojis.
2. Company Name: Remove legal suffixes (Inc., LLC, Ltd., Corp., GmbH). Keep only the recognizable brand name.
3. Job Title: Normalize non-standard titles (e.g., turn “Revenue Ninja” into “Sales Director”, or “Head of Growth” into “VP of Marketing”).
4. ICP Score (1–10): Rate fit for our target customer based on seniority and department (Higher score for VP/Director in Sales or Marketing; lower for junior or non-commercial roles).

Return the cleaned data as a simple table with columns: Clean First Name, Clean Company, Normalized Title, ICP Score.

Here are the raw leads:
[Paste your rows from Excel or Google Sheets]

Before and After

Here is what a raw row looks like when exported from an enrichment database:

dr. michael smith 🚀 | Acme Cloud Technologies, LLC | Head of Global Demand Gen & Growth Hacking

And here is what the prompt outputs:

  • First Name: Michael
  • Company: Acme Cloud
  • Job Title: VP of Marketing
  • ICP Score: 9/10

Now your cold email token {{company}} reads naturally as “Acme Cloud”, and your reps can prioritize reaching out to high-scoring decision-makers first.

One Honest Limit

AI can occasionally over-simplify unique brand names (for example, turning “ABC Corp Media” into just “ABC”). Always do a quick 60-second visual scan of the company column before importing the spreadsheet into your CRM.

Try It Today

Take 10 rows from your most recent outbound list, run them through this prompt, and see how much cleaner your email merge tags look.

About GPTify: GPTify.co helps B2B sales and marketing teams put AI to work with practical workflows, vetted tech stacks, and custom revenue automation. We publish a weekly briefing with tactical AI breakdowns—subscribe to our weekly newsletter and join 30,000+ revenue leaders in our LinkedIn community.

—

*Some links in this article are partner links. GPTify may earn a commission at no extra cost to you.*

**About GPTify:** [GPTify.co](https://gptify.co) helps B2B sales and marketing teams put AI to work, with training, ready-to-use tools and custom AI workflows.

Weekly Briefing

AI Insights for Sales & Marketing

What changed in AI this week, what it means for your pipeline, and 3 tools worth testing. A 5-minute weekly read.

Free · Unsubscribe anytime