The Scenario
You are a CRM specialist. Your VP of Retention asked you this morning to pull all 1,800 contacts in eSputnik's "VIP Customers" segment into Excel by end of day so the analytics team can enrich them with purchase frequency data from a separate database before a loyalty campaign goes out next week.
Except you are working in Google Sheets, not Excel, because the analytics team shared the enrichment template as a Google Sheet.
The slow version of this afternoon:
- You open eSputnik's UI and look for a segment export option
- The built-in export gives you email and a few standard fields, not the external customer ID the analytics team needs for the enrichment join
- You download the CSV, open it, discover the column for external ID is missing entirely
- You go back to eSputnik and try to find where external IDs are stored
- You pull a raw contact export, cross-reference it with the segment list manually in another sheet
- It is 4:30 PM and the enrichment template is still empty.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your intent and calls eSputnik's segment export API with the exact fields the analytics team needs.
Open the SheetXAI sidebar and type:
Export all contacts from eSputnik segment 'VIP Customers' into this sheet — email in column A, first name in B, last name in C, phone in D, and external customer ID in E.
SheetXAI calls eSputnik, retrieves every contact in the segment, and writes the five fields into the sheet. The analytics team has the join key they need.
What You Get
A populated sheet with all 1,800 VIP contacts ready for enrichment:
- Email — the primary identifier for the loyalty campaign send
- First name and last name — for personalisation fields in the campaign
- Phone — for the SMS follow-up track
- External customer ID — the join key the analytics team needs to attach purchase frequency from the other database
The external ID is the critical field here. Without it, the analytics team cannot link the eSputnik segment to the purchase database, and the enrichment does not happen. SheetXAI includes it in the same pull, no second export required.
Once the analytics team fills in the enrichment columns, you can ask SheetXAI to update those fields back in eSputnik, or to import the enriched list into a new segment, in the same session.
What If the Data Is Not Quite Ready
Segment exports rarely come back exactly as expected. SheetXAI handles variations in the same prompt.
When the segment has contacts with no external customer ID
Some contacts in the VIP segment were created manually in eSputnik and never had an external ID assigned.
Export all contacts from eSputnik segment 'VIP Customers' into this sheet — email in A, first name in B, last name in C, phone in D, external customer ID in E. For contacts with no external ID, write "MISSING" in column E so the analytics team knows which records need manual lookup.
When the analytics team wants contacts grouped by acquisition channel
The enrichment template has separate tabs for email-acquired and SMS-acquired customers.
Export all contacts from eSputnik segment 'VIP Customers'. Write email-channel contacts (where the subscription channel is email) to the 'Email VIPs' tab with email in A, first name in B, external ID in C. Write SMS-channel contacts to the 'SMS VIPs' tab with the same structure.
When only a subset of the segment is needed
The analytics team only wants VIPs who joined in the last 6 months.
Export all contacts from eSputnik segment 'VIP Customers' who were created or first subscribed within the last 6 months. Write email in A, first name in B, external customer ID in C into this sheet.
When you need to pull the segment, enrich it, and re-import in one session
You have purchase frequency data in the 'Purchase Data' tab indexed by external customer ID and you want to attach it to each VIP contact and push those enriched records back to eSputnik.
Export all contacts from eSputnik segment 'VIP Customers' into the 'VIP Export' tab — email in A, first name in B, external ID in C. Then look up each external ID in the 'Purchase Data' tab and write the purchase frequency into column D of 'VIP Export'. Finally, update each contact in eSputnik with their purchase frequency as a custom field called "purchase_frequency".
The pattern: export, enrich, re-import, all in one conversation without switching between tools or writing a script.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, then ask it to export any eSputnik segment directly into the sheet. The eSputnik integration is included in every SheetXAI plan. See also how to bulk-add contacts to a segment or the eSputnik in Google Sheets overview.