In this post, I will tell you how to create a sidebar in Google Sheets with Google Apps Script.

The sidebar is an operation panel displayed on the right side of the screen that can be used for G Suite applications.
In other words, it is a kind of user interface.
official documentation of sidebar

The sidebar can be created for the following applications:

  • Spreadsheet
  • document
  • slide
  • Form

Create a SideBar in Google Sheets

  • Open Google sheets
  • In the sheet menu click on tools > script editor
  • There is one file already
  • we have to create one more file Sidebar.html
Create a SideBar in Google Sheets with Google Apps Script

Creating the Html file and code editor will look like this

Create a SideBar in Google Sheets with Google Apps Script

Google Apps Script

Write Below code in

					function onOpen() {
  .addItem('createSidebar', 'createSidebar')
function showSidebar() {
  var htmlOutput = HtmlService.createHtmlOutputFromFile('Sidebar');

write below code in Sidebar.htm

					<div class="block form-group">
  <label for="text"><b>Name</b></label>
  <input type="text" name="Name" id="Name">
<div class="block">
  <button class="create">Create</button>
  <button onclick="">close</button>
Airtable Consulting, Automate ScriptAirtable Consulting, Automate Script

Hello! I am Haroon Khan

Google apps script developer. I have 6+ years of Experience with Professional Google Apps Script development.

Other Posts