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

🔍 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

These are the exact settings saved in the task. Open it on Apify and they are already filled in, so you can run it unchanged or edit a field first.

{
  "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

One record per result, with these fields, exportable as CSV, JSON or Excel.

🚀 How to run this task

1. Open the task on Apify

   Use the button above. New accounts get $5 of free credit and no credit card is required.

2. Check the pre-filled input

   Every setting shown above is already there. Change a city, a price range or the result limit if you want a different slice of the data.

3. Click Run

   Pagination, rotating proxies and anti-bot handling all happen in the cloud. The result limit is what controls your cost.

4. Export or schedule it

   Download CSV, JSON or Excel, or save the task in your own account and schedule it daily or weekly. Webhooks and the Apify API push results straight into your own tools.

💵 What this task costs

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

🔗 Related actors