Daily FDA food recall alerts for your grocery or restaurant chain

Build me an agent workflow that keeps my grocery or restaurant chain ahead of FDA food recalls. It should run on a cron trigger every weekday at 6am America/New_York, before stores open.

Step 1. Pull my active product catalog from Google Sheets using the Get Values operation. The sheet has one row per SKU with these columns: SKU, product name, brand, supplier firm (manufacturer), category, and the responsible buyer's Slack handle or user ID. Read the whole active range and hold it in memory for the run.

Step 2. Query openFDA using the Search Food Recall Enforcement Reports operation for recalls where report_date or recall_initiation_date falls in the last 24 to 48 hours, across all classifications (Class I, II, and III). Do not pre-filter by brand at the API layer. Pull the full recall records so you have recall class, reason for recall, product description, recalling firm, distribution pattern (states), status, and any lot codes or UPCs.

Step 3. For each recall returned, use judgment to decide if it hits my catalog. Match on brand name, product description, and manufacturer or firm name. This is the reason we are using an agent and not exact string matching: I want you to catch partial hits, alternate spellings, parent-company recalls that affect a sub-brand, and ingredient-level recalls (e.g. a recalled peanut butter used in one of my private-label cookies). When the fit is ambiguous, err on the side of alerting, and say in the alert why you think it matches.

Step 4. For every match, use the Slack Bot Send a Message operation to post one well-formatted alert to the #food-safety channel. Include recall class (I / II / III), the reason for the recall in plain English, the distribution states, affected lot codes or UPCs, the recalling firm, and the specific in-stock SKUs from my catalog that need to be pulled from shelves. Then DM the responsible buyer for each matched SKU with just their affected items and clear next-step instructions (pull from shelves, quarantine, contact supplier). Group by buyer so a buyer with three matched SKUs gets one DM, not three.

If no recalls match, post a short 'no relevant food recalls in the last 24 hours, check ran clean' message to #food-safety so the team knows the workflow fired and everything is quiet. Do not DM buyers on all-clear days.

Bake in dedup. Keep a record of recall IDs the workflow has already alerted on (a small state store or a scratch tab on the same Google Sheet is fine) and skip any recall whose ID has already been posted. Multi-day recalls should only ping the channel the first morning they surface.

Formatting notes: keep alerts scannable with a header line, a class badge, a one-line reason, then a bulleted list of affected SKUs. Use Slack mrkdwn. Do not fabricate lot codes or SKUs; if the recall record does not include a lot code, say 'no lot codes published'.