Google’s online collaboration tools were a revolution when working together with colleagues, clients, or providers in the same document.
Undoubtedly, one of its most exciting features was real-time collaboration, which, almost two-decades past, still feels like magic to use.
Google Sheets offered a full-fledged online spreadsheet, taking offline Excel into a new dimension. Sharing with Google Sheets is easy as pie.
You just need a Gmail address, and you instantly get access to a free wide range of collaboration tools such as Google Docs, Google Slides, or Google Sheets.
You can then simply type sheets.new in your browser, and you get a brand new spreadsheet you can begin editing.
Once you’re ready to welcome collaborators, press the prominent Share button on the top right corner, and your sharing experience has just begun.
Google Sheets allows you to control top-level access to your spreadsheet with one or more email addresses.
You can specify whether someone has View or Edit access to your file. If you want to go a bit more into detail, you can protect specific cell ranges or sheets from being edited, and you can do it even at the user level.
This is already great if you want to keep control over people editing what they are not supposed to.
However, if you deal with more private/sensitive data, you may encounter a situation where the available options are not enough since everyone you share access with will be able to see all of the data, no matter what.
Hiding sheets is also not an option if you’re concerned about data privacy since anyone can simply copy your sheet and unhide your tabs easily.
The ideal collaborating experience with Google Sheets happens when you can really make it simple for others to know what to view or edit without navigating them through a workbook with multiple tabs and building a complex network of accesses you then have to manage.
Unfortunately, GSheets doesn’t currently offer this ideal setup.
That’s why we built Layer - a web app that works on top of any Google Sheets and instantly gives you the ability to control your spreadsheet access down to the cell level.
You select which cell ranges each person should have access to, and Layer seamlessly creates a carve-out that only includes that data.
But Layer is so much more than that. It offers you proper control over what others do in your spreadsheet; the ability to revert back to previous versions of your file keeps communications inside your spreadsheet and enables you to manage data collection and consolidation processes efficiently.
Keep reading and discover what Layer has in store for you!