Published on November 30, 2016 by Google

Spreadsheets are a great utility in the business world, a virtual swiss army knife for what they can do with data, turning it into information. While presentations aren’t able to manipulate data in the way a spreadsheet can, they do take information & make it more visually appealing & more easily understood by human beings. In this video, Google engineer Wesley Chun shows you how to import spreadsheet data into presentations by using both the Google Sheets and Slides APIs. With these APIs, you can develop powerful apps that can automate this process between both types of apps so users no longer have to do this by hand.

Links:
Google Sheets API codelab: g.co/codelabs/sheets
Explore in Docs, Sheets, and Slides release announcement (Sep 2016): goo.gl/GmDAPp
Google APIs Client Libraries: goo.gl/3vknAI
Google APIs Python client library: goo.gl/SJ3zGJ
Google Developers Console: console.developers.google.com
“Transferring data from a SQL database to a Sheet” DevByte video: goo.gl/N1RPwC
Deeper dive code review of script used in this DevByte: goo.gl/Fa34S3
Table operations in presentations: goo.gl/mD7oaN
Adding charts to presentations: goo.gl/9T3Dao
Overview of the Google Slides API: goo.gl/gIqivd
Common operations & API samples: goo.gl/JFGs3Z
Slides API reference documentation: goo.gl/8QXk7N
Slides API quickstarts in Python & other languages: goo.gl/hoRi0Q
Slides API developers launch announcement (Nov 2016): goo.gl/o6EFwk
Slides API launch announcement (Nov 2016): goo.gl/UA2pRJ
“Setting up new Google API projects” DevByte video: goo.gl/RbyTFD
“Common Python code walkthrough” DevByte video: goo.gl/KMfbeK

Watch more episodes of G Suite Dev Show: goo.gl/JpBQ40
Subscribe to the Google Developers YouTube channel: youtube.com/GoogleDevelopers

Leave a Reply

6 Comments on "Generating slides from spreadsheet data"

Notify of
avatar

Andy Hay
Guest
Andy Hay
2 days 16 hours ago

@google developers do you need to pay for G Suites to be able to program these type of things?

Dradee
Guest
Dradee
9 days 9 hours ago

5:16 – "Snatic stapshot"? 🙂

thmorriss
Guest
thmorriss
9 days 9 hours ago

presentation was smooth!

Jeff Larkin
Guest
Jeff Larkin
9 days 13 hours ago

Wait, is this seriously 100 lines of python to do what MS Office (and I'm pretty sure G-suite) does with just copy and paste? I love that I can write scripts to manipulate Google sheets and slides, but this seems like overkill for what should be a really simple thing.

Robert Ross
Guest
Robert Ross
9 days 12 hours ago

You can copy data from google sheets and paste into google slides, too.

Michael Thomas
Guest
Michael Thomas
9 days 19 hours ago

Thanks Wesley 😉

wpDiscuz