Shows a short message in the bottom corner of the spreadsheet.
class SpreadsheetApp method .toast()
SpreadsheetApp is the Apps Script service.
.toast() is the method name you will see after a dot in your code.
What it does
Why it's used
- Give quick feedback without blocking the user with a popup.
- A saved-rows or sync-complete message that fades on its own.
Common errors
- Forgetting parentheses on toast. Write SpreadsheetApp.toast(), not SpreadsheetApp.toast or toast by itself.
- Skipping dots between chained calls. Each step needs a dot, like SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data').toast().
- Adding spaces where they do not belong. Write SpreadsheetApp.toast(), not SpreadsheetApp .toast(), SpreadsheetApp.toast (), or SpreadsheetApp . toast().
- Wrong capitalization. Use SpreadsheetApp and toast, not spreadsheetapp or toast.
Snippets using this method
- Visicalc 2023 Design Walkthrough
- Visicalc 2023 Quick Walkthrough
- SubSpyHub Subreddit Scanner
- Sync Tabs in Different Sections
- Sync Many Tabs without ImportRange()
- Sync Two Tabs Without ImportRange()
- Introducing SheetFools
- Creating a Live Message in Google Sheets
- Can I get alerted when a tab name is changed?
- Count Merged Rows
- Advanced Coding in Google Sheets for Programmers
Explore
Related methods
-
.alert()
Shows a simple alert box with an OK button.
-
.prompt()
Shows a dialog that asks the user for text input.
-
.showModelessDialog()
Opens a dialog the user can use while still working in the sheet.
-
.showModalDialog()
Opens a modal dialog that blocks interaction with the sheet.
-
.addToUi()
Publishes a custom menu to the spreadsheet UI.
More Apps Script
Better Sheets tutorials
Advanced Coding in Google Sheets for Programmers
Can I get alerted when a tab name is changed?
Count Merged Rows
Creating a Live Message in Google Sheets
Introducing SheetFools
SubSpyHub Subreddit Scanner
Sync Tabs in Different Sections
Sync Two Tabs Without ImportRange()
Visicalc 2023 Design Walkthrough
Related blog posts
Written guides about SpreadsheetApp.toast().
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 →What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users
Make your data tasks simpler & efficient. Discover the power of automation in Google Sheets with a comprehensive guide that covers everything from triggers to scripts.
Read post →