The Scenario
A sales ops manager has just closed out a Q2 campaign in Emelia and needs every contact from it pulled into a Google Sheet before the Salesforce import can happen. There's a dedup step that has to run against the CRM first — you can't import blindly. The RevOps admin who usually handles this is on leave. The Salesforce import window is Friday.
The handoff note says "just export from Emelia." It does not say how.
The bad version:
- Log into Emelia, navigate to the campaign, find the export option, download a CSV, open it, discover the column headers don't match what Salesforce expects, spend twenty minutes renaming them, save the file, open the Google Sheet that's been set up for this workflow, import the CSV, and realize the encoding is off on three rows with non-ASCII characters.
- Run the Salesforce dedup check against the sheet, find 40 duplicates, manually mark them, go back and remove them from the sheet before the import.
- Do this for every campaign at the end of every quarter.
There are six campaigns that need to be pulled. That's six CSV downloads, six formatting passes, and six imports.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It connects to Emelia and pulls the campaign contact list directly into whatever column layout you specify.
List all contacts in my Emelia campaign 'Cold Q2' and write each contact's email, first name, last name, and company into my Google Sheet starting at row 2
What You Get
- Every contact in the Emelia campaign is fetched and written into the sheet row by row.
- Email lands in one column, first name in another, last name and company follow in the columns you specified or in the order SheetXAI interprets from your prompt.
- The sheet is ready to hand to whoever is running the Salesforce dedup — no CSV import, no encoding fix, no column rename.
What If the Data Is Not Quite Ready
You need contacts from multiple campaigns combined into one sheet
The Q2 outreach ran across three campaigns — Q2-Enterprise, Q2-SMB, and Q2-Partners. You need all three in one sheet for the dedup.
Pull all contacts from my Emelia campaigns 'Q2-Enterprise', 'Q2-SMB', and 'Q2-Partners' and write them into a single sheet — email in column A, first name in column B, last name in column C, company in column D, and which campaign they came from in column E
You only want contacts with a specific status
You want to import only the contacts who replied — not every contact in the campaign.
List all contacts from my Emelia campaign 'Cold Q2' where the status is 'replied' and write their email, first name, last name, and company into my Google Sheet
You need the export deduplicated before it lands in the sheet
The three campaigns had overlapping contact lists. Before writing to the sheet, you want duplicates removed.
Pull contacts from my Emelia campaigns 'Q2-Enterprise', 'Q2-SMB', and 'Q2-Partners', deduplicate by email address, and write the unique contacts to my Google Sheet with columns for email, first name, last name, company, and campaign source
Pull the contacts, flag CRM matches, and format for import in one pass
You have a second tab called 'Salesforce Existing' that has all current CRM emails. You need the export to flag any contact whose email appears in that tab before it goes to Salesforce.
Pull all contacts from my Emelia campaign 'Cold Q2', write them to the 'Emelia Export' tab with email in column A, first name in B, last name in C, company in D — then check each email against the 'Salesforce Existing' tab column A and write 'CRM match' or 'new' in column E
The combined pull-flag-format prompt means the sheet is import-ready before you close it.
Try It
Get the 7-day free trial of SheetXAI and open your Google Sheet set up for the CRM import, then ask it to pull contacts from any Emelia campaign directly into the sheet. For related workflows, see Bulk Enrol Prospects Into an Emelia Campaign or the Emelia hub overview.