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!