This template provides a framework for creating a Google Sheets add-on. It shows the structure needed to define a UI (including menus, a sidebar and dialog) and how to coordinate communication between the UI client and the server where the Sheet resides. This template also covers some basic uses of Apps Script with Google Sheets, including:

• Reading and writing data to a Sheet
• Creating, copying and clearing a sheet

Note that add-ons that work with Google Sheets will usually need to read and manipulate the Sheet data, formatting, validation, etc. For more information, see Extending Google Sheets.

In addition, developers of Sheets add-ons should be aware of the Known Issues specific to Google Sheets.

Finally, note that this template must be added to a container-bound script attached to a Google Sheet in order to function. Developed add-ons must go through a publishing process before they can be made available publicly.