Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Forms Column to Google Slides

Column to Slides Add on

Google Forms Column to Google Slides

Send a Column of Responses from Google Forms to Google Slides

Google Forms is awesome but can be tricky to go over responses with the class. I coded an Add-on for Google Sheets that will allow you to select a column of responses from a Google Form and send those responses to Google Slides.

Join alicekeeler.com/betatester

To install the Add-on you need to request to join my beta tester group. This gives you the ability to install many of my Add-ons from the Chrome webstore, including Column to Slides.

Install Add-on

After you are approved to the beta tester group, you will be able to install Column to Slides from the Chrome Webstore.

Click here to install Column to Slides

YouTube video

Authorize the Add-on

Google has not reviewed my code. I do not have any plans soon to go through the process of getting my code authorized so all my Add-on templates will give you a warning that Google has not reviewed the code. You will need to click on ADVANCED and UNSAFE (it is safe, I personally coded it) to authorize the Add-on. You will be authorizing YOURSELF to access your Google Apps.
Click on advanced and unsafe

Open Any Google Form

You will want to open the spreadsheet from the Google Form. Click on the Responses tab and click on the spreadsheet icon.
Click on responses and spreadsheet

Click on Any Cell

Click on any cell in the column of responses you want to send to Google Slides. ALL of the responses in that column will be sent to Google Slides, not just the selected cell.

Note, you can NOT select the entire column. My code is looking for the cell you have clicked on and it identifies the column. 

Add-on Menu

From the spreadsheet, use the Add-on menu and choose “Column to Slides” and select “Send to Slides.”
Send to Slides from the add on menu

Your slides have been created

Slides Tab

Automatically a tab called “Slides” will be added to your spreadsheet. This will keep a list of all of the Google Slides presentations you make from that spreadsheet using my Add-on. A live hyperlink to the Slides allows you easy access to the presentations.
Slides Tab

Edit the Layout

The font may be too large for the responses. Use the View menu and choose “Master.” Edit the font size (and any other formatting changes you may want to make) on the layout. The changes will be universal to all of the slides.
View Master

Changing the layout

Share with Edit Access

You may want to share the slides with the students with edit access to allow for peer feedback. Students can click on a slide, put their name in the placeholder text on the left and their comment on the right.
allow for peer review

A Complete Video Guide to Google Forms

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

2 thoughts on “Google Forms Column to Google Slides

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.