Step 1: Install the add-on
Install PromptCell in Google Sheets. After installation, open a spreadsheet and look for Extensions > PromptCell > Configure & Sign In.
Setup
Get PromptCell running in under five minutes.
Setup should be simple: install the add-on, sign in once from the sidebar, and run a first formula that proves the product is useful on real sheet data.
1install from the Marketplace
2sign in once inside the sidebar
3run a first formula in a live sheet
Setup steps
Use this order to avoid confusion.
Step 2: Sign in once in the sidebar
Use Google sign-in from the PromptCell sidebar. The same account can then be reused in future sheets.
Step 3: Start with one useful formula
Pick a real task like summarizing a row, cleaning imported data, or matching a customer tier from another sheet.
Step 4: Expand when needed
Move from one-cell answers to range rewrites, new tables, and cross-sheet lookup once the first use case is proven.
Run these first
These examples lead with jobs-to-be-done instead of formula jargon.
Summarize a row
Start with a single output cell.
=ASK("Summarize this customer row in one sentence", A2:F2)Clean a messy range
Keep the same row and column shape while rewriting the contents.
=ASKR("Trim spaces and standardize state abbreviations", A2:D10)Build a fresh table
Return a filtered or extracted table with new headers.
=ASKT("Return only overdue invoices with customer, owner, and amount", A2:H200)Look up across sheets
Match one value against another sheet and return the aligned result.
=ASKX("Return the matching tier", A2, Customers!A:A, Customers!C:C)Provider controls when you need them
Most teams should start with the default PromptCell provider and only force a model when they have a specific reason.
Default behavior
ASK, ASKR, ASKT, and ASKX use the saved default provider. Use GEM* to force Gemini or CLD* to force Claude.