The Scenario
You are a campaign manager at a DTC brand. The re-engagement push goes out in 72 hours.
You have a Google Sheet of 600 high-value churned customers who stopped purchasing more than six months ago. Your retention team identified them through a purchase analysis and exported them to the sheet. They all need to be in eSputnik's "Win-Back Targets" static segment before the campaign builder can configure the send.
The bad version of this task:
- You open eSputnik and look for the "add contacts to segment" function
- The UI lets you add contacts one at a time, or upload a CSV, but the CSV upload for segments expects contact IDs, not emails
- You have emails in the sheet, not eSputnik contact IDs
- You run a contact lookup to get IDs, which is a separate export step
- You cross-reference the two files, assemble the ID list, upload it
- You get an error on 85 rows because some contacts are not in eSputnik yet and need to be imported first.
- Now you have two tasks instead of one and 48 hours left.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the sheet and handles the contact lookup, import if needed, and segment add as a single operation.
Open the SheetXAI sidebar and type:
Add all contact IDs in column A of my 'Win-Back' sheet to eSputnik static segment ID 8821.
Or, if you have emails instead of IDs:
Add all email addresses in column A of my 'Win-Back' sheet to eSputnik static segment 'Win-Back Targets'. If any email does not have an existing contact in eSputnik, create the contact first and then add them to the segment.
SheetXAI resolves the IDs, creates missing contacts, adds everyone to the segment, and writes the result back to the sheet.
What You Get
600 churned customers in the "Win-Back Targets" segment, confirmed and ready for the campaign builder:
- All contacts added — including any who were not yet in eSputnik as contacts
- No duplicate segment entries — eSputnik deduplicates segment membership automatically
- Row-level confirmation in column B — "added" for each contact, or the specific error for any that failed
- Segment ready before the 72-hour deadline — the campaign builder is not waiting on you
The "create if missing" pattern matters. If 85 of your 600 churned customers are not in eSputnik because they came from a third-party data source, a naive segment add will fail on those 85. SheetXAI handles both cases, import and segment add, in the right order.
What If the Data Is Not Quite Ready
Re-engagement lists from analytics exports have predictable rough edges. SheetXAI handles them in the same prompt.
When the sheet has email addresses and you need eSputnik contact IDs
Your analytics team gave you emails. The segment add requires IDs.
For each email in column A of this sheet, look up the eSputnik contact ID and write it into column B. Then add all contacts with found IDs to static segment ID 8821. For emails with no matching eSputnik contact, write "NOT FOUND" in column B.
When you want to exclude contacts who are already in the segment
Running the add a second time should not cause errors, but you want a clean confirmation of net new additions.
Add all email addresses in column A to eSputnik segment 'Win-Back Targets'. For each row, check if the contact is already in the segment. Write "already member" or "added" into column B. Report the net new addition count in cell C1.
When the sheet contains contacts across multiple re-engagement tiers
Column B has a tier label: "High Value," "Medium Value," "Low Value." High Value should go into one segment, the rest into another.
For each row where column B is 'High Value,' add the email in column A to eSputnik segment ID 8821. For all other rows, add the email to segment ID 8822. Write the segment destination and result into column C for each row.
When you want to import, add to segment, and send the campaign in one session
The campaign is ready to go. You want to handle the segment population and trigger the first send in the same prompt.
Add all 600 email addresses from column A of the 'Win-Back' sheet to eSputnik segment 'Win-Back Targets'. After confirming the segment is populated, send eSputnik prepared message template ID 9044 to all contacts in the 'Win-Back Targets' segment. Write the send count into cell B1.
The pattern: one prompt covers the data work and the action. The campaign manager is not the bottleneck.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a list of contacts you need to organize in eSputnik, then ask it to add them to the right segment. The eSputnik integration is included in every SheetXAI plan. See also how to bulk-import contacts into eSputnik or the eSputnik in Google Sheets overview.