Job Application Tracker

This project automates the tracking of job applications by scanning your Gmail account for relevant emails, extracting key information using the Groq API, and organizing it all in a Google Sheet.

Features

• Automated Email Scanning: Searches your Gmail for emails related to job applications based on customizable keywords.
• Smart Extraction: Uses the Groq API to intelligently extract details like company name, application status, and links from email content.
• Google Sheets Integration: Populates a Google Sheet with the extracted data, creating a centralized and easy-to-manage tracker.
• Duplicate Prevention: Keeps track of processed emails to avoid duplicate entries.
• Conditional Formatting: Automatically color-codes rows in your Google Sheet based on application status (e.g., "interview", "rejected").

Requirements

• Python 3.6+
• A Google account with the Gmail and Google Sheets APIs enabled.
• A Groq API key.

Setup

1. Clone the repository:

   git clone https://github.com/prshanthreddy/jobapplicationtracker.git
   cd jobapplicationtracker

2. Install the dependencies:

   pip install -r requirements.txt

3. Configure Google APIs:

   • Go to the Google Cloud Console.
   • Create a new project.
   • Enable the "Gmail API" and "Google Sheets API".
   • Create credentials for a "Desktop application" and download the credentials.json file.
   • Place the credentials.json file in the root of the project directory.

4. Set up environment variables:

   • Create a .env file in the root of the project directory.
   • Add the following variables to the .env file:

     GOOGLE_SHEET_ID="your_google_sheet_id"
     SEARCH_KEYWORDS="thank you for your application,interview,job offer,rejected"
     GROQ_API_KEY="your_groq_api_key"
     

   • You can get the GOOGLE_SHEET_ID from the URL of your Google Sheet.

Usage

1. Run the application:

   python tracker.py

2. Authorize access:

   • The first time you run the script, you will be prompted to authorize access to your Google account.
   • Follow the on-screen instructions to complete the authorization process.
   • A token.json file will be created in the project directory, which will store your authorization credentials for future use.

3. View your job applications:

   • Open the Google Sheet you specified in the .env file to see your tracked job applications.