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.
Snippets using this method
- Visicalc 2023 Design Walkthrough
- Visicalc 2023 Quick Walkthrough
- Simple Inventory Management Automations
- Twitter App Clone in a Google Sheet
- Sheet Stories / Video Notes + Clear 24 Hour Old Videos
- Scrape Google Maps Added Phone and Reviews
- Password Protecting Data In a Google Sheet Part 2 The Basics
- Google Maps Scraper for Outreach
- Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
- Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
- Create a PR Agency From Scratch
- Add Columns Automatically
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
Better Sheets tutorials
Add Columns Automatically
Create a PR Agency From Scratch
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
Google Maps Scraper for Outreach
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
Password Protecting Data In a Google Sheet
Password Protecting Data In a Google Sheet Part 2 The Basics
Scrape Google Maps
Scrape Google Maps Added Phone and Reviews
Simple Inventory Management Automations
Visicalc 2023 Design Walkthrough
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 →