# Run fair, bot-proof Shopify drops with GPT-4o-mini, WhatsApp and Google Sheets

> Quick overview This workflow runs limited Shopify drops by collecting waitlist entries via webhooks, scoring and filtering bots with OpenAI, drawing size-based winners with weighted randomness, sending expiring claim links via WhatsApp or Gmail, and continuously sweeping expiries while tracking everything in Google Sheets and notifying Slack. How it works 1. Receives waitlist signups via a POST webhook, normalizes the entry, and checks in Google Sheets whether the selected drop and size are currently open. 2. Looks up prior entries and member history in Google Sheets and pulls Shopify customer order counts to calculate loyalty weight and bot-risk signals. 3. Uses rules and, for borderline cases, OpenAI (gpt-4o-mini) to classify entries as accepted, review, or rejected, then saves the result to the Entries sheet and returns a JSON confirmation. 4. Every 5 minutes, checks Google Sheets for drops that have closed, loads stock by size, performs a seeded weighted draw to assign invited winn

- **Domain**: `n8n-workflow-22546.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/22546
- Page (HTML): https://agenstry.com/agents/n8n-workflow-22546.n8n.io
- Documentation: https://n8n.io/workflows/22546
