Shows a dialog that asks the user for text input.
class SpreadsheetApp method .prompt()
SpreadsheetApp is the Apps Script service.
.prompt() is the method name you will see after a dot in your code.
What it does
Why it's used
- Ask for a sheet name, email, or ID before the script continues.
- Lightweight input without building a full HTML dialog.
Common errors
- Forgetting parentheses on prompt. Write SpreadsheetApp.prompt(), not SpreadsheetApp.prompt or prompt by itself.
- Skipping dots between chained calls. Each step needs a dot, like SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data').prompt().
- Adding spaces where they do not belong. Write SpreadsheetApp.prompt(), not SpreadsheetApp .prompt(), SpreadsheetApp.prompt (), or SpreadsheetApp . prompt().
- Wrong capitalization. Use SpreadsheetApp and prompt, not spreadsheetapp or prompt.
1 Snippets using this method
Explore
Related methods
-
.alert()
Shows a simple alert box with an OK button.
-
.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.
-
.toast()
Shows a short message in the bottom corner of the spreadsheet.
-
.activate()
Makes a sheet or range the active selection.
More Apps Script
1 Better Sheets tutorials
Add Columns Automatically
Related blog posts
Written guides about SpreadsheetApp.prompt().
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 →Google Sheets AI Formula
Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at times. Depends on your use of AI. I just updated Better Sheets' AI apps script to use Open AI Omni. Get the full script here. Can I use ChatGPT in Google Sheets? No but you can create ChatGPT in Google Sheets. Let me show you! But I need help with Google...
Read post →Explore Coding in Google Sheets
Did you know you can actually code in Google Sheets?
Read post →