{"product_id":"automate-nps-survey-replies-with-openai-google-sheets","title":"Automate NPS Survey Replies with OpenAI \u0026 Google Sheets","description":"\u003ch3\u003eEffortlessly Automate NPS Survey Replies with OpenAI \u0026amp; Google Sheets\u003c\/h3\u003e\n\n\u003cp\u003eEnhance your customer experience management by automating your Net Promoter Score (NPS) survey replies. This n8n workflow reads new survey responses from Google Sheets, leverages OpenAI for generating personalized email replies, and sends them via Gmail. Finally, it efficiently routes responses for additional actions based on promoter, passive, or detractor classifications.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns every 6 hours to process fresh NPS survey responses from a designated Google Sheets tab.\u003c\/li\u003e\n  \u003cli\u003eFilters responses to keep only those with a \"new\" status, ensuring no double handling.\u003c\/li\u003e\n  \u003cli\u003eParses NPS scores and classifies each response into Promoter, Passive, or Detractor categories.\u003c\/li\u003e\n  \u003cli\u003eUtilizes OpenAI's Chat Completions to craft a personalized email tailored to each respondent, complete with a unique segment-specific subject line.\u003c\/li\u003e\n  \u003cli\u003eSends the email via Gmail to maintain seamless communication with your customers.\u003c\/li\u003e\n  \u003cli\u003eAppends positive promoter comments to a separate Google Sheets testimonials tab for future reference.\u003c\/li\u003e\n  \u003cli\u003eMarks all processed responses with a \"Processed\" status to keep track of completed tasks.\u003c\/li\u003e\n  \u003cli\u003eAutomatically alerts your support team about detractor responses via email so immediate attention can be given.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse Cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators looking to streamline customer feedback management and deepen customer connections through timely, personalized communications.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers seeking to reduce manual effort associated with handling NPS survey responses, ensuring no feedback falls through the cracks.\u003c\/li\u003e\n  \u003cli\u003eCustomer support teams that require a systematic way to track and respond to NPS survey responses with minimal manual intervention.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical Details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations used: Google Sheets, OpenAI (Chat Completions), Gmail.\u003c\/li\u003e\n  \u003cli\u003eKey nodes involved: code, gmail, filter, switch, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003eEasy setup: Add credentials for Google Sheets, Gmail, and OpenAI in n8n, replace placeholders like YOUR_NPS_SHEET_ID, and configure a support team email for alerts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45695002345651,"sku":"N8N-17148","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/A6UhJs1L5Y2c6f26Gon4j_26825c4b86944b51938a1da3ab8dbdee.jpg?v=1784192869","url":"https:\/\/buyflowscripts.com\/products\/automate-nps-survey-replies-with-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}