Skip to content

Initial Release

Choose a tag to compare

View all tags
@sandeeppvn sandeeppvn released this 15 Dec 07:48
· 16 commits to prod since this release
v2.0.1
a433966

AIJobApply

Automate your job application process using AI, Google Sheets, and Email services.

Table of Contents

Prerequisites

  • Python 3.8 or higher.
  • OpenAI GPT API access.
  • Google App Password

PLEASE PERFORM ALL THE BELOW SETUP IN ORDER

Google Service Account Setup

To access the Google Sheets API, you need to create a service account and obtain the credentials file.

  1. Google Cloud Console: If you don't already have a Google Cloud account, sign up at Google Cloud Console.
  2. Create a Project: Create a new project in the Google Cloud Console.
  3. Enable the Google Sheets API: Navigate to the Google Sheets API page and enable the API for your project.
  4. Enable the Google Drive API: Navigate to the Google Drive API page and enable the API for your project.
  5. Create a Service Account: Navigate to the Service Accounts page and create a new service account for your project.
  6. Download Credentials: After creating the service account, open the service account (click on the service account link), click on keys, generate new key (JSON) and download it as the credentials file. This file contains the necessary information to authenticate your application with the Google Sheets API.
  7. Keep track of where you downloaded the credentials json to.

Google Sheets Setup

For setting up your job application data, AIJobApply utilizes Google Sheets. To get started quickly, you can use our pre-defined template. Access the Google Sheets template here: AIJobApply Google Sheets Template.

To make a copy of the template, click on File > Make a copy. This will create a copy of the template in your Google Drive. Name the copy as

AIJobApply

You need to provide the sheet access to the service account created. To do this, click on Share and add the email address of the service account.
Open the credentials json file, copy the client_email value, and paste it in the Add people and groups section.
Ensure that the service account has Editor access to the sheet.

OpenAI API Setup

To utilize the OpenAI GPT API for message generation, follow these steps to obtain an API key:

  1. OpenAI Account: If you don't already have an OpenAI account, sign up at OpenAI.
  2. API Access: Once logged in, navigate to the API section.
  3. Create an API Key: Follow the instructions to create a new API key.
  4. Keep track of the API key value

Gmail Setup

To send emails using the Gmail service.

  • If you are not using 2FA, you can use your regular Gmail password.

  • If you are using 2FA, you need to set up an App Password. Follow these steps to generate an App Password:

  1. Google Account: If you don't already have a Google account, sign up at Google.
  2. App Password: Navigate to the App Passwords section of your Google account.
  3. Generate Password: Select Mail and Other from the dropdown menus. Enter a name for the application and click Generate.

Selenium Driver Setup

To automate the LinkedIn connection request and message sending process, you need to download the appropriate Selenium driver for your browser. The Selenium driver is used by the Selenium Python library to automate the browser actions.
Currently, the following Selenium drivers are supported:

Download the appropriate driver for your browser and keep track of where you downloaded it to.

Installation

Download the executable.
After setting up all the previous steps and add some jobs (refer Adding a Job) to the google sheet
Double click the executable.

aijobapply

MacOS Special cases

For the aijobapply executable and for the selenium webdriver, after double clicking, you might want to go to "Privacy and Security" and allow the applications.

Adding a Job

(Optional)
A job can be added to the google sheet either manually or
you can use the RPI tool provided by Bardeen. This tool allows for a streamlined process of adding job listings through automation. For detailed instructions on how to use this tool, refer to the following Bardeen playbook: LinkedIn Autobook.

Full Changelog: https://github.com/sandeeppvn/AIJobApply/commits/v2.0.1

Assets 5
Loading