Integration spotlight: Rows Company Search

Overview

With our Rows Company Search integration, it couldn’t be easier to find company names, domains, or companies based on their number of employees, location, and industry.

This is the new home for what used to be known as our Gauss integration :partying_face:

Pricing and limits

Each function execution consumes 1 integration task and returns as much data as is possible according to Rows cell limits. For very broad searches, this averages out to around 900 responses.

Functions

Function Description
FIND_DOMAIN Get a company’s domain.
FIND_EMAIL Find a person’s professional email address based on their name and their company’s domain.
GET_COMPANY_BY_DOMAIN Get company details based on their domain.
SEARCH_COMPANIES Find companies based on the number of employees, location, and industry.

FIND_DOMAIN

Use FIND_DOMAIN to quickly find the domain of a company.

Syntax

FIND_DOMAIN(company)

Parameter Mandatory Description
company Yes Company name or keyword. For example: "Rows" or "Tesla".

Examples

To get the domain of apple:

FIND_DOMAIN("apple")

Find domain example

FIND_EMAIL

Use FIND_EMAIL to get the right email for a person at a company.

Syntax

FIND_EMAIL(domain_or_url, first_name, last_name)

Parameter Mandatory Description
domain_or_url Yes The company domain or URL where the person works. For example: "amazon".
first_name Yes The first name of the person. For example: "jeff".
last_name Yes The last name of the person. For example: "bezos".

Examples

To get the email address for someone called Jeff Bezos at Amazon:

FIND_EMAIL("amazon.com", "jeff", "bezos")

Find email example

GET_COMPANY_BY_DOMAIN

Use GET_COMPANY_BY_DOMAIN to get a company’s name, founding date, sector, employee range, address, and LinkedIn profile. And to get all these details just with one click, use our Company details recommended row or table.

Syntax

GET_COMPANY_BY_DOMAIN(domain)

Parameter Mandatory Description
domain Yes Company website domain. For example: "spotify.com".

Examples

To get the details for apple.com:

=GET_COMPANY_BY_DOMAIN("apple.com")

Get company by domain example

SEARCH_COMPANIES

Use SEARCH_COMPANIES to find companies based on their number of employees, location, and industry. You can use the Companies recommended table to get all your results, including their name, domain, founding date, sector, employee range, address, and LinkedIn profile, into a table with just one click.

Syntax

SEARCH_COMPANIES(employees, location, industry)

Parameter Mandatory Description
employees Yes Number of employees. For example: ">50" or "<1000".
location Yes Company location (country, region or state, city). For example: "United States" or "London; Manchester; Liverpool".
The responses returned will favor the locations in sequential order. That is, there will be more responses for the first location than the second, the second to the third, and so on.
industry Yes Company industry. For example: "retail" or "banking;retail". For a full list of industries, check the note below.

:memo: Note: Just remember: to enter numerous locations or industries, you need to use a semicolon (;). This way, you can state locations more precisely ("Houston, Texas; Austin, Texas") as well as use industries that already have a comma in them ("Leisure, Travel & Tourism; Food & Beverage").

List of Industries

A-J K-Z
- Accounting
- Airlines/Aviation
- Alternative Dispute Resolution
- Alternative Medicine
- Animation
- Apparel & Fashion
- Architecture & Planning
- Arts and Crafts
- Automotive
- Aviation & Aerospace
- Banking
- Biotechnology
- Broadcast Media
- Building Materials
- Business Supplies and Equipment
- Capital Markets
- Chemicals
- Civic & Social Organization
- Civil Engineering
- Commercial Real Estate
- Computer & Network Security
- Computer Games
- Computer Hardware
- Computer Networking
- Computer Software
- Construction
- Consumer Electronics
- Consumer Goods
- Consumer Services
- Cosmetics
- Dairy
- Defense & Space
- Design
- ELearning
- Education Management
- Electrical/Electronic Manufacturing
- Entertainment
- Environmental Services
- Events Services
- Executive Office
- Facilities Services
- Farming
- Financial Services
- Fine Art
- Fishery
- Food & Beverages
- Food Production
- FundRaising
- Furniture
- Gambling & Casinos
- Glass, Ceramics & Concrete
- Government Administration
- Government Relations
- Graphic Design
- Health, Wellness and Fitness
- Higher Education
- Hospital & Health Care
- Hospitality
- Human Resources
- Import and Export
- Individual & Family Services
- Industrial Automation
- industry
- Information Services
- Information Technology and Services
- Insurance
- International Affairs
- International Trade and Development
- Internet
- Investment Banking
- Investment Management
- Judiciary
- Law Enforcement
- Law Practice
- Legal Services
- Legislative Office
- Leisure, Travel & Tourism
- Libraries
- Logistics and Supply Chain
- Luxury Goods & Jewelry
- Machinery
- Management Consulting
- Maritime
- Market Research
- Marketing and Advertising
- Mechanical or Industrial Engineering
- Media Production
- Medical Devices
- Medical Practice
- Mental Health Care
- Military
- Mining & Metals
- Motion Pictures and Film
- Museums and Institutions
- Music
- Nanotechnology
- Newspapers
- Nonprofit Organization Management
- Oil & Energy
- Online Media
- Outsourcing/Offshoring
- Package/Freight Delivery
- Packaging and Containers
- Paper & Forest Products
- Performing Arts
- Pharmaceuticals
- Philanthropy
- Photography
- Plastics
- Political Organization
- Primary/Secondary Education
- Printing
- Professional Training & Coaching
- Program Development
- Public Policy
- Public Relations and Communications
- Public Safety
- Publishing
- Railroad Manufacture
- Ranching
- Real Estate
- Recreational Facilities and Services
- Religious Institutions
- Renewables & Environment
- Research
- Restaurants
- Retail
- Security and Investigations
- Semiconductors
- Shipbuilding
- Sporting Goods
- Sports
- Staffing and Recruiting
- Supermarkets
- Telecommunications
- Textiles
- Think Tanks
- Tobacco
- Translation and Localization
- Transportation/Trucking/Railroad
- Utilities
- Venture Capital & Private Equity
- Veterinary
- Warehousing
- Wholesale
- Wine and Spirits
- Wireless
- Writing and Editing

Examples

To get retail companies in London that have more than 50 employees:

=SEARCH_COMPANIES(">50","London","retail")

Search companies example

Summary

Yeah - our Rows Company Search integration is pretty awesome and will definitely make your company searches a whole lot easier.

And if you need a bit of a quick start, check out our templates:

And now get out there, build :rocket:!