Copy page

Tutorials

LinkedIn Finder

Find the professional email behind a LinkedIn profile URL. You have LinkedIn profile URLs (from Sales Navigator exports or event lists) and need the work email.

Credits: 1 search credit when found. Lookups that find nothing cost nothing. See Pricing and limits.

Inputs and options

Input: url (LinkedIn profile URL)

This tool has no options.

Try one value

Code
CALL TOMBA.core.linkedin_finder('https://www.linkedin.com/in/jane-doe');

The call returns the result as a VARIANT (example values, shortened):

Code
{
    "status": "found",
    "credits": 1,
    "results": [
        {
            "EMAIL": "jane.doe@acme.com",
            "FULL_NAME": "Jane Doe",
            "POSITION": "Head of Sales",
            "COMPANY": "Acme"
        }
    ]
}

status is found, not_found, invalid or error; results holds the output columns and data the complete Tomba record.

Run it over a table

Create a small table to try it (or use one of yours, after granting the app access):

Code
CREATE OR REPLACE TABLE my_db.public.prospects (LINKEDIN_URL STRING);
INSERT INTO my_db.public.prospects VALUES
    ('https://www.linkedin.com/in/jane-doe');
GRANT SELECT ON TABLE my_db.public.prospects TO APPLICATION TOMBA;

Run the tool, then read the results:

Code
CALL TOMBA.core.find_emails_from_linkedin('MY_DB.PUBLIC.PROSPECTS', 'LINKEDIN_URL', 'PROSPECTS_LINKEDIN_FINDER', 100);

SELECT INPUT_URL, EMAIL, FULL_NAME, POSITION, COMPANY, VERIFICATION_STATUS
  FROM TOMBA.results.PROSPECTS_LINKEDIN_FINDER
 WHERE lookup_status = 'found';

Signature: find_emails_from_linkedin(input_table STRING, url_column STRING, output_table STRING, max_rows INT DEFAULT 100000)

Output columns

Each row starts with INPUT_<name> columns (your values, unchanged) and then has:

EMAIL, SCORE, VERIFICATION_STATUS, FIRST_NAME, LAST_NAME, FULL_NAME, POSITION, DEPARTMENT, COMPANY, WEBSITE_URL, COUNTRY, LINKEDIN, TWITTER, EMAIL_TYPE, ACCEPT_ALL, PHONE_NUMBER, followed by the common columns (LOOKUP_STATUS, CREDITS, DATA, SOURCE, …).

Tips

• Use the public profile URL (https://www.linkedin.com/in/...).

Related

• Email Finder
• Phone Finder