Ocado is the world’s largest online-only grocery store. But Ocado isn’t your typical corner grocery store. For one thing, there’s no corner as we’re an online-only grocery retailer reaching British households, and now with a fast-growing non-food business alongside. Our customers shop online using our award-winning webshop or mobile apps and then their orders are picked and packed in one of our huge automated warehouses, the largest of their kind in the world; hours later, our vans deliver to their kitchens in one-hour delivery slots.

Google Workspace allows us to do things our way, wherever and whenever we want. Our staff use Gmail, Google Calendar and Google Drive to stay on top of their day to day work, and Google+ is helping our teams stay in touch, share information and build local communities. Ultimately, all of these tools help to make sure our customers get the groceries they order, on time and in the best possible condition.

But we didn’t stop there. We looked at other ways we could use Google’s technology to help us run our business and started using Google App Engine for building internal applications. For example, we used App Engine to create a new version of our “Where’s My Order” application, which our customers will soon be using to find out where their orders are within our production cycle. Once their order is on the road, the integration with Google Maps allows them to see exactly where their delivery van is. So we’re taking what used to be a chore, grocery shopping, and making it a simple experience that you can do from the convenience of your own home, or wherever you may be.

Our most recent project was on Google Compute Engine. Within our warehouses there are certain tasks that are repetitive and arduous for humans to do, like picking heavy six packs of bottled water into customer orders. So our robotics team is developing solutions that use robots to automate these sorts of tasks and thus release staff for other more important work. But these robots need sophisticated 3D vision systems to enable them to see what they are doing. These are very computationally intensive applications and by providing the instantly flexible and scalable computing power to crunch all those numbers, Compute Engine provided the perfect solution. And, we are already using the cloud to store and process some of the huge volumes of data that our business spits out every minute.

But with an eye to future growth and international expansion, we have plans to use Compute Engine and Cloud Storage to move other parts of our production systems to the cloud. So walk into an Ocado warehouse in the future and you might run into a robot if you’re not careful. Like I said, we’re not your typical corner grocery store.

*Google Workspace was formerly known as G Suite

We recently announced the general availability of Connected Sheets, which brings you the power and scale of a BigQuery data warehouse in the familiar context of Google Sheets. With Connected Sheets, you can analyze billions of rows and petabytes of data in Sheets without specialized knowledge of computer languages like SQL. This makes it easy for anyone, not just data analysts, to apply pivot tables, charts, and formulas to massive datasets and unlock insights.

Our customers use Connected Sheets to enable data-driven decision-making across their organizations. We’ve heard many stories about how Connected Sheets has enabled them to achieve operational efficiencies and new ways of unlocking the power of their data; we’d like to share a few here.

Operate with agility

Now more than ever, it’s critical for organizations to react with flexibility and agility to new realities. Connected Sheets helps organizations harness and collaborate on massive amounts of data, making it easier to understand and quickly respond to today’s dynamic landscape. 

The United Nations Office for Project Services (UNOPS) helps the UN and its partners deliver peace and security, humanitarian, and development solutions. As COVID-19 emerged, UNOPS used Connected Sheets to help coordinate a swift global response. Says Tushar Dighe, Chief Information Officer at UNOPS, “When the COVID-19 pandemic started, we needed to quickly assess the status of our operational capacity in order to assist governments with the response. We used a Connected Sheet with data from our BigQuery data warehouse combined with manual status inputs on the same Sheet, where colleagues in more than 80 countries were able to collaboratively provide inputs. The results in the form of pivots and charts were instantly available live. It took less than three hours to design and implement the solution, and we had status information from more than 80 countries within the first 24 hours.”

Improve business and financial reporting

Reports and dashboards displaying business metrics, like revenue figures or operational KPIs, play a critical role in organizations. These reports help sales teams track performance, enable finance teams to make projections, and provide business leaders with a picture of their organization’s health. Especially now, as businesses adapt their planning to reflect the new normal and employees remain dispersed, it’s doubly important that teams can quickly access and collaborate on business and financial dashboards, from wherever they are. But building and maintaining these reports can be time consuming and error-prone, and requests for changes or new views result in manual work for data analysts. All of this just extends the time to insight and action. 

Connected Sheets helps automate report creation, while maintaining a single source of truth for data in BigQuery. The live connection between BigQuery and Sheets also means that data stays fresh, minimizing the risk that people make decisions based on outdated information and avoiding the data integrity risks of manual data pulls. 

Says Alexander Danilowicz, a Software Engineer at data connectivity company LiveRamp, “Our Finance team uses Connected Sheets to automate reports that are shared with other stakeholders to run the business. This enables our business partners to analyze and create pivot tables on massive datasets, which is not possible in a traditional spreadsheet.”

“Now that it’s all integrated, there’s no human error involved. Changes can be made at the click of a button, resulting in 10 hours saved per month,” he adds.

Track product adoption

It’s important for teams across the business to understand customer adoption of products and services, whether it’s the product team tracking usage of a newly released feature or the support team trying to anticipate incoming service requests. Similarly,  IT teams need to analyze adoption of an organization’s internal applications and systems, so they know what tools employees are using and how they are being used. But product adoption datasets are often too large for traditional spreadsheets to handle, and new data is continuously being added. 

Connected Sheets can provide teams access to large, powerful, and up-to-date usage datasets, in the familiar Sheets interface. PwC, a global professional services organization, uses Connected Sheets as part of its efforts to make technology and data more accessible across its workforce. One way PwC uses Connected Sheets is to monitor and analyze internal adoption of tools like G Suite. 

Says Peter Van Nieuwerburgh, Global Change Manager at PwC, “If you look at our own adoption dashboarding, it’s more than three terabytes of data—good luck putting that in any spreadsheet. With Connected Sheets, we’re not really pulling the data into the spreadsheet, rather it lives in the database where it belongs. The ability to go and so easily analyze and visualize the data is really powerful.”

We hope Connected Sheets helps to scale data-driven decision making at your organization, by making powerful data easily accessible across your sales, finance, product, and IT teams.

In 1984, Mario Maio set up a small business manufacturing electrical transformers in his Johannesburg garage. Over the next two decades, the ACDC Dynamics company he created came to dominate manufacturing, import, and distribution in South Africa’s electrical goods sector. Then, in 2007, Mario’s son, Ricardo Maio, founded a retail arm to the business, ACDC Express. Today ACDC Express is South Africa’s largest electrical retail franchise, with 29 franchise stores across the country. Eight of those franchises joined in 2017 alone, and ACDC Express is experiencing quarter-on-quarter growth of 28% per year.

Rapid expansion increases the demands on the ACDC Express central administration, which provides each franchise with IT support and a full suite of marketing, operational, and bookkeeping functions. So when email server downtime became a frequent problem, Ricardo and his team chose G Suite to transform the way the franchise worked.

“We lost revenue when our email servers went down. When I researched Google’s SLA of 99.9% uptime and experimented with G Suite on my private Gmail account, I could see the difference this technology could create.”

Ricardo Maio, CEO, ACDC Express

“On consecutive occasions, our entire email server went down,” says Ricardo Maio, CEO at ACDC Express. “It would take more than one or two days to bring it back up. We had already highlighted software cost overhead as a potential thing to reduce, so when that happened several times within a short period, we knew it was time to make a change.”

Building a better franchise

Franchise businesses undergoing rapid expansion must respond quickly to the demands of new stores. At ACDC Express, 33 staff run the national franchise, delivering core services and support to 29 franchises across the country. Key tasks, such as updating the operations manual, were hampered by a reliance on paper forms and mail services, while email servers experienced repeat failures, which compromised communication. By implementing new, cloud-based productivity tools, ACDC Express looked to cut down on slow and expensive practises, and deliver an agile, reliable online communications platform.

To do that, ACDC Express migrated its franchise to G Suite with Opennetworks. “We lost revenue when our email servers went down,” says Ricardo. “When I researched Google’s SLA of 99.9% uptime and experimented with G Suite on my private Gmail account, I could see the difference this technology could create.”

Since moving to Gmail, ACDC Express reports that the problem of email server downtime “is no longer existent for us,” while with Google Drive, versioning problems have been resolved. Using surveys on Google Forms, ACDC Express quickly and easily collects data from stores and customers—whether they are in stores or on the road—and populates Google Sheets with the information.

“Our operations manual is a binding document, and it’s a living document that gets regularly updated. In the past, we would struggle to track which franchise had which version. With Google Drive, we can be sure that everyone is looking at the right one.”

Ricardo Maio, CEO, ACDC Express

With Google Data Studio, the managing team then consolidates that data on dashboards, creating snapshots of performance, complete with averages and simple comparisons, which make it easy to spot issues and outliers in need of attention. Individual businesses that do require help are then contacted over Google Hangouts Meet to assess what they need, part of a culture of sharing expertise, which Ricardo sees as key to the franchise mode.

“As a franchise, sharing knowledge is as important as maintaining control,” he says. “If there’s a new procedure or system that worked in one store, we can immediately update our manuals and documentation so that everyone has access to it. That’s been fantastic.”

“Our operations manual is a binding document, and it’s a living document, which gets regularly updated,” says Ricardo. “In the past, we would struggle to track which franchise had which version, and every time we had to make a change we would print out a version and send it to stores through an unreliable postal service. With Google Drive, we can be sure that everyone is looking at the right one.”

Remote training, rapid migration

Rolling out new IT tools across a franchise is often expensive, demanding extensive travel and numerous training sessions, which often repeat the same material. Instead, ACDC Express set up training on Google Hangouts that staff could drop into at their convenience, creating a cost-effective training schedule, which meant individual stores could plan their own learning process.

“When we moved to G Suite, we did it all at once, with every employee changing at the same time. We took a band-aid approach, switching to the new tools as rapidly as possible. After six months of training, there have been no reported problems with G Suite at all.”

Ricardo Maio, CEO, ACDC Express

“The whole benefit of franchising is that you can learn from your peers,” says Ricardo. “When we moved to G Suite, we did it all at once, with every employee changing at the same time. We took a band-aid approach, switching to the new tools as rapidly as possible. After six months of training, there have been no reported problems with G Suite at all.”

More mobile, more reliable

Today, ACDC Express operates 240 Google accounts, and information from the franchises’ marketing systems, research, operations, and accounting is fed back automatically to Google Sheets and Google Dashboard at the headquarters in Edenvale, Gauteng. By Ricardo’s estimation, the administrative team is now so effective with G Suite tools, it can achieve twice as much as it could without them.

Now, ACDC Express is looking to use Google Chromebooks in a new web-based point-of-sale system, and considering moving its ERP onto Google Cloud Platform for greater stability, in another project with Opennetworks.

“We’ve developed an in-house point of sale system that’s web-based and can use a functional touchscreen,” adds Ricardo. “We’re looking at rolling that out with Google Chromebooks. We really like how straightforward and simple the Google Chrome devices are, and because we’ve taken a lot of infrastructure into the cloud, we no longer actually need physical machines on our counters. We can work anywhere. That’s something that applies from our head office right down to our smallest franchise store.”

The global-wide interruptions of the coronavirus pandemic provided the opportunity for businesses to take a closer look at how we work, learn, live, and consume. With work stoppages and quarantine orders in place, carbon emissions and pollution levels saw significant reductions, highlighting how business and environmental sustainability are linked. As the world returns to work, businesses need to adjust to the new reality and make decisions that will ensure the continuing sustainability of our planet. 

Understanding the need for sustainability

A recent Google-commissioned study by IDG, based on a global survey of more than 2,000 IT decision-makers, illustrated the importance of sustainability for organizations’ IT departments while also revealing that significant work is needed before businesses meet their sustainability goals. The good news is that ninety percent say that sustainability is a priority of their IT department and as more organizations consider the benefits of digital transformation and cloud migration, 75% report that sustainability is a “must-have” or “major consideration” when evaluating cloud providers.LEARN MOREIT Leaders Research ReportWhat are the biggest IT priorities in 2021? Explore insights from a survey of 2,000 Senior IT leaders conducted by IDG, in collaboration with Google Cloud.

Businesses face both internal and external pressures to reform their practices and processes to meet new targets around sustainability, and IT leaders have an important role to play in that effort. Specifically, 54% said sustainability initiatives were important to their companies because of corporate social responsibility, 46% said it was because of environmental regulations and mandates, and 40% said it was due to the climate change impacts.

The research also examined the areas where IT leaders are looking to make positive changes for sustainability in their organizations. Not surprisingly, 62% said in their IT infrastructure and data centers, 53% their supply chain, and 46% in their facilities and building operations.

Facing the obstacles to progress

However, for many organizations, behaviors lag intent. Only 67% actually have environmental sustainability targets in place. The gap between behavior and intent widens when looking at digitally forward vs. digitally conservative organizations. For the purposes of the study, digitally forward companies were defined as either digital natives or those with a digital strategy and implementation in place. Digitally conservative organizations either have no strategy in place, or are in the process of considering or planning digital transformations, but haven’t reached the stage of implementation. 

The study revealed that digital natives embracing cloud solutions were more likely than more conservative organizations to demonstrate a commitment to sustainability. Twenty percent of digital natives are implementing IT initiatives to reduce emissions to become more environmentally sustainable, while only 10% of digitally conservative organizations have done so. 

When considering the effects of the COVID-10 pandemic, 20% of respondents from digital conservative organizations delayed or cancelled initiatives around reducing emissions to become more environmentally sustainable compared to only 12% for digitally forward respondents. 

Sustainability is in our DNA

Sustainability has been a core value for Google since our inception. We were the first major company to become carbon neutral in 2007 and we were the first major company to match our energy use with 100 percent renewable energy in 2017 — and have continued to do so every year since. We are proud to operate the cleanest global cloud in the industry, and we’re the world’s largest corporate purchaser of renewable energy. It is this commitment that makes Google the leading choice for organizations with sustainability initiatives. 

To learn more about the IDG findings and how IT leaders are implementing sustainable solutions, download the full report.

Interested in how Google Cloud’s commitment to providing sustainable solutions can help IT leaders and their organizations meet their own sustainability targets?

Google is focused on enhancing our products to help billions of people take action to reduce their environmental footprint.

• Google creates tools and invests in technology that will foster a carbon-free future for everyone and reduce carbon footprints.
• Google Cloud is the only major cloud provider to purchase enough renewable energy to cover our entire operations, enabling us to operate the cleanest cloud in the industry.
• When running on Google Cloud, an organization’s usage is net carbon neutral, and the electricity used to power workloads is matched 100% with renewable energy.

Looking for more? Check out our blog that introduces the Google Cloud Region Picker, which helps organizations choose a Google Cloud region based on carbon footprint, price, and latency.