Automate LinkedIn Talent Profiling & Summaries with Decodo, Gemini & Google Sheets

Who this is for

This workflow is built for recruiters, HR professionals, talent acquisition teams, and AI-powered recruitment startups who need to analyze LinkedIn profiles at scale.

It’s ideal for anyone looking to turn raw LinkedIn data into structured, ATS-ready candidate profiles and summarized professional insights automatically.

What problem this workflow solves

Recruiters spend countless hours manually reviewing LinkedIn profiles, extracting details like experience, skills, education, and crafting summaries for ATS or reporting.

This process is time-consuming, inconsistent, and error-prone.

This workflow automates that process — from profile scraping to data structuring and AI-driven summarization, allowing recruiters to instantly generate standardized talent profiles.

What this workflow does

The workflow integrates Decodo , Google Gemini , and Google Sheets to perform automated LinkedIn talent profiling.
Here’s how it works step-by-step:

1. Input Setup

   • The workflow begins when the user executes it manually or passes a LinkedIn profile URL.
   • The input includes url (LinkedIn profile link) and geo (location, e.g., India).

2. Profile Extraction with Decodo

   • The Decodo node scrapes structured data from the LinkedIn profile (headline, experience, skills, education, etc.).
   • Output: Detailed text-based content of the LinkedIn profile.

3. AI Processing and Enrichment (Google Gemini)

   • Structured Data Extractor Node parses the scraped data into JSON Resume Schema using Gemini AI.
   • The Summarize Content Node uses Gemini AI to produce a short, professional summary of the candidate’s profile.
   • The two Gemini nodes ensure both structured and human-readable data formats are available.

4. JSON Parsing & Merging

   • The Code Node cleans and parses the JSON output from the AI for reliable downstream use.
   • The Merge Node combines both structured profile data and the AI-generated summary.

5. Data Storage in Google Sheets

   • The Google Sheets Node appends or updates the record, storing the structured JSON and summary into a connected spreadsheet.
   • This creates a live repository of candidate profiles with summaries for quick access or ATS integration.

6. End Output

   • A unified, machine-readable profile in JSON + an executive-level summary suitable for HR review or downstream automation.

Setup Instructions

Prerequisites

• n8n account with workflow editor access
• Decodo API credentials - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard

• Google Gemini (PaLM) API access
• Google Sheets OAuth credentials

Setup Steps

1. Import the workflow into your n8n instance.

2. Configure Credentials

   • Add your Decodo API credentials in the Decodo node.
   • Connect your Google Gemini (PaLM) credentials for both AI nodes.
   • Authenticate your Google Sheets account.

3. Edit Input Node

   • In the Set the Input Fields node, replace the default LinkedIn URL with your desired profile or dynamic data source.

4. Run the Workflow

   • Trigger manually or via webhook integration for automation.
   • Verify that structured profile data and summary are written to the linked Google Sheet.

How to customize this workflow to your needs

• Bulk Profile Input
  Connect the “Set Input” node to a Google Sheet or CSV input for batch LinkedIn URLs.

• Alternate Output Format
  Instead of Google Sheets, connect to Notion, Airtable, or PostgreSQL for centralized profile databases.

• Advanced Summaries
  Modify the Summarize Content Gemini prompt to generate more specialized summaries — e.g., "Leadership Potential Summary" or "Technical Fit Analysis"

• Resume Comparison Feature
  Add another Gemini node to compare a candidate’s profile against a job description and output a fit score or gap analysis.

• Notification Integration
  Use Slack or Gmail nodes to send alerts when a new candidate summary is generated.

• Language Localization
  Add a language detection step before summarization to support multilingual summaries.

Summary

The Automated LinkedIn Talent Profiling & Summary via Decodo + Google Gemini workflow streamlines recruitment intelligence by automating every step of LinkedIn profile research:

• Scraping (via Decodo)
• Structuring (via Gemini JSON Extraction)
• Summarizing (via Gemini Summarizer)
• Storing results (in Google Sheets)

This workflow empowers recruiters to analyze hundreds of profiles within minutes, ensuring data consistency, faster candidate evaluation, and smarter hiring decisions — powered by Bright Data scraping intelligence and Google Gemini’s AI reasoning.