Attribution: Inspired by Google Workspace with Gemini Prompting Guide 101 (2025). Transformed and expanded by 6DuckLearn.
Overview
For customer support specialists and managers. Turn raw feedback data into insights, simplify policies into self-service content, and design follow-up surveys — using Gemini across Sheets, Docs, and Gmail.
Prompt Templates
Analyze feedback trends from a spreadsheet
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. (Gemini app — upload the file)
Simplify return policy into 5 clear steps
Summarize this content to write a clear and concise product return policy. Outline 5 sequential steps for customers to follow. (Gemini in Docs)
Turn policies into a self-service blog post
Take this content and turn it into a short blog titled "Resolve Common Issues Without Agent Assistance." Include separate sections for our return policy, refund policy, and store credit policy. (Gemini in Docs)
Create post-call survey questions
Create five questions for customers who just spoke to a support agent. Questions should gauge: how effective the call was, if their concern was addressed, and if they would recommend our business to others. (Gemini in Docs)
Email template for self-service resources
Draft an email template to a customer that highlights self-service resources referencing [blog link] for [support issues]. Thank them for their business and assure them of our commitment to meeting their needs. (Gemini in Docs)
Request a follow-up call with a dissatisfied customer
Request a follow-up conversation on [date] at [time] with this customer who provided negative feedback to understand their concern and offer resolutions. Include example solutions. (Gemini in Gmail)
Workflow
Feedback spreadsheet → analyze trends → simplify policies → publish self-service blog → create post-call survey → close the loop with dissatisfied customers.