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, and manually add each of the five questions one by one.
- Repeat that sequence 11 more times.
- Forget to copy one of the questions on module 7 and only catch the error when a learner reports a short quiz.
Nobody hired you to be a data entry clerk. The course opens in 10 days and this is one item on a list of eight.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, 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 G so you have a clean record.
For each module name in column A of this sheet, create a new Google Form titled "Quiz: [module name]", add the questions from columns B through F as multiple-choice items using batch update, and write the form URL back to column G
What You Get
- 12 Google Forms created, each titled with its module name.
- The five questions from columns B–F added to each form as multiple-choice items.
- The form URL written to column G in the corresponding row.
- Any row where column A is blank is skipped automatically.
What If the Data Is Not Quite Ready
Some modules have fewer than five questions — the remaining columns are blank
Not every module has a full five-question set. Blank cells in the question columns shouldn't create empty form items.
For each module name in column A, create a Google Form titled "Quiz: [module name]" and add only the non-blank questions from columns B through F as multiple-choice items, then write the form URL to column G
I need some questions to be short-answer instead of multiple choice
The spreadsheet has a "type" column at column G indicating whether each question is multiple-choice or short-answer.
For each module name in column A, create a Google Form titled "Quiz: [module name]", add the questions from columns B through F using the question type from column G for each, and write the resulting form URL to column H
I need to write form IDs back separately from the URLs for future batch updates
Column G should get the URL, column H should get the form ID for later reference.
For each module name in column A, create a Google Form titled "Quiz: [module name]", 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 forms, set each one accepting responses, and log everything in one pass
The forms need to be published and open to respondents immediately, not left in draft.
For each module name in column A, create a Google Form titled "Quiz: [module name]", add questions from columns B through F as multiple-choice items, set the form to published and accepting responses, write the form URL to column G and the form ID to column H
Creation, publishing, and logging happen in one instruction — no follow-up step needed.
Try It
Get the 7-day free trial of SheetXAI and open your module question bank sheet, then ask it to generate all your Google Forms and write the URLs back to the sheet in one prompt. For related tasks, see publish draft forms in bulk or the Google Forms overview.