Tech With Galvan
Back to Articles
AutomationJan 24, 2029 • 5 min read

How to Automate Feedback Surveys and Act on Bad Scores

Automate customer feedback surveys — NPS, CSAT, and custom surveys with automated follow-up for low scores. Tools and Python code included.

Galvan
Galvan

Founder & Creator

Introduction

Most businesses collect feedback and do nothing with it. A customer rates you 2/5, and nobody follows up. That’s a lost customer — and a missed opportunity to fix a real problem.

Automated feedback surveys with smart follow-up ensure that every piece of feedback gets a response. This post shows you how to build a system that collects, scores, and acts on feedback automatically.

The feedback funnel

Service completed → Survey sent (Day 1) → Score received
    ├── High score (4-5/5 or NPS 9-10) → Thank you + review request
    ├── Medium score (3/5 or NPS 7-8) → Thank you + "what can we improve?"
    └── Low score (1-2/5 or NPS 0-6) → Alert owner + personal follow-up + recovery offer

The key: different scores trigger different actions.

Survey types

NPS (Net Promoter Score)

“How likely are you to recommend us to a friend?” (0-10)

  • Promoters (9-10): Loyal customers who will refer others
  • Passives (7-8): Satisfied but not enthusiastic
  • Detractors (0-6): Unhappy customers who may leave negative reviews

NPS = % Promoters - % Detractors (range: -100 to +100)

CSAT (Customer Satisfaction)

“How satisfied were you with your experience?” (1-5)

  • 4-5: Satisfied
  • 3: Neutral
  • 1-2: Dissatisfied

Custom survey

Ask specific questions:

  • “How was the service quality?” (1-5)
  • “How was the wait time?” (1-5)
  • “Would you visit again?” (Yes/No)
  • “What could we improve?” (free text)

Step 1: Create the survey

Option A: Google Forms (free)

  1. Create a Google Form with your questions
  2. Add a “Thank you” page with a review link
  3. Get the form URL

Option B: Typeform (polished)

  1. Create a Typeform with your questions
  2. Add logic jumps (different follow-up based on score)
  3. Get the form URL

Option C: Embedded in email

Include a 1-click rating in the email itself:

<p>How was your experience?</p>
<a href="https://yoursite.com/feedback?score=5&customer=123">⭐⭐⭐⭐⭐</a>
<a href="https://yoursite.com/feedback?score=4&customer=123">⭐⭐⭐⭐</a>
<a href="https://yoursite.com/feedback?score=3&customer=123">⭐⭐⭐</a>
<a href="https://yoursite.com/feedback?score=2&customer=123">⭐⭐</a>
<a href="https://yoursite.com/feedback?score=1&customer=123">⭐</a>

One-click surveys get 3-5x higher response rates than multi-question forms.

Step 2: Automate survey sending

import resend, os
from datetime import datetime, timedelta

resend.api_key = os.environ["RESEND_API_KEY"]

def send_survey(customer):
    resend.Emails.send({
        "from": "Your Business <[email protected]>",
        "to": [customer["email"]],
        "subject": f"How was your experience, {customer['name']}?",
        "html": f"""
        <p>Hi {customer['name']},</p>
        <p>Thank you for visiting us! We'd love to hear your feedback.</p>
        <p>How would you rate your experience?</p>
        <div style="font-size: 24px;">
            <a href="{SURVEY_URL}?score=5&customer={customer['id']}">⭐⭐⭐⭐⭐</a><br>
            <a href="{SURVEY_URL}?score=4&customer={customer['id']}">⭐⭐⭐⭐</a><br>
            <a href="{SURVEY_URL}?score=3&customer={customer['id']}">⭐⭐⭐</a><br>
            <a href="{SURVEY_URL}?score=2&customer={customer['id']}">⭐⭐</a><br>
            <a href="{SURVEY_URL}?score=1&customer={customer['id']}">⭐</a>
        </div>
        <p style="margin-top: 20px; color: #666; font-size: 12px;">
            It only takes 5 seconds. Thank you!
        </p>
        """,
    })

Send 1 day after the service (while the experience is fresh).

Step 3: Handle feedback (automated routing)

def handle_feedback(customer_id, score):
    customer = get_customer(customer_id)
    
    if score >= 4:
        # Happy customer → thank you + review request
        send_thank_you(customer)
        send_review_request(customer)
        log_feedback(customer, score, "positive")
        
    elif score == 3:
        # Neutral → thank you + ask what to improve
        send_thank_you(customer)
        send_improvement_question(customer)
        log_feedback(customer, score, "neutral")
        
    else:
        # Unhappy → alert owner + recovery offer
        alert_owner(customer, score)
        send_recovery_offer(customer)
        log_feedback(customer, score, "negative")

def alert_owner(customer, score):
    """Send urgent alert to business owner."""
    resend.Emails.send({
        "from": "Alert System <[email protected]>",
        "to": [OWNER_EMAIL],
        "subject": f"⚠️ Low feedback score: {customer['name']} ({score}/5)",
        "html": f"""
        <h3>Low Feedback Alert</h3>
        <p><strong>Customer:</strong> {customer['name']} ({customer['email']})</p>
        <p><strong>Score:</strong> {score}/5</p>
        <p><strong>Service:</strong> {customer['service']}</p>
        <p><strong>Date:</strong> {customer['service_date']}</p>
        <p>Please follow up personally within 24 hours.</p>
        """,
    })

def send_recovery_offer(customer):
    """Send a recovery offer to unhappy customers."""
    resend.Emails.send({
        "from": "Your Business <[email protected]>",
        "to": [customer["email"]],
        "subject": "We're sorry — let us make it right",
        "html": f"""
        <p>Hi {customer['name']},</p>
        <p>We're sorry your experience wasn't what you expected. Your feedback is important to us.</p>
        <p>We'd like to make it right. Here's a [free/discounted service] on us:</p>
        <a href="{RECOVERY_OFFER_LINK}">Claim Your Offer</a>
        <p>Or reply to this email and we'll personally address your concern.</p>
        """,
    })

Step 4: Track feedback metrics

Build a dashboard to track:

  • Response rate: % of customers who respond to surveys
  • Average score: Overall satisfaction trend
  • NPS: Net Promoter Score over time
  • Negative feedback rate: % of low scores
  • Recovery rate: % of unhappy customers who return
import streamlit as st
import pandas as pd

st.title("📊 Feedback Dashboard")

# Load feedback data
df = load_feedback_from_db()

col1, col2, col3, col4 = st.columns(4)
col1.metric("Total Responses", len(df))
col2.metric("Avg Score", f"{df['score'].mean():.1f}/5")
col3.metric("NPS", calculate_nps(df))
col4.metric("Response Rate", f"{len(df) / total_customers * 100:.1f}%")

# Trend chart
fig = px.line(df, x="date", y="score", title="Feedback Trend")
st.plotly_chart(fig, use_container_width=True)

# Negative feedback
st.subheader("⚠️ Needs Attention")
neg = df[df["score"] <= 2]
st.dataframe(neg, use_container_width=True)

Step 5: Act on feedback

For positive feedback (4-5):

  • Send thank you email
  • Request Google review (see Get More Google Reviews)
  • Add to testimonials (with permission)
  • Share internally (team morale)

For neutral feedback (3):

  • Send thank you email
  • Ask: “What could we do better?”
  • Log the feedback for team review
  • Follow up in 30 days

For negative feedback (1-2):

  • Alert owner immediately (within 1 hour)
  • Personal follow-up within 24 hours (phone call, not email)
  • Offer recovery (discount, free service, refund)
  • Log and analyze — is this a pattern?
  • Fix the root cause — don’t just apologize, fix the problem

Common mistakes

  • Not following up on bad scores — collecting feedback without acting on it is worse than not collecting it
  • Only asking happy customers — this is “review gating” and violates Google’s policy
  • Too many questions — keep surveys to 1-2 questions max (one-click is best)
  • Not tracking trends — a single bad score is an incident; a trend is a problem
  • Ignoring the data — if 3 customers say “wait time is too long,” fix the wait time
  • Not closing the loop — tell customers what you changed based on their feedback

Key Concepts

  • NPS = Net Promoter Score (0-10, % promoters - % detractors)
  • CSAT = Customer Satisfaction Score (1-5)
  • Feedback routing = different actions based on score
  • Recovery offer = compensation for bad experiences
  • Closed-loop feedback = acting on feedback and telling the customer

What to Try Next

FAQ

What’s a good NPS score?

NPS ranges from -100 to +100. Above 0 is good, above 30 is great, above 50 is excellent. Most businesses are between 0-30. Track your trend over time — improving NPS is more important than the absolute number.

How many survey questions should I ask?

1-2 questions max. One-click rating (1-5 stars) + optional comment. Longer surveys get lower response rates. If you need more data, send a follow-up survey to customers who responded.

Should I survey every customer?

Yes — but at the right time. Send 1 day after the service (while the experience is fresh). Don’t survey the same customer more than once per month. Use a cooldown period. See Automate Customer Follow-Ups.