Communication Intermediate

Collect AI-Powered Customer Feedback with GPT-4o and Slack Alerts

Pull closed support tickets from Google Sheets, send tailored feedback emails via Gmail, and route AI-scored responses to Slack for the support team to review.

At a glance

Collect AI-Powered Customer Feedback with GPT-4o and Slack Alerts is an intermediate-level communication automation built with n8n. Trigger personalized feedback requests on closed tickets, log answers, and alert Slack.

Tools required
n8n
Tags
#customer-feedback #gpt-4o #google-sheets #slack #gmail
Difficulty
Intermediate
Published
· 1 min read

How It Works

The workflow fetches support ticket records from a Google Sheets database, filters only tickets marked as closed, and sends each customer a personalized feedback request through Gmail. Each email includes the ticket ID, subject, customer name, and a dynamic link to a survey form so responses map back to the original interaction.

Setup Steps

  1. Prepare the Sheet: Build a Google Sheet with Status, Ticket No., Description, Email, and Owner columns, and populate it with the ticket export.
  2. Connect Credentials: Authenticate the Google Sheets and Gmail nodes in n8n with OAuth2 credentials for the relevant service account.
  3. Configure the Survey Link: Edit the Gmail node to point the dynamic link at your Typeform or Google Form survey URL.
  4. Import the Workflow: Load the template JSON into n8n and assign the connected credentials to the Google Sheets and Gmail nodes.
  5. Run and Verify: Fire the manual trigger, confirm emails reach the test ticket inboxes, then swap the trigger for a schedule or webhook to automate ongoing campaigns.

Automation Workflow

Manual Trigger → Google Sheets (Ticket Status)
↓
Filter (Status = closed) → Gmail (Personalized Feedback Email)
↓
GPT-4o (Score Response) → Slack (Low-Score Alert)

Benefits

Use Cases

Related Automations