The Scenario
Your team just got back from a trade show. You've got 150 business cards scanned and entered into an Excel workbook — first name in column A, last name in column B, email in column C, company in column D. The follow-up campaign is supposed to launch Thursday. It's Tuesday.
The contacts need to be in Tomba as leads before anyone can build the sequence. You open Tomba's UI and see the "Add Lead" form. It takes one contact at a time.
The bad version:
- Open the workbook, read row 2, open Tomba, fill in first name, last name, email, company, click Save.
- Go back to the workbook, read row 3, go back to Tomba, fill in the form again.
- Make it through 20 rows before you start second-guessing whether row 14's email was what you thought it was.
- Realize at row 40 that you've been entering the company name in the wrong field for the last eight rows.
One hundred and fifty contacts. One form submission at a time. Thursday is not that far away.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the contact data you already have and pushes it to Tomba's leads API row by row — then writes the returned lead IDs back into the workbook so you have a record of what was created.
Here's the prompt to use:
Take all 150 contacts in my Excel table (Name, Email, Company) and add them as new leads in Tomba, writing the Tomba lead ID back into the LeadID column.
What You Get
After running this prompt:
- A Tomba lead is created for each contact in the workbook.
- The LeadID column contains the Tomba lead ID for every successfully created record.
- Rows where the email is blank are skipped and noted.
- Any creation failure (duplicate email, validation error) is surfaced in an adjacent column so you can address it without losing the whole batch.
What If the Data Is Not Quite Ready
Some emails have typos or trailing spaces
Scanned business cards are not clean data. "john @acme.com" with a space in the middle will fail on Tomba's side.
Before creating any leads, trim whitespace from every value in the Name, Email, and Company columns, and lowercase all emails. Then create a Tomba lead for each row using those cleaned values and write the lead ID into the LeadID column.
You need to skip rows that already have a lead ID
You're running a second pass — maybe the first one timed out halfway through. You don't want to create duplicates for the rows that already succeeded.
For every row where the LeadID column is blank, create a Tomba lead using the first name, last name, and email from the corresponding columns, then write the returned lead ID into the LeadID column. Skip rows where LeadID already has a value.
The company name needs to go along with the lead
The workbook has a Company column and you want it included in the Tomba lead record.
Create a Tomba lead for every row in my workbook using the first name in column A, last name in column B, email in column C, and company in column D. Write the returned lead ID into column E.
Full pipeline: validate emails, filter by company size, create leads, and log errors in one shot
Check each email in the Email column against Tomba's domain validation. Skip any row where the domain is webmail or disposable and write "skipped: free email" into the Status column. For the remaining rows, create a Tomba lead using the name and email columns, write the lead ID into LeadID, and write any creation errors into the Status column.
One prompt handles the gatekeeping and the creation.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of contacts — names, emails, company names — and ask it to push them all into Tomba as leads in one go. For a related workflow, see exporting Tomba leads back into a workbook, or the full Tomba integration overview.