Enrich 25 companies before lunch.
A column of company URLs becomes industry, headcount and HQ, then a verified email for every row.
fx=LINKEDINCOMPANY(A2:A26)
✅ 25 results → Linkedin Company Results
| Company URL | Formula | |
|---|---|---|
| 2 | linkedin.com/company/lumen-metrics | =LINKEDINCOMPANY(A2:A26) |
| 3 | linkedin.com/company/clearpath-hr | |
| 4 | linkedin.com/company/northstar-billing | |
| 5 | linkedin.com/company/fieldnote | |
| 6 | linkedin.com/company/quill-analytics |
Linkedin Company Results
| industry | headcount | hq |
|---|---|---|
| Software Development | 51-200 | Austin, TX |
| Human Resources | 11-50 | Dallas, TX |
| Financial Services | 201-500 | Houston, TX |
| Software Development | 2-10 | Austin, TX |
| Data Analytics | 51-200 | Plano, TX |
| Software Development | 11-50 | Houston, TX |
| Human Resources | 201-500 | Austin, TX |
| Financial Services | 2-10 | Plano, TX |
| Software Development | 51-200 | Austin, TX |
| Data Analytics | 51-200 | Dallas, TX |
| Software Development | 11-50 | Houston, TX |
| Human Resources | 201-500 | Austin, TX |
| Financial Services | 2-10 | Plano, TX |
| Software Development | 51-200 | Austin, TX |
| Data Analytics | 51-200 | Dallas, TX |
| Software Development | 11-50 | Houston, TX |
| Human Resources | 201-500 | Austin, TX |
| Financial Services | 2-10 | Plano, TX |
| Software Development | 51-200 | Austin, TX |
| Data Analytics | 51-200 | Dallas, TX |
| Software Development | 11-50 | Houston, TX |
| Human Resources | 201-500 | Austin, TX |
| Financial Services | 2-10 | Plano, TX |
| Software Development | 51-200 | Austin, TX |
| Data Analytics | 51-200 | Dallas, TX |
Example output for illustration, not a live result.
25 companies. About 1 hour by hand, or one formula dragged down.
How LINKEDINCOMPANY() works.
Where it runs
This runs in the background. The cell shows a scraping placeholder for up to about a minute while the job runs, then writes every row to a new tab named Linkedin Company Results. A Source column in that tab names the input cell that produced each row.
Where the data comes from
Reads each company's own public LinkedIn page directly, no login required. It only works from a company page URL, so it will not search LinkedIn for you or read a personal profile.
Costs 400 integration credits for 25 companies: 16 per company, from the published rate. See every source's rate
Two ways to do it.
Formula
Every formula works on Free.
1. Paste the formula
Put your company url values in column A and paste =LINKEDINCOMPANY(A2:A26) into B2.
2. Drag it down
Drag the LINKEDINCOMPANY cell down the column. Every row runs on its own.
3. Read the results
Results land in a new tab named Linkedin Company Results, with a Source column naming the cell that asked for each row.
Chat
Chat Agent is on Solo, Team and Business plans.
1. Type the job
“Add industry, headcount and a verified email for every row”
2. Approve the cost
The agent shows the credit cost before it runs anything. You approve or reject it, and nothing is spent until you do.
3. Choose raw or cleaned
Once the scrape returns, pick the raw data or a cleaned-up version, deduped and trimmed to what you asked for, before either one lands in the sheet.
4. The agent writes the sheet
Enriched 25 rows and flagged 2 undeliverable emails.
Month four.
The list gets 2 new rows a week. Drag the column over them.
| company url | industry | hq | Run |
|---|---|---|---|
| linkedin.com/company/brightpath-legal | Legal Services | Austin, TX | New |
| linkedin.com/company/harbor-analytics | Data Analytics | San Antonio, TX | New |
What re-running the same formula next month adds or changes. Example output for illustration, not a live result.
Turn on Keep Formula in the sidebar and the column stays live for the rows you add next week.
Formulas for this job.
=LINKEDINCOMPANY({"https://linkedin.com/company/google"})Company page data: industry, staff count, HQ, specialties
=VALIDATEEMAIL({"test@example.com"})Check whether email addresses are deliverable
=AITEXT("Write a product description for: " & A1)Generate AI text from any prompt, supports every model and optional real-time web search
Not sure it fits your job? Ask.
Describe the task in plain English. In about ten seconds you get a straight answer, yes, partially or not a fit, plus the exact formulas or Chat Agent prompt to run. No signup, no card.
Already sure?
Installs from the Google Workspace Marketplace in under a minute. Every formula works on the free allowance.
Install free for Google Sheets