Easily Integrate Google Sheets/Forms Information into Docs and Slides

Post in Teq News by MatthewThaxter on 13th September 2017

Today, we’re going to show you a time-saving technique that’s perfect for quickly embedding data and creating reports in Google Docs/Slides. This is the perfect solution for anyone interested in having a running report of student grades or progress/summary and adding it to a document or presentation. In a few simple steps, you’ll be able to utilize raw dynamic data within your presentations without having to constantly replace your charts! 

To do this, all you need is Google Sheets/Forms and the basic functions of Google Docs/Slides.

Getting Started

For today’s example, we’ve modeled how to accomplish this in Google Docs, however, the steps are the same for Google Slides.

Please note: If you only need to run graphical data, you only need to send the Google Doc. The receiver would only need to have the Doc, and it will automatically update.

Step 1

Go to Google Forms and select “Start a new form.” This will be where you collect your data.

Step 2

Once you have collected the results, in Google Forms click into the Responses tab. Then select the green box in the upper right side, and select “Create a new spreadsheet.”

Step 3

From the Sheet, organize your data within the Sheets application.

Step 4

To create the chart(s) from the data collected, go to “Insert” (top left), and select “Chart.” Here, you can select what chart type you would like to use, the data range, and other ways to customize your chart.

Here is the view of the “old chart editor,” (above) which is still an available option on Google Sheets.
This is the view of the new chart editor (above). Its simple design is still user-friendly and intuitive to use.

Step 5:

Open Google Docs and draft the layout of your document.

Step 6:

When you reach the point in your Document where you would like to insert the information from Google Sheets,

  • Click Insert
  • Click Chart > From Sheets…
  • Navigate to the desired Chart and select Import (bottom right).

In order to have the chart (which is now inserted into Google Docs) automatically update as more data is collected within your Google Form and then Sheet, select Link to Spreadsheet. 

Again, this will allow any new data collected through Google Forms to be sent to Google Sheets, and ultimately, reflect on the Chart (which will be in your Google Doc or Google Slide, depending on where you inserted the chart).

Step 7

When you want to update the chart/data which is located in the Google Doc or Slide, click on the chart, and then click Update (top right of chart).

Now you have the ability to utilize raw, dynamic data in your presentations without having to constantly replace your charts!

For More

For more great Google Tips like this, visit our Teq Tip page. Here, you will find quick and easy videos that teach you how to make the most of Google Apps For Education, Gmail, and more!

Leave a Reply