Tag Archives: Google Slides

Creating files from templates now easier in Google Drive

Since 2015, we’ve been making it easier to focus on your content—not your formatting—with templates in Google Docs, Sheets, Slides, and Forms. We’ve introduced templates for invoices, pitch decks, and cases studies, as well as templates designed by experts and developed specifically for your organization.

Today, we’re making it easier for users to create files from templates by granting access to templates directly from Drive. Instead of navigating to the Docs, Sheets, Slides, or Forms home pages, you can simply go to Drive > New > Google Docs/Sheets/Slides/Forms > From a template. From there, you’ll be directed to the applicable template gallery, where you can select the template of your choice.


For more details on templates, visit the Help Center.

Launch Details
Release track:
Launching to Rapid release, with Scheduled release coming in three weeks

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Create a file from a template


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Legacy versions of Google Drive, Docs, Sheets, and Slides mobile apps shutting down on April 3, 2017

On April 3, 2017, we will shut down older versions of the following Android and iOS applications: 

  • Google Drive for Android (prior to version 2.4.311)
  • Google Docs for Android (prior to version 1.6.292)
  • Google Sheets for Android (prior to version 1.6.292)
  • Google Slides for Android (prior to version 1.6.292)


  • Google Drive for iOS (prior to version 4.16)
  • Google Docs for iOS (prior to version 1.2016.12204)
  • Google Sheets for iOS (prior to version 1.2016.12208)
  • Google Slides for iOS (prior to version 1.2016.12203)

This month, users of these legacy versions will begin seeing the below prompts to upgrade. Please note that after March 1, some users with very old versions will be forced to upgrade when they receive the prompt.


If you are using any of these unsupported versions, we encourage you to download and install the latest version of that mobile application. Note that corresponding web and desktop applications will not be affected by this change. On most devices, you can find an app’s version type in its settings menu.


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Page setup and ODF and EPUB support in the Google Docs, Sheets, and Slides Android apps

New versions of the Docs, Sheets, and Slides apps for Android are now available on Google Play, including the following new features to help you get more done on the move:

Page setup in Google Docs and image support improvements in Sheets
You can now change the orientation, paper size, and page color Docs on Android. In Sheets, you can use the IMAGE function to view images inside of cells.





EPUB and ODF support on Android
Docs now supports exporting your files in the EPUB (.epub) and OpenDocument Text (.odt) file formats. Additionally, you can now import OpenDocument Text (.odt) files from the Android app. Similarly, you will now be able to import and export OpenDocument Spreadsheets (.ods) in Sheets and OpenDocument Presentations (.odp) in Slides.

Please note: these features are only available when the device is online. When the device is offline, an error dialog will show saying "Data connection needed to open this file type".


Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1-3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI


More Information
Help Center: Page setup
How to use Google Slides
How to use Google Docs
How to use Google Sheets


Formatting text with the Google Slides API

Originally posted on G Suite Developers blog

Posted by Wesley Chun (@wescpy), Developer Advocate, G Suite

It's common knowledge that presentations utilize a set of images to impart ideas to the audience. As a result, one of the best practices for creating great slide decks is to minimize the overall amount of text. It means that if you do have text in a presentation, the (few) words you use must have higher impact and be visually appealing. This is even more true when the slides are generated by a software application, say using the Google Slides API, rather than being crafted by hand.

The G Suite team recently launched the first Slides API, opening up a whole new category of applications. Since then, we've published several videos to help you realize some of those possibilities, showing you how to replace text and images in slides as well as how to generate slides from spreadsheet data. To round out this trifecta of key API use cases, we're adding text formatting to the conversation.

Developers manipulate text in Google Slides by sending API requests. Similar to the Google Sheets API, these requests come in the form of JSON payloads sent to the API's batchUpdate() method. Here's the JavaScript for inserting text in some shape (shapeID) on a slide:

{
"insertText": {
"objectId": shapeID,
"text": "Hello World!\n"
}

In the video, developers learn that writing text, such as the request above, is less complex than reading or formatting because both the latter require developers to know how text on a slide is structured. Notice for writing that just the copy, and optionally an index, are all that's required. (That index defaults to zero if not provided.)

Assuming "Hello World!" has been successfully inserted in a shape on a slide, a request to bold just the "Hello" looks like this:

{
"updateTextStyle": {
"objectId": shapeID,
"style": {
"bold": true
},
"textRange": {
"type": "FIXED_RANGE",
"startIndex": 0,
"endIndex": 5
},
"fields": "bold"
}
If you've got at least one request, like the ones above, in an array named requests, you'd ask the API to execute them with just one call to the API, which in Python looks like this (assuming SLIDES is your service endpoint and the slide deck ID is deckID):
SLIDES.presentations().batchUpdate(presentationId=deckID,
body=requests).execute()

To better understand text structure & styling in Google Slides, check out the text concepts guidein the documentation. For a detailed look at the complete code sample featured in the DevByte, check out the deep dive post. To see more samples for common API operations, take a look at this page. We hope the videos and all these developer resources help you create that next great app that automates producing highly impactful presentations for your users!

Formatting text with the Google Slides API

Posted by Wesley Chun (@wescpy), Developer Advocate, G Suite

It's common knowledge that presentations utilize a set of images to impart ideas to the audience. As a result, one of the best practices for creating great slide decks is to minimize the overall amount of text. It means that if you do have text in a presentation, the (few) words you use must have higher impact and be visually appealing. This is even more true when the slides are generated by a software application, say using the Google Slides API, rather than being crafted by hand.

The G Suite team recently launched the first Slides API, opening up a whole new category of applications. Since then, we've published several videos to help you realize some of those possibilities, showing you how to replace text and images in slides as well as how to generate slides from spreadsheet data. To round out this trifecta of key API use cases, we're adding text formatting to the conversation.

Developers manipulate text in Google Slides by sending API requests. Similar to the Google Sheets API, these requests come in the form of JSON payloads sent to the API's batchUpdate() method. Here's the JavaScript for inserting text in some shape (shapeID) on a slide:

{
"insertText": {
"objectId": shapeID,
"text": "Hello World!\n"
}

In the video, developers learn that writing text, such as the request above, is less complex than reading or formatting because both the latter require developers to know how text on a slide is structured. Notice for writing that just the copy, and optionally an index, are all that's required. (That index defaults to zero if not provided.)

Assuming "Hello World!" has been successfully inserted in a shape on a slide, a request to bold just the "Hello" looks like this:

{
"updateTextStyle": {
"objectId": shapeID,
"style": {
"bold": true
},
"textRange": {
"type": "FIXED_RANGE",
"startIndex": 0,
"endIndex": 5
},
"fields": "bold"
}
If you've got at least one request, like the ones above, in an array named requests, you'd ask the API to execute them with just one call to the API, which in Python looks like this (assuming SLIDES is your service endpoint and the slide deck ID is deckID):
SLIDES.presentations().batchUpdate(presentationId=deckID,
body=requests).execute()

To better understand text structure & styling in Google Slides, check out the text concepts guidein the documentation. For a detailed look at the complete code sample featured in the DevByte, check out the deep dive post. To see more samples for common API operations, take a look at this page. We hope the videos and all these developer resources help you create that next great app that automates producing highly impactful presentations for your users!

Generating slides from spreadsheet data

Posted by Wesley Chun (@wescpy), Developer Advocate, G Suite

The G Suite team recently launched the very first Google Slides API, opening up a whole new set of possibilities, including leveraging data already sitting in a spreadsheet or database, and programmatically generating slide decks or slide content based on that data. Why is this a big deal? One of the key advantages of slide decks is that they can take database or spreadsheet data and make it more presentable for human consumption. This is useful when the need arises to communicate the information reflected by that data to management or potential customers.

Walking developers through a short application demonstrating both the Sheets and Slides APIs to make this happen is the topic of today's DevByte video. The sample app starts by reading all the necessary data from the spreadsheet using the Sheets API. The Slides API takes over from there, creating new slides for the data, then populating those slides with the Sheets data.

Developers interact with Slides by sending API requests. Similar to the Google Sheets API, these requests come in the form of JSON payloads. You create an array like in the JavaScript pseudocode below featuring requests to create a cell table on a slide and import a chart from a Sheet:


var requests = [
   {"createTable": {
       "elementProperties":
           {"pageObjectId": slideID},
       "rows": 8,
       "columns": 4
   }},
   {"createSheetsChart": {
       "spreadsheetId": sheetID,
       "chartId": chartID,
       "linkingMode": "LINKED",
       "elementProperties": {
           "pageObjectId": slideID,
           "size": {
               "height": { ... },
               "width": { ... }
           },
           "transform": { ... }
       }
   }}
];
If you've got at least one request, say in a variable named requests (as above), including the Sheet's sheetID and chartID plus the presentation page's slideID. You'd then pass it to the API with just one call to the presentations().batchUpdate() command, which in Python looks like the below if SLIDES is your API service endpoint:
SLIDES.presentations().batchUpdate(presentationId=slideID,
       body=requests).execute()

Creating tables is fairly straightforward. Creating charts has some magical features, one of those being the linkingMode. A value of "LINKED" means that if the Sheet data changes (altering the chart in the Sheet), the same chart in a slide presentation can be refreshed to match the latest image, either by the API or in the Slides user interface! You can also request a plain old static image that doesn't change with the data by selecting a value of "NOT_LINKED_IMAGE" for linkingMode. More on this can be found in the documentationon creating charts, and check out the video where you'll see both those API requests in action.

For a detailed look at the complete code sample featured in the video, check out the deep dive post. We look forward to seeing the interesting integrations you build with the power of both APIs!

Trash view and more in the Google Docs, Sheets, and Slides mobile apps

Check out the following new features in the latest versions of the Google Docs, Sheets, and Slides mobile apps:

  • Trash view in the Docs, Sheets, and Slides iOS apps - You can now view and restore previously deleted files in the Docs, Sheets, and Slides iOS apps. Just select “Trash” from the menu on the left side of the screen.
  • GIF insertion in the Docs Android app - Using the Google Keyboard in the Docs Android app, you can now search for and insert GIFs into documents.


Download the latest versions of the Docs, Sheets, and Slides mobile apps from the Google Play Store and the App Store today.

Launch Details
Release track: 
Launching to both Rapid release and Scheduled release

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Delete a document, spreadsheet, or presentation


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Export presentations in OpenDocument Presentation (ODP) format from Google Slides

Being able to save Google Slides in the OpenDocument Presentation (.odp) file format has been a popular request from the open-source community and organizations that use open-source office suites, such as LibreOffice and OpenOffice. Starting today, you can download your Google Slides presentations in the ODP file format.

From a Google Slides presentation, click File > Download as > ODP Document (.odp) to download your presentation as an ODP file. The file will be saved to your default download folder.

With this update, you can now import and export all three major OpenDocument file formats: .odt files for documents, .ods for spreadsheets, and .odp for presentations.



Please note that some formatting (e.g. tables and complex shapes) may be lost during file conversion.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Rollout pace:
Full rollout (1–3 days for feature visibility)

Editions:
Available to all G Suite editions

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Save time with new custom templates in Docs, Sheets, Slides and Forms

We recently launched new tools in G Suite like Explore, Action items, and other features to help your teams save time and focus on what’s important: creating impactful work, quicker. We know time spent re-creating files in the workplace takes away from the time your team can spend collaborating and achieving results.

That’s why, today, we’re introducing custom templates in G Suite for the Docs, Sheets, Slides, and Forms files your teams use the most.

Simply submit files to shared template galleries in the Docs, Sheets, Slides, and Forms home screens for your co-workers to adapt and use as needed. With these customizable templates, your teams can focus less on formatting and more on driving impact and sharing success.


Note that if you disabled template submissions to the old Google Drive templates gallery in the Admin console, users in your organization will not be able to see and use the new galleries when they launch. You can enable the new galleries for your users in the Admin console (Apps > G Suite > Drive and Docs > Templates). You can also configure the categories available for your organization’s templates from that same section in the Admin console.


In addition, G Suite for Business and Education customers can require templates be approved before they appear in the galleries, or prevent end users from submitting new templates altogether. These features are not enabled by default, so you’ll need to update your settings if you want to moderate or restrict template submissions to the galleries.


The old templates gallery will be shut down in early 2017, giving you and your users time to transition to the new galleries. We’ll let you know the exact date with a message in the old gallery, but it will not take place before February 1st, 2017.

An important note regarding this rollout: 
To give you a chance to update your settings and curate your organization’s template galleries, we’re rolling out these features (both in the Admin console and in the home screens) to all admins, regardless of their release track, starting today. We’ll launch to end users on the Rapid release track today as well, with the rollout to end users on the Scheduled release track starting on December 7th. 

Launch Details
Release track:
  • G Suite administrators
    • Launching to both Rapid and Scheduled release
  • G Suite end users
    • Launching to Rapid release, with Scheduled release coming on December 7th

Editions:

  • Template galleries
    • Available to all G Suite editions
  • Moderation and restriction capabilities
    • Available to G Suite for Business and Education customers only

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Admin action suggested/FYI

More Information
Help Center: Enable templates for Docs, Sheets, Slides, and Forms
Help Center: Create a file from a template


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Notifications and more in the Google Docs, Sheets, and Slides apps for Android

Check out the following new features in the latest versions of the Google Docs, Sheets, and Slides Android apps:

  • Notifications in Docs, Sheets, and Slides - Users who currently see notifications in their Google Drive Android app (for instance, when someone mentions them in a comment or shares a document with them) will now see notifications in their Docs, Sheets, and Slides Android apps as well. These notifications are specific to the app they’re working in and only appear if the user has an updated version of Google Drive installed on their mobile device.
  • Resize rows and columns in Sheets - Users will find it easier to resize rows and columns in the Sheets Android app, which now features options to specify the pixel sizes of rows and columns and to fit columns to their data exactly.
  • Create and edit data validation in Sheets - Just like they can on the web, users can now create and edit data validation criteria in the Sheets Android app.
  • Change the color of sheet tabs in Sheets - Users can now differentiate between sheets in a spreadsheet by changing the color of their tabs in the Sheets Android app.

Visit the Google Play Store to download the latest versions of the Google Docs, Sheets, and Slides apps for Android.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (potentially longer than 3 days for feature visibility)

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Edit rows and columns in a spreadsheet
Help Center: Create an in-cell dropdown list
Help Center: Copy, re-order, and delete sheets


Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates