Gemini Prompt to Analyze a Survey

Surveys are powerful tools for gathering data, but their true value lies in analyzing the results. Gemini, Google's artificial intelligence model, excels at interpreting qualitative and quantitative data from surveys. Whether you collected responses via Google Forms, Typeform, or any other tool, Gemini can identify hidden trends, cross demographic variables with responses, and produce actionable summaries in seconds. Where manual analysis would take hours of sorting and categorization, Gemini automatically structures verbatims, detects dominant sentiments, and quantifies recurring themes. This capability is particularly useful for marketing teams, researchers, product managers, and consultants who need to quickly turn raw data into strategic recommendations. In this guide, you will find an optimized prompt for Gemini as well as variants adapted to your level of expertise and the complexity of your survey.

The prompt

Gemini

You are a data analyst specialized in survey analysis. I will provide you with survey results. Your goal is to produce a complete and structured analysis.

Here are the survey results:
[PASTE SURVEY DATA HERE]

Conduct the following analysis following this structure:

Executive summary: Summary of the 3 to 5 major findings in a few sentences.
Quantitative analysis: For each closed question, indicate response percentages, dominant trend, and significant gaps.
Qualitative analysis: For each open-ended question, group responses by theme, rank them by frequency, and identify the general sentiment (positive, neutral, negative).
Cross-tabulations and correlations: Identify links between demographic variables (age, role, tenure…) and responses. Highlight any notable correlation.
Points of attention: List weak signals, surprising results, or contradictions in the data.
Recommendations: Propose 5 concrete and priority actions based on the results.
Limitations of the analysis: Mention potential biases, sample size, and interpretation precautions.

Adopt a professional and factual tone. Use tables to present numerical data. Cite representative verbatims to illustrate qualitative trends.

Personalize this prompt with Léa

Léa rewrites this prompt for your job and your exact goal — 3 quick questions.

Why it works

This prompt leverages the role-setting framework (data analyst) to activate Gemini's analytical skills, combined with a very detailed output structure that eliminates ambiguity. The explicit separation between quantitative and qualitative analysis forces the model to process each data type with the appropriate methodology, while the request for cross-tabulations and limitations pushes Gemini beyond mere description to produce rigorous interpretation.

Expected result

Gemini produces a structured analysis report in 7 sections, including percentage tables for closed questions, thematic grouping of open-ended responses with illustrative verbatims, and correlations between respondent profiles and answers. The deliverable concludes with actionable recommendations and a methodological note on the limitations of the analysis.

Variants by level

FAQ

In what format should I provide my survey data to Gemini?

Gemini accepts data in several formats. The most efficient is to copy and paste a table directly from Google Sheets or Excel (columns and rows are interpreted automatically). You can also provide data in CSV format, as structured text with separators, or even as a list of responses. For large files, use Gemini Advanced which allows you to directly upload Google Sheets, CSV, or Excel files. Be sure to include column headers so Gemini understands the structure of your data.

Can Gemini analyze a survey with hundreds of open-ended responses?

Yes, this is one of Gemini's strengths thanks to its large context window (up to 1 million tokens with Gemini 1.5 Pro). The model can process hundreds of verbatims, group them by theme, and extract trends. For very large volumes (over 1000 responses), it is recommended to proceed in batches or use Gemini in Google Sheets with the AI extension. However, note that Gemini does not perform strict statistical calculations; it estimates proportions. For absolute statistical rigor, supplement with a dedicated tool like SPSS or R.

How can I get a comparative analysis between two survey waves with Gemini?

Provide the results of both waves in the same prompt by clearly identifying them (e.g., "Wave 1 - January 2026" and "Wave 2 - March 2026"). Add in your instruction: "Compare the results of the two waves, identify significant changes (improvements and deteriorations), calculate the differences in percentage points, and propose explanatory hypotheses for the observed changes." Gemini will then produce a comparative table with trends and an interpretation of the shifts between the two periods.

How to use this prompt

Copy the prompt with the button above.
Paste it into ChatGPT, Claude or your favorite AI assistant.
Replace the bracketed variables with your details, then refine the result.

About Prompt Guide

Prompt Guide is a free library of 4800+ ready-to-use prompts for ChatGPT, Claude and other AIs, with guides to learn prompting and tools to build and optimize your own prompts.

Prompt library Learn prompting Prompt builder Prompt optimizer

Already have a prompt?

Paste it into the Optimizer, AI improves it in 5 seconds: role, context, format. Free, no signup.

Open the Optimizer

More prompts to explore

Gemini Prompt to Create a Social Media Strategy

Social networks have become an essential lever for any business looking to increase its visibility, engage its community, and generate qualified leads.

GitHub Copilot Prompt for Analyzing an Annual Report

GitHub Copilot, initially designed as a development assistant, also proves formidable for analyzing complex documents such as annual reports.

GitHub Copilot Prompt for Analyzing Customer Reviews

GitHub Copilot, GitHub's AI assistant integrated into code editors, is not limited to code generation. It also excels at analyzing textual data like customer reviews. By leveraging its natural language processing capabilities directly in your development environment, you can automate sentiment extraction, thematic categorization, and trend identification from thousands of user feedback items. Whether you're working on a Python script, a Jupyter notebook, or a Node.js application, Copilot helps you structure your analysis pipelines without leaving your IDE. This approach is particularly valuable for product and data teams who want to turn raw reviews into actionable insights: detecting recurring pain points, evaluating satisfaction by feature, and tracking sentiment evolution over time. The prompt we offer here is designed to guide Copilot in creating a comprehensive analysis system, from data parsing to generating summary reports usable by business teams.

GitHub Copilot Prompt for Analyzing Market Trends

GitHub Copilot, initially designed as a development assistant, proves to be a powerful tool for market trend analysis when used with the right prompts. By leveraging its code generation and data analysis capabilities, you can automate data collection, processing, and visualization directly in your development environment.

GitHub Copilot Prompt for Analyzing User Feedback

Analyzing user feedback is crucial for improving a product, service, or customer experience. However, manually processing hundreds or thousands of comments—whether from reviews, support tickets, NPS forms, or social media—is a significant undertaking. GitHub Copilot, with its natural language understanding capabilities built directly into your code editor, can automate this analysis with remarkable accuracy. By crafting appropriate prompts, you can ask Copilot to categorize sentiments, extract recurring themes, identify priority friction points, and generate actionable summaries for your product teams. Whether you're working with CSV files, JSON exports, or raw data copied from a support tool, Copilot turns your IDE into a full-fledged qualitative analysis platform. This approach is especially useful for developers and product managers who want to integrate feedback analysis directly into their technical workflow, without relying on expensive third-party tools or advanced data science skills.

GitHub Copilot Prompt for Automating Customer Service

GitHub Copilot, GitHub's AI-powered code assistant, proves to be a formidable ally for automating customer service. By leveraging its capabilities...

Go further

How to prompt Gemini

The complete guide: techniques, examples and best practices.

Free prompt library

4800+ prompts sorted by category, one-click copy.

Get new prompts every week

Join our newsletter.