Easily track your job applications with natural language input. This Python-based solution leverages OpenAI’s GPT API to extract structured data and uses Zapier to push it into a Google Sheet — no manual spreadsheet edits required.

• Python 3.8+
• OpenAI API key
• Zapier webhook URL
• Internet access

1. Clone this repo or download the script.
2. Install dependencies:

pip install -r requirements.txt

Create a .env file in the root directory and add:

OPENAI_API_KEY=your_openai_api_key_here
ZAPIER_WEBHOOK_URL=https://hooks.zapier.com/hooks/catch/xxxxxx/yyyyyy/

Run the script with:

python app.py

You’ll be prompted to enter the job application note in plain English.

Enter application note: I applied to Bright Forge as a Software Engineer via referral through John.

And Zapier updates your Google Sheet automatically.