The 7 Best Google Sheet Add-Ons for Security Professionals
Depending on the day and the data, excel documents and google sheets can either be your best friend or your greatest enemy. Either way, there is often a lot of ctrl+shift+PageUp, ctrl+F, ctrl+X, ctrl+V, and probably a lot of ctrl+Z’s happening.
But as the masters in making the boring stuff less mind-numbing, we’ve compiled a list of the best Google Sheet add-ons that will simplify and speed up the process of creating awesome spreadsheets. These tools will help you dazzle your coworkers with your camera inventory reports, sync various documents together, and auto fill data like no one has ever seen before.
Sheetgo: Build Complex Workflows Across Documents
Tired of updating spreadsheets? Sheetgo let’s you consolidate data from multiple google sheets and/or excel documents into one master spreadsheet with the click of a button. Utilize their free pre-built templates or work with their team of excel wizards to develop a custom workflow and dashboard. It’s the perfect tool for businesses looking to:
- Reduce the amount of time spent on data management
- Streamline their processes using automated workflows
- Visually communicate data trends on comprehensive dashboards
Awesome Table: Automate and Create Interactive Dashboards Using Raw Data
If your colleagues tend to get that glazed look in their eyes every time you talk about your VMS, Awesome Table can help you to share your insights in a more visual and interactive format.
Whether it’s a list of health monitoring events, a camera inventory list, a support requests list or a list of camera snapshots, Awesome Table allows you to instantly turn your raw data into pie charts, word clouds, or tables to help you and your team better understand it. that show off the top five or ten results.
Have data you want to share far and wide? This Google Sheet add-on can turn your spreadsheet data into dynamic web formats!
Document Studio: Automate Document Creation Using Templates and Data Tags
Document Studio is the mail-merge of document creation. This free web-based app enables you to automatically create documents using templates with data tags. Auto fill data from a Google Form, Google Sheet or csv into a pre-existing Google Doc, Google Sheet or Google Slide template to streamline any consistent updates or communications you create.
Document Studio is the perfect tool for automating regular system updates, customer reports, presentations and even TPS reports.
Hunter: Quickly and Easily Find Contact Email Addresses
Not that you need it but, Hunter will help you up your sleuth game. This Google Sheet add-on allows you to quickly pull the names and email addresses of specific people in a business or organization from their company’s website. Hunter for Google Sheets exposes all the information it finds as rows in a spreadsheet — title, name, email address, social network accounts — and breaks everything down into neat little columns. We don’t need to know what you’re doing with it, we just know it might come in handy.
ChartExpo™: Communicate Your Data Using Custom Charts
Just because we are all too familiar with that blank stare that follows when we talk about camera hardware, here’s another data visualization tool for you. ChartExpo™ helps you create custom and fully integrated charts. Easily track security vulnerabilities using a map chart or analyze network needs and issues in a comparison chart. Explaining what it is you do all day has never been easier.
Power Tools: Automate Repetitive Actions With Added Functionality
Power Tools provides more than 30 solutions to improve and add functionality to Google Sheets. It sorts data, removes duplicates, generates numbers and so much more – and presents it in an organized way. All the available tools are easily divided into 10 groups based on their use.
Advanced Find and Replace: Exactly What It Sounds Like
When your list of camera and server names is a mile long, a good ‘find and replace’ function can bring you more joy and comfort than even man’s best friend. Well Advanced Find & Replace takes those warm and fuzzy feelings to the next level, allowing you to search through values, formulas, notes, and even hyperlinks, find what you are looking for and replace it with something new.
In the end, Advanced Find & Replace will save you time and avoid confusion when replacing text in several places at once.
There’s a lot to be said for doing things the old fashioned way. By nature, many of us security and surveillance experts are creatures of habit.
But, take it from us, you are meant for bigger, less boring things. These tools can help you save time, communicate more effectively, as well as identify and solve problems more easily.
While not all add-ons are created equal, the ones we featured here are worth looking into if you value productivity and/or peace of mind.