AI for Google Sheets
Describe the work. Keep it in Google Sheets.
Griddy lives in the Google Sheets sidebar. Select the relevant cells, explain the spreadsheet result you need, and review formulas, cleanup, formatting, charts, pivots, and other edits in the sheet your team already uses.
The Google Workspace Marketplace listing is free to install with paid features available. Griddy needs edit access to the spreadsheet where the add-on runs.
Griddy in Google Sheets
Example workflow, not a product screenshot
Your prompt
“Clean this expense table, create a pivot table showing spend by category and owner, and add a filter for the current month.”
Expected result
Normalized source rows plus a new pivot output tied to the data people update—without moving the workflow into another app.
Concrete Sheets prompt
“In Summary!B2:B13, mirror Net Income from Monthly Sales!F2:F13 with formulas, format the results as currency with no decimals, and do not change the Monthly Sales sheet.”
This prompt is explicit about the source, destination, formula requirement, number format, and protected sheet. That makes the intended final state testable.
Expected output
- Cross-sheet formulas in the requested Summary range rather than pasted values.
- Currency formatting applied only to the target cells.
- Existing month labels and the source worksheet left intact.
- An editable result that continues to reflect source-cell changes.
Google Sheets formulas, chart objects, pivots, and formatting remain native spreadsheet elements. Confirm the resulting references and ranges before sharing the file.
Workflow
From request to workbook.
- 01
Open the sidebar
Install Griddy from Google Workspace Marketplace. In a spreadsheet, choose Extensions → Griddy → Open Griddy, then sign in.
- 02
Select the relevant cells
Give Griddy concrete context by selecting the source range or naming the sheet and cells in the prompt. State any rows, columns, or tabs it must preserve.
- 03
Ask for the final state
Describe the outcome—such as formulas in a target column, a chart at a location, a cleaned table, or a pivot grouped by named fields—not just the menu command.
- 04
Inspect the sheet
Review the changes directly in Google Sheets. If a result is not right, undo it and refine the scope, business rule, or output location.
Google Sheets tasks
Use natural language for native spreadsheet work.
Griddy is most useful when the request ends in an inspectable sheet: formulas, cleaned rows, a chart, a pivot, or a clearly formatted review view.
Formula-driven summaries
Create formulas across a range, connect tabs, apply number formats, and preserve source cells so the output stays tied to the data.
Learn more 02Charts that use your ranges
Create or update common Google Sheets chart types, name the title and position, and keep the visualization linked to its source range.
Learn more 03Pivot tables from named fields
Ask for a pivot with explicit rows, columns, values, aggregation, filters, and destination instead of configuring each field manually.
Learn moreReview before you rely
Specific prompts make safer spreadsheet edits.
The add-on can change the sheet, so scope matters. A good request says what to edit, what to preserve, and how you will recognize a correct result.
- Use one clear header row and consistent data types before asking for formulas, pivots, or charts.
- Name protected sheets or ranges when the task should not rewrite source data.
- Check formulas, filters, aggregations, and chart series after the edit completes.
- Undo and re-prompt if the result is broader than intended; do not layer more instructions onto a wrong base.
Keep going
Related spreadsheet resources
FAQ
Before you start.
How do I use Griddy in Google Sheets?
Install the add-on from Google Workspace Marketplace, then open a spreadsheet and choose Extensions → Griddy → Open Griddy. Sign in, select relevant cells, type the request, and inspect the resulting sheet changes.
Can Griddy edit my Google Sheet directly?
Yes. The add-on can apply supported spreadsheet operations such as formulas, data cleanup, formatting, sorting and filtering, charts, and pivot tables. It requests permission to view and manage the spreadsheet where it is installed.
What makes a good Google Sheets AI prompt?
Name the sheet or range, describe the business rule, specify the destination and formatting, and state what must remain unchanged. Prompts with a testable final state are easier to review than broad requests to analyze the whole file.
Should I still check the result?
Yes. Review formulas, data transformations, chart ranges, pivot aggregations, and any assumptions before sharing or using the result. AI-generated spreadsheet work can misinterpret ambiguous labels or incomplete source data.
Keep the workflow in your sheet.
Install Griddy for Google Sheets and start with one bounded request you can verify.