Weekly CRM hygiene report for marketing ops

Build me an agent workflow that produces a weekly CRM hygiene report for the marketing ops team.

Trigger: a cron schedule that runs every Monday at 8:00am local time.

When the workflow runs, the agent should:

1. Use HubSpot Search Contacts to pull every contact whose createdate or lastmodifieddate falls in the last 7 days. Page through results until there are no more (HubSpot search caps at 10,000 total). Collect each contact's id, email, firstname, lastname, lifecyclestage, and hubspot_owner_id.

2. Deduplicate the email list and drop any contacts with no email. Send the remaining addresses through ZeroBounce Batch Validate Emails in groups of up to 200 per call. Be patient with the response: batch validate can take up to 70 seconds, so do not bail early. Page through batches until every address has been validated.

3. Group the validation results into buckets: Valid (status = valid), Catch-all (status = catch-all), Risky (status = do_not_mail with sub-status disposable, role_based, spamtrap, abuse, or toxic), and Undeliverable (status = invalid, or sub-status mailbox_not_found / does_not_accept_mail / failed_smtp_connection). Count each bucket and compute the share of the total.

4. Pick the 10 worst offenders across Risky and Undeliverable, preferring contacts that are higher up the funnel (lifecyclestage of customer or opportunity over subscriber). For each, include the contact name, email, bucket, sub-status, and HubSpot record link.

5. Call ZeroBounce Get Credit Balance and note the remaining credits.

6. Draft a written digest (plain text or simple HTML) that includes: a one-paragraph summary of deliverability impact for the week, a counts-by-bucket table with percentages, the 10 riskiest addresses with a recommended action for each (remove, suppress, re-verify, or keep), a one-sentence recommended next step per bucket, and the ZeroBounce credit balance footer.

7. Send the digest with Gmail Send a Message to marketing-ops@ (let the user override the address at setup time). Subject line should be "Weekly CRM hygiene report — week of <Monday's date>".

The workflow is read-only against HubSpot. Do not write back to contacts, do not create tasks, do not delete anything. If a step errors (HubSpot 429, ZeroBounce credit exhausted, Gmail send failure), include the error in the digest so the team knows the run was partial, and still attempt the Gmail send with whatever data was collected.