Job Fill Auto Extension

Chrome extension that appends a row to your Google Sheet when you submit job details from the popup. Supports the following job boards:

• Ashby
• Greenhouse
• Lever
• Workday
• Linkedin

Why

Job applications are spread out all over different job boards. All job boards track the jobs that you've applied to on their platforms making it harder to track all jobs across different platforms. Google sheets acts as a ground truth where you can fill in your details pretty easily, but it gets pretty exhausting having to copy and paste the same details 20 times a day, every day. This extension aims to automate the copy-pasting part by automatically adding these fields from the browser to your selected google sheet, making one aspect of the job search a little easier.

Note

This extension is currently a work in progress and is meant to be run as an unpacked Chrome extension in developer/debug mode. You should be comfortable creating a Google Cloud OAuth client and editing manifest.json.

Configurable Google Sheet layout

The extension appends one row using the field order configured in the extension settings page. Your Google Sheet header row should match that same order so columns line up.

Open settings from the popup or from Chrome's extension options page. Settings let you configure:

• Google Sheet ID.
• Tab name.
• Custom fields.
• Required fields.
• Which fields appear in the popup.
• Field order, changed by dragging fields, which controls append order.
• Autofill sources such as current URL, detected role, detected organization, detected location, detected salary, and today's date.
• Optional default values that fill the popup when the selected autofill source is blank.

The extension does not validate Google Sheet headers yet. Keep the configured field order aligned with your sheet columns.

Example field layout:

Job link | Organization | Role | Date | Location | Salary | Status | Notes

Setup

1. Load the extension in debug mode

1. Open Chrome → chrome://extensions.
2. Turn on Developer mode.
3. Select Load unpacked.
4. Choose this repository folder.
5. Keep this page open and copy the generated extension ID. You will use it when creating the Google OAuth client.

2. Google Cloud project

1. Open Google Cloud Console.
2. Create a project (e.g. “Job Fill Extension”).
3. APIs & Services → Library → enable Google Sheets API.
4. APIs & Services → OAuth consent screen → type External → add app name, your email, and scope https://www.googleapis.com/auth/spreadsheets.
5. APIs & Services → Credentials → Create credentials → OAuth client ID:

• Application type: Chrome extension (or Chrome app, depending on what the console offers for extensions).
• Item ID / Application ID: paste the extension ID from step 1.

6. Copy the Client ID (ends with .apps.googleusercontent.com).

3. Configure manifest.json

Chrome requires the OAuth client ID directly in the extension manifest. In manifest.json, replace the oauth2.client_id value with your own Google OAuth client ID:

"client_id": "<YOUR_GOOGLE_OAUTH_CLIENT_ID>"

After saving manifest.json, go back to chrome://extensions and click Reload on the extension card. If you change the OAuth client or extension files later, reload the extension from this page again.

4. Use the extension

1. Open your sheet and note the Sheet ID from the URL: https://docs.google.com/spreadsheets/d/<SHEET_ID>/edit
2. Open the extension popup → Settings.
3. Paste the Sheet ID and exact tab name (e.g. Sheet1).
4. Add fields and drag them into the same order as your Google Sheet columns.
5. Mark required fields, choose autofill sources, and add default values where useful.
6. Save settings.
7. On a job posting page, open the popup, confirm or edit fields, then Submit to Sheets.

Tasks to-do:

• Screen to add configuration options
  • Users can set their own columns to auto detect and enter
  • Users should be able to select the mandatory columns, and click (see more...) to expand the modal to add entries in optional columns
• Fix current auto-fill fields (job title, company name, on all job board sites)
  • Fix company name on Ashby, Greenhouse, Lever, Workday
  • Add location field (auto-detection) to job fields
• Detect
  • Detect salary comp
  • location
  • day applied on (current day or any other day)
  • date job posted on (ashby, and others)
  • work type (remote, on-site, hybrid)
• Make extension sticky (open once, close only on close button)
• Linkedin job link needs to click the "Copy Link" button to copy the job link
• Check if job already applied to (unique constraint on job id/url - might make mandatory)
• Add option to sign in with google (social login) to auto detect sheets and names
  • Removes the need to have a unique key so that login is streamlined
• Publish extension to google extension store
• Enhancements
  • Option to edit job details/fields if already in tracker
  • Add recruiter support
    • support filling details on linkedin/manual fill
    • plan the design and flow for this
• Remove query params