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

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.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.