{"product_id":"n8n-workflow-monitor-app-reviews-w-gemini-sheets-slack-gmail","title":"n8n Workflow: Monitor App Reviews w\/ Gemini, Sheets, Slack \u0026 Gmail","description":"\u003ch3\u003eSpot negative app reviews instantly—and get AI-assisted responses with n8n\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e with an AI-suggested reply when critical.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e: execute the workflow in n8n by clicking \u003cem\u003eExecute workflow\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches and normalizes reviews\u003c\/strong\u003e: calls your configured \u003cstrong\u003eHTTP Request\u003c\/strong\u003e endpoint to retrieve a batch of app reviews, then converts them into one item per review (including rating, platform, and device details).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI sentiment analysis with Gemini\u003c\/strong\u003e: sends each review to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate a sentiment label, sentiment score, and confidence, then parses the JSON output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI support category classification\u003c\/strong\u003e: runs the review through \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e again to classify it into a single support category (e.g., Bug, Payment, Crash) and parses the JSON response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs negative reviews to Google Sheets\u003c\/strong\u003e: if sentiment is \u003cem\u003eNegative\u003c\/em\u003e, the workflow appends or updates a row with review details, sentiment, and category.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack + Gmail alerts with suggested replies\u003c\/strong\u003e: when a negative review meets the workflow’s critical conditions, it posts an alert to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel, generates a short AI-suggested reply with Gemini, and emails the review details plus the suggested response via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce time-to-response for \u003cstrong\u003enegative mobile app reviews\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCentralize review triage in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for reporting and tracking.\u003c\/li\u003e\n  \u003cli\u003eStreamline customer support workflows by routing urgent issues to \u003cstrong\u003eSlack\u003c\/strong\u003e and sending AI-assisted email replies through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e nodes for sentiment, categorization, and reply generation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for logging negative reviews\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e for team alerts\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for emailing review details and the suggested response\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e nodes for workflow clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup highlights\u003c\/h3\u003e\n\u003cp\u003eConnect \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e credentials for the three Gemini nodes, update the \u003cstrong\u003eHTTP Request\u003c\/strong\u003e node to your reviews API endpoint (and authentication options if needed), and configure \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with your spreadsheet\/document ID.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46206051483827,"sku":"N8N-20782","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/01KYb6T6QQcUUH1Xw9lvj_PQjtBUdy.png?v=1791796106","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-monitor-app-reviews-w-gemini-sheets-slack-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}