📘 SheetFormR Help & User Guide

💳 Subscription Info

SheetFormR offers a 3-day free trial with full access to all features — unlimited builds, AI tools, Classroom integration, Math Mode, everything.

After your trial, continue with a Pro subscription ($7/month) to keep creating forms. No feature restrictions during or after trial — you always get the complete SheetFormR experience.

🖥️ Wide View vs Compact View

SheetFormR offers two interface modes:

• Wide View — Opens as a large modal window. Best for detailed work and seeing more options at once.
• Compact View — Opens in the sidebar. Best for quick edits while viewing your spreadsheet.

Click the Switch to Compact or Switch to Wide button in the top-right to toggle between modes.

You can also choose your preferred view from the homecard when you first open SheetFormR.

📊 How to Structure Your Spreadsheet

SheetFormR expects your data organized like this:

📋 Source Sheet Dropdown

Select which sheet (tab) in your spreadsheet contains your quiz questions. SheetFormR reads data from this sheet when building your form.

Auto-map on Sheet Change

When enabled, SheetFormR automatically detects and maps your columns every time you switch to a different sheet. This saves you from manually mapping columns each time.

Remember Build Tab Choices

Saves your preferences (Auto-Map setting, Build Options, Open Form in New Tab) on this computer. Your settings will persist even after closing and reopening SheetFormR.

Enable Quiz Mode ✓

Creates a graded quiz instead of a regular form. This enables:

• Answer keys (correct answers)
• Point values per question
• Automatic grading when respondents submit

When enabled, a green QUIZ badge appears next to the option.

See also: Quiz Mode Default Settings for the automatic settings applied to quizzes.

Create and Link New Response Sheet ✓

Automatically creates a linked Google Sheets™ response sheet for your form. Responses will be collected in a new tab in your current spreadsheet.

This is required if you want to use the Track Submissions feature later.

Apply Title/Description ✓

Uses Row 2 of your mapped Title and Description columns as the form’s title and description.

Create as Classroom Assignment

Creates a Google Classroom™ assignment along with your form. When enabled:

1. Click Load Courses to see your classes
2. Select which course to create the assignment in
3. After the form is created, the assignment is automatically published to your Classroom course

Append Date/Time To Name

Adds the current date and time to the end of your form title. Useful for creating multiple versions of the same quiz.

Example: “Chapter 5 Quiz” becomes “Chapter 5 Quiz 2026-02-20 10:30”

Include Question Numbers ✓

Prepends the question number (from your Question # column) to each question title.

Example: “What is 2+2?” becomes “1. What is 2+2?”

Shuffle Answer Choices

Enables Google Forms™’ native answer shuffling on each Multiple Choice and Checkbox question. Each respondent sees answer choices in a different random order, helping prevent copying.

Note: Dropdown questions do not support answer shuffling — this is a Google Forms™ limitation. The preview always shows your original spreadsheet order; shuffling happens when students open the form.

Shuffle Question Order

Enables Google Forms™’ native “Shuffle question order” setting. Each respondent sees questions in a different random order.

The preview always shows your original spreadsheet order; shuffling happens when students open the form.

Sort by Question Number

Sorts questions based on the values in your Question # column before building. Useful if your questions are out of order in the spreadsheet.

Include Images

Attaches images to questions using URLs from your Image URL column. Supports:

• Direct image links (JPG, PNG, GIF)
• Google Drive™ images (must be shared as “Anyone with the link”)

Render Math Equations

Renders mathematical equations as formatted images embedded directly in your Google Form™. When enabled, SheetFormR converts equations from your Equation column or from $...$ notation in question text into high-resolution images.

Supports fractions, exponents, square roots, Greek letters, integrals, and more. See Math Mode for full details and examples.

📝 Row Selection

Build only specific rows instead of the entire sheet. Leave blank to build all rows.

Formats accepted:

• 3-10 — rows 3 through 10
• 3,5,7 — only rows 3, 5, and 7
• 3-10,15,20-25 — combine ranges and individual rows

🔒 Automatic Quiz Settings

Need different settings? After creating your form, open it in Google Forms™ and change these settings manually in the ⚙️ Settings tab.

Preflight

Scans your spreadsheet row by row and checks for common mistakes before building. Catches all issues at once so you can fix everything in one pass:

• Missing question text or empty rows
• No answer choices for multiple choice questions
• Unrecognized question types (typos like “muliple choice”)
• Correct answer doesn’t match any available choice (e.g., answer “E” but only A–D exist)
• Non-numeric points values (e.g., “five” instead of 5)
• Correct answer set but no points assigned
• Duplicate question numbers
• Duplicate questions (identical question text in different rows)
• Missing correct answer in Quiz Mode
• Section and question on the same row
• Grid questions missing rows or columns

Always run Preflight first to avoid surprises!

Preview

Shows a visual preview of your form without actually creating it. Scroll down to see how your questions will appear, including answer choices, point values, and help text.

Click any question image in the preview to see it full-size.

Create Form

Builds your Google Form™! When complete, you’ll see a success summary showing the form title, question count, quiz mode status, and build time. Click anywhere on the success message to dismiss it.

Open Form

After creating a form, click this button to open your new Google Form™ in a new browser tab. You can also copy the form URL from the success message.

Check to Open Form in New Tab

When enabled, automatically opens your newly created form in a new browser tab immediately after creation. This saves you a click if you always want to review your form right away.

Each history entry shows the form title, question count, and date created. From here you can:

• 📄 Open — Open the form in a new tab
• ✏️ Edit — Open the form editor in Google Forms™
• 📋 Copy URL — Copy the form link to your clipboard

Click Clear History to reset. History is stored on your device only — it doesn’t sync between computers.

✅ How to Format Correct Answers

The Correct Answer field accepts different formats depending on your question type:

How to Enable Math Mode

1. Go to the Build tab
2. In Build Options, check Render Math Equations
3. Add an Equation column to your spreadsheet (or use $...$ in question text)
4. Build your form — equations appear as crisp images above each question

Plain Math (Easiest)

Just type the math expression the way you’d write it on paper. SheetFormR automatically converts it to a formatted equation image:

LaTeX (Advanced)

For complex equations, use LaTeX notation wrapped in dollar signs in the Equation column:

Example question text:

Solve for x: $2x + 5 = 15$

SheetFormR extracts the equation from between the $...$ signs and renders it as an image above the question. The plain-text version of the equation remains in the question title for accessibility.

📊 Spreadsheet Setup for Math Quizzes

🔧 How It Works Behind the Scenes

SheetFormR sends equation text to CodeCogs (primary) or i.upmath.me (backup) to generate PNG images. These images are then embedded in your Google Form™ above the question text.

Privacy: Only the mathematical notation itself is sent to the rendering service — no student data, names, emails, or other spreadsheet content is transmitted.

Performance: All equations are fetched in parallel for fast builds. A 60-question math quiz typically builds in about 2 minutes.

Grades with the SBAC badge include Smarter Balanced test prep guidance, priority standard markers, and links to official SBAC practice tests at sampleitems.smarterbalanced.org and practice.smarterbalanced.org.

🎨 Theme

Choose your accent color: Blue (default), Red, Green, Yellow, or Pink.

🌙 Mode

Choose light mode, dark mode, or follow your system settings.

Compact Layout

Reduces padding and spacing for a more compact view. Only applies when using the sidebar (not the wide modal).

Tooltips on Mouse Over

Shows helpful tooltips when you hover over options. Disable if you find them distracting.

How to Use Forge AI

1. Select a sheet from the “Add Questions To” dropdown, or create a new sheet
2. Describe your quiz in the text box (up to 15,000 characters)
3. Check “Includes Math/Equations” if your topic involves math — equations will render as images
4. Click 🚀 Forge Content to Sheet

🔒 What Data Is Sent

When you use Forge AI or Polish, your prompt text and authenticated email are sent to SheetFormR’s Cloud Run™ service for license validation. Only the prompt text is forwarded to Google’s Gemini™ API. No student data, Classroom data, or spreadsheet content beyond your prompt is ever transmitted. SheetFormR does not use your data to train AI models.

☑️ Includes Math/Equations

When checked, Forge generates equations in a dedicated Equation column using LaTeX notation. Combined with Render Math Equations in Build Options, these render as formatted images in your Google Form™.

Privacy note: Only the mathematical notation is sent to equation rendering services — no student data, names, or other spreadsheet content is transmitted.

How to Use Polish AI

1. Enter row numbers to polish (e.g., 3-10 or 3,5,7). Leave blank for all rows (max 20).
2. Select improvement style(s):
   • Make clearer / less ambiguous — removes confusing wording
   • Simplify reading level — makes questions easier to understand
   • Make more rigorous — increases precision and academic rigor
3. Click ✨ Polish Questions
4. Review the preview — select which improvements to apply
5. Click Apply Selected

How to Track Submissions

1. Click Create Roster Status Sheet
2. Select your Roster Sheet — the sheet containing student names and emails
3. Select your Response Sheet — the linked response sheet from your form
4. Choose an action:
   • Create Submission Status Sheet — creates the structure only
   • Create & Sync Scores — creates structure AND imports scores

How to Import a Classroom Roster

1. Click Import Classroom Roster
2. Select one or more courses from the list
3. Choose Import Mode:
   • Combined — all students in one sheet
   • Per-class — separate sheet for each course
4. Choose Roster Import Mode:
   • Append — only adds new students (recommended)
   • Refresh — clears and rebuilds the entire roster
5. Click Import Roster

❓ Can I edit a form after creating it?

Yes! After SheetFormR creates your form, it’s a normal Google Form™. Open it in Google Forms™ to make any edits — add questions, change settings, update the theme, etc.

❓ Does SheetFormR store my data?

No. All your data stays in your Google account. SheetFormR reads from your spreadsheet and writes to Google Forms™, but we don’t store your questions, student data, or form content on our servers. Only your email is used for license verification.

When using AI features (Forge/Polish), your prompt text and email are sent to our Cloud Run service for license validation; only the prompt is forwarded to Google’s Gemini™ API — never student names, emails, or Classroom data. When using Math Mode, only the mathematical notation is sent to equation rendering services.

❓ Why do students have to sign in to my quiz?

This is intentional. When Quiz Mode is enabled, SheetFormR automatically requires Google sign-in and limits to one response per student. This ensures academic integrity and allows matching responses to your roster. If you need anonymous surveys, disable Quiz Mode before creating the form.

❓ “No sheets found” or dropdown is empty

Solution: Click Refresh to reload the sheet list. Make sure you have at least one sheet tab in your spreadsheet.

❓ Auto-Map isn’t detecting my columns

Solution: Check that your column headers are in Row 1. Auto-Map looks for headers in the first row only. Also try using standard names like “Question”, “Answer A”, etc. See Column Aliases for all recognized names.

❓ Images aren’t appearing in my form

Solutions:

• Make sure Include Images is enabled in Build Options
• Use direct image URLs (right-click → Copy image address)
• For Google Drive™ images, share as “Anyone with the link”
• Supported formats: JPG, PNG, GIF

❓ Math equations aren’t rendering in my form

Solutions:

• Make sure Render Math Equations is enabled in Build Options
• Check that your Equation column header is recognized (use “Equation”, “Math”, or “Formula”)
• For inline equations, wrap them in dollar signs: $\frac{1}{2}$
• Plain math like 3/4 or 5^2 works in the Equation column without dollar signs
• If some equations fail, SheetFormR will try a backup rendering service automatically

❓ Correct answers aren’t being graded properly

Solutions:

• Make sure Enable Quiz Mode is checked
• Ensure your Correct Answer value exactly matches one of your answer choices (including capitalization for MC questions)
• For Short Answer questions, matching is case-insensitive
• For multiple correct answers (checkbox questions), separate with commas: A, C

❓ Grid question grading isn’t working

Solutions:

• Make sure you have a Grid Answer Key column mapped with the correct format: Row=Column|Row=Column
• Row names in the answer key must exactly match your Grid Rows values
• Column names in the answer key must exactly match your Grid Columns values
• Set Grid Scoring Rule to all or partial
• SheetFormR uses the Google Forms REST API for grid scoring — if you see a warning, open the form in Google Forms™ to verify

❓ I can’t see my Classroom courses

Solution: SheetFormR can only access courses where you are a teacher. Student courses won’t appear. Also make sure the courses are active (not archived).

❓ Form was created but it’s empty

Solutions:

• Check that your Question Text column is mapped correctly
• Make sure you have data starting in Row 3 (Row 1 = headers, Row 2 = title/description)
• Run Preflight to check for issues before building

❓ SheetFormR is running slowly

Solutions:

• Large spreadsheets take longer to process — try using Row Selection to build smaller batches
• Math Mode adds build time for equation rendering (approximately 2 seconds per equation batch)
• Disable Include Images and Render Math Equations if you don’t need them
• Close other browser tabs to free up memory

❓ Session expired error

Solution: SheetFormR includes a built-in keep-alive system that keeps your session active. However, if you leave the sidebar idle for an extended period, Google Apps Script sessions may still expire. Close the SheetFormR sidebar and reopen it from the Extensions menu. Your column mappings are saved automatically if “Remember Build Tab Choices” is enabled.

❓ I need more help

Contact us at sheetformr@gmail.com — we’re happy to help!