Collect LinkedIn profiles with AI processing using SerpAPI, OpenAI, and NocoDB

What problem does this solve?

It fetches LinkedIn profiles for a multitude of purposes based on a keyword and location via Google search and stores them in an Excel file for download and in a [NocoDB](NocoDB.com) database. It tries to avoid using costly services and should be n8n beginner friendly. It uses the [serpapi.com](SerpAPI.com) to avoid being blocked by Google Search and to process the data in an easier way.

What does it do?

- Based on criteria input, it searches LinkedIn profiles - It discards unnecessary data and turns the follower count into a real number - The output is provided as an Excel table for download and in a NocoDB database

How does it do it?

- Based on criteria input, it uses [serpAPI.com](serpAPI.com) to conduct Google search of the respective LinkedI profiles - With [OpenAI.com](OpenAI.com) the name of the respective company is being added - With OpenAI.com the follower number e.g., 300+ is turned into a real number: 300 - All unnecessary metadata is being discarded - As an output an Excel file is being created - The output is stored in a nocodb.com table

Step-by-step instruction

1. Import the Workflow: Copy the workflow JSON from the "Template Code" section below. Import it into n8n via "Import from File" or "Import from URL".