Google Sheets Add-on Email Finder

Easily extract emails from a Google Sheets spreadsheet with Tomba. Streamline your contact management and outreach efforts seamlessly

Written by Mohamed Ben rebia

Updated about a Jul 24, 2024

Tomba for Google Sheets makes it possible to add email addresses from existing data or find them from a domain directly in your spreadsheet.

How to install the Tomba for Google Sheets Add-on

Go to the Tomba for Google Sheets page and click the Get the Add-on button.
Click the Install button.
Click Allow to give permissions to Tomba.
Create a new Google Sheets file online and open the Tomba Add-on. To do this simply select the Add-ons tab -> Tomba for Sheets -> Open.
Now you’ll see a panel on the right side of the page where you’ll be able to perform a Domain Search or an Email Finder task directly in your spreadsheet.

When performing the first search, the Add-on will ask you to enter your personal API key and API Secret to associate the add-on with your Tomba account. The API key can be found in the API section of your account.

Find email addresses from a domain

Select the Search tab and enter the domain in the text box.
Choose the number of email addresses you’d like to get for that domain from the drop-down menu and hit the Find email addresses button. Remember: you’ll need to enter your secret Tomba API key the first time you use the Add-on.
Tomba will create a new sheet and provide you all the available email addresses directly in it.

Tomba will populate the table with the following information:

Email address
First name: if the email is personal, and the name of the contact is publicly available, the first name will be provided
Last name: if the email is personal, and the name of the contact is publicly available, the last name will be provided
Confidence score: an indicator for the deliverability of the email (in %).
Type: an email can be Personal or Generic.
Department: the department associated to the email.
Number of sources: the number of pages of the web where Tomba found that email address.

Perform a Bulk Domain Search

Select Bulk in the Search tab.
Select a list of domains in your spreadsheet and click the red "Launch the bulk search" button when you are ready

When doing a bulk domain search, you can select up to 1000 domains at a time. If you select to find more than 10 emails per domain, we recommend selecting less to ensure the Google script does not time out.

Enrich your existing data with email addresses

Tomba for Google Sheets can enrich your existing data by finding email addresses using first name, last name, and company website or company name.

Open a Google Sheet file with your contacts data. This data should at least contain a First Name, Last Name and Company or Domain Name. For better results, we suggest adding all 4 fields.
Select the Finder tab.
Match the contact fields to your corresponding columns.
Check the My table has headers box if needed.
Click on "Find email addresses".

Tomba will automatically complete the sheet with the email addresses found for each person. It will also add a column for the confidence score, and a column for the status.

The status can be OK if an email has been found, no results if no email was found, or it can indicate an error message, such as Parameter(s) missing, if the Email Finder could not be processed. When parameters are missing, this means that data is missing in one of the mandatory colums.

Verify a list of email addresses

You can also verify a list of email addresses to get the deliverability status of each email.

Select the Verifier add-on tab.
Select a list of emails in your spreadsheet, and click on "Verify email addresses"

A new tab will be created with the emails and the verification statuses. There will also be a column for the confidence score, and one for the number of sources where the email is found. You can also choose to include the full verification details.

You can select a list of up to 1000 emails at a time.