Table of Contents

    Do you want to quickly enrich your email data with additional information? The ENRICH_EMAIL formula in Google Sheets can help you easily retrieve a variety of information about an email address in just a few seconds. Using Explorium’s API, this powerful formula allows you to access data such as the email owner’s first and last name, company, job title, and LinkedIn profile. Plus, Explorium offers a wide range of data sources and provides up to 500 free enrichments per month. In this post, we’ll show you how to use the ENRICH_EMAIL formula and give you a brief overview of the types of data that Explorium offers.

    See the Formula in Action

    A Simple Way to Enhance Your Email Data

    With just a simple formula, you can transform an email address into a wealth of information. The formula is “=ENRICH_EMAIL(A2)”, with the email entered in cell A2. This will automatically fill in data for the following columns: First Name, Last Name, Company, Job Title, Professional Email, and LinkedIn Profile.

    How to Use the Formula

    To use the formula, you have two options:

    Option 1: Copy the template spreadsheet (easier)

    1. Enter this Google spreadsheet – https://docs.google.com/spreadsheets/d/1rdSyOVto27EiVXKo3CKzgo6wWyEkfpBTchIEx-iNL6M/edit?usp=sharing.
    2. Click “File” then “Make a copy”.
    3. This will create a copy of the template spreadsheet with the formula in your Google Sheets.
    4. In the “Settings” worksheet, paste your API key into cell B1.

    Option 2: Manually copy the code

    /**
 * Find email information by email address using Explorium API
 *
 * @param {string} email Email address of the prospect
 * @return if found the First name, Last name, Company name, Job title, Professional email and LinkedIn profile URL of the prospect
 * @customfunction
 */
function ENRICH_EMAIL(email) {
    // Define here the fields you want to take from Explorium
    // You can view all available Contacts for professional Individuals fields at https://developers.explorium.ai/reference/individual-contact-data-contacts-for-professional-individuals
    const EXPLORIUM_FIELDS_e = [
        "First name", "Last name", "Company name", "Job title", "Professional email", "LinkedIn profile URL"
    ];

    // Send HTTP request to Firmographics Explorium API - https://developers.explorium.ai/reference/individual-contact-data-contacts-for-professional-individuals
    const response = UrlFetchApp.fetch("https://app.explorium.ai/api/bundle/v1/enrich/contacts-for-professionals", {
        method: "post",
        payload: JSON.stringify([{
            "email": email
        }]),
        headers: {
            "Content-Type": "application/json",
            "x-explorium-ref": "gsheets_formula_enrich_email",
            "API_KEY": readExploriumAPIKey()
        },
        muteHttpExceptions: true
    });

    const responseCode = response.getResponseCode();
    const responseJson = JSON.parse(response);

    if (responseCode !== 200)
        return responseJson.message;

    const signals = responseJson[0];
    const relevantFields = EXPLORIUM_FIELDS_e.map(field => signals[field]);

    return [relevantFields];
}

// Reads Explorium API Key from Settings sheet, B1 cell
function readExploriumAPIKey() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var worksheet = spreadsheet.getSheetByName("Settings");
  var cell = worksheet.getRange("B1");
  return cell.getValue();
}
    1. Copy the above code
    2. Create or enter an existing spreadsheet
    3. Go to “Extensions” then “Apps Scripts”.
    4. Paste the code into the editor.
    5. Click the save icon.
    6. Create a worksheet named “Settings” with the first cell (A1) labeled “API Key”.
    7. Paste your API key into cell B1.

    Maximize Your Data’s Potential with Explorium

    In this post, we introduced you to the ENRICH_EMAIL formula in Google Sheets, which allows you to quickly access a wealth of information about any email address. But that’s not all – Explorium has a vast catalog of data beyond just email data, including company firmographics data, tech stack data, growth indicators, web presence data, points of interest data, and much more! With Explorium, you can easily enrich your data and gain valuable insights. Be sure to browse Explorium’s full data catalog and access its API documentation to learn more. If you’re interested in using Explorium for your own data enrichment needs, don’t hesitate to sign up for a free account. We hope this post has been helpful, and we look forward to helping you with all your data enrichment needs.