Builds a custom menu in the spreadsheet toolbar.
class SpreadsheetApp method .createMenu()
SpreadsheetApp is the Apps Script service.
.createMenu() is the method name you will see after a dot in your code.
What it does
Why it's used
- Add a custom menu so users run your scripts from the toolbar.
- Package several functions behind one menu.
Common errors
- Forgetting parentheses on createMenu. Write SpreadsheetApp.createMenu(), not SpreadsheetApp.createMenu or createMenu by itself.
- Skipping dots between chained calls. Each step needs a dot, like SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data').createMenu().
- Adding spaces where they do not belong. Write SpreadsheetApp.createMenu(), not SpreadsheetApp .createMenu(), SpreadsheetApp.createMenu (), or SpreadsheetApp . createMenu().
- Wrong capitalization. Use SpreadsheetApp and createMenu, not spreadsheetapp or createmenu.
Snippets using this method
- Uncheck Every Checkbox in Google Sheets
- Visicalc 2023 Design Walkthrough
- Visicalc 2023 Quick Walkthrough
- Tweet From a Sheet
- SubSpyHub Subreddit Scanner
- Simple Inventory Management Automations
- Self Destructing Google Sheet
- Shaman: AI Blog Writer
- Twitter App Clone in a Google Sheet
- Sheet Stories / Video Notes + Clear 24 Hour Old Videos
- Scrape Google Maps Added Phone and Reviews
- Saving OpenAI API Calls inside of Google Sheets
- I Created an Automatic Emailer
- Make a Tour of Your Sheet
- Introducing SheetFools
- Password Protecting Data In a Google Sheet Part 2 The Basics
- How to Move Tab To End Easily with Apps Script
- How to Insert Multiple Rows in Google Sheets (Easy to Hard)
- How to Merge Cells in Google Sheets
- How to Power Testimonials with Google Forms and Sheets
- Google Maps Scraper for Outreach
- How To Download All Tabs as CSV in a Zip File
- Form Automations: Close Multiple Forms When Over Limit
- How To Change Date Format Automatically
Explore
Related methods
-
.addToUi()
Publishes a custom menu to the spreadsheet UI.
-
.addItem()
Adds a menu item that runs a function when clicked.
-
.showSidebar()
Opens a custom sidebar built with HtmlService.
-
.addSeparator()
Adds a divider line between menu items.
-
.getUi()
Returns the UI object used to build menus and show dialogs in Sheets.
More Apps Script
Better Sheets tutorials
Access Free API's with Google Sheets
Activate A Certain Sheet When Opening a Spreadsheet
Add Columns Automatically
Add Tasks to Google Tasks From Google Sheets
Americano Tournament Template With Four Automations
Automate Emails
Automate Move Blank Rows
Automatically Align Top
Automatically Clear Content | Refresh Reuse Recycle Templates
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas
Big Year - a Whole Year in One Google Sheets Tab
Breaking Through Errors In Apps Script
Build Your Own AI Writer in Google Sheets
Built a Cookie Clicker Clone in Google Sheets
ChatGPT Clone in Google Sheets Part 1
ChatGPT Clone in Google Sheets Part 2
Count Merged Rows
Create an Automated Task List
Create a PR Agency From Scratch
Curate Google Sheets Easily - Automatic Bookmarklet Maker
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
Every Google Drive File Created in Last 24 Hours
Explore Readable Hex Codes
Fast FAQS
Form Automations: Close Multiple Forms When Over Limit
Google Maps Scraper for Outreach
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
How To Change Date Format Automatically
How to Create a Google Form Automatically
How to Create AI Images From Google Sheets
How To Download All Tabs as CSV in a Zip File
How To Duplicate a Tab and Move it to the End in Google Sheets
How to Insert Multiple Rows in Google Sheets (Easy to Hard)
How to Merge Cells in Google Sheets
How to Move Tab To End Easily with Apps Script
I Created an Automatic Emailer
Introducing SheetFools
Make a Tour of Your Sheet
Password Protecting Data In a Google Sheet
Password Protecting Data In a Google Sheet Part 2 The Basics
Saving OpenAI API Calls inside of Google Sheets
Scrape Google Maps
Scrape Google Maps Added Phone and Reviews
Self Destructing Google Sheet
Shaman: AI Blog Writer
Simple Inventory Management Automations
SubSpyHub Subreddit Scanner
Tweet From a Sheet
Uncheck Every Checkbox in Google Sheets
Visicalc 2023 Design Walkthrough
Related blog posts
Written guides about SpreadsheetApp.createMenu().
How to Use Google Sheets as a Website Database
Did you know you can use Google Apps Script to turn a Google Sheet into a free, auto-syncing database for your website? This guide shows you exactly how to set it up. You’ll prepare your spreadsheet, write a few lines of code and publish your site. Don’t worry if you’re not a developer, we’ll walk you through it. Why Use Google Sheets as a Database? For small projects, Google Sheets offers many advantages over traditional databases: * Free hosting and storage * Easy to edit data without...
Read post →What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Build A Business: PR Agency in a Google Sheet
Unlock the power of Google Sheets. Start a PR agency! Discover how to curate web content, track stats, code email service, and sell sheet access for profit.
Read post →