Gemini Prompt for Analyzing a Survey
Surveys are powerful tools for collecting data, but their true value lies in analyzing the results. Gemini, Google's artificial intelligence model, excels at interpreting qualitative and quantitative survey data. Whether you have collected responses via Google Forms, Typeform, or any other tool, Gemini can identify hidden trends, cross-reference demographic variables with responses, and produce actionable summaries in seconds. While manual analysis would take hours of sorting and categorizing, 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 transform raw data into strategic recommendations. In this guide, you will find an optimized prompt for Gemini as well as variants adapted to your expertise level and survey complexity.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a data analyst specialized in survey analysis. I will provide you with survey results. Your goal is to produce a comprehensive and structured analysis.
Here are the survey results:
[PASTE SURVEY DATA HERE]
Perform the following analysis following this structure:
- Executive Summary: Synthesize the 3 to 5 key takeaways in a few sentences.
- Quantitative Analysis: For each closed question, indicate response percentages, dominant trends, and significant deviations.
- Qualitative Analysis: For each open-ended question, group responses by theme, rank by frequency, and identify the overall sentiment (positive, neutral, negative).
- Cross-tabulations and Correlations: Identify links between demographic variables (age, role, tenure…) and responses. Report any notable correlations.
- 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 verbatim quotes to illustrate qualitative trends.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
This prompt leverages the role assignment 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 handle each data type with the appropriate methodology, while the request for cross-tabulations and limitations pushes Gemini beyond simple description to produce a rigorous interpretation.
Use Cases
Variants
Expected Output
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 ends with actionable recommendations and a methodological note on analysis limitations.
Frequently Asked Questions
What format should I provide my survey data in to Gemini?
Gemini accepts data in several formats. The most efficient method 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 upload Google Sheets, CSV, or Excel files directly. 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 actually 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 process in batches or use Gemini in Google Sheets with the AI extension. However, note that Gemini does not perform statistical calculations in the strict sense; 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 using Gemini?
Provide the results of both waves in the same prompt, clearly identifying them (for example: "Wave 1 - January 2026" and "Wave 2 - March 2026"). Add to your instructions: "Compare the results of the two waves, identify significant changes (improvements and declines), calculate the percentage point differences, and propose explanatory hypotheses for the observed changes." Gemini will then produce a comparative table with trends and an interpretation of the movements between the two periods.
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt Guide📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Multichannel marketing data analysis
Complete multichannel marketing performance analysis with ROI calculation, attribution models, and budget optimization.
Choose the right visualization for your data
Guide the choice of optimal chart type based on data, audience, and message to communicate.
Web analytics metrics analysis
Comprehensive web analytics metrics analysis to understand visitor behavior and identify optimization areas.
ChatGPT Prompt for Analyzing a Survey
Survey analysis is a crucial step for transforming raw data into actionable insights. Whether you collected responses via Google Forms, Typeform, or any other tool, ChatGPT can help you identify trends, segment respondents, and draw relevant conclusions in minutes. Where an analyst would spend hours cross-referencing variables and writing a report, AI significantly speeds up the process while maintaining methodological rigor. This prompt is designed to guide ChatGPT through a structured analysis of your survey results: synthesis of quantitative data, interpretation of open-ended responses, identification of significant correlations, and formulation of concrete recommendations. It works equally well for a customer satisfaction survey, a market study, or an internal questionnaire. The proposed approach combines descriptive statistical analysis and thematic qualitative analysis, offering you a complete and nuanced view of your results without requiring advanced data science skills.