Skip to content

How to Find Emails in Google Sheets with Tomba (2026)

Learn how to find emails in Google Sheets using the Tomba add-in. Discover step-by-step instructions, bulk search, enrichment, and verification tips.

Abedrahim B Jul 28, 2025 5 min read 1,077 words
How to Find Emails in Google Sheets with Tomba (2026)

How to Find Emails in Google Sheets (2025 Guide)#

This guide shows you how to find emails in Google Sheets with the Tomba add-in, without leaving your spreadsheet. You can search a domain, find the email for each name on a list and verify addresses before you send. The steps below cover installing the add-in, setting up your API key and running each feature. Get the Tomba add-in for Google Sheets. You can also read about the Tomba Google Sheets integration.

Why Use Tomba to Find Emails in Google Sheets?#

Integrating Tomba with Google Sheets offers key benefits:

  • Efficiency – No switching between platforms
  • Bulk Processing – Handle large datasets with ease
  • Email Enrichment – Add verified emails to your lists
  • Real-Time Verification – Ensure email accuracy

Learn more about how Tomba verifies emails. Need to process a file instead of a sheet? See the bulk email finder, or use the Email Finder for a single contact.

Getting Started with the Tomba Add-in#

Install Tomba in Google Sheets#

  1. Open a new/existing spreadsheet
  2. Go to Extensions > Add-ons > Get add-ons
  3. Search for Tomba, click Install
  4. Authorize permissions

Set Up Your API Key#

  • Open Tomba from Extensions > Tomba > Open
  • Paste your API key (found in your Tomba dashboard)
  • Click Login
Tomba API key field in the Google Sheets add-in sidebar
Tomba API key field in the Google Sheets add-in sidebar
  1. Access Add-ons: Click on the Extensions tab in the top menu.
  2. Get Add-ons: Select Add-ons > Get add-ons to open the Google Workspace Marketplace.
  3. Search for Tomba: Enter "Tomba" in the search bar and select the Tomba add-in.
Google Workspace Marketplace search results for Tomba
Google Workspace Marketplace search results for Tomba
  1. Install the Add-in: Click Install and follow the on-screen instructions to authorize the add-in.
Install button for the Tomba add-in in Google Workspace Marketplace
Install button for the Tomba add-in in Google Workspace Marketplace
  1. Provide Permissions: Grant the necessary permissions when prompted to complete the installation.

Setting Up Tomba#

  1. Open Tomba Add-in: Go to Extensions > Tomba > Open.
  2. Enter API Key: Input your secret Tomba API key the first time you use the add-in. You can find this key in your Tomba account dashboard under the API section.
  3. Authenticate: Click Login to authenticate your account and activate the add-in features.

Find Emails from a Single Domain#

You can find emails in Google Sheets by entering a domain:

  1. Go to the Search tab
  2. Enter the domain (e.g., example.com)
  3. Choose how many results you want
  4. Click Find email addresses

Tomba will create a new sheet with:

  • Email
  • First & Last Name
  • Confidence Score
  • Type (Generic or Personal)
  • Department
  • Source Count

Steps to Find Emails#

  1. Select the Search Tab: In the Tomba add-in sidebar, click on the Search tab.
  2. Enter the Domain: Input the domain name in the provided text box.
Search tab of the Tomba add-in with a domain entered
Search tab of the Tomba add-in with a domain entered
  1. Choose the Quantity: Select the number of email addresses you want to retrieve from the drop-down menu.
  2. Find Email Addresses: Click the Find email addresses button.

Understanding the Results#

Tomba will generate a new sheet containing the following information:

Results sheet listing emails, names and confidence scores
Results sheet listing emails, names and confidence scores
  • Email Address: The identified email addresses associated with the domain.
  • First Name: Provided if the email is personal and the contact's first name is publicly available.
  • Last Name: Provided if the email is personal and the contact's last name is publicly available.
  • Confidence Score: A percentage indicating the deliverability likelihood of the email.
  • Type: Indicates whether the email is Personal or Generic.
  • Department: The associated department of the contact, if available.
  • Number of Sources: How many web pages Tomba found the email address on.

Perform Bulk Domain Email Searches#

Want to find emails in Google Sheets across multiple domains?

Steps:#

  1. Select Bulk Option under Search
  2. Add a list of domains in your sheet
  3. Highlight them, click Launch bulk search
  4. Wait for the new results sheet

Note: You can select up to 1,000 domains at a time. If you're retrieving more than 10 emails per domain, consider selecting fewer domains to prevent the Google script from timing out.

Enriching Existing Data with Email Addresses#

If you already have a list of contacts without email addresses, Tomba can enrich this data.

Steps to Enrich Data#

  1. Prepare Your Data: Open a Google Sheet containing your contacts. Include at least the first name, last name, and company or domain name. For optimal results, include all four fields.
  2. Select the Finder Tab: In the Tomba add-in sidebar, click on the Finder tab.
  3. Match Fields: Align the contact fields with your spreadsheet columns.
  4. Check for Headers: If your table has headers, tick the My table has headers box.
  5. Find Email Addresses: Click the Find email addresses button.

Outcome#

Tomba will fill in the missing email addresses and add columns for the confidence score and status:

  • Status Indicators:
    • OK: An email address was found.
    • No results: No email was found for the contact.
    • Parameter(s) missing: Required data is missing from one or more columns.

Verifying a List of Email Addresses#

Ensure your emails are valid before initiating outreach campaigns.

Steps to Verify Emails#

  1. Select the Verifier Tab: In the Tomba add-in sidebar, click on the Verifier tab.
  2. Highlight Emails: Choose the list of email addresses you wish to verify in your spreadsheet.
  3. Verify Email Addresses: Click the Verify email addresses button.

Results#

A new sheet will be created containing:

  • Email Addresses: The emails you selected.
  • Verification Statuses: The deliverability status of each email.
  • Confidence Score: A percentage indicating the likelihood that the email is valid.
  • Number of Sources: The number of sources where the email was found.
  • Full Verification Details: Optional detailed information about the verification process.

Note: You can verify up to 1,000 emails at a time.

Best Practices When You Find Emails in Google Sheets#

  • Monitor API usage
  • Break large jobs into smaller chunks
  • Follow privacy regulations
  • Keep your data updated

Conclusion#

The Tomba Google Sheets Add-in is an invaluable tool for professionals seeking to streamline their email finding and verification processes. By integrating directly with Google Sheets, Tomba enhances your workflow efficiency, allowing you to focus on meaningful outreach rather than tedious data collection. Start leveraging Tomba today to elevate your networking and lead generation efforts.

// start free

See who Tomba finds at any company

Type a company's domain to see its people, their roles and verified work emails, each with the pages it was found on. Free account, no card.

Free plan · No credit card required · GDPR & CCPA

Share
0 clapsEnjoyed it? Give a clap.
Abedrahim B

// about the author

Abedrahim B

CEO

Was this helpful?