Back

Turn my Google Sheets job tracker into a weekly digest

A weekly digest of applications, stage changes, deadlines, and priorities

Prompt

Open my job search tracker [sheet link, e.g. a Google Sheet with tabs for applications, contacts, and saved jobs] and summarize the last [period, e.g. 7 days]. Read every tab. Pull out what happened in that period: new applications sent, rows that moved stage (applied, screening, interview, offer, rejected), new contacts added, and anything marked closed. Count each. Then look ahead: deadlines, interviews, and assessments in the next [window, e.g. 14 days], follow-ups older than [threshold, e.g. 7 days] with no reply, and saved jobs I have not applied to yet. If a row is missing a date or stage, list it rather than guessing. Hand back a short digest: one headline line with the totals, then a table with columns Company, Role, Stage, Last update, Next step, Due, and Priority (high, medium, low), then my top 3 actions for the coming week. Read-only: do not edit the sheet. If I ask, email the digest to myself only.

Works withdocs.google.com