Build a Company Research Workflow from Domains

This tutorial walks through building a table that starts with company domains and returns a complete company profile including firmographics, technology stack, decision-maker contacts, and social presence.

---

Before you begin

• Connect these integrations in Settings > Integrations:
  • Apollo (for company enrichment)
  • Apify (for LinkedIn employee scraping)
• No external setup is needed for TexAu utility actions.

---

What you will build

A table where each row is a company domain, and the columns build out a complete picture of that company:

---

Step 1: Create the table

1. Click New Table and name it Company Research.
2. Import your list of company domains as a CSV, or paste them directly.
3. Name the first column Company Domain (e.g. acme.com, not https://acme.com).

---

Step 2: Enrich company firmographics

1. Click Add Column and select Action Column.
2. Search for and select Enrich Company (Apollo).
3. Map the Company Domain column to the company domain input.
4. Select these outputs:
   • Company Name
   • Industry
   • Employee Count
   • Annual Revenue Range
   • Location (City, Country)
   • LinkedIn URL
   • Short Description
5. Click Save.

This action costs 2 credits per row.

---

Step 3: Get the technology stack

1. Click Add Column and select Action Column.
2. Search for and select Get Website Tech Stack (TexAu Utility).
3. Map the Company Domain column to the URL input. Add https:// prefix with a formula if needed: CONCAT("https://", company_domain).
4. Select Technologies as the output. This returns a list of detected tools.
5. Click Save.

This action costs 1 credit per row.

---

Step 4: Get website metadata

1. Click Add Column and select Action Column.
2. Search for and select Get Web Meta Tags (TexAu Utility).
3. Map CONCAT("https://", company_domain) as the URL input.
4. Select Title, Description, and Keywords as outputs.
5. Click Save.

This action costs 1 credit per row.

The meta title and description give you a quick summary of how the company describes itself, useful for personalizing outreach.

---

Step 5: Build the LinkedIn Company URL

Most company LinkedIn URLs follow a predictable pattern. Build one from the Apollo output or directly:

1. Click Add Column and select Formula Column.
2. If Apollo returned a LinkedIn URL, use: apollo_linkedin_url
3. If not, you can build an approximate URL: CONCAT("https://linkedin.com/company/", LOWER(REPLACE(company_name, " ", "-")))

Name this column LinkedIn Company URL.

---

Step 6: Scrape decision-maker contacts

1. Click Add Column and select Action Column.
2. Search for and select Scrape LinkedIn Company Employees (Apify).
3. Map the LinkedIn Company URL column to the input.
4. Configure filters:
   • Job Title Keywords: "cto", "vp engineering", "head of", "director", "founder"
   • Max Results: 10 (to limit to top results per company)
5. Click Save.

This action costs 8 credits per row and returns multiple contacts per company.

---

Step 7: Run all rows

1. Click Run All Rows.
2. Monitor the progress. The Apify column will take longer than the others.
3. After completion, review the data.

---

Step 8: Export or pass to enrichment

Export the contact rows from Step 6 as a CSV and run them through email enrichment in a separate table:

1. Click Export and download the table as CSV.
2. Create a new table for contact enrichment.
3. Import the LinkedIn profile URLs from the exported file.
4. Add Find Work Email by LinkedIn URL (BetterEnrich) as an Action Column.

---

Troubleshooting

Enrich Company returns empty fields for a domain. Apollo may not have data for every company. Small companies, very new companies, and companies with no web presence are less likely to be in Apollo's database. Try Get Meta Tags and Get Tech Stack as alternative ways to gather minimal company data.

The LinkedIn Company URL formula returns a wrong URL. The formula-built URL works for companies with simple, predictable slugs. Companies with unusual characters in their names, initials, or multiple LinkedIn pages will not be found this way. If Apollo returns a LinkedIn URL, use that directly instead.

Apify returns contacts that are not in the expected job function. LinkedIn keyword matching is broad. A search for "director" will return all titles containing the word "director." Add more specific terms to refine results, or filter the output by job title in TexAu using a formula column after the run.