Google Sheets prompts
Google Sheets questions are easier to solve when you describe the columns and paste a few sample rows. These prompts help you write and explain formulas, clean data, build QUERY and lookup formulas, create summaries and charts, design trackers and budgets, and audit a sheet for errors. Paste an anonymised sample into an AI assistant, say what result you want, and ask for the formula with an explanation. The prompts do not open your sheet, so test on a copy, check locale settings and keep sensitive data private.
Prompts
-
Macro Safety and Maintainability Audit
Review recorded macros before sharing a workbook.
-
Spreadsheet Automation Script Audit
Review cloud spreadsheet scripts for reliability and permissions.
-
Linked Workbook and External Data Connection Audit
Find fragile links between files.
-
Workbook Performance and File Size Audit
Find what makes a spreadsheet slow.
-
Shared Spreadsheet Access and Version Control Audit
Check who can change what, and how versions are tracked.
-
Scheduled Refresh and Linked Data Reliability Review
Check connections and refresh behaviour.
-
Spreadsheet to Application Migration Readiness
Decide when a sheet should become a proper tool.
-
Sales Dashboard Audit
Check definitions, filters and chart choices.
-
Monthly Management Report Audit
Check that a report supports decisions.
-
Chart Honesty Audit for a Report
Check axes, scales and emphasis.
-
KPI Definition Audit
Check that each metric is defined, owned and comparable.
-
Pivot Table Report Audit
Check source ranges, grouping and refresh habits.
-
Dashboard Metric Definition and Source Audit
Audit dashboard metric definitions and sources, so every number can be traced, explained and trusted by the reader.
-
Monthly Report Refresh Process Audit
Check how the report is updated and who checks it.
-
KPI Target and Variance Calculation Review
Check targets, actuals and variance logic.
-
Pivot Table and Summary Sheet Integrity Check
Check summaries against raw data.
-
Data Cleaning Audit
Run a data cleaning audit on a dataset: profile it, spot problems and list cleaning rules to apply and verify.
-
Duplicate and Entity Matching Review
Plan how to detect and merge near-duplicate records.
-
Survey and Form Response Data Validation
Validate survey and form response data: check for bad responses, duplicates, straight-lining and bias before analysis.
-
Data Dictionary and Governance Check
Create documentation and ownership for a dataset.
-
Master Data and Reference Table Governance
Keep lookup tables correct and consistent.
-
Unit and Currency Consistency Audit
Prevent mixing units, currencies, and scales.
-
Sampling Method for Auditing Large Datasets
Check quality without checking every row.
-
Customer List Duplicate and Format Audit
Find duplicates, inconsistent formats and unusable records.
-
Survey Export Data Quality Audit
Check responses for bad data before analysis.
-
Inventory Sheet Accuracy Audit
Compare counts, records and movements for a small shop.
-
Time Tracking Sheet Audit
Check hours, rounding and totals before billing or payroll use.
-
Data Validation and Input Control Audit
Check that entry cells reject bad values.
-
Merged Data from Multiple Sources Reconciliation Audit
Check that combined files match their sources.
-
Spreadsheet Documentation and Handover Audit
Check whether someone else could safely use the file.
-
Missing Data Strategy Review
Decide how to handle blanks responsibly.
-
Outlier and Anomaly Investigation Guide
Separate errors from real extremes.
-
Date, Address and Name Standardization Plan
Normalize messy text fields.
-
Reconciliation Between Two Data Sources
Compare systems and explain differences.
-
Data Entry Template and Validation Design
Prevent bad data at the point of entry.
-
Data Freshness and Pipeline Reliability Check
Assess whether reports use current data.
-
Privacy Review of a Spreadsheet or Dataset
Find personal data before sharing.
-
Workbook Structure and Tab Layout Audit for Clarity
Review how a workbook's tabs, order and naming are organised and propose a clearer structure so another person can follow it without help.
-
Spreadsheet Formula Consistency Audit From Sample Rows
Spot inconsistent, hard-coded or broken formulas in a column by comparing sample cells, and get a fix plan that is safe to test on a copy.
-
Spreadsheet Handover Documentation and README Audit
Check whether a spreadsheet has enough explanation for a successor to use it safely, then produce a README tab with sources, steps and cautions.
-
Data Entry Validation and Input Cell Audit
Audit a spreadsheet's input columns for validation gaps, free-text chaos and error-prone entry, and design simple rules to prevent bad data.
-
Spreadsheet File Naming and Version Control Audit
Review a shared folder of spreadsheet versions to find confusing names and unclear latest files, then set a naming rule and cleanup plan.
-
Shared Spreadsheet Access and Edit Risk Audit
Check who can view and edit a shared spreadsheet, spot over-broad access and fragile editing habits, and propose safer settings. Defensive only.
-
Hard-Coded Numbers and Hidden Assumptions Audit
Find numbers typed into formulas and undocumented assumptions in a model, and move them into labelled input cells with a change log.
-
Pivot Table Source Data and Refresh Check
Audit the source range, refresh habits and field setup of a pivot table to catch stale or incomplete numbers before sharing a report.
-
Report Sheet Readability and Print Layout Audit
Review a spreadsheet report page for readability, number formatting, labels and print settings, and get a prioritised polish list for readers.
-
Date and Number Format Consistency Audit for a Dataset
Detect mixed date formats, text-numbers and inconsistent units in a pasted dataset sample, and write a safe standardising plan.
-
Financial Model Sanity Check
Test a model's logic, assumptions, and outputs.
Frequently asked questions
Can AI write Google Sheets formulas?
Yes. Describe your columns, paste sample rows and say what result you want. Then test on a copy of the sheet.
Do Excel formulas work in Google Sheets?
Many do, but not all, and names or syntax can differ. Tell the AI which application you use.