---
title: "Create and run polls in Google Slides using Google Forms and Google Sheets"
author: "Martin Hawksey"
date: 2022-06-07T11:15:53+00:00
modified: 2022-06-07T11:18:52+00:00
canonical_url: https://pulse.appsscript.info/p/2022/06/create-and-run-polls-in-google-slides-using-google-forms-google-sheets/
markdown_url: https://pulse.appsscript.info/p/2022/06/create-and-run-polls-in-google-slides-using-google-forms-google-sheets.md
categories:
  - "Beginner"
  - "Forms"
  - "Sheets"
  - "Slides"
  - "Snippet"
  - "Solutions"
tags:
  - "100marks-in"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2022/06/forms-slides-poll.png
description: "I thought this was a nice little Apps Script snippet from Prateek Sharma which hooks into a .onFormSubmit() trigger to update all charts embedded from Google Sheets in a Google Slides presentation. Prateek provides detailed steps including the code for setting this up. Unfortunately, a limitation of Google Slides is once you go into 'slideshow' mode all charts become static images so you need to jump back to the editor view to show real-time results. "
---

# Create and run polls in Google Slides using Google Forms and Google Sheets

![Create and run polls in Google Slides using Google Forms and Google Sheets](https://pulse.appsscript.info/files/2022/06/forms-slides-poll.png)

> Image credit: Prateek Sharma
> I wanted to give a presentation to a group of people. In order to make the presentation more engaging & eliminate silences during the slideshow, I thought of conducting polls in between. … Since I am giving presentation using Google tools, I thought let’s try it out with Google Apps Script.

I thought this was a nice little Apps Script snippet from Prateek Sharma which hooks into a `.onFormSubmit()` trigger to update all charts embedded from Google Sheets in a Google Slides presentation. Prateek provides detailed steps including the code for setting this up. Unfortunately, a limitation of Google Slides is once you go into ‘slideshow’ mode all charts become static images so you need to jump back to the editor view to show real-time results.

Source: [Create and Run Polls in Google Slides using Google Forms & Google Sheets**](https://100marks-in.medium.com/create-and-run-polls-in-google-slides-using-google-forms-google-sheets-google-apps-script-efa77d6d44ac)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/06/create-and-run-polls-in-google-slides-using-google-forms-google-sheets/](https://pulse.appsscript.info/p/2022/06/create-and-run-polls-in-google-slides-using-google-forms-google-sheets/)*