Skip to main content

How to Find Emails Directly in Google Sheets

Find Verified Emails for Your Contacts, Right Inside Google Sheets

Christian Porcher avatar
Written by Christian Porcher
Updated over 2 weeks ago

The Scalelist for Google Sheets add-on brings our powerful B2B enrichment engine directly into your workflow, allowing you to find verified work emails without ever leaving your spreadsheet.

This guide will walk you through setting up and using the add-on step-by-step.


βœ… Before You Start: What You'll Need

To use the add-on, please make sure you have the following ready:

  1. A Scalelist Account: You must be logged into your Scalelist account to use the add-on. You can create a free account which includes free credits to try the feature.

  2. Available Enrichment Credits: Finding emails consumes credits from your monthly allowance (1 credit per email found).

  3. A Formatted Google Sheet: Your spreadsheet must have clear column headers. For the best results, you will need columns for:

    • First Name

    • Last Name

    • Company Name or Company Website (Domain)


πŸ’‘ Pro Tip: Before running a large list, we recommend testing the add-on on a small sample of 10-20 contacts to ensure your columns are mapped correctly and everything is working as expected.
​


βš™οΈ Step-by-Step Guide: How to Find Emails

Step 1: Install the Add-on

First, you need to install the Scalelist add-on from the Google Workspace Marketplace.

  • Click here to visit the Marketplace and find the Scalelist Add-on.

  • Install the Add-on

  • You will be asked to grant permission for the add-on to access and modify your spreadsheets.

Step 2: Launch the Scalelist Sidebar

Once installed, open the Google Sheet that contains the prospect list you want to enrich.

  • In the Google Sheets menu, navigate to Extensions β†’ Scalelist β†’ Open.

  • This will open the Scalelist sidebar on the right-hand side of your sheet. You will be prompted to Sign in to your Scalelist account.

Step 3: Map Your Columns

This is the most important step. You need to tell Scalelist which columns in your sheet contain the data we need for enrichment.

  • In the Scalelist sidebar, you will see fields for "Column of First Name," "Column of Last Name," and "Column of Company Name" / "Column of Company Website."

  • For each field, select the corresponding column letter from your spreadsheet (e.g., A, B, C).

Step 4: Start Enriching

Once your columns are mapped, you're ready to go.

  • Ensure the "My table has headers" box is checked if your sheet has a header row.

  • Click the "Search Emails" button.

  • The add-on will begin processing your list. You will see a progress bar in the sidebar. You can continue to work in your sheet while the enrichment runs.

Step 5: Review Your Results

When the process is complete, Scalelist will automatically add three new columns to your spreadsheet with the results.

  • Email: The verified work email address, if found.

  • Status: The verification status of the found email (e.g., "Valid," "Risky").

  • Result: A simple confirmation for each row (e.g., "Email Found," "Not Found").


Understanding Credit Consumption

The add-on uses the same simple credit system as the Scalelist web app.

  • 1 credit is used for each email successfully found.

  • The email verification status is included in the credit cost.

  • You are not charged any credits for contacts where we cannot find an email.

Did this answer your question?