Scrape LinkedIn Jobs with Gemini AI and Store in Google Sheets Using RSS

This n8n workflow automates the process of scraping LinkedIn job listings, enriching them with AI-generated summaries and sentiment analysis using Google Gemini, and then storing the processed data in a Google Sheet. It's designed to help you keep track of relevant job opportunities efficiently.

What it does

1. Triggers Manually: The workflow starts when manually executed.
2. Reads RSS Feed: It fetches the latest job postings from a specified RSS feed (e.g., a LinkedIn job search RSS feed).
3. Loops Over Items: Each job posting from the RSS feed is processed individually in a loop.
4. Extracts HTML Content: For each job, it makes an HTTP request to the job's URL to fetch its full HTML content.
5. Parses HTML: It then extracts specific details from the HTML, such as the job description, using CSS selectors.
6. Enriches with AI (Google Gemini):
   • It sends the extracted job description to a Google Gemini Chat Model.
   • An AI Agent is used to generate a concise summary of the job description and perform sentiment analysis (e.g., "positive," "negative," or "neutral").
   • A Structured Output Parser ensures the AI's response is formatted correctly (e.g., as JSON with summary and sentiment fields).
7. Formats Data: A Code node transforms and combines the original RSS feed data with the AI-generated summary and sentiment into a structured format suitable for Google Sheets.
8. Appends to Google Sheets: Finally, it appends the processed job data (including title, link, summary, and sentiment) as a new row in a specified Google Sheet.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google account with access to Google Sheets. You'll need to create a new spreadsheet or specify an existing one for the job data.
• Google Gemini API Key: An API key for Google Gemini (configured as a credential in n8n).
• LinkedIn Job Search RSS Feed: A URL for a LinkedIn job search RSS feed. You can generate this by performing a search on LinkedIn and looking for an RSS icon or a way to subscribe to the search results.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the JSON content or upload the file.
2. Configure Credentials:
   • Google Sheets: Set up a Google Sheets credential. This typically involves OAuth2 authentication to grant n8n access to your Google Sheets.
   • Google Gemini Chat Model: Configure a Google Gemini credential using your API key.
3. Update Node Parameters:
   • RSS Read (Node 37): Update the "URL" parameter with your LinkedIn job search RSS feed URL.
   • HTTP Request (Node 19): Ensure the URL is correctly mapped to {{ $json.link }} to fetch the content of each job link.
   • HTML (Node 842):
     • Adjust the "CSS Selector" for extracting the job description if LinkedIn's HTML structure changes. You might need to inspect a LinkedIn job page to find the correct selector for the main job description content.
   • AI Agent (Node 1119): Review the prompt for the AI Agent to ensure it generates the desired summary and sentiment.
   • Google Sheets (Node 18):
     • Specify the "Spreadsheet ID" of your target Google Sheet.
     • Specify the "Sheet Name" where the data should be appended.
     • Ensure the "Values" are correctly mapped from the Code node's output (e.g., {{ $json.title }}, {{ $json.link }}, {{ $json.summary }}, {{ $json.sentiment }}).
4. Execute the Workflow:
   • Click "Execute Workflow" in the "Manual Trigger" node to run the workflow.
   • For continuous monitoring, consider replacing the "Manual Trigger" with a "Cron" node to run at scheduled intervals.