Tutorial on creating a Google Spreadsheet Sidebar with Materialize CSS framework, jQuery JavaScript framework, and Google Apps Script.
Andrew Roberts has shared a tutorial and boilerplate for using the Materialize CSS framework in the Google Sheets sidebar. Materialize is based on Material Design and the framework is lightweight and easy to use. This framework will also work for other G Suite editor sidebars (Docs, Sheets, Forms, Slides). If you plan to use Materialize in your Editor Add-on Google ask that the design adheres to the UI style guide.
This is an overview of the various techniques and best practices I have evolved in developing Google Apps Scripts over the years. Of course Google have got a few suggestions of their own, and there are plenty of more general …
This includes some good design pattern considerations for Apps Script projects as well as links to testing libraries, boilerplate frameworks, and extensions that help manage Apps Script work.
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
