# Reply to Google reviews and send weekly insights with OpenAI and Slack

> Quick overview This workflow monitors new Google Business Profile reviews, uses OpenAI to draft replies and tag a single root-cause category, routes complaint replies to Slack for approval, logs every review to Google Sheets, and emails a weekly Gmail report summarizing the fixable issue that cost the most stars. How it works 1. Polls Google Business Profile hourly for new reviews and ignores any reviews that already have an owner reply. 2. Normalizes each review into consistent fields (ID, author name, date, star rating number, and review text). 3. Uses OpenAI to generate a short draft reply plus sentiment, a single root-cause tag, optional staff name, and a brief complaint summary. 4. Logs the enriched review (including fixable flag and reply status) to a Google Sheets review log. 5. Automatically posts the reply back to Google Business Profile for 4–5 star reviews tagged as having no complaint, and sends all other drafted replies to Slack for approve/decline. 6. Posts the approved r

- **Domain**: `n8n-workflow-19885.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/19885
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19885.n8n.io
- Documentation: https://n8n.io/workflows/19885