ChatGPT Prompts for Google Forms (Surveys + Intake)
20 copy-paste ChatGPT prompts for Google Forms: survey design, question writing, form logic, response analysis, and the workflows that turn Forms from data collection into decisions.
Form Design
4 promptsSurvey Design from Goal
1/20Design Google Form for [survey goal]. Audience: [describe]. Output: question types (multiple choice, scale, open-ended) per goal, sequence (warm-up to important), length (5-10 min max), incentive consideration. Goal-driven design > question dump.
Designs goal-driven surveys.
Pro tip: Survey design starts with decision: what action will responses inform? If unclear, survey unnecessary. Goal-driven design = actionable data.
Question Writing
2/20Write [N] questions for [survey topic]. Per question: clear (no ambiguity), neutral (no leading), specific (one concept per question), correct type (multiple choice / scale / open-ended). Avoid double-barrels.
Writes survey questions.
Pro tip: Double-barreled questions ("Was the service fast and friendly?") = useless data. Single-concept questions = clean data. Most surveys have 30% bad questions.
Survey Length Calibration
3/20Calibrate survey length. Goal: [describe]. Output: total questions, time estimate (30 sec/question rule), what to cut if over budget, completion rate impact. Long surveys = abandoned. Short surveys = limited insight.
Calibrates survey length.
Pro tip: Surveys over 5 minutes = completion rate drops. 5-minute survey × 100 responders > 20-minute survey × 20. Length is the single biggest abandonment driver.
Open-Ended Question Strategy
4/20Decide which questions open-ended vs multiple choice. Output: criteria (open for unexpected insight, multiple choice for known options), max open-ended (3-5 typical), placement (end), analysis cost. Open-ended = harder to analyze.
Plans open-ended questions.
Pro tip: Open-ended = qualitative insight. But 50 open-ended on 200 responses = 10K free-text words. Reserve for the questions where unexpected patterns matter.
Prompts get you started. Tutorials level you up.
A growing library of 300+ hands-on AI tutorials. New tutorials added every week.
Logic + Branching
4 promptsConditional Logic Setup
5/20Set up form logic. Conditions: [describe — e.g., "if customer = yes, show customer questions"]. Output: section design, "Go to section based on answer," skip patterns, test scenarios. Conditional = relevant questions.
Sets up form logic.
Pro tip: Linear forms = irrelevant questions. Conditional forms = each respondent sees only relevant. Better completion + cleaner data. Setup once; benefits all respondents.
Multi-Step Form
6/20Multi-section form for [purpose]. Output: section breakdown (3-5 sections, 3-7 questions each), progress indicator, save-progress consideration, abandonment risk per section. Multi-step = digestible.
Builds multi-section forms.
Pro tip: Long form on one page = overwhelming. Multi-section = digestible. Progress bar = motivation. Same questions, better structure, higher completion.
Required vs Optional Calibration
7/20Calibrate which questions required vs optional. Output: required for: identification, segmentation, must-have data; optional for: nice-to-have, sensitive (income, demographics). Too many required = abandonment.
Calibrates required questions.
Pro tip: Required questions on every Q = abandonment. Required only on critical = completed. Most forms over-require. Sensitive questions optional = better data + better experience.
Form Validation Rules
8/20Set up validation rules. Use cases: email format, number ranges, regex matching, character limits. Output: per question type, validation, error message, when to validate (on submit vs live). Clean data > clean prompt.
Sets up form validation.
Pro tip: No validation = bad data. "Phone number" + free text = "I don't want to share" + "555-1212" + "+44 20 1234 5678" = unparsable. Validation = clean data.
Response Analysis
4 promptsResponse Summary
9/20[Paste Form responses summary or sheet]. Summarize: response rate, demographic mix, top patterns, key insights, surprises. Don't just describe data; tell story. Most form analysis stops at counts.
Summarizes form responses.
Pro tip: Form data without story = numbers. Form data with story = insight. "60% answered X" + "this means Y about our user base" = decision-ready.
Open-Ended Theme Analysis
10/20[Paste open-ended responses]. Theme analysis: top 5-7 themes, frequency per theme, representative quotes per theme, surprising themes, contradictions. Qualitative analysis manually = days; AI = hours.
Analyzes open-ended responses.
Pro tip: Open-ended responses sit unread = wasted insight. AI theme analysis = patterns visible quickly. Quotes lifted = use in reports + decks.
Cross-Tab Analysis
11/20[Describe responses]. Cross-tab analysis: how does Q1 answer correlate with Q2? Segments emerging? Patterns by demographic? More than just totals; drive at relationships in data.
Cross-tabs form responses.
Pro tip: Single-question stats = surface. Cross-tabs = patterns. "Customer satisfaction by segment" reveals more than "average satisfaction." The interesting insights are in cross-tabs.
NPS / Score Interpretation
12/20[NPS or rating data]. Interpret: score breakdown (promoters, passives, detractors), what shifted vs prior, drivers of detractors (open-ended), action items. NPS without interpretation = vanity metric.
Interprets NPS scores.
Pro tip: NPS score alone = noise. NPS + driver analysis (why detractors detract) = action. Most teams report score; mature teams act on drivers.
Like these prompts? There are full tutorials behind them.
Learn the workflows, not just the prompts. 300+ easy-to-follow tutorials inside AI Academy — and growing every week.
Workflows + Distribution
4 promptsForm Distribution Strategy
13/20Distribute Google Form for [audience]. Output: channels (email, social, intranet), incentive (if any), reminder strategy, response goal, deadline. Distribution = response volume.
Plans form distribution.
Pro tip: Generic distribution ("here's a form") = low response. Specific channels + reminders + deadline = high response. Most forms under-distribute then complain about response rate.
Form → Sheet → Dashboard Pipeline
14/20Build pipeline: Form → Sheet → Dashboard. Output: form data flows to Sheet (auto), Sheet feeds Dashboard (Looker Studio / Sheets chart), refresh strategy, who sees what. Form data alive in dashboard.
Builds form-to-dashboard pipelines.
Pro tip: Form data sitting in Sheet = unused. Dashboard layer = visibility. Same data, different value. Underused workflow.
Form Notifications
15/20Form response notifications. Output: who gets notified (form owner, channel), trigger (every response vs threshold), notification content, escalation rules. Most form responses notify nobody = forgotten.
Sets up form notifications.
Pro tip: Default Forms: response goes to Sheet, no notification. Add notification (email or Slack via Apps Script) = real-time response. Critical for support / intake forms.
Form Templates Library
16/20Build Form template library for [team]. Templates: customer feedback, employee survey, intake, RSVP, etc. Per template: question structure, branding, response handling. Reusable = consistent.
Builds form template library.
Pro tip: Random forms per use case = inconsistent + slow build. Templated forms = consistent quality + 5-min creation. Build once, reuse many.
Frequently Asked Questions
Prompts are the starting line. Tutorials are the finish.
A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.
7-day free trial. Cancel anytime.