P

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:

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

  1. Copy the prompt with the button above.
  2. Paste it into ChatGPT, Claude or your favorite AI assistant.
  3. 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.

More prompts to explore

Gemini Prompt to Automate Tasks

Gemini, Google's artificial intelligence, offers remarkable capabilities to automate repetitive and time-consuming tasks. Whether you are an entrepreneur, manager, or freelancer, AI automation transforms your daily productivity. Thanks to its contextual understanding and structured generation capabilities, Gemini can design complete workflows, write automation scripts, create sorting and data processing rules, and orchestrate multi-step processes. The challenge is no longer whether you should automate, but how to formulate your requests to obtain reliable and maintainable automations. A well-constructed prompt enables Gemini to understand not only the task to automate, but also the business context, edge cases to handle, and success criteria. In this guide, you will discover an optimized main prompt to transform any repetitive task into an automated process, as well as variants adapted to your expertise level. Each prompt has been designed to produce immediately actionable results, whether for automating email processing, report generation, file management, or orchestrating complex workflows.

Gemini Prompt to Create a Brand Style Guide

Creating a brand style guide is a fundamental step for any brand wishing to establish its visual identity. Traditionally entrusted to experienced designers, this task can now be greatly facilitated with the help of artificial intelligence.

Gemini Prompt to Create a Business Plan

Creating a solid business plan is a crucial step for any entrepreneur, but the process can be long and complex. Gemini, the artificial intelligence

Gemini Prompt to Create a Content Strategy

Creating an effective content strategy requires a clear vision of your objectives, audience, and priority distribution channels. Gemini, with its analytical and synthesis capabilities, becomes a valuable ally in structuring this strategic thinking.

Gemini Prompt to Create a Knowledge Base

Creating a structured knowledge base is a major challenge for any organization wishing to centralize its knowledge. Gemini, thanks to its ability to process large volumes of information and understand relationships between concepts, is a formidable ally for this task.

Gemini Prompt to Create a Media Kit

A professional media kit is essential for any content creator, influencer, or business looking to attract partnerships and collaborations. Quickly create a compelling media kit with Gemini.

Go further

Get new prompts every week

Join our newsletter.