The Scenario
You are an SDR manager. Your team just finished verifying 600 contacts for the Q2 Outreach campaign. They are sitting in a Google Sheet, one row per contact, with columns for email, first name, company, and website.
The campaign in Instantly is ready to go. Launch is tomorrow morning.
The slow version:
- Open Instantly's lead import UI
- Export the sheet as a CSV
- Upload the CSV, map the columns to Instantly's expected fields
- Realize the column order does not match, re-export, re-upload
- Confirm the import, check for errors, dig through the error log for the twelve rows that failed
- You are still doing this at 11 PM.
The fast version is one prompt and the sheet stays open in your browser.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the data and pushes it directly into Instantly so you do not have to touch the import UI.
Open the SheetXAI sidebar and type:
Add every row from this sheet as a lead to Instantly campaign 'Q2 Outreach' — column A is email, B is first name, C is company, D is website — skip any row where column A is blank, and write 'added' or the error into column E.
SheetXAI reads the sheet from top to bottom, calls the Instantly API for each row, skips blanks, and writes a result into column E for every row. When it is done, you have a column telling you exactly what happened to each contact.
What You Get
Six hundred rows processed without opening the Instantly import UI:
- Column E status — "added" for every lead that went in cleanly
- Error flags — rows with malformed email addresses or duplicate entries get a clear label, not a silent failure
- Skipped rows noted — any blank email row is flagged in column E so you can review it
- Campaign populated — all valid leads are live in 'Q2 Outreach' and ready to send
The column E audit trail is the part that saves you. When your team asks tomorrow morning why a contact is not in the campaign, the answer is already in the sheet.
If you need to push to a second campaign, give SheetXAI the same prompt with a different campaign name. No re-export, no re-mapping.
What If the Data Is Not Quite Ready
Lead lists from verification tools are rarely in the exact shape Instantly expects. SheetXAI handles the cleanup and the import in the same prompt.
When some emails have inconsistent casing or extra whitespace
You scraped and verified from multiple sources and the email column has "John@Company.com" next to "john@company.com" next to " jane@company.com".
Normalize all emails in column A to lowercase and trim whitespace. Then add every row as a lead to Instantly campaign 'Q2 Outreach' using columns A through D, and write the result into column E.
When some rows have missing first names
The first name column is blank for about fifty rows because the scraper did not find them. You do not want to send a campaign that opens with "Hi ,"
For any row in this sheet where column B is blank, write "Unknown" into column B before importing. Then add all rows as leads to Instantly campaign 'Q2 Outreach' and write results into column E.
When you only want contacts from specific companies
Your campaign is targeted at SaaS companies but the list has mixed verticals.
Filter to rows where column C contains any of these company domain keywords: 'software', 'platform', 'cloud', 'app', 'tech'. Add only those rows as leads to Instantly campaign 'Q2 Outreach' and write 'added' or 'filtered' into column E.
When you need to split the list across two campaigns by domain
Enterprise contacts go to the 'Enterprise Q2' campaign, SMB contacts go to 'SMB Q2'. The difference is the domain extension in the email.
For each row in this sheet, if the email in column A has a .com or .io domain, add the lead to Instantly campaign 'Enterprise Q2'. Otherwise add them to 'SMB Q2'. Write the assigned campaign name and result into column E.
The pattern: instead of cleaning the list first and then importing, you describe the condition and the destination in one prompt. SheetXAI handles both inline.
Try It
Get the 7-day free trial of SheetXAI and open any verified contact sheet, then ask it to push the leads to your Instantly campaign. The Instantly integration is included in every SheetXAI plan. For related workflows, see how to verify emails before importing or the Instantly in Google Sheets overview.