Weekly formulary safety and supply digest

Build me an agent workflow that sends a weekly safety and supply digest for the drugs on my hospital formulary. Trigger it on a cron every Monday at 7:00 AM US Eastern.

Read my formulary from a Google Sheets tab using Get Values. The sheet has one row per drug with these columns: brand name, generic name, therapeutic class, and the clinical lead's email. Make the spreadsheet ID, tab name, and range configurable on the workflow.

For each drug in the sheet, the agent should call openFDA three times:

1) Search Drug Shortages for the current shortage status and any newly resolved shortages. Match on generic name and brand name using the normalized openfda fields. Capture the status, reason, and affected presentations.

2) Search Drug Recall Enforcement Reports for any Class I or Class II recalls in the past seven days. Filter by recall_initiation_date in the last seven days and classification in (Class I, Class II).

3) Search Drug Adverse Events for new serious outcome reports in the past seven days. Filter by receivedate in the last seven days and serious outcome flags for death, hospitalization, or life-threatening events. Note the reaction terms and counts.

Then synthesize a single readable digest as the email body. Group items by therapeutic class. Lead with the highest-severity items (Class I recalls and death outcomes first, then Class II recalls and hospitalization outcomes, then shortage status changes, then everything else). Call out any shortage that changed status since last week (use the workflow's persistent memory or last-run state to compare). Flag any adverse event signal that looks unusually clustered (same reaction term spiking week over week, or multiple serious reports against the same drug in a short window) and explain why it caught the agent's attention.

Include a short coverage line at the top of the digest: 'Checked N drugs. M had new safety or supply signals.' For drugs with no signals, do not list them individually.

Send the finished digest with Gmail's Send a Message to the recipient email address configured on the workflow. The subject should be 'Formulary safety and supply digest — week of <Monday date>'. Send the body as readable HTML with clear class headings, severity labels, and links back to the relevant FDA records where useful.

On the first run, treat the previous week as having no recorded state and just publish the current snapshot so the agent has a baseline to compare against next week.