Find B2B Leads by Job Title in Google Sheets: 100 in One Formula
Build a prospect list of decision makers with work email, mobile, LinkedIn and company size using one =FINDLEADS() formula in Google Sheets. 100 leads cost 881 scraping credits instead of 5 hours of copying.
Phil Nguyen · 6 min read

=FINDLEADS() searches for B2B contacts by job title, location, company domain and industry, and writes up to 100 of them into Google Sheets by default, each with a work email, mobile, LinkedIn profile and company size. One formula gives you a prospect list of decision makers you can sort and send to, at a known cost of 81 scraping credits per run plus 8 per lead.
Picture an SDR who needs 100 marketing directors at US agencies for next week's sequence. Searching LinkedIn, opening each company site and copying the name, title and email into a sheet takes about 3 minutes a contact, so 100 contacts is 5 hours. One FINDLEADS formula returns the same 100 rows for 881 scraping credits.
How do I find B2B leads by job title in Google Sheets?
FINDLEADS takes five arguments, all optional, but you need at least one filter:
=FINDLEADS(job titles, location, company domain, industry, maxResults)
Put the titles you want in B2:B4 (for example Marketing Director, Head of Marketing, VP Marketing) and write:
=FINDLEADS(B2:B4, "united states", , "marketing & advertising", 100)
- Job titles: one title or a range. Several titles are OR-matched, so any of them counts. Use specific titles, not departments.
- Location: a region, country or state, such as "united states" or "united kingdom". It filters where the contact is, not where the company is headquartered.
- Company domain: limit results to people at specific companies, such as "example.com". Good for account-based lists.
- Industry: one of the tool's fixed industry values (see below).
- maxResults: the most leads to return. The default is 100.
The cell shows ⏳ Scraping... straight away, and the contacts arrive on a new tab when the search finishes.
What does FINDLEADS return?
The rows land on a tab called Leads Finder Results, after a Source column holding the formula's cell. The columns are:
Full Name, Job Title, Seniority, Email, Personal Email, Mobile, LinkedIn, City, State, Country, Company, Company Domain, Industry, Company Size, Revenue, Founded, Description, Technologies, Company Address, Company Phone, Company LinkedIn, Company City, Company Country, Annual Revenue, then First Name, Last Name, Headline, Company Website, Company State, Company Postal Code and Company Keywords.
Here is the shape of the output, with made-up values for illustration:
| Full Name | Job Title | Seniority | Company | Company Domain | Company Size |
|---|---|---|---|---|---|
| Jane Example | Marketing Director | director | Example Agency | example.com | 51-100 |
| Sam Sample | VP Marketing | vp | Sample Media | sample.io | 11-20 |
How do I write the filters so the search does not come back empty?
Most empty or failed searches come from filter values the search does not accept.
- Industry must be an exact value. The tool accepts a fixed list of lowercase industries that use "&", not "and": "marketing & advertising", "computer software", "financial services", "real estate", "hospital & health care". "Marketing" or "SaaS" is rejected.
- Location is lowercased for you. The search wants lowercase values like "united states", and SheetMagic converts what you type, including two-letter codes such as "US", before it sends the search.
- Fewer filters means more results. Title plus location plus industry works well. Stack too many narrow values and you may get nothing back.
- There are no exclusion filters. You cannot exclude a title, city or industry in the formula. Pull the leads, then filter the sheet.
- City, seniority and company size are not formula arguments. They come back as columns (City, Seniority, Company Size), so filter on them in the sheet.
What can I do with the lead list?
- Pitch the decision maker first. Filter the Seniority column to the senior levels and start there. On a 100-row list that is one filter, not an hour of reading LinkedIn headlines.
- Check emails before you send. Run =VALIDATEEMAIL() on the Email column. It checks deliverability and flags disposable and role-based addresses, so you can drop risky rows before they bounce and hurt your sender reputation. See how to verify email addresses in Google Sheets.
- Keep only the company sizes you sell to. Filter Company Size to your band. That keeps reps off accounts too small to buy.
- Research the best accounts deeper. Feed the LinkedIn column to =LINKEDINPROFILE() or the Company Website column to =CONTACTINFO() for the accounts worth a personal touch.
How much does a lead search cost?
Each FINDLEADS run costs 81 scraping credits plus 8 per lead returned. 100 leads is 81 + 800 = 881 credits. A run that finds no leads bills nothing.
| Plan | Scraping credits | 100-lead searches that fit |
|---|---|---|
| Free | 100 | a 2-lead test |
| Solo | 10,000 a month | 11 |
| Growth | 45,000 a month | 51 |
| Scale | 115,000 a month | 130 |
On Free, with all 100 credits unspent, a 100-lead request is shrunk automatically to what your balance covers, which is 2 leads (81 + 16 = 97 credits), so you can see the output before you upgrade.
How do I scale to many accounts?
Put your target domains in a column and pass the range as the company domain argument, for example =FINDLEADS(B2:B4, , D2:D21, , 200). maxResults is the total across the whole search, not per company, so raise it for a long domain list. Each row carries the Source cell of the formula that found it, and the Company Domain column lets you VLOOKUP contacts back to your account list. For filling in data on accounts you already have, see enrich lead lists in Google Sheets.
What are the common pitfalls?
- Results do not appear under the formula. They go to the Leads Finder Results tab. With Keep Formula on, the default, the formula cell is kept as text so it does not run again on its own.
- A blank target cell is refused. If every filter cell is empty, the cell shows #ERROR: empty input and nothing is charged.
- The default is 100 leads. Set maxResults lower for a test run, such as 10 (161 credits).
For the wider playbook of building and working a pipeline from a sheet, start with sales lead generation in Google Sheets.
Text and scraping formulas run on the free allowance. Install from the Google Workspace Marketplace, no card, no expiry.
Install free for Google SheetsAbout the author
Phil NguyenPhil builds SheetMagic, the Google Sheets add-on that brings AI and web scraping into the spreadsheet, used by 6,000+ people. He writes these guides from the formulas he runs on his own sheets.
