Export Smartlead Leads to CSV (Or Ask Your Agent Instead)
Step-by-step Smartlead CSV export from Lead list or Inbox. Plus sync via webhook and get a CSV or Google Sheet from your agent in seconds.
Yes, you can still export leads from Smartlead manually. Most teams doing this every Friday are better off syncing once and asking their agent for a CSV or Google Sheet instead.
Why teams export Smartlead data
A clean CSV helps you analyze performance, share a slice with stakeholders, or keep an archive for compliance. It is a fine one-off move. It gets painful when you repeat it across campaigns, clients, and sequencers.
How to export a CSV from Smartlead (Lead list)
- Open your campaign. Log in to Smartlead and open the campaign you need.
- Go to Lead list. Inside the campaign, select Lead list.
- Apply filters (optional). Narrow by Email Status (In progress, Completed, Not contacted) or Lead Category.
- Download as CSV. Click Download as CSV to save the file.
Name files consistently, for example smartlead-campaign-name-2026-06-11.csv, so your team knows which filters you used.
Export from Campaign Inbox (sequence step and status)
For engagement by message step:
- Open Campaign → Inbox.
- Filter by Email Sequence Step (Step 1, Step 3, etc.) and Email Status (Opened, Clicked, Replied, Bounced).
- Download as CSV.
This view helps you see which steps drive replies and which accounts bounced.
What is typically in a Smartlead CSV
Raw Smartlead exports often include:
- Lead name and email
- Current sequence step
- Sent, opened, clicked, and replied timestamps
- Reply text (when applicable)
- Open counts
That is enough for a single-campaign snapshot. It is not enough when you also run Instantly, HeyReach, or multiple clients.
Stop exporting every Friday
If you run the same Smartlead export every week to answer "who replied?", sync once and ask your agent instead.
One-time setup
- Install the skill in Claude Code, Cursor, or Hermes.
- Open Connections, copy your Smartlead webhook URL, and paste it into Smartlead.
- Ask your agent to sync your local database.
Get a CSV in seconds (local file)
Use the Outreach Magic skill.
Export all Smartlead leads from workspace [WORKSPACE]
where [FILTER: e.g. replied in the last 7 days]
to a CSV on my machine.
Include standard and activity columns.
Sync first if data looks stale.
Get a Google Sheet (edit in the browser, sync back)
Use the Outreach Magic skill.
Export leads from workspace [WORKSPACE]
to a Google Sheet for review.
Use the standard column set.
Send me the link when ready.
After you edit the Sheet, run:
Use the Outreach Magic skill.
Sync my Google Sheet edits back
to the local database for workspace [WORKSPACE].
See Google Sheets review for the full edit-and-sync flow. Local exports and Sheets review do not count toward webhook limits. Only sequencer webhooks and sync batches do.
Setup details: Smartlead integration.
Smartlead CSV vs Outreach Magic export
| Typical Smartlead CSV column | What Outreach Magic adds or normalizes |
|---|---|
| Name, email | workspace_stage, lead_sentiment, tags across clients |
| Sequence step only | last_event, last_event_at, event_count on a unified timeline |
| Reply in one cell | latest_inbound_preview, total_replies_count across channels |
| Single campaign scope | linkedin_sent_count, external_id, latest_sender from every connected sequencer |
| Static file | Live data your agent can re-export to CSV or Google Sheets on demand |
Every column your agent can export
When you ask your agent for a CSV or Google Sheet, these fields come from your local SQLite database. That is usually more than a raw sequencer CSV: one schema across Smartlead, Instantly, HeyReach, PlusVibe, EmailBison, and other tools you connect.
Identity and contact
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
email | Work email on the lead record | alex@acme.com | Yes |
name | Full name | Alex Morgan | Yes |
linkedin_url | Public LinkedIn profile URL | linkedin.com/in/alexm | Yes |
company | Company name on the lead | Acme Corp | Yes |
title | Job title | VP Sales | Yes |
company_domain | Primary domain for routing and dedup | acme.com | No |
Firmographics and location
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
industry | Industry from enrichment or import | SaaS | Yes |
headcount | Company size band when known | 51-200 | Yes |
location_city | Lead city | Austin | Yes |
location_state | Lead state or region | TX | Yes |
location_country | Lead country | US | Yes |
hq_city, hq_state, hq_country | Company HQ when stored | San Francisco, CA, US | No |
Workspace state (per client)
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
workspace_stage | Pipeline stage in this workspace | replied | Yes |
lead_status | Status from sequencer or agent updates | interested | Yes |
lead_sentiment | Reply tone classification | positive | Yes |
contact_priority | Follow-up priority (numeric) | 2 | Yes |
tags | Segmentation tags (semicolon-separated) | icp;enterprise | Yes |
notes | Free-text notes on the lead | Ask again in Q3 | Yes |
Activity and engagement
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
email_sent_count | Outbound emails sent to this lead | 4 | No |
linkedin_sent_count | LinkedIn touches sent | 2 | No |
total_replies_count | Replies across all channels | 1 | No |
total_contacted_count | Total outbound touches | 6 | No |
last_contacted_at | Last outbound touch time | 2026-06-01T14:22:00Z | No |
last_event | Most recent event type | email_reply | No |
last_event_at | Timestamp of last event | 2026-06-02T09:10:00Z | No |
event_count | Total events stored for this lead | 12 | No |
Attribution and senders
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
latest_sender | Sender account used last | lila@agency.com | No |
latest_sender_platform | Sequencer for the last touch | smartlead | No |
original_source | Where the lead first entered | clay | No |
original_source_detail | Import batch or list name | Q2 ICP scrape | No |
latest_source | Most recent data source | smartlead | No |
external_id | ID from the sequencer | sl_88421 | No |
Messaging previews (full / Sheets standard export)
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
latest_outbound_subject | Subject of last outbound email | Quick question on outbound | No |
latest_outbound_preview | Snippet of last outbound body | Hi Alex, noticed you... | No |
latest_inbound_subject | Subject of last reply | Re: Quick question | No |
latest_inbound_preview | Snippet of last reply body | Thanks, let's chat Thursday | No |
Deliverability
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
email_verification_status | Last verification result | valid | No |
be_platform | Platform that reported a bounce | smartlead | No |
be_bounce_message | Bounce reason from provider | 550 mailbox unavailable | No |
be_last_seen_at | When the bounce was recorded | 2026-05-28T11:00:00Z | No |
Personalization
| Column | What it means | Example | Editable in Sheets? |
|---|---|---|---|
personalized_first_name | Merge field for copy | Alex | Yes |
personalized_company_name | Merge field for copy | Acme | Yes |
Full schema reference: SQLite tables.
Practical tips
- Document filters. Note campaign, status filters, and date in the filename or a README row.
- Protect PII. Share only columns your audience needs.
- Prefer sync over schedules. If you export weekly, try one webhook setup and an agent prompt instead of Smartlead API cron jobs.
Next steps
- Get started: install the skill and connect Smartlead
- Smartlead integration: webhook setup
- Google Sheets review: edit exports and sync back
- Features · Pricing