Automated job scraping with SerpAPI, Gemini AI filter & email notifications

🛜 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:

1. Scrape: Uses SerpAPI with a tailored Google Dork to fetch fresh job listings daily from top platforms. 2. Filter: A Gemini AI agent validates offers to ensure they match corporate finance criteria. 3. Store: Saves new offers in Google Sheets, marking duplicates to avoid spam. 4. 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.