Scrape LinkedIn jobs with Gemini AI and store in Google Sheets using RSS
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read RSS Feed. (RSS Read): reads an RSS feed
- Loop for Job Posts (Loop Over Items (Split in Batches)): loops over the items in batches
- Scrape Job HTML. (HTTP Request): calls an HTTP API
- Extract HTML (HTML): parses or builds HTML
- Parse Job Details. (Code): runs custom JavaScript code
- Pre-clean Before AI (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Update Google Sheet. (Google Sheets): append or update
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTML
n8n-nodes-base.html - Code
n8n-nodes-base.code - RSS Read
n8n-nodes-base.rssFeedRead - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
What Problem Does it Solve This workflow automates the process of finding and collecting job postings from LinkedIn, eliminating the need for manual job searching. It’s designed to save time and ensure you don’t miss out on new opportunities by automatically…