{"product_id":"reply-to-google-reviews-with-openai-slack-approval-n8n","title":"Reply to Google Reviews with OpenAI + Slack Approval (n8n)","description":"\u003ch3\u003eReply to Google Reviews with OpenAI drafts—Slack approval included (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your \u003cb\u003eGoogle Business Profile\u003c\/b\u003e for new customer reviews, uses \u003cb\u003eOpenAI\u003c\/b\u003e to draft replies and classify the complaint root-cause, then sends any potential issue replies to \u003cb\u003eSlack\u003c\/b\u003e for approval before posting—while logging everything to \u003cb\u003eGoogle Sheets\u003c\/b\u003e and emailing a weekly Gmail report.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003ePolls Google Business Profile hourly\u003c\/b\u003e for new reviews and ignores reviews that already have an \u003cb\u003eowner reply\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes each review\u003c\/b\u003e into consistent fields (review ID, author name, date, star rating number, and review text).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cb\u003eOpenAI\u003c\/b\u003e to generate a \u003cb\u003eshort draft reply\u003c\/b\u003e plus sentiment, a \u003cb\u003esingle root-cause category\u003c\/b\u003e, an optional staff name, and a brief complaint summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs every enriched review\u003c\/b\u003e to \u003cb\u003eGoogle Sheets\u003c\/b\u003e, including fixable status and reply status.\u003c\/li\u003e\n  \u003cli\u003eFor \u003cb\u003e4–5 star reviews with no complaint\u003c\/b\u003e, it automatically posts the reply to Google Business Profile.\u003c\/li\u003e\n  \u003cli\u003eFor other reviews, it \u003cb\u003esends the drafted reply to Slack\u003c\/b\u003e for approve\/decline.\u003c\/li\u003e\n  \u003cli\u003eWhen approved in Slack, it \u003cb\u003eposts the approved reply\u003c\/b\u003e back to Google Business Profile.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEvery Monday at 9 AM\u003c\/b\u003e, it reads the last 7 days from Google Sheets, calculates \u003cb\u003estars lost\u003c\/b\u003e (5 minus rating) by fixable root-cause tag, writes a short HTML insight using OpenAI, and emails the owner via \u003cb\u003eGmail\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal businesses and multi-location teams that need fast, consistent Google review responses.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing reputation workflows across many reviews without manual triage.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an approval-based support\/reputation process in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Google Business Profile (OAuth2), \u003cb\u003eOpenAI\u003c\/b\u003e (API key), \u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth2), \u003cb\u003eSlack\u003c\/b\u003e (OAuth2), \u003cb\u003eGmail\u003c\/b\u003e (OAuth2).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNodes \/ building blocks:\u003c\/b\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCore logic:\u003c\/b\u003e hourly polling, “has owner reply” filtering, OpenAI drafting + root-cause tagging, Slack approval routing, and weekly star-loss reporting.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081393328307,"sku":"N8N-19885","price":40.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ftvS98qbBDyl2-f7P63Cc_p7G1kXDS.png?v=1790240732","url":"https:\/\/buyflowscripts.com\/products\/reply-to-google-reviews-with-openai-slack-approval-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}