Tag Archives: G Suite

English county council saves millions switching to G Suite and Chromebooks

A day in the life of an employee at Northumberland County Council in northern England involves everything from running schools, repairing roads or literally putting out fires. It’s work that never stops and that stretches across a rural area the size of Greater London with 330,000 citizens and three million sheep.

Two years ago, the Northumberland IT team started to notice strain in their service infrastructure which connects 380 locations across the region, and recent budget cuts made that system feel increasingly unworkable.

"We had a very big legacy setup that was costing us a fortune in licensing and devices,” says Neil Arnold, Chief Information Officer at Northumberland County Council. “We decided to bring people together in a central hub to make teams more agile."

Creating G Suite champions

After evaluation, Arnold and his team chose G Suite for its functionality and flexibility. The team relied on Netpremacy, a Google Cloud partner, to train 300 staff members to educate colleagues on how to use G Suite. Within months, 5,500 corporate users and 11,500 schools users had been set up with G Suite accounts. “Without the support of Netpremacy, we wouldn't have been able to implement as rapidly as we did,” says Arnold. “They recognised the cultural challenges. There was skepticism at first, but users really took the tools to heart when they could see the benefits.”

From different locations across the region, staff began working collaboratively on Docs and Sheets and inviting others to join. The team saved money by switching to Chromebooks and Arnold and his colleagues started using Hangouts to join meetings to stay synced on daily work.

Even firefighters, who were reluctant to try out Hangouts at first, started using it regularly. “Firefighters now use Hangouts at the scene of fires to communicate with central command, monitor the fire, and decide how many vehicles they need,” says Arnold. “The chief fire officer doesn't have to get in his car and drive out to the scene to help — he can do it all from wherever he is.”

Firefighters use Hangouts at the scene of fires to communicate to central command, so the chief fire officer doesn't have to drive to the scene. Neil Arnold
CIO, Northumberland County Council

Saving big by going cloud-first

Arnold expects switching to Chromebooks will help Northumberland County Council save close to £2.5 million on licensing and hardware, without sacrificing data security since Chromebooks have multiple protection layers.

The next step for Arnold and his team is to bring G Suite to the classroom. “We've got a lot of schools using Google Classroom successfully,” he says, “and we want to roll G Suite out to more schools. It’ll be a big efficiency for them, because many have small file servers on site, that they manage themselves or pay a third-party to manage. Drive will help them decommission that.”

Meanwhile, outdated exchange and file servers are being closed down across the council as data is seamlessly transferred to Google Cloud. The new central office for the county is set to open in 2019, and Arnold does not plan to have a datacenter at the new building: “That footprint’s going to reduce over the next three years to virtually nothing.” 

“I've been working in IT for over 30 years and this has been one of the most successful and satisfying projects I've ever been involved in,” says Arnold. “We’ve achieved more than we expected and using G Suite has been a tremendous catalyst for change.”

Source: Google Chrome


English county council saves millions switching to G Suite and Chromebooks

A day in the life of an employee at Northumberland County Council in northern England involves everything from running schools, repairing roads or literally putting out fires. It’s work that never stops and that stretches across a rural area the size of Greater London with 330,000 citizens and three million sheep.

Two years ago, the Northumberland IT team started to notice strain in their service infrastructure which connects 380 locations across the region, and recent budget cuts made that system feel increasingly unworkable.

"We had a very big legacy setup that was costing us a fortune in licensing and devices,” says Neil Arnold, Chief Information Officer at Northumberland County Council. “We decided to bring people together in a central hub to make teams more agile."

Creating G Suite champions

After evaluation, Arnold and his team chose G Suite for its functionality and flexibility. The team relied on Netpremacy, a Google Cloud partner, to train 300 staff members to educate colleagues on how to use G Suite. Within months, 5,500 corporate users and 11,500 schools users had been set up with G Suite accounts. “Without the support of Netpremacy, we wouldn't have been able to implement as rapidly as we did,” says Arnold. “They recognised the cultural challenges. There was skepticism at first, but users really took the tools to heart when they could see the benefits.”

From different locations across the region, staff began working collaboratively on Docs and Sheets and inviting others to join. The team saved money by switching to Chromebooks and Arnold and his colleagues started using Hangouts to join meetings to stay synced on daily work.

Even firefighters, who were reluctant to try out Hangouts at first, started using it regularly. “Firefighters now use Hangouts at the scene of fires to communicate with central command, monitor the fire, and decide how many vehicles they need,” says Arnold. “The chief fire officer doesn't have to get in his car and drive out to the scene to help — he can do it all from wherever he is.”

Firefighters use Hangouts at the scene of fires to communicate to central command, so the chief fire officer doesn't have to drive to the scene. Neil Arnold CIO, Northumberland County Council

Saving big by going cloud-first

Arnold expects switching to Chromebooks will help Northumberland County Council save close to £2.5 million on licensing and hardware, without sacrificing data security since Chromebooks have multiple protection layers.

The next step for Arnold and his team is to bring G Suite to the classroom. “We've got a lot of schools using Google Classroom successfully,” he says, “and we want to roll G Suite out to more schools. It’ll be a big efficiency for them, because many have small file servers on site, that they manage themselves or pay a third-party to manage. Drive will help them decommission that.”

Meanwhile, outdated exchange and file servers are being closed down across the council as data is seamlessly transferred to Google Cloud. The new central office for the county is set to open in 2019, and Arnold does not plan to have a datacenter at the new building: “That footprint’s going to reduce over the next three years to virtually nothing.” 

“I've been working in IT for over 30 years and this has been one of the most successful and satisfying projects I've ever been involved in,” says Arnold. “We’ve achieved more than we expected and using G Suite has been a tremendous catalyst for change.”

Sell smarter with ProsperWorks for G Suite

If you want to scale your business, you’ve likely invested in a CRM solution to manage sales workflows and speed up data-driven decision-making - but, CRMs have become a clunky epicenter for team collaboration. You need actionable data insights to drive deals forward, which often require a CRM tool that integrates with the apps you use every day. ProsperWorks for G Suite can help:

With ProsperWorks for G Suite, it’s simple to integrate your CRM with the tools you already use, like Gmail, Calendar and Docs. You can:

  • Access everything in one place—forget toggling back and forth between your CRM and G Suite applications
  • Automatically sync Google Contacts in ProsperWorks
  • View and track sales activity in real-time directly within Gmail
  • Export data from Sheets to ProsperWorks and get insights instantly without manual data entry
  • Create custom dashboards, reports and charts using the Google Sheets integration in the ProsperWorks CRM Custom Report Builder

Why UrbanVolt chose ProsperWorks for G Suite

UrbanVolt, an energy-saving firm based in Dublin, Ireland, installs LED lighting for businesses at no upfront cost (“light as a service”). UrbanVolt's Light as a Service® solves the problem of companies requiring capital to install LED lighting. This model allowed the company to scale rapidly, but it also meant managing a higher volume of inbound leads. “We needed a solution that would allow us to scale our inbounds and deal flow with ease,” says Edel Kennedy, Head of Marketing at UrbanVolt.

The UrbanVolt team opted for ProsperWorks for its intuitive design and its seamless integration with G Suite. “ProsperWorks was the clear choice for our team. There was no learning curve since it worked with G Suite, where we spend the majority of our day,” says Kennedy.

Now, UrbanVolt employees save time because they don’t have to toggle between their CRM and spreadsheets to analyze data. Instead, they use G Suite tools like Sheets Add-on for ProsperWorks to view opportunities at various stages in the sales cycle, and create advanced dashboards, reports, charts and graphs collaboratively.

If you want to get started using ProsperWorks for G Suite at your business, sign up for a free webinar on Wednesday, June 21, 2017 at 9 a.m. PT / 12 p.m. ET.

Sell smarter with ProsperWorks for G Suite

If you want to scale your business, you’ve likely invested in a CRM solution to manage sales workflows and speed up data-driven decision-making - but, CRMs have become a clunky epicenter for team collaboration. You need actionable data insights to drive deals forward, which often require a CRM tool that integrates with the apps you use every day. ProsperWorks for G Suite can help:

With ProsperWorks for G Suite, it’s simple to integrate your CRM with the tools you already use, like Gmail, Calendar and Docs. You can:

  • Access everything in one place—forget toggling back and forth between your CRM and G Suite applications
  • Automatically sync Google Contacts in ProsperWorks
  • View and track sales activity in real-time directly within Gmail
  • Export data from Sheets to ProsperWorks and get insights instantly without manual data entry
  • Create custom dashboards, reports and charts using the Google Sheets integration in the ProsperWorks CRM Custom Report Builder

Why UrbanVolt chose ProsperWorks for G Suite

UrbanVolt, an energy-saving firm based in Dublin, Ireland, installs LED lighting for businesses at no upfront cost (“lighting as a service”). This leasing model allowed the company to scale rapidly, but it also meant managing a higher volume of inbound leads. “We needed a solution that would allow us to scale our inbounds and deal flow with ease,” says Edel Kennedy, Head of Marketing at UrbanVolt.

The UrbanVolt team opted for ProsperWorks for its intuitive design and its seamless integration with G Suite. “ProsperWorks was the clear choice for our team. There was no learning curve since it worked with G Suite, where we spend the majority of our day,” says Kennedy.

Now, UrbanVolt employees save time because they don’t have to toggle between their CRM and spreadsheets to analyze data. Instead, they use G Suite tools like Sheets Add-on for ProsperWorks to view opportunities at various stages in the sales cycle, and create advanced dashboards, reports, charts and graphs collaboratively.

If you want to get started using ProsperWorks for G Suite at your business, sign up for a free webinar on Wednesday, June 21, 2017 at 9 a.m. PT / 12 p.m. ET.

Source: Google Cloud


Sell smarter with ProsperWorks for G Suite

If you want to scale your business, you’ve likely invested in a CRM solution to manage sales workflows and speed up data-driven decision-making - but, CRMs have become a clunky epicenter for team collaboration. You need actionable data insights to drive deals forward, which often require a CRM tool that integrates with the apps you use every day. ProsperWorks for G Suite can help:

With ProsperWorks for G Suite, it’s simple to integrate your CRM with the tools you already use, like Gmail, Calendar and Docs. You can:

  • Access everything in one place—forget toggling back and forth between your CRM and G Suite applications
  • Automatically sync Google Contacts in ProsperWorks
  • View and track sales activity in real-time directly within Gmail
  • Export data from Sheets to ProsperWorks and get insights instantly without manual data entry
  • Create custom dashboards, reports and charts using the Google Sheets integration in the ProsperWorks CRM Custom Report Builder

Why UrbanVolt chose ProsperWorks for G Suite

UrbanVolt, an energy-saving firm based in Dublin, Ireland, installs LED lighting for businesses at no upfront cost (“lighting as a service”). This leasing model allowed the company to scale rapidly, but it also meant managing a higher volume of inbound leads. “We needed a solution that would allow us to scale our inbounds and deal flow with ease,” says Edel Kennedy, Head of Marketing at UrbanVolt.

The UrbanVolt team opted for ProsperWorks for its intuitive design and its seamless integration with G Suite. “ProsperWorks was the clear choice for our team. There was no learning curve since it worked with G Suite, where we spend the majority of our day,” says Kennedy.

Now, UrbanVolt employees save time because they don’t have to toggle between their CRM and spreadsheets to analyze data. Instead, they use G Suite tools like Sheets Add-on for ProsperWorks to view opportunities at various stages in the sales cycle, and create advanced dashboards, reports, charts and graphs collaboratively.

If you want to get started using ProsperWorks for G Suite at your business, sign up for a free webinar on Wednesday, June 21, 2017 at 9 a.m. PT / 12 p.m. ET.

Source: Google Cloud


Google I/O session recap: how to build custom apps with App Maker



Every company has workflows and processes that are unique to its business, customers and employees. Often, these are captured manually within large spreadsheets or ad-hoc databases with macros and scripts. But what if they could be turned into custom business apps instead? Apps that provide useful UIs and distinct user roles, while helping to minimize data entry errors and increase productivity?

This year at Google I/O, I shared reasons why businesses should use App Maker—our low-code, application development tool that lets companies quickly build custom apps in G Suite. Check it out here:


And for those who’d like more detail, here is a recap of my presentation.

Closing enterprise “app gaps” with App Maker 

“App gaps” are a reality for most companies, even those that embrace major SaaS products. Think about the edge cases that aren’t addressed with a standard CRM offering like conducting territory planning or tracking asset performance.

We experienced similar gaps at Google. A few years ago, our HR recruiters were overwhelmed with the thousands of monthly interviews that each generated lengthy feedback reports from multiple interviewers. This volume made it difficult for hiring committees to calibrate candidates and make timely decisions, and resulted in delayed responses. To fix this, our IT team decided to build an app by cobbling elements from our own infrastructure.

Over time, more app requests came in from other parts of Google, so we created App Maker. What started as a handful of apps within Google, evolved into nearly 400 internal apps used by thousands. Plus, the majority of these apps were built by non-engineers outside of IT.

Today, App Maker gives software engineers and citizen developers—like business analysts or coding enthusiasts—the ability to quickly build and deploy apps to get around their workflow challenges.

How does it work? 

App Maker makes it easy to build apps in days, not months, because of its easy data-binding and drag-and-drop UI design. You can also integrate your apps with various data sources, Google services or APIs to cover broad legacy assets. Any app you create is also a part of Drive in G Suite so your data never leaves your domain.

Here’s how to build an App Maker app in three steps:
  1. Define your data models, by importing existing Google Sheets to App Maker, connecting to Google Cloud SQL instances, or manually defining custom objects field by field.
  2. Build your UI by adding pre-built components like data entry forms, report templates and easily create event triggers and application flows. 
  3. Optionally, add open source HTML, CSS and JavaScript to run on the client UI and on the app server, implementing custom functionality that’s not provided out-of-the-box.
App Maker is currently in Early Adopter Program (EAP) for every G Suite Business customer. To get started, apply here.

Ideas to get started 

By now you’re probably wondering what you can build. Well, based on our customers’ experience, here are some good starting points:
  • If you have a large Sheet with more than a handful of users updating it regularly: Sheets usually have an underlying workflow. An App Maker app will provide a better UI for it—showing the workflow visually, prompting for actions and eliminating data entry errors. 
  • If you perform recurring bulk operations in Calendar or Gmail: Say an employee joins or leaves a department, you can build an App Maker app to generate the appropriate bulk-operations in a few clicks. 
  • If your company is already using Apps Script and BigQuery: This means you’ve already invested in customizing workflows. App Maker can increase the velocity of developing custom apps.
Go build your apps with App Maker in G Suite—sign up for the EAP today.

Visualize data instantly with machine learning in Google Sheets

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it even easier for you to visualize and share your data, and find insights your teams can act on.

Ask and you shall receive → Sheets can build charts for you

Explore in Sheets, powered by machine learning, helps teams gain insights from data, instantly. Simply ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average sales on Sundays?” and Explore will help you find the answers.  

Now, we’re using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.

Sheets GIF

Instantly sync your data from Sheets → Docs or Slides

Whether you’re preparing a client presentation or sharing sales forecasts, keeping up-to-date data is critical to success, but it can also be time-consuming if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.   

Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.

Sheets bundle - still

Even more Sheets updates

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”  
  • Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
  • Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads
  • More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also support statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”

These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.

Source: Google Cloud


Visualize data instantly with machine learning in Google Sheets

Sorting through rows and rows of data in a spreadsheet can be overwhelming. That’s why today, we’re rolling out new features in Sheets that make it even easier for you to visualize and share your data, and find insights your teams can act on.

Ask and you shall receive → Sheets can build charts for you

Explore in Sheets, powered by machine learning, helps teams gain insights from data, instantly. Simply ask questions—in words, not formulas—to quickly analyze your data. For example, you can ask “what is the distribution of products sold?” or “what are average sales on Sundays?” and Explore will help you find the answers.  

Now, we’re using the same powerful technology in Explore to make visualizing data even more effortless. If you don’t see the chart you need, just ask. Instead of manually building charts, ask Explore to do it by typing in “histogram of 2017 customer ratings” or “bar chart for ice cream sales.” Less time spent building charts means more time acting on new insights.

Sheets GIF

Instantly sync your data from Sheets → Docs or Slides

Whether you’re preparing a client presentation or sharing sales forecasts, keeping up-to-date data is critical to success, but it can also be time-consuming if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.   

Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.

Sheets bundle - still

Even more Sheets updates

We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:

  • Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”  
  • Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
  • Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads
  • More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also support statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”

These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.

Keeping your company data safe with new security updates to Gmail

Keeping company data secure is priority one, and that starts with protecting the tools that your employees use every day. We’re constantly adding security features to help businesses stay ahead of potential threats, and are excited to announce new security features for Gmail customers, including early phishing detection using machine learning, click-time warnings for malicious links, unintended external reply warnings and built-in defenses against new threats.

New machine learning models in Gmail to block phishing

Machine learning helps Gmail block sneaky spam and phishing messages from showing up in your inbox with over 99.9 percent accuracy. This is huge, given that 50-70 percent of messages that Gmail receives are spam. We’re continuing to improve spam detection accuracy with early phishing detection, a dedicated machine learning model that selectively delays messages (less than 0.05 percent of messages on average) to perform rigorous phishing analysis and further protect user data from compromise.

Our detection models integrate with Google Safe Browsing machine learning technologies for finding and flagging phishy and suspicious URLs. These new models combine a variety of techniques such as reputation and similarity analysis on URLs, allowing us to generate new URL click-time warnings for phishing and malware links. As we find new patterns, our models adapt more quickly than manual systems ever could, and get better with time.
Gmail security - still

New warnings for employees to prevent data loss 

When employees are empowered to make the right decisions to protect data, it can improve an enterprise’s security posture. To help with this, Gmail now displays unintended external reply warnings to users to help prevent data loss. Now, if you try to respond to someone outside of your company domain, you’ll receive a quick warning to make sure you intended to send that email. And because Gmail has contextual intelligence, it knows if the recipient is an existing contact or someone you interact with regularly, to avoid displaying warnings unnecessarily.

Gmail Security - GIF

Protecting your business with the latest security advancements

Security threats are constantly evolving and we’re always looking for ways to help people protect their data. With new built-in defenses against ransomware and polymorphic malware, Gmail now blocks millions of additional emails that can harm users. We classify new threats by combining thousands of spam, malware and ransomware signals with attachment heuristics (emails that could be threats based on signals) and sender signatures (already marked malware).

Outside of today’s updates, here are a few other security advancements we’ve made within Gmail to make sure you stay protected:

Whirlpool, PWC and Woolworths are just a few companies that rely on Gmail to securely collaborate. Learn more.

Source: Gmail Blog


Keeping your company data safe with new security updates to Gmail

Keeping company data secure is priority one, and that starts with protecting the tools that your employees use every day. We’re constantly adding security features to help businesses stay ahead of potential threats, and are excited to announce new security features for Gmail customers, including early phishing detection using machine learning, click-time warnings for malicious links, unintended external reply warnings and built-in defenses against new threats.

New machine learning models in Gmail to block phishing

Machine learning helps Gmail block sneaky spam and phishing messages from showing up in your inbox with over 99.9 percent accuracy. This is huge, given that 50-70 percent of messages that Gmail receives are spam. We’re continuing to improve spam detection accuracy with early phishing detection, a dedicated machine learning model that selectively delays messages (less than 0.05 percent of messages on average) to perform rigorous phishing analysis and further protect user data from compromise.

Our detection models integrate with Google Safe Browsing machine learning technologies for finding and flagging phishy and suspicious URLs. These new models combine a variety of techniques such as reputation and similarity analysis on URLs, allowing us to generate new URL click-time warnings for phishing and malware links. As we find new patterns, our models adapt more quickly than manual systems ever could, and get better with time.
Gmail security - still

New warnings for employees to prevent data loss 

When employees are empowered to make the right decisions to protect data, it can improve an enterprise’s security posture. To help with this, Gmail now displays unintended external reply warnings to users to help prevent data loss. Now, if you try to respond to someone outside of your company domain, you’ll receive a quick warning to make sure you intended to send that email. And because Gmail has contextual intelligence, it knows if the recipient is an existing contact or someone you interact with regularly, to avoid displaying warnings unnecessarily.

Gmail Security - GIF

Protecting your business with the latest security advancements

Security threats are constantly evolving and we’re always looking for ways to help people protect their data. With new built-in defenses against ransomware and polymorphic malware, Gmail now blocks millions of additional emails that can harm users. We classify new threats by combining thousands of spam, malware and ransomware signals with attachment heuristics (emails that could be threats based on signals) and sender signatures (already marked malware).

Outside of today’s updates, here are a few other security advancements we’ve made within Gmail to make sure you stay protected:

Whirlpool, PWC and Woolworths are just a few companies that rely on Gmail to securely collaborate. Learn more.