Use the Tomba add-on to find, verify and enrich email addresses without leaving Google Sheets. Answers go to new columns or a new sheet, so your own data stays as it is.
Before you start
You need a Tomba account. Create a free account if you don't have one yet. The add-on works in Google Sheets in a web browser on a computer.
Install the add-on
Step 1. In Tomba, open Integrations in the left menu and click the Spreadsheets tab.
Step 2. Under Tomba For Google Sheets, click Get add-on. The Google Workspace Marketplace listing opens.
Step 3. Click Install and allow access. The add-on can reach only the spreadsheet you have open, and it connects to Tomba.
Step 4. Open a spreadsheet, then go to Extensions > Tomba for Sheets > Open. The Tomba sidebar opens.
💡 Tip: You can also install it from Google Sheets. Go to Extensions > Add-ons > Get add-ons and search for Tomba.
Sign in to your Tomba account
Step 1. In the sidebar, click Sign in with Tomba. The sidebar shows a code.
Step 2. Click the button that opens app.tomba.io/device, and sign in to Tomba if asked. If the page asks for the code, type it and click Continue.
Step 3. Click Authorize.
Step 4. Go back to Google Sheets. The sidebar signs in by itself.
You never type your password in Google Sheets.
Run a tool on a column
Step 1. Choose a tool from the menu at the top of the sidebar.
Step 2. Type a column letter, or select a cell and click the icon to use its column. Auto-map can match your columns for you.
Step 3. Check the Credit Breakdown, which shows what the tool costs.
Step 4. Click the tool's button. Keep the sidebar open while it runs.
The sidebar shows the progress and the time left. If it reaches your plan's speed limit, it pauses and then carries on. If you close the sidebar, the run stops, and Tomba offers Resume next time.
What each tool does
Tool | Start from | Button |
Domain Search | One domain, or a column of domains | Search to a new sheet or Search the column |
Email Finder | Names, with a domain or company | Find emails |
LinkedIn Finder | LinkedIn profile links | Find emails |
Author Finder | Links to articles | Find authors |
Phone Finder | Emails, domains or LinkedIn profiles | Find phones |
Phone Validator (a tab in Phone Finder) | Phone numbers | Validate phones |
Email Verifier | A column of emails | Verify emails |
Email Enrichment | A column of emails | Enrich emails |
Company Enrichment | A column of domains | Enrich companies |
Reveal | A sentence, or filters such as industry and size | Run to sheet |
Technology | A column of domains | Detect technologies |
A domain is a company's website name, such as tomba.io. Enrichment adds details to what you already have, such as a person's name or a company's size. Reveal builds a list of companies.
Use formulas
Type =TOMBA_ in any cell to use Tomba as a formula. Open Formulas in the sidebar menu to see them all. A formula costs the same as the tool. Answers are saved for a while, so recalculating the sheet doesn't use credits again.
What it costs
💳 Credits: The add-on uses your Tomba account's credits. Lookups that find nothing aren't charged, except Phone Validator, which uses 1 search credit for every check.
Tool | Cost |
Domain Search | 1 search credit for every 10 results you ask for, only when an address is found |
Email Finder, LinkedIn Finder, Author Finder | 1 search credit |
Email Enrichment, Company Enrichment | 1 search credit |
Email Verifier | 1 verification credit |
Phone Finder | 5 search credits, or 1 when the row has a domain, only when a number is found |
Reveal | 1 search credit per page of up to 50 companies |
Technology | Free, but you need search credits left |
Find phone box, on the tools that have it | 5 more search credits for each result with a phone number |
Common questions
How many rows can I run at once?
Up to 1,000 rows per run, and up to 10,000 companies per Reveal search. For a longer list, run the tool again from the next row. If the results went to a new sheet, the last run's summary offers Continue from row and the row number.
Will Tomba overwrite my data?
No. Answers go to new columns or a new sheet, and your own columns stay as they are.
Does it work on my phone?
No. The add-on works only in Google Sheets in a web browser on a computer.
Can my team use it?
Yes. Team members share your credits and use the add-on with their own Google accounts.
Related articles