FormQuick — Build a Google Form from a Sheet!

Who this is for

Anyone who has a list of questions in Google Sheets and wants a Google Form generated from it.

What is Google Forms?

What is Google Sheets?

What is FormQuick

• FormQuick is a Google Sheets add-on that turns a structured sheet (using our simple template) into a Google Form—fast and repeatable.

• Use case it solves: Build surveys, checklists, and intake forms directly from your spreadsheet—no manual retyping.

• Permissions: On first use, Google will show a standard OAuth prompt to approve access per policy. 

🚀TL;DR (90-second quick start)

1. Install the FormQuick add-on - FormQuick - Google Marketplace 

2. Open a Sheet → show the side panel (bottom-right) → click the FormQuick icon.

3. Click Get template and make a copy (first-time only).

4. Replace the sample rows with your questions (keep the header and columns).

5. Back in your Sheet, set Form name (optional) → Create Form.

Tip: After the first run, you can reuse your template—open it, edit, and click Create Form again.

How to use the template

You can use any of your Sheet to create the Form - just keep the template layout, including row headers, structure, and format for question types. 

Header row (must stay exactly as provided in the template):

• A — Question: The question text.

• B — Type: One of:
  Short answer, Paragraph, Multiple choice, Checkboxes, Dropdown, Section, Multiple choice grid, Checkbox grid, Linear scale, Rating, Date, Time

• C — Required: TRUE/YES (case-insensitive) or leave blank for optional.

• D+ — Options / Settings (varies by type):
  
  

Type-by-type rules (quick guide)

• Short answer / Paragraph / Date / Time
  Leave all option cells blank (columns D onward).
  
  

• Section
  Optional section description in D; E+ must be blank.
  
  

• Multiple choice / Checkboxes / Dropdown
  Provide ≥ 2 options. You can:
  • Put a comma-separated list in D (e.g., Red, Green, Blue), or
  • Put one option per cell across D, E, F, … (both work).
  
  

• Multiple choice grid / Checkbox grid
  D = Row labels, E = Column labels (each can be comma-separated lists).
  Both D and E must be present.
  
  

• Linear scale
  D = Min (1–10), E = Max (1–10, > Min), F = Min label (optional), G = Max label (optional).
  
  

• Rating
  E = Max stars (3–10). (If blank, defaults to 5.)
  
  

Examples (you can mirror these in your help screenshots):
• Multiple choice: A: “Favorite color?”, B: “Multiple choice”, C: “YES”, D: “Red, Green, Blue”
• Grid: A: “Rate features”, B: “Multiple choice grid”, D: “Speed, UI, Support”, E: “Poor, OK, Great”
• Linear scale: A: “Satisfaction”, B: “Linear scale”, D: “1”, E: “7”, F: “Low”, G: “High”

• Screenshot C: Template header row annotated (A–G) with short hints.
  Alt: “Template columns A–G labeled with what to put in each.”
  
  

• Screenshot D: One valid example row for each major type (MCQ, Grid, Scale).
  Alt: “Sample rows showing correct data for Multiple choice, Grid, and Linear scale.”
  
  

First-time vs. every-time

• First-time only: Install, the initial template copy, and the per-file authorization prompt.

• Every time: Show side panel, click the FormQuick icon, update questions, and Create Form.

Troubleshooting (common messages & fixes)

• “Row N: unknown question type” → Use one of the supported types exactly as shown in the template (no extra spaces).

• “Row N: options should be blank” → You added options to a type that doesn’t use them (Short answer, Paragraph, Date, Time). Clear columns D+.

• “Row N: needs ≥ 2 answer options” → For Multiple choice / Checkboxes / Dropdown, provide at least two options (D/E/… or comma-separated).

• “Row N: row labels missing (col D)” / “column labels missing (col E)” → For grid types, put row labels in D and column labels in E.

• “Row N: only the first option cell (col D) may hold the section description” → For Section, keep any text in D only; clear E+.
  
  

• Linear scale errors
  • “min/max must be numbers” → Put numbers in D and E.
  • “min must be < max” → Make sure D < E.
  • “bounds must be 1–10” → Keep values within 1–10.
  
  

• “Row N: rating max must be 3–10” → Put a number 3–10 in E for Rating.
  
  

Speed tips

• Duplicate your last good template and tweak questions—fastest path to a new form.

• Use comma-separated lists in a single cell for long option sets.

• Keep “Form name” empty to default to “{Sheet name} – Form” (you can rename in Forms later).
  
  

Where to find FormQuick

In Google Sheets → bottom right “Show side panel” → click the FormQuick icon.

Permissions & privacy (what you’ll be asked to allow)

FormQuick runs as a Google Workspace Add-on (Apps Script) inside your account. The first time you use certain features, Google shows an OAuth prompt so you can approve access. These permissions are defined and displayed by Google, not by us.

What we ask for — and why

• Drive file access
  Scope: https://www.googleapis.com/auth/drive.file
  Google’s description: “See, edit, create, and delete only the specific Google Drive files you use with this app.”
  Why FormQuick needs it: to save the new Google Form to your Drive (and only the files you create with FormQuick or explicitly choose).
  
  

• Forms access
  Scope: https://www.googleapis.com/auth/forms (full Forms access within Apps Script)
  What this enables: creating and editing Forms. On Google’s scope list, this aligns with the Forms “body” permission (“See, edit, create, and delete all your Google Forms forms”). FormQuick uses it only to create the form you ask for.
  
  

• This spreadsheet only
  Scope: https://www.googleapis.com/auth/spreadsheets.currentonly
  What this means: access is limited to the spreadsheet where you run the add-on, not all of your Sheets. This is Google’s “Only current document” model for add-ons. FormQuick reads your active sheet to build questions.
  
  

When you’ll see prompts

• You’ll see the consent screen the first time you run the add-on (or after permissions change).

• The file-specific prompt appears the first time you click Create Form in a given spreadsheet; once approved, you won’t be asked again for that sheet. (This is standard Apps Script behavior for add-ons managing scopes.)
  
  

Your data stays in your Google account

• FormQuick reads your sheet and writes a Form into your Drive.

• We don’t send your sheet or form contents to any external (non-Google) servers.

• Permissions are enforced by Google; you can review or revoke them at any time in your Google Account settings or (for organizations) your Admin can control which apps may access Workspace data.

Additional info

• Privacy  policy

• Impressum

Need help?

• Email to support@formquick.dev - happy to hear from you :)