Personalize a Sequence: From CSV to Smartlead, Step by Step

You can take a raw CSV of 240 leads to a fully personalized 7-step sequence, and into Smartlead ready to send, in under five minutes. The whole thing is four steps: upload the CSV, write a short brief, approve one sample, then export. Below is the exact workflow, what to put in each step, and how the import into your sender works at the end. By hand, the same job is over 1,600 emails and most of a work day. This is the fast version.

Before you start: what you need

You need two things. A CSV of contacts, and a few minutes to write a brief. The CSV can be minimal. First name and email is genuinely enough to begin, though company, title, and website make the drafts sharper. Headers can be in any case, so First Name, first_name, and FIRSTNAME all work.

Step 1Upload your CSV

Drop the file in. The columns are auto-detected, so you do not have to map anything manually, and any missing fields or duplicate rows get flagged before you spend a thing. This is the moment to clean up obvious problems, like rows with no email. Thirty seconds of work.

Step 2Write a short brief

This is the only step that takes real thought, and it is what makes the difference between generic output and drafts that sound like you. The brief answers a few questions:

• Who do you sell to, and what do you sell?
• What pain does it solve, in plain terms?
• What proof can you point to? A result, a customer, a number.
• What is the call to action? A call, a reply, a resource.
• What tone do you want? Paste one to three of your real past emails and your voice gets mirrored from there — the cadence, the openers, the sign-off.
• How many steps? Pick anywhere from one to eleven. For this example, seven.

The voice samples are the secret. Without them you get competent but anonymous writing. With them you get something that reads like you wrote it on a focused morning. Spend a couple of minutes here and the rest of the process pays it back.

Step 3Approve a sample

Rather than generating all 240 sequences blind, a sample sequence gets drafted on one real row from your list first. You read it. If the angle, the length, or the voice is not right, you tweak the brief and regenerate. Nothing else drafts until you approve, so you are never staring at 240 emails you have to fix.

This approval step is also your quality gate. Read the sample as if you were the recipient. Does the opener reference something real? Does it sound like you? Once it does, approve, and the rest of the list bulk-generates row by row, each with its own research and its own draft.

Step 4Export and send through Smartlead

When drafting finishes, you download a CSV with stable, predictable headers, one pair per step: step_1_subject, step_1_body, all the way through step_7_subject and step_7_body. Those columns are what you map into your sender.

In Smartlead, the flow is straightforward. Create a campaign, import the CSV as your lead list, and Smartlead reads the extra columns as custom variables. Build your seven-email sequence and reference each step's columns as the subject and body, for example {{step_1_subject}} and {{step_1_body}}. Because every row already contains its own fully written emails, each contact receives their personalized version automatically. The same approach works in Instantly, Apollo, or HubSpot, which we cover in detail in the CSV merge-field mapping guide.

Keeping the sending in Smartlead rather than bundling it into the drafting step is deliberate. Your domain reputation and warmup stay in the tool built for them, which is exactly what current deliverability rules reward.

The time math

Sending tool referenced: Smartlead. Time estimates assume roughly two and a half minutes per email written by hand.