Block 1 - Manual Trigger
- Type / Role
- n8n-nodes-base.manualTrigger - manualTrigger
- Config choices
- Version 1
Collect LinkedIn profiles with AI processing using SerpAPI, OpenAI, and NocoDB
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
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 [Noco...
Best for
- Lead Generation automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.manualtrigger, n8n-nodes-base.httprequest, n8n-nodes-base.set, n8n-nodes-base.stickynote, n8n-nodes-base.converttofile, n8n-nodes-base.splitout, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.merge
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Askan.
Original n8n.io source1.1 Workflow description
- Title
- Collect LinkedIn profiles with AI processing using SerpAPI, OpenAI, and NocoDB
- Workflow name
- 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 database. It tries to avoid using costly services and should be n8n beginner friendly. It uses the 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 to conduct Google search of the respective LinkedI profiles
- With 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
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".
Set up a free account at serpapi.com and get API credentials to enable good Google search results
Set up an API account at openai.com and get API key
Set up a nocodb.com account (or self-host) and get the API credentials
Create the credentials for serpapi.com, opemnai.com and nocodb.com in n8n.
Set up a table in NocoDB with the fields indicated in the note above the NocoDB node
Follow the instructions as detailed in the notes above individual nodes
When the workflow is finished, open the Excel node and click download if you need the Excel file
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Google search w/ SerpAPI
- Type / Role
- n8n-nodes-base.httpRequest - httpRequest
- Config choices
- Version 4.2
Block 3 - Edit Fields
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 4 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 5 - Sticky Note2
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 6 - Sticky Note3
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 7 - Sticky Note4
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 8 - Discard meta data
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 9 - LinkedIn profiles in Excel for download
- Type / Role
- n8n-nodes-base.convertToFile - convertToFile
- Config choices
- Version 1.1
Block 10 - Sticky Note12
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 11 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 12 - Sticky Note10
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 13 - Sticky Note13
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 14 - Sticky Note14
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 15 - Search parameter
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 16 - Turn search results into individual items
- Type / Role
- n8n-nodes-base.splitOut - splitOut
- Config choices
- Version 1
Block 17 - Company name & followers
- Type / Role
- @n8n/n8n-nodes-langchain.openAi - openAi
- Config choices
- Version 1.8
Block 18 - Generate final data via merge
- Type / Role
- n8n-nodes-base.merge - merge
- Config choices
- Version 3.1
Block 19 - Sticky Note5
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 20 - Sticky Note9
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 21 - Sticky Note11
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 22 - Store data in a NocoDB table
- Type / Role
- n8n-nodes-base.nocoDb - nocoDb
- Config choices
- Version 3
Block 23 - Sticky Note15
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
3. Summary Table
| Workflow | Collect LinkedIn profiles with AI processing using SerpAPI, OpenAI, and NocoDB |
|---|---|
| Complexity | advanced |
| Nodes | 23 |
| Categories | Lead Generation, AI Summarization |
| Author | Askan |
| Published | 07 May 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/3920/3920.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Collect LinkedIn profiles with AI processing using SerpAPI, OpenAI, and NocoDB do?
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 [Noco...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation, AI Summarization use case.