LinkedIn URL to Email Address in 3 Steps: A Google Sheets Add-on Walkthrough

This is a practical walkthrough of the LinkedIn Enricher Google Sheets add-on. If you’ve never used it before and want to know exactly what happens from install to enriched contacts, this is the post for you.

Three steps: install, configure, enrich. Here’s what each step actually looks like.

Before You Start: What You’ll Need

A Google account with access to Google Sheets
A spreadsheet with at least one column of LinkedIn profile URLs
API credentials from Datagma, LeadMagic, or both (free trial credits available on both platforms)

The add-on itself is free to install. You pay per lookup to whichever enrichment provider(s) you use.

Step 1 — Install the Add-on

Open any Google Sheet
Go to Extensions → Add-ons → Get add-ons
Search for LinkedIn Enricher (by Makeinfo)
Click Install and grant the required permissions

The permissions requested are:

Read and edit your spreadsheets (to read URLs and write results)
Connect to external services (to call enrichment APIs)
Store user properties (to save your API keys per user)

After installation, the add-on appears under Extensions → LinkedIn Enricher → Open.

Step 2 — Configure Your API Keys

Open the add-on. You’ll see two tabs: Enrich and Settings.

Go to Settings first.

You’ll see provider cards for Datagma and LeadMagic. For each provider you want to use:

Enter your API key in the input field
Click Save
Click Test Connection

If the test passes, you’ll see a green confirmation. If it fails, double-check the key — copy-paste errors are the most common issue.

Key storage: Keys are saved in your Google account’s PropertiesService, scoped to your user. They’re not stored on any external server. When the add-on sends a request to the enrichment API, your key is used in the API call directly.

You don’t need both providers. One is sufficient. But if you have keys for both, enabling fallback significantly improves hit rates — the second provider catches profiles the first one missed.

Step 3 — Enrich Your LinkedIn URLs

Go to the Enrich tab.

Select Your Column

Use the dropdown to select the column that contains your LinkedIn profile URLs. The add-on reads your current sheet’s headers and lets you choose by column name.

Important: URLs must be individual profile URLs in linkedin.com/in/... format. Company pages, post URLs, and search result URLs won’t return results.

Choose Your Primary Provider

Select which provider to try first. This is your “primary.” If you have both keys set up, the other provider will automatically act as fallback for rows your primary doesn’t find.

General guidance:

US-heavy lists: Datagma first
EMEA-heavy lists: LeadMagic first
Mixed lists: Test a sample of 50 rows with each primary to see which performs better

Options

Skip already-enriched rows: When checked, the add-on skips any row that already has an email in the result column. Use this on re-runs to avoid paying for lookups you’ve already done.

Click Enrich

The progress bar fills as each row is processed. You’ll see a live count of rows completed, emails found, and rows where nothing was returned.

Processing speed is roughly 100–150 rows per minute. A 300-row list typically completes in 2–4 minutes.

What the Results Look Like

After the run, the add-on writes these columns into your sheet (to the right of your URL column, or into designated output columns if configured):

Column	Content
Email	Work email address, or blank if not found
Phone	Phone number if returned by the provider (lower hit rate than email)
Provider	”Datagma” or “LeadMagic” — which provider returned this result
Enriched At	ISO timestamp of when this row was processed

Rows where neither provider found data will have blank email/phone fields. These are not errors — they simply mean the profile wasn’t in either provider’s database at the time of the lookup.

Reading Your Results

After your first run, here’s how to evaluate what came back:

Sort by Email column. This gives you a clean split between found and not-found rows.

Check the Provider column. If most results came from your primary provider, your fallback added modest incremental value. If a significant percentage came from fallback, both providers are genuinely complementary on your list.

Review a sample. Spot-check 10–15 of the returned emails against what you’d expect. Look for obvious formatting issues ([email protected] vs. [email protected]) — consistency suggests the provider has solid data on your list’s industry.

Segment not-found rows separately. Copy them to a new tab or add a label column. These can be re-enriched in 60–90 days, or handled via LinkedIn outreach.

Typical First-Run Results by List Type

List composition	Expected email hit rate
US SaaS, Director level and above	68–80%
US mixed industries, all seniority	58–72%
EMEA enterprise	52–65%
SMB founders and solo operators	55–68%
Recruiters sourcing candidates	60–72%

These are ranges based on aggregate performance. Your specific list may fall above or below depending on how well your profiles are represented in each provider’s database.

After Enrichment: Next Steps

Verify before sending. Enrichment returns what was indexed — not what’s necessarily active today. If your list is older than 30 days or contains frequent job-changers (entry-to-mid level), verify emails before loading them into any outreach tool.

Tag your source. Add a column noting that these emails came from LinkedIn enrichment and when. This helps track data freshness when you revisit the list.

Re-enrich not-found rows. Schedule a reminder to re-run not-found rows in 2–3 months. Providers continuously update their databases, and some profiles that return nothing today will have results then.

For how the dual-provider fallback strategy works in more detail, see Why Two Providers Beat One: The Fallback Strategy →

Try the LinkedIn Enricher on your own list. LinkedIn Profile Enricher for Google Sheets — install free →