Monthly competitor hiring and headcount digest

Build an agent workflow that runs on a cron schedule on the first Monday of every month at 7am and produces a competitor intelligence digest emailed to my leadership list. The output is a written narrative ranked by signal strength, not a stats dump, so an agent is the right fit.

Step 1. Read my competitor watch list from Google Sheets. Use Get Values on the configured spreadsheet and tab. The sheet has two columns: competitor name and website domain. Treat each row as one competitor to research.

Step 2. For each competitor, call Coresignal three times. Use Enrich Company by Website (Multi-source) with the website domain to pull the company record. Use Get Historical Headcount to retrieve the trailing 12-month workforce trend. Use Search Jobs (Filter) — Base to find that company's currently open postings, then count them and break them down by department or function. If a competitor cannot be found by domain, note the gap in the digest and keep going.

Step 3. Synthesize a single written digest. Rank competitors by headcount growth rate over the trailing 12 months. For each competitor write one short paragraph that names the functions they are hiring into most aggressively and flags notable inflections (sudden 20%+ growth, new geographic presence, a clear sales-team buildout, a sharp drop). Put a compact header table at the top with the headline metrics per competitor (current headcount, 12-month growth %, total open roles, top hiring function). End the digest with two or three so-what implications for our team.

Step 4. Deliver the digest via Gmail. Use Create a Draft with the configured recipient list, a clear subject line that includes the month, and the digest as the body, then Send a Draft to deliver it. Keep the formatting scannable: a header table plus one paragraph per competitor, not a wall of stats.

Step 5. Log the headline metrics. Use Google Sheets Append Values to append one row per competitor to a History tab in the same spreadsheet, with the run date, competitor name, current headcount, 12-month growth %, total open roles, and top hiring function. This makes month-over-month deltas inspectable without rerunning the agent.

Configurable inputs the user should be able to edit: the source spreadsheet and tab, the History tab name, the Gmail recipient list, the subject line template, and the inflection thresholds (for example the growth % that triggers a callout). Default the inflection threshold to 20%.