← All Automations JOB SEARCH TOOL

Personal AI Job Finder

A Google Apps Script that lives inside your Google Sheet — searches Google Jobs via SerpAPI, hits Greenhouse and Lever company boards directly, filters noise, and logs only the relevant roles automatically.

WHAT IT DOES

Stop searching. Start finding.

• One click runs your full keyword list through Google Jobs — no manual searching across tabs
• Detects which companies use Greenhouse or Lever from apply links, then hits those boards directly — surfacing roles that Google hasn't indexed yet
• Filters out Director, VP, and Principal titles automatically, and drops any job requiring 4+ years of experience
• A company watchlist checks your target employers on every run — even if they don't appear in search results
• Deduplicates against your existing sheet rows so you never see the same listing twice

HOW IT WORKS

One script, full pipeline.

1. Step 1 — Read your Config tab

   The script reads your keywords, location, watchlist companies, and ATS slug cache from the Config tab. No hardcoded values — change anything without touching the script.

2. Step 2 — Search Google Jobs via SerpAPI

   Each keyword + location combo hits SerpAPI's Google Jobs engine. Returns structured job data — title, company, apply link, posting date — and extracts Greenhouse and Lever slugs from the apply URLs automatically.

3. Step 3 — Freshness check + watchlist merge

   Drops any company with no posting in the last 30 days. Merges detected companies with your pinned watchlist. Applies a 7-day cooldown on companies that previously returned zero results — saving your API quota.

4. Step 4 — Direct ATS enrichment

   For up to 25 companies, the script calls Greenhouse and Lever's job board APIs directly — bypassing Google's index. This surfaces roles posted minutes ago that haven't been crawled yet.

5. Step 5 — Filter, deduplicate, write

   All results pass through relevance and experience filters. Duplicates removed within the batch and against existing sheet rows. New jobs prepend to the top of your Results tab — freshest always first.

WATCH IT RUN

See it find jobs live.

Full walkthrough — Config tab setup, script install, SerpAPI key, and a live run pulling real jobs into the sheet.

WHAT YOU NEED

Everything is free.

1. Google Account

   You already have this. The script runs entirely inside Google Sheets via Apps Script — no installs, no servers.

2. SerpAPI account (free tier)

   Sign up at serpapi.com. Free plan includes 100 searches/month. Running the script weekly with 6 keywords uses ~24 searches/month — well within the free tier.

3. 5 minutes to set up

   Create two tabs, paste the script, add your API key as a Script Property. The setup guide walks through every step with screenshots.