Open menu

How to Find Company Email Addresses in Google Sheets (From a List of Names)

How to Find Company Email Addresses in Google Sheets (From a List of Names)

To find company email addresses in Google Sheets, run a company-name-to-email add-on on your company column. Back in 2023, I came home from a logistics trade show in Hamburg with 180 company names on badge scans and napkins. No people. No emails. So I started opening websites by hand, got through 34 in two hours, and quit.

But let’s do the free routes first. Because for ten companies, they still beat any tool.

📌 TL;DR: Three ways to fill a company email column: (1) read the address off the company's own website, free but slow; (2) work out the email format from one address you already know, then verify it; (3) run an add-on on your company-name column: names in, addresses out, row range like 2-181, one pass. And remember: a general inbox like info@ is not a named person's work email.

What Is a Company Email Address, Exactly?

A company email address is a general mailbox a business publishes, like info@ or sales@. It belongs to the company, not a person. So whoever is on rota that week reads it.

People mean three different things by that phrase, though. And the difference decides which page you need.

First, the general mailbox: info@, sales@, support@, hello@, press@. That’s what this guide finds, and it’s the cheapest contact data a business gives away.

Second, a specific employee’s work email. Totally different job. Want Lena in procurement rather than the front desk? Then go and find a person’s email in Google Sheets instead, because that workflow takes people’s names.

Third, creating an address at your own domain. That’s a mail provider job, not a lookup. Google Workspace or Microsoft 365 will sell you a mailbox in about ten minutes. Nothing on this page does that. So if that’s why you’re here, go there with my blessing.

Still here? Then you want addresses that already exist. Let’s go and get them.

How Do You Find a Company’s Email Address for Free?

Check the website contact page and footer first. Most companies publish one there. No tool, no credits, no signup. For a short list, that’s the whole answer.

Read It Off the Website

Try these in order: the contact page, the footer, /contact, /about, and the press or media page. Small and mid-size companies nearly always publish something. Larger ones bury it behind a form.

But enterprises will fight you. When the contact page holds only a web form, note it and move on. Working one company at a time? Then read my non-Sheets walkthrough on how to find business email addresses from a company name.

Check the Profiles the Company Controls

Then try the places the business fills in itself. A LinkedIn company page often carries a contact address in its overview. A Google Business Profile shows one for local companies, and so do industry directories and exhibitor listings.

Those exhibitor lists rescued a chunk of my Hamburg file. Half my badge scans had a stand number, and each listing carried an address.

Work Out the Pattern Instead

Know one address at a company? Then you know the shape of every other one. That’s the job a company email format finder does, and your own eyes do it perfectly well:

  • first.last@ → maria.lang@northvalefreight.com
  • flast@ → mlang@northvalefreight.com
  • first@ → maria@northvalefreight.com

The domain half is easier than people expect. When you’re asking how to find company email domain, the answer is usually the website in front of you. Strip the https:// and the www., then keep what’s left. That’s your whole company email domain finder, for free.

And yes, plenty of people search for an email finder by company name free. The genuinely free version is what you just did: the company’s own site.

One warning, though. A pattern is a guess until something verifies it. And guesses bounce.

So here’s the ceiling I hit. Thirty-four websites, two hours, dead ends included. Free routes are lovely up to 20 or 30 companies. At 180, they eat your week.

📌 Example: Hamburg, 2023. 180 badge scans. 34 websites opened by hand in two hours. Then I gave up, pasted the remaining 146 company names into one column, and ran them in a single pass.

How Do You Find Email Addresses for a Whole List of Companies?

Put the company names in one column and run a bulk lookup on the whole range. That’s the shape of the job at 20 rows or 2,000.

An email finder by company name takes the name, matches it to the right business, then returns the address that business publishes. So you end up with a list of company email addresses beside your own targets, row for row. That’s all there is to how to find company email addresses at volume: one clean column in, one verified column out.

Now the uncomfortable part. No provider holds an address for every company on earth. Match rates swing with region, industry and size. Some businesses publish no general mailbox, just a form. So those rows come back blank, and blank is the correct answer.

“Verified” should mean three checks in order: syntax, then the domain and its MX record, then the mailbox itself. That’s Data Verification. Google’s bulk sender guidelines ask senders to keep spam complaints under 0.3%, and unchecked guesses are a fast way past that line.

Which is the argument for doing this inside the spreadsheet. Because company email addresses in Google Sheets sit beside every other column you care about. No export, no CSV round trip. You want a company email address finder that works on a range, not a search box.

How Do You Do It With the CUFinder Add-On?

Install the add-on, add your API key, pick the company-email service, map your columns, and run. That’s my loop for company email addresses in Google Sheets, and only the last step repeats.

  1. Install the add-on. Grab the CUFinder add-on from the Google Workspace Marketplace. Never installed one before? Google’s help page on Sheets add-ons explains how they install and where they appear.
  2. Copy your API key. Open your CUFinder dashboard and copy the API key from there.
  3. Enter the key in the add-on. One paste, and you’re connected.
  4. Pick the service. Open the add-on from the Google Sheets menu. It opens as a right panel listing all the enrichment services. Choose Find Business Email Address, which takes company names and returns a verified business email.
  5. Map columns, set the range, run. Set the input column (your company names), the output column (where addresses land), and the row range. Mine was rows 2 to 181. Then run it.

Before you run anything, spend two minutes on the input column. Because company names are fussier to match than you’d think:

  • One company per row: split “Bauer & Sons / Bauer Logistics” into the legal name you mean.
  • Use the name the company writes on its own site, not the badge abbreviation. “Nordwest Log.” matches nothing.
  • Add the country when the name is generic. Three companies call themselves Meridian, and only one is yours.
  • Drop suffixes like GmbH, Ltd or Inc only when you’ve typed them inconsistently. Consistency beats the suffix.
  • Remove duplicates first, under Data → Data cleanup → Remove duplicates. Badge lists are full of them.

Clean company names are the cheapest match-rate upgrade there is. Seriously.

💡 Pro Tip: Run rows 2-6 as a test batch first. Open those five websites and check the addresses by eye. THEN set the range to your full list and run it.

Now the limits, plainly. Some rows come back empty, every processed row spends credits, and coverage varies by region and size. A small manufacturer in a quiet market is harder than a software firm. So test 20 rows before trusting a column of 500.

And one decision before you press run. If you really need a named human (Lena in procurement, not the front desk), stop here. A list of people belongs in the bulk email finder workflow instead.

A B C D E

GOOGLE SHEETS  |  CUFINDER ADD-ON

Run this workflow without leaving your sheet

1Pick a service 2Set input & output columns 3Choose your rows & run

A Worked Example: 5 Rows, Before and After

Here’s the template I keep for this. Company names in column A, an empty website column, an empty email column:

ABC
1CompanyWebsiteCompany Email
2Northvale Freight
3Kestrel Packaging
4Alpine Fluid Systems
5Redshaw Instruments
6Lumen Kitchen Group

Then I run it as two chained passes, not one. First, Company Name to Domain fills column B: input A, output B, rows 2 to 6. That’s the same move as filling a company website column in Google Sheets.

Second, Find Business Email Address fills column C. Same sheet, same range, new output.

→ company names → domains → company inboxes. Two runs, one sheet.

ABC
1CompanyWebsiteCompany Email
2Northvale Freightnorthvalefreight.cominfo@northvalefreight.com
3Kestrel Packagingkestrelpackaging.comsales@kestrelpackaging.com
4Alpine Fluid Systemsalpinefluidsystems.cominfo@alpinefluidsystems.com
5Redshaw Instrumentsredshawinstruments.com
6Lumen Kitchen Grouplumenkitchengroup.comhello@lumenkitchengroup.com

Look at row 5. Redshaw Instruments has a website and publishes no general mailbox, only a contact form. So column C stays empty, and that empty cell is the honest result. My email finder by company name filled four rows of five, which is what a real list looks like.

Two habits keep a sheet like this usable. First, keep found addresses in their own column, never mixed with pattern guesses. Second, add a “found on” date column. Companies retire and reroute inboxes. That’s Data Decay, and six months is enough for it to bite.

Want more than an address? Headcount, industry and revenue are a company enrichment in Google Sheets job. And when you’d rather call, the same trick fills a company phone numbers column.

Should You Email info@ or Find a Person?

Email a person when you can. General inboxes reply far less often. That isn’t a rule I read somewhere. It’s what my own sheet told me.

That quarter I ran both. My info@ emails came back at roughly a third of my named-contact reply rate. Same offer, same week, same signature: the only variable was who owned the address. My campaign, my numbers, so treat it as one marketer’s experience rather than a benchmark.

But sometimes the general inbox is genuinely the right target:

  • Partnership and reseller enquiries, which someone always forwards onward.
  • Press and media requests, since press@ exists for precisely this.
  • Small businesses, where the owner reads info@ personally.
  • Procurement and vendor registration, which are gatekept on purpose.
  • Support-driven products, where the support queue answers fastest.
  • Any company where you have no named contact yet.

So the realistic play is both, in order. Use the company address to open the door and ask who owns the topic. Then find that person’s email in Google Sheets for the follow-up.

What Should You Watch Out For?

The header row, unverified patterns, catch-all domains, mail-merge tone, consent rules, stale columns. Four of those six have caught me personally:

  • Starting the range at row 1. Then you enrich your header and burn a credit looking up a company called “Company”.
  • Treating a scraped pattern as verified. Guesses bounce, and bounces cost you Email Deliverability, which is slow to win back.
  • Sending to a catch-all domain and calling it delivered. A Catch-All Email domain accepts mail for any address, so “accepted” says nothing about the mailbox.
  • Blasting info@ with a personalised-looking template. “Hi there, I loved what your team is doing” reads as a mail merge, because it is one. Write to the company instead.
  • Ignoring consent rules. GDPR wants a lawful basis and a working opt-out, while the CAN-SPAM Act wants honest headers, a physical address and a real unsubscribe. Company mailboxes are not a loophole.
  • Never re-checking. Addresses rot quietly. So re-verify any column older than six months.
🔍 Did You Know? Google's bulk sender guidelines put the spam-complaint ceiling at 0.3%. That's three complaints per thousand emails. And yes, general inboxes report spam too.

FAQ: Finding Company Email Addresses

How to find an email address from a company?

Start on the company’s own website: contact page, then footer, then press page. Most businesses publish a general address in one of those three spots. For a whole list, skip the clicking: paste the names into a column and run one bulk pass.

How can I find a company’s email address?

Check the profiles the company controls, not only its website. A LinkedIn company page, a Google Business Profile, an industry directory or an exhibitor listing often carries a contact address. And companies refresh those profiles more often than a forgotten contact page.

How do I look up a business email?

One business by eye, a column of businesses by lookup. A single company takes about 30 seconds on its contact page. But 200 companies is a different job, so put the names in one column and let an add-on fill the next one.

How to check if an email address is from a company?

Compare the domain after the @ with the company’s own website domain. If they match, it’s a company address. If the domain is gmail.com, outlook.com or another free provider, it belongs to a person rather than the business. That check takes five seconds.

Can you find an email by name only?

No. You need the company too, because the domain comes from the employer. “Maria Lang” exists at hundreds of businesses. So add the company name, then use the person-level workflow in find a person’s email in Google Sheets.

How do I find a company CEO email address?

That’s a person-level lookup: you need the CEO’s name plus the company. So use the person-email workflow linked above, not this one. Honestly, executives are the hardest to find and the slowest to reply, so a general inbox is often the faster door.

What is the best free email finder?

The company’s own website, honestly. Every free tier caps out somewhere, ours included. Most tools hand you starter credits and then charge. So spend those credits on the rows that matter and read the easy ones off the contact page.

How can I get a company email address?

That depends on whether you want to create one or find one. To create an address at your own domain, you need a mail provider like Google Workspace or Microsoft 365. To find one a business publishes, use this guide: website first, then a bulk lookup.

Your Company Column Is Waiting

Those 180 badge scans became a contacted list before the follow-up window closed, and after a trade show that window is about two weeks. Not because I found a clever trick. Because I stopped opening tabs one at a time.

So paste your names into column A, check the first few by hand, then let one run handle the rest. And hold onto the honest rule: a general inbox opens the door, a named person answers it.

Company email addresses in Google Sheets are only the first column, too. The data enrichment in Google Sheets hub covers what to fill next: websites, phone numbers, headcount, tech stack. Tell me in the comments: how many company names are in your sheet right now?

How would you rate this article?
Bad
Okay
Good
Amazing
Comments (0)
Comments (0)
98% accuracy, GDPR & CCPA ready

Prefer to Explore on Your Own?

Skip the call and start free: 15 credits, no credit card required. Upgrade or talk to us whenever you’re ready.

Free plan available · 50 credits/month · no credit card required