Find LinkedIn profiles fast and save clean lead data without manual copy and paste. Sales and marketing teams can search by keyword and location, then get a ready Excel file and a synced NocoDB table for outreach. It is a simple way to build a targeted list and enrich it with useful details.

Here is how it works. You start the workflow by hand and set the search inputs like keyword, region, language, and result count. SerpAPI runs a Google search limited to LinkedIn, and the results are split into single items. Fields are mapped, then OpenAI reads each result to detect the company name and turn follower text into a real number. Extra metadata is removed. The cleaned data is merged and exported to an Excel download and stored in NocoDB for future use. This avoids direct scraping, keeps costs down, and delivers consistent results.

You will need accounts for SerpAPI, OpenAI, and NocoDB. Expect to cut list building time by a large margin and raise data quality with normalized follower counts. Great for SDR teams, agencies, and founders who need quick prospect lists for a specific market or region.

• Manual start to control when searches run
• Search parameter mapping for keyword, location, language, and result count
• SerpAPI request to Google with a LinkedIn site filter
• Split results into single items for clean processing
• Field edits to keep only useful data from search results
• OpenAI step to detect company name and convert followers to a number
• Merge step to combine original fields with enriched values
• Export to Excel for download and write to NocoDB for storage

• Reduce manual prospecting from hours to minutes
• Automate most steps of profile discovery and cleanup
• Improve data quality with normalized follower counts
• Handle larger search volumes without extra effort
• Unify output into Excel and NocoDB for easy sharing
• Lower risk of blocks by using SerpAPI for Google search

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with SerpAPI, OpenAI and NocoDB. See the Tools Required section above for links to create accounts with these services.
3. In SerpAPI, create an API key from your account dashboard. Keep it ready for n8n credentials.
4. In OpenAI, create an API key from the API keys page. Copy the key for n8n setup.
5. In NocoDB, create a project and a table with fields for name, profile URL, title, location, company, and followers number. Get your API token.
6. In n8n, open the Google search node for SerpAPI, choose Credential to connect with, click Create new credential, select SerpAPI, paste your API key, name the credential clearly, and save.
7. In n8n, open the OpenAI node, choose Credential to connect with, click Create new credential, select OpenAI API Key, paste the key, name it, and save.
8. In n8n, open the NocoDB node, choose Credential to connect with, click Create new credential, select NocoDB Token, enter base URL and API token, name it, and save.
9. Open the Search parameter node and fill in keyword, location, language, country code, and number of results. Save your changes.
10. Run a test with the Manual Trigger. Check the SerpAPI node output to confirm organic results are returned.
11. Inspect the SplitOut and Edit Fields nodes to verify each item has title, link, and snippet mapped correctly.
12. Open the OpenAI node and run a small test. Confirm it returns a company name and a numeric follower value. If empty, adjust the prompt or reduce result count.
13. Check the Merge and Convert to File nodes. Download the Excel file and confirm columns look correct.
14. Verify the NocoDB node writes rows to the right table. If you see errors, confirm table field names and your API token permissions.