The Scenario
Your team just got back from a trade show. You've got 150 business cards scanned and entered into a Google Sheet — 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 sheet, read row 2, open Tomba, fill in first name, last name, email, company, click Save.
- Go back to the sheet, 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 Google Sheet. 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 sheet so you have a record of what was created.
Here's the prompt to use:
Create a Tomba lead for every row in my sheet using the first name in column A, last name in column B, and email in column C, then write the returned lead ID into column D.
What You Get
After running this prompt:
- A Tomba lead is created for each contact in the sheet.
- Column D contains the Tomba lead ID for every successfully created record.
- Rows where the email in column C is blank are skipped and noted.
- Any creation failure (duplicate email, validation error) is surfaced in column E 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 columns A, B, and C, and lowercase all emails. Then create a Tomba lead for each row using those cleaned values and write the lead ID into column D.
You need to skip rows that already have a lead ID
You're running a second pass — maybe the first one timed out at row 80. You don't want to create duplicates for the rows that already succeeded.
For every row where column D is blank, create a Tomba lead using the first name in column A, last name in column B, and email in column C, then write the returned lead ID into column D. Skip rows where column D already has a value.
The company name needs to go along with the lead
The sheet has a Company column (column E) and you want it included in the Tomba lead record.
Create a Tomba lead for every row in my sheet using the first name in column A, last name in column B, email in column C, and company in column E. Write the returned lead ID into column F.
Full pipeline: validate emails, filter by company size, create leads, and log errors in one shot
Check each email in column C against Tomba's domain validation. Skip any row where the domain is webmail or disposable and write "skipped: free email" into column E. For the remaining rows, create a Tomba lead using columns A, B, and C, write the lead ID into column D, and write any creation errors into column E.
One prompt handles the gatekeeping and the creation.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet 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 sheet, or the full Tomba integration overview.