Automate Review Requests with n8n

Webhook Trigger
    ↓
Set Node (format data)
    ↓
HTTP Request
  POST https://youragency.com/api/webhooks/inbound/{token}
  Body Content Type: JSON
  Body: { first_name, last_name, email, phone, completed_at }
    ↓
IF (2xx response)
  → Slack notification
  → Log to Google Sheets

Schedule Trigger (every 5 min)
    ↓
PostgreSQL
  SELECT * FROM jobs
  WHERE status = 'completed'
  AND review_sent = false
    ↓
Loop Over Items
    ↓
HTTP Request
  POST https://youragency.com/api/webhooks/inbound/{token}
  Body: { name, email, phone, completed_at }
    ↓
PostgreSQL
  UPDATE jobs SET review_sent = true

Webhook Trigger
    ↓
Switch Node (service_type)
  → "plumbing"   → HTTP Request (endpoint A)
  → "electrical" → HTTP Request (endpoint B)
  → "hvac"       → HTTP Request (endpoint C)

Each endpoint is its own connection,
tied to its own campaign.

Webhook Trigger (job completed)
    ↓
HTTP Request
  POST https://youragency.com/api/webhooks/inbound/{token}
  Body: { name, email, phone, completed_at }

Timing lives in EmbedMyReviews:
  completed_at + 24 hours, or next morning
  (workflow finishes as soon as it posts)