This project automates the process of tracking job application emails from Gmail and storing relevant information in a Google Spreadsheet.
Before running the application, ensure you have the following installed:
- Python 3.x
- Git
-
Clone the repository:
git clone https://github.com/yourusername/job-application-tracking-automation.git
-
Navigate to the project directory:
cd job-application-tracking-automation
-
Install the required Python packages:
pip install -r requirements.txt
-
Obtain credentials for Gmail API and Google Sheets API:
- Go to the Google Cloud Console.
- Create a new project.
- Enable the Gmail API and Google Sheets API for your project.
- Create credentials (OAuth 2.0 client ID) for both APIs.
- Download the credentials JSON file for each API and save them as
credentials_gmail.json
andcredentials_sheets.json
respectively in the project directory.
-
Run the application:
python JobApplicationTrackingSheet.py
-
Follow the authentication flow to grant access to Gmail and Google Sheets.
Once the application is running, it will:
- Retrieve job application-related emails from your Gmail inbox.
- Extract the date, time, subject, and content of each email.
- Process the emails by using ChatGPT API
- Store this information in a Google Spreadsheet
You can customize the application by adjusting parameters such as the number of emails to retrieve (maxResults
) and the spreadsheet ID and range in the save_to_google_spreadsheet
function.
Contributions are welcome! If you have any suggestions or want to contribute to this project, feel free to open an issue or submit a pull request.
This project is licensed under the MIT License.