Search for the LinkedIn URL using a company name. Works well when the company name contains extra words that prevent exact matching with databases.

Your goal is to find the LinkedIn company url for a company name.
If the company is a country subsidiary, we want the parent company LinkedIn url.
You will do that by first removing any country information from the company name. 
Then you will search on Google for a LinkedIn Company link matching the parent company name. A LinkedIn company name has the following format linkedin.com/company/
If not found, do a search on Google to get the website for the parent company name and scrape the website to find the LinkedIn company url.

The company name to process is: account %CompanyName%

How to use this prompt on a CSV file?

Datablist allows you to take an entire CSV file and run prompts directly on every line. Whether you're cleaning data, generating summaries, or transforming text, this method saves hours.

Open Datablist (it's free)

The great news is that the prompt you need is already available in Datablist under the "Templates" section. No need to start from scratch! Simply select the template that fits your task, and it’s ready to run on every line of your CSV. This makes it even easier to transform your data with just a few clicks.

Import your CSV file in Datablist. Then select "Enrich" from the header.

Select Enrich
Select Enrich

Then select the template: Company Name to LinkedIn Url

Select Enrich
Select Template

Replace the variables from the prompt with your collection's properties using {{

Use your data
Define variables using your collection's properties

Note on AI Agent prompts

This prompt is made for Datablist AI Agent enrichment. An AI Agent is a smart tool that uses artificial intelligence (AI) to perform tasks for you. It can browse websites, use Google to find information and interact with different online services. This means it can help you with real-time data and up-to-date answers.

On the other hand, the ChatGPT API can only analyze the input text and respond based on its existing knowledge. It doesn’t have the ability to access the internet or gather new information on its own.

An AI Agent provides a more dynamic experience by pulling in real-time data, while the ChatGPT API relies on pre-existing knowledge to respond to queries.

When you interact directly on https://chatgpt.com/, you are interacting with an Agent. Sometimes it goes online to provide extra information for your prompt (but not often). However other tools that are connected to ChatGPT use the API. So remember that this prompt cannot be used in another tool that calls the ChatGPT API.

Datablist AI Agent runs an agent on every line of your CSV.