Tag Archives: Google Slides

See a snapshot of information about a file in Google Docs, Sheets, and Slides

Today, you can view the details of any file or folder stored in Google Drive, including the file or folder owner’s name, the last time it was opened or modified, its location, and more. With this launch, you’ll gain that same capability in Google Docs, Sheets, and Slides on the web.

To see details of a Google document, spreadsheet, or presentation, simply select Document details from the File menu.


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

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

Impact:
All end users

Action:
Change management suggested/FYI

Note: all launches are applicable to all Google Apps editions unless otherwise noted

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

Better tables and charts in the Google Docs, Sheets, and Slides Android apps

The latest releases of the Google Docs, Sheets, and Slides apps for Android make it easy to create tables and improve the look of charts on your mobile phone or tablet.

For instance, starting today, when you copy a body of cells in Sheets and paste it into Docs or Slides, that selection will render as a fully-formatted table, gridlines and all. This will only work for selections of fewer than 400 cells; anything larger will be pasted in a tab-separated format. Note that you will need to update all three apps—Docs, Sheets, and Slides—for this to work.


We’ve also made improvements to the technology that powers charts in Sheets, so you may notice small changes to the way your charts are drawn.

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

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

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

Impact:
All end users

Action:
Change management suggested/FYI

Note: all launches are applicable to all Google Apps editions unless otherwise noted

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

How BioDot’s global team works better together using Android and Chrome

Posted by Dan Tisone, VP of Global IT, BioDot

Editor's note: Today we hear from Dan Tisone, VP of Global IT at BioDot, a low volume dispensing manufacturer specializing in biotech applications. Learn how BioDot’s 60 employees use Android and Chrome devices to work closely together and build better products.


I’ve led IT at BioDot since my father, a former research and development engineer at Nokia Bell Labs, founded the company in 1994. Since then, I’ve seen workplace technology evolve from clunky desktops and servers to the fast, cloud-based devices we use today.

Our transition to Google started with Gmail in 2009. Through Gmail we discovered Google Apps like Drive, Hangouts and Docs. Google Apps are affordable and easy to use, so when we needed to purchase computers and smartphones for our employees the following year, we chose Google Chrome and Android products. Today, we have 42 Android smartphones, as well as a few dozen Chromebooks and Chromeboxes.

As an international business headquartered in Southern California with satellite offices in Asia and Europe, our sales team travels a great deal, and tends to use their smartphones more than laptops, whether they’re at the airport, in between meetings or in a taxi. They use Google Docs to review contracts and Google Slides to create new business presentations from their Android phones while traveling. They can even update Pipedrive, our CRM platform, through the mobile app.

I install work apps on each device using Google Mobile Device Management so employees can access required work apps and install any other pre-approved apps from the Play for Work Store. I can securely manage all devices with this central console, too. If an employee accidentally installs an app or downloads malware, I receive an alert and can fix the problem immediately.

Setting up Chromebooks is simple, too. It used to take me hours to deploy our old laptops. Each Chromebook takes minutes to set up — no time-consuming installations required. As BioDot’s sole IT staff member, it can be difficult to quickly deploy new devices while ensuring the security of every company device around the world. Chrome makes this easier.

Cloud-based Android devices also foster a collaborative work environment. For example, when the manufacturing team is assembling a new medical dispenser in the factory, they mark up the schematic diagram in red pen to show which parts don’t work. They used to snail-mail this marked up diagram to our engineers, who are hundreds or thousands of miles away in an office. Now, the manufacturing team snaps a picture of the schematic with their Android phone and uploads it to Google Drive, so engineers can see their revisions immediately. This saves our teams a few days’ delay, so they can iterate faster, and ultimately build better products in a shorter timeframe.

Google Apps also allows us to be more productive and efficient. Instead of taking a one-day trip to meet with a prospect for the first time, sales executives are starting to use Google Hangouts. This saves our company around $1,000 for each trip. When you think about the hundreds of trips salespeople take throughout the year, these savings go a long way — especially for a small company.

Switching to Google Apps, and subsequently Chrome and Android devices helps BioDot run faster and more smoothly. Employees, from tech-savvy millennials to employees who were new to smartphones, now rely on Android and Chrome devices to work together and complete tasks, whether they’re in the office, on the road or at one of our manufacturing facilities.

Choose a file’s folder location when you make a copy in Google Docs, Sheets, and Slides

Previously, when you made a copy of a Google Docs, Sheets, or Slides file, that copy would be automatically added to your My Drive folder—instead of the original file’s folder as most people would expect. Going forward, when you make a copy of a Docs, Sheets, or Slides file on the web, you’ll be able to choose which folder to place the file in. This should reduce confusion and make it easier to organize your Docs, Sheets, and Slides files.


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

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

Impact: 
All end users

Action: 
Change management suggested/FYI

Note: all launches are applicable to all Google Apps editions unless otherwise noted

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

Google Apps and gaming help Melexis keep a fast-growing global team together

Posted by Koen Bosmans, Senior System Administrator/Service Desk Team Lead, Tessenderlo, Belgium

Editor's note: Today we hear from Koen Bosmans, Senior Systems Administrator at Melexis, a microelectronics supplier based in Tessenderlo, Belgium. One of the world’s top producers of sensors and microchips for the automotive industry, Melexis is expanding into new industries, with great success. Spread across 11 offices in nine countries, read how this truly global company uses Google Apps for Work to build its international team.
There’s a good chance you’ve used one of our products without realising it. The sophisticated microchips we make are in everything from children’s ear thermometers, to airbags, to smartphones, to drones. And as the demand for microelectronics has grown, so has our business: Melexis shares are worth 20 times more now than when I started working here in 1999, and today we employ 1,200 staff worldwide in Belgium, Bulgaria, France, Germany, Switzerland, China, Malaysia, the Ukraine and the US. As early as 2010, we could see that this rapid expansion might lead to “silo thinking” that prevents outstanding engineers in different countries from working together effectively in a global team. That’s why Melexis management asked me to research alternatives to the open-source software we were using.
I ranked five IT solutions on 25 criteria — including web accessibility, document sharing and OS compatibility — and Google Apps for Work came out on top. We bought 500 accounts and got ready to deploy them over 13 weeks. But after the first fortnight, I realised that Google Apps training was so straightforward I could ask a student working in my department to do it. He travelled the world for three months and trained the entire company.

Google Apps improves staff satisfaction with their work environment and rewards teamwork. In the first quarter after we switched to Gmail, the number of complaints about email dropped by 65%. No more spam or slow webmail, and Calendar has ended confusion over meeting room bookings. Expansion is much easier, too; instead of having to install servers and data lines in every new office, all we need is an internet connection. Plus, we can expand without asking engineers to relocate, since as part of a virtual team, they can talk to colleagues anywhere in the world over Hangouts while working together on a shared document in Sheets. And wherever we are, Drive saves time by letting colleagues work simultaneously on single documents — whether it’s our R&D teams collecting test data in Sheets, or the IT team preparing a presentation on Slides for our monthly meeting.

Through my experience using Google Apps within our IT team, I understand how something as simple as face-to-face contact through Hangouts can make a team so much stronger. My IT Service Desk team is made up of eight people split over six locations, and we meet every two days on Hangouts to discuss work. I noticed that seeing each other so often created a relaxed and friendly dynamic that made it easier to share advice and help each other.

At Melexis, we don’t just work hard, we play hard, too. Fun is part of our DNA, and three years ago, we invited everyone to take part in an international computer game LAN party. We’ve been doing it every year since, and it’s always a great opportunity to get to know each other across different locations.
Google Apps makes these international LAN parties possible. Staff use Forms to sign up for some of the four or five games we’ll be playing in competition, and we organise times and equipment through a community on Google+. Presentations on Slides explain what we’re doing, and we use Sheets to keep score.
The party starts at 6pm on a Friday. In each office, staff decorate a room, put on fancy dress, and set up a Hangout between all the offices, even our senior leaders get dressed up and take part! Projection screens, microphones and speakers let the offices communicate with each other while the organisers announce gaming fixtures. Our scoreboard is in Sheets, which automatically updates its graphs with all the new information from every match.
In the first year, we had 120 participants, and that number’s been going up every year since. We’ve even given out best-dressed awards for themes from Halloween to superheroes.
Now, when I travel between our offices in different countries, staff walk up to tell me how good the LAN parties are for the company and morale. But there’s no question that combining our talents and pulling together through technology, wherever we are, lies at the heart of our global success.

Charter schools use technology to explore history and diverse perspectives

Posted by Jilli Hume, Program Manager, Google for Education team

(Cross-posted on the Google for Education Blog.)

Editor's note: Small schools are seeing great success with Google for Education tools. We spoke with educators and administrators from smaller districts across the United States to better understand how technology has helped them innovate, create more efficient processes, and make a positive impact on their students. This is the second in a series of posts where we explore the impact small schools are making on their students. To learn more about using Google for Education tools in charter schools, visit us here. 

Charter schools are small but mighty. While they don’t have the resources and support an entire district has, they do have ambitious goals when it comes to educating their students. We’ve encountered a number of charter schools who are leading the way in their use of technology to help students become inquisitive learners, fostering in them a desire to learn about the world around them. These charter schools are using interactive experiences to spark students’ imaginations, encouraging them to learn about international landmarks, social issues in their communities and historical events that have shaped our country. They’ve found that when students acknowledge diversity in their communities and the world, they’re encouraged to think about how they can create positive change beyond the classroom.

Greater exposure to social issues and diverse perspectives 


Teachers at Brooklyn Prospect Charter School use technology to host discussions about current events, giving every student a voice — including those who are quieter in a traditional classroom setting. For example, after one teacher shared an article with her class about conflict in the Middle East via Google Classroom, every student had the opportunity to comment and share his or her opinion via a text-based discussion in Classroom.

"The most interesting thing I learned from classmates during Google Classroom discussions is how they interpreted a book we read,” says Lena Gallager, an 11th grade student at Brooklyn Prospect Charter School. “We were able to compare our thoughts on the book and build ideas off of each other.”

“When we discussed poetry using Google Classroom, I gained a sense of others’ perspectives. Google Classroom made it really collaborative and easy to share knowledge on the topic,” says fellow 11th grader Nicolas Villarosa.

Along with having open conversations about international news, students at Brooklyn Prospect are encouraged to learn about the issues affecting their own communities. One 10th grader wanted to understand what his peers viewed as the most concerning global issues. As his end-of-the-year project for the international baccalaureate program, he created a survey in Google Forms to collect his peers’ opinions on the topic. He then used those responses as inspiration to compose a musical protest album to raise awareness for the gravity of the issues.

“Technology is helping our students become citizens of the world by cultivating their awareness and giving them a global view,” says Tyra Frederick, educational technology coordinator and high school English teacher at Brooklyn Prospect.

Interactive learning about our forefathers 


Exposing students to a global curriculum at a young age is vital for them to become well-rounded, culturally aware citizens. In addition to teaching geography and history, many schools teach classes about international current events. They also explore how historical events have shaped a city’s identity.

Westlake Charter Schools, for example, encourages students to become curious learners about their pasts. When eighth grade history teacher, Caroline Gaea, gave students an assignment to map the Manifest Destiny across the United States by dropping pins in Google Maps, students went above and beyond. They engaged in critical thinking, not only commenting on the significance of a location at a particular moment in time, but also noting the overall importance of that moment in the broader context of American history.
An eighth grade student at Westlake Charter Schools comments on a city's role in the Manifest Destiny


“My favorite part of the project was being able to be creative with information and make it fun to read,” says Maya, an eighth grader at Westlake Charter Schools. “There were so many different ways to learn the same thing, so each student was able to customize their experience.”

Even after that assignment was complete, students took the initiative to dive deeper into the topic — they impressed their teacher with a historical map of the United States, using layers in Google Maps to show the 1803 Louisiana Purchase.
Westlake Charter Schools students create a collaborative, historical map in Google Maps
“This project made me even more excited to learn about American history because the Google tools give us an opportunity to express our knowledge on a whole new level,” says Grace, an eighth grader at Westlake Charter Schools.

“Mapping out the places and presidents of that time period made it feel like we were there because we understood it better,” says Jada, an eighth grader at Westlake Charter Schools.

Taking virtual field trips around the world


Students at Challenge to Excellence Charter School are using technology to travel outside of the classroom. When a second grade student traveled to India for a family vacation, his classmates virtually went with him. The student took a tablet so he could take pictures of his trip and share them with the class. Back in the classroom, students researched the landmarks that their classmate was visiting and had a real-life view of places like the Taj Mahal using Google Earth.

“It was so fun to be able to take my tablet with me to India to take pictures and then send them to my class,” says Arushi, a second grader at Challenge to Excellence Charter School. “Mrs. Stewart shared the pictures with the class before I even got back home.”

“When the student came back from his trip, his classmates showed him all the pictures and information they’d collected,” says Julie Stewart, technology integration specialist at Challenge to Excellence Charter School. “You could feel their excitement — the project helped take my students outside the four walls of the classroom.”

These are just a few of the ways charter schools are inspiring students to think big and learn about experiences beyond their own. What do you think? What are the best ways for schools — public, independent or charter — to approach a global education?

Charter schools use technology to explore history and diverse perspectives

Posted by Jilli Hume, Program Manager, Google for Education team

Editor's note: Small schools are seeing great success with Google for Education tools. We spoke with educators and administrators from smaller districts across the United States to better understand how technology has helped them innovate, create more efficient processes, and make a positive impact on their students. This is the second in a series of posts where we explore the impact small schools are making on their students. To learn more about using Google for Education tools in charter schools, visit us here. 

Charter schools are small but mighty. While they don’t have the resources and support an entire district has, they do have ambitious goals when it comes to educating their students. We’ve encountered a number of charter schools who are leading the way in their use of technology to help students become inquisitive learners, fostering in them a desire to learn about the world around them. These charter schools are using interactive experiences to spark students’ imaginations, encouraging them to learn about international landmarks, social issues in their communities and historical events that have shaped our country. They’ve found that when students acknowledge diversity in their communities and the world, they’re encouraged to think about how they can create positive change beyond the classroom.

Greater exposure to social issues and diverse perspectives 


Teachers at Brooklyn Prospect Charter School use technology to host discussions about current events, giving every student a voice — including those who are quieter in a traditional classroom setting. For example, after one teacher shared an article with her class about conflict in the Middle East via Google Classroom, every student had the opportunity to comment and share his or her opinion via a text-based discussion in Classroom.

"The most interesting thing I learned from classmates during Google Classroom discussions is how they interpreted a book we read,” says Lena Gallager, an 11th grade student at Brooklyn Prospect Charter School. “We were able to compare our thoughts on the book and build ideas off of each other.”

“When we discussed poetry using Google Classroom, I gained a sense of others’ perspectives. Google Classroom made it really collaborative and easy to share knowledge on the topic,” says fellow 11th grader Nicolas Villarosa.

Along with having open conversations about international news, students at Brooklyn Prospect are encouraged to learn about the issues affecting their own communities. One 10th grader wanted to understand what his peers viewed as the most concerning global issues. As his end-of-the-year project for the international baccalaureate program, he created a survey in Google Forms to collect his peers’ opinions on the topic. He then used those responses as inspiration to compose a musical protest album to raise awareness for the gravity of the issues.

“Technology is helping our students become citizens of the world by cultivating their awareness and giving them a global view,” says Tyra Frederick, educational technology coordinator and high school English teacher at Brooklyn Prospect.

Interactive learning about our forefathers 

Exposing students to a global curriculum at a young age is vital for them to become well-rounded, culturally aware citizens. In addition to teaching geography and history, many schools teach classes about international current events. They also explore how historical events have shaped a city’s identity.

Westlake Charter Schools, for example, encourages students to become curious learners about their pasts. When eighth grade history teacher, Caroline Gaea, gave students an assignment to map the Manifest Destiny across the United States by dropping pins in Google Maps, students went above and beyond. They engaged in critical thinking, not only commenting on the significance of a location at a particular moment in time, but also noting the overall importance of that moment in the broader context of American history.
An eighth grade student at Westlake Charter Schools comments on a city's role in the Manifest Destiny

“My favorite part of the project was being able to be creative with information and make it fun to read,” says Maya, an eighth grader at Westlake Charter Schools. “There were so many different ways to learn the same thing, so each student was able to customize their experience.”

Even after that assignment was complete, students took the initiative to dive deeper into the topic — they impressed their teacher with a historical map of the United States, using layers in Google Maps to show the 1803 Louisiana Purchase.
Westlake Charter Schools students create a collaborative, historical map in Google Maps
“This project made me even more excited to learn about American history because the Google tools give us an opportunity to express our knowledge on a whole new level,” says Grace, an eighth grader at Westlake Charter Schools.

“Mapping out the places and presidents of that time period made it feel like we were there because we understood it better,” says Jada, an eighth grader at Westlake Charter Schools.

Taking virtual field trips around the world


Students at Challenge to Excellence Charter School are using technology to travel outside of the classroom. When a second grade student traveled to India for a family vacation, his classmates virtually went with him. The student took a tablet so he could take pictures of his trip and share them with the class. Back in the classroom, students researched the landmarks that their classmate was visiting and had a real-life view of places like the Taj Mahal using Google Earth.

“It was so fun to be able to take my tablet with me to India to take pictures and then send them to my class,” says Arushi, a second grader at Challenge to Excellence Charter School. “Mrs. Stewart shared the pictures with the class before I even got back home.”

“When the student came back from his trip, his classmates showed him all the pictures and information they’d collected,” says Julie Stewart, technology integration specialist at Challenge to Excellence Charter School. “You could feel their excitement — the project helped take my students outside the four walls of the classroom.” These are just a few of the ways charter schools are inspiring students to think big and learn about experiences beyond their own. What do you think? What are the best ways for schools — public, independent or charter — to approach a global education?

Online Travel Agent (OTA) Travix takes off with Google Apps for Work

Posted by Jan Castelijns, Head of Systems Engineering and IT Operations, Travix, Amsterdam, The Netherlands

Editor's note: Today we hear from Jan Castelijns, Head of Systems Engineering and IT Operations at Travix, a global online travel technology company that sells low fare flight tickets to 2.5 million passengers from 28 countries every year. Founded in 2011, Travix has rapidly built up a network of 500 staff in seven offices worldwide. Read why they chose Google Apps as the IT infrastructure behind their rapid expansion.

When Travix started out in 2011, it was through the merger of three companies. We gained strength from that diversity, but we also inherited three corporate IT systems. So the first thing the CEO asked me to do when I joined was to find one system we could use across the whole company. He recommended Microsoft Office 365, but implementing it was more demanding than anyone had expected. Months into the process, I went back to him with a realistic projection of the time and resources necessary to finish the rollout, and a recommendation that we put the project on hold. The hunt began for alternatives. That’s where Google Apps came in.

Google Apps is perfectly suited for an expanding global business. We have offices in Amsterdam, Oosterhout, Berlin, Bangalore, Singapore, California and London, and in all of these places, Office 365 required infrastructure modifications before implementation. By contrast, Google Apps was ready to go right out of the box.

Our corporate IT systems need to be quick, reliable and safe, with a minimum of costs and management overhead. Google Apps costs less to implement, less to maintain and allows greater contractual flexibility than Office 365. Because Google Apps is also entirely cloud based, we don’t need to install servers, as recommended in the hybrid server-cloud Office 365 solution. In fact, Google Apps allowed the decommissioning of 10 existing servers, each of which is priced at $3,000.

Rolling out Google Apps took just six weeks. g-company led training with one-on-one sessions for executives, small workshops for staff and even presentations over Hangouts for our Bangalore team. But key to our rapid deployment were the “ambassadors” – staff prepared to support their colleagues when Google Apps went live. After setting up our systems engineers on Google Apps, I sent out a Form for people to register as ambassadors and the response was overwhelming: 104 people signed up for 50 positions. This was a clear sign for us that our people were willing to embrace this change and make this transition work.

At Travix, we already worked with other Google products in particular fields, like Google Analytics and Google Adwords in marketing and Google BigQuery and kubernetes in engineering. Now we have Google Apps for everyone.

Staff here have become very enthusiastic about Google Apps, as they see how the tools fit into their working lives. Gmail, Calendar and Hangouts let staff stay on top of their work anytime, from anywhere. Rather than book meeting rooms through a separate app, now everything is on Calendar, saving time and hassle. Drive has been organically and rapidly adopted across the organisation, and Forms has been a huge success that we didn’t even plan for. Instead of starting a gigantic email thread or using a free survey tool found on the internet, we now use the simple Forms interface to get swift feedback, with answers fed directly into Sheets for analysis.

Hangouts in particular has changed the way we communicate, whether through the efficiency of instant messaging or by working more closely with colleagues abroad. Hangouts on Air allows staff in other offices to participate in our CEO’s presentations in Amsterdam, and because the stream is recorded, engineers in Bangalore and California can watch it too, despite the time difference. Collaboration between team members no longer requires a kind of “email ping pong” and stressful version control. We can just open Hangouts and Drive and go through a document together, whether an engineering design in Docs, a marketing product plan on Slides, or details of a tender on Sheets.

A growing global technology company demands an IT solution that works in any location, on any device. On top of that, it has to be cost-effective, easy to maintain and ready to use in short time. It’s my job to provide that for my colleagues. With Google Apps, that’s exactly what we’ve got.

Bartle Bogle Hegarty takes good ideas global with Google Apps for Work

Posted by Andy Coppin, Operations Director at Bartle Bogle Hegarty

Editor's note: Today we hear from Andy Coppin, Operations Director at Bartle Bogle Hegarty, a global advertising agency based in London. Founded in 1982, BBH has twice won Agency of the Year at the Cannes Lions International Advertising Festival with groundbreaking campaigns for clients including Audi, British Airways, Tesco and Unilever. With offices in London, Los Angeles, New York, Shanghai, Singapore, Mumbai and Stockholm, read how the BBH team uses Google Apps for Work to enhance its global network.

A good idea can cross borders. That’s one reason why we have just one office in each global region, instead of one office in each country like most of our competitors. It keeps campaigns focused and recognises that our adventurous staff see travel as a perk, rather than a chore. So when we overhauled our IT system in 2010, we needed a system that enabled both close international collaboration and great mobility. Google Apps for Work opened up far-reaching creative possibilities that change the way we work.

Mobility we need with lower cost, more dependable tools


Google Apps is ideal for flexible and mobile working. Gmail and Calendar are web-based, so client-facing teams are never out of touch as they travel to meetings abroad. Previously, remotely connecting to our old servers could only be done with an unreliable VPN. It proved to be an expensive liability with a tendency to fail. Drive is not only cheaper, it’s also dependable. The instant messaging function on Hangouts is perfect for teams on the road. Chromebox for meetings has become so powerful and easy to use that it’s entirely superseded the separate video conferencing system we installed five years ago.

Managing IT and administrative controls internally, for faster troubleshooting


The simple administrative interface and modular design of Google Apps for Work means we can solve IT problems internally instead of spending on external support. My colleague Will Triantos, our Global Google Technical Lead, not only administers the entire platform for 1,000 staff in eight offices, he’s also constantly creating new ways of using Google Apps to improve work at BBH. Fast, friendly and comprehensive support from Cloud Technology Solutions (CTS) means all the advice we need is always on-hand. With their support, we migrated our entire Stockholm office to Google Apps in less than a week.

Fostering a culture of creative IT, sharing and efficiency


Using Sites, Drive and Google APIs, Will has created a much-improved new intranet. While our previous intranet was based on servers around the world that cost us £20,000 a year to license, the new intranet is entirely cloud-based, so we don’t pay to maintain our own hardware. Because it uses Sheets to present our global company directory, we can always be confident we have up-to-date contact details for all our offices. With its connections to Drive, we can upload documents like historical advertising pitches in a few seconds, instead of in ten to thirty minutes. And because any of our staff can upload, rather than just one administrator in London, each office can share news and holiday information specific to them. Teams anywhere can access their local Google+ communities or submit Forms to make catering requests from kitchen staff, and users access the intranet with their Google Account single sign on, too, so their Gmail, Calendar and Drive is embedded and only a click away.

Most IT FAQs are answered on our intranet, so Will is free to find other applications for Google Apps. To take a simple example, before new BBH staff arrive at the office, they fill in a Form on Sites that connects to a Sheet in HR, so we have all their details in advance. And at the building entrance they sign-in to a Form on a tablet that emails reception, so the right person can be there to meet them. Small things like that add up, make a great impression and prove that cutting admin in one area frees creative thinking elsewhere.

New ways to keep data flowing between your apps and ours

(Cross-posted on Google Apps Developer Blog)

Posted by Tom Holman, Product Manager, Google Sheets

There was a time when office work used to be all about pushing physical paper. Computing and productivity tools have made things better, but workers still find themselves doing the same tasks over and over across the different apps they use: copying and pasting from a CRM app to a slide presentation, or manually exporting data from a project management app just to turn around and import it back into a spreadsheet. It’s the digital equivalent of pushing paper.

To make it easier to get the job done across multiple apps, without all the copy and paste, we’re announcing three new APIs and a new feature to help workers get to the data they need, when and where they need it.

Build seamless integrations with the new Sheets and Slides APIs

Our new APIs let developers connect their apps—and the data within them—more deeply with Google Sheets and Google Slides.

The new Sheets API gives developers programmatic access to powerful features in the Sheets web and mobile interfaces, including charts and pivot tables. For example, developers can use Sheets as part of a rich workflow that pushes data from their app into Sheets and allows users to collaborate on that data before the updated data is pulled back into the original app, removing altogether the need to copy and paste.

Teams at Anaplan, Asana, Sage, Salesforce, and SAP Anywhere are already building interesting integrations with the new Sheets API. Check out this video to see an overview of what’s possible, as well as several example integrations.


The new Sheets API is available today. Find the developer documentation as well as a codelab to help you get started at developers.google.com/sheets.

Similar to the Sheets API, the new Slides API gives developers programmatic access to create and update presentations. For example, developers can use this API to push data and charts into Slides to create a polished report from source data in other application, ready to present.

Conga, ProsperWorks, SalesforceIQ, and Trello are all building integrations with Slides using the new API. Several examples of what’s possible are in this video.


The Slides API will be launching in the coming months, and these partner integrations will be available soon after. You can sign up for early access to the Slides API at developers.google.com/slides.

Keep your data in sync with the new Classroom API

For developers building tools and workflows for schools, the Classroom API has launched new coursework endpoints to help you build stronger integrations that keep your data in sync. Read the full announcement on the Google for Education blog, here.


Say goodbye to stale data with linked charts

Finally, to make sure we can help keep all this data flowing seamlessly from app to app, users can now also embed linked charts from Sheets into Docs or Slides. The result? Once the underlying data in a spreadsheet changes, whether that change comes from an action taken in another app via the API or a collaborator, an updated chart in the corresponding presentation or document is just one click away.



For more information, see how to add a chart to a document or to a presentation.

We can't wait to see what you build.

Note: all launches are applicable to all Google Apps editions unless otherwise noted

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