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 a Google Sheet, 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 sheet and rename headers to match
- You export as CSV and upload
- 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, 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 spreadsheet that reads the data and calls eSputnik's import API for you, with deduplication handled automatically.
Open the SheetXAI sidebar and type:
Import all rows from my 'New Signups' sheet into eSputnik — email in column A, first name in B, last name in C, phone in D — deduplicate on email and write the import session ID into cell F1.
SheetXAI reads every row, maps the columns to eSputnik's contact fields, calls the import API with deduplication enabled, and writes the session ID back to F1. When F1 has a value, you know the import completed.
What You Get
A confirmed import with 2,400 contacts in eSputnik and a record in the sheet:
- All unique contacts added — anyone already in eSputnik is skipped, not duplicated
- Column mapping done for you — no header renaming required
- Session ID in cell F1 — your confirmation that the import ran
- Errors surfaced inline — any rows that could not be imported get flagged, not silently dropped
The session ID is not just for logging. If something goes wrong with the campaign send, you can pull the session ID and look up exactly which contacts were in that batch. That is the audit trail your ops team will ask for.
You can also ask SheetXAI to write a second column next to each row indicating whether that contact was imported fresh or was already in the system. Useful for reporting to the team on net new reach.
What If the Data Is Not Quite Ready
Most sign-up exports are messier than a clean four-column sheet. SheetXAI handles the cleanup and the import in the same prompt.
When emails have inconsistent formatting
Some rows have leading or trailing spaces. Some entries are uppercase. eSputnik will treat "User@Example.com" and "user@example.com" as different contacts.
Normalize all email addresses in column A to lowercase and trim any 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 only send SMS to those with a number.
Import all rows from this sheet into eSputnik. For rows where column D is blank, import the contact without a phone number. For rows where column D has a value, include the phone field. Deduplicate on email and write the session ID into F1.
When the sheet has duplicate rows from a form glitch
The sign-up form double-fired for about 60 submissions. You have duplicate email addresses in the sheet before the eSputnik import even happens.
Deduplicate rows in this sheet by email address, keeping the first occurrence of each. Then import the deduplicated list into eSputnik with email in A, first name in B, last name in C, phone in D, and write the import session ID into F1.
When you also need to add everyone to a specific segment
The flash sale has a dedicated segment in eSputnik. You want the import and the segment add to happen together.
Import all rows from this sheet 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 add separately, you ask for both in one prompt. SheetXAI handles the sequencing.
Try It
Get the 7-day free trial of SheetXAI and open any sheet 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 specific segment or the eSputnik in Google Sheets overview.