The Scenario
You are a growth marketer at an online retailer. It is 2 PM on a Tuesday and the flash sale email goes out at 6 PM today.
Your sign-up form collected 2,400 new subscribers over the last four days. They are sitting in an Excel workbook on the "New Signups" tab: email in column A, first name in B, last name in C, phone in D. Not one of them is in eSputnik yet.
The slow version of this afternoon:
- You open eSputnik's import UI and read the column naming requirements
- You go back to the workbook and rename headers to match
- You save as CSV from Excel desktop, which forces you to pick a delimiter and encoding
- You upload the CSV and eSputnik flags 140 rows as duplicates from a previous import you did not know about
- You re-download the flagged list, cross-reference it manually in another workbook, fix it, re-export, re-upload
- The campaign goes out at 6 PM to the existing list only because you ran out of time
- 2,400 people who signed up specifically for this sale do not get the email.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the data and calls eSputnik's import API for you, with deduplication handled automatically.
Open the SheetXAI sidebar and type:
Bulk-add all 2,400 contacts from my Excel 'New Signups' tab to eSputnik using email in column A and first name in column B as the deduplication key. Also include last name in column C and phone in column D. Write the import session ID into cell F1.
SheetXAI reads every row in the tab, maps the columns, calls eSputnik's import API, and writes the session ID back to F1. When F1 has a value, the import is complete.
What You Get
A confirmed import with 2,400 contacts in eSputnik and a record in the workbook:
- All unique contacts added — anyone already in eSputnik on that email address is skipped
- Column mapping handled — no header renaming, no CSV formatting step
- Session ID in cell F1 — your confirmation that the batch completed
- Error rows surfaced — any rows that failed get flagged per row, not lost in a total count
The session ID is your audit trail. If the campaign send has issues, you can pull the session ID and look up exactly which contacts were in this import batch.
What If the Data Is Not Quite Ready
Most sign-up exports from form platforms have rough edges. SheetXAI handles the cleanup and the import in the same prompt.
When emails have inconsistent formatting
Some rows have trailing spaces or mixed case. eSputnik will treat "User@Example.com" and "user@example.com" as different contacts.
Normalize all email addresses in column A of the 'New Signups' tab to lowercase and trim whitespace. Then import all rows into eSputnik with first name in B, last name in C, phone in D, deduplicate on the normalized email, and write the session ID into F1.
When some rows are missing phone numbers
Your form made phone optional, so column D is blank for a few hundred rows. You want to import everyone but without errors on the blank cells.
Import all rows from the 'New Signups' tab into eSputnik. For rows where column D is blank, import the contact without a phone number. For rows with a value in D, include the phone field. Deduplicate on email and write the session ID into F1.
When the workbook has duplicate rows from a form glitch
The sign-up form double-fired for about 60 submissions, so some emails appear twice in the workbook.
Deduplicate rows in the 'New Signups' tab by email address in column A, keeping the first occurrence. Then import the deduplicated list into eSputnik with email in A, first name in B, last name in C, phone in D. Write the import session ID into F1.
When you also need to add everyone to a specific segment after import
The flash sale has a dedicated segment in eSputnik. You want the import and the segment add to happen together.
Import all rows from the 'New Signups' tab into eSputnik — email in A, first name in B, last name in C, phone in D — deduplicate on email. After the import, add all successfully imported contacts to eSputnik segment ID 6610. Write the import session ID into F1 and the segment add confirmation into F2.
The pattern: instead of importing first and then handling the segment separately, you ask for both operations in one prompt. SheetXAI handles the sequencing.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with subscriber data, then ask it to import the contacts into eSputnik. The eSputnik integration is included in every SheetXAI plan. See also how to bulk-add contacts to a segment in Excel or the eSputnik in Excel overview.