n8nflow.net logo

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

by Louisβ€’Updated: Last update 19 days agoβ€’Source: n8n.io
Loading workflow viewer...

πŸ›œ 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.

πŸ”‘ 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