Sales & Business5 min read

Personalize an Entire Prospect List: CSV In, Trackable Links Out

Import a prospect CSV, map your columns, pick a material per row, and generate personalized collateral for the whole list — then export the table with every share link and view count included.

EEdithly Team
Personalize an Entire Prospect List: CSV In, Trackable Links Out

Bottom line: personalization does not fail because reps do not believe in it. It fails because doing it for two hundred accounts takes two weeks. Import the list, map the columns, generate — and get a table back with a trackable link on every row.

The Whole Loop, In Order

  1. Import a CSV. Apollo export, Clay table, a segment out of HubSpot, or a list you built by hand.
  2. Map the columns. Headers are matched automatically against the schema; anything ambiguous is yours to remap or skip.
  3. Set the material per row. Pitch deck, one pager, landing page, infographic, elevator pitch, cold call script or email outreach.
  4. Add notes where you have an angle. Click any notes cell and type; that note steers only that row.
  5. Generate. One row to test, or the whole list once the angle is right.
  6. Export. The full table comes back as CSV with share links and view counts attached.

The Column Mapping Is the Part That Usually Breaks

Every tool that accepts a CSV promises it is easy, and every rep has spent an hour renaming headers to satisfy one.

The importer matches loosely against each field:

FieldHeaders it recognizes
Prospect companycompany, company name, prospect co, prospect company
Website URLwebsite, url, website url, prospect website
Contact namecontact, name, contact name
Rolerole, title, position
Locationlocation, city, region, country
Materialmaterial, visual type, output type, type
Notesnotes, description, message
Linklink, share link, deck, html url
Viewsviews, views count, open count, count

You see the mapping before anything is created, and you can skip any column you do not want imported. An Apollo export usually maps with no manual intervention at all.

One Row at a Time, or the Whole List

Each prospect row has its own play button. This is deliberate.

  • Test on one row. Generate for a single account, open it in the preview drawer, and check whether the angle lands before spending credits on the rest.
  • Then run the list. Once the angle is right, queue the rest.

The rows are searchable and paginated, so a list of five hundred accounts stays workable. Completed rows open into a preview drawer on click; failed rows are highlighted with the error visible on the row rather than swallowed.

Notes: Segment-Level Personalization Without Segment-Level Work

The notes column is where a rep's judgement enters the process.

For a list of eighty accounts, you might write notes on twelve — the ones where you know something the research cannot find:

  • "Met their VP at a conference in March."
  • "They churned off our competitor last year."
  • "Renewal with the incumbent lands in Q1."

Those twelve rows get an asset shaped by that fact. The other sixty-eight get the research-driven default, which is still far better than the same PDF sent to all of them.

What You Get Back Is Measurable

The export is not just a record of what was generated. It carries a share link and a view count per row, which turns an outbound push into something you can actually read:

  • Zero views across a segment — the problem is the subject line or the list, not the asset.
  • High views, no replies — the asset lands and the call to action does not.
  • A single account with repeat views — someone is circulating it internally. Call them today.

Hand the export to an SDR team, an outreach partner, or push it back into the CRM so the link sits on the record.

Who Runs It This Way

  • SDR teams working a weekly list — one import on Monday, personalized assets for the whole week's sequence.
  • Founders doing their own outbound — a segment at a time, without hiring for it.
  • Agencies running client campaigns — a playbook per client, a list per campaign, an export per report.
  • AEs reviving a dead pipeline — export the stalled accounts, generate a one pager each, and give every one of them a reason to reopen.

Where the Individual Assets Are Covered

Each material has its own deep dive: the cold call script, the cold email variants, the one pager, and the personalized landing page. All of them are generated against the same product playbook.

If you would rather not touch a CSV at all, the same generation can be triggered from inside Apollo, Clay, HubSpot or Zoho, or asked for one account at a time through the sales assistant.

Start With One Segment

Export fifty accounts from your CRM. Import, generate, send, and look at the view counts in a week. That single loop tells you more about your messaging than a quarter of guessing.

Start with the GTM pilot at edithly.com/gtm — 50 free credits, every format, no credit card required.

Frequently Asked Questions

What columns does the CSV importer accept?

Prospect company, website URL, contact name, LinkedIn URL, role, location, material type, notes, created date, link, views count and last update date. Column names are matched loosely, so common header variations like 'company', 'url' or 'title' map automatically — and you can remap or skip any column during import.

Can I use an Apollo or Clay export directly?

Yes. Drop the export in as-is; the importer matches its headers to the schema and shows you the mapping before anything is created, so you can correct it.

Can different rows produce different materials?

Yes. Material type is a per-row field, so one import can produce one pagers for the enterprise accounts and cold call scripts for the mid-market rows.

Do I have to generate everything at once?

No. Each row has its own play button, so you can sanity-check an angle on one account before committing credits to the rest of the list.

What comes back in the export?

The full table as CSV, including all prospect data, share links and view counts — ready to hand to an SDR team, an outreach partner, or back into your CRM.

Can I add a different angle per prospect?

Yes. Every row has a notes field you can click to edit, and that note steers the generated asset for that account only.

Try Edithly free

Turn any document into something useful

Upload a PDF, paste a URL, or drop a YouTube link. Get mind maps, flashcards, MCQs, presentations and more — in seconds.