Automate your entire job search using AI — from a single Google Sheet.
Find jobs across LinkedIn, Indeed, RemoteOK & more. Match them to your resume. Draft personalized emails. Push to Gmail. Track everything. Zero hosting. Zero cost. Powered by Gemini.
Job searching is repetitive and time-consuming. You open 10 tabs, search the same query on 5 boards, copy-paste into a spreadsheet, write the same email 20 times. JobPilot AI automates all of it.
- 🆓 100% free — runs on Google's free tier (Gemini API + Apps Script)
- 🚫 No hosting needed — everything runs serverlessly inside Google Sheets
- 🔒 Your data stays yours — no external servers, no accounts, no tracking
- ⚡ One-click pipeline — search → match → draft → Gmail in a single click
- 🤖 AI-powered, not AI-dependent — direct scrapers run first, AI fills the gaps
| Feature | Description |
|---|---|
| 📄 Resume Parsing | Upload or paste your resume — Gemini extracts skills, experience, and target roles |
| 🔍 AI Job Search | Searches the web for jobs across LinkedIn, Indeed, Glassdoor, Wellfound, RemoteOK & more |
| 💼 Direct Scrapers | Built-in scrapers for LinkedIn, Indeed, RemoteOK, We Work Remotely — no API quota used |
| ✍️ Manual Input | Paste job URLs or descriptions — AI extracts structured job details |
| 📋 Bulk Import | Paste multiple job listings from any source — AI parses them all at once |
| 🎯 Job Matching | AI scores every job (0-100) against your resume with detailed explanations |
| ✉️ Email Drafting | Gemini writes personalized application emails (casual, formal, or custom style) |
| 📧 Gmail Drafts | One-click push emails to Gmail as drafts, ready to review and send |
| 📊 Full Tracking | Google Sheet tracks every job: status, match score, email draft, Gmail link |
| 🚀 Full Pipeline | Run search → match → draft → Gmail in a single click from the sidebar |
┌─────────────────────────────────────────────────────┐
│ Google Sheets UI │
│ Custom Menu · HTML Sidebar │
├─────────────────────────────────────────────────────┤
│ Google Apps Script │
│ ┌─────────┐ ┌──────────┐ ┌──────────┐ ┌─────────┐ │
│ │ Resume │ │ Job │ │ Job │ │ Email │ │
│ │ Parser │ │ Search │ │ Matcher │ │ Drafter │ │
│ └────┬────┘ └────┬─────┘ └────┬─────┘ └────┬────┘ │
│ └───────────┼────────────┼─────────────┘ │
│ ▼ ▼ │
│ ┌──────────────┐ ┌──────────┐ │
│ │ Gemini 2.0 │ │ Gmail │ │
│ │ Flash API │ │ Drafts │ │
│ │ + Search │ └──────────┘ │
│ │ Grounding │ │
│ └──────────────┘ │
│ ┌──────────────────────────────────────────────┐ │
│ │ Direct Scrapers (no API needed) │ │
│ │ LinkedIn · Indeed · RemoteOK · WWR │ │
│ └──────────────────────────────────────────────┘ │
└─────────────────────────────────────────────────────┘
Single API key, multiple capabilities:
- 🤖 AI Analysis — Resume parsing, job matching, email drafting
- 🔍 Web Search — Job discovery via Gemini Search Grounding
- 💼 Direct Scrapers — LinkedIn, Indeed, RemoteOK, WeWorkRemotely (free, no Gemini quota used)
- 📧 Gmail — Draft creation and management
- Google account (free or Workspace)
- Gemini API key (get one free)
That's it! No other API keys, subscriptions, or services needed.
- Create a new Google Sheet
- Open Apps Script Editor: Extensions → Apps Script
- Copy all
.gsfiles from thesrc/folder into the script editor - Copy
Sidebar.htmlas an HTML file in the script editor - Update
appsscript.json: Show manifest file, replace contents withsrc/appsscript.jsonfrom this repo - Reload the Sheet — the 🚀 JobPilot AI menu appears
- Run Initialize from the menu to create tracker sheets
- Enter your Gemini API key via JobPilot AI → Settings
📖 Detailed setup guide: SETUP.md
src/
├── appsscript.json # Apps Script manifest (required by CLASP)
├── Code.gs # Entry point, custom menu, orchestration
├── GeminiService.gs # Gemini API wrapper (REST + Search Grounding)
├── SheetManager.gs # Google Sheets CRUD operations
├── Config.gs # Configuration & API key management
├── ResumeParser.gs # Resume analysis via Gemini
├── JobSearch.gs # AI-powered job discovery + direct scrapers + manual input
├── JobMatcher.gs # Job-resume matching & scoring
├── EmailDrafter.gs # Personalized email generation
├── GmailService.gs # Gmail draft creation
├── Utils.gs # Utility functions
└── Sidebar.html # HTML sidebar UI
JobPilot AI uses a hybrid approach: direct scrapers run first (free, no quota), then Gemini Search Grounding fills the gaps.
| Source | Method | API Quota |
|---|---|---|
| Direct scraper (public pages) | ❌ Free | |
| Indeed | Direct scraper (HTML parsing) | ❌ Free |
| RemoteOK | Direct scraper (JSON API) | ❌ Free |
| We Work Remotely | Direct scraper (RSS feed) | ❌ Free |
| Glassdoor, Wellfound, Cutshort, Instahyre | Gemini Search Grounding | ✅ Uses quota |
| Company career pages | Gemini Search Grounding | ✅ Uses quota |
| Any URL or text | Manual Add / Bulk Import | ✅ Uses quota |
Note: LinkedIn, Naukri, and Glassdoor job details may be login-gated. Use Add from URL or Bulk Import for jobs from these platforms.
| API | Free Tier | Cost After Free Tier |
|---|---|---|
| Gemini API | 15 requests/min, 1,500/day | ~$0.001 per request |
| Gmail API | 250 drafts/day | Free (included with Google account) |
💡 Only one API key (Gemini) is required. It's free from Google AI Studio. This is NOT the same as a Gemini Pro subscription — the API key is completely free with generous daily limits.
| Issue | Solution |
|---|---|
| Menu doesn't appear | Reload the sheet, or run onOpen manually in Apps Script |
| Rate limit (429) errors | Wait for quota reset (midnight PT) or enable billing |
| Search returns few results | Try different keywords, or search multiple times (duplicates auto-skipped) |
| LinkedIn/Naukri jobs missing | Use Bulk Import or Add from URL instead |
| URL added but no details | Login-gated site — copy job text into Bulk Import |
📖 Full troubleshooting guide: SETUP.md#-troubleshooting
Contributions are welcome! Please see CONTRIBUTING.md for guidelines.
- Fork the repo
- Create your feature branch (
git checkout -b feature/awesome-feature) - Commit your changes (
git commit -m 'Add awesome feature') - Push to the branch (
git push origin feature/awesome-feature) - Open a Pull Request
This project is licensed under the MIT License — see the LICENSE file for details.
- Google Gemini API for powering all AI features including Search Grounding
- Google Apps Script for the serverless runtime
- Built with ❤️ for job seekers everywhere
job-search job-automation google-apps-script gemini-api google-sheets job-tracker resume-parser email-automation job-board-scraper ai-automation job-hunting career-tools google-workspace gemini-ai job-application gmail-automation job-matching remote-jobs productivity open-source