
B2B Databases such as Apollo.io or Zoominfo scrape the web to update their people and company data. With hundreds of millions of leads (Apollo says 275M), they can't keep their data fresh.

Profiles with data not updated for more than 1 year are more common than you think. The only places with fresh data are where people update their profile themself. And the best place is LinkedIn.

LinkedIn is the most reliable source for fresh profile data.

With this enrichment, you only need the LinkedIn profile URL and it will scrape available public data. And Datablist is built for scale, so run this enrichment on hundreds or thousands of profiles.

Main features:
- Update all or only missing fields.
- **This enrichment doesn't need your LinkedIn credentials**. No risk of having your LinkedIn account blocked.
- Run at scale

## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>

### Step 2: Select the "LinkedIn Profile Scraper" enrichment

Click on the "Enrich" button in the header, and search for "LinkedIn Profile Scraper".

![Select LinkedIn Profile Scraper on the enrichment store](/enrichements_images/scrape_linkedin_profile/enrichment_store.png#2360x1270)



### Step 3: Configure settings and inputs

After selecting the enrichment, a drawer opens with settings and the input configuration.

Select "Disable cached profiles" to get only real-time data from LinkedIn (see [pricing](#how-much-does-it-cost-to-scrape-linkedin-profile)). When disabled, you might get a cached version (less then 1 month). This allows faster and cheaper scraping.

In the "Input" section, select the property from your collection with the LinkedIn Profile URL.

![LinkedIn Profile Scraper settings & input](/enrichements_images/scrape_linkedin_profile/linkedin_scraper_inputs_settings.png#2356x1354)


### Step 4: Configure Outputs and Run the enrichment

The final step is to configure when the scraped data will be stored. You can map the output data with an existing property or create a new property that will store the results.

![LinkedIn Profile Scraper outputs](/enrichements_images/scrape_linkedin_profile/linkedin_scraper_outputs.png#2358x1336)

Once your output properties are set, click "Run enrichment".


## How much does it cost to scrape a LinkedIn Profile?

Datablist Enrichments work with a credit system. You receive credits with your monthly plan and you can buy non-expiring credits with top-ups.

The Linkedin Profile Scraper enrichment costs 25 credits per profile (50 credits when "Disable cached profiles" is checked).

**A $20 top-up gives you 20,000 credits. The scraping of one profile costs $0,025. You can scrape 800 profiles with a $20 top-up.**

**A $150 top-up gives you 200,000 credits (25% discount). The scraping of one profile costs $0,01875. You can scrape 8000 profiles with a $150 top-up.**

[Learn more about the Datablist Credits System.](/docs/credits)


Extract/Scrape LinkedIn data from profile URLs in a CSV/Excel file - In Bulk

LinkedIn Profile Scraper


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Email Finder" enrichment

Click on the "Enrich" button, and search for "Email Finder".

![Email Finder](/enrichements_images/email_finder/email_finder_store.png#2354x1182)







Get the email address for each contact on a Excel/CSV file - In Bulk

Email Finder


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>

### Step 2: Select the "Instagram Profile Scraper" enrichment

Click on the "Enrich" button in the header, and search for "Instagram Profile Scraper".

![Select Instagram Profile Scraper on the enrichment store](/enrichements_images/instagram_profile_scraper/instagram_profile_scraper_store.png#2343x1288)



Scrape Instagram profiles from a Excel/CSV file

Instagram Profile Scraper

Run ChatGPT based Agent on Excel/CSV lines - In Bulk

AI Agent


## How to run ChatGPT on each Excel or CSV line (in bulk)?

Running ChatGPT prompts in bulk can be a useful approach when you have a list of items and want to generate responses for each of them. 

But ChatGPT's web interface is designed for interactive use, making it challenging to perform bulk operations directly on the chat interface.

With Datablist, you can write a prompt using variables. The prompt will then be run for each item and Datablist will take care of replacing the variables with your item's data.

And if you have used ChatGPT API, you know it can be challenging to deal with rate limits and parallelization. Datablist handles that for you and will retry unsuccessful calls.

### Step-by-step guide

#### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>

#### Step 2: Select the "Ask ChatGPT" enrichment

Click on the "Enrich" button in the header, and search for "Ask ChatGPT/OpenAI".

![Select Ask ChatGPT on the enrichment store](/enrichements_images/ask_chat_gpt/enrichment_store.png#2316x1378)

#### Step 3: Write your prompt with variables

After selecting the enrichment, a drawer opens. Write your prompt and use the characters `{{` to add a variable. All your text-compatible properties (=fields) can be used as variables.

![Define variable](/enrichements_images/ask_chat_gpt/use_variable.png#2080x1280)

You can add a System Prompt to help ChatGPT format its response.

![Add System Prompt](/enrichements_images/ask_chat_gpt/with_system_prompt.png#2146x1401)


#### Step 4: Define where to store the results

ChatGPT returns a text for each item. You must define where this text will be stored. You can create a new property or map an existing property.

![Create properties to store the results](/enrichements_images/ask_chat_gpt/result_properties.png#2314x1374)

#### Step 5: Check the results on 10 items and run on all your data

To avoid mistakes and to let you experiment with different prompts, Datablist runs the prompts on 10 items first. You can see the results in real time. When the results match your expectations, click "Run" to process your remaining items.


## FAQ

### How much does it cost?

This enrichment is free to use. But you need to use your own OpenAI API Key and you will be charged directly by OpenAI.

> **Warning**<br/>
> You must have credits on your OpenAI balance. This enrichment won't work with a free OpenAI account without credits.

### How to create an OpenAI API Key

Create an account on the [OpenAI Platform](https://platform.openai.com/). Then go to the [API Keys page](https://platform.openai.com/api-keys) and click "Create new secret key".

### Can I run ChatGPT on a large CSV?

Datablist [opens large CSV files](/csv-editor) without breaking a sweat. Datablist is the perfect tool to run ChatGPT on a large CSV file.

## Use cases

Running a ChatGPT prompt on a list of items can be beneficial in various scenarios where natural language processing is required. Here's a list of use cases:

### Email intro for cold emailing

Generate initial drafts for emails. Use personal info from each contact profile to write a personalized email.

### Language Translation

ChatGPT is perfect for translating phrases or sentences from one language to another with ease.

### Data Cleaning

ChatGPT can be used to clean your Excel or CSV files. If can correct text cases, fix grammar and typos, normalize company names, etc.

### Social Media Posts

Stay ahead of your social media schedule by generating posts for your social media accounts.

### Product Catalog processing

Generate summaries from product descriptions, or generate descriptions from your product characteristics.

Run ChatGPT/OpenAI on Excel/CSV lines - In Bulk

Ask ChatGPT/OpenAI


## ChatGPT is perfect for translating your CSV/Excel files

ChatGPT is a language model developed by OpenAI. It grasps the contextual meaning of texts with nuances of grammar, syntax, and semantics. 

This makes ChatGPT a perfect technology for translation. This level of precision is essential for translating legal documents, technical manuals, and other sensitive materials where accuracy is paramount.

ChatGPT/OpenAI's versatility shines through its ability to handle a wide range of languages and genres. It can seamlessly translate between over 100 languages, including major and minor tongues, ensuring that users can connect with people from all corners of the globe.

## How much does it cost to translate with ChatGPT?

ChatGPT stands out not only for its linguistic prowess but also for its exceptional cost-efficiency. It is cheaper than Deepl or Google Translate for almost similar translation quality.

Datablist Enrichments work with a credit system. You receive credits with your monthly plan and you can buy non-expiring credits with top-ups.

Datablist ChatGPT/OpenAI translation enrichment costs 1.5 credits for 1000 characters.

**A $20 top-up gives you 20,000 credits. A translation of 1000 characters costs $0,0015. Or $1.5 for 1,000,000 characters.**

**A $150 top-up gives you 200,000 credits (25% discount). A translation of 1000 characters costs $0,001125. Or $1.13 for 1,000,000 characters.**

[Learn more about the Datablist Credits System.](/docs/credits)


## How to translate a CSV/Excel file with ChatGPT?

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of texts.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Translate with OpenAI/ChatGPT" enrichment

Click on the "Enrich" button in the header, and search for "Translate with OpenAI/ChatGPT".

![Select Translate with OpenAI/ChatGPT on the enrichment store](/enrichements_images/translate_chatgpt/translate_chatgpt_enrichment.png#2356x1395)

#### Step 3: Select the target language and the column to translate

After selecting the enrichment, a drawer opens. The first step is to configure the target language for your translations.

Then, you need to select which column (=property) of your data to translate. Use the drop-down button with "Text to translate" to select one of your data columns.

> **Notes**<br />
> This enrichment translates the text from one column. To translate several or call your columns, you have to run the enrichment several times. Once on each column.

![Select target language](/enrichements_images/translate_chatgpt/translate_chatgpt_settings_inputs.png#2054x1361)

### Step 4: Define where to store the results

To avoid losing data, the translated texts will be stored in a new property. In the "Output" section, click on the "+" button to define a new property that will be used to store the translations.

![Create a property to store the results](/enrichements_images/translate_chatgpt/translate_chatgpt_results.png#2048x1370)

#### Step 5: Run the translation

Once your configuration is fine. Click the "Run enrichment" button to process your data.

## FAQ

### How long does it take to translate my data with ChatGPT?

ChatGPT is slower to process text than Google Translate or Deepl. Datablist speeds translations by running parallel ChatGPT tasks.

And for a better user experience, this enrichment runs asynchronously. Once started, the data is sent to our servers that manage the calls to ChatGPT. You don't have to wait in front of your screen for it to finish. Just come back later to get your translated files.



Translate CSV/Excel files with ChatGPT/OpenAI

Translate with ChatGPT/OpenAI


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "LinkedIn Profile Finder" enrichment

Click on the "Enrich" button, and search for "LinkedIn Profile Finder".

![LinkedIn Profile Finder](/enrichements_images/linkedin-finder-name/linkedin-profile-finder-store.png#2358x1214)







Find LinkedIn profile from name in a CSV/Excel file - In Bulk

LinkedIn Profile from name



## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Location Lookup" enrichment

Click on the "Enrich" button, and search for "Location Lookup".

![Location Lookup](/enrichements_images/location_lookup/location_lookup_store.png#2362x1286)






Location Lookup for Excel/CSV lines - In Bulk

Location Lookup

500 free credits on signup => 500 free enrichments.


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Company Domain/LinkedIn Company Page Lookup" enrichment

Click on the "Enrich" button, and search for "Company Domain/LinkedIn Company Page Lookup".

![Company Domain/LinkedIn Company Page Lookup](/enrichements_images/linkedin_lookup/domain_linkedin_lookup.png#2401x1403)


### Step 3: Select a property with Domains or with Linkedin Company Page URLs

Then, select the property (=column) with either LinkedIn Company Page URLs or with websites/domains.

The enrichment automatically detects for each item the lookup operation to perform.

Datablist handles most of the variations possible for domains/websites and LinkedIn Page URLs.

For the company URL source, some compatible formats:
- **Full URL**: https://www.datablist.com/
- **Full URL with path**: https://www.datablist.com/how-to?arg=value
- **Only Domain**: datablist.com

For the LinkedIn Company Page URLs, some compatible formats:
- **Full URL (with ending slash or not)**: https://www.linkedin.com/company/datablist/
- **Regional LinkedIn**: https://fr.linkedin.com/company/datablist/
- **Partial URL**: linkedin.com/company/datablist/

> **Warning** <br />
> Linkedin Company Pages with IDs are not supported.<br />
> ❌ https://www.linkedin.com/company/23423423423

![LinkedIn Company Page Lookup Inputs](/enrichements_images/linkedin_lookup/domain_linkedin_lookup_inputs.png#2381x1404)

And configure outputs. The "LinkedIn Company/Domain Lookup" enrichment exposes 2 outputs:

- **Company Domain** - To get company domains from LinkedIn Company Pages
- **Company LinkedIn Url** - To get LinkedIn Company Pages from company domains or websites

![LinkedIn Company Page Lookup Outputs](/enrichements_images/linkedin_lookup/domain_linkedin_lookup_inputs.png#2410x1394)


> **Important**
> For each item, only one output is returned. If the enrichment detects a domain as input, it only returns the LinkedIn Company Page. If it detects a LinkedIn Company Page, only the domain is returned.


Find Linked Company Page for domain and vice versa  - In Bulk

LinkedIn Company/Domain Lookup

500 free credits on signup => 10,000 free enrichments.


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Name Parser" enrichment

Click on the "Enrich" button, and search for "Name Parser".

![Name Parser](/enrichements_images/name-parser/name-parser-store.png#2350x1308)




Parse names in a Excel/CSV file - In Bulk

Name Parser


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Deepl Translate" enrichment

Click on the "Enrich" button, and search for "Deepl Translate".

![Deepl Translate](/enrichements_images/deepl_translate/deepl_store.png#2358x1240)







Translate a column in a Excel/CSV file with Deepl - In Bulk

Deepl Translator



Managing an email list can feel like trying to keep a garden weed-free. You want it to thrive, but if you don’t pull out the dead addresses, you risk a mess that impacts your campaigns. That’s where a Free Email Validator comes in handy. It helps you clean up invalid and temporary addresses before they can cause problems. Trust me, it’s a lifesaver.

With the Free Email Validator, you get a full analysis of your email list. It runs several checks:

- **Syntax Check** - Catches formatting errors, like missing the "@" symbol.
- **MX Records Check** - Ensures the email domain can actually receive emails. If the domain lacks MX records, it’s invalid.
- **MX Provider name** - Get the name of the email provider. This is useful when you want to send cold emails to matching email providers. Google accounts to Google accounts, Outlook to microsoft accounts, etc.
- **Disposable Email Detection** - Identifies temporary, one-time-use addresses from services like YopMail or Mailinator.
- **Business vs. Generic Emails** - Finds out if the email is a business address (like someone@company.com) or a personal one (like Gmail or Yahoo).

## How to Use the Free Email Validator

### Step 1: Import Email List

Using the Free Email Validator is straightforwar.

Create a new collection in Datablist, click on the "+" button, and select "Import CSV/Excel". [Datablist opens CSV files](/csv-editor) and Excel files.

![Import Email List](/enrichements_images/free-email-validator/create-collection-cleaned.png#2598x1177)

### Step 2: Run the Free Email Validator Enrichment

Click on the "Enrich" button in the header.

![Click Enrich](/enrichements_images/free-email-validator/enrich-free-email-validation.png#2627x1236)

Then select "[Free Email Validator](/enrichments/free-email-validator-bulk)".

![Select Free Email Validator](/enrichements_images/free-email-validator/enrichment-free-email-validation.png#2235x1304)

Choose the property containing the email addresses from your collection.

![Map your email property](/enrichements_images/free-email-validator/map-properties.png#2185x1339)


Configure the output options to store the results. This will include whether the email is valid, error message, domain, is the email from a generic email provider (Gmail, Yahoo, etc.) or a business domain, and the email provider information.

![Map your email property](/enrichements_images/free-email-validator/mx-records-outputs.png#2881x1343)


<aside class="text-center mt-5 mb-5">
    <div class="mb-2">
        <a href="/how-to/email-list-cleaning" className="btn btn-primary btn-large" target="_blank">
            Read our guide for the step by step instructions
        </a>
    </div>
</aside>


## List of MX Providers

The "Free Email Validator" enrichment can return the name of the email provider based on the MX Records.

Here is the list of built-in providers:

- google
- microsoft
- zoho
- yahoo
- safenames
- ovh
- amazon
- gandi
- ionos
- mimecast
- godaddy
- yandex
- apple
- proofpoint
- mailgun
- protonmail
- mail.ru
- barracuda
- namecheap

> **Note:** If the MX Records don't match one of those providers, the full MX Record is returned.


## FAQ

### Why do I need to clean my email list?

Here’s what a clean list gets you:

- Better Open Rates: Emails land in more inboxes and less spam folders.
- Higher Engagement: You’re reaching real people, not just dead accounts.
- Improved Sender Reputation: Email providers like Gmail and Yahoo trust you more when you send to valid addresses.

Free Email Validator


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Google Translate" enrichment

Click on the "Enrich" button, and search for "Google Translate".

![Google Translate](/enrichements_images/google_translate/google_translate_store.png#2360x1178)







Translate a column in a Excel/CSV file with Google Translate - In Bulk

Google Translate


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "LinkedIn Page Finder" enrichment

Click on the "Enrich" button, and search for "LinkedIn Page Finder".

![LinkedIn Page Finder](/enrichements_images/linkedin-page-finder/linkedin-page-finder.png#2352x1190)







Find LinkedIn Pages from company names in a CSV/Excel file - In Bulk

LinkedIn Page from company name

500 free credits on signup => 50,000 free enrichments.


Navigating through rows of data in an Excel file or a CSV file, searching for and extracting phone numbers, can be a tedious task. Imagine if you could streamline this process. Good news—it's possible!

Let's see how the "Phone Number Extractors" lets you effortlessly extract phone numbers in a few clicks.


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Phone Number Extractor" enrichment

Click on the "Enrich" button in the header, and search for "Phone Number Extractor".


![Phone Number Extractor](/enrichements_images/phone_number_extractor/phone_number_store.png#2312x1100)

### Step 3: Configure settings

In the next step, you can configure a country to handle local numbers. This setting is optional.

If the setting is empty, the enrichment extracts all numbers in the international format (starting with + XX ..).
When you define a country, it parses all numbers and analyzes them to check if they match the format for the defined country. If so, it will add the international country code in the extracted value.

A setting is also available to extract the list of countries from the country codes.

![Phone Number Extractor settings](/enrichements_images/phone_number_extractor/phone_extractor_input_settings.png#2312x1372)


### Step 4: Define where to store the results

This enrichment returns a list of extracted numbers (comma separated), and a list of country names (if the "Add country names" setting is enabled). You must define where this text will be stored. You can create a new property or map an existing property.

![Create properties to store the results](/enrichements_images/phone_number_extractor/phone_extractor_outputs.png#2314x1364)


Extract phone numbers from an Excel or CSV file - In Bulk

Phone Number Extractor



## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is perfect for [list building](/use-cases/lead-list-building). With powerful data-cleaning features and enrichments. 

Create a new collection and import your CSV or Excel file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Classification with ChatGPT/OpenAI" enrichment

Click on the "Enrich" button, and search for "Classification with ChatGPT/OpenAI".

![Classification with ChatGPT/OpenAI](/enrichements_images/chatgpt_classification/store.png#2358x1322)



## When to use the ChatGPT text classification?

**Sentiment Analysis**

ChatGPT excels at understanding the nuances of human emotions. Run this enrichment to get the intent by analyzing social media posts, customer reviews, or feedback.

**Language and Country Classification**

Find the language from a text or the country from a city. This simple classification helps write better personalized emails.

**Segment companies**

Once you have extracted texts from a company website, use ChatGPT to segment your list between industries.


## FAQ

### How much does it cost?

This enrichment is free to use. But you need to use your own OpenAI API Key and you will be charged directly by OpenAI.

> **Warning**<br/>
> You must have credits on your OpenAI balance. This enrichment won't work with a free OpenAI account without credits.

### How to create an OpenAI API Key

Create an account on the [OpenAI Platform](https://platform.openai.com/). Then go to the [API Keys page](https://platform.openai.com/api-keys) and click "Create new secret key".



Classification with ChatGPT/OpenAI


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Apollo People Search" enrichment

Click on the "Enrich" button, and search for "Apollo People Search".

![Apollo People Search enrichment](/enrichements_images/apollo_people_search/apollo_people_search.png#2359x1376)






Find profiles using Apollo People Search - In Bulk

500 free credits on signup => 16,000 free detections.


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Detect Language from a Text" enrichment

Click on the "Enrich" button, and search for "Detect Language from a Text".

![Detect Language from a Text](/enrichements_images/language_detection/enrichment_store_detect_language.png#2597x1319)



## Use Cases

### Lead Generation

By identifying the language of a lead's inquiry or information, you can tailor your outreach efforts for better engagement. Language detection allows you to segment leads based on their language and send targeted messages in their preferred tongue, significantly increasing the chance of a positive response.

### Customer Service

Language detection helps route customer inquiries to the appropriate agent who speaks their language. This eliminates the need for translation delays and allows for quicker issue resolution.

### Text Segmentation

When you segment data by language, you ensure you're analyzing information relevant to a specific audience. Imagine analyzing customer reviews in a single pool, containing both positive English feedback and negative Spanish reviews. Language detection allows you to segment these reviews and analyze the sentiment within each language group. This provides a clearer picture of customer satisfaction across different regions.


Detect the Language from texts in a Excel/CSV file - In Bulk

Language Detection


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Entity Name Extraction" enrichment

Click on the "Enrich" button, and search for "Entity Name Extraction".

![Entity Name Extraction](/enrichements_images/entity_extractor/entity_extractor_store.png#2354x1182)






Extract people, company and location names from a Excel/CSV file - In Bulk

Entity Name Extraction


Finding accurate and up-to-date company domains is crucial for sales outreach or to [clean your CRM data](/how-to/data-cleaning). Yet, manually searching for each domain is time-consuming and error-prone. Datablist, a [powerful CSV viewer and editor](/csv-editor), offers unique enrichment tools to help you achieve this. In this article, we'll walk you through how Datablist can find company domains using a list of company names with two effective methods: leveraging a pre-existing database and performing Google searches.

## How to find company domains for a list of company names

The "Find Company domains from Company names" enrichment uses two methods:

- **Method 1: Using company databases** - Datablist uses several databases containing a comprehensive list of company name/domain mappings with their location. This method is quick and reliable for matching company names to their corresponding domains. When setting the "Target Country" parameter, only companies matching the country are returned.

- **Method 2: Using Google** - In cases where the database method doesn't yield results, Datablist uses a fallback method: performing Google searches to fetch the first relevant result matching the company name.

By combining both methods, Datablist offers a powerful dual-approach to ensure you get the most accurate company domains.

## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Find Company domains from Company names" enrichment

Click on the "Enrich" button, and search for "Find Company domains from Company names".

![Find Company domains from Company names](/enrichements_images/name_to_domain/name_to_domain_store_list.png#2275x1390)

### Step 3: Configure settings and select the column with the names

A drawer opens to configure the enrichment.

In the “Settings” section, choose the enrichment workflow. The default workflow uses Google to find domains not listed in the domain or company name database.

The "Target Country" setting lets you select a Country to filter the company databases. This setting is also used to rank Google search results according to the country. When empty, the Google search uses a "United States" location by default.

![Configure workflow and country](/enrichements_images/name_to_domain/settings_map_company_name_1.png#2371x1389)

Then, in the "inputs" section, map the "Company Name" input with the field holding the names. Datablist will automatically discard empty names.

![Find Company domains from Company names](/enrichements_images/name_to_domain/settings_map_company_name_2.png#2374x1327)


### Step 4: Define where to store the company domains

This enrichment returns 2 properties: the domain, and the status for the domain matching. Click on the "+" icon to create new properties to store the data. Or map with existing properties if you already have them created.

![Find Company domains from Company names](/enrichements_images/name_to_domain/map_company_domain.png#2356x1329)


## Use Cases

- **Enriching CRM** - Imagine you're a sales manager with a list of potential leads (company names) but without their contact domains. By uploading the list to Datablist and using the database method, you can swiftly acquire the corresponding company domains, thereby streamlining your outreach efforts.

- **Niche Companies Enrichment** - Suppose you're a market researcher dealing with niche companies not covered by standard databases. Using the Google search method, you can still discover company domains, ensuring your dataset remains enriched and valuable.

- **Email Finding** - In order to find email addresses for a company, you need to have the domain. See [Email Finder](/enrichments/email-finder).
- **Lead Generation** - A simple way to check if a company is worth being contacted is to check its website. Use this domain lookup tool to segment your [lead lists](/use-cases/lead-list-building).


Find the company domains from a CSV/Excel with company names - In Bulk

Find Company domains from Company names


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "WebPage to PDF file" enrichment

Click on the "Enrich" button, and search for "WebPage to PDF file".

![WebPage to PDF file](/enrichements_images/pdf-from-urls/store.png#2358x1170)






Generate PDFs from URLs from a CSV/Excel file

Generate PDF from URLs


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Fetch Meta Information" enrichment

Click on the "Enrich" button, and search for "Fetch Meta Information".

![Fetch Meta Information](/enrichements_images/urls-meta/store.png#2358x1310)






Fetch meta data from a list of URLs in a CSV/Excel file - In Bulk

Fetch meta data from URLs


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Smart Scraper" enrichment

Click on the "Enrich" button, and search for "Smart Scraper".

![Smart Scraper](/enrichements_images/links_scraper/smart-scraper-store.png#2230x1305)


### Step 3: Configure options and enable proxy if needed

The next step is to configure the scraper.

A nice feature is the option to automatically follow "About us" links.
When enabled, the Smart Scraper scans the webpage to find links pointing to an "About us" page. It uses a [list of common "About Us" paths](/learn/scraping/common-url-paths-about-us-pages), as well as link anchors analysis to match "About us" page patterns.

Another option is to define the use of a proxy. Some websites are protected from scraping or have rate limits. You can use a proxy automatically when the Smart Scraper receives an error. The proxy option is useful for e-commerce websites or if you are scraping several pages of the same website.

> **Note:** The cost per URL to scrape is 0.50 credits with the proxy, and 0.10 credits without. When the proxy is used as a fallback, you won't be charged for the proxy if the URL returns a valid response with a simple scraping.

![Connect WebPage URLs input](/enrichements_images/links_scraper/settings_inputs_options.png#2351x1348)

In the advanced settings, you can define blacklist terms to exclude emails or links to be scraped.


### Step4: Select the column with the Webpages as inputs
 
Now, you need to select the column from your collection with the website or webpage to scrape.

Move to the "Input Property" section and select the property using the dropdown menu.


### Step 5: Define where to store extracted texts, links, and email addresses

The enrichment returns extracted texts, email addresses, phone numbers, and social links. Create a property or map to an existing property to store the results.

When multiple phone numbers/links/emails are found, they are returned with a comma between each.

![Connect Texts, Emails and Social links outputs](/enrichements_images/links_scraper/smart-scraper-outputs.png#2365x1289)


## How to use the extracted texts with ChatGPT?

The Smart Scraper not only returns phone numbers, emails, social links, etc. It also returns an aggregation of relevant texts found on the scraped page, including on the "About us" page.

It automatically discards header texts, footer texts, etc., and tries to keep only texts that bring context information.

This text is perfect to be used as input in a ChatGPT prompt.

For example, you can use the extracted texts to segment websites that target B2B and B2C customers.

![Write ChatGPT Prompt using extracted texts](/enrichements_images/links_scraper/chat-gpt-b2b-classification.png#2056x1252)

Giving you the following results:

![B2B/B2C classification results](/enrichements_images/links_scraper/chat-gpt-b2b-results.png#1924x1024)


## Use Cases

### Lead Generation

Gathering email addresses and LinkedIn profile links from webpages is perfect to enrich company data. Sales teams can use this information to reach out to relevant individuals or businesses with targeted sales pitches or marketing campaigns.

### Recruitment and Talent Sourcing

HR professionals and recruiters can use scraped email addresses and LinkedIn profile links to identify potential candidates for job openings. This enables them to proactively reach out to qualified candidates and build a talent pipeline.

Extract texts, LinkedIn profiles, Emails, and Instagram profile links in a webpage - In Bulk

Smart Texts, Links & Email scraper

500 free credits on signup => 5,000 free scrapings.


## Step-by-step guide

### Step 1: Load your CSV or Excel file on Datablist

Create a free account and import your data file. Datablist is a powerful [CSV editor](/csv-editor). Perfect for opening large CSV files or Excel files with a list of items.

Create a new collection and import your file.

<aside class="text-center mb-5">
    <div class="mb-2">
        <a href="https://app.datablist.com/" className="btn btn-primary btn-large" target="_blank">
            Open Datablist
        </a>
    </div>
    <span class="orange-text">Signup for Free</span>
</aside>


### Step 2: Select the "Bulk Scraper" enrichment

Click on the "Enrich" button, and search for "Bulk Scraper".

![Bulk Scraper](/enrichements_images/bulk-scraper/bulk-scraper.png#2384x1090)

### Configure CSS Selectors

The Bulk Scraper uses two ways to extract data from the HTML page: [CSS Selectors](#configure-css-selectors) and [Regular Expressions](#configure-regular-expressions).

CSS selectors allow you to target specific parts of an HTML document to extract information.

A CSS selector is defined with the following information:

- **CSS Selector** - The CSS path to the HTML element. [Read this guide to learn how to write CSS Selector.](https://www.w3schools.com/cssref/css_selectors.asp)
- **CSS Selector Content** - Data to extract for the HTML element.
    - **InnerText** - Extract the text inside the HTML element. If the HTML element contains nested HTML elements, their texts are also extracted.
    - **HTML** - Extract the outer HTML code for the HTML element
    - **Attribute** - Extract a specific attribute text from the HTML element.
- **Selector Attribute** - Available when the `CSS Selector Content` is set on `Attribute`. Define the attribute to extract. Example: href, rel, title.


> **Note:** When several elements match a CSS selector, all the results are returned concatenated with a semicolon (`;`)


![CSS Selector](/enrichements_images/bulk-scraper/css-selector.png#1889x1189)

Selector Attribute field available on `CSS Selector Content: Attribute`.

![CSS Selector Attribute](/enrichements_images/bulk-scraper/css-selector-attribute.png#1828x1079)


#### Examples of CSS Selectors

To learn how to write CSS Selector paths, [please read this guide](https://www.w3schools.com/cssref/css_selectors.asp).

--- 

Getting the text of an HTML element.

```
<div class="section product-data">
    <div class="product-name">New Phone</div>
</div>
```

The CSS selector would be `.section.product-data .product-name` with the `CSS Selector Content` to **InnerText**.

--- 

Getting the text of the first div after a custom HTML attribute.

```
<div data-testid="block-content">
    <div>Info To Scrape</div>
    <div>Useless Info</div>
    <div>Useless Info</div>
</div>
```

The CSS selector would be `[data-testid="block-content"] > div:first-child` with the `CSS Selector Content` to **InnerText**.

--- 

Getting the URLs for links:

```
<div class="social-media">
    <a href="https://fr.linkedin.com/company/datablist">Linkedin</a>
    <a href="https://www.twitter.com/datablist">Twitter</a>
</div>
```

The CSS selector would be `.social-media` with the `CSS Selector Content` to `Attribute` and the `Attribute` to **href**.

--- 

#### How to test CSS Selectors

An easy way to test your CSS Selectors before running them in bulk is to use your browser console.

To test for `InnerText`:

```
Array.from(document.querySelectorAll('{css-selector-path}')).map(elem => elem.textContent).join(';')
```

![Test CSS Selector InnerText](/enrichements_images/bulk-scraper/test-css-selector.png#2422x1182)


To test for `HTML`:

```
Array.from(document.querySelectorAll('{css-selector-path}')).map(elem => elem.outerHTML).join(';')
```

![Test CSS Selector InnerText](/enrichements_images/bulk-scraper/test-css-html.png#2410x1276)


To test for the content of an `Attribute`:

```
Array.from(document.querySelectorAll('{css-selector-path}')).map(elem => elem.getAttribute('{attribute}')).join(';')
```

![Test CSS Selector Attribute](/enrichements_images/bulk-scraper/test-css-attribute.png#2414x1098)


If you need help writing your CSS Selectors, [please contact us](https://docs.google.com/forms/d/e/1FAIpQLSeAZfqCjOg-ok7yYAwz4hmKxhPOeLMIwZrLozsro5HTQhrsxw/viewform?usp=sf_link).


### Configure Regular Expressions

The second way to scrape data from several URLs is to use regular expressions. The bulk scraper matches the RegEx against the HTML code source.

If the pattern contains capturing groups, they are returned. And if there are no groups, the scraper returns the strings matching the whole pattern.

![Bulk Scrape with Regular Expressions](/enrichements_images/bulk-scraper/bulk-scraper-regex.png#1866x1299)


#### Capturing groups or pattern-matching

When writing a Regex, you can add a capturing group using **parenthesis**. When a capturing group is defined, the bulk scraper will return only the group text.

For example, in the HTML code:

![Example HTML Code](/enrichements_images/bulk-scraper/regex-expression.png#960x540)

To capture only the "US" text from the Shopify.country line, you would write:

```Shopify\.country\s=\s"(\w+)";```

Notice the parenthesis in **(\w+)**.

To capture the whole line, you would write:

```Shopify\.country\s=\s"\w+";```

Notice I removed the parenthesis.


## Use Cases

### Lead Generation

Bulk scraping allows you to enrich URLs from various sources, such as directories, social media platforms, forums, etc.. Using CSS Selector, bulk scraping lets you get structured information from HTML pages.

### Price Monitoring

E-commerce businesses can use URL scraping to monitor competitor websites and track product prices, discounts, and promotions. This information can be used for competitive intelligence and pricing strategies to stay competitive in the market.

### Job Board Scraping

Job boards often contain valuable job postings information. Scraping URLs from job boards allows businesses to aggregate job postings automatically, providing valuable insights into hiring trends, job requirements, and competitor recruitment strategies.


Scrape URLs with CSS Selectors and/or Regular Expressions - In Bulk

Bulk Scraper

Use Deepl machine translation to translate your texts. Deepl provides the world's most accurate and nuanced machine translation. You can use your own Deepl API Key when you are on the Datablist Standard Plan.

<h2 id="user-content-step-by-step-guide"><a href="#step-by-step-guide" aria-hidden="true" tabindex="-1"><span></span></a>Step-by-step guide</h2>
<h3 id="user-content-step-1-load-your-csv-or-excel-file-on-datablist"><a href="#step-1-load-your-csv-or-excel-file-on-datablist" aria-hidden="true" tabindex="-1"><span></span></a>Step 1: Load your CSV or Excel file on Datablist</h3>
<p>Create a free account and import your data file. Datablist is a powerful <a href="/csv-editor">CSV editor</a>. Perfect for opening large CSV files or Excel files with a list of items.</p>
<p>Create a new collection and import your file.</p>
<h3 id="user-content-step-2-select-the-deepl-translate-enrichment"><a href="#step-2-select-the-deepl-translate-enrichment" aria-hidden="true" tabindex="-1"><span></span></a>Step 2: Select the "Deepl Translate" enrichment</h3>
<p>Click on the "Enrich" button, and search for "Deepl Translate".</p>
<p><img src="/enrichements_images/deepl_translate/deepl_store.png#2358x1240" alt="Deepl Translate"></p>


Other enrichments

Translate a column in a Excel/CSV file with Deepl - In Bulk

Step-by-step guide

Step 1: Load your CSV or Excel file on Datablist

Step 2: Select the "Deepl Translate" enrichment

Enrichment Reference

Settings

Inputs

Outputs

Join the future of list management