n8n Workflow: Monitor App Reviews w/ Gemini, Sheets, Slack & Gmail

Spot negative app reviews instantly—and get AI-assisted responses with n8n

This n8n workflow monitors mobile app reviews from an HTTP endpoint, analyzes each review with Google Gemini (sentiment + support category), logs negatives to Google Sheets, and alerts your team in Slack and Gmail with an AI-suggested reply when critical.

What this workflow does

• Runs on demand: execute the workflow in n8n by clicking Execute workflow.
• Fetches and normalizes reviews: calls your configured HTTP Request endpoint to retrieve a batch of app reviews, then converts them into one item per review (including rating, platform, and device details).
• AI sentiment analysis with Gemini: sends each review to Google Gemini to generate a sentiment label, sentiment score, and confidence, then parses the JSON output.
• AI support category classification: runs the review through Google Gemini again to classify it into a single support category (e.g., Bug, Payment, Crash) and parses the JSON response.
• Logs negative reviews to Google Sheets: if sentiment is Negative, the workflow appends or updates a row with review details, sentiment, and category.
• Slack + Gmail alerts with suggested replies: when a negative review meets the workflow’s critical conditions, it posts an alert to a Slack channel, generates a short AI-suggested reply with Gemini, and emails the review details plus the suggested response via Gmail.

Use cases

• Reduce time-to-response for negative mobile app reviews.
• Centralize review triage in Google Sheets for reporting and tracking.
• Streamline customer support workflows by routing urgent issues to Slack and sending AI-assisted email replies through Gmail.

Technical details

• if, code, http request
• Google Gemini nodes for sentiment, categorization, and reply generation
• Google Sheets for logging negative reviews
• Slack for team alerts
• Gmail for emailing review details and the suggested response
• Sticky Note nodes for workflow clarity

Setup highlights

Connect Google Gemini credentials for the three Gemini nodes, update the HTTP Request node to your reviews API endpoint (and authentication options if needed), and configure Google Sheets with your spreadsheet/document ID.