Automated Job Scraping with SerpAPI, Gemini AI Filter & Email Notifications

Description

🛜 Daily Notification on Specific Latest Job Offers 🛜

🌟 Overview: Never miss a job offer again! This n8n workflow automates daily job scraping from LinkedIn, Indeed, Welcome to the Jungle, and more, using Google Dorks and SerpAPI. It filters offers with a Gemini AI agent, stores them in Google Sheets, and sends a sleek HTML newsletter to your inbox or subscribers—all manageable from your phone!

💼 Use Cases:

Students hunting for M&A, valuation, or transaction services internships (6+ months).
Career switchers seeking automated, curated job alerts.
Content creators building a job newsletter to monetize their audience.

⚙️ How It Works:

Scrape: Uses SerpAPI with a tailored Google Dork to fetch fresh job listings daily from top platforms.
Filter: A Gemini AI agent validates offers to ensure they match corporate finance criteria.
Store: Saves new offers in Google Sheets, marking duplicates to avoid spam.
Notify: Generates an email/newsletter notification and sends it via Outlook

🛠️ Setup Instructions:

Import the JSON workflow into n8n.
Add credentials: SerpAPI (API key), Google Sheets (OAuth2), Microsoft Outlook (OAuth2)
Customize the Google Dork in the "Edit Fields" node for specific job criteria.
Schedule to run daily at 7 AM. Test and tweak the AI prompt for precision.

🔑 Required Credentials & Nodes:

Credentials**: SerpAPI, Google Sheets OAuth2, Microsoft Outlook OAuth2
Nodes**: Schedule Trigger, HTTP Request, Google Sheets, AI Agent (Gemini), Microsoft Outlook

🔗 Creator: Louis Delahaye | n8n.io/creators/louisdl

🎥 YouTube @cash-routine

My AI Agency : https://agence-alain.fr