Monday morning compensation pulse for tracked roles

Every Monday at 9am ET, run a compensation pulse for the roles my team is actively hiring or planning to hire for. This should be an agent workflow on a cron trigger.

Inputs the agent should accept when I configure it: the Google Sheets spreadsheet ID and tab/range that holds my tracked roles, the Slack channel ID for the digest, and a movement threshold (default 3 percent).

Step 1: Read the tracked roles from the Google Sheet using Google Sheets Get Values. The sheet has one row per role with a job title column and a location column, plus columns for the prior week's min, median, and max so the agent can compare week over week.

Step 2: For each role, call Job Salary Data Get Job Salary Estimate with the job title and location to fetch the current min, median, and max plus the confidence rating. Iterate over the data array (up to three publisher estimates) and aggregate sensibly (for example median of medians, or pick the top result) rather than blindly indexing the first element.

Step 3: Append a dated snapshot row per role back to the same sheet using Google Sheets Append Values. Each appended row should include the date, job title, location, this week's min, median, max, and confidence, so we build a clean longitudinal record over time.

Step 4: Compare this week's median to last week's median (from the prior-week columns the sheet already carries) for every role. Flag any role whose median moved by more than the configurable threshold (default 3 percent) in either direction.

Step 5: Write a short markdown digest that opens with a one-line summary, lists the movers with direction and percent change, calls out any roles that came back with low confidence, and includes a link to the underlying Google Sheet so the team can drill in.

Step 6: Send that digest to the configured Slack channel using Slack Send a Message so the comp and recruiting team sees it in their Monday morning standup feed.

Be resilient: if a single role lookup fails or the API returns a 429, log the role and skip it rather than failing the whole run. If no roles moved beyond the threshold, still post a brief 'no significant movement this week' note so the team knows the pulse ran.