Tag Archives: Google Sheets

Introducing Android add-ons for Docs and Sheets

Posted by Saurabh Gupta, Product Manager, Google Apps

Students and teachers use the Docs and Sheets apps to get schoolwork done on the go - whether they’re putting the finishing touches on a research paper or working with classmates on a science fair project. Today, we’re introducing Android add-ons for Docs and Sheets, new tools created by third-party developers with students in mind to help make completing schoolwork even easier.

Get more done, no matter where you are

These Android add-ons give students and teachers the ability to accomplish more in their documents and spreadsheets.

EasyBib: Quickly and easily add citations when you’re working in Docs on your Android with the EasyBib add-on. Automatically format citations by URL, title, or simply capture a book bar code with your Android’s camera. Read more here.

Google Classroom: Easily turn in your Classroom assignments from Docs on Android with the new Classroom add-on.

You can find these add-ons and many more, including Teacher Aide, DocuSign, ProsperWorks, AppSheet and Scanbot in our Google Play collection as well as directly from the add-on menus in Google Docs or Google Sheets.
Try them out today, and see how much more you can do.

Introducing Android add-ons for Docs and Sheets

Posted by Saurabh Gupta, Product Manager, Google Apps

Students and teachers use the Docs and Sheets apps to get schoolwork done on the go - whether they’re putting the finishing touches on a research paper or working with classmates on a science fair project. Today, we’re introducing Android add-ons for Docs and Sheets, new tools created by third-party developers with students in mind to help make completing schoolwork even easier.

Get more done, no matter where you are

These Android add-ons give students and teachers the ability to accomplish more in their documents and spreadsheets.

EasyBib: Quickly and easily add citations when you’re working in Docs on your Android with the EasyBib add-on. Automatically format citations by URL, title, or simply capture a book bar code with your Android’s camera. Read more here.

Google Classroom: Easily turn in your Classroom assignments from Docs on Android with the new Classroom add-on.

You can find these add-ons and many more, including Teacher Aide, DocuSign, ProsperWorks, AppSheet and Scanbot in our Google Play collection as well as directly from the add-on menus in Google Docs or Google Sheets.
Try them out today, and see how much more you can do.

Colossal Media and the art of collaboration: Sheets to the streets


Editor's note: Today Google Sheets unveiled an original artwork in NYC , designed entirely in Sheets by two artists working together from different continents. To turn their artwork into reality, we worked with Colossal Media, a Brooklyn-based company and Google Apps customer that hand-paints murals all over the world. At Google, we’re always inspired by innovative uses of our collaboration tools, so we spoke with Colossal co-founder Adrian Moeller to learn what inspires him.

Can you tell us about Colossal Media and what drove you and your co-founder to start the company?
Colossal was founded in 2004 to bring hand-painted advertising back. It was tough to get clients at the beginning because nobody wanted to hand-paint anything, it was a completely dead industry. So we built a sustainable business out of a startup, guerrilla-style beginning.

Why hand-painted advertising?
Hand-paint is in your face. It’s exciting. Being high up on buildings and painting on rigs, I thought it was the coolest thing in the world. Now we’re working on 400 of these projects a year.

When did you start using Google Apps?
Colossal has been using Gmail as our corporate email platform for about 10 years and in around 2008, we began to use Google Apps.

What made you choose Google Apps?
From a logistical standpoint, it made the most sense. We’re physically all over the place. We all work from different locations (offices in New York, co-workers in California, painters working out in the field across the globe) and needed a solid solution for communication and information exchange. Apps makes it easy to share concepts and ideas.

Which apps do you use most and why?
Google Drive is super helpful for Colossal. It helps keep all projects organized and managed. It’s also nice having a sharing tool to use that can be kept private.

We also use Sheets, Forms, Hangouts and Docs. From the shop perspective, Sheets is a great web-based solution that helps us create database systems for organizing, compiling and calculating job information during pre-production. Sheets also helps us deliver accurate, up-to-date information to our crew and clients who are in several locations around the city on any given day. Forms let us collect feedback from the field and gather Peer Evaluations and End-of-Job details.

How has Google Apps changed the way you work?
As Colossal has grown as a company, communication has become harder because it’s not always face to face. Google Apps has made communicating from anywhere more streamlined and efficient. The flexibility to have instant, easy access to everything we need to get the job done — whether we’re on site for a paint job or in the office across the country — from colleagues we’re collaborating with has helped us scale. When you work outdoors and wrestle with the elements, anything can happen when you least expect it. Google Apps brings all of our information to us wherever we are, whenever we need it. It’s also great that we’re able to go back and find things from eight years ago and look at it. It’s like a treasure trove of memories that travels with you.

Easily prepare financial statements with a new Google Sheets template from Xero

Financial statements are a crucial means by which businesses report their profits, losses, assets, and expenditures. Today, with accounting software company Xero, we’re making it easier for organizations to create financial statements in Google Sheets on the web and mobile.

Simply access the Financial statements template from the Sheets homescreen, and get started by entering and categorizing your business transactions. The template will automatically update charts and graphs illustrating your company’s sales, expenses, revenue, and more. For more information, check out this video.


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

More Information
Help Center: Docs, Sheets, and Slides templates
Video: Financial Statements template | Xero

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

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

Top UK CIO explains how to create a 5-star digital hotel experience

Posted by Chris Hewertson, CTO of glh

Editor's note: Today’s post is from Chris Hewertson, CTO of glh, the largest owner-operator hotel company in London with over 5,000 rooms throughout London as well as two locations in Malaysia. Chris was recently named “disruptive player in the crowded hotels market” in the CIO top 100 list. Here, he shares his secrets to success.

In 2013, we launched the world’s fastest hotel wi-fi and put our focus on digital. We had big ideas to transform our business, and we knew we couldn’t do it alone.

We’re always looking for new and innovative technology solutions that can help us deliver the best guest-centred experience in hospitality. Hosted services and real-time responses are becoming more and more of a basic customer expectation in other industries so we thought, why not hotels? We worked with implementation partner Cloudreach to adopt Google Apps as our fully integrated, enterprise-wide cloud collaboration and storage solution.

Let product enthusiasts within your teams help usher a smooth adoption

With over 33 hotels, more than 1000 users and nearly 4 million files, how were we going to move everything and everyone onto Google Apps for Work? The answer was obvious – Jedis.

Well, not Jedis exactly, but pretty close. Our nominated Google Guides were a group of 65 champions across all our locations and departments – from night managers to head housekeepers – who helped kick-start our Google Apps for Work adoption. Their support and enthusiasm for the tools meant we could truly bring Google Apps for Work into every part of our business.

Not only did they help us cut down old and unused data as part of the migration process (we have now almost halved our original 3 million files), they encouraged everyone to use the tools for creative solutions. This is a great example of how a user led change approach can lead to high levels of engagement and adoption while minimising the need for a traditional data migration.

Find creative ways to use new tools to improve customer experience

At glh, we take guest complaints seriously and try to accommodate each request as much as we can. At our biggest hotel, room moves and changes happen daily. Guests move rooms to be closer to their travelling party, away from their boss (yes, really) or even to avoid odd numbers.

Before Google, this would cause major disruption across a number of teams from Housekeeping to Concierge. Now, all teams can see and edit real-time room changes in Sheets, and housekeepers can even use it on their mobiles. As a result, we’ve significantly minimized delays, confusion and complaints.

From internal invites to office polls, Forms has been a welcome addition to the working lives of all of us at glh. Now we have a form that allows staff to check out a guest from anywhere in the hotel in seconds. No more printed paper that was popped into a box at reception.


Invest big savings from new technology tools into workplace improvements

Trans-atlantic Hangout conversations have led to a 42% reduction in conference call charges. Hourly printouts of various logs and reports of over 1,000 pages are now shareable digital Docs that are securely stored on Drive. The logs are updated in real time and available on any device.

It’s just over a year since we introduced Google Apps for Work, and in that time we’ve made so many apps-based ideas a reality – like our Manager of the Month initiative, where everyone votes using a Form.

Our Google Guides, who were so central to our training and awareness a year ago, are still coming up with new suggestions all the time – it’s amazing how creative people can be.

Introducing the Google Sheets API v4: Transferring data from a SQL database to a Sheet

Posted by Wesley Chun (@wescpy), Developer Advocate, Google Apps

At Google I/O 2016, we launched a new Google Sheets API—click hereto watch the entire announcement. The updated API includes many new features that weren’t available in previous versions, including access to functionality found in the Sheets desktop and mobile user interfaces. My latest DevBytevideo shows developers how to get data into and out of a Google Sheet programmatically, walking through a simple script that reads rows out of a relational database and transferring the data to a brand new Google Sheet.

Let’s take a sneak peek of the code covered in the video. Assuming that SHEETS has been established as the API service endpoint, SHEET_ID is the ID of the Sheet to write to, and datais an array with all the database rows, this is the only call developers need to make to write that raw data into the Sheet:


SHEETS.spreadsheets().values().update(spreadsheetId=SHEET_ID,
    range='A1', body=data, valueInputOption='RAW').execute()
Reading rows out of a Sheet is even easier. With SHEETS and SHEET_ID again, this is all you need to read and display those rows: 
rows = SHEETS.spreadsheets().values().get(spreadsheetId=SHEET_ID,
    range='Sheet1').execute().get('values', [])
for row in rows:
    print(row)

If you’re ready to get started, take a look at the Python or other quickstarts in a variety of languages before checking out the DevByte. If you want a deeper dive into the code covered in the video, check out the post at my Python blog. Once you get going with the API, one of the challenges developers face is in constructing the JSON payload to send in API calls—the common operations samples can really help you with this. Finally, if you’re ready to get going with a meatier example, check out our JavaScript codelab where you’ll write a sample Node.js app that manages customer orders for a toy company, the database of which is used in this DevByte, preparing you for the codelab.

We hope all these resources help developers create amazing applications and awesome tools with the new Google Sheets API! Please subscribe to our channel, give us your feedback below, and tell us what topics you would like to see in future episodes!

New editing features in the latest Google Docs and Sheets mobile apps

The latest versions of the Google Docs and Sheets apps for Android and iOS devices include the following new features:

  • Edit content in Print layout view in the Docs Android and iOS apps - Tap the edit pencil when you’re viewing a document in Print layout mode, and you’ll be able to edit that document immediately—without needing to leave Print layout mode. 


  • Add new and edit existing conditional formatting rules in the Sheets Android app - Format cells, rows, and columns to change their formatting (text, background color, and more) if they meet certain conditions, like containing a particular word or number.


Check out the Help Center articles below for more information.

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
Print or change the page setup
Use conditional formatting rules in Google Sheets

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

Introducing the Google Sheets API v4: Transferring data from a SQL database to a Sheet

Posted by Wesley Chun (@wescpy), Developer Advocate, Google Apps

At Google I/O 2016, we launched a new Google Sheets API—click hereto watch the entire announcement. The updated API includes many new features that weren’t available in previous versions, including access to functionality found in the Sheets desktop and mobile user interfaces. My latest DevBytevideo shows developers how to get data into and out of a Google Sheet programmatically, walking through a simple script that reads rows out of a relational database and transferring the data to a brand new Google Sheet.

Let’s take a sneak peek of the code covered in the video. Assuming that SHEETS has been established as the API service endpoint, SHEET_ID is the ID of the Sheet to write to, and datais an array with all the database rows, this is the only call developers need to make to write that raw data into the Sheet:


SHEETS.spreadsheets().values().update(spreadsheetId=SHEET_ID,
    range='A1', body=data, valueInputOption='RAW').execute()
Reading rows out of a Sheet is even easier. With SHEETS and SHEET_ID again, this is all you need to read and display those rows: 
rows = SHEETS.spreadsheets().values().get(spreadsheetId=SHEET_ID,
    range='Sheet1').execute().get('values', [])
for row in rows:
    print(row)

If you’re ready to get started, take a look at the Python or other quickstarts in a variety of languages before checking out the DevByte. If you want a deeper dive into the code covered in the video, check out the post at my Python blog. Once you get going with the API, one of the challenges developers face is in constructing the JSON payload to send in API calls—the common operations samples can really help you with this. Finally, if you’re ready to get going with a meatier example, check out our JavaScript codelab where you’ll write a sample Node.js app that manages customer orders for a toy company, the database of which is used in this DevByte, preparing you for the codelab.

We hope all these resources help developers create amazing applications and awesome tools with the new Google Sheets API! Please subscribe to our channel, give us your feedback below, and tell us what topics you would like to see in future episodes!

Fancy.com grows merchant partnerships with Google Apps and ProsperWorks

Posted by Paul Hsu, Chief Operating Officer at Fancy

Editor's note: Today we hear from Paul Hsu, Chief Operating Officer at Fancy, which uses Google Apps with ProsperWorks CRM to help manage merchant partnerships, gain transparency into sales team activity and optimize their internal processes. Register here to join our Hangout on Air on June 14 at 9 a.m. to learn more about how ProsperWorks, a Google recommended app, can improve your business.

Fancy, the place to discover, engage with and buy goods from top brands, works with trendsetters and tastemakers to curate thousands of goods. Keeping track of new merchant product launches can get complicated, but Google Apps helps ease the coordination process. For example, we often need to schedule last minute meetings to review products that we want to feature at the start of every day. We use Calendar to find meeting times that fit our schedules, Drive to share product launch proposals and Sheets to manage product launch timelines. Since Google Apps are designed to work and integrate smoothly with one another, running these meetings is a seamless process. We’ve used it heavily since we started the company, and the tools have been vital to our productivity and growth.

Growing with Google

With a quickly growing merchant partnership base, we’ve found it increasingly important to keep track of all potential vendors and new interactions. Working with thousands of merchants and even more products, we needed a CRM solution to help scale this part of our business.

Since we were already using Gmail, Calendar, Sheets, Contacts and Drive for most of our operations, we saw ProsperWorks as an effective CRM solution, given how integrated it is with Google’s entire ecosystem of apps.

ProsperWorks with Gmail and Calendar

After we integrated the ProsperWorks Chrome extension — which only took a few short hours — our brand development team began using it immediately. They used ProsperWorks to track communications and interactions with merchants in Gmail and identify items that required follow-up. We saw an increase in our team’s productivity and growth in our brand partner network that we directly attributed to this integration.

With easy-to-use and intuitive tools from ProsperWorks, we experienced a significant increase in the number of merchant partnership deals closed due to the ability to better track customers and share real-time information that helped us close deals.

ProsperWorks with Drive and Sheets

In addition to the benefits for our brand development team, our executive team gained tremendous insight through ProsperWorks reporting capabilities, which work perfectly with Sheets. ProsperWorks' integration with Sheets allowed our brand development team to simply aggregate, organize and visualize our sales in a single dashboard. This gave us immediate access to important insights, such as those gleaned from comparing pipelines by stage, opportunity assessments, customer types, team workload, monthly team progress and even the status of our leads. We were able to get a bird’s eye view of all our sales pipelines without leaving Google Apps.

Using ProsperWorks with Drive gave us insight into product category gaps that we weren’t pursuing and showed us categories that had more partners than we needed. With ProsperWorks, we were able to easily identify these areas and refine our focus to develop partnerships that would expand our reach into new categories while reducing time spent on categories we had already built out.

Optimizing our brand management team with ProsperWorks and Google Apps for Work

On the ground level, our brand management team used ProsperWorks as a way to communicate, manage workflow, manage and assign tasks, share documents and more. Our brand development team has thousands of interactions daily across Gmail, Calendar and Hangouts, and it’s really helpful that on ProsperWorks, the profiles and status of each lead are automatically updated so that every email exchange, event and file is easily accessible by any team member.

Using Google Apps alongside ProsperWorks has helped us optimize the processes of our brand development team and make better decisions faster, which definitely gives us an edge over our competition.