You are helping me build the following AI agent workflow.

## Goal
Competitor Affiliate Program Analysis: Twice daily, it scrapes competitor affiliate terms, scores threat levels via AI, and alerts you to critical gaps in Slack or email.

## Specification
- What it does: Stay ahead of competitor affiliate programs by receiving twice-daily alerts on critical gaps via Slack or email. You get AI-scored threat levels based on scraped commission rates and terms, with all data tracked in Google Sheets for easy reference.
- Trigger: On a schedule (Scheduled · twice daily)
- Autonomy: Fully hands-off
- Expected setup effort: under an hour
- Tools/services involved:
  - Bright Data: Web scraping competitor sites
  - Code: AI scoring and analysis logic
  - Google Sheets: Logging historical data
  - Slack: Sending threat alerts
  - Send Email: Generating report emails

## Known pitfalls, handle each one explicitly in your implementation
1. Competitor websites often block automated scrapers so you must configure Bright Data with rotating residential proxies and respect robots.txt policies.
2. LLM token limits can truncate long analysis outputs so keep your prompt concise and request structured JSON responses to ensure reliable parsing.
3. Google Sheets row insertion failures can cause data loss so implement error handling that logs failed attempts to a separate error sheet for manual review.

## Reference implementation
https://n8n.io/workflows/10176 (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/competitor-affiliate-program-analysis/ via usecasesforagents.com