Google Sheets, Slides APIs Revamped To Improve Workflow

...

Revised APIs for Sheets and Slides aim to help developers make data in Google Apps for Work more readily accessible to third-party apps.

Google may struggle with social networking, but it does better with machine networking, in the form of APIs.

APIs, or application programming interfaces, allow programs to talk to one another. In an era when nearly everything is potentially programmable, APIs have become more important than ever, particularly to businesses that need to connect a diverse portfolio of services.

Google Apps has had APIs for years, but much of the recent attention lavished on the suite has occurred at a business level. Google has shown more interest in increasing its enterprise credibility than its technical capability.

But after strengthening its Google Apps for Work partner program and bringing Diane Greene on board to run the company's enterprise business, Google wants to make the technical foundation of its cloud productivity suite more useful to enterprise partners.

"There have been APIs for Docs to give you programmatic access since 2006, but we really weren't focused on building an enterprise-grade ecosystem," said Ritcha Ranjan, group product manager for Google Docs in an interview last week. "And we really weren't focused on getting leading partners in the enterprise space to help us with this."

Last year, Google introduced the Classroom API to help developers integrate education apps with Google Classroom, a tool to make Google Apps for Education more useful to teachers. This year, as Google plans to announce at Google I/O 2016, the company is updating Sheets and Slides, to help developers make data in Google Apps for Work more readily accessible to third-party apps.

Ranjan said after talking with partners and looking at how people use Google Apps, Google realized there was an opportunity to improve workflows that exist between Google Apps and other applications. Often these workflows involve copying and pasting data between apps.

"What we want to do is take what takes minutes in a workflow today and simplify that down into a couple of clicks," said Ranjan.

At Google I/O on Wednesday, Ranjan said, Google plans to announce enhancements to the APIs for Sheets and Slides that allow the products to communicate more easily with third-party services.

The new Sheets API makes almost all the features in Sheets programmatically accessible. With the API, developers will be able to write code to replace copy-and-paste data transport from Google Apps to a CRM or ERP app.

"Salesforce is using our API to do real-time updates," said Ranjan. "The thing we think is a real differentiator here is that the data, when updated in Google Sheets, will be automatically pushed back in real-time to Salesforce."

Other companies working to integrate the Sheets API include Anaplan, Asana, Sage, and SAP.

Similarly, the new Slides API will allow developers to alter Slides programmatically, enabling one-button updates to data and charts in Slides. Developers can sign up for early access, with general availability planned in a few months.

Google says Conga, ProsperWorks, SalesforceIQ, and Trello are among the companies working to integrate the Slides API into their products.

On a related note, Google intends to allow live data from Sheets to be embedded in Docs or Slides files. Using this capability, associated documents in other applications can be updated to match the data in Sheets with a single click.

Also, the Classroom API is getting new endpoints so that developers can integrate assignments, grades, and workflow into their apps. With the ability to sync Classroom grades to reporting systems, teachers should no longer need to transfer grades manually.

Jonathan Rochelle, director of product for Google Apps for Education, said that the next journey for Google Apps is machine intelligence, pointing to the Explore feature in Sheets as an example of the kinds of innovations to expect. That means adding to your team, he said, "not just people but the machine. Not just relying on it to do mundane task replacement, but to be smart and add intelligence to the process."

Categories
APPLICATIONS
0 Comment

Leave a Reply

Captcha image


RELATED BY

  • 5300c769af79e

    Bellabeat turns over a new Leaf with smart jewelry to help you stay stress free

    In addition to the stress tracking feature, the new app will bring improved meditation and mindfulness techniques.The company also has a new piece of smart jewelry called the Leaf Urban.
  • 5300c769af79e

    ASUS Teases CES ZenFone Event With 'Explore the Unknown' Video

    In the video, we see two young children exploring the world around them, as well as a young man who oddly resembles Harry Potter who is recreating the solar system out of papier-mâché.Near the end, ASUS shows off the outline of a device, but we don’t really get a good look at it.
  • 5300c769af79e

    Scientists Can Sequence DNA With a Smartphone

    Scientists have created a smartphone-based microscope that could make cancer screening accessible to healthcare workers in the more remote areas of the world.The device is aimed at underdeveloped countries, where doctors don't always have the tools or expertise to conduct DNA sequencing analysis and testing for genetic mutations.
  • 5300c769af79e

    Report: Sony Confirms 'High-End' PS4

    As expected, Sony is developing an upgraded version of its PlayStation 4 console with support for 4K and richer graphics, Sony Interactive Entertainment head Andrew House told the Financial Times.Rumors about a new PS4, codenamed "Neo," began swirling in March when The Wall Street Journal teased a new PlayStation that could more effectively handle virtual reality content.