Tag Archives: Google Slides

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

Embed charts from Google Sheets in Google Docs and Slides and update them with a single click

Charts help you display data in a visually compelling way. At work, the same chart may be used across multiple documents and presentations, to help you better convey your message and strengthen your argument. If that chart changes, it can be tedious and time-consuming to replace it in each and every file. To save you valuable time, we’re now making it possible to update your chart with a single click—without ever needing to leave your document or presentation.

To get started, simply go to Insert > Chart in Google Docs or Slides on the web. Insert a new chart, or select From Sheets to add an existing chart from the spreadsheet of your choice. As long as you check the Link to spreadsheet box, you’ll be given the option to update the chart with one click if its underlying data in Google Sheets changes. Should you no longer want to be notified of updates to a particular chart, you can simply unlink it. This same functionality is available if you copy and paste a chart into a document or presentation.



Please note that the ability to import or update linked charts will only be available to collaborators with edit access to the document, presentation, or underlying spreadsheet. For more information on embedding charts in your Docs and Slides files, check out the Help Center articles below.

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

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

Impact:
All end users

Action:
Change management suggested/FYI

More Information
Help Center: Add a chart to a slide
Help Center: Add a chart to a document

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

Opening Google Docs, Sheets, and Slides files on mobile now easier when you’re offline

We know that internet connections can be spotty when you’re working on your phone on the go. And we recognize that sometimes you need access to a file you didn’t remember to make available offline. With this launch, we’ll make it easier to open Google Docs, Sheets, and Slides files on your Android and iOS devices when you’re not online.

Starting today, any Docs, Sheets, or Slides files you’ve recently worked on will be automatically synced to your mobile device, so you can open them even if you don’t have an internet connection. As your documents, spreadsheets, and presentations go stale—or if your phone or tablet maxes out on storage space—we’ll remove those older files from your device. To see what documents are saved to your device and to access them later, simply select Offline from the overflow menu in your Docs, Sheets, or Slides app. This will show files synced both automatically and manually (note that manually synced files will now be labeled with a checkmark, instead of a pin icon).



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

More Information
Help Center: Work on Google files offline

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

New ways to keep data flowing between your apps and ours

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 the video below to see an overview of what’s possible as well as several example integrations.


Partner integrations with the new Google Sheets API

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 the video below.


Partner integrations with the new Google Slides API

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.

Sync assignments & grades programmatically with the Google Classroom API


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.

Linked charts allow for easy updates in Docs & Slides

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.

How oil and gas company Imaginea Energy built a productivity pipeline

Posted by Greg Bennett, Imaginea

Editor's note: Today we hear from Greg Bennett of Imaginea Energy, an oil and gas company based in Calgary, Alberta Canada. Learn how Google Apps helps Imaginea defy industry stereotypes as they work to produce energy sustainably, securely and profitably.

At Imaginea Energy, our vision is an Oil and Gas industry that is much better for the Planet, and for People, and for Profits. This vision is reflected in our culture, the mindsets of our people as well as in our organizational model. Together, our organizational model and culture promote curiosity, teamwork and 10X thinking — values that affect everything from our team-driven project pitches, to idea generation to the tools that are integral to creating solutions that match our aspirations, like Google Apps for Work.

We switched from our previous platform because our legacy storage, productivity and email tools didn’t reflect our open and transparent culture or our vision of the future. The closed IT environment made it difficult to collaborate together beyond very small teams: file-sharing was non-existent, which created insane revision situations and confusion about document version control. Google Drive changes all of that. We've migrated nearly 260,000 files to Drive, all of which can be accessed from anywhere, on any device, without deploying a rigid shared drive structure.

Google Docs, Sheets, Slides and Forms have absolutely transformed how we work together. With real-time editing, commenting and data collection, we can quickly share ideas and insights and rapidly move work forward together. At a recent meeting we had over 30 people generate 20 pages of new ideas in under two hours. Seamless collaboration and rapid ideation like this simply wasn’t possible before.

Google Apps for Work combined with our flexible working environment provide maximum autonomy, which our employees leverage to increase their productivity both in and out of the office. Visit our headquarters on a Friday and you might find up to 40% of our people foregoing their commute in favour of working from home (or a coffee shop, or a park). This flexibility really works for our company and our team.

With access to information online or offline, the ability to work remotely extends to the vast 30,000 km2 of rolling prairie that our operations cover. Operators can capture data even without internet access. Once they re-connect, all of their offline work is instantly synced, eliminating redundant data-entry and confusion.

Our ability to work from anywhere has been further enhanced by using Google Hangouts. Whether a field operator is at one of our 600+ active wells or a team member is running a training presentation from 7,000 kms away in Europe, Hangouts connects our people face-to-face. Our field staff have cut down on the 500 km round trip visits to headquarters — now they can spend more time on-site, and less time driving by communicating and holding meeting via Hangouts. Reducing driving time increases the safety of our team, and also reduces our environmental footprint and operating costs.

Not only has switching to Google Apps saved us significant time, it will also reduce our IT spend. By mid-2016, we’ll have saved over 50 percent on IT maintenance, money that can be redeployed to develop solutions to business problems and maximising our team’s capabilities.

Google Apps gives us the security we need without compromising information flow or flexibility. The Admin console lets us customize mobile device management and quickly respond to changing security events. On a recent trip to Paris, a company device was stolen on the subway. Within 12 minutes, access credentials were changed and our data was secured. This security extends behind the scenes to every part of Google Apps. We may never have world-leading security experts on our staff, but luckily we don’t have to: Google does. Having trust in our tools, combined with the trust we invest in our employees, means we can focus on creating value without obsessing over security.

At Imaginea, we defy industry stereotypes by focusing on Planet, People and Profit together. When you set out to reimagine an industry like oil and gas, achieving that vision is only possible with the right people and the right tools. With Google Apps, we’ve set course to truly transform our business and the energy industry.