Ever wondered how to share your google sheet with multiple emails as both editors and viewers?
Neo-share comes along with the solution.
It is a google addon that allow sheet owners to share the sheet with emails in a particular range.
To user the addon
- Make a copy this template document HERE .
- Install the Neo-share addon in your sheet by going to addon then search Neo-share.
- Enable the addon.
- Type your email numbers as indicated in the template.
NB. Never change the sheet name “SHARE” in the document. This will render the addon non functional.
Good to go?
Now type your emails in their respective areas. Names are optional.
- To share with editors go to addon >> SHARE >> EDITORS >> ADD
- To remove editors go to addon >> SHARE >> EDITORS >> REMOVE
- To share with viewers go to addon >> SHARE >> VIEWERS>> ADD
- To remove viewers go to addon >> SHARE >> VIEWERS>> REMOVE
Thank you for your patience, You were a good student, now a teacher, Enjoy the service.