This free Google Sheet and script finds the LinkedIn profile URL for a supplied list of contact and company names.
1) Get an API Key from OpenAI.com. You will receive $18 worth of free tokens as a first-time user.
2) Get an API Key for the Bing Web Search API (free plan).
2) Make a copy of this Google Sheet to your own Google account.
Once you have used up your free API credits, I estimate the OpenAI API costs to be approximately $0.03 per 100 rows of data.
Bing Web Search API
The free tier includes a maximum of 1,000 API requests (rows) per month. The pricing for more extensive use is available here.
The script loops through all rows in the ‘Data’ sheet where a name and company name exists. A search is performed on Bing as follows “site:linkedin.com ‘[Name]’ ‘[Company Name]'”.
The top ten search results are then passed to GPT3.5 with an instruction to determine which of the URLs is most likely to be the correct LinkedIn profile for the name provided.
Do take a look at the code behind this function by clicking Extensions > Apps Script from the main menu and feel free to adapt it to different use cases. All of the code was generated by GPT4.
Although I can’t offer individual support for this free script, please let me know if you run into any bugs or have thoughts on how the script could be adapted.