📋 Application Tracking Using Google Sheets and OpenAI API

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.

🛠 Requirements

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

---

📦 Installation

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

pip install -r requirements.txt

🔑 Environment Setup

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/

▶️ Usage

Run the script with:

python app.py

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

Example

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

And Zapier updates your Google Sheet automatically.