Work Smart with Google Sheets

Work Smart with Google Sheets

Our Work Smart blog series continues with Google Sheets. The aim with this series is to help companies to work smarter by getting the most out of the cloud computing power that’s already available to them.

With so many updates and additional features being added to G Suite (formerly known as Google Apps for Work), it can be easy to overlook some simple use-cases that might just make your work day a whole lot simpler. So let’s see what’s possible…

Financial Reports

Data analyst teams can work together from a single Google Sheets spreadsheet to pull together their data on upcoming investment opportunities. Each analyst can add data to their own protected cells to make sure there are never any oversights or mistakes made. Keeping everything together in one spreadsheet makes it easy to stay on track and access all the necessary information for meetings, which are carried out via Hangouts Meet so that everyone can discuss their recent findings and plan the next steps.


    • Save time by working within one sheet that can be accessed and updated any time.
    • Avoid overloaded inboxes with multiple file versions.
  • Provide live feedback through Hangouts Meet and everyone can see live updates during the meeting.

Manage Resources

If a production company has a limited amount of lights, cameras and (action!) other equipment, they can easily keep track of them and process requests within Google Sheets. Project managers can fill out a pre-defined Google Form that automatically updates the spreadsheet with their requirements. Once the equipment manager has matched the appropriate resources to the projects, they can then notify the project manager that their equipment is ready for use by creating a Google Calendar invitation for the required dates.


    • Managers can access and update requests from anywhere
  • Managers send reminders and notifications quickly, updating everyone at once.

Manage Deliveries

Supermarket warehouse staff can record all deliveries in their inventory within one Google Sheet. Whenever deliveries are made, they can notify the relevant department manager via a Hangouts Chat message, who can then open the same Google Sheet from their mobile device to see exactly what stock has come in, and when they can expect the next to arrive.


    • The inventory management process is streamlined.
    • Perishable items can be marked so they are managed immediately, and avoid waste.
  • Google Sheets can notify departments automatically when inventory is ready.

Manage Schedules

Factory managers create and share a Google Sheets spreadsheet to keep track of all work rotas and schedules with employees. Whenever the rota needs changing due to holidays or overtime, the manager updates the spreadsheet and notifications are sent out to all relevant staff members automatically. Formulas and clear formatting display the different hours worked by day or by week for each employee while workers can keep track of their schedules by viewing the spreadsheet on their mobile devices. They can then request any shift swaps or holidays by leaving comments and tagging co-workers within the relevant cells of the spreadsheet.


    • All workers have access to the most up-to-date rota at all times.
  • Changes to the schedule are simple and fast to make, allowing employees to contribute and help find the right work/life balance for the whole team.


If you’re interested in learning more about how to get the most out of Google Sheets or you’d just like to find out a bit more about G Suite and what it could offer, please don’t hesitate to get in touch via We would be delighted to have a chat about how we could help.