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, loaded into Smartlead and ready to send, in under an hour. SimpleSend's campaign wizard has six steps: Upload, Review data, Brief, Approve sample, Generate, and Send or export. Your part is a few minutes of setup and one sample to read. The drafting itself takes about 20 to 25 minutes. Below is the exact workflow, what to put in each step, and how the import into Smartlead works at the end. By hand, the same job is 1,680 emails and a full working day or more.

Before you start: what you need

You need two things: a list of contacts and a few minutes to write a brief. For an email campaign the CSV needs three columns: first name, company and email. Title and website make the drafts sharper. Header spelling is forgiving, so First Name, first_name, and FIRSTNAME all map to the same field, and you confirm the mapping before anything runs.

Those extra columns are worth using. A notes column from your CRM, a link to a recent post, or a trigger you already track can all become research inputs in the brief. Reading a notes column costs 1 credit per contact; links, labels and inserted text cost nothing extra.

A CSV is not the only way in, either:

• HubSpot: import a list of up to 500 contacts through a read-only connection, at no credit cost.
• Find Leads: on a paid plan, search B2B contacts by title, seniority, industry, headcount and more, then draft straight from the saved list.
• Sales Navigator: with the LinkedIn Outreach add-on, import a Sales Navigator search for a LinkedIn campaign. Those imports carry no email addresses, so they feed LinkedIn rather than this email workflow.

Step 1Upload your list

Start a new campaign and drop the CSV in, or pick a HubSpot or Find Leads list instead. Files up to 10 MB work, and SimpleSend drafts up to 500 rows per batch, so a 240-contact list runs in one go. Ten seconds of work.

Step 2Review the data

SimpleSend auto-detects your columns and shows the mapping for you to confirm. First name, company and email are marked as required, and anything it guessed wrong is one dropdown to fix. It also flags rows missing a required field, duplicate emails and role inboxes like info@, with one click to remove the duplicates or drop the flagged rows. This is also where you choose which extra columns feed the brief. About a minute of work.

Step 3Write 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? You can give up to three value props. They rotate across the steps and each contact starts on a different one, so make every one of them strong.
• What proof can you point to? A result, a customer, a number.
• What is the call to action? A call, a reply, a resource, plus the link that makes it easy.
• 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 ten. For this example, seven.
• What should it research? Add research targets, such as a recent funding round or open sales roles, each with a note on how to play it when it turns up. A target costs 5 credits per company, findings are reused free for 30 days, and planning the research adds 5 credits per target once per campaign.
• Which model? Standard, Premium or Enhance, at 2, 4 or 8 credits per drafted email.

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, then save the brief as a template so your next campaign starts from it.

Step 4Approve a sample

Rather than generating all 240 sequences blind, SimpleSend drafts one contact's full sequence from your list first. You read it. If the angle, the length, or the voice is not right, leave feedback notes or tweak the brief and redraft. Your notes steer every draft that follows, and 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.

Step 5Generate the rest

Approve, and the rest of the list drafts row by row, each contact with its own research and its own sequence. Every draft goes through a QA pass and a fact-check against the research, and anything flagged is listed for review on the final screen. At about six seconds per contact, 240 contacts take roughly 20 to 25 minutes, and you can watch each draft land as it runs.

Step 6Send or export to Smartlead

When drafting finishes, the last screen offers two paths. If your plan includes sending (Pro, or Individual with the Email Sending add-on), Send with SimpleSend turns the campaign into a Sequence that sends from warmed mailboxes on domains registered in your name, and every contact keeps their own drafted wording. This tutorial takes the other path: Download CSV.

The CSV has stable, predictable headers. It starts with the standard contact columns, first_name, last_name, company, email and title, then one pair per step: step_1_subject, step_1_body, all the way through step_7_subject and step_7_body. An optional step_N_delay_days column carries each step's wait. Pick the HTML link style before you download, so your call-to-action link stays clickable once Smartlead drops the body in.

In Smartlead, the flow is straightforward. Create a campaign and import the CSV as your lead list, mapping email, first_name, last_name and company to Smartlead's standard fields and keeping the step columns as custom fields. 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.

Whichever path you take, the deliverability rule is the same: send cold email from dedicated, authenticated domains, never your main one, and warm them first. In Smartlead that means warmed sending accounts on a secondary domain. In SimpleSend, the domains, DNS records and warmup are set up for you.

The time math

Sending tool referenced: Smartlead. Time estimates assume two to three minutes per contact by hand (research plus all seven steps) and about six seconds per contact for SimpleSend's drafting. Smartlead's menu labels change as the tool updates, so treat the import steps as a map rather than a literal click path.