6DuckLearn Skills

feedback trend analysis

Analyse trends and patterns in a customer feedback spreadsheet using Gemini. Trigger when you need to surface insights from raw feedback data, spot categories with rising complaint volume, or investigate customer sentiment shifts over time.

data-processing Tags: curated, google-workspace, customer-feedback, support, analytics

Attribution: Prepared by 6DuckLearn. Inspired by Google Workspace with Gemini Prompting Guide 101 (2025).

When to use this

You're a customer support specialist or manager with a spreadsheet of raw feedback and you need to quickly identify which categories are spiking, why customer outreach is increasing, and where to focus the team's attention.

What you'll get

A structured analysis of feedback trends by category and time period — including the top patterns, notable increases in contact volume, and likely root causes worth investigating.

Prompt template

Use this in the Gemini app (upload the spreadsheet file):

I am a customer support specialist. Using the attached spreadsheet, identify trends and patterns in [customer feedback] by [category] over [time period]. Highlight areas where [customer outreach] has increased significantly and investigate potential reasons.

Fill in the variables:

  • [customer feedback] — describe the feedback type (e.g. "product reviews", "support ticket notes", "post-purchase survey responses")
  • [category] — how you want grouping done (e.g. "product line", "issue type", "agent team", "region")
  • [time period] — the date range to analyse (e.g. "Q1 2025", "the last 90 days", "January–March vs April–June")
  • [customer outreach] — the metric to highlight (e.g. "repeat contacts", "escalations", "refund requests")

Customisation tips

  • Attach the spreadsheet directly in the Gemini app — it reads column headers automatically, so clean header names improve output quality
  • Add "Rank the top 3 categories by volume" to get a prioritised list
  • Specify the output format: "Present your findings as a bullet-point executive summary followed by a table"
  • If the sheet covers multiple products or regions, mention which ones to focus on

Iteration suggestions

After Gemini responds:

  1. Simplify policies that address top issues → use return-policy-simplification to turn complex policy text into clear customer steps
  2. Create self-service content → use self-service-blog-from-policy to turn the findings into a blog post
  3. Design a follow-up survey → use post-call-survey-questions to capture structured data on the issues uncovered

Related skills in this workflow

Step Skill What it does
1 → You are here feedback-trend-analysis Analyse trends in feedback spreadsheet
2 return-policy-simplification Simplify return policy into 5 clear steps
3 self-service-blog-from-policy Turn policies into self-service blog post
4 post-call-survey-questions Create post-call survey questions
5 self-service-email-template Email template for self-service resources
6 dissatisfied-customer-followup Request follow-up call with unhappy customers

Related skills

  • dissatisfied customer followup — Request a follow-up call with a customer who left negative feedback — acknowledge their concern and offer concrete resolutions. Trigger when you need to close the loop with an unhappy customer via Gmail.
  • post call survey questions — Generate post-call customer satisfaction survey questions that measure call effectiveness, issue resolution, and likelihood to recommend. Trigger when setting up CSAT or NPS surveys after support interactions.
  • return policy simplification — Simplify a complex return policy document into 5 clear sequential steps customers can follow. Trigger when you have dense policy text and need to transform it into scannable, actionable customer-facing instructions.
  • self service blog from policy — Turn support policy documents into a short self-service blog post covering return, refund, and store credit policies. Trigger when you want customers to resolve common issues without contacting an agent.
  • self service email template — Draft a customer email that highlights self-service resources and a blog link for common support issues. Trigger when you want to proactively deflect support contacts by pointing customers to help content.
  • gemini customer feedback analysis — Analyze feedback trends from spreadsheets, simplify return policies, create self-service content, and run voice-of-customer surveys