---
title: "Enrich a company list with founded year, HQ, CEO and size"
slug: "enrich-company-list-with-ai"
type: "apify-task-example"
url: "https://automationbyexperts.com/apify/examples/enrich-company-list-with-ai"
actor: "Run GPT, Claude, DeepSeek... Prompts in Bulk (No API Key)"
actor_url: "https://automationbyexperts.com/apify/bulk-llm-runner"
apify_url: "https://apify.com/fayoussef/bulk-llm-runner/examples/enrich-company-list-with-ai?fpr=youssef&fp_sid=abe_ex_enrich-company-list-with-ai"
price: "$0.002"
price_unit: "per result"
---

# Enrich a company list with founded year, HQ, CEO and size

Upload a sheet of company names and websites, ask your question in plain words, and get the answers back as new columns: founded year, headquarters, CEO and employee count.

**Run it:** [Enrich a company list with founded year, HQ, CEO and size on Apify](https://apify.com/fayoussef/bulk-llm-runner/examples/enrich-company-list-with-ai?fpr=youssef&fp_sid=abe_ex_enrich-company-list-with-ai)  
**Actor:** [Run GPT, Claude, DeepSeek... Prompts in Bulk (No API Key)](https://automationbyexperts.com/apify/bulk-llm-runner)  
**Pricing:** $0.002 per result

## What this task is for

Web search is switched on for this task, so the model looks each company up rather than answering from memory, and the question names the four facts it has to return. Asking for specific fields is what keeps the column names identical on every row instead of drifting between answers.

The result is your own file back as Excel, which is the format a CRM import or a prospect list actually needs. Change the question and the same task enriches a list with whatever else is public: funding stage, tech stack, office locations.

## The input this task runs with

```json
{
  "spreadsheet_file": "https://api.apify.com/v2/key-value-stores/I40EWpLzQaVq08gCm/records/companies-sample.csv",
  "prompts": [
    "For the company {{Company}} ({{Website}}), find the year it was founded, its headquarters city, its current CEO and its approximate number of employees."
  ],
  "model": "google/gemini-2.5-flash",
  "enable_web_search": true
}
```

## What every run returns

- `Prompt`
- `Model used`
- `Response text`
- `Structured JSON columns`
- `Web search sources`
- `Source row (Excel/CSV/Sheet)`
- `Status`
- `Timestamp`

## How to run it

1. Open the task on Apify. New accounts get $5 of free credit.
2. Check the pre-filled input above and change anything you need.
3. Click Run. Pagination, proxies and anti-bot handling are automatic.
4. Export CSV, JSON or Excel, or save it as your own task and schedule it.

## Other Run GPT, Claude, DeepSeek... Prompts in Bulk (No API Key) tasks

- [Write Amazon listing copy for every SKU in a spreadsheet](https://automationbyexperts.com/apify/examples/amazon-listing-copy-from-product-spreadsheet): A full Amazon listing for every SKU in your spreadsheet: title, five bullets, description and backend search terms, each in its own column, written only from the facts in your sheet.
- [Run a ChatGPT prompt for every row of a Google Sheet](https://automationbyexperts.com/apify/examples/run-chatgpt-prompts-from-google-sheet): One ChatGPT prompt per row, run for a whole Google Sheet or Excel file. Paste the link, get the file back with each answer in a new column. No API key of your own required.
- [Check which tests each lab offers from an Excel list](https://automationbyexperts.com/apify/examples/check-lab-tests-from-excel-list): Upload a list of laboratories and a checklist of tests, and get yes, no or unknown for every lab and test, each answer with an evidence sentence and a source link.
- [Compare GPT, Claude and Gemini side by side](https://automationbyexperts.com/apify/examples/compare-gpt-claude-gemini-answers): The same prompts sent to GPT-5, Claude Sonnet 5, Gemini 3.8 Flash and Perplexity Sonar, returned as one row per model per prompt with the answer, the cost and the token count.
- [Classify and tag customer reviews at scale](https://automationbyexperts.com/apify/examples/classify-customer-reviews): Every review through the same rubric: sentiment, a topic tag, an urgency flag and a one-line summary, each as its own column rather than a paragraph of commentary.
- [Write SEO product descriptions in bulk](https://automationbyexperts.com/apify/examples/seo-product-descriptions-in-bulk): One line per product in, a structured description out: a benefit-led paragraph, feature bullets and a meta description, as JSON columns ready for a product feed.

---

Part of [AutomationByExperts](https://automationbyexperts.com) - see [all example tasks](https://automationbyexperts.com/apify/examples) or [request a new one](https://automationbyexperts.com/suggest).