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

1861 views

2/3/2026

PostgreSQL Data Transformation Webhooks Cost Calculation Database Query

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

Collect LinkedIn Profiles with AI Processing using SerpApi, OpenAI, and NocoDB

This n8n workflow automates the process of collecting LinkedIn profile data, enriching it with AI-generated summaries, and storing it in NocoDB. It's designed for lead generation, recruitment, or market research, allowing you to easily gather and analyze professional profiles.

What it does

This workflow performs the following key steps:

Manual Trigger: Initiates the workflow manually, allowing you to control when the data collection begins.
HTTP Request (SerpApi): Sends a request to SerpApi to search for LinkedIn profiles based on a predefined query. This node is configured to fetch search results from LinkedIn.
Split Out: Takes the array of search results from SerpApi and processes each result individually, ensuring that each LinkedIn profile is handled as a separate item.
Edit Fields (Set): Extracts and structures relevant data points from each LinkedIn profile search result, such as the profile URL, title, and snippet.
HTTP Request (LinkedIn Profile Scraper): For each individual LinkedIn profile URL, it makes another HTTP request to a LinkedIn profile scraper (likely a custom endpoint or another SerpApi call for detailed profile data).
Merge: Combines the initial search result data with the detailed profile data obtained from the scraper, creating a comprehensive data item for each profile.
Edit Fields (Set): Further processes the merged data, potentially cleaning or reformatting fields for consistency.
OpenAI: Sends the collected profile data (e.g., the "about" section or experience) to OpenAI to generate an AI-powered summary or extract key insights.
Edit Fields (Set): Incorporates the AI-generated summary back into the profile data.
NocoDB: Stores the complete and enriched LinkedIn profile data, including the AI summary, into a NocoDB base.
Convert to File: (Optional/Disconnected) This node is present but not connected in the provided JSON, suggesting it might be for converting the final data into a file format like CSV, but it's not active in the current flow.

Prerequisites/Requirements

To use this workflow, you will need:

n8n Instance: A running instance of n8n.
SerpApi Account & API Key: For searching and potentially scraping LinkedIn profiles.
OpenAI Account & API Key: For AI-powered text processing and summarization.
NocoDB Instance & Credentials: A NocoDB base and table configured to store the LinkedIn profile data.
LinkedIn Profile Scraper (HTTP Endpoint): An accessible HTTP endpoint that can scrape detailed LinkedIn profile information. This could be a custom service or another API.

Setup/Usage

Import the Workflow: Download the JSON provided and import it into your n8n instance.
Configure Credentials:
- Set up your SerpApi credentials in n8n.
- Set up your OpenAI credentials in n8n.
- Set up your NocoDB credentials in n8n, ensuring they have access to the target base and table.
Configure HTTP Request Nodes:
- SerpApi HTTP Request: Update the URL and parameters to reflect your specific search query (e.g., q=software+engineer+linkedin&engine=linkedin_profiles). Ensure your SerpApi API key is correctly passed (e.g., in headers or as a query parameter).
- LinkedIn Profile Scraper HTTP Request: Update the URL to point to your LinkedIn profile scraping service and ensure it correctly receives the LinkedIn profile URL from the previous nodes.
Configure OpenAI Node: Adjust the prompt and model in the OpenAI node to suit the type of summary or analysis you want to perform on the LinkedIn profiles.
Configure NocoDB Node: Specify the correct NocoDB base ID, table name, and map the incoming data fields to your NocoDB table columns.
Execute Workflow: Click "Execute Workflow" in the n8n editor to run the workflow manually. You can also set up a schedule trigger if you want it to run automatically at intervals.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

By higashiyama

Auto-reply & create Linear tickets from Gmail with GPT-5, gotoHuman & human review

This workflow automatically classifies every new email from your linked mailbox, drafts a personalized reply, and creates Linear tickets for bugs or feature requests. It uses a human-in-the-loop with gotoHuman and continuously improves itself by learning from approved examples. How it works The workflow triggers on every new email from your linked mailbox. Self-learning Email Classifier: an AI model categorizes the email into defined categories (e.g., Bug Report, Feature Request, Sales Opportunity, etc.). It fetches previously approved classification examples from gotoHuman to refine decisions. Self-learning Email Writer: the AI drafts a reply to the email. It learns over time by using previously approved replies from gotoHuman, with per-classification context to tailor tone and style (e.g., different style for sales vs. bug reports). Human Review in gotoHuman: review the classification and the drafted reply. Drafts can be edited or retried. Approved values are used to train the self-learning agents. Send approved Reply: the approved response is sent as a reply to the email thread. Create ticket: if the classification is Bug or Feature Request, a ticket is created by another AI agent in Linear. Human Review in gotoHuman: How to set up Most importantly, install the gotoHuman node before importing this template! (Just add the node to a blank canvas before importing) Set up credentials for gotoHuman, OpenAI, your email provider (e.g. Gmail), and Linear. In gotoHuman, select and create the pre-built review template "Support email agent" or import the ID: 6fzuCJlFYJtlu9mGYcVT. Select this template in the gotoHuman node. In the "gotoHuman: Fetch approved examples" http nodes you need to add your formId. It is the ID of the review template that you just created/imported in gotoHuman. Requirements gotoHuman (human supervision, memory for self-learning) OpenAI (classification, drafting) Gmail or your preferred email provider (for email trigger+replies) Linear (ticketing) How to customize Expand or refine the categories used by the classifier. Update the prompt to reflect your own taxonomy. Filter fetched training data from gotoHuman by reviewer so the writer adapts to their personalized tone and preferences. Add more context to the AI email writer (calendar events, FAQs, product docs) to improve reply quality.

By gotoHuman

353

Generate Funny AI Videos with Sora 2 and Auto-Publish to TikTok

This automation creates a fully integrated pipeline to generate AI-powered videos, store them, and publish them on TikTok — all automatically. It connects OpenAI Sora 2, and Postiz (for TikTok publishing) to streamline content creation. --- Key Benefits ✅ Full Automation – From text prompt to TikTok upload, everything happens automatically with no manual intervention once set up. ✅ Centralized Control – Google Sheets acts as a simple dashboard to manage prompts, durations, and generated results. ✅ AI-Powered Creativity – Uses OpenAI Sora 2 for realistic video generation and GPT-5 for optimized titles. ✅ Social Media Integration – Seamlessly posts videos to TikTok via Postiz, ready for your audience. ✅ Scalable & Customizable – Can easily be extended to other platforms like YouTube, Instagram, or LinkedIn. ✅ Time-Saving – Eliminates repetitive steps like manual video uploads or caption writing. --- How it works This workflow automates the end-to-end process of generating AI videos and publishing them to TikTok. It is triggered either manually or on a recurring schedule. Trigger & Data Fetch: The workflow starts by checking a specified Form for new entries. It looks for rows where a video has been requested (a "PROMPT" is filled) but not yet generated (the "VIDEO" column is empty). AI Video Generation: For each new prompt found, the workflow sends a request to the Fal.ai Sora 2 model to generate a video. It then enters a polling loop, repeatedly checking the status of the generation request every 60 seconds until the video is "COMPLETED". Post-Processing & Upload: Once the video is ready, the workflow performs several actions in parallel: Fetch Video & Store: It retrieves the final video URL, downloads the video file Generate Title: It uses the OpenAI GPT-4o-mini model to analyze the original prompt and generate an optimized, engaging title for the video. Publish to TikTok: The video file is uploaded to Postiz, a social media scheduling tool, which then automatically publishes it to a connected TikTok channel, using the AI-generated title as the post's caption. --- Set up steps To make this workflow functional, you need to complete the following configuration steps: Prepare the Google Sheet: Create a Form with at least "PROMPT", "DURATION", and "VIDEO" fields. Configure Fal.ai for Video Generation: Create an account at Fal.ai and obtain your API key. In both the "Create Video" and "Get status" HTTP Request nodes, set up the "Header Auth" credential. Set the Name to Authorization and the Value to Key YOURAPIKEY. Set up TikTok Publishing via Postiz: Create an account on Postiz and connect your TikTok account to get a Channel ID. Obtain your Postiz API key. In the "Upload Video to Postiz" and "TikTok" (Postiz) nodes, configure the API credentials. In the "TikTok" node, replace the placeholder "XXX" in the integrationId field with your actual TikTok Channel ID from Postiz. (Optional) Configure AI Title Generation: The "Generate title" node uses OpenAI. Ensure you have valid OpenAI API credentials configured in n8n for this node to work. --- Need help customizing? Contact me for consulting and support or add me on Linkedin. Header 2

By Davide

24772