Get AI summaries of any video or article — Sign up free
Can You REALLY Trust ChatGPT to Design Survey Forms for Data Analysis? thumbnail

Can You REALLY Trust ChatGPT to Design Survey Forms for Data Analysis?

Dr Rizwana Mustafa·
5 min read

Based on Dr Rizwana Mustafa's video on YouTube. If you like this content, support the original creators by watching, liking and subscribing to their content.

TL;DR

Prompt ChatGPT with the research problem, research questions, target population details (degree level and setting), and the required question types to generate a survey instrument that matches the study.

Briefing

Designing survey instruments, collecting responses, and turning results into usable findings can consume weeks—especially when researchers aren’t steeped in survey methodology. A workflow built around two free tools—ChatGPT (referred to as “Char gbd/charb”) and Google Docs/Google Forms—aims to cut that time by generating survey questions, structuring the form for easy completion, and producing analysis-ready summaries.

The process starts by prompting ChatGPT with the research context so the questions match the study’s goals. The prompt should include the research problem and research questions, the target population (including degree level and setting such as “Lore University”), and the respondent profile (for example, undergraduate and graduate students). It also helps to specify the respondent constraints and the kinds of items needed: demographic questions, multiple-choice questions, yes/no items, and open-ended questions. ChatGPT can then draft a survey instrument that is aligned with the study and “easy to solve,” with the expectation that shorter, clearer prompts reduce participant burden and improve response quality.

Once the draft survey content is produced, the next step is transferring it into Google Docs and then into Google Forms. Google Forms is used to operationalize the questionnaire: researchers add a title, create sections, and choose question types such as short answer paragraphs, multiple choice, checkboxes, dropdowns, grid formats, and even file upload options. After the form is ready, sharing becomes the main task—sending the link through channels like WhatsApp groups, Facebook groups, or online communities. Responses then flow automatically into Google Sheets, where the data are organized into tables and visualized through charts/infographics, removing the need to manually chase participants for spreadsheets.

Evaluation comes next, again using ChatGPT. The workflow shifts from question design to analysis by copying the collected data (numbers and text) into ChatGPT along with details about the study context—such as degree level and the type of research being conducted. The prompt can request trend summaries in percentages rather than raw counts, and it can ask for interpretation tied to specific relationships (for example, the effect of one variable on another). ChatGPT can also generate a discussion narrative based on the results, including structured outputs that researchers can expand or shorten.

A concrete example in the transcript describes analyzing survey results related to a test preparation context, where a large share of students reported taking an English proficiency test (such as TOEFL or IELTS), alongside measures tied to stress and anxiety and recommendations for improvement programs. The key takeaway is not that ChatGPT replaces statistical rigor, but that it can accelerate the labor-intensive stages—drafting instruments, structuring data capture, and producing analysis-ready summaries—so researchers spend more time on interpretation and less on formatting and manual compilation.

Cornell Notes

A time-saving survey workflow pairs ChatGPT with Google Forms to design questionnaires, collect responses, and generate analysis-ready summaries. Researchers prompt ChatGPT with the research problem, research questions, target population details (degree level, setting), and the desired question types (demographics, MCQs, yes/no, open-ended items). The drafted survey is then built in Google Forms using appropriate question formats, shared via a link, and automatically stored in Google Sheets with charts and tables. For evaluation, researchers paste the collected data into ChatGPT and request percentage-based trends and a discussion tied to the study context. This reduces manual work in survey creation, data organization, and first-pass interpretation.

What information should be included in a ChatGPT prompt to generate a survey that fits a specific research study?

The prompt should include the research problem and research questions, the target audience (including degree level and setting such as a university), and the respondent profile. It should also specify what the survey must include—demographic items, multiple-choice questions, yes/no questions, and open-ended questions. The transcript emphasizes that adding details like “PhD student,” the study focus (e.g., challenges faced by non-native English speakers learning English as a foreign language), and the participant group (undergraduate and graduate students) helps ChatGPT produce a customized, usable questionnaire.

Why does the workflow stress using multiple question types (MCQ, yes/no, open-ended) instead of only open-ended questions?

Multiple question types let researchers capture both structured and qualitative data. MCQs and yes/no items support easier aggregation and percentage-based trend reporting, while open-ended questions provide richer context. The transcript also notes a practical constraint: if participants face too many or too lengthy prompts, response quality can drop, so the survey should be “easy to solve” and not require extensive writing.

How does Google Forms reduce the effort of collecting survey data?

Google Forms turns the questionnaire into a shareable link. Researchers can distribute that link through groups (e.g., WhatsApp or Facebook communities), and responses automatically populate Google Sheets. This eliminates the need to request spreadsheets back from participants and supports immediate organization into tables plus charts/infographics for quick review.

What kinds of question formats does Google Forms support in this workflow?

The transcript lists several formats researchers can choose while building the form: short answer paragraphs, multiple choice, checkboxes, dropdowns, multiple choice grids, checkbox grids, and file upload options. This flexibility helps match each survey item to the most appropriate response type.

How is ChatGPT used for analyzing survey results in the workflow?

After data collection, researchers copy the collected columns or tables and paste them into ChatGPT along with the study context (e.g., degree level and what relationships matter). Prompts can request trend summaries in percentages rather than raw counts and can ask for interpretation of how one variable affects another. ChatGPT can also draft a discussion section narrative based on the results, which researchers can then expand or edit.

What does the transcript’s example illustrate about the kind of outputs researchers can request from ChatGPT?

The example describes results where a majority of students reported taking an English proficiency test (TOEFL or IELTS), alongside measures related to stress and anxiety around test implementation and recommendations for improvement programs. The implied output style includes percentage-based findings and a discussion that ties those findings to the study’s variables and recommendations.

Review Questions

  1. When prompting ChatGPT to generate a survey, what minimum set of study details should be included to keep questions aligned with the research problem?
  2. How does the combination of Google Forms and Google Sheets change the data collection workflow compared with manually requesting spreadsheets?
  3. What prompt instructions would you give ChatGPT to produce percentage-based trends and a discussion tied to specific variables in your survey data?

Key Points

  1. 1

    Prompt ChatGPT with the research problem, research questions, target population details (degree level and setting), and the required question types to generate a survey instrument that matches the study.

  2. 2

    Design the survey to be easy to complete by mixing structured items (demographics, MCQs, yes/no) with open-ended questions rather than relying only on long responses.

  3. 3

    Transfer the ChatGPT-generated questionnaire into Google Forms, selecting appropriate input types such as short answer, multiple choice, checkboxes, dropdowns, and grid formats.

  4. 4

    Distribute the Google Forms link through relevant communities to collect responses without manually chasing participants for data files.

  5. 5

    Use Google Sheets as the automatic data repository so responses appear in tables and charts immediately for faster review and analysis.

  6. 6

    For evaluation, paste the collected data into ChatGPT and request percentage-based trends and interpretation tied to the study context, then edit the resulting discussion for academic use.

Highlights

A single prompt that includes the study’s research problem, target audience, and desired question formats can generate a customized survey draft.
Google Forms automates the hardest part of collection—responses flow directly into Google Sheets with tables and charts.
ChatGPT can be used after data collection to summarize trends in percentages and draft a discussion narrative based on the pasted results.
The workflow emphasizes reducing time spent on formatting and compilation so researchers can focus on interpretation and refinement.

Topics