Tag: scripts

script to Forms

Import AI generated questions to Google Forms

Dale

As someone who frequently conducts surveys to gather insights and feedback from teachers, I found myself facing the tedious task of manually entering survey questions into Google Forms. I knew there had to be a more efficient way, so I turned to ChatGPT for help.

If you give it some parameters, ChatGPT is good at generating survey questions. I decided to see if I could take it one step further and train it to generate questions in a defined format. Once I got ChatGPT to give me the format I wanted, I asked it to name this the “Baslery” format so I could use it for future question generation.

"Baslery" format
“Baslery” format

To use this format in your own ChatGPT account, I have shared my chat so you can continue the conversation and generate your own questions that are pre-formatted for the next step.

With my question format in place, I worked on a script that imports survey questions from a Google Doc into Google Forms.

Script imports questions from Google Docs into Google Forms

The script takes advantage of my pre-formatted questions that I pasted into Google Docs and parses the data so it can be imported into Google Forms.

To use the script, follow these steps:

  1. Use this template to get your own copy of the Google Doc.
  2. Add your own questions to the doc (use my format)
  3. Click the Extensions -> App Scripts menu item.
  4. Click the Run button.
  5. Follow the steps to authorize the app starting with selecting your account.

After the script is run, you can find a link to the new Google Form in the Execution log or just go to Recent in Google Drive.

There are a couple of caveats when using this script:

  1. The script only works for multiple choice questions.
  2. Double-check your questions before running the script to make sure each one is formatted correctly.
  3. Watch out for True/False questions. ChatGPT likes to forget to list “true” and “false” as options.

Happy surveying!

    Cells to Slides

    Script copies data from Sheets to titles in Slides

    Dale

    A few times each year, I need a Google Slides presentation where every student in a class has their name set as the title of each slide. This is usually done so we can share the presentation with the class, and each student can contribute to their respective slide.

    I always have the list of student names in Google Sheets, so why not automate the slide creation!

    After an exchange with ChatGPT, I settled on the following script to get the job done:

    To use the script, follow these steps:

    1. Use this template to get your own copy of the spreadsheet.
    2. Change the data in column A to your own or use the example class list.
      (Note: A1 is the header. It will not be copied to a slide.)
    3. Click the Extensions -> App Scripts menu item.
    4. Click the Run button.
    5. Follow the steps to authorize the app starting with selecting your account.
    • Click “Review permissions” button.
    • Choose an account.
    • Click the “Advanced” link.
    • Click “Go to CellsToSlides (unsafe)” link.
    • Click the “Allow” button.

    After I made this script, I had an exciting realization! It became clear to me that its potential goes far beyond just class lists. This script can be utilized for ANY type of presentation!