The Scenario
It's the third week of April and you're the training coordinator for a 60-person organization. The learning management team just handed you a spreadsheet: 12 module names in column A, and five quiz questions per module spread across columns B through F. Each module needs its own Google Form before the course opens May 1st. Nobody mentioned this until today.
The bad version:
- Open Google Forms, create a new blank form, type the module name as the title, manually add each of the five questions one by one.
- Repeat that sequence 11 more times.
- Realize on module 9 that you've been adding questions as short-answer instead of multiple-choice for the last three forms, and have to go back and fix them.
You're supposed to be coordinating the course rollout, not building forms one by one. The deadline doesn't move.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, sees your module list, and talks directly to Google Forms to create all 12 forms in one operation — then writes the resulting URLs back to column C so you have a clean record.
Read the 5 form titles in column A and their corresponding question lists in column B of this Excel sheet and create a separate Google Form for each, writing the resulting form links back to column C
What You Get
- 12 Google Forms created, each titled with its module name.
- Questions from the corresponding row added to each form.
- The form URL written to column C in the matching row.
- Blank rows in column A are skipped without error.
What If the Data Is Not Quite Ready
Questions are split across multiple columns, not a single column
The workbook has questions in columns B through F, not consolidated into one column.
For each module name in column A, create a Google Form titled "Quiz: [module name]", add the non-blank questions from columns B through F as multiple-choice items, and write the form URL to column G
Some questions are multiple-choice and some are short-answer
Column G has a type indicator — "MC" or "SA" — for each question row.
For each module name in column A, create a Google Form and add the questions from columns B through F using the type in column G to determine whether each is multiple-choice or short-answer, then write the form URL to column H
I need form IDs in addition to URLs for later bulk updates
For each module name in column A, create a Google Form, add questions from columns B through F as multiple-choice items, write the form URL to column G and the form ID to column H
Create, publish, and log in one pass
For each module name in column A, create a Google Form, add questions from columns B through F as multiple-choice items, set each form to published and accepting responses, write the form URL to column G and the form ID to column H
All twelve forms built, published, and documented in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your module question bank workbook, then ask it to generate all your Google Forms and write the links back to the sheet in a single prompt. For related tasks, see publish draft forms in bulk or the Google Forms overview.