Google Review Replies Automation: DeepSeek + Sheets + Discord

Turn Google Reviews into ready-to-send responses—automatically

This n8n workflow receives Google review payloads via a webhook, uses DeepSeek (via OpenAI) to draft personalized reply text, logs everything to Google Sheets, and keeps your team updated in Discord. It also runs a weekly scheduled digest and handles invalid or negative reviews with Gmail notifications for approval.

What this workflow does

• Ingests reviews via HTTP POST webhook and normalizes key fields (business name, reviewer, rating, and review text).
• Validates payloads: checks required fields and ensures rating is between 1 and 5. If invalid, it alerts your Discord and sends a Gmail notice.
• Drafts AI replies with DeepSeek (via OpenAI): generates a JSON response with sentiment, a 2–4 sentence reply draft, and a human-review flag.
• Logs to Google Sheets: appends the original review, AI draft reply, and metadata to a “Reviews” log for traceability.
• Notifies your team in Discord with the review + draft response. If the review is negative (rating ≤ 2 or negative sentiment), it emails the draft to the owner via Gmail for approval.
• Weekly scheduled digest (Mondays): reads the Sheets log, computes weekly stats, and posts an “all clear” message to Discord if there were no reviews. If there are reviews, it uses DeepSeek (via OpenAI) to write a short digest, then emails it via Gmail and posts it to Discord.

Use cases

• Local service businesses managing multiple Google review sources and needing faster, consistent responses.
• SaaS operators who want automated Google review replies automation with human approval for negative feedback.
• n8n users who need a reliable workflow for review tracking, audit logs, and weekly performance updates.

Technical details

• Webhook trigger (HTTP POST) + if, set, and code nodes for normalization and validation.
• DeepSeek via OpenAI for AI reply generation (JSON output with sentiment and draft reply).
• Google Sheets for persistent review logging (Reviews sheet).
• Discord notifications for new drafts and weekly updates.
• Gmail alerts for invalid payloads and negative review approval, plus weekly digest delivery.