Personalized sales outreach from LinkedIn job signals with Apify & Google Gemini — n8n 워크플로

높음 복잡도 트리거23개의 노드 AI👁 322회 조회작성자: Intuz

개요

This n8n template from Intuz provides a complete and automated solution for identifying high-intent leads from LinkedIn job postings and automatically generating personalized outreach emails.

Disclaimer Community nodes are used in this workflow.

Who’s this workflow for? B2B Sales Teams & SDRs Recruitment Agencies & Tech Recruiters Startup Founders Growth Marketing Teams

How it works

  1. Scrape Hiring Signals: The workflow starts by using an Apify scraper to find companies actively hiring for s

사용된 노드

Google SheetsHTTP RequestCodeBasic LLM ChainStructured Output ParserGoogle Gemini Chat Model

워크플로 미리보기

▶️ Start Workflow
Manually triggers the entire lead generation process.
Run the LinkedIn Job Scraper from Apify
Scrape LinkedIn Job Postings:
Uses Apify to find companies that are actively hiring b
Get dataset Items
Collect Scraped Data:
Retrieves the list of job postings and company details
Checks Company Size < 250
Filter by Company Size:
Only allows companies with fewer than 250 employees to
Rmeove Duplicate Entries
Rmeove HR Related Companies
Prepare Final Company Details
Check domain Existence
Limit Company Search
Apollo Get Targeted Personnel
Find Decision-Makers:
Searches Apollo.io using the company domain to find key
Sanitising Person Details
Clean Person Data:
Structures the contact details and removes duplicates t
Apollo Email Finder
Find Verified Emails:
For each contact, this node asks Apollo.io to find thei
Sanitising Email Details
Isolate Email Data:
Prepares the found email addresses for merging
Merge Data
Combine Data Streams:
Merges the company data, the person data, and the email
Structuring Complete Details of Person
Create Final Lead Profile:
Combines all three data streams into a single, complete
Save Leads to Google Sheets
Appends each complete lead profile as a new row in the
Fetching Leads Data
Read Leads for AI:
Reads the newly saved leads from the sheet to begin the
Validates Email Id and Email Content
Check Before AI Processing:
Filters for leads that have a valid email but do NOT ye
Apply Final Filter
Applies a final condition before sending data to the AI
Lead Email Generator
AI Prompt Engine:
Takes the lead data, combines it with the prompt, and s
Google Gemini Chat Model
Google Gemini Model:
The AI model that actually writes the email based on th
Update Sheet with Email
Update Sheet with AI Email:
Saves the generated subject and email body back into th
Structured Output Parser
Format AI Output:
Takes the raw text from Gemini and structures it into c
Need Help?
We develop tailored workflow to save youe valuable time
Email: ge
modelparser
Update Sheet with Email
Google Gemini Chat Model
Structured Output Parser
W
When clicking ‘Execute w…
R
Remove Duplicates
R
Run the LinkedIn Job Scr…
G
Get dataset Items
C
Checks Company Size < 250
R
Removes HR Related Indus…
Prepare Final Company De…
C
Checks Domain Existence
Apollo Get Targeted Pers…
Apollo Email Finder
Sanitising Email Details
Structuring Complete Det…
Adding Leads to Sheets
Fetching Leads Data
V
Validates Email Id and E…
Lead Email Generator
L
Limit Companies Search
Sanitising Person Details
M
Merge Data
F
Filter for Batching
23 nodes24 edges

작동 원리

  1. 1

    트리거

    워크플로는 트리거 트리거로 시작합니다.

  2. 2

    처리

    데이터가 23개의 노드를 통해 흐릅니다, connecting @apify/n8n-nodes-apify.apify, chainllm, code.

  3. 3

    출력

    워크플로가 자동화를 완료하고 구성된 대상에 결과를 전달합니다.

노드 세부 정보 (23)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
CO

Code

code

#3
BA

Basic LLM Chain

n8n-nodes-langchain.chainLlm

#4
ST

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

#5
GO

Google Gemini Chat Model

n8n-nodes-langchain.lmChatGoogleGemini

#6

이 워크플로 가져오는 방법

  1. 1오른쪽의 JSON 다운로드 버튼을 클릭하여 워크플로 파일을 저장합니다.
  2. 2n8n 인스턴스를 열고 워크플로 → 새로 만들기 → 파일에서 가져오기로 이동합니다.
  3. 3다운로드된 personalized-sales-outreach-from-linkedin-job-signals-with-apify-google-gemini 파일을 선택하고 가져오기를 클릭합니다.
  4. 4각 서비스 노드에 대한 자격 증명(API 키, OAuth 등)을 설정합니다.
  5. 5워크플로 테스트를 클릭하여 모든 것이 작동하는지 확인한 후 활성화합니다.

또는 n8n → JSON에서 가져오기에 직접 붙여넣기:

{ "name": "Personalized sales outreach from LinkedIn job signals with Apify & Google Gemini", "nodes": [...], ...}

통합

@apify/n8n-nodes-apify.apifychainllmcodefiltergooglesheetshttprequestiflimitlmchatgooglegeminimanualtriggermergeoutputparserstructuredremoveduplicates

이 워크플로 가져오기

한 번의 클릭으로 다운로드 및 가져오기

JSON 다운로드n8n.io에서 보기
노드23
복잡도high
트리거trigger
조회수322
카테고리AI

제작자

Intuz

Intuz

@intuz

태그

@apify/n8n-nodes-apify.apifychainllmcodefiltergooglesheetshttprequestiflimitlmchatgooglegeminimanualtrigger

n8n을 처음 사용하시나요?

n8n은 무료 오픈소스 워크플로 자동화 도구입니다. 자체 호스팅하거나 클라우드 버전을 사용하세요.

n8n 무료로 시작하기 →

Related AI Workflows

AGCOFIGM+10
high

Automate Digital Product Delivery: Stripe to Gmail via n8n

Transform your post-purchase operations with this high-performance n8n workflow designed for digital creators and SaaS founders. Instead of manual fulfillment, this automation acts as a 24/7 digital concierge. It begins by scanning Stripe for successful transactions, cross-referencing buyer data against a centralized Google Sheets inventory to identify the correct digital asset. Utilizing advanced AI via GPT-4o, the system then drafts a personalized onboarding email, including secure access credentials and custom instructions, ensuring a premium customer experience without manual intervention. This flow eliminates the 'human-in-the-middle' delay, significantly reducing support tickets related to missing downloads. By integrating an AI agent, the workflow can intelligently parse complex product variations, making it far more robust than standard linear automations. Whether you are selling automation templates, software licenses, or protected PDF guides, this system provides a scalable infrastructure that grows with your sales volume while maintaining a personal touch through LLM-generated content. **Common Use Cases:** - Scaling a niche digital marketplace for selling specialized code snippets or design assets. - Automating the distribution of unique software license keys and documentation after a SaaS subscription purchase. - Delivering personalized AI-generated consulting reports or audit results based on customer input data.

Scheduled·25 nodes
AGCHCOEX+10
high

Automated AI Resume Parser & JD Matcher via n8n & GPT-4

Transform your recruitment funnel with this advanced AI-driven candidate evaluation engine. This n8n workflow eliminates manual screening fatigue by autonomously analyzing batches of resumes against specific job descriptions. Using GPT-4 and LangChain's structured output parsers, the system extracts key qualifications, scores them against your criteria, and generates objective alignment reports. The process begins with a custom n8n form for document upload, followed by intelligent text extraction from PDFs. The data is then processed through an LLM chain to ensure unbiased scoring. Results are synchronized directly to Google Sheets for centralized tracking, while high-match alerts are dispatched via Slack and SendGrid to keep hiring managers informed in real-time. This workflow is essential for high-volume recruitment agencies and scaling startups that need to maintain a rigorous, auditable, and data-backed shortlisting process without increasing headcount or sacrificing quality of hire. **Common Use Cases:** - High-volume university recruitment and internship screening - Technical talent sourcing for niche engineering roles - Internal mobility matching for large corporate restructuring

Trigger·21 nodes
AGCHGMGM+5
medium

AI Gmail Auto-Labeler: Smart Inbox Sorting with GPT-4 & n8n

Stop drowning in a cluttered inbox and regain control of your digital communication. This advanced n8n automation leverages GPT-4's natural language processing to intelligently analyze, categorize, and label incoming Gmail messages in real-time. Unlike basic filter rules that rely on rigid keywords, this workflow understands the context and sentiment of every email, ensuring high-precision organization. The process begins with a Gmail Trigger that captures new messages. It then passes the content through a LangChain LLM chain where OpenAI evaluates the intent—distinguishing between urgent client requests, internal project updates, or low-priority newsletters. Using structured output parsing, the workflow extracts key metadata and applies the appropriate Gmail labels automatically. This eliminates the manual cognitive load of triaging emails, allowing your team to focus on high-value tasks rather than administrative upkeep. Whether you are managing high-volume support tickets or complex sales inquiries, this workflow ensures that critical messages are highlighted and organized without human intervention. **Common Use Cases:** - Automated Customer Support Triage: Instantly tag emails as 'Urgent Support', 'Feature Request', or 'Billing' to speed up response times. - Sales Lead Prioritization: Automatically identify high-intent inquiries and label them for immediate follow-up by account executives. - Project Management Sync: Categorize incoming vendor updates and stakeholder feedback by project name or department for better visibility.

Trigger·11 nodes
AGGMGOLM+3
medium

AI Dental Lead Follow-up: n8n, OpenAI & Google Sheets Sync

Stop losing high-value patients to delayed responses. This advanced n8n workflow bridges the gap between lead capture and appointment booking by deploying an AI-driven engagement layer. When a prospect submits a query via your website or landing page, the automation immediately triggers, logging the data into Google Sheets for centralized tracking. Instead of sending a generic auto-reply, the integrated LangChain agent utilizes GPT-4/3.5 to analyze the specific treatment interest—be it Invisalign, dental implants, or routine cleaning—and crafts a personalized, empathetic response delivered via Gmail. The workflow includes a strategic 'Wait' node to mimic natural human timing and a 'Memory Buffer' to maintain context if the lead replies. This system is essential for clinics looking to scale their patient acquisition without increasing administrative headcount, ensuring every inquiry is nurtured instantly with professional, clinical-grade communication. By automating the initial touchpoint, your front-desk team can focus on confirmed arrivals rather than chasing cold leads. **Common Use Cases:** - Automated Patient Triage: Categorizing and responding to specific dental treatment inquiries based on urgency and procedure type. - Medical Spa Lead Nurturing: Instantly engaging prospects interested in high-ticket aesthetic treatments to increase conversion rates. - Multi-Location Clinic Sync: Centralizing lead data from various web forms into a single Google Sheet while maintaining personalized local email follow-ups.

Trigger·8 nodes
AGCOGOHT+8
high

Automate AI UGC Video Production with Google Sheets & Veo

Transform your digital marketing strategy by automating the production of high-converting User-Generated Content (UGC) at scale. This sophisticated n8n workflow eliminates the logistical bottleneck of traditional content creation by orchestrating a seamless pipeline between Google Sheets and advanced AI video models. By leveraging NanoBanana Pro for precise image synthesis and Veo 3.1 for fluid motion, the system takes three distinct visual inputs—your product, a chosen persona, and a target environment—and blends them into hyper-realistic, selfie-style video assets. The automation begins by monitoring a Google Sheet for new campaign parameters, triggers an intelligent AI agent to handle complex image processing, and manages asynchronous API calls to ensure high-fidelity video rendering. This is an enterprise-grade solution for performance marketers who need to refresh creative assets daily without manual intervention. It effectively handles the heavy lifting of prompt engineering and file management, allowing you to focus on strategy while the workflow generates 8-second, platform-ready clips optimized for the TikTok and Instagram algorithms. **Common Use Cases:** - Scaling creative testing for TikTok and Meta Ads by generating hundreds of product variants - Automating personalized influencer-style shoutouts for e-commerce loyalty programs - Rapid prototyping of social media video content for global brand localization

Scheduled·24 nodes
@BAGCOIF+7
high

Automate AI Twitter Threads via Telegram & n8n (No-Code)

Streamline your social media presence with this enterprise-grade n8n automation that bridges the gap between raw inspiration and professional X (Twitter) publishing. By integrating Telegram as a mobile command center, this workflow allows you to dictate or type thread ideas on the go. The system leverages OpenAI’s LLMs and LangChain agents to draft high-engagement thread structures, which are then sent back to your private Telegram chat for review. Unlike basic automation, this setup features a sophisticated 'human-in-the-loop' approval system. You can interactively refine the AI-generated content, request edits, or finalize the draft. Once you provide the 'Okay' confirmation, the workflow automatically formats and publishes the entire thread to X via the Blotato integration. This eliminates the friction of manual drafting and copy-pasting, ensuring your brand stays active without the constant overhead of social media management. It is the perfect solution for creators and businesses looking to maintain a high-quality digital presence using a voice-to-thread mobile pipeline. **Common Use Cases:** - Thought Leadership: Convert spontaneous voice memos into structured educational threads while commuting. - Event Live-Tweeting: Rapidly draft and approve professional event summaries from a mobile device without opening the X app. - Content Repurposing: Send links or snippets of long-form articles to Telegram to generate 'tweetable' summaries for social distribution.

Trigger·19 nodes